Reports

Good day, Elena StClair.

I'd be happy to share a report with the information you need.

You can either run the Transaction List by Customer or Invoices and Received Payments report. Then, customize the column to add the Open Balance.

Here's how:

1. On the left panel, click Reports.
2. Type Transaction List by Customer or Invoices and Received Payments in the search field.
3. Select the Report period, and the Customize button.
4. In the Rows/Columns section, put a check mark on the Open Balance box.
5. Click Run report.

Here's a sample screenshot of what the report looks like:

To learn more about the other customer reports and how to customize them, you can check out these articles:

• Reports included in your QuickBooks Online subscription
• Customize reports in QuickBooks Online

Please let me know if you need something else. I'll be right here to help you out some more. Have a good day ahead.

Thank you.  This is really helpful to see how to customize the reports.  The only problem I am still having is the total amount at the bottom add all the transactions together.  Payments and invoices.  I would like the total to subtract the invoices from the payments so I can send my customer a total of what is left in their account.  Maybe this is a problem with how I am inputting the payments.  

Thanks 

Hey newcomer, @Elena StClair. 

Thanks for reaching back out to the Community. I can give you some information about this report. 

Based on the details you'd like, the report isn't going to be able to give you the information the way to want it. However, it has the total amount column and then another open balance column. 

I'll send feedback to our Product Developers so they can consider this in one of the upcoming releases. You can also check out our Blog site to keep up with what's new in the product. 

If there's anything else I can help you with, just let me know. I'm only a post away if you need me. Have a fantastic day! 

Hi @Elena StClair  ,

Kritesh here from Better Reports!

We recently launched our app Better Reports in QuickBooks, which can help create this report that shows all the transactions by a customer/account. So a lump sump payment and then each expense individually. Finally, you can also see the balance at the end. We can include the exact dates as well so it is clear. You can even schedule this report to run automatically at a daily/weekly cadence.

Better Reports also has several other built-in reports, along with the ability to create your own. You can also schedule these to run at a regular cadence and sent to your email or Google Sheets directly so your workflow is automated.

We offer a 14 day free trial, so you can see it all in action.

Also, as part of our offering, we'll be happy to create these custom reports for you as well.

Once you install Better Reports, please contact us and we'll be happy to set this up for you!

thank you, but I don't see where there is an open balance column.  Is this something I have to add in the customization?

Yes, you can add the Open Balance column in the report customization with QuickBooks Online (QBO), @Elena StClair. I'm here to show you how.

When you customize your reports in QBO, you'll get to focus on the details that matter the most to you. There are some reports (i.e., Customer Balance Detail) that display the Open Balance column even without customization.

However, with the Transaction List by Customer and Invoices and Received Payments reports (suggested by my colleague above), you'll have to do the customization process to display the Open Balance column. Here's how:

1. Go to the Reports menu.
2. Type in and then choose either Transaction List by Customer or Invoices and Received Payments in the search field.
3. Click the Customize button.
4. Select the Report period.
5. In the Rows/Columns section, click the Change columns link and put a checkmark on the Open Balance box.
6. Click Run report. 

To learn more about report customization in QBO, you can check out this article: Customize reports in QuickBooks Online.

Also, reports give you snapshots of the different areas of your business. To know all reports that are available for your version of QBO, you can refer to this article: Reports included in your QuickBooks Online subscription.

Let me know in the comments if you have other concerns about customizing reports in QBO. Please don't hesitate to drop a comment below, and I'll gladly help. Take care and stay safe always, @Elena StClair.