Allowance for doubtful accounts by aging · Calculation guide

Buckets must be disjoint. Rates are your forward-looking loss estimates.

Calculation guide

Opening allowance is the signed credit balance after write-offs. A negative adjustment releases an allowance.

Required allowance = Σ(bucket receivables × estimated loss rate).

Inputs

Existing allowance credit balance

Example entry 450 (in the selected currency).

Gross receivables

Example entry 10000 (in the selected currency).

Estimated loss rate

Example entry 1 %. Allowed range 0 to 100.

Worked example

InputValue
Existing allowance credit balance450

Receivable aging buckets

Gross receivablesEstimated loss rate
10,0001%
3,00010%
50060%
ResultValue
Required closing allowance700
Charge or release in period250
Net receivables after allowance12,800

How each input affects this example

Each row starts from the worked example and changes one input.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Existing allowance credit balance450495Charge or release in period250205
Gross receivables (row 1)10,00011,000Required closing allowance700710
Estimated loss rate (row 1)1%2%Required closing allowance700800
Allowance for doubtful accounts by aging →

Sources