Calculation guide
Include prior retention only once.
Inputs
Current certified work
Example entry 50000 (in the selected currency).
Current retention (%)
Example entry 10 %. Allowed range 0 to 100.
Opening retention balance
Example entry 8000 (in the selected currency).
Release of prior retention
Example entry 3000 (in the selected currency).
Worked example
| Input | Value |
|---|---|
| Current certified work | 50,000 |
| Current retention (%) | 10% |
| Opening retention balance | 8,000 |
| Release of prior retention | 3,000 |
| Result | Value |
|---|---|
| Amount due this billing | 48,000 |
| Retention balance after billing | 10,000 |
Calculation steps
Amount due this billing = ((Current certified work × (1 − (Current retention (%) ÷ 100))) + Release of prior retention)
((50,000 × (1 − (10 ÷ 100))) + 3,000) = 48,000
Retention balance after billing = ((Opening retention balance + ((Current certified work × Current retention (%)) ÷ 100)) − Release of prior retention)
((8,000 + ((50,000 × 10) ÷ 100)) − 3,000) = 10,000
Interpreting the result
A release increases the current amount payable and reduces retained funds by the same amount. The closing balance carries forward to the next billing.
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 |
|---|---|---|---|---|---|
| Current certified work | 50,000 | 55,000 | Amount due this billing | 48,000 | 52,500 |
| Current retention (%) | 10% | 11% | Amount due this billing | 48,000 | 47,500 |
| Opening retention balance | 8,000 | 8,800 | Retention balance after billing | 10,000 | 10,800 |
| Release of prior retention | 3,000 | 3,300 | Amount due this billing | 48,000 | 48,300 |
