Quick answer: What is an accounts receivable aging report?
An accounts receivable aging report lists every unpaid customer invoice sorted by how far past its due date it is, grouped into aging buckets — current, 1–30, 31–60, 61–90, and 90+ days. It answers three questions at once: who owes you, how much, and how late. Read it by checking the total, then the spread across buckets, then the customers behind the oldest balances. BizBooks Pro generates the report from your invoices automatically, so it's accurate the moment you open it.
You had a $61,000 month. Your bank account disagrees. That gap has a name, and it's sitting in one report you may never have opened. The accounts receivable aging report is the list of every dollar you've earned but haven't collected — sorted by how long your customers have been holding it.
It's the most actionable report in small business accounting, and the most neglected. The balance sheet tells you receivables exist. The aging report tells you whose they are, how late they are, and which ones are quietly turning into money you'll never see. This guide covers how to read one, what the shape of yours is telling you, and what to actually do about each bucket.
New to the term? "Accounts receivable" is money customers owe you for work already invoiced. It shows up as a current asset — see our guide to reading a balance sheet for where it sits and why it counts as something you own.
What Is an Accounts Receivable Aging Report?
An accounts receivable aging report — sometimes called an aging schedule or AR aging — takes every open invoice and sorts it by age past the due date. Each invoice lands in a bucket, the buckets get totaled, and the result is a one-page map of your uncollected revenue.
The critical detail people miss: aging counts from the due date, not the invoice date. An invoice you sent 45 days ago on net-30 terms is 15 days overdue and belongs in the 1–30 bucket — not the 31–60 one. Reports that age from the invoice date make every customer look delinquent and train you to ignore the report. The due date is the promise; aging measures the broken promise.
The Aging Buckets, Explained
Nearly every accounting system uses the same five columns. Here's what each one actually means for your business:
| Bucket | What it means | How worried to be |
|---|---|---|
| Current | Invoiced, not yet due | Healthy — this is just business in flight |
| 1–30 days | Slightly late; usually an oversight | Normal, but the cheapest time to act |
| 31–60 days | Late enough to be a choice, not an accident | Worth a real conversation |
| 61–90 days | The invoice has a problem you don't know about | Escalate — find out what's wrong |
| 90+ days | Collection odds drop sharply from here | Decide: pursue hard, settle, or write off |
The rightward drift is the story. An invoice rarely jumps from current to 90+ — it slides one bucket at a time while nobody is looking. Watch the same report weekly and you can literally see money moving right.
An overdue invoice is a loan you never agreed to make, at 0% interest, to a borrower you didn't credit-check.
How to Read an Accounts Receivable Aging Report
Read it in three passes. It takes about five minutes once you know what you're looking at.
Pass 1: What's the total?
The bottom-right number is the cash your customers are holding. Compare it to your bank balance. If receivables are $61,000 and your account has $9,000, you don't have a profitability problem — you have a collections problem, and those have completely different cures. This is also why a profitable business can fail: see how to read a cash flow statement for the mechanics of profit that never becomes money.
Pass 2: How is it spread across the buckets?
A healthy report is front-loaded — most of the balance in current and 1–30, very little past 60. Now compare against last month. If the total is flat but the mix has shifted right, your collections are deteriorating even though the headline number didn't move. That shift is the earliest warning you'll get.
Pass 3: Who's behind the old money?
Scan by customer. You're hunting for concentration: one client holding $14,000 of a $19,000 overdue balance is a fundamentally different situation from twelve clients holding $1,600 each. The first is one difficult phone call and possibly one credit decision. The second is a broken invoicing process — unclear terms, invoices going to the wrong inbox, or no follow-up at all.
What Your Aging Report Is Telling You
Beyond the totals, patterns in the report diagnose specific problems:
- Everything's late by roughly the same amount. Your terms probably aren't the terms your customers are following. If everyone pays on day 45 with net-30 terms, you effectively have net-45 — either enforce it or price for it.
- One customer, consistently in 60+. That's not a payment issue, it's a relationship issue. They may be using you as a credit line, or there's an unresolved dispute you haven't heard about.
- A single old invoice nobody's chasing. Very often the invoice was never received, went to a departed employee, or was disputed silently. Old invoices are frequently misunderstandings, not refusals.
- The 90+ bucket keeps growing. Under accrual accounting, you already booked that revenue. If it's uncollectible, your reported profit is overstated until you write it off.
The Bucket-by-Bucket Collections Playbook
Reading the report is half of it. Here's the follow-up that actually converts the buckets into deposits — matched to how late the money is:
- Current: Do nothing. Chasing an invoice that isn't due yet damages relationships and teaches customers to ignore you.
- 1–30 days: Send a friendly reminder with the invoice attached. Assume it's an oversight, because it usually is. This single step collects more money than everything below it combined — and it's the one most small businesses skip.
- 31–60 days: Pick up the phone. Ask a real question — "did this invoice reach the right person?" — rather than restating the balance. You're looking for the blocker: a missing PO number, an approval sitting in someone's queue, a dispute nobody told you about.
- 61–90 days: Escalate and put terms on the table. A written payment plan you'll actually collect beats a full balance you won't. Pause new work if it's material.
- 90+ days: Make a decision instead of letting it drift. Pursue formally, settle for a partial amount, or write it off. Perpetual hope is the most expensive option — it costs you staff time and an honest set of books.
The prevention beats all of it. Clear due dates on every invoice, deposits on large jobs, and a reminder that goes out automatically at day 5 will do more for your cash than the best collections effort at day 75.
Why the Aging Report Matters Beyond Collections
Chasing invoices is the obvious use, but the report earns its keep three other ways.
It's your cash forecast. The current and 1–30 buckets are your best estimate of near-term deposits — far more reliable than a sales pipeline, because the work is already done and invoiced.
It supports your bad debt estimate. If you report on an accrual basis, GAAP expects you to recognize that some receivables won't be collected. The aging report is the standard basis for that estimate: apply a loss percentage to each bucket, weighted toward the older ones. Our GAAP for small business guide covers when this starts to matter for you.
Lenders ask for it. Apply for a line of credit and the aging report is one of the first documents requested — often alongside the balance sheet and P&L. A clean, front-loaded aging tells a bank your revenue converts to cash. A bloated 90+ column tells them the opposite, no matter what your income statement says.
How BizBooks Pro Handles It
The reason most small businesses don't run an aging report is friction: rebuilding it by hand in a spreadsheet is tedious enough that it happens quarterly at best, which is the same as never.
BizBooks Pro builds the accounts receivable aging report directly from your invoices and payments, so it's accurate the moment you open it — no assembly. Pick an as-of date and it groups every open invoice into the standard current / 1–30 / 31–60 / 61–90 / 90+ buckets, showing each invoice's number, date, due date, and remaining balance under the customer who owes it. Because each customer's email and phone number appear right next to what they owe, the report is a call list, not just a number. You can send a payment reminder by email straight from your books, generate a full customer statement showing every invoice, payment, and credit for that client, and your dashboard flags a growing overdue balance before it reaches the 90-day cliff. Memorize the report once and it's a click away every Monday morning.
It all runs on true double-entry bookkeeping on your own computer, with your customer data in a local database rather than someone else's cloud.
Know Exactly Who Owes You
BizBooks Pro gives you AR aging, customer statements, and one-click payment reminders — on software that lives on your own machine, for one flat annual price with no monthly fee that climbs every year.
Start Free 30-Day Trial Try Live DemoThe Bottom Line
The accounts receivable aging report turns "some customers are slow" into a specific list of names, amounts, and days late — which is the difference between worrying about cash and doing something about it. Run it weekly, read the total, then the spread, then the customers. Act on the 1–30 bucket where a polite reminder still works, and make real decisions about the 90+ bucket instead of hoping. Five minutes a week is a remarkable rate of return on the money you've already earned.
Frequently Asked Questions
What is an accounts receivable aging report?
An accounts receivable aging report is a list of every unpaid customer invoice, sorted by how long it has been outstanding past its due date. Invoices are grouped into aging buckets — typically current, 1–30 days, 31–60 days, 61–90 days, and over 90 days — so you can see at a glance who owes you, how much, and how late they are.
What are the aging buckets on an AR aging report?
The standard buckets are current (not yet due), 1–30 days past due, 31–60 days past due, 61–90 days past due, and 90+ days past due. Each column counts days from the invoice due date, not the invoice date, so an invoice issued 45 days ago on net-30 terms sits in the 1–30 bucket.
How do you read an accounts receivable aging report?
Read it in three passes. First check the total — that's the cash your customers are holding. Second, look at how the total is spread across the buckets; money drifting right toward 60, 90, and 90+ days signals a collections problem. Third, scan by customer to spot concentration, where one client accounts for an outsized share of what's overdue.
How often should you run an AR aging report?
Weekly if you invoice regularly, and always as part of your month-end close. Weekly review means you contact a customer while an invoice is a few days late and easy to fix, rather than discovering it at 75 days when the buyer has forgotten the work and the invoice has gone cold.
What is a good accounts receivable aging report supposed to look like?
A healthy report is front-loaded: the large majority of the balance sits in current and 1–30 days, with very little past 60 days. There's no universal target because terms vary by industry, but the trend matters more than any single snapshot. If each month pushes more of your balance rightward into the older buckets, your collections are slipping even if sales look strong.
Does accounting software generate an AR aging report automatically?
Yes. BizBooks Pro builds the accounts receivable aging report from your invoices and payments, so it's always current — choose an as-of date and it groups every open invoice into the standard buckets, shows each customer's contact details next to what they owe, and lets you send a payment reminder without leaving the report.
Related Articles
- How to Read a Cash Flow Statement: A Small Business Owner's Guide
- The Month-End Close Checklist for Small Business (8 Steps, In Order)
- How to Read a Balance Sheet: A Small Business Owner's Guide
- Cash vs. Accrual Accounting for Small Business: Which Should You Use?
- How to Reconcile a Bank Statement in 6 Steps (Small Business Guide)
- What Is a General Ledger? A Plain-English Guide for Small Business
- GAAP for Small Business: What It Is, Who Actually Needs It, and Why It Matters
- How to Read a Profit and Loss Statement: A Small Business Guide