QuickBooks: Accounts Receivable Customer Balance Detail Report
There are several accounts receivable reports that a business can run in QuickBooks. It’s important to know which report to run to get the specific information you need.
Running the standard QuickBooks A/R Aging Summary Report, A/R Aging Detail Report, Open Items Report or Collections Report will not give you details on payments or credit memos that relate to a particular invoice. With any of these reports you can click into any invoice directly from the report and get the details of any payments or credit memos that are associated with the invoice, however if you run a Customer Balance Detail Report you will be able to see all the details in a single report. Here is how to get to the report.
Go to Reports>Customers & Receivables>Customer Balance Detail. As you can see, payments and credit memos are displayed as well as the open invoices.
The A/R Aging Summary, A/R Aging Detail Report, Open Items Report and the Collections Report are still useful reports as they will provide aging information in different formats based on the particular report chosen. But the Customer Balance Detail report is very helpful when you need the history of a specific invoice.