Skip to content

Accounts Receivable Aging Report: How to Read It and What to Do Next

By the NexaPilot team · Updated · 6 min read

In short

An accounts receivable (AR) aging report groups unpaid invoices by how long they are past due — usually current, 1–30, 31–60, 61–90 and 90+ days. It shows at a glance how much money is at risk and which customers need attention. The older the bucket, the more urgent the action, so review it weekly and move invoices out of the older buckets first.

What an aging report shows

An aging report lists each customer's unpaid invoices and sorts the balances into time buckets based on the due date. The totals for each bucket tell you how healthy your receivables are; the rows tell you whom to call.

CustomerCurrent1–3031–6061–9090+Total
Atlas Studio——$4,800——$4,800
Marlow & Co.€1,250————€1,250
Bright Harbor—$900———$900

What each bucket means — and what to do

BucketWhat it usually meansAction
CurrentNot yet dueCourtesy reminder a few days before the due date
1–30 daysLate, often an oversightPolite email reminders; confirm the invoice was received
31–60 daysA pattern is formingAsk for a specific payment date; call the customer
61–90 daysSerious riskFirm reminder, payment plan, consider pausing work
90+ daysHigh risk of non-paymentFinal notice and formal recovery steps

Days Sales Outstanding (DSO)

DSO estimates how many days on average it takes you to collect payment after a sale. A common formula is:

DSO = (Accounts receivable ÷ Total credit sales in the period) × Number of days in the period

For example, $30,000 in receivables against $90,000 of credit sales over 90 days gives a DSO of 30 days. Track it month to month: a rising DSO means cash is coming in more slowly, even if sales look fine. Compare it with your standard payment terms — if your terms are 30 days and your DSO is 45, invoices are being paid two weeks late on average.

A weekly aging review in 15 minutes

  1. Start with the oldest bucket and work toward current.
  2. For each customer, check the last contact and any open promise to pay.
  3. Decide one next action per invoice: email, call, payment plan or escalate.
  4. Look for customers moving into an older bucket since last week — they need attention first.
  5. Note disputes separately; they need a fix, not a reminder.

NexaPilot builds the aging report automatically from your recorded invoices and payments, keeps every currency separate, and shows monthly collections and average days to pay alongside it.

Frequently asked questions

What is a good DSO?

It depends on your payment terms and industry. A useful rule of thumb is that DSO should stay close to your standard terms — for 30-day terms, a DSO well above 30 means customers are paying late.

How often should I review my AR aging report?

Weekly for most small businesses. A short weekly review catches invoices before they slip into the 60- and 90-day buckets.

Which aging bucket should I focus on first?

Usually the oldest buckets with the largest balances, plus any customer who just moved into an older bucket or missed a promised payment.

Stop chasing. Start getting paid.

NexaPilot ranks overdue invoices, tracks payment promises and drafts reminders for you.

Start your free 14-day trial

Get new guides by email

One short email when we publish something useful about getting paid. No spam, unsubscribe any time.

By subscribing you agree to our Privacy Policy.