Quick answer: What does an accounts receivable aging report tell you?
An accounts receivable aging report ranks every unpaid invoice by how overdue it is, sorting them into brackets — not yet due, 1–30, 31–60, 61–90, and 90+ days late. It reveals in one page who is holding your money, how much, and for how long. Work through it in three looks: the total, the spread across brackets, then the customers behind the oldest balances. Kantivo assembles the report from your invoices automatically, so it's live whenever you open it.
The sales figure says you're winning. The bank balance says otherwise. Both can be true at the same time, and there's exactly one report that explains the contradiction. An accounts receivable aging report catalogues every dollar you've invoiced but not banked — arranged by how long your customers have been holding onto it.
Almost nothing else in your books is this directly useful. A balance sheet confirms that receivables exist; the aging report names the people, attaches the amounts, and counts the days. Here's how to read one, what your particular report is diagnosing about your business, and the response each bracket actually deserves.
Unfamiliar term? "Accounts receivable" is simply money customers owe you for invoices already issued. It appears among your current assets — our guide to reading a balance sheet explains why an unpaid invoice counts as something you own.
What an Accounts Receivable Aging Report Actually Is
Take every open invoice, measure how far past its due date it has travelled, drop it into the matching bracket, and total the columns. That's the whole construction. The output is a single page mapping your uncollected revenue by age.
One detail decides whether the report is useful or noise: the clock starts at the due date, not the invoice date. Send an invoice on net-30 terms and check back on day 45 — it's 15 days late, so it belongs in the 1–30 bracket. Systems that age from the invoice date paint your entire customer base as delinquent, which teaches you to stop trusting the report. What you're measuring isn't elapsed time; it's the distance past a promise.
Reading the Brackets
The same five columns turn up in virtually every accounting package. What they mean in practice:
| Bracket | What's really going on | Your temperature |
|---|---|---|
| Current | Issued, still within terms | Fine — ordinary business in motion |
| 1–30 days | Mildly late; nearly always forgetfulness | Routine — and the cheapest moment to act |
| 31–60 days | Too late to be an accident — it's a decision | Time for an actual conversation |
| 61–90 days | Something is wrong and nobody told you | Escalate and find the blocker |
| 90+ days | Recovery odds fall away sharply | Choose: press, settle, or write it off |
The migration is the real narrative. Invoices don't leap from current to 90+ — they inch one column right while your attention is elsewhere. Look at the same report every week and you'll watch the money walk.
A late invoice is an unsecured loan you never agreed to issue, charging no interest, to a borrower nobody credit-checked.
Three Looks That Take Five Minutes
Look one: how big is the total?
The figure in the bottom corner is revenue sitting in your customers' accounts rather than yours. Set it beside your bank balance. Receivables of $61,000 against $9,000 in the bank isn't a profit problem — it's a collection problem, and the two have nothing in common as far as remedies go. It's precisely how a profitable company runs out of money; our piece on reading a cash flow statement traces that gap in detail.
Look two: where is the balance sitting?
You want it stacked on the left — current and 1–30 heavy, the far columns nearly empty. Then hold it up against last month's. An unchanged total whose composition has shifted rightward means your collections are eroding while the headline number hides it. That drift is the earliest signal you'll ever get.
Look three: who owns the old balances?
Sort by customer and hunt for concentration. One client responsible for $14,000 of a $19,000 overdue pile is a completely different animal from twelve clients at roughly $1,600 apiece. The former is a single awkward call and maybe a credit decision. The latter says your process is leaking — vague terms, invoices landing in the wrong inbox, or nobody following up at all.
What the Shape of Your Report Diagnoses
Patterns in the columns point to specific, fixable causes:
- Uniform lateness across the board. Your stated terms aren't the operating terms. If everybody pays around day 45 on net-30, you're running net-45 — enforce it or price it in.
- The same customer parked in 60+ every month. That's a relationship signal, not an accounting one. You're either their unofficial credit line or there's a dispute you've never been told about.
- One ancient invoice nobody has touched. Usually it never arrived, went to someone who left the company, or was quietly contested. Old invoices are far more often confusion than refusal.
- A swelling 90+ column. On an accrual basis that revenue is already recorded. If it's never coming, your reported profit is inflated until you write it off.
What to Do, Bracket by Bracket
Reading the thing is only half the job. Match your response to the age of the money:
- Current: Leave it alone. Chasing invoices before they're due strains relationships and teaches customers to tune you out.
- 1–30 days: A warm reminder with the invoice attached. Treat it as an oversight, because it nearly always is. This one habit recovers more cash than everything further down the list combined — and it's the step small businesses most often skip.
- 31–60 days: Call them. Ask something genuine — "did this land with the right person?" — rather than reciting the balance back at them. You're searching for the obstruction: an absent PO number, an approval stuck in a queue, an objection never voiced.
- 61–90 days: Escalate, and put structure on the table. An instalment plan you'll genuinely collect beats a full balance you won't. If the sum is significant, stop starting new work.
- 90+ days: Decide rather than drift. Pursue it properly, accept a partial settlement, or write it off. Indefinite optimism is the priciest option available — it burns your time and corrupts your books.
Prevention outperforms all of it. Unmissable due dates, deposits on big jobs, and an automatic nudge on day five will protect your cash better than heroic collections work at day seventy-five.
The Uses Nobody Mentions
Collections are the obvious payoff. The report quietly does three more jobs.
It forecasts cash. Your current and 1–30 columns are the most credible prediction of near-term deposits you own — considerably better than a sales pipeline, since the work is finished and billed.
It underpins your bad-debt estimate. Report on accrual and GAAP expects you to acknowledge that a slice of receivables won't arrive. The aging report is the conventional foundation: apply a loss rate per bracket, heavier on the older ones. Our GAAP for small business guide covers when this becomes your concern.
Lenders want to see it. Ask a bank for a credit line and the aging report is among the first things requested, usually alongside your balance sheet and P&L. A tidy, left-weighted report says your revenue reliably becomes cash. A fat 90+ column says the opposite, no matter how good the income statement looks.
How Kantivo Does the Work
The reason so few small businesses run this report is friction. Rebuilding it by hand in a spreadsheet is dull enough that it happens once a quarter — which is functionally never.
Kantivo constructs the accounts receivable aging report straight from your invoices and the payments applied to them, so it's accurate the second you open it. Choose an as-of date and every open invoice sorts itself into current, 1–30, 31–60, 61–90, and 90+, listing invoice number, issue date, due date, and outstanding balance beneath the customer responsible. Each customer's email and phone sit right beside what they owe, which quietly turns the report into a call sheet. From there you can email a payment reminder directly out of your books, produce a full customer statement covering every invoice, payment, and credit on that account, and your dashboard raises a flag when the overdue balance grows — well before anything reaches the ninety-day cliff. Memorize the report once and it's one click away each Monday.
All of it rests on proper double-entry bookkeeping, running on your own machine, with your customer list held in a local database instead of somebody else's cloud.
See Exactly Who's Sitting on Your Cash
Kantivo brings you AR aging, customer statements, and one-click payment reminders — on software that runs on your own computer, for one flat annual price with no monthly fee ticking away.
Start Free 30-Day Trial Try Live DemoThe Takeaway
An aging report converts the vague worry that "some customers are slow" into names, figures, and day counts — which is the entire distance between fretting about cash and fixing it. Run it weekly. Read the total, then the spread, then the names. Move on the 1–30 bracket while a courteous reminder still does the job, and make honest decisions about the 90+ column instead of quietly hoping. Five minutes a week is an extraordinary return on money you've already earned.
Frequently Asked Questions
What does an accounts receivable aging report show?
It shows every invoice your customers haven't paid yet, ranked by how far past due each one is and grouped into age brackets — not yet due, 1–30 days late, 31–60, 61–90, and beyond 90. In one page you learn which customers are sitting on your money, how much of it, and how long they've had it.
What do the aging buckets mean?
Current means the invoice hasn't reached its due date. The 1–30 bracket is usually forgetfulness. 31–60 means someone made a decision not to pay yet. 61–90 typically hides a problem you haven't been told about. Past 90, the chance of collecting falls off steeply. Every bracket measures days beyond the due date, never days since the invoice was written.
How should I analyse my AR aging report?
Three looks. The grand total tells you how much of your revenue is parked with customers instead of in your bank. The distribution across the brackets tells you whether that money is moving toward you or away from you. The customer-level view tells you whether it's one difficult account or a systemic invoicing weakness.
How frequently should the aging report be reviewed?
Once a week if invoicing is a regular part of your business, plus once more when you close the month. Weekly cadence lets you nudge a customer while the invoice is only days late and the work is fresh in their mind — which is when a reminder still works.
What does a healthy aging report look like?
Weighted heavily toward the left: nearly all of the balance in current and 1–30, thin columns beyond 60 days. Industries differ too much for a universal benchmark, so read the direction rather than the snapshot. Balance creeping steadily into older brackets month after month means collections are weakening, whatever your sales figures say.
Can Kantivo produce an aging report for me?
It does it for you. Kantivo assembles the aging report live from your invoices and the payments applied against them — set an as-of date and every open invoice drops into the right bracket, with the customer's phone and email shown beside the balance so you can email a reminder or produce a full statement without leaving your books.
Related Articles
- How to Read a Cash Flow Statement (And Find Out Where Your Profit Went)
- How to Close Your Books Every Month: A Small Business Month-End Routine
- How to Read a Balance Sheet (Without an Accounting Degree)
- Cash Basis or Accrual Basis? A Small Business Owner's Guide to Picking the Right Method
- How to Reconcile a Bank Statement (Without Losing an Evening)
- What Is a General Ledger? (And Why Every Report Starts There)
- GAAP for Small Business, Explained: What the Rules Say and When They Start to Matter
- How to Read a Profit and Loss Statement (No Accounting Degree Needed)