Aging Report

An accounts receivable aging report groups unpaid invoices into buckets — current, 1–30, 31–60, 61–90, and 90+ days overdue — to show which accounts need collection attention first. Enter your invoices below to generate totals, percentages, and a CSV export.

Last updated:

Add Invoices

$

Total Invoices: 2

Invoice #AmountDue DateAction
INV-001$2,500.002026-08-07
INV-002$5,000.002026-07-08

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

Overdue Invoice Reminder Emails4-stage escalating email sequence with copy-paste templates.Demand LetterFormal payment demand letter with guidance and downloadable formats.Payment Plan AgreementInstallment agreement covering schedule, default, and signatures.Collection Call ScriptFirst call, broken-promise follow-up, and objection-handling scripts.Late Fee CalculatorCalculate accrued interest on overdue invoices with statutory rates.DSO CalculatorDays sales outstanding: measure how quickly you collect.Payment Plan CalculatorBuild installment schedules with automatic rounding.How to Collect Overdue InvoicesFull escalation ladder from reminders through agency referral.When to Send an Invoice to CollectionsCollections costs, recovery rates, and referral preparation.Payment Terms That Get You PaidNet 30, late fees, retention of title, and personal guarantees.AR Automation Features ChecklistWhat to look for in AR automation software, and what to ask any vendor.Payment Reminder TimingThe exact reminder schedule: T-3, due date, +3, +7, +14, +30 days, then escalation.Early Payment Discounts: Pros and ConsWhat 2/10 net 30 actually costs, annualized (36.7%), and when it is worth it.How to Get Invoices Paid Faster10 concrete tactics ordered by effort, from same-day invoicing to formal demand.What Is AR Automation?What gets automated, what stays human, and a manual vs. automated comparison.AR Automation ROI CalculationThe ROI formula with a full worked example: time savings and DSO working capital.Average DSO by IndustryMedian DSO by industry (CRF/D&B sourced), plus the "good DSO = terms + 50%" rule.collect.ac vs. AR Automation ToolsHonest, sourced comparison against Chaser, Upflow, and Gaviti — gaps included.
Browse all free resources →

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

Try collect.ac free