Stack Overflow
Stack Overflow

Questions tagged [accounting]

Systematic recording, reporting, and analysis of financial transactions of a business.

323 questions
3
votes
2 answers

Open-source PHP Accounting/General Ledger Implementation

I'm looking for any open-source accounting module that I can include in my Symfony project. I was thinking of writing my own & releasing a plugin, but then I came across 2 solutions: http://arias.sourceforge.net/ http://frontaccounting.net/ Please…
Prasad
  • 1,774
  • 3
  • 22
  • 39
3
votes
2 answers

is there a general accounting system database schema which i can use?

i require a generic accounting system database schema is there any sites which provide this ?
sodhancha
  • 437
  • 15
  • 31
3
votes
1 answer

how to calculate balances in an accounting software using postgres window function

I'ved got a problem same as this but I am using Postgres. Calculate balance with mysql have a table which contains the following data: ID In Out 1 100.00 0.00 2 10.00 0.00 3 0.00 70.00 4 5.00 …
Axil
  • 2,835
  • 5
  • 43
  • 97
3
votes
2 answers

Multi-Country Accounting System Default currency

We are developing an enterprise-size accounting system and we have logical design problem which we couldn't solve so far. according to the GAAP standards all the financial transactions have to be stored in one currency only in the database which is…
Jawad Al Shaikh
  • 2,067
  • 1
  • 23
  • 36
3
votes
2 answers

Accounting database schema

It has been asked many times before... and no answers with schema. Could someone share Accounting database schema please? I've read many related articles regarding double-entry accounting and relational database in accounting.. But there is no…
Jeffrey Rasmussen
  • 339
  • 2
  • 8
  • 20
3
votes
0 answers

Accounting database schema

I'm looking for existing andp properly designed accounting database schema rather than develop it from scratch. I know that there are single-entry and double-entry accounting and I prefer to use double-entry one. Can someone point me in the right…
Mark White
  • 47
  • 5
3
votes
2 answers

Double-Entry Accrual Accounting Concept

I have an accounting question regarding property management. Step 1: Residential Owner: Peter I charge Peter $200 for month management fee. So: Type Name Debit Account Credit Account Amount ------ ----- ------------------ …
VAAA
  • 12,647
  • 20
  • 110
  • 213
3
votes
1 answer

Accounting transaction table design

I have the following accounting tables: http://sqlfiddle.com/#!3/b93f3/2 My transaction details table has the following fields: [transdetailid] [int] IDENTITY(1,1) NOT NULL, [transid] [int] NOT NULL, [debitaccount] [varchar](10) NOT NULL, …
VAAA
  • 12,647
  • 20
  • 110
  • 213
3
votes
3 answers

SQL: Creating aging buckets based on last payment date for financial reporting

I need to create an aging report of credit balances on the customer-level. Notes: Aging is based on customer's last payment date. A customer can have multiple accounts, and there are sometimes errors in which a payment is applied to the wrong…
texas_mike81
  • 61
  • 1
  • 2
  • 11
2
votes
3 answers

MySQL table designing for an Accounting system

I am designing an online accounting system as a college project. I have got the following simple transactions. Sales on cash $300 Cash burrowed from Smith $250 Electricity bill paid $50 I have referred Double Entry Accounting in a Relational…
Rav
  • 1,023
  • 4
  • 16
  • 18
2
votes
5 answers

Rails: Accounting logic...Create multiple records at once

I'm actually trying to develop an accounting Rails application and I'm stuck with the logic... In fact, I want to simplify the life of the users trying to automate the "dirty" debit / credit stuff. Let say that I have these fields in my form: Date…
Dannoel
  • 161
  • 1
  • 12
2
votes
2 answers

General Ledger Account Code Format

I have added a general ledger account table to my database to store account codes and their descriptions. I have asked three potential clients, two use a 4 digit numeric code the other a 3 digit numeric code. I have been unsuccessful in finding any…
Reafidy
  • 7,918
  • 4
  • 42
  • 74
2
votes
1 answer

How to record transactions for money flowing into an acounting system?

I've been reading about accounting patterns described by Martin Fowler in his book "Analysis Patterns - Reusable Object Models". I understood the basic concepts: account, entry, transaction, etc; but I am not quite clear when it comes to the money…
Tong Wang
  • 1,572
  • 4
  • 28
  • 36
2
votes
2 answers

Double Entry Accounting pagination issue

There is a really serious issue about Double Entry Accounting systems with pagination, I think it is common but I still didn't find any solution for my problem yet. You can use this link to read about the simple Double Entry Accounting systems just…
tinyCoder
  • 469
  • 9
  • 29
2
votes
1 answer

Account Balance verification with Java and Hibernate HQL

I have following properties in my current Account Balance object: long id; // Database ID Date date; // date when this balance object was created boolean currentBalanceFlag; // indicates this is the most recent…
MatBanik
  • 24,206
  • 38
  • 107
  • 172
1 2 3
…
21 22