What is a provision matrix under IFRS 9?

A table of loss rates by how long receivables have been past due, applied to the balances in each band. IFRS 9 paragraph B5.5.35 names it as a practical expedient for measuring expected credit losses on trade receivables, and Illustrative Example 12 works one through.

Do trade receivables need lifetime expected credit losses?

Yes, where they have no significant financing component — the simplified approach in IFRS 9 paragraph 5.5.15. There are no stages and no twelve-month figure: every balance is measured over its whole life.

Does the current band need a loss rate?

Yes. In IFRS 9's own Example 12 the current band carries 0.3%, which is CU45,000 of the CU580,000 allowance.

Where do the loss rates come from?

From your own history of receivables that went bad, adjusted for forward-looking information. The tool starts with placeholder rates so it can calculate straight away, and says so on the result until you replace them with your own.

Where does my file go?

It is sent to be measured and stored nowhere once the answer comes back. Your work is kept in your own browser, and there is nothing to sign up for.

Provision matrix calculator for trade receivables (IFRS 9)

Bring your aged receivables — from QuickBooks, Xero, Sage or your ledger, exactly as it exported — and get the lifetime expected credit loss under the IFRS 9 simplified approach, the journal entry and a draft note. Free, with nothing to sign up for.

Credit loss allowance

Bring a loan tape or a receivables ageing.
Get the allowance, the journal entry and a draft disclosure note.

Excel or CSV · IFRS 9 · Ind AS 109 · US GAAP for receivables

Choose a file

Checked against the standard

IFRS 9’s own worked example, run through the same calculation your file goes through — not copied from the published answer.

Illustrative Example 12 — a provision matrix IFRS 9 IE74–IE77

Days past due	Receivables	Loss rate	Allowance
Current	CU 15,000,000	0.3%	CU 45,000
1–30 days past due	CU 7,500,000	1.6%	CU 120,000
31–60 days past due	CU 4,000,000	3.6%	CU 144,000
61–90 days past due	CU 2,500,000	6.6%	CU 165,000
More than 90 days past due	CU 1,000,000	10.6%	CU 106,000
Total	CU 30,000,000		CU 580,000

The example prints CU 580,000 — the sum of the bands. The engine reaches exactly the same figure.

And the provision matrices companies have filed with the SEC

An engine checked only against its own author’s expectations proves nothing, however many tests it has. These are complete calculations published by other people, reproduced on every change.

Source	What it works	Published	Bilnax
IFRS 9, Illustrative Example 12	Provision matrix, CU30m of trade receivables	CU 580,000	CU 580,000
IFRS Foundation, ITG July 2016 The slide rounds. Its own working — 30%×22 + 55%×52 + 15%×136 — is 55.6.	One asset, three scenarios, two-step staging	CU 56	CU 55.60
BDO, related company loans, §5.5	12-month ECL, 5% × 60% × CU100	CU 3.00	CU 3.00
Copa Holdings, Form 20-F FY2025	Filed provision matrix, five ageing bands	US$ 1,950k	US$ 1,950k
ASE Technology, Form 20-F FY2023	Filed matrix, plus its individually-impaired column	NT$ 164,408k	NT$ 164,408k
Bajaj Finance, consolidated accounts FY2025	Filed stage 1/2/3 gross, allowance and net carrying amount	₹ 6,982.36 cr	₹ 6,982.36 cr
HSBC Bank plc, Annual Report 2024	Filed stage 1/2/3 and POCI across all IFRS 9 in-scope instruments	£ 925m	£ 925m
Bajaj Finance, consolidated balance sheet FY2025	Thirty-one filed balances through the statements engine	₹ 466,126.83 cr	₹ 466,126.83 cr

The second row does not match, and is shown not matching. Where a published figure has been rounded, Bilnax reports the unrounded one.

What it does

Reads the ageing as your system printed it — the title lines, the bands across the top, and the report’s own total line, which it leaves out rather than counting the book twice.
Measures each balance at the loss rate for its band, over its whole life, and says which rates are still the tool’s starting values rather than yours.
Gives you the journal entry for the movement in the allowance and a draft IFRS 7 note, with the working paper behind both.

Reporting under US GAAP? The same ageing under ASC 326 is the CECL calculator.

Questions

What is a provision matrix under IFRS 9?: A table of loss rates by how long receivables have been past due, applied to the balances in each band. IFRS 9 paragraph B5.5.35 names it as a practical expedient for measuring expected credit losses on trade receivables, and Illustrative Example 12 works one through.
Do trade receivables need lifetime expected credit losses?: Yes, where they have no significant financing component — the simplified approach in IFRS 9 paragraph 5.5.15. There are no stages and no twelve-month figure: every balance is measured over its whole life.
Does the current band need a loss rate?: Yes. In IFRS 9's own Example 12 the current band carries 0.3%, which is CU45,000 of the CU580,000 allowance.
Where do the loss rates come from?: From your own history of receivables that went bad, adjusted for forward-looking information. The tool starts with placeholder rates so it can calculate straight away, and says so on the result until you replace them with your own.
Where does my file go?: It is sent to be measured and stored nowhere once the answer comes back. Your work is kept in your own browser, and there is nothing to sign up for.