Customer Aging: The Science of Receivables Management and Provisioning

Customer aging is not just a monthly report printed for the CFO; it is an early-warning system that protects a company’s liquidity from silent collapse. Every unrecovered riyal is a dead riyal that does not fund operations, generate growth, or pay salaries. Mastering accounts-receivable aging is the line between a company that grows in financial health and one that bleeds cash chronically despite its book profits.

This in-depth guide covers: what customer aging is, how it is computed, how it is read, how it translates into a doubtful-debt provision under IFRS 9, and how to build a professional collection cycle that accelerates the conversion of sales into actual cash.

1) The concept and importance of customer aging

Customer aging classifies accounts-receivable balances by the time elapsed since the invoice due date. The longer the duration, the higher the probability of non-collection and the lower the real value of the debt. This classification is the primary instrument for assessing receivables quality and measuring collection effectiveness.

• Liquidity management — accurate forecasting of cash inflows.
• Credit decisions — identifying which customers deserve extended credit.
• Provisioning — the foundation for ECL calculation.
• Sales and collection performance — tying incentives to quality of sales, not just volume.
• Auditor and investor disclosure — evidence of earnings quality.

2) Aging buckets and how they are computed

Aging is computed at the invoice level (invoice-level aging), not at the aggregate balance level. This distinction is critical because a total balance can mask the fact that part of it is very old even if the customer is paying recent invoices on time.

3) Reading an aging report as a finance leader

• % of balances over 90 days: if it exceeds 10% of total receivables, it is a serious red flag.
• Concentration risk: a single customer over 20% of receivables creates dependency risk.
• Trend across months: direction matters more than absolute level.
• Gap between aging and contract age: a 120-day invoice with a 30-day customer is a clear breach.
• Inactive receivables: usually signal an unresolved commercial dispute.

4) DSO and what it tells you

Days Sales Outstanding measures the average number of days the company takes to collect credit sales:

A healthy company keeps DSO close to its credit terms. If your terms are net-30 but actual DSO is 75 days, you are financing your customers with 45 extra days at your liquidity’s expense. Every day added to DSO ties up working capital equal to one day of sales.

5) Expected Credit Loss under IFRS 9

IFRS 9 mandates the Expected Credit Loss (ECL) model instead of the older “incurred loss” approach. The company must record a provision from day one based on expected future losses, rather than wait for them to occur.

1. Build a provision matrix per aging bucket using historical loss data.
2. Apply provision rates to each bucket balance in the aging report.
3. Adjust the rates with forward-looking information (macroeconomics, customer sector).

6) Credit policy and trading limits

• Credit assessment of new customers — registry check, financial statements, market reputation.
• Credit limit enforced automatically by ERP on new invoices.
• Clear contractual payment terms, late penalties, right to suspend supply.
• Collateral for large customers (cheques, bank guarantees, liens).
• Periodic review of limits—raised for disciplined customers, lowered or suspended for delinquents.

7) The collection cycle

1. 7 days before due date — friendly automated reminder (SMS/email).
2. On due date — formal due notice.
3. 1–15 days late — phone call from collections.
4. 16–30 days late — formal warning and credit hold.
5. 31–60 days late — escalation to customer senior management.
6. 61–90 days late — legal warning through counsel.
7. Over 90 days — litigation or specialized collection agency.

8) Writing off bad debts

• All reasonable legal action exhausted.
• Rationale documented in formal minutes.
• Write-off approved by the competent authority (board level for large debts).
• Entry: Dr Allowance for doubtful debts, Cr Accounts receivable.

For ZATCA purposes, deductibility from the zakat/tax base typically requires evidence that all legal avenues have been exhausted and formally documented.

9) ERP tools for managing aging

• Dynamic aging reports with multiple filters (customer, branch, salesperson, segment).
• Visual dashboards — DSO trend, aging distribution, top-10 delinquent customers.
• Automated alerts on credit-limit or aging-threshold breaches.
• Automatic ECL provisioning engine refreshed monthly.
• Integrated collection workflow — automated messages, call logging, promise-to-pay tracking.
• Payment-gateway integration — direct pay links inside invoices.

10) Worked case study

A mid-sized trading company with net-30 credit terms, total receivables SAR 5,000,000, annual credit sales SAR 30,000,000. Reporting date: 31 December.

• % over 90 days = 8% — within acceptable range.
• DSO ≈ (5,000,000 ÷ 30,000,000) × 365 = 60.8 days vs 30-day terms → gap of 30.8 days.
• Each extra DSO day = SAR 30,000,000 ÷ 365 ≈ SAR 82,191 trapped.
• Required ECL provision = SAR 269,000 — compare with current balance and post the difference.

11) DSO, BPDSO, CEI and ADD

• BPDSO (Best Possible DSO): the lowest DSO achievable if all current receivables were collected on time. The gap between DSO and BPDSO reveals real delinquency.
• CEI (Collection Effectiveness Index): measures the share of due receivables actually collected in the period — target > 85%.
• ADD (Average Days Delinquent): DSO − BPDSO, isolating the genuine lateness.
• Roll Rate: the percentage of balances that migrate from one aging bucket to the next each month — rising roll rate is an early warning.

12) Re-engineering the Order-to-Cash cycle

1. Credit screening before order acceptance — system rejects orders that breach the limit.
2. Invoice speed — each day delayed in issuing the invoice equals a day delayed in collection.
3. Invoice accuracy — the leading reason for late payment is invoice disputes.
4. Multiple payment channels — pay links, Mada, Apple Pay, bank transfer embedded in the e-invoice.
5. Proactive collection — a 7-day pre-due reminder lifts on-time collection by 25–40%.
6. Fast dispute resolution — clear workflow to resolve disputes within five days.
7. Sales-team alignment — link salesperson incentives to customer DSO, not just sales volume.

Key performance indicators

FAQ