Accounts Receivable Aging Report: Meaning, Format & Analysis | LearnEdition
learnedition.com
Accounting & Financial Reporting Guide
The Accounts Receivable Aging Report
Every unpaid invoice has an age. This one report tells you, at a glance, how old your company's money is — and exactly how worried you should be about getting it back. Here's how to read it, build it, and use it, explained for students, investors, accountants, and business owners alike.
0–30 daysCurrent
31–60 daysWatch
61–90 daysOverdue
90+ daysCritical
Hover each band — this is the exact structure almost every aging report in the world is built on.
01 What Is an Accounts Receivable Aging Report?
Before defining the report, it helps to define the thing it tracks.
Definition — Accounts Receivable (AR)
Accounts Receivable is the money a business is owed by its customers for goods or services it has already delivered, but for which cash hasn't been collected yet. It sits on the balance sheet as an asset, because it represents a future inflow of cash — but only if the customer actually pays.
Definition — Accounts Receivable Aging Report
An Accounts Receivable Aging Report (sometimes called an AR aging schedule) is a table that lists every unpaid customer invoice and sorts it into time buckets based on how many days it has been outstanding — typically 0–30, 31–60, 61–90, and 90+ days. It converts a single balance sheet number ("Accounts Receivable: $500,000") into a detailed map of exactly whose money it is, and how stale it has become.
Think of it like the "best before" system on a refrigerator shelf. A single number telling you "you have 40 items of food" tells you almost nothing about whether you should be worried. But sort those same items by how many days they've sat there, and suddenly you know which ones need eating tonight and which ones need throwing away. An aging report does exactly that with money instead of milk — the older an unpaid invoice gets, the more it starts to smell like a loss rather than an asset.
This report exists because not all receivables are equal. A $10,000 invoice raised eight days ago is a completely different animal from a $10,000 invoice raised 140 days ago. The first is simply normal business — most customers pay within their credit terms. The second is a warning light. Statistically, the older a receivable gets, the less likely it is to ever be collected at all; a widely cited industry rule of thumb is that a debt aged past 90 days has roughly a 1-in-4 chance of eventually being written off completely, and past 180 days, the odds get considerably worse. The aging report is simply the tool that turns "we are owed money" into "we are owed money, and here is exactly how nervous to be about each piece of it."
Key terms you'll need
Term
Invoice Date
The date a bill was issued to the customer — the starting point most aging reports count from.
Term
Due Date
The date payment is contractually owed, based on the agreed credit terms (e.g. "Net 30" means due 30 days after the invoice date).
Term
Days Past Due (DPD)
The number of days that have elapsed since an invoice's due date without payment. This is what determines which bucket an invoice falls into.
Term
Aging Buckets
The fixed time bands — usually 30-day increments — used to group outstanding invoices by age.
Term
Bad Debt / Doubtful Debt
A receivable judged unlikely to ever be collected, and written off or provisioned against in the accounts.
Term
Days Sales Outstanding (DSO)
The average number of days a company takes to collect payment after a sale — a summary metric derived from the aging data.
02 Why This Report Matters — To Everyone
Unusually for a piece of accounting paperwork, this particular report is read closely by four very different audiences, each for a different reason.
For Students
The bridge from theory to practice
Textbooks teach "accounts receivable" as one number in a T-account. The aging report is where that number becomes real: it's the working document behind the "allowance for doubtful accounts" entry every intermediate accounting course covers, and it's a favourite exam and case-study topic because it combines bookkeeping, ratio analysis, and business judgment in one artifact.
For Investors
A quiet truth-teller
Revenue and profit can be dressed up with aggressive recognition policies. Receivables aging is harder to fake — a rising share of invoices stuck in the 90+ bucket, quarter after quarter, is one of the more reliable early signs that a company's reported revenue is outrunning its actual cash collection, which is exactly the pattern behind several well-known accounting scandals.
For Accountants
The basis for a required estimate
Under both IFRS (through the expected credit loss model) and US GAAP, a company must estimate and provision for receivables it doesn't expect to collect. The aging report is the standard working paper used to build that estimate, often by applying a historical loss percentage to each bucket.
For Business Owners
A daily cash-flow instrument
Profit is an opinion; cash is a fact. A business can be profitable on paper and still run out of cash if its receivables age too long. Owners use this report to decide who to call this week, who to put on credit hold, and how much cash to actually expect in the next 30 days.
03 The Format: What an Aging Report Looks Like
Despite the different software packages that generate it — spreadsheets, ERP systems, accounting platforms — the format is almost universal worldwide. It's a grid: customers (or invoices) down the side, aging buckets across the top.
Below is a simplified, illustrative aging report for a fictional company, Meridian Textiles Pvt Ltd, as of the last day of a reporting month. Amounts are shown in a generic currency unit so the structure is what matters, not the denomination.
Customer
Total Due
Current (0–30 days)
31–60 days
61–90 days
90+ days
Bright Harbor Retail
42,000
42,000
–
–
–
Coastal Hardware Group
28,500
18,500
10,000
–
–
Danvers & Co. Distributors
61,200
20,000
15,200
26,000
–
Everline Apparel
15,000
–
–
–
15,000
Farrow Home Goods
33,800
33,800
–
–
–
Grantline Uniforms Ltd
19,500
4,500
–
–
15,000
Total
200,000
118,800
25,200
26,000
30,000
% of Total
100%
59.4%
12.6%
13.0%
15.0%
Reading across a single row (Danvers & Co.) tells a story on its own: of the 61,200 owed, a chunk is fresh, a chunk is a month old, and a worrying 26,000 has drifted into the 61–90 day band — this is one customer to call today, not next week. Reading down the columns tells the company-wide story: roughly 60% of everything owed is still current and healthy, but 28% has crossed the 60-day line, which is where collection risk starts rising sharply.
Detail-level vs. summary-level reports
Most accounting software can generate this report at two depths. A detail-level aging report lists every single unpaid invoice individually (useful for the collections team calling specific customers about specific invoices). A summary-level aging report rolls everything up by customer, as shown above (useful for management review and financial reporting).
Aging by invoice date vs. aging by due date
There's one format decision that trips up almost everyone new to this report: should the "clock" start on the invoice date, or on the due date? Both conventions are used worldwide, and they produce very different-looking reports for the same underlying data.
Aged by invoice date: the buckets simply count days since the invoice was raised, ignoring credit terms. Simple, but can make a perfectly on-time customer with 45-day terms look "31–60 days" overdue when they aren't overdue at all.
Aged by due date: the buckets count days past the agreed due date. An invoice with 45-day terms only starts aging on day 46. This is the more analytically useful convention, because the "Current" bucket then genuinely means "not yet late," and every other bucket genuinely means "late by that many days."
When reading any aging report — as a student, investor, or manager — the very first question to ask is which convention was used, because it changes what the numbers mean.
Same invoice, same "today" — two different aging conventions produce two different stories.
04 A Real-Time Example, Walked Through
Numbers are easier to trust once you've walked through what they actually mean in a live business.
Sunrise Office Supplies, a mid-sized B2B stationery distributor, closes its books at the end of June with total accounts receivable of $500,000, owed by around 90 active business customers on 30-day credit terms. Its aging report (aged by due date) looks like this:
Bucket
Amount
% of Total
Reading
Current (not yet due)
350,000
70%
Healthy — this is money simply in transit within normal terms.
1–30 days late
75,000
15%
Normal friction — some customers always pay a little late.
31–60 days late
40,000
8%
Needs a phone call — this is the point to start following up personally.
60+ days late
35,000
7%
High risk — evaluate for collections action or provisioning.
Total AR
500,000
100%
—
On its own, "$500,000 in receivables" is a neutral, even reassuring, number — it implies strong sales. But once aged, the picture sharpens: 85% of that balance is either current or only mildly late, which most trade-credit benchmarks would call a comfortable position. The concerning slice is the 7% — $35,000 — sitting more than 60 days past due. Sunrise's controller would typically now do three things: (1) pull the detail-level report to see exactly which customers make up that $35,000, (2) check whether it's concentrated in one or two accounts (concentration risk) or spread thinly across many (more likely just normal churn), and (3) decide whether any of it needs to move into a bad debt provision this month.
Quick DSO Check
If Sunrise's average daily credit sales are $9,500, its Days Sales Outstanding is 500,000 ÷ 9,500 ≈ 52.6 days. Against 30-day terms, that means customers are, on average, taking over three weeks longer to pay than the terms allow — a useful single number to track month over month, even though the bucket-level detail above is what tells you exactly where that slippage is coming from.
05 A Real Story: When Nobody Was Reading the Report
Case Study — Design & Branding Agency, Bengaluru
Kavi's Near Miss
Kavi ran a small branding studio that had grown from a one-person freelance operation into a 14-person agency within three years. Business was, by every visible measure, booming: the client roster had tripled, monthly invoicing had gone from $8,000 to $95,000, and the studio had just signed its biggest client yet — a retail chain that wanted a full rebrand across 40 stores.
What Kavi didn't watch closely was the aging report her bookkeeping software quietly generated every month. The big retail client was slow to pay from the very first invoice — first 45 days late, then 70, then 110 — but because the studio kept billing new milestones every month, the top-line revenue number kept climbing, masking the fact that an ever-larger share of that revenue was simply not turning into cash. By month five of the relationship, that single client accounted for 60% of the studio's entire outstanding receivables, almost all of it sitting in the 90+ day bucket.
The crunch arrived the week payroll was due. Kavi had the invoices to prove $210,000 in sales that quarter — but only $40,000 of actual cash in the bank, most of it already earmarked for rent and software subscriptions. She had to delay a payroll run by four days while a very uncomfortable phone call finally got 25% of the overdue balance released.
The studio survived, but the fix that followed was simple and permanent: every Friday, Kavi now opens the aging report first, before anything else. A written policy went up — a friendly reminder at 30 days, a phone call at 45, a formal notice at 60, and no new work approved for any client sitting in the 90+ bucket, however prestigious. The following year, with revenue slightly lower but far more evenly collected, the studio never came within two weeks of a cash crunch again.
The lesson Kavi's story illustrates is one that shows up in businesses of every size, everywhere in the world: revenue is an opinion until it's collected — the aging report is where you find out how good that opinion really is.
06 How to Analyze an Aging Report
Reading the raw table is step one. The real value comes from turning it into a small set of ratios and trends that can be tracked over time.
1. Days Sales Outstanding (DSO)
The single most-quoted receivables metric. It answers: "On average, how many days does it take us to collect payment after a sale?"
DSO = (Accounts Receivable ÷ Total Credit Sales) × Number of Days in Period
Lower is generally better, but DSO must always be compared against a company's own credit terms and its industry — a DSO of 55 days is a problem for a company offering Net 30, but perfectly normal for one offering Net 60.
2. Percentage current vs. percentage overdue
The simplest, fastest read of the whole report: what share of total receivables sits in "Current," versus what share has crossed into the overdue buckets. A healthy business-to-business company typically keeps 80–90% of its receivables current; anything meaningfully below that deserves a closer look.
3. Collection Effectiveness Index (CEI)
A more refined measure of how well a company's collections process is actually working, comparing what was collectible in a period against what was actually collected.
CEI = [(Beginning AR + Credit Sales − Ending Total AR) ÷ (Beginning AR + Credit Sales − Ending Current AR)] × 100
A CEI close to 100% indicates a near-perfect collections process; anything meaningfully below 80% suggests collections effort is falling behind new sales being generated on credit.
4. Trend analysis across buckets
A single month's aging report is a snapshot. The real signal comes from lining up three, six, or twelve months side by side and watching how the same dollars move between buckets. If the 90+ bucket is quietly growing as a percentage of total AR, month after month, that's a structural collections problem, not a one-off. If it spikes for one month and then returns to normal, it's more likely a single delayed customer.
The aging report is only the starting point — its value comes from the ratio and trend analysis, and the escalation ladder, that follow.
07 Red Flags & Best Practices
Red flags to watch for
Concentration
One customer, most of the risk
If a single customer accounts for a large share of the 90+ bucket, the company's cash position is hostage to one relationship.
Drift
The oldest bucket keeps growing
A steadily rising 90+ percentage over several periods, even while revenue looks fine, points to a collections process that isn't keeping up.
No write-offs
Suspiciously clean books
A company that never writes off any bad debt, ever, despite an aging report full of ancient balances, is likely understating its losses rather than genuinely collecting everything.
Reconciliation gap
Aging doesn't match the ledger
If the total on the aging report doesn't tie out to the receivables balance on the general ledger, something is being missed, double-counted, or manipulated.
Best practices
Review on a fixed cadence. Weekly for the collections team, monthly for management and ownership — never only at year-end.
Tier the response by age, not by relationship comfort. A friendly reminder at 30 days, a call at 45–60, a formal notice at 60–90, and a hard decision — collections agency or write-off — beyond 90–120.
Tie credit limits to aging history. A customer who reliably drifts into the 60+ bucket should see tighter terms or a lower credit limit going forward, regardless of order size.
Automate it. Virtually every modern accounting platform generates this report natively; the constraint is rarely the software, it's whether anyone actually opens it regularly.
08 Common Mistakes to Avoid
Mistake 1
Aging every invoice from its invoice date while ignoring varied credit terms — this makes customers on longer terms look artificially overdue and hides genuinely late ones on shorter terms.
Mistake 2
Ignoring partial payments and credit notes, so the "amount due" shown in a bucket no longer matches what's actually still owed.
Mistake 3
Treating every customer identically regardless of size — a $500 balance sitting at 95 days deserves far less attention than a $95,000 balance sitting at 61 days.
Mistake 4
Never reconciling the aging report total back to the general ledger receivables balance, letting small discrepancies compound unnoticed.
08b A Global Perspective: Does This Report Look the Same Everywhere?
Because this guide is read by students, accountants, and business owners across very different economies, it's worth addressing directly: does an aging report in Lagos look like one in London, or Manila, or São Paulo?
The structural answer is yes — the 30-day bucket convention is close to a universal language in trade credit, largely because most accounting software is built around it regardless of where it's sold. What genuinely differs from market to market is the context surrounding those buckets.
Typical credit terms vary by region and sector. Net 30 is common in North America and much of Europe for many B2B relationships, while Net 60 or Net 90 is far more typical in parts of Asia, Latin America, and in industries like construction or government contracting almost everywhere. A "60-day" bucket that looks alarming under Net 30 terms may simply represent a customer paying exactly on time under Net 90 terms.
Currency and inflation context matters for investors. In economies with high inflation, a receivable that ages even a modest 60–90 days can lose real purchasing-power value simply by sitting unpaid, independent of any collectability risk — a nuance that pure DSO figures don't capture on their own.
Legal enforceability of debt differs by jurisdiction. How quickly and cheaply a business can pursue a genuinely delinquent customer through small-claims processes, factoring arrangements, or formal collections varies enormously across countries, which in turn shapes how aggressively companies in different markets tend to manage the 60+ day buckets.
Reporting standards converge, even if practice doesn't. Whether a company reports under IFRS (used across most of Europe, much of Asia, and large parts of Africa and Latin America) or US GAAP, the underlying requirement — estimate expected losses on receivables — is conceptually the same, and the aging report remains the standard working tool for that estimate under both frameworks.
The practical implication for anyone reading an aging report — a student analyzing a case study, an investor comparing two companies, or an accountant benchmarking performance — is the same: never judge a bucket in isolation. Always ask what the underlying credit terms were, what industry and country the business operates in, and what "normal" genuinely looks like in that specific context before deciding whether a number is healthy or alarming.
09 Test Yourself: 10-Question Quiz
Answer all ten, then check your score. The full answer key is also listed at the end for reference.
Answer Key
1. B — Unpaid customer invoices, by age
2. C — 0–30 / 31–60 / 61–90 / 90+
3. B — Clock starts after terms expire
4. A — Average days to collect payment
5. D — Possible collectability concern
6. C — Supports bad-debt allowance estimate
7. B — Measures collections effectiveness
8. A — Pull the detail report first
9. C — Concentration in oldest bucket
10. D — Growth masked a tracked-nothing overdue problem
11. B — Judge DSO against terms/industry
Key Takeaways
An aging report turns one receivables number into a map of exactly whose money it is, and how old.
The standard structure is 30-day buckets: Current, 31–60, 61–90, and 90+ days.
Aging "by due date" is more analytically meaningful than aging "by invoice date."
DSO, % current, and the Collection Effectiveness Index turn the raw table into trackable metrics.
A growing, concentrated overdue balance is one of the most reliable early warning signs in business — for owners and investors alike.
10 Frequently Asked Questions
Yes. "Aging report," "aging schedule," and occasionally "aging summary" all refer to the same document — a breakdown of outstanding customer invoices by how long they've been unpaid. The naming varies by region and software vendor, not by substance.
They mirror each other but track opposite directions of cash flow. An AR aging report tracks money customers owe the company (an asset). An AP aging report tracks money the company owes its own suppliers (a liability). Both use the same bucket structure, applied to opposite sides of the balance sheet.
Most collections teams pull it weekly, while management typically reviews a summarized version monthly, alongside the rest of the management accounts. Waiting until year-end review is generally considered too infrequent to catch problems while they're still manageable.
There's no single universal number — a good DSO is one reasonably close to the company's own stated credit terms. A company offering Net 30 with a DSO of 33–38 days is performing well; the same DSO would be excellent for a company offering Net 60. Industry benchmarks (retail vs. construction vs. professional services, for instance) also vary widely.
Yes — virtually every modern accounting or ERP platform generates an aging report natively from existing invoice and payment data, usually exportable to spreadsheet formats. The challenge in most businesses isn't producing the report; it's building a habit of actually reviewing it regularly.
Neither IFRS nor US GAAP explicitly mandates the specific document, but both frameworks require companies to estimate expected credit losses or doubtful accounts on their receivables — and the aging report is the standard working paper accountants use to build that required estimate.
Typically yes, until it's formally resolved, credited, or written off — the invoice remains open in the accounting system and will keep aging. Many companies flag disputed invoices separately within the report so they aren't confused with genuinely uncollected, undisputed debt.
Absolutely — the same logic scales down cleanly. Even a solo freelancer with five active clients benefits from knowing which invoices are current versus stale, since late-paying clients are exactly as capable of causing a cash crunch for an individual as for a large company.
There's no fixed universal rule, but many companies begin formally provisioning for a portion of a balance once it passes 90 days overdue, and consider a full write-off once collection attempts have been exhausted — often somewhere between 120 and 180 days, depending on internal policy and the size of the balance.
Generating it faithfully every month but never actually acting on it — treating it as a filing exercise rather than a live management tool. The report only creates value when it changes behavior: a call made, a credit limit tightened, a provision booked.
