IFRS 9 ECL Calculator
for Government
Pre-configured for government and public sector entities with tax receivable defaults, intergovernmental receivable considerations, citizen fee receivables, and IPSAS 41 public sector alignment guidance.
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.
Print-ready working paper populated from your calculator data. Includes provision matrix with PY comparison, sensitivity analysis, movement schedule, compliance checklist, and auditor sign-off section.
- ISA 540 compliant structure
- Pre-filled with your calculations
- PDF via browser print (Ctrl+P)
- Engagement header with preparer/reviewer
Complete the calculator above first to generate your working paper.
IFRS 9 ECL Audit Cheat Sheet: free PDF
Simplified approach framework, industry benchmark loss rates for 12 sectors, and forward-looking adjustment guidance. Plus one practical audit insight per week.
No spam. We're auditors, not marketers.
IFRS 9.5.5.15: Simplified approach for trade receivables
IFRS 9.B5.5.35: Provision matrix methodology
IFRS 9.5.5.17: Forward-looking information
IFRS 9.5.5.18: Probability-weighted outcomes
IFRS 7.35H: Movement schedule disclosure
ISA 540: Auditing accounting estimates
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).