QuickBooks HelpQuickBooksHelpIntuit

How to get your Ageing Reports to match

SOLVEDby QuickBooksUpdated December 01, 2022

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

How do I change the ageing method to report the date?

  1. Open the A/R Ageing report.
  2. Select Customise.
  3. Select Ageing.
  4. Under Ageing 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.


Need more help?

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 Ageing report you want to match the Open Balance to your Balance Sheet / Trial Balance amount for Accounts Receivable.

Now your ageing reports match up.

Was this helpful?

You must sign in to vote, reply, or post
QuickBooks Online EssentialsQuickBooks Online PlusQuickBooks Online Simple Start

Sign in for the best experience

Ask questions, get answers, and join our large community of QuickBooks users.

More like this