Free AR resources / tool
Accounts Receivable Aging Report
An accounts receivable aging report groups outstanding balances by how long they have been overdue. It helps teams prioritise follow-up, identify risk and explain receivables health to stakeholders.
How to use this resource
- Enter the total receivables balance.
- Allocate amounts into current, 1–30, 31–60 and 61–90 day buckets.
- The tool shows the remaining balance in the 90+ day bucket.
- Review where overdue balances are concentrated and make sure bucket totals reconcile to the ledger.
Understanding AR aging buckets
Current invoices are not yet overdue. The overdue categories commonly cover 1–30, 31–60, 61–90 and more than 90 days past the due date.
Older balances may require more attention, but amount, customer circumstances and dispute status matter too. Use aging information alongside the account history.
What to do with an aging report
Start with the largest overdue exposures and any invoices approaching the next escalation stage. Confirm payments and credits before contacting customers.
Review aging movement over time to see whether new overdue invoices are accumulating faster than existing balances are being resolved.
Frequently asked questions
What does 90+ days mean?
It represents invoices more than 90 calendar days past their due date.
Can an invoice appear in multiple aging buckets?
No. Each open invoice belongs in a single bucket based on the days past its due date.
Does this tool import accounting software data?
No. It is a manual illustrative breakdown. Enter figures from your ledger to visualise them.
More resources
Open this page in a browser to use the interactive tool.