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
| Input | Value |
|---|---|
| Existing allowance credit balance | 450 |
Receivable aging buckets
| Gross receivables | Estimated loss rate |
|---|---|
| 10,000 | 1% |
| 3,000 | 10% |
| 500 | 60% |
| Result | Value |
|---|---|
| Required closing allowance | 700 |
| Charge or release in period | 250 |
| Net receivables after allowance | 12,800 |
How each input affects this example
Each row starts from the worked example and changes one input.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Existing allowance credit balance | 450 | 495 | Charge or release in period | 250 | 205 |
| Gross receivables (row 1) | 10,000 | 11,000 | Required closing allowance | 700 | 710 |
| Estimated loss rate (row 1) | 1% | 2% | Required closing allowance | 700 | 800 |
