Your aging report is a to-do list in disguise
Every business that extends credit ends up with a pile of unpaid invoices. The question isn't whether some customers will pay late — Atradius found that 43% of the value of U.S. B2B credit sales was overdue in 2025, and 5% was written off entirely. The question is which of those overdue accounts you chase first, and when.
That's exactly what an accounts receivable aging report is built to answer. Used well, it stops being a static accounting document and becomes a prioritized recovery plan. This guide covers what the report shows, how to read its buckets, why the timing matters more than most teams realize, and how to turn it into outreach that actually gets accounts paid.
What is an accounts receivable aging report?
An accounts receivable aging report is a summary of every unpaid invoice you're owed, grouped by how long each one has been outstanding. Instead of one lump "accounts receivable" figure, it breaks your open balances into time-based buckets so you can see the shape of your overdue revenue at a glance.
Most reports use standard aging buckets:
- Current — not yet past due
- 1–30 days past due
- 31–60 days past due
- 61–90 days past due
- 90+ days past due
You can run the report by customer, so you see who owes what in each bucket, or as a company-wide summary that shows how much of your total receivables sits in each stage. Both views matter: the summary tells you how healthy your book is overall, and the customer view tells you exactly who to contact today.
How to read the report
Start at the far-right columns. Balances in the current and 1–30 bucket are normal and mostly healthy — most customers simply haven't reached their due date or are a few days behind. The story you care about is how much money is drifting into the 60-, 90-, and 90+ columns, and whether that drift is getting worse month over month.
Look for concentration, not just totals
A single large invoice sitting in 90+ days is a very different problem from fifty small ones. Sort each bucket by balance so you can see whether your overdue exposure is concentrated in a handful of accounts (a focused phone-and-email problem) or spread across many (an automation problem). The aging report is where you decide which kind of problem you actually have.
Watch the trend line
One aging report is a snapshot. Three in a row is a trend. If the share of receivables in your 61+ buckets keeps climbing, your collections process isn't keeping pace with your billing — no matter how strong this month's revenue looks. Aging also feeds two metrics worth tracking alongside it: your days sales outstanding (DSO) and your accounts receivable turnover ratio. The aging report shows you where the problem is; those ratios show you how fast it's moving.
Why the buckets matter: the cost of waiting
Here's the part that turns an aging report from a bookkeeping habit into a revenue tool. The age of a balance is one of the strongest predictors of whether you'll ever collect it.
Collections-industry benchmarks that have circulated in the accounts-receivable world for years tell a consistent story: an account is highly collectable while it's fresh, but the odds fall sharply as it ages — to roughly 70% collectable at 90 days past due, around 50% at six months, and near 23% after a year. In other words, a dollar in your 1–30 bucket is worth far more than the same dollar in your 90+ bucket, because you're much more likely to actually recover it.
That single fact should reshape how you use the report. The goal isn't to work the biggest balances first, or the oldest ones out of guilt. It's to keep accounts from aging into the low-recovery buckets in the first place — which means acting earliest on the balances that are about to cross a line.
Turn the report into a collections plan
An aging report only creates value when it drives action. The most effective in-house teams assign a specific, repeatable play to each bucket so nothing slips.
Current and 1–30 days: stay friendly, stay automated
These customers usually intend to pay. A light, automated reminder by email or text — a due-date nudge and a gentle follow-up a few days after — clears most of this bucket without a human ever picking up the phone. The tone here is service, not collections.
31–60 days: add urgency and make paying effortless
By now a polite reminder isn't enough on its own. Increase the cadence, switch some outreach to text (which gets read faster than email), and — most importantly — remove friction from the payment itself. If a customer has to call during business hours or mail a check, you've added a reason to delay. A text-to-pay or self-service payment link that settles the balance in a few taps often recovers this bucket on its own.
61–90 days: get a person involved and offer a path
This is the bucket where recovery odds start dropping fast, so it deserves direct, personal contact. Many customers in this range can't clear the full balance at once but will commit to paying over time. Offering a structured payment plan on the overdue account converts a stalled balance into predictable cash — and keeps the relationship intact.
90+ days: decide and document
Everything in this bucket needs a decision: escalate internally, place with an agency, or write it off. Whatever you choose, the aging report is your paper trail. A clean record of every reminder, call, and payment attempt makes the next step — whether that's a final demand or a handoff — faster and defensible.
Building the report — and keeping it current
You can produce a basic aging report from most accounting systems or even a spreadsheet: list open invoices, calculate days past due from each due date, and sort them into buckets. The limitation isn't creating the report — it's that a spreadsheet is out of date the moment you export it, and it doesn't do anything. You still have to read it, decide who to contact, write the messages, and follow up by hand.
That manual gap is where overdue accounts quietly slide from the 30-day bucket into the 90-day bucket while your team is busy with everything else.
From static report to automatic recovery
This is where a purpose-built recovery platform changes the math. Dash keeps your accounts aging in real time and automatically triggers the right outreach for each stage — friendly nudges early, escalating email and text as balances age, and self-service payment options that let customers pay the moment they're reminded. Your team sees every account's status on one dashboard and stays in control, while the routine chasing runs itself. The result is fewer balances reaching the low-recovery buckets, a shorter DSO, and customer relationships that survive the collections process.
Your aging report already tells you where the money is. The teams that recover the most are simply the ones that act on it before the buckets do the deciding for them.
Want to see your receivables age and recover automatically instead of by hand? See Dash in action.


.png)



















.jpg)





















.jpg)





