Skip to content

G.29Receivables

How to Read an Accounts Receivable Aging Report

A sample report from a staffing agency, read three ways, with the patterns worth a phone call and a short Monday routine for acting on them.

By PayLinkPublished 7 min read

On this page8 sections
  1. 01A sample aging report
  2. 02Read down the columns: how much is late
  3. 03Read across the rows: which customers are slipping
  4. 04What each aging bucket usually signals
  5. 05Check the settings before you trust the report
  6. 06The accounts receivable aging method for estimating bad debt
  7. 07A weekly routine for acting on the aging report
  8. 08Frequently asked questions

An accounts receivable aging report lists every unpaid invoice, grouped by how long it has been outstanding: typically current, 1 to 30 days past due, 31 to 60, 61 to 90, and over 90. Read it down the columns to see how much of your money is late, across each row to see which customers are slipping, and week against week to see whether things are getting better or worse.

Definition

An accounts receivable aging report is a table of a business's open customer invoices, sorted by customer and grouped into time buckets based on how many days each invoice is past its due date or invoice date. It shows who owes money, how much, and for how long, so collection effort can go where it matters most.

A sample aging report

Here is a hypothetical report for a staffing agency that bills clients weekly on net 30 terms. It is aged by due date, so "current" means not yet due.

CustomerCurrent1–3031–6061–9090+Total
Regional hospital$28,000$14,000–––$42,000
Logistics warehouse$18,500$6,200$3,100––$27,800
Food processing plant$9,000$9,000$8,400––$26,400
Hotel group–$5,600$5,600$5,600$2,800$19,600
Event company––––$7,500$7,500
Call center$6,300––––$6,300
Property manager$4,200––––$4,200
Total$66,000$34,800$17,100$5,600$10,300$133,800
Share of total49%26%13%4%8%100%

Read down the columns: how much is late

Start with the bottom row. Just under half of this agency's receivables are current, so slightly more than half ($67,800) is past due. Most of that is in the first bucket, where a reminder usually does the job. The $15,900 in the two oldest buckets is the part to worry about: it is 12% of the book, and the older an invoice gets, the less likely it is to be paid in full.

Totals by bucket also feed your other numbers. The receivables total drives days sales outstanding, and the current column gives you best possible DSO, the figure you would have if nobody paid late.

Read across the rows: which customers are slipping

The bucket totals tell you how big the problem is. The rows tell you what kind of problem it is. Four patterns in the sample are worth recognizing, because each calls for a different response.

Late but steady

The regional hospital has $14,000 just past due and nothing older. Large institutions often pay on a fixed cycle that runs a little behind your terms. That is a timing issue more than a credit risk, and it may be worth asking their AP team when their payment runs happen, so you can time invoices to land before the cutoff.

A creeping balance

The food processing plant has roughly equal amounts in three consecutive buckets. Two months ago it was paying on time. A customer whose overdue balance grows a little each month is often under strain, or has a dispute nobody has mentioned. Call this week, before the oldest invoices age further.

Paying one invoice at a time

The hotel group has the same $5,600 in each bucket. It pays something each month, but always the oldest invoice, so it never catches up. Its balance has been stuck at about three and a half months of billing, and nothing is current only because the agency stopped sending new staff there last month. A payment plan that clears the arrears on a schedule, alongside paying new invoices on time, usually works better than a series of reminders.

All in the oldest bucket

The event company's entire balance is over 90 days. A customer that pays nothing at all is either disputing the invoice or no longer able to pay. Find out which. If it is a dispute, resolve it; if the customer has stopped responding, move to the formal steps in how to collect unpaid invoices.

What each aging bucket usually signals

BucketWhat it usually meansTypical action
CurrentNot yet duePre-due reminder on larger invoices
1–30 daysMissed due date, often an oversight or a payment cycleAutomated reminder, then a past due invoice email
31–60 daysSomething is holding the invoice: a dispute, a missing PO, cash strainPhone call to the AP contact; ask what is stopping payment
61–90 daysReal collection riskCall the decision-maker; consider pausing new work or orders
90+ daysUnlikely to be paid in full without interventionPayment plan, formal demand, or referral; review for write-off with your accountant

The escalating sequence of reminders in the first three rows is what collections teams call dunning, and most of it can run automatically.

Check the settings before you trust the report

Two settings change what the report means, and it is easy to run one without knowing which you chose.

  • Aging by due date or by invoice date. Aged by invoice date, a net 30 invoice sits in the 1–30 bucket for its whole life before it is even due. That makes every report look worse than it is, and invoices on net 45 or net 60 terms make it worse still. For collection work, age by due date.
  • Unapplied payments and credits. A payment received but not matched to an invoice leaves the invoice showing as overdue. Credit memos and overpayments appear as negative amounts. Apply cash the day it arrives, and clear old credits, so you never chase a customer who has already paid.

The accounts receivable aging method for estimating bad debt

The aging report also does accounting work. Under the aging method, you estimate the allowance for doubtful accounts by applying a different loss percentage to each bucket, because older invoices are less likely to be collected. The percentages should come from your own collection history; the ones below are hypothetical.

BucketBalanceEstimated uncollectibleAllowance
Current$66,0001%$660
1–30 days$34,8003%$1,044
31–60 days$17,10010%$1,710
61–90 days$5,60025%$1,400
90+ days$10,30050%$5,150
Total$133,800$9,964

The agency would carry an allowance of about $10,000, or 7.4% of receivables. More than half of it comes from the $10,300 over 90 days, which shows how much an old balance weighs on the true value of the book. Your accountant can confirm the method and percentages that suit your books; the tax treatment of bad debts follows separate rules.

A weekly routine for acting on the aging report

The report is only useful if someone acts on it. This takes 30 to 45 minutes every Monday.

  1. Apply every payment received since last week, so the report is accurate.
  2. Run the report aged by due date and sort customers by total past due, largest first.
  3. Compare the bucket totals with last week's. If more money moved into 31–60 than left it, collections are falling behind.
  4. Call the top five past-due accounts. Ask a specific question about a specific invoice, and write down the promised payment date.
  5. Check last week's promised dates. Anyone who missed one moves up the escalation table.
  6. Flag any customer with a creeping balance or a fully aged balance, and decide whether to hold new orders.
  7. Feed expected payments into your cash flow forecast for the coming weeks.

Frequently asked questions

Q.01

What is the difference between an AR aging report and an AP aging report?

An accounts receivable aging report shows money customers owe you, grouped by how overdue it is. An accounts payable aging report shows money you owe suppliers, grouped the same way. The first tells you whom to chase; the second tells you which bills to pay this week to avoid late fees and keep supplier relationships in good standing.

Q.02

Should I send customers their aging details?

Send each customer a statement instead, listing each open invoice with its date and amount. It does the same job from their side and often surfaces invoices their AP team never received. Never send a customer the full report, since it shows other customers' balances. Monthly statements to every account with an open balance are a sensible default.

Q.03

What percentage of receivables should be current?

There is no universal figure, because it depends on your terms and customers. Compare yourself with your own history: if the current share is falling over several months, collections are slipping. A business on net 30 where most customers pay on time should see the large majority of its book in the current and 1–30 buckets.

Talk to us

Talk to us about how long you wait to get paid.

Book a free consultation and talk through how this applies to your business. If you have a recent processing statement, bring it along.