Overdue Receivables Percentage

Goal of the analysis:

Quantify the share of accounts receivable (AR) that is past due beyond contractual terms and explain why. Overdue Receivables Percentage is a leading indicator of cash risk, collections effectiveness, billing quality, and credit policy adherence. Executives use it to reduce cash trapped in the Order-to-Cash cycle, lower bad-debt risk and borrowing needs, improve customer experience by preventing disputes, and set targets by segment. A rigorous approach defines consistent metrics (overall overdue %, 30+/60+/90+ buckets), normalizes for seasonality and FX, segments by customer/region/channel, attributes drivers (invoice accuracy, disputes, unapplied cash, terms misalignment, collections capacity), and translates overdue dollars into cash and P&L risk.

Data required:

• AR balances and invoice-level detail:
  • AR trial balance and aging by customer/invoice (invoice date, due date, amount, currency, aging bucket, credit memos, write-offs, bad-debt reserves).
  • Unapplied/partially applied cash, chargebacks/deductions, short-pays, promised payment dates.
• Sales and contract terms:
  • Recognized revenue by month (credit sales), billing frequency, milestone/advance terms, early-pay discounts, customer portals/EDI requirements.
  • Contractual payment terms (Net X, stage payments) and exceptions/side letters.
• Collections and dispute management:
  • Collections activity logs (contacts, escalations), dispute tickets and reasons (pricing, tax, quantity, POD), resolution times, write-off approvals.
• Customer master and credit risk:
  • Customer hierarchy (parent/child), industry/segment, region/country, channel (direct/partner/marketplace), key account flags.
  • Credit limits, risk scores/ratings, collateral/LCs, blocked order history.
• Cash application and banking:
  • Remittances, lockbox files, payment methods, auto-match rates, unapplied cash aging.
• Reference and normalization:
  • FX rates/constant-currency policy, fiscal calendar (52/53-week), one-off registry (large settlements/true-ups), intercompany flags.
  • O2C KPIs: order accuracy, invoice timeliness/accuracy, EDI/e-billing adoption, three-way-match exceptions.

Detailed step-by-step instruction on how to conduct the analysis:

1. Define metrics and variants.
   • Overdue AR % (headline) = Past-due AR ÷ Total AR.
   • 30+/60+/90+ Overdue % = AR aged >= bucket ÷ Total AR; also compute as % of credit sales (optional for seasonality control).
   • Average Days Past Due (DPD) and Collection Effectiveness Index (CEI) for context.
   • Exclude VAT/sales taxes and intercompany balances; compute reported and constant-currency views.
2. Extract, cleanse, and reconcile.
   • Pull 18–24 months of monthly AR aging, revenue, and cash receipts; convert to constant currency.
   • Reconcile AR subledger to GL; validate invoice and due dates; tag one-offs and milestones.
3. Calculate headline metrics and cash impact.
   • Compute Overdue AR % (total and by 30/60/90+ buckets) company-wide and by segment (customer tier, region, channel, industry).
   • Translate overdue dollars to cash risk: Cash trapped = Total past-due AR; Interest cost ≈ Cash trapped × borrowing rate.
4. Segment and concentrate.
   • Top-20 overdue customers and their share; overdue concentration for key accounts and channels (e.g., marketplaces, distributors).
   • Compare contractual terms vs actual behavior (days late) to isolate policy vs execution gaps.
5. Aging and behavior diagnostics.
   • Aging pyramids overall and by segment; compute migration rates between buckets (current→30→60→90+).
   • Unapplied cash % of receipts and aging; quantify its contribution to reported past due.
   • Discount capture vs available; short-pay incidence and common reasons.
6. Driver attribution.
   • Dispute rate and Pareto (pricing, tax, quantity, delivery/POD); invoice timeliness/accuracy metrics.
   • Collections coverage and workload (accounts per collector, promise-to-pay adherence).
   • Credit breaches (orders released over limit) and portal/PO setup status for large accounts.
7. Bridge analysis vs prior year/plan.
   • Overdue % bridge: Prior → Terms/mix (BPDSO shift) → Invoice timeliness/accuracy → Disputes/deductions → Unapplied cash → Collections capacity → FX/one-offs → Current.
   • Link to DSO: quantify days driven by past-due buckets; cash impact per 1 pp overdue reduction.
8. Risk overlay and provisioning.
   • Map 90+ day buckets to expected credit loss (ECL) assumptions; estimate incremental bad-debt risk by segment.
   • Identify legal/placement candidates and payment plan opportunities.
9. Forecast and targets.
   • Set targets for headline Overdue %, 90+ %, CEI, and unapplied cash % by segment.
   • Update rolling forecast using collections curves, seasonality, and dispute trends.
10. Integrity checks.
    • Exclude intercompany and tax; ensure milestone AR with secured cash (LC/escrow) is disclosed separately.
    • Align revenue cut-off with invoicing; verify that credit memos/deductions are applied to the correct invoices.

Format of the output of analysis:

• Executive scorecard: Overdue AR % (total; 30+/60+/90+), DPD, CEI, unapplied cash %, cash trapped and interest cost, by segment.
• Aging pyramids and heatmaps: overdue % by customer/region/channel; concentration charts for top overdue accounts.
• Driver panel: dispute Pareto and rates, invoice accuracy/timeliness, collections workload, discount capture, short-pay reasons.
• Bridges: Overdue % bridge vs prior year and vs plan with cash translation; DSO linkage.
• Risk view: 90+day exposure, ECL overlay, write-off trends; payment plan/legal pipeline.

How to interpret results:

• Low overdue % with strong CEI (≥90%) and low unapplied cash: Healthy O2C execution; maintain policies and automate further.
• High 1–30 day overdue with many disputes: Billing accuracy or PO/portal setup issues; fix invoicing and master data before tightening credit.
• High 60+/90+ overdue concentrated in few customers: Elevated credit and write-off risk; escalate with executive outreach, payment plans, or stop-ship controls.
• Overdue inflated by unapplied cash: Cash application bottleneck misstates risk; automate remittance capture and matching.
• Partner/marketplace channels overdue: Check payout schedules, returns/chargeback reconciliation, and data exchange timeliness.
• Seasonal spikes: Use TTM/rolling views; distinguish planned quarter-end sales pushes from structural deterioration.

Steps a company can take to improve on this measure:

• Policy and credit management:
  • Standardize terms by segment; enforce “no ship without PO/portal setup” and credit checks; require collections sign-off for large renewals with aged balances.
  • Set risk-based credit limits, insurance/LCs for high-risk accounts, and stop-ship thresholds for 60+/90+ buckets.
• Billing accuracy and master data:
  • Automate e-invoicing/EDI; pre-validate tax, pricing, bill-to/ship-to; implement first-time-right invoicing KPIs.
  • Align shipment/milestone triggers with contract; reduce manual invoice touches.
• Collections engine:
  • Segment portfolios (risk/size); implement dunning cadences, promise-to-pay tracking, and escalation playbooks.
  • Deploy payment plans for distressed but strategic customers; consider early-pay incentives where APR > borrowing cost.
• Dispute and deduction resolution:
  • Stand up a dispute “squad” with root-cause accountability (pricing, tax, POD); reduce cycle times with SLA and workflows.
  • Tighten returns/chargeback policies and documentation to prevent recurring deductions.
• Cash application automation:
  • Adopt lockbox/OCR/AI remittance matching; aim for touchless auto-apply; reduce unapplied cash <2% of receipts.
• Commercial levers and incentives:
  • Tie a portion of sales compensation to cash (e.g., partial commission on collection); discourage end-of-quarter terms exceptions without finance approval.
• Governance and visibility:
  • Publish weekly overdue dashboards by owner/segment; escalate 60+/90+ with exec reviews; link targets to CFO scorecard.
  • Run quarterly customer terms reviews and clean up chronic exception lists.
• Scenario guidance:
  • If overdue % is 28% with disputes at 15%, fix invoice accuracy (pricing/tax) and mandate PO validation; target −8–10 pts in two quarters.
  • If 90+ bucket is 6% concentrated in top-10 accounts, deploy exec outreach and payment plans; consider stop-ship; target halving 90+ within one quarter.
  • If unapplied cash is 7% of receipts, automate cash app and require remittance formats; aim <2% and −3–5 pts overdue.

Benchmark comparisons:

General benchmarks (directional):

• B2B software/SaaS: Total overdue AR % 10–20% with 90+ at 1–3% for mature programs; enterprise-heavy mixes trend higher without strong EDI/portals.
• Wholesale/Distribution: Overdue 15–25%; 90+ at 2–5% when deductions are well-governed; higher where chargebacks are common.
• Industrial/Manufacturing: Overdue 15–30%; project/milestone billing can increase 60+/90+ if documentation lags.
• Consumer/CPG selling to retail: Overdue 20–35% with deductions; best-in-class keep 90+ ≤3% through tight dispute control.
• CEI: 85–95% indicates strong collections; Unapplied cash <2–3% of monthly receipts is best practice.

Constructing internal benchmarks:

• Build 18–24 month histories of Overdue % (total and 30/60/90+) by BU/region/segment; publish quartiles and targets.
• Set guardrails: total overdue ≤15–20% for mature segments, 90+ ≤2–3% (tiered by customer risk); CEI ≥90%.
• Track migration from 30→60→90+ and dispute cycle times; adopt top-quartile cells as internal targets.
• Reset baselines after terms/policy changes and maintain a one-off registry (large settlements, system cutovers) to preserve comparability.