Your A/R aging report may not match your open invoices. This does not always mean that money is missing.
The two reports may use different dates or settings. A payment or credit may also be in QuickBooks but not linked to the right invoice.
The difference is worth checking before you contact a customer or rely on the total.
What does the A/R aging report show?
Your accounts receivable, or A/R, aging report shows what customers still owe.
It groups open balances by age. For example:
- Current
- 1–30 days late
- 31–60 days late
- 61–90 days late
- More than 90 days late
The report is based on the records and settings in QuickBooks. It does not prove that every balance is still due.
Why can the reports be different?
There are several common reasons.
The report dates do not match
One report may use today’s date. The other may use the end of a past month or year.
A payment entered after that date may appear in one report but not the other.
The aging setting is different
QuickBooks can age balances using the current date or the report date.
If the reports use different settings, the totals may not match.
A payment has not been applied
A customer payment may be in QuickBooks but not linked to the right invoice.
The payment record may exist while the invoice still has an open balance.
A credit has not been applied
A customer may have a credit that has not been applied to an invoice.
This can leave an invoice open while the customer has a credit elsewhere in their records.
The reports use different filters
A report may be limited by date, customer, account, or another filter.
Even one different filter can change the total.
An invoice was changed
Someone may have changed an invoice date, due date, amount, customer, or payment link.
That change can affect where the balance appears.
What should I check?
Start with these simple checks:
- Run both reports for the same date.
- Check that both reports cover the same period.
- Review any filters.
- Check the aging setting.
- Look for unapplied customer payments.
- Look for unused customer credits.
- Open a few invoices and check their payment links.
- Check whether any invoice was changed or removed.
Do not edit or delete records just to make the totals agree. First find the cause of the difference.
If you are unsure how a change may affect your books, ask your bookkeeper or accountant before making it.
What if the customer says they already paid?
Check your bank records and the payment record in QuickBooks.
A bank deposit can show that money reached your bank. It does not prove that the payment was applied to the right invoice in QuickBooks.
The amount may also cover more than one invoice. A partial payment can make the balance harder to trace.
Do not ask the customer to pay again until you have checked the records.
Does an open invoice mean the money is still owed?
Not always.
An invoice may look open because a payment or credit was not applied. The customer may also dispute the balance or have other records that change what is due.
An open invoice is a reason to check. It is not proof of recoverable value by itself.
Why can this become hard to check?
One invoice may be easy to trace.
A full year may include many invoices, payments, credits, and changes. One payment may cover several invoices. Similar amounts may belong to different customers or dates.
A match in amount alone does not prove that two records belong together.
Where RecurSave fits
RecurSave provides Financial Leakage Reviews for owner-led service businesses.
You send us standard QuickBooks exports. You do not share your login or give us access to your QuickBooks account.
We review what the submitted records support. We do not assume that every open invoice is still owed.
The review is free. If the records support material estimated recoverable value, you receive a free Findings Summary.