Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
Abcorealty
Level 1

I made a report with transaction list by customer, but it doesn't give me the balance of those invoice and payments. How can I get the balance for each customer and balance at the end of report to match with my bank

 
1 Comment 1
Carneil_C
QuickBooks Team

I made a report with transaction list by customer, but it doesn't give me the balance of those invoice and payments. How can I get the balance for each customer and balance at the end of report to match with my bank

I've got your back, @Abcorealty.

 

I'll ensure you'll be able to pull up a report that gives you invoice and payment balances that make up each customer in QuickBooks Desktop

 

You can pull up a Customer Balance Detail report. You'll just have to modify it to see the data you need. I'll show you how:

 

  1. Go to Reports at the top menu and select Customers & Receivables.
  2. Choose Customer Balance Detail.
  3.  Click the Customize Report button.
  4. Go to the Display tab and customize the Report Date Range.
  5. You can also utilize the Filter tab and personalize the data according to your needs.

 

I've added this resource to learn how to draw information clearly and save the same report settings for future use: Customize reports in QuickBooks Desktop.

 

If you want the same settings of the customized report to be available for future use, feel free to check out this article: Create, access, and modify memorized reports.

 

Let me know how else I can help you with pulling up reports in QBDT by adding a comment below. We're always here to guide and assist you whenever you need help.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us