How to read an accounts receivable aging report and decide what to do next
Understand aging buckets, reconcile invoice balances, and turn an accounts receivable report into a prioritized follow-up worklist. Includes a worked example.
An accounts receivable aging report groups unpaid balances by age. To make it useful, confirm the report date and aging basis, reconcile payments and credits, then add the latest client response, next action, and owner to each overdue invoice.
What does an accounts receivable aging report show?
It shows outstanding receivables divided into age groups. Depending on the system and settings, aging may be based on the due date or another date. Confirm that basis before interpreting a bucket as “days overdue.” An invoice issued 30 days ago with net-30 terms may only just be due.
A summary report is useful for seeing exposure by customer and age. A detail report lets you inspect the individual transactions behind the total. Intuit distinguishes these two views in its QuickBooks guidance. Source: QuickBooks aging reports.
Use the detailed view when preparing outreach. Two invoices for one client can have different due dates, partial payments, or disputed amounts. A customer-level total does not tell you which bill to mention.
Read the buckets before prioritizing the balance
A common due-date-based report separates current invoices from balances 1–30, 31–60, 61–90, and more than 90 days overdue. Your software may use different intervals. “Current” means not yet overdue in this example, not necessarily paid.
Here is a fictional report as of October 29, 2026:
| Client | Invoice balance | Due date | Days overdue | Bucket |
|---|---|---|---|---|
| Maple Studio | $2,250 | November 5 | Not due | Current |
| Henderson & Co. | $4,800 | October 22 | 7 | 1–30 |
| Alder Partners | $3,200 | September 15 | 44 | 31–60 |
| Westbrook | $1,850 | August 15 | 75 | 61–90 |
The total outstanding balance is $12,100. The overdue balance is $9,850, because Maple’s $2,250 is still current. If the goal is to estimate overdue-invoice recovery, entering $12,100 would mix future-due cash with the overdue portfolio.
This distinction matters when setting priorities, evaluating recovery software, and discussing a balance with a client. Always preserve the report’s as-of date alongside exported figures.
Reconcile before sending reminders
Check for payments recorded after the report was generated, unapplied receipts, credits, and invoice adjustments. A client who paid yesterday may still appear in last week’s export. Conversely, a payment may be recorded at the customer level without being matched to the invoice you plan to chase.
Do not “fix” a difference by manually deleting the invoice from your worklist. Record why it changed and make sure the underlying billing record is correct. Otherwise the same balance may return in the next export.
For law firms, keep billed receivables separate from unbilled work and trust balances. If you are unsure how a report treats those categories, confirm with the person responsible for your firm’s accounting before acting on the totals.
Add the context the aging report does not contain
An aging bucket describes time, not the reason for nonpayment. Add these fields to your operational view:
- Last contact date and channel.
- Latest reply or reason for delay.
- Proposed or approved payment date.
- Disputed amount, if any.
- Next action and the person responsible.
- Date the payment record was last checked.
In the example, Henderson might need a first reminder, Alder might have promised payment tomorrow, and Westbrook might be waiting for a corrected bill. Sending the same “please pay” email to all three would ignore the work already done.
A payment-promise log helps distinguish a responsive client from an unanswered account without hiding either balance from the financial report.
Prioritize actions, not just the oldest invoices
Start by resolving situations where the next action is clear: resend a missing invoice, answer a billing question, or match a reported payment. Then review high-value or older balances that have no useful response.
Do not assume the largest invoice should always receive the most contact. It may be under active review with an agreed next step. Likewise, a small balance with a duplicate charge may need correction rather than another reminder.
A practical daily queue has four groups: ready for approved outreach, waiting on a commitment, waiting on a staff decision, and waiting on payment verification. Each group has a different completion condition.
Use the report to measure change over time
Save a dated starting portfolio and track what happens to those invoices. Separate cash received from credits and write-offs; a lower outstanding balance is not always the result of a payment. Note new invoices separately so growth in billing does not hide recovery on older balances.
For example, if the $9,850 overdue portfolio falls to $5,000, investigate the $4,850 change. If $4,000 was paid and $850 credited, report those outcomes separately. “Recovered $4,850” would overstate the cash result.
See the invoice recovery ROI guide for a method that also subtracts the service cost and distinguishes incremental recovery from cash that likely would have arrived anyway.
Common questions
Why does my aging report disagree with a client’s balance?
Check the as-of date, aging method, filters, credits, and payment allocation. The two views may cover different transactions or dates. Resolve the difference before treating either number as the confirmed amount owed.
Does an older invoice mean it is uncollectible?
No. Age is a signal to investigate. Whether to pursue, adjust, or write off a balance requires the appropriate accounting and account-owner decision; the bucket itself does not make that decision.