Skip to main content
Qd1
July 9, 2020
Question

Why is my balance sheet receivalble total different than my trial balance receivable total. Trial balance is correct.

  • July 9, 2020
  • 1 reply
  • 0 views
Original commenter did not share additional details

1 reply

July 10, 2020

Hi there, 

 

It's important that your Aging accounts match and I'd be glad to help. QuickBooks Online offers powerful reports which help you streamline your business and get ahead with your work. 

 

If your Balance Sheet, Trial Balance, and Accounts Receivable Aging Reports don’t match up, it’s usually because the Aging Report defaults to Current.

 

Here's how to change the aging method to report the date:

  1. Open the A/R Aging report.
  2. Select Customize.
  3. Select Aging.
  4. Under Aging Method, choose Report Date.
  5. Select Run report.

After finishing this process, your report will balance to the Balance Sheet/Trial Balance.

 

Tip: Be sure that the Balance Sheet / Trial Balance is run using Accrual as the reporting method.

 

If you're still having problems, consider the following items:

  • If a bill has been paid today it won’t show.
  • Make sure the date range on the reports match.
  • Be sure you're comparing the correct numbers.
  • On your A/R Aging report you want to match the Open Balance to your Balance Sheet / Trial Balance amount for Accounts Receivable.

Give this a try and if you have questions, please contact our support team using this link. Let me know if you have other questions by leaving a comment below. I'll be on standby.