I’m again reviewing my finances from last year, 2007, and I’m trying to figure out the best way to manage customer payments and bank deposits.
Here’s some of my thoughts:
* When I issue an invoice, the amount is match to the revenue source and the customer’s account (a sub-accounts receivable). I used to group all invoices into a single A/R account.
* When they pay, I match the deposit to the bank the funds are being deposited in with the customer’s account (which used to be the single A/R).
That works in concept, but its fairly complicated to code up, because in most real world scenarios, multiple checks come in, are combined into a single deposit, and some customers pay multiple invoices with a single check. In cases like that, the HTML form to support it becomes overly complicated.
There are also some special situations:
* There are times when payments are made from customers without a corresponding invoice.
* There are times when deposits are made from parties other than customers (like a transfer).
What to do?
Latest Comments
RSS