All tools

Receivables ageing and expected credit loss

Bucket balances by age and compute the allowance from a provision matrix.

Result

Gross receivables
520000.00
Expected credit loss
4200.00
Net receivables
515800.00

Download the workbook

The method

  1. Each bucket's balance × its expected loss rate = the bucket's allowance; their sum is the allowance.
  2. The rates come from the entity's own collection history, not from a general figure.

Built forAn accountant or analyst who needs an evidenced decision from period figures

When you need it

You need to explain a figure or compare alternatives before taking the analysis to management. Bucket balances by age and compute the allowance from a provision matrix.

The decision it supports

Use the result to explain a trend, gap or scenario effect, then connect it to an operating cause. The tool shows its method beside the result so you can review it.

What you receive

Receivables ageing and expected credit loss result

A shareable interactive result with findings, calculation method and an Excel workpaper carrying the same figures.

An example you can inspect

A ready-to-run example

The tool opens with: Not yet due = 400000.00, Overdue = 120000.00, Expected loss rate = 3.5. Change any value to see its effect immediately.

Continue the workflow