Receivables Ageing: Reading the Signals Before They Become Bad Debt

A receivables ageing report is one of the simplest and most powerful tools in finance. It groups what customers owe you by how overdue the amount is — and reading it correctly is the difference between healthy cash flow and a chronic bad-debt problem. Here is how to use it as the early-warning system it should be.

What an ageing report shows

The classic format: a list of customers (or invoices) with the amount owed, grouped into ageing buckets based on days past invoice date or due date:

• Current (0 days past due) — paid on time so far, or not yet due
• 1–30 days past due — slipping a bit
• 31–60 days past due — noticeable problem
• 61–90 days past due — serious problem
• 90+ days past due — likely bad debt; needs decisive action

The structure assumes you have defined payment terms for each customer (Net 30, Net 45, etc.) and that "past due" is measured against those terms — not against invoice date.

What healthy looks like

A roughly healthy distribution for most B2B businesses:

• 80%+ in Current — most of your money is on track
• 15% in 1–30 days — normal slippage
• 3–5% in 31–60 days — early warning territory
• Under 2% combined in 61+ days — manageable bad debt risk

Numbers will vary by industry — B2B project work is typically more spread out; FMCG and retail much tighter; service businesses with retainers very steady. The ratios above are a useful default to benchmark against.

What unhealthy looks like

A few patterns to watch for:

• A large 30+ day bucket — your payment terms are not being enforced. Either your invoicing process is broken or you're not following up
• A growing 60+ day bucket month over month — early sign of customer cash-flow trouble (theirs or yours)
• Customer concentration in the late buckets — one or two large customers slipping; high risk
• A specific bucket suddenly larger — usually a process problem (invoices not issued, disputes not resolved)

The bucket sizes are stories. Read them.

When to act on each bucket

A practical escalation:

• Current — no action; just monitor
• 1–30 past due — automated reminder email; possibly a phone call from accounts
• 31–60 past due — sales team gets involved; understand if there's a dispute, a payment schedule, or a problem
• 61–90 past due — senior management escalation; written demand for payment; freeze of new credit
• 90+ past due — collection action, settlement discussion, or write-off

The escalation should be mechanical, not discretionary. The reason ageing reports fail is that everyone has a reason to delay action on every customer — "they're a big customer", "they're temporarily having issues", "we don't want to upset them". The escalation rules should fire regardless.

Customer-specific ageing

Beyond the company-wide view, per-customer ageing is where action happens:

• For your top customers (the 80/20 — see our customer 80/20 post) — ageing reviewed weekly with the account owner
• For B-tier customers — reviewed monthly
• For tail customers — automated rules trigger action without management intervention

The pattern: customers with chronic late payment are a different relationship from customers with occasional slippage. Distinguish them; treat them differently.

The credit-control feedback loop

Ageing data should flow back into credit decisions:

• A customer with persistently late payment should not get extended new credit
• A new customer with no history should have a credit limit until they prove they pay
• A historically prompt payer can be extended more credit without much risk

Without this feedback loop, you over-extend to the wrong customers and under-extend to the right ones.

DSO — the headline number

Beyond the ageing report, the single useful summary metric is Days Sales Outstanding (DSO):

DSO = (Accounts Receivable ÷ Total Credit Sales) × Number of Days

Example: ₹40 lakh receivables, ₹1.2 crore quarterly sales = (40/120) × 90 = 30 days DSO.

If your average payment terms are Net 30, a DSO of 30 means you're collecting exactly on time. DSO of 45 means you're getting paid 15 days later than agreed. DSO of 60+ means you have a problem.

Trend matters more than the absolute number. A rising DSO is the leading indicator of cash-flow trouble.

The provision for doubtful debts

Aged receivables eventually become bad debts. Conservative accounting recognises this before the bad debt crystallises through a provision for doubtful debts:

• A percentage of receivables in each bucket is provisioned (e.g., 1% on 30-day, 5% on 60-day, 25% on 90-day, 100% on 180-day)
• The provision is an expense on the P&L, with a contra-asset on the balance sheet
• When a specific debt is finally written off, it draws against the provision (no further P&L impact)
• Adjustments to the provision happen quarterly or annually as the receivables mix changes

This is conservative accounting that prevents nasty surprises. Without provisions, a sudden write-off hits the P&L all at once; with provisions, the impact is spread as it accrues.

The behaviour change ageing creates

A team that sees their ageing report weekly behaves differently than a team that sees it never:

• Invoices get sent faster (closing the start of the clock)
• Reminders go out automatically at fixed days past due
• Phone calls happen earlier
• Disputes get resolved faster
• New credit decisions are tighter

The mere existence of the report — visible, current, distributed — changes outcomes. The data is necessary but the discipline of looking at it is what works.

How Booksmor helps

Booksmor produces ageing reports at company, customer and invoice level; computes DSO trends; runs automated reminder emails at the buckets you configure; and supports provision for doubtful debts with proper P&L and balance-sheet treatment. The "top 10 overdue" view is on the dashboard, not buried in a report. Start a 30-day free trial and stop letting receivables drift into bad debt.