Provision Matrix
Define aging buckets, enter gross carrying amounts and historical loss rates. Per IFRS 9.B5.5.35.
Forward-Looking Adjustment
Required by IFRS 9.5.5.17. Purely historical rates are not IFRS 9 compliant.
Advanced Features
Optional: probability-weighted scenarios, movement schedule, specific assessment, and entity details.
IFRS 9 ECL Audit Working Paper Template — free PDF
Practical audit guide covering the simplified approach provision matrix methodology, forward-looking adjustment documentation template, probability-weighted scenario framework, IFRS 7.35H movement schedule template, common ISA 540 findings on ECL estimates, and industry benchmark loss rates for 12 sectors.
No spam. Unsubscribe anytime.
IFRS 9 Expected Credit Losses for Government
Government and public sector entities face unique IFRS 9 ECL challenges that differ fundamentally from private sector entities. While many public sector entities apply IPSAS 41 Financial Instruments (the public sector equivalent of IFRS 9) rather than IFRS 9 directly, the ECL methodology is substantially aligned, and the simplified approach provision matrix works identically under both frameworks. The primary challenge is the diversity of receivable types: tax receivables follow unique assessment methods based on taxpayer compliance data, intergovernmental receivables between government entities carry near-zero credit risk, citizen service fee receivables (water, waste, permits) have moderate default rates, and fines/penalties receivables have the highest non-collection risk because the debtors may lack the willingness or capacity to pay. This calculator helps government auditors develop independent ECL estimates for the non-tax receivable components using the provision matrix approach.
Receivable Characteristics — Government
Tax receivables are the largest and most complex category for government entities. They require specialised assessment methods based on taxpayer type (individual vs. corporate), assessment status (self-assessed vs. audit-assessed), and appeal status. Tax receivables are often assessed by the tax authority using statistical models based on historical collection rates by category — this approach aligns with the IFRS 9 provision matrix concept. Intergovernmental receivables (amounts owed by one government entity to another) carry near-zero credit risk assuming both entities are solvent — however, IFRS 9 still requires formal assessment and documentation. Citizen service fee receivables (water/sewerage charges, waste collection fees, building permit fees) behave similarly to utility receivables. Fines and penalties receivables have the highest default rates because the debtor has already demonstrated non-compliant behaviour and may lack the financial resources or willingness to pay.
Forward-Looking Factors
Forward-looking indicators for government ECL depend on the receivable type. For tax receivables, GDP growth and employment forecasts directly affect tax revenue and compliance rates. For citizen service fees, unemployment and household income trends are the primary indicators. For fines receivables, enforcement effectiveness and legislative changes affecting penalty levels or collection powers are relevant. For intergovernmental receivables, the fiscal health of the counterparty government entity matters. The challenge for government entities is that many forward-looking indicators are generated by the government itself (or its statistical agencies), creating a self-referential dynamic that requires careful governance.
Key forward-looking indicators for government:
- GDP growth and tax revenue forecasts
- Unemployment rates (affecting citizen payment ability)
- Tax compliance statistics
- Regulatory/legislative changes affecting collections
- Demographic trends in the jurisdiction
Regulatory and Audit Context
Government auditors (whether internal or external — supreme audit institutions) should apply ISA or equivalent public sector auditing standards to ECL estimates. The key audit challenge is verifying that tax receivable ECL models are appropriately calibrated using historical collection data, that intergovernmental receivables have been assessed (not simply assumed to be zero-risk), and that citizen fee and fine receivables are segmented appropriately. For entities applying IPSAS 41 rather than IFRS 9, the auditor should verify that the ECL methodology is consistent with the IPSAS requirements, which are substantively aligned with IFRS 9 but may have implementation guidance specific to the public sector. Common findings include: overstated tax receivables (gross amounts without adequate ECL provision), assumed zero-ECL for intergovernmental receivables without documentation, and failure to write off uncollectible fines that have passed all enforcement possibilities.
Public sector entities applying IPSAS 41 should follow the public-sector-specific implementation guidance for ECL. Tax receivables typically require specialist assessment methods beyond the standard provision matrix approach.
Worked Example — Municipality of Westport
The Municipality of Westport has €5.2M in non-tax trade receivables comprising citizen service fees (€3.2M), property lease receivables (€1.0M), and fines/penalties (€1.0M). Tax receivables of €28M are assessed separately using the tax authority's statistical collection model. Intergovernmental receivables of €4.5M are assessed at near-zero ECL with documented justification.
| Bucket | Amount | Rate | ECL |
|---|---|---|---|
| Not yet due | €2.800.000 | 0.30% | €8.400 |
| 1–30 days | €1.000.000 | 0.80% | €8.000 |
| 31–60 days | €600.000 | 2.50% | €15.000 |
| 61–90 days | €380.000 | 7.00% | €26.600 |
| 91–180 days | €260.000 | 18.00% | €46.800 |
| 180+ days | €160.000 | 50.00% | €80.000 |
| Total | €5.200.000 | €184.800 |
Forward-looking adjustment factor: 1× applied to all buckets. Rates shown above are adjusted rates (historical × FL factor).