Re: double-entry bookkeeping unneeded?




Thomas Gagne wrote:
I've written multiple financial OLTP systems and can confidently say
there's no such thing as "john bill 5".

A transaction system must be able to record:

Check for $10.
Cash for $20.
Deposit to checking $15.
Payment to line-of-credit: $15.

These are 4 *separate* transactions, aren't they? It is still:

A, B, 10.00
C, D, 20.00
E, F, 15.00
G, H, 15.00

Where the letters are the various account categories/codes (unspecified
here). It is still a form of "john bill 5". Every individual
accounting transaction has to debit and credit 2 accounts. Traditional
accounting would do the above like this:

A, 10.00
B, -10.00
C, 20.00
D, -20.00
E, 15.00
F, -15.00
G, 15.00
H, -15.00

Which is bad normalization. As far as a larger grouping of multiple
transactions, that is not the issue here that I can see. As far as
"splitting" a check, first it is deposited, and then divied up in
further/later transactions.


or perhaps

Check for $100.
Interest payment: $98.
Principle payment: $2.

These are all examples of double-entry/balanced transactions.
Double-entry is a misnomer. It's not so much as recording the same
information twice as much as it is creating smaller transactions and
building bigger transactions out of them.

--
Visit <http://blogs.instreamfinancial.com/anything.php>
to read my rants on technology and the finance industry.

.



Relevant Pages

  • Re: Carry forward balance of account
    ... The transaction date column would allow you to determine the appropriate year, and so the transactions for different years would all be in the same file. ... Standard accounting procedures do involve closing a period, ... In this system, there is a closing balance for each period, which becomes the opening balance for the new period. ... What you are doing by creating a new database file and manually entering the opening balance is therefore part way towards the accounting model rather than the basic normalized database. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Balance sheet for a dormant company
    ... transactions' during the accounting period. ... Companies House do not count as significant accounting transactions ... company on the register. ... I cannot say shares were sold ...
    (uk.finance)
  • Re: Balance sheet for a dormant company
    ... transactions' during the accounting period. ... Companies House do not count as significant accounting transactions ... various other documents including annual company balance sheets to ... I cannot say shares were sold at ...
    (uk.finance)
  • Re: Balance sheet for a dormant company
    ... transactions' during the accounting period. ... Companies House do not count as significant accounting transactions ... company on the register. ... I cannot say shares were sold ...
    (uk.finance)
  • Re: Balance sheet for a dormant company
    ... transactions' during the accounting period. ... Companies House do not count as significant accounting transactions ... company on the register. ... I cannot say shares were sold ...
    (uk.finance)

Quantcast