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.

Looking For More?


Silicon Valley Accounting Solutions produces the Solution of the Week in order to share tips and shortcuts that promote process efficiency and highlight software features that may not be in your current toolbox. Please let us know if you have questions on how to accomplish a particular task or if you simply have a comment to share.

Even if you find that you know most of what you see here, it only takes one “Aha” to make regular visits worthwhile. To avoid missing any solutions, you may subscribe and have a new one delivered to your inbox each week.

Contact Us

We want to help you grow
your business, call us
at: (408) 260-5250 or
find out more here.


When you need:
  • Clear processes for cash controls
  • Analysis of results
  • Customized reporting


When you need:
  • Timely and accurate bookkeeping
  • Reconciliations and monthly closes
  • Familiarity with popular accounting software
Web Analytics