IFRS 9 ECL Calculator
for Energy
Pre-configured for energy entities with consumer utility receivables, B2B energy supply considerations, seasonal payment patterns, and commodity-linked forward-looking adjustments.
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 Energy
Energy and utility companies carry trade receivables with a distinctive dual profile: high-volume consumer receivables from household energy customers and lower-volume but higher-value B2B receivables from commercial and industrial energy consumers. Under IFRS 9, both categories require ECL assessment using the simplified approach, but the credit risk characteristics differ substantially. Consumer energy receivables are subject to regulatory protections (suppliers cannot immediately disconnect for non-payment in most jurisdictions), creating a longer exposure period. B2B energy receivables are typically governed by commercial contracts with shorter credit terms but higher individual exposures. Commodity price volatility adds an additional dimension — sharp energy price increases directly affect customer payment ability, and forward-looking adjustments must consider energy market forecasts.
Receivable characteristics: Energy
Consumer utility receivables are high-volume, low-value, and subject to seasonal patterns. Winter energy bills are typically 40–60% higher than summer bills, coinciding with periods of household financial stress. Energy prepayment meter customers do not generate receivables, but credit meter customers may accumulate significant balances during peak consumption periods. B2B energy supply receivables arise from contracts with commercial and industrial customers, often with monthly billing and 30-day payment terms. Government subsidy receivables (renewable energy feed-in tariffs, capacity payments) carry very low credit risk but may be subject to regulatory changes. Commodity trading receivables (for energy companies involved in wholesale markets) represent short-term, high-value balances that require separate risk assessment.
Forward-looking factors
Energy price forecasts are the single most important forward-looking factor for energy company ECL. Rising energy prices directly reduce customer payment capacity, particularly for household consumers and energy-intensive industrial customers. Consumer energy debt statistics (published by regulators in many jurisdictions) provide direct insight into payment stress. Unemployment rates and household income trends affect consumer payment ability. Seasonal weather forecasts influence energy consumption and therefore billing amounts. For renewable energy generators, subsidy regime changes and energy market reform proposals are forward-looking factors that affect the credit risk of government-related receivables.
Key forward-looking indicators for energy:
- Energy price forecasts (oil, gas, electricity)
- Consumer energy debt statistics
- Unemployment rate and household income
- Seasonal weather forecasts (heating/cooling demand)
- Regulatory price cap changes
- Energy transition policy developments
Regulatory and audit context
Energy sector regulators in many jurisdictions publish data on customer debt levels, disconnection rates, and payment plan arrangements that provide direct input into ECL estimates. Auditors should verify that management has considered this publicly available data. The regulated nature of energy pricing means that price cap changes can materially affect receivable balances and credit risk — a price cap increase may simultaneously increase billing amounts and customer default rates. Common audit findings include: failure to adjust for seasonal patterns in year-end ECL estimates, inadequate forward-looking adjustment during energy price spikes, and insufficient segmentation between consumer and commercial receivables.
Energy regulators in most European jurisdictions publish consumer debt statistics and disconnection data that provides direct input into ECL estimation. Auditors should verify that management has considered this publicly available regulatory data.
Worked example: GridPower Utilities NV
GridPower Utilities NV serves 250,000 household and 12,000 commercial customers with €8.5M in trade receivables at year-end (December). Seasonal concentration is significant — Q4/Q1 billing is 45% higher than Q2/Q3. The FL factor of 1.10× reflects forecast energy price increases and rising consumer debt levels in the service area.
| Bucket | Amount | Rate | ECL |
|---|---|---|---|
| Not yet due | €4.800.000 | 0.44% | €21.120 |
| 1–30 days | €1.600.000 | 1.10% | €17.600 |
| 31–60 days | €1.000.000 | 3.30% | €33.000 |
| 61–90 days | €550.000 | 8.80% | €48.400 |
| 91–180 days | €350.000 | 19.80% | €69.300 |
| 180+ days | €200.000 | 49.50% | €99.000 |
| Total | €8.500.000 | €288.420 |
Forward-looking adjustment factor: 1.1× applied to all buckets. Rates shown above are adjusted rates (historical × FL factor).