Showing results for 
Search instead for 
Did you mean: 
NEW Connect to DBS IDEAL direct bank feeds Click here
Level 3

Report on customer transactions with open balances

Is there a way to use the Customer Transaction List report or another report to filter by all invoices, payments, credit notes, etc. with open balances, and hide ones that have zero balance?


Thank you.

7 Comments 7

Report on customer transactions with open balances

Yes, there’s a report that displays those details, Steven. And I’d be glad to share it with you.

You can run the Invoices and Received Payments report in QuickBooks Online. It shows all your invoices, payments, credit notes, open balances, etc. Then, you'll want to export it to Excel to hide or remove the zero-balance transactions.

Here are the steps to do it:


  1. Go to your Reports menu.
  2. Enter "Invoices and Received Payments" in the Search field.
  3. Filter the date period. You can also select the Customise button.
  4. Click the Small gear icon, then tap Show More.
  5. Select the Open Balance option and the other info you need.
  6. Hit the Export icon and choose Export to Excel.
  7. In the spreadsheet, eliminate the ones that have zero balance.

You can use this reference to learn more about personalizing, exporting, and sharing reports: Customise reports in QuickBooks Online. It walks you through also how to have a perfect set of filters and save them. This way, you can access the same report in the future.

Moreover, here’s an illuminating guide that contains ways to make reports easier to understand: Common custom reports in QuickBooks Online.

I want to ensure everything is taken care of for you. If you need further assistance with QuickBooks reports, don’t hesitate to reach back out. I’ll be here to help. Have a great rest of your day!

Level 3

Report on customer transactions with open balances

Thanks for the feedback. So there isn't a way of filtering it within Quickbooks - I can only export and then use something like Excel to remove the zero balance documents?


Report on customer transactions with open balances

Hello there, @Steven_ZA. Let me join the thread and provide additional information in running the report you need. 


In QuickBooks Online (QBO), you can run the Customer Balance Detail report. It shows how much each customer owes you. And this report will only display customers with balances. 


To pull this up, here's how:


  1. On your QBO account, select Reports in the left menu.
  2. Go to the Reports tab, then the Standard tab.
  3. Locate and select Customer Balance Detail.
  4. Set the Report period and Aging method.
  5. Click Run report.


For more information and guidance in running a report in QBO, I recommend checking these articles: 



If you need tips and related articles on your future tasks, I recommend watching our video tutorials to help manage your QBO account, income, expenses, and banking. 


Please let us know if you need anything else. The Community and I will be here to help you.

Level 1

Report on customer transactions with open balances

Hello admin, your solution displays a report with even negative balances but how can you get a report with only positive customer open balances. Thanks


QuickBooks Team

Report on customer transactions with open balances

Let me guide you in running a report to show your customer's open balance with positive amounts, @Muganga.


Please know that the negative balance in the Customer Balance Detail report is the default. As a workaround, we can run the Transaction List by Customer report.


Here's how:

  1. On the left panel, click Reports.
  2. Search for Transaction List by Customer report.
  3. Click the Filter icon, then modify it. I suggest looking at the screenshots below for better understanding.
  4. Click the Columns dropdown, then select Open Balance.

Here are the screenshots for your visual reference:


Please note that this method only applies to invoices. If you want to include transactions such as Payments and Credits, the negative amounts will also be included in your report. With this, I recommend exporting the report and manually removing the negative amounts.


Moreover, you can check out this article to help you customise your report: Customise reports in QuickBooks Online.


Let me know if you need further assistance customising your report. Keep safe.

Level 2

Report on customer transactions with open balances

So, what if I want to do a report to show open balances, sorted by product? I can customize to add an 'open balance' field to the Sales by Product/Service Detail report, but the open balance field is always $0 even when I know my customers have an outstanding balance. I'd also like to see any discounts applied on the invoice. I don't want to see a report that is only able to be sorted by customer to do this. I've tried figuring this out for years, but have not been able to do this. Please help.


QuickBooks Team

Report on customer transactions with open balances

Thanks for joining this thread, jmarewski.


I know this can be challenging in showing the Open balance in your reports. I recommend contacting our online support team for further investigation regarding this matter. Our support team has all the necessary tools to conduct a thorough check, and you can also schedule a callback or initiate a chat.

Here's how:

  1. Sign in to your QuickBooks Online company.
  2. Select Help (?).
  3. Select Contact Us and choose a way to connect with us:
  • Start a chat with a support expert.
  • Get a callback from the next available expert.


In addition, refer to this article to learn how to set a schedule and send it by email in QBO: Set schedule and email information for a memorised report.


Don't hesitate to update us anytime if you still have issues running your reports in QBO. I'm always here to help.