Accounts Receivable Aging Report: Buckets, DSO and Cash

An accounts receivable aging report groups unpaid customer invoices by how far they are past their due dates. It helps a finance team distinguish money that is not yet due from overdue balances, disputes and collection promises. Use it to decide who needs follow-up and when cash can reasonably enter the forecast.

The report is a dated snapshot, not a guarantee of collection. A customer may owe money without paying it during the week you need it. Equally, an invoice is not overdue merely because it was issued a month ago: use the agreed due date.

Why cash collection deserves a separate management view

In the Federal Reserve Banks' 2026 Report on Employer Firms, meeting operating expenses was the most common reported financing purpose among financing applicants. The report covers a 2025 US convenience sample; it does not establish that overdue invoices caused those financing needs, or describe every country's businesses.

For your own company, an aging report makes one part of the cash question auditable: what remains unpaid, on which terms, and with what evidence of an expected payment? Link that detail to a 13-week cash-flow forecast rather than assuming recognized revenue is already spendable cash.

Start with an invoice-level export

Keep invoice ID, customer, invoice date, contractual due date, original amount, receipts applied, credit notes applied, outstanding balance and currency. Add dispute status, collection owner, promised payment date and the last confirmed customer response.

Use one reporting cutoff across the export and ledger. Apply receipts and credit notes dated on or before that cutoff; do not reduce a historical balance with a payment received afterward. Reconcile the invoice-level total to the receivables control account and investigate differences such as unapplied cash or timing.

Separate credit balances and disputed amounts visibly. Do not silently offset one customer's balance against another's. For installment arrangements, age the outstanding installments against their own due dates rather than treating the entire invoice as late.

Calculate days past due and assign each balance once

Outstanding balance = Invoice amount − Applied receipts − Applied credit notes

Days past due = MAX(0, Reporting date − Contractual due date)

If cell B1 holds the reporting date and D2 contains the due date, the Excel formula is =MAX(0,$B$1-D2). Store genuine spreadsheet dates, not ambiguous text. Calculate outstanding balances separately and include only positive unpaid amounts in the aging buckets.

Use current, 1–30, 31–60, 61–90 and 91+ days past due as a simple starting structure. An invoice due on the reporting date belongs in current; it becomes one day overdue the following day. These buckets are a management convention, not a universal legal collection timetable.

Worked example: a snapshot at November 1, 2026

This is illustrative data, in one currency and excluding tax. Each row is an unpaid invoice balance after applied receipts and credits.

Invoice	Due date	Outstanding	Days past due	Bucket
A	2026-11-15	12,000	0	Current
B	2026-10-17	8,000	15	1–30
C	2026-09-17	6,000	45	31–60
D	2026-08-18	4,000	75	61–90
E	2026-07-19	2,000	105	91+
Total	—	32,000	—	—

Overdue receivables are 20,000: all rows except current invoice A. The overdue share is 20,000 ÷ 32,000 = 62.5%. The 91+ bucket is 2,000, not the entire overdue amount.

Group the same records by customer to identify concentration. A large balance across several invoices may deserve attention even when no individual invoice exceeds your review threshold. Keep invoice-level drill-down so the customer total remains traceable.

DSO is useful, but it does not replace aging

A simple period-end calculation is:

DSO = Ending trade receivables ÷ Net credit sales for the period × Days in the period

Using the example's 32,000 balance and assumed net credit sales of 180,000 over a 90-day period gives 16 days. In this example, both balances and sales exclude tax and cover the same business scope and currency. In practice, align the tax basis, exclude cash sales from the credit-sales denominator, and document the chosen method.

That aggregate 16-day result does not make invoice E's 105-day delay disappear. Rapid recent sales growth, seasonality and customer mix can make period-end DSO look healthy while old invoices remain unpaid. An average-receivables method may be more informative in some businesses; disclose the method and keep comparisons consistent.

For multiple units, calculate consolidated DSO from consolidated receivables and credit sales for the same period. Do not take a simple average of unit DSOs. If credit sales are zero or unavailable, do not invent a meaningful DSO; report the balances and missing information.

Turn the report into a collection plan

For each material overdue balance, record whether the invoice was delivered correctly, whether the customer accepts it, what blocks approval, the next contact date and the collection owner. Distinguish a written payment commitment from an internal estimate.

Use expected receipt dates supported by that evidence in the cash forecast. A bucket total does not automatically belong in next week's receipts. Show an alternative collection scenario for material uncertainty, and update the forecast when promises are missed.

Discuss disputed invoices with the responsible operational team. Collection escalation, late-payment charges and impairment or write-off decisions require the applicable contract, accounting policy and professional advice; this guide does not prescribe those decisions.

Include five checks in the monthly report

1. Receivables total reconciles to the ledger at the reporting cutoff.
2. Bucket totals add to the invoice-level positive balances without duplicates.
3. Overdue share, DSO method and tax basis are stated.
4. Concentrations, disputes and broken promises have named owners.
5. Expected receipts connect to the cash forecast without being counted twice.

Use the monthly management report template to summarize the findings, and carry collection assumptions into your 2027 budget plan. Raavue can help review structured financial exports, but it does not contact debtors, guarantee payment or replace the receivables ledger. View a sample financial report to see the reporting approach.

Frequently asked questions

Should aging start from the invoice date or due date?

For overdue collection analysis, use the contractual due date. An invoice-date aging view answers a different question and must be labeled differently.

Does an old invoice automatically become a bad debt?

No. Age is a warning signal, not an accounting conclusion. Assess collectability, disputes and the applicable accounting requirements with the responsible professional.

How often should the report be updated?

Use the monthly close for reconciled management reporting, with more frequent collection reviews when cash timing or customer concentration makes them necessary.