Skip to main content

Finance area · 2 datasets

IFRS 9 expected credit loss sample data: receivables ageing, provision matrix and write-offs for Power BI and Excel

Free expected credit loss practice datasets for trade receivables: month-end ageing by customer, an approved provision matrix and its update, credit-impaired customers, write-offs and recoveries, invoice-level open items for two companies, probability-weighted scenarios and the allowance the ledger booked. Build the IFRS 9 allowance, explain its movement, back-test it and reconcile it, with graded questions at every level.

L1

Mizan Building Supplies: How Much of the Receivables Will We Collect? - IFRS 9 Expected Credit Loss Fundamentals

Age a receivables book, apply an IFRS 9 provision matrix, provide for credit-impaired customers, track write-offs and recoveries, and test whether las...

DD-ECL-001 · XLSX · ~10,000 rows · 30 questions

L2

Mizan Building Supplies: Two Companies, Three Scenarios and a Booked Allowance That Does Not Agree - IFRS 9 ECL

Build the IFRS 9 expected credit loss allowance from invoice-level open items for two companies: days past due, a versioned provision matrix, probabil...

DD-ECL-002 · CSV · ~30,000 rows · 40 questions

Free account: download the data, check your answers and earn a certificate.

Create a free account

More practice data