An accounts receivable aging report shows which invoices are current, overdue, or becoming a collection risk. This guide provides a spreadsheet-ready accounts receivable aging report template, practical priority rules, follow-up email examples, and a weekly collections workflow that small businesses can reuse throughout the month.
Overview
An invoice aging report organizes unpaid invoices by the amount of time since their due date. A simple structure uses five aging bands: current, 1–30 days overdue, 31–60 days overdue, 61–90 days overdue, and more than 90 days overdue.
The report is useful because a total accounts receivable balance does not show how quickly cash may be collected. Two businesses can have the same outstanding balance, while one has mostly current invoices and the other has several older balances requiring immediate attention. Aging makes that difference visible.
Use the report as an operational tracker rather than as a substitute for accounting records. Keep invoice totals, payment status, credit notes, disputed amounts, and customer details aligned with your accounting system. If the spreadsheet and accounting system disagree, investigate the difference before contacting the customer.
For a broader back-office process, pair this tracker with a clear small business operations manual template. The manual can document who sends invoices, who approves credit, and who owns collections follow-up.
What to track
Start with one row per invoice. The following columns are enough for a practical accounts receivable spreadsheet:
| Field | Purpose |
|---|---|
| Customer | Identifies the account or legal entity responsible for payment. |
| Invoice number | Provides a reference for emails, calls, and accounting records. |
| Invoice date | Shows when the invoice was issued. |
| Due date | Defines when payment was expected under the agreed terms. |
| Invoice amount | Records the original amount billed. |
| Payments received | Captures partial or full payments already applied. |
| Open balance | Shows the amount still outstanding. |
| Days overdue | Measures the number of days past the due date. |
| Aging bucket | Groups the invoice as current, 1–30, 31–60, 61–90, or 90-plus days overdue. |
| Owner | Names the person responsible for the next action. |
| Last contact | Records the most recent reminder, call, or customer response. |
| Next action and date | Turns the report into a collections workflow instead of a passive list. |
| Status or issue | Flags promises to pay, disputes, missing purchase orders, or other blockers. |
A spreadsheet-ready header row might look like this:
Customer | Invoice Number | Invoice Date | Due Date | Invoice Amount | Payments Received | Open Balance | Days Overdue | Aging Bucket | Owner | Last Contact | Next Action | Next Action Date | Status or Issue
Useful formulas include Open Balance = Invoice Amount - Payments Received and, when the invoice is unpaid, Days Overdue = MAX(0, TODAY() - Due Date). The exact formula syntax depends on the spreadsheet application and date format. A basic aging-bucket rule can be expressed as:
- Current: the due date has not passed.
- 1–30: 1 to 30 days past the due date.
- 31–60: 31 to 60 days past the due date.
- 61–90: 61 to 90 days past the due date.
- 90-plus: more than 90 days past the due date.
Do not include a disputed amount in the same priority queue as an undisputed overdue balance without labeling it. A dispute may require an operational fix, such as correcting an invoice or supplying documentation, rather than a standard payment reminder.
Cadence and checkpoints
A weekly review is usually frequent enough for a small team to catch new overdue invoices without creating unnecessary administration. Choose a consistent day and assign one person to prepare the report before the review.
- Refresh the data. Import or enter new invoices, payments, credit notes, and customer updates.
- Reconcile the open balance. Compare the spreadsheet total with the accounting system or invoice ledger.
- Sort by priority. Review older aging buckets first, then high-value or strategically important accounts.
- Check ownership. Every overdue invoice should have one owner, one next action, and one due date for that action.
- Send or schedule outreach. Record the date and channel so follow-up is visible to the team.
- Review promises and blockers. Move promised payments to a monitored status and assign disputed items to someone who can resolve them.
At month-end, save a dated snapshot rather than overwriting the prior report. Monthly snapshots help you compare total receivables, the number of overdue invoices, and balances in the older buckets. A weekly operations review can provide a useful setting for this checkpoint; see the Weekly Operations Review Template for a broader meeting structure.
How to interpret changes
Look for movement, not just the current total. A falling total balance may be positive, but check whether the reduction came from actual payments, credits, write-offs, or corrected invoices. Likewise, a stable total can hide deterioration if amounts are moving from the current column into older buckets.
Use simple priority rules to keep decisions consistent:
- Current: confirm that invoices were delivered and that payment details are correct. Avoid treating every current invoice as overdue.
- 1–30 days: send a courteous reminder, include the invoice, and ask whether any information is needed to process payment.
- 31–60 days: assign a named owner, request a specific payment date, and investigate approval or purchase-order issues.
- 61–90 days: escalate internally, review the customer relationship and credit terms, and document any agreed payment plan.
- 90-plus days: treat the balance as a management decision. Consider a final structured outreach, escalation to the appropriate commercial or legal contact, or professional advice based on your circumstances.
These are workflow guidelines, not legal or accounting advice. Contract terms, jurisdiction, customer agreements, and the nature of a dispute can affect the appropriate next step.
Follow-up email templates
First overdue reminder
Subject: Payment reminder: Invoice [number]
Hello [name],
Our records show that invoice [number] for [amount] was due on [date]. I have attached a copy for convenience. Could you confirm the expected payment date, or let us know if any information is needed from our side?
Thank you,
[sender]
Older balance follow-up
Subject: Action requested: Outstanding invoice [number]
Hello [name],
I am following up on the outstanding balance of [amount] for invoice [number], now [days] days past due. Please confirm whether payment is scheduled and share the expected date. If there is a question or dispute about the invoice, please send the details so we can route it for review.
Regards,
[sender]
Keep the message factual, attach the relevant invoice, and avoid promising a resolution your team cannot provide.
When to revisit
Update the report weekly and preserve a monthly or quarterly snapshot for trend review. Revisit the template whenever payment terms change, billing responsibility moves to another team member, your accounting system changes, or customers begin requesting new documentation.
Use the next review to ask four practical questions: Which balances moved into an older bucket? Which promised payments arrived? Which invoices have no owner or next action? What recurring issue is delaying payment? The answers can lead to process improvements, such as a clearer client onboarding SOP, better invoice instructions, or a documented approval checkpoint.
To put the tracker into use today, copy the header row into a spreadsheet, add every open invoice, calculate each aging bucket, and assign the first action to an owner. Schedule a recurring weekly review, save dated snapshots, and update the status after every customer contact. The report becomes valuable when it drives a specific next step for every overdue balance.
