Match your ageing reports

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.

In QuickBooks:

1. Follow this link to complete the steps in product
2. From the Who owes you ▼ dropdown, select Accounts receivable ageing summary.
3. Select Customise report, then select the General Options panel.
4. Select the Ageing ▼dropdown, then select the 🔘Report date radio button.
5. Select X to exit the General Options panel, then select Save as.

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.