Construction progress billing and retention release · Calculation guide

Apply retention to the current certified gross work, then release the entered portion of previously withheld retention.

Calculation guide

Include prior retention only once.

Amount due this billing = ((Current certified work × (1 − (Current retention (%) ÷ 100))) + Release of prior retention). Retention balance after billing = ((Opening retention balance + ((Current certified work × Current retention (%)) ÷ 100)) − Release of prior retention)

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

InputValue
Current certified work50,000
Current retention (%)10%
Opening retention balance8,000
Release of prior retention3,000
ResultValue
Amount due this billing48,000
Retention balance after billing10,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.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Current certified work50,00055,000Amount due this billing48,00052,500
Current retention (%)10%11%Amount due this billing48,00047,500
Opening retention balance8,0008,800Retention balance after billing10,00010,800
Release of prior retention3,0003,300Amount due this billing48,00048,300
Construction progress billing and retention release →

Sources