Aging Report

Build an accounts receivable aging report by entering your invoices. The tool groups them by age bucket (current, 1–30, 31–60, 61–90, 90+ days overdue), calculates totals and percentages, and exports as CSV.

Add Invoices

$

Total Invoices: 2

Invoice #AmountDue DateAction
INV-001$2,500.002026-06-18
INV-002$5,000.002026-05-19

Aging Summary

Aging BucketCountTotal Amount% of Total
Current (Not yet due)0$0.000.0%
1–30 days overdue1$2,500.0033.3%
31–60 days overdue1$5,000.0066.7%
61–90 days overdue0$0.000.0%
90+ days overdue0$0.000.0%
Total2$7,500.00100.0%

How to Use Aging Reports

Track collection velocity

Run monthly and compare aging distributions. An increasing 90+ bucket signals collection problems.

Prioritize follow-up

Focus collection effort on 1–30 day overdue invoices first. These have the highest recovery rate. Leave the 90+ bucket for escalation or write-off decisions.

Identify trends

If a specific customer appears frequently in the 90+ bucket, consider tightening terms or halting credit until past amounts are collected.

Prepare for escalation

Share this report with collection agencies or your legal team when escalating invoices over 90 days old. It shows the receivable history and collection effort.

Questions

What is an aging report?

An aging report groups accounts receivable invoices by how long they are overdue. It shows which invoices are current, 30/60/90+ days overdue, helping prioritize collection effort.

Why does aging matter?

The longer an invoice is unpaid, the less likely recovery becomes. Aging reports reveal collection patterns: high concentrations 90+ days out signal systemic issues or uncollectible debt.

How often should I run an aging report?

Monthly, ideally. Compare month-over-month trends to track collection velocity and identify customers falling behind on payment patterns.

What do the aging buckets mean?

Current: invoices not yet due. 1–30 days: moderately overdue, first contact stage. 31–60 days: formal follow-up warranted. 61–90 days: escalation needed. 90+: possible write-off or attorney referral.

How do I improve my aging profile?

Tighten payment terms, send invoices faster, automate reminders, follow up within 7 days of due date, and enforce escalation for invoices over 30 days late.

Should I write off old receivables?

Invoices 90+ days overdue with no payment contact in 30+ days may be uncollectible. Consult your accountant on write-off timing for tax and reporting purposes.

Related resources

Browse all free resources →

collect.ac automates overdue reminders that never exceed what your contract allows.

Try collect.ac free