What the buckets actually represent.
An AR aging report sorts unpaid invoices by how many days have passed since their due date. Standard buckets are 0-30, 31-60, 61-90, and 90+. The 0-30 bucket is healthy: customers who pay slightly late but reliably. The 31-60 bucket is a watch zone: cash flow planning treats these as conditional. The 61-90 bucket is friction: these need active chasing. The 90+ bucket is impaired: assume 30-50% will never pay without escalation.
The mistake is treating total receivables as one number. $5 million in AR sounds healthy. $5 million broken as 1.5M in 0-30, 800k in 31-60, 600k in 61-90, and 2.1M in 90+ is a fire. Same total, completely different cash trajectory. Always read the aging breakdown before celebrating the total.
Reading aging like a CFO.
Three ratios make the aging report actionable. First, days sales outstanding (DSO): average AR divided by daily sales. Industry benchmark for retail and distribution is 30-45 days. Above 60 is a working capital crisis. Second, percentage in 90+ bucket: under 5% is healthy, 5-10% is concerning, above 10% means systemic collection problem. Third, AR turnover: annual credit sales divided by average AR. Higher is better. Compare against your own history and industry peers.
A worked example: $12 million AR on $90 million annual sales. DSO = 12 / (90/365) = 49 days. AR in 90+ bucket = 1.4 million = 11.7% of total. AR turnover = 7.5x. Diagnosis: collection is the second-biggest cash leak after gross margin. Action: assign an owner to the 90+ bucket, set weekly call quotas, write off $350,000 of confirmed dead invoices to clean the report.
Why customers age into 90+.
There are five reasons an invoice ends up in 90+. First, the customer disputes a quantity, price, or quality issue and you never resolved it. Second, the customer cannot pay due to his own cash crunch. Third, the customer forgot, your reminders were soft, and the invoice slipped under the noise floor. Fourth, the customer is gaming you, paying every supplier at maximum tolerance. Fifth, your contact at the customer left, and the new contact does not recognize the invoice.
Each reason has a different fix. Disputes: investigate, settle, issue credit note. Cash crunch: agree a payment plan in writing, secure with PDC. Forgotten: tighter dunning cadence. Gaming: pricing power conversation, possibly stop supply. Contact change: re-introduce, get fresh PO confirmation. Most SMBs treat all five the same and lose all of them.
Dunning, automated and human.
A dunning sequence is a pre-defined chase ladder. Day 1 past due: friendly reminder email. Day 7: second reminder with statement attached. Day 15: WhatsApp/SMS to the AP contact. Day 30: phone call from the sales rep. Day 45: formal letter from finance. Day 60: legal notice draft shared. Day 75: stop further supply. Day 90: handed to legal or write-off committee. The exact timings vary by industry but the structure is universal.
Nonari runs the first three steps automatically: emails and WhatsApp messages fire on schedule unless the invoice is paid or you pause it. Steps four onward are human, but the tool tracks who owns each escalation. The conversion rate from a structured ladder vs ad-hoc chasing is roughly 2x in the 30-60 bucket and 3x in the 60-90 bucket.
- Day 1 overdue: gentle email reminder.
- Day 7: second email with statement.
- Day 15: WhatsApp/SMS to AP contact.
- Day 30: phone call from sales owner.
- Day 60: formal letter from finance.
When to write off, when to push.
A write-off is an admission that a receivable will not be collected. It removes the asset from the balance sheet and posts a bad debt expense to the P&L. The journal entry is: DR Bad Debt Expense / CR Allowance for Doubtful Accounts (or directly Accounts Receivable for direct write-off). Writing off does not mean you cannot still collect; it just means you stopped pretending the asset is real.
Rule of thumb: anything in 90+ for which there is no payment plan, no recent contact, and no business relationship to preserve, write off after 120 days. Keep the customer in your AR ledger as zero balance with a "written off" flag. If they ever pay, the entry reverses. This is much healthier than letting dead invoices clutter the aging report and make every percentage look worse than reality.
Provisioning vs writing off.
Most SMBs jump straight from "trying to collect" to "complete write-off" with nothing in between. The middle ground is the allowance for doubtful accounts: a contra-asset account that recognizes some receivables will not be collected but does not specify which. A common policy: 1% of 0-30, 5% of 31-60, 25% of 61-90, 50% of 90+. Total expected loss is provisioned via DR Bad Debt Expense / CR Allowance.
When a specific invoice is later confirmed dead, you write it off against the allowance: DR Allowance / CR AR. P&L impact was already taken when you provisioned. This smooths your bad debt expense across periods and matches expense to the period the sale was made, not the period you finally gave up.
Tax treatment of bad debts.
your country’s tax code Section 29 allows a deduction for bad debts written off, subject to conditions. The debt must have been included in income previously (so trade receivables yes, lent money no). The debt must be actually written off in the books in the year claimed. The debt must be such that there is no reasonable prospect of recovery. Documentation matters: legal notices issued, customer absconded, business closed, court decree.
Sales tax has a parallel concept: under Section 9 of the your sales tax law, you can adjust output tax already paid on a bad debt if certain conditions are met (debt over 180 days, written off in books, customer not reachable). Most SMBs miss this and double-suffer: they lose the sale and pay the sales tax. Nonari flags eligible bad debts for sales tax adjustment automatically.
Building a collection culture.
The cleanest aging reports come from sales teams that own collection alongside revenue. If the sales rep gets full commission only when the invoice is paid, not just when it ships, behavior aligns. If credit limits are enforced (no new orders for customers above 60 days overdue), customers self-discipline. If management reviews top 10 overdue weekly with a named owner, accountability sticks.
Most SMBs lose this fight because sales gets paid on shipment, finance owns collection, and the two functions point at each other when an invoice ages past 90 days. A simple commission claw-back on collections under 60 days fixes more bad debt than any dunning software. Use the software for cadence; use compensation for culture.