A sale can look healthy in your accounts while the cash is still missing from your bank. When customers pay late, that gap can affect wages, supplier bills, and everyday spending. An accounts receivable aging report makes the problem visible by grouping unpaid invoices according to how long they have been outstanding or overdue.
Its value is not simply identifying the oldest debt. Used properly, the report helps you decide whom to contact, which payments to expect, and how much confidence to place in your upcoming cash receipts.
What the report tells you
An accounts receivable aging report, also called a receivables report or aging schedule, lists open customer balances at a selected date. It usually includes customer names, invoice numbers, due dates, outstanding amounts, and totals arranged in age categories. A customer might have invoices across several categories.
Unlike a sales report, it focuses on money billed but not yet collected. It helps identify overdue payments, spot collection patterns, and check whether customer balances support cash plans. The report’s total should agree with the accounts receivable balance in your accounting records for the same cut-off date, after relevant adjustments.
Understand the accounts receivable aging buckets
For collections, most reports measure days past the invoice’s due date. Common categories are current, 1–30 days overdue, 31–60 days overdue, 61–90 days overdue, and more than 90 days overdue. Some systems instead calculate age from the invoice date, so check the settings before assuming every older invoice is late.
Current invoices
These balances are not yet due. They normally need routine monitoring rather than a collection call. A large invoice approaching its deadline may justify confirming the customer has everything needed to pay.
1–30 days overdue
A recently late invoice may be waiting for approval or sitting in the wrong inbox. Send a courteous reminder stating the invoice number, amount, original due date, and payment details.
31–60 days overdue
Repeated generic reminders are less helpful here. Contact the appropriate person, ask what is preventing payment, and request a specific expected date. Record any dispute or commitment.
61–90 days and over 90 days overdue
Older balances warrant closer attention and possibly escalation under your credit policy. Age raises concern, but does not prove a debt is uncollectible. A disputed invoice requires a different approach from a customer who has stopped responding.
A practical example: reading the numbers
Suppose a design agency runs its report on 14 October. It has four invoices: $7,200 due on 30 October, $4,000 due on 25 September, $3,000 due on 20 August, and $1,800 due on 8 July.
Using days past due, the first invoice is current. The others are 19, 55, and 98 days overdue respectively. The agency has $16,000 outstanding, of which $8,800 is overdue and $4,800 is more than 30 days overdue.
That is a different picture from simply seeing a $16,000 receivables balance. The agency could confirm the payment process for the large current invoice, remind the $4,000 customer, obtain a commitment on the $3,000 invoice, and investigate the $1,800 account’s circumstances.
The oldest invoice is not necessarily the first call. Priority should also reflect invoice size, customer history, disputed amounts, and the cash needed soon.
Turn the report into a collection plan
A useful invoice collections process assigns a next action rather than producing another list that nobody follows. For each material overdue balance, identify the person responsible, the contact already made, the customer’s response, and the next follow-up date.
Check before chasing
Review payments received after the report date, credit notes, partially settled invoices, and unapplied receipts. Otherwise, you risk pursuing a customer who has already paid or who was billed incorrectly.
Ask questions that move payment forward
Instead of sending the same message repeatedly, find out whether the invoice has been approved, whether documentation is missing, and when the next payment run occurs. A specific commitment is more useful than an indefinite assurance.
Find problems in your own process
If invoices regularly become overdue because they lack purchase-order references or are sent to the wrong address, improve those steps at the source. Clear invoice payment terms and accurate contact details can prevent delays.
Review the accounts receivable aging report weekly when invoicing is frequent. A business facing a short-term cash squeeze may need a daily check. Keep notes so that the next person handling an account knows what has happened.
Use aging figures for better cash planning
Unpaid invoices are not cash guaranteed to arrive this month. An invoice due tomorrow may be paid next month, while one already overdue could arrive today. The aging report is a snapshot of outstanding claims, not a prediction of payment dates.
For a cash flow forecast, start with due dates, then adjust using confirmed promises, payment history, disputes, and reasonable uncertainty. Keep doubtful receipts separate from money you can confidently count on for immediate obligations.
If $5,000 expected in October slips into November, the October cash plan needs to change even though total receivables remain the same. This is why cash flow forecasting and aging analysis work better together.
Compare consecutive reports, too. If balances move into older categories faster than customers pay them, collection performance may be deteriorating despite higher sales.
Common mistakes that distort the report
Incorrect due dates can make reliable customers appear late. So can mixing invoice-date aging with due-date aging when comparing periods. Use consistent definitions and a clear reporting cut-off.
Look for misallocated payments, duplicate invoices, unused credit notes, and customer balances that should have been cleared. Reconcile your receivables report to the ledger rather than assuming the software output is correct.
Older balances can help inform an allowance for doubtful accounts or expected credit losses. The appropriate calculation depends on the accounting framework and evidence about collectability. An age bracket alone does not establish that an invoice should be written off.
Reliable small business bookkeeping makes analysis possible: accurate invoices, prompt payment allocation, and documented customer conversations keep the report meaningful.
Make the report part of your routine
An aging report earns its place when it changes what happens next. Review overdue balances, resolve billing obstacles, follow up on commitments, and revise cash expectations when receipts slip. Small, consistent actions beat discovering old invoices at month-end.
Frequently asked questions
How often should I generate an accounts receivable aging report?
Monthly reviews support financial reporting, but weekly reviews are generally more useful for active collections. High-volume businesses or those managing tight cash flow may check it daily.
Are aging buckets based on invoice dates or due dates?
Both methods exist. Days past due is usually more useful for collections, so check how your accounting system defines its buckets.
Does an invoice over 90 days old have to be written off?
No. An old balance warrants investigation, but any decision about write-offs or allowances requires evidence about collectability and the relevant accounting rules.
Can the report replace a cash flow forecast?
No. The aging report shows unpaid balances as of a date. A forecast estimates when cash will arrive and when payments must be made.
