Connecting Invoices, Customer Payments, Deposits, and Bank Statement Transactions

PBooks has the foundation to support invoices, customer payments, and deposits, but I haven't yet devised an elegant way to tie them all together.

Here's some more thoughts on the matter:

  • When I create an invoice in PBooks, a journal entry is made with entries in the revenue accounts as well as the customer account.
  • When the customer makes a payment, I mark the invoice as paid. I'd like PBooks to automatically create a journal entry with entries in the customer account and a "funds to deposit" account, or the bank account the payment is placed into. PBooks does not do this yet, and when it does, I'd like it to be flexible as to whether the journal entry includes the "funds to deposit" account, or a bank account, and which bank account.
  • When a bank statement is imported into PBooks, I'd like PBooks to seamlessly connect the deposit entry with transaction in the bank statement. The issue here is that customer payments are often combined into a single bank transaction.

I'm quite confident that given the time, I'll be able to implement all this into PBooks.

By Albert on November 10, 2009 6:39 PM