Skip to main content
June 4, 2020
Question

One of my suppliers has an open balance that is different to the balance when I run the summary report. The balance in the report matches the statement from my supplier.

  • June 4, 2020
  • 1 reply
  • 0 views
Original commenter did not share additional details

1 reply

June 4, 2020

I'm here to share details about how QuickBooks Online (QBO) generates the information it provides in the supplier reports, @info1073.

 

The supplier open balance that shows in their profile should match with the Supplier Balance Summary report. This is because the amount it displays is just based on the data of your supplier's transactions.

 

Let's make sure the Report period of the Supplier Balance Summary report is correct. This will ensure that the data you'll get is accurate and timely. Then your supplier's open balance from their profile will now match with the report and the statement from them. Here's how:

  1. Go to the Reports menu.
  2. Type in Supplier in the search box then select Supplier Balance Summary.
  3. Set the correct date in the Report period field.
  4. Click Run report.

 

Once done, go to your supplier's profile from the Expenses menu. Then, in the Transaction List tab, view their total open balance under the Balance column.

 

Additionally, you can customise the Supplier Balance Summary report to focus on the details that matter most to you. Then, have it memorised so you can save the current customisation settings. For the detailed steps, kindly refer to this article: Memorise reports in QuickBooks Online.

 

Please let me know if you have other concerns. I'm just around to help.