PBooks™ Open Source Accounting

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?