IFRS 9 · Banking

IFRS 9 ECL Calculator
for Banking

IFRS 9 simplified approach for bank trade receivables including interbank claims, fee receivables, and non-lending financial assets. Note: loan portfolios require the general model (Stage 1/2/3) — this tool does not support the general model.

Benchmark rates loaded. These are illustrative only. Replace with entity-specific historical loss data for IFRS 9 compliance.

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.

Important: This calculator implements the IFRS 9 simplified approach (IFRS 9.5.5.15) for trade receivables only. For bank loan portfolios, the IFRS 9 general model with three-stage impairment (Stage 1, 2, and 3) is required under IFRS 9.5.5.1–5.5.14. This tool does not support the general model.

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).

Typical receivable profile: Bank trade receivables (distinct from the loan portfolio) include fee receivables from advisory and transaction services, interbank settlement receivables, credit card merchant fee receivables, and sundry operational receivables. These are generally low-value, short-duration, and lower-risk than the loan book.

Frequently Asked Questions — Banking

Does this calculator work for bank loan portfolio ECL under IFRS 9?
No. This calculator implements the simplified approach (IFRS 9.5.5.15) for trade receivables only. Bank loan portfolios must use the IFRS 9 general model (IFRS 9.5.5.1–5.5.14), which requires a three-stage impairment approach: Stage 1 (12-month ECL for performing loans), Stage 2 (lifetime ECL where significant increase in credit risk has occurred), and Stage 3 (lifetime ECL for credit-impaired assets with interest on net carrying amount). The general model requires fundamentally different inputs including probability of default (PD), loss given default (LGD), and exposure at default (EAD) — none of which are implemented in this tool.
What bank receivables can be assessed using the simplified approach?
The simplified approach applies to trade receivables without a significant financing component. For banks, this includes: advisory and transaction fee receivables, interbank settlement receivables, credit card merchant fee receivables, insurance brokerage receivables (for bancassurance), and sundry operational receivables (rent, utilities owed by tenants of bank-owned property, etc.). The key criterion is that these receivables arise from the provision of services, not from lending activities.
Why is the banking variant's default FL factor set at 1.10×?
Bank trade receivable counterparties are diverse — ranging from large corporates (for advisory fees) to small merchants (for card processing fees) — and their credit risk is sensitive to financial market conditions. A base FL factor of 1.10× reflects the typical precautionary overlay applied in the banking sector, where regulatory expectations for forward-looking adjustments are well-established from the loan portfolio context and spill over into trade receivable assessment.
Should banks use the same ECL model for trade receivables and loan portfolios?
No. The simplified approach (provision matrix) and the general model (PD × LGD × EAD staged approach) are fundamentally different methodologies. While both require forward-looking adjustments, the inputs, calculations, and disclosure requirements are distinct. In practice, most banks have dedicated credit risk modelling teams for the loan portfolio ECL and may use simpler approaches for the much smaller trade receivable population.
How do ECB/PRA/APRA guidelines affect trade receivable ECL for banks?
Regulatory ECL guidelines from the ECB, PRA, and APRA are primarily directed at loan portfolio impairment. However, the general principles — documented methodology, adequate forward-looking information, probability-weighted scenarios, and governance over key assumptions — are considered best practice for all financial assets, including trade receivables. Bank auditors should verify that trade receivable ECL is subject to the same governance framework as the loan portfolio, even if the methodology is simpler.