There is no report that will show the date paid, but there are several ways to get everything else. One of my favourites is an obscure little trick as follows: Reports > Banking > Missing Checks. Change the Account from your bank to Accounts Receivable, OK. Change the Dates to something like "This fiscal year to date", make any other changes you wish, and memorize for future use.
Well, I can point you in the direction of a report to get all of that except date paid.
Go to "Customers and Receivables" in the Reports menu. Select "Transaction List by Customer" as the report. Modify the report to Transaction Type:Invoices and also to your specified date setting. This will bring up everything you wanted except date paid. You would have to do another report with bill payments for that, unless you wanted both reports mixed together, but that would probably be messy if your customers pay multiple invoices with each payment.
Hope this helps.
Love it! Thank you *very* much.
Another great method - I can tapdance with Excel to match the paid date, so that's no problem.
The first part is fine, but bill payments (to vendors) have absolutely nothing to do with invoice payments (from customers).
"Leo Navoichick" wrote ...
Yeah, meant to say a different report for "receive payments" and not for "bill payments." My bad.
Even so, I don't think there is a report that will give you the date of payment of invoices, because:
- An invoice may be paid by multiple separate payments and/or by applying one or more credit notes.
- "Applying" a payment or credit is a separate function from receiving a payment or issuing a credit, thus an invoice may be "paid" on a date different from the "receipt of payment" (and/or issue of a credit).
- A payment may be applied to multiple invoices. In the case of a Customer with multiple Jobs, a payment may be recorded as received from the Customer and applied to multiple Jobs/Invoices (but the same is not true for a credit note).
So far as I know, the only way to see when an invoice was paid is to generate a Transaction History for the Invoice, and this can be done only for one Invoice at a time. Even so, this shows only the date a payment was received or a credit note issued, not when they were actually applied.
Our Customer Payment Analyzer has a report that shows the payment history on multiple incoices in one report. See screehshot 5 at
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.