Has anyone implemented any kind of a/r and a/p aging and payment
scheme for accrual accounting in ledger? You know the kind of thing:
Water (say) bill received on May 31st for water consumed in May. Bill
due for payment by June 30th. You'd have something like:
2010/05/31 * (-) May Bill from Water Inc
expenses:utllities:water $100
liabilities:accounts-payable
2010/06/30 * (-) Pay Water Inc May Bill
assets:bank -$100
liabilities:accounts-payable
However, there are at least three things missing (versus, say, a
QuickBooks implementation)
a. There's nothing about aging; i.e. nothing in that first entry about
payment terms (the fact that the bill is due within 30 days in this
case)
b. There's nothing tying that particular $100 payment on June 30th to
the water supplier. Now this could be fixed by using a/p subaccounts.
So instead of liabilities:accounts-payable" I'd use
"liabilities:accounts-payable:water-inc". But even if that was done:
c. There's nothing tying that specific payment to that specific bill
from the water supplier
I imagine this is beyond the scope of the core ledger engine, but I
wondered if anyone had looked at maybe using comment fields to add
these kind of a/p and a/r functions?
thanks,
Tommy