QuickBooks HelpQuickBooksHelpIntuit

Match your ageing reports in QuickBooks Online

by Intuit2 Updated about 4 hours ago

Learn how to match your ageing reports in QuickBooks Online.

Your balance sheet, trial balance, and accounts receivable ageing reports should match in QuickBooks to maintain a healthy cash flow. If they don't, it’s usually because the ageing report defaults to current. Here’s how you can match them.

Some of your reports will look different depending on whether they're in the classic view or new enhanced experience. Learn more about the new enhanced experience.

Change the ageing method to report the date

Change the Ageing Method when you run your A/R Ageing report.

  1. In QuickBooks, go to Reports, then select the Standard tab.
  2. From the Who owes you ▼ dropdown, select Accounts receivable ageing summary.
  3. Select Customise, then select Ageing ▼ dropdown.
  4. Under Ageing method, select Report date.
  5. Select Run report.

After this process, you can run a Balance Sheet or a Trial Balance report to match the results.

Note: Make sure you run the Balance Sheet or Trial Balance report using Accrual as the Accounting method.

Check for other possible reasons for a mismatch

Consider the following items to help match your reports:

  • If you paid your bill today, it won’t show‌ up on your reports right away.
  • Make sure the date range on the reports matches.
  • Make sure you're comparing the correct numbers on your reports.
  • Check the opening balance on your A/R Ageing summary report. The balance should match the total amount of Accounts Receivable that shows on your Balance Sheet or Trial Balance.

Sign in now for personalized help

See articles customized for your product and join our large community of QuickBooks users.