IFRS 9 Expected Credit Loss (ECL) Calculator
Calculate IFRS 9 / TFRS 9 expected credit loss and provision for trade receivables or loans.
Aging Buckets
Enter receivable balances and historical loss rates for each aging bucket.
Not Past Due
1–30 Days Past Due
31–60 Days Past Due
61–90 Days Past Due
More than 90 Days Past Due
TRY 1,213,000.00
TRY 40,535.00
%3.34
TRY 15,535.00
ECL Provision Matrix
Expected credit loss by aging bucket.
| Aging Bucket | Receivable (TRY) | Historical Loss Rate (%) | Adjusted Rate (%) | Expected Credit Loss (TRY) |
|---|---|---|---|---|
| Not Past Due | TRY 850,000.00 | %0.50 | %0.55 | TRY 4,675.00 |
| 1–30 Days Past Due | TRY 210,000.00 | %2.00 | %2.20 | TRY 4,620.00 |
| 31–60 Days Past Due | TRY 95,000.00 | %8.00 | %8.80 | TRY 8,360.00 |
| 61–90 Days Past Due | TRY 40,000.00 | %25.00 | %27.50 | TRY 11,000.00 |
| More than 90 Days Past Due | TRY 18,000.00 | %60.00 | %66.00 | TRY 11,880.00 |
| TOTAL | TRY 1,213,000.00 | %3.34 | TRY 40,535.00 |
| Account Code | Account Name | Debit | Credit |
|---|---|---|---|
| 654 | Provision Expense | TRY 15,535.00 | — |
| 129 | Allowance for Doubtful Receivables (–) | — | TRY 15,535.00 |
The entry reflects the net movement versus the prior IFRS 9 allowance. Reclassification under local tax rules is a separate assessment.
About the Calculation Method
Simplified approach: ECL = Receivable × Historical Loss Rate × (1 + Forward-looking Adjustment) for each aging bucket.
General approach: ECL = EAD × PD × LGD, then discounted with 1 / (1 + Discount Rate)^Horizon.
What Is Expected Credit Loss (ECL) and Why Calculate It?
Suppose you lend a friend 20,000 TRY this time. As collateral, your friend leaves you the keys to a car worth 8,000 TRY if they cannot repay.
Ask yourself three questions in order:
- How much is at risk?
If your friend cannot pay one day, the amount owed to you at that moment is exactly 20,000 TRY. Your exposure is 20,000 TRY — before considering collateral, this answers “how large is the debt in the bad scenario?” - What is the probability of non-payment?
You know your friend — work is a bit unstable, but generally reliable. Say there is a 15% chance they cannot repay. That probability is estimated from how often similar people historically failed to pay. - If they do not pay, how much do we lose?
If they default, you still have the car as collateral and can sell it for 8,000 TRY. So 8,000 of the 20,000 is recovered from collateral and the remaining 12,000 is the true loss. Loss rate: 12,000 / 20,000 = 60%.
Now multiply the three:
20,000 TRY (exposure) × 15% (probability of default) × 60% (loss rate) = 1,800 TRY
So you already know that, on average, you may never see 1,800 TRY of this 20,000 receivable — and you book it that way. Banks do the same for millions of loans, one by one, looking at collateral, payment history and economic outlook.
Start with a simple example
Suppose you lend 1,000 TRY to each of 10 friends. All say “I will repay.” But life tells you that probably 1 of those 10 will never repay — maybe they lose their job, maybe something else goes wrong.
Ask yourself: how much money do you really have?
- On paper: you have 10,000 TRY receivable.
- In expected reality: you will probably get only 9,000 TRY back.
That is exactly what Expected Credit Loss (ECL) is: estimating a loss that has not yet happened but is likely, and recognising it in advance.
The same story for companies
Think of a company — trade receivables from credit sales, or a bank’s loan book. The books show “receivables.” In real life:
- Some customers pay late.
- Some never pay (bankruptcy, shutdown, disappearance).
- Some loans become non-performing over time.
If the company books “I will collect everything,” it looks richer than it is, misleading itself, banks, partners and investors.
ECL prevents that illusion: it answers “How much of this receivable/loan will we really not collect?”, expenses that amount, and sets it aside as an allowance (provision).
Why is it mandatory?
It is not optional — it is required by TFRS 9 / IFRS 9. The aim is simple:
Financial statements should show the real situation, not a polished picture.
After the 2008 crisis revealed hidden losses behind “healthy” bank balance sheets, the world moved to recognising probable losses before they crystallise. ECL is that lesson.
How is it calculated? (Briefly)
There are two simple approaches:
1. Trade receivables: apply historical non-collection rates by aging bucket (e.g. “60% of >90 day balances were never collected”) and adjust for forward-looking economic expectations.
2. Loans: ask three questions — how much exposure, what probability of default, and what loss given default after collateral.
Another example: you lend 10,000 TRY and take a watch worth 6,000 TRY as collateral.
- Exposure: 10,000 TRY.
- Probability of default: say 10%.
- Loss given default: after selling the watch for 6,000, only 4,000 is truly lost — a 40% loss rate.
Multiply: 10,000 × 10% × 40% = 400 TRY.
Putting the watch and car examples side by side makes the point clear: the higher the collateral value, the lower the loss rate, because more value is recoverable.
Loans are also split into 3 stages: performing loans use a 12-month horizon; significantly increased risk or credit-impaired loans use lifetime ECL.
What does this achieve?
- The company does not fool itself about how much cash it really has.
- Banks, investors and partners get reliable figures.
- Surprise losses decline — losses appear gradually instead of as a shock.
- Audit and compliance requirements under TFRS 9 are met.
In short
ECL prepares financial statements with realistic collectibility — just as you want to know the real money in your pocket after lending to friends, companies must know their true financial position.
Frequently Asked Questions
Related topics
This tool is for education and demonstration only. Real TFRS 9 / IFRS 9 allowances must follow entity policies, loss data and independent audit/advisory judgement.