Match your aging reports in QuickBooks Online

Learn how to match your aging reports in QuickBooks Online.

Your balance sheet, trial balance, and accounts receivable aging reports should match in QuickBooks to maintain a healthy cash flow. If they don't, it’s usually because the aging 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 aging method to report the date

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

1. In QuickBooks, go to Reports, then select the Standard tab.
2. From the Who owes you ▼dropdown, select Accounts receivable aging summary.
3. Select Customize report, then select the General Options panel.
4. Select the Aging ▼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 Aging summary report. The balance should match the total amount of Accounts Receivable that shows on your Balance Sheet or Trial Balance.