Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
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.
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:
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!
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?
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:
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.
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
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:
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.
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.
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:
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.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here