Accounts Receivable Aging Report: How to Track Unpaid Invoices

Short answer

An accounts receivable aging report groups unpaid invoices by how long they have been outstanding. A simple report uses Current, 1-30 days overdue, 31-60 days overdue, 61-90 days overdue, and 90-plus days overdue. It helps a small business decide which customers need a reminder, a call, a dispute review, or a formal collection step.

What the report should include

For each open invoice, show the customer, invoice number, amount, issue date, due date, days outstanding, status, and responsible owner. Add columns for the aging bucket and last contact date. Keep disputed invoices clearly identified because a disputed balance may need investigation rather than another automated reminder.

How to calculate invoice age

Calculate age from the due date, not only the issue date. An invoice due today is current; an invoice due 12 days ago is 1-30 days overdue. Use the contract and invoice due date calculation to avoid treating a not-yet-due invoice as late.

Example aging buckets

| Bucket | Meaning | Typical action | | --- | --- | --- | | Current | Not yet due | Confirm receipt and prepare a friendly reminder | | 1-30 days | Recently overdue | Send a clear follow-up and check for questions | | 31-60 days | Persistent delay | Contact the billing owner and review terms | | 61-90 days | High collection risk | Escalate internally and agree a documented plan | | 90+ days | Serious risk | Review dispute, collection, or write-off options |

The exact actions depend on your contract, customer relationship, and local rules. A clear invoice late fee policy should be communicated before fees are applied.

Use the report to prioritize work

Start with large balances that are overdue but not disputed. Then review customers with several open invoices, repeated late payments, or missing approval references. Combine the report with payment history rather than judging every customer by the same number of days.

For a professional collection sequence, use the invoice follow-up process. If a customer challenges a line item, move it into the invoice dispute process instead of repeatedly sending the same reminder.

Reduce the number of overdue invoices

• Put the invoice number, amount, and due date in the email subject.
• Offer a convenient invoice payment link.
• Send invoices immediately after an approved milestone.
• Ask for purchase order details before work is complete.
• Confirm the billing contact and approval route.
• Offer deposits or staged payments for larger projects.
• Review aging trends every week.

FAQs

Is an aging report the same as an overdue invoice list?

An overdue list only shows late invoices. An aging report also shows current invoices and groups balances by age, making it more useful for planning and prioritization.

Should disputed invoices be included?

Include them for visibility, but label them separately. Do not treat a disputed amount as equally collectible until the billing question has been resolved.

How often should I review the report?

Weekly is a practical cadence for most small businesses. Review it more frequently when cash flow is tight or a few customers represent a large share of outstanding revenue.