Accounts Receivable Aging Report: A Small-Business Guide

What is an accounts receivable aging report?

An accounts receivable aging report lists unpaid customer invoices and groups them into time buckets based on the invoice date or due date. Common buckets are current, 1–30 days overdue, 31–60, 61–90, and more than 90 days overdue. The report shows which customers owe money, how much is outstanding, and how long each balance has remained unpaid.

The report is a control tool, not merely an accounting output. It helps a business prioritize collection work, investigate disputes, estimate cash receipts, assess credit risk, and identify process problems before an overdue balance becomes difficult to recover.

Build the report from reliable records

Start with the customer ledger and include the customer name, invoice number, invoice date, due date, original amount, payments or credits, remaining balance, aging bucket, dispute status, owner, and next action date. Use the contractual due date consistently so invoices are not classified differently from one review to the next.

Reconcile the total aging balance to the accounts receivable control account. Investigate differences caused by duplicate invoices, unapplied cash, credit notes, write-offs, currency conversion, or transactions posted to the wrong customer. Decisions based on an unreconciled report can waste collection effort and damage customer relationships.

• Remove fully paid invoices.
• Apply customer payments and approved credits promptly.
• Flag disputed amounts separately.
• Keep notes factual and time-stamped.
• Protect access because the report contains sensitive commercial information.

Read concentration and movement, not only totals

The total receivable balance can look stable while risk increases underneath. Compare the share of balances moving into older buckets, the amount owed by the largest customers, average payment behavior, and invoices repeatedly promised but not paid.

A large current balance from a reliable customer may be less urgent than a smaller 90-day balance with no response. Review both value and collectability. Note whether overdue amounts result from customer financial stress or from internal failures such as late invoicing, missing purchase orders, incorrect tax information, or unresolved service issues.

Create a weekly collection workflow

Assign each overdue item to a named owner and define the next action. Early contact can be a polite reminder with the invoice and payment options. Older or higher-risk items may require account-manager involvement, a repayment plan, a credit hold, escalation, or qualified legal advice.

Use consistent communication while respecting applicable debt-collection, privacy, contractual, and consumer-protection rules. Do not threaten actions the business cannot or will not take. Preserve a clear record of messages, promises, disputes, and agreed dates.

• Confirm the invoice was received and accepted.
• Resolve missing documentation or service disputes.
• Record a specific promised payment date.
• Escalate broken promises under a documented policy.
• Stop extending additional credit when risk exceeds the approved limit.

Connect aging to cash forecasting

The aging report supplies evidence for the cash-flow forecast, but an outstanding invoice should not automatically be treated as cash arriving on its due date. Use the customer's actual payment pattern, open disputes, promises, and current risk to estimate receipt timing.

Model delays for large or concentrated balances. If one late customer would create a shortfall, management can act earlier by accelerating other collections, changing spending, negotiating payment timing, or arranging appropriate finance.

Improve the process that creates overdue debt

Collections begin before an invoice becomes late. Confirm credit terms during onboarding, capture the correct legal and billing details, obtain purchase orders when required, invoice promptly, describe the work clearly, and give customers an easy way to report a problem.

Track recurring causes of delay. If invoices are rejected because of missing references or sent to the wrong contact, faster reminders will not solve the root cause. Fixing the billing workflow can reduce days outstanding without adding pressure to good customers.

Use metrics with judgment

Useful measures include overdue value, percentage current, balances over 60 or 90 days, collection effectiveness, disputed amount, promise-to-pay kept rate, and customer concentration. Days sales outstanding can help at portfolio level, but seasonal sales or changing payment terms can distort it.

Review trends rather than one isolated figure. The aim is not to force every customer into the shortest possible term. It is to make credit deliberate, collect valid invoices predictably, protect relationships, and keep cash assumptions grounded in evidence.