Why the Balance Sheet and A/R aging report don't match

When the Balance Sheet and the Accounts Receivable aging report show different totals, the usual cause is the aging method on the aging report. QuickBooks Online leaves that method set to Current, which ages invoices as of today rather than as of the report date. One setting change usually brings the two reports back into line.

The cause of the gap

The Balance Sheet reports receivables as of one date. It counts every invoice that was still open on that date and subtracts every payment received on or before it. A payment received later has no effect on that figure.

The Current aging method answers a different question: which invoices are unpaid today. It subtracts payments received up to today, including any received after the report date, and it leaves out invoices that have been paid in full since. Run the report for a month-end date a few weeks back and its total can sit well below the Balance Sheet figure for that date.

Neither report is wrong. Each is answering the question it was built to answer, and only one of those questions is the one a historical Balance Sheet asks.

Does aging use due dates?

It does. QuickBooks Online builds the aging buckets from each invoice’s due date, not its invoice date. An invoice stays in the Current column until its due date passes, then moves through the 1-30, 31-60 and later buckets.

That choice decides which column an invoice lands in. It does not change the report total, so it is not by itself a reason the two reports disagree. QuickBooks Desktop has a preference for aging from the transaction date instead; QuickBooks Online does not offer that switch.

Switch to Report Date aging

Open Reports in the left navigation and select the Accounts receivable aging summary or aging detail report.
Select Customize in the report toolbar.
In the Aging section, set Aging method to Report Date.
Set the report period so its end date matches the Balance Sheet date.
Select Run report.

The report now subtracts only payments received on or before the report date, which is the same logic the Balance Sheet uses. Invoices paid after that date stay on the report, and the two totals should agree. Use Save customizations to keep this version ready for the next month-end.

Match the report settings

A few settings can still pull the numbers apart:

Run both reports as of the same date, down to the day.
Set the accounting method to Accrual on both reports. A cash-basis Balance Sheet may not show receivables at all.
Clear any filters on the aging report. A saved customer list or transaction filter can quietly remove rows.

If the totals still differ

After that, the remaining causes usually sit in the transactions themselves:

Look for a payment or credit memo that has not been applied to an invoice. Apply it, then run both reports again.
Confirm the aging method still reads Report Date rather than Current.
Recheck both dates side by side, including the year. A one-day offset changes the total whenever payments fall across it.

If a specific transaction looks wrong, such as a payment posted with the wrong date, the record lives in your Intuit account. Intuit’s support team can look at it with you; reach them from the Help menu in QuickBooks Online.