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 Banking
This calculator implements the IFRS 9 simplified approach (IFRS 9.5.5.15), which applies to trade receivables without a significant financing component. For banks, this covers a narrow but important category of financial assets: fee receivables from advisory mandates, transaction banking fee receivables, interbank settlement receivables, credit card merchant fee receivables, insurance premium receivables (for bancassurance operations), and sundry operational receivables. The vast majority of a bank's balance sheet — loans, advances, debt securities, and off-balance-sheet commitments — falls under the IFRS 9 general model (IFRS 9.5.5.1–5.5.14), which requires the three-stage impairment approach. This tool does not support the general model. Banks using this calculator should only input trade receivable balances, not loan portfolio data.
Receivable Characteristics — Banking
Bank trade receivables are fundamentally different from loan portfolio assets. They are typically short-duration (30–90 day settlement), low individual value relative to the loan book, and arise from service delivery rather than lending activity. Fee receivables from corporate advisory work may be individually large but are generally backed by engagement letters with creditworthy counterparties. Interbank receivables settle through established clearing systems with minimal credit risk. Credit card merchant fee receivables are high-volume, low-value, and typically secured against future card transactions. The collective provision matrix approach works well for bank trade receivables because they form a homogeneous population with predictable loss patterns.
Forward-Looking Factors
Forward-looking adjustments for bank trade receivables should consider the broader financial system health, as the entity's counterparties include other financial institutions, large corporates, and small businesses. Central bank interest rate policy directly affects the creditworthiness of fee-paying clients. Interbank market stress indicators (such as the TED spread or EURIBOR-OIS spread) provide early warning of counterparty risk in settlement receivables. GDP forecasts and unemployment projections affect the creditworthiness of smaller commercial counterparties from whom the bank has operational receivables.
Key forward-looking indicators for banking:
- Central bank policy rate
- Interbank lending rates (SOFR, EURIBOR, SONIA)
- Banking sector CDS spreads
- Non-performing loan ratios (system-wide)
- GDP growth forecasts
- Unemployment rate projections
Regulatory and Audit Context
Bank auditors must clearly distinguish between the general model ECL (applied to the loan book and reported under IFRS 7 with extensive disclosures) and the simplified approach ECL (applied to trade receivables). Regulatory bodies including the ECB, PRA, and APRA have published extensive guidance on ECL for loan portfolios, but relatively little specific guidance exists for bank trade receivables under the simplified approach. Nevertheless, the same IFRS 9 principles apply, and auditors should verify that bank management has not overlooked trade receivable ECL in the shadow of the far larger loan portfolio impairment. Common oversight: banks may apply zero ECL to trade receivables without documented justification, which is not IFRS 9 compliant.
For bank loan portfolios, the IFRS 9 general model (Stage 1/2/3) is required under IFRS 9.5.5.1–5.5.14 — this tool does not support the general model. ECB, PRA, and APRA have published specific guidance on loan portfolio ECL estimation.
Worked Example — NordBank AG — Trade Receivables Only
NordBank AG has €15M in non-lending trade receivables comprising advisory fee receivables (€8M), transaction banking fees (€4M), and sundry operational receivables (€3M). The FL factor of 1.10× reflects a moderate tightening in financial market conditions. Note: this is separate from the bank's €2.4B loan portfolio, which is assessed under the IFRS 9 general model.
| Bucket | Amount | Rate | ECL |
|---|---|---|---|
| Not yet due | €10.500.000 | 0.11% | €11.550 |
| 1–30 days | €2.800.000 | 0.33% | €9.240 |
| 31–60 days | €900.000 | 0.88% | €7.920 |
| 61–90 days | €450.000 | 2.20% | €9.900 |
| 91–180 days | €250.000 | 5.50% | €13.750 |
| 180+ days | €100.000 | 16.50% | €16.500 |
| Total | €15.000.000 | €68.860 |
Forward-looking adjustment factor: 1.1× applied to all buckets. Rates shown above are adjusted rates (historical × FL factor).