Retention Money: Follow the Cash Through Each Payment
Understand retention deductions, caps, releases, and cumulative payment arithmetic with a transparent worked example.
By Dr. Hassan Khames EliwaLast updated

Start with the payment ledger, not the percentage
Retention money is an amount withheld from an otherwise assessed payment under an agreed arrangement. It affects when cash is received, not simply the headline value of work. The useful question is not only “what percentage is retained?” but “what balance remains withheld after this assessment and any release?”
This article explains a simplified bookkeeping model. It is general information, not contract, legal, or claims advice. Actual deduction bases, limits, release conditions, protections, and payment procedures depend on the applicable documents and rules. None of the example assumptions establishes a right to deduct or receive money.
Use the retention and progress payment calculator to separate the gross assessment, cumulative retention, previous payments, and current payment. Before entering figures, label whether each input is cumulative or relates only to the current period. Mixing those two bases produces plausible-looking but incorrect payment amounts.
Define the base and the cap separately
A retention percentage needs a base. An example model might apply it to cumulative eligible work value. Another arrangement might treat particular items differently. Do not assume that materials, variations, tax, advance payments, and other adjustments all belong in the same base.
A cap is a separate limit on the total retention held under the chosen model. If the cap is expressed as a percentage of a reference amount, identify that amount explicitly. Five percent of current work value and five percent of an agreed overall reference value are different calculations.
For the worked example, every amount is in one unspecified currency, tax is excluded, all assessed work is eligible, and no other deductions apply. The assumed reference value is 1,000,000. The retention rate is 5%, with a fixed monetary cap of 30,000. These are selected arithmetic inputs, not standard contract terms.
The simple formula assumes there have been no releases. Once money has been released, maintain a separate retention ledger rather than blindly reapplying a target balance that could appear to reinstate released money.
Work through three assessments
At the first assessment, cumulative eligible work is 200,000. Five percent is 10,000, below the cap. With no previous payments, the current payment is 190,000. The ledger records work of 200,000, retention held of 10,000, and net cash paid of 190,000.
At the next assessment, cumulative work reaches 500,000. The target retention becomes 25,000. Net cumulative value is 475,000. Deduct the previous net payment of 190,000 to obtain a current payment of 285,000. Only 15,000 of additional retention is withheld in this period.
At the third assessment, cumulative work reaches 800,000. The uncapped retention calculation is 40,000, but the cap limits the balance to 30,000. Net cumulative value becomes 770,000. Previous payments total 475,000, leaving a current payment of 295,000.
| Assessment | Cumulative work | Retention held | Previous net payments | Current payment |
|---|---|---|---|---|
| First | 200,000 | 10,000 | 0 | 190,000 |
| Second | 500,000 | 25,000 | 190,000 | 285,000 |
| Third | 800,000 | 30,000 | 475,000 | 295,000 |
The three current payments sum to 770,000. Add the 30,000 still held and the result reconciles to 800,000 of assessed work. That reconciliation is a better control than checking the retention percentage alone.
Release is a ledger movement, not new work
Suppose a later authorized release is 15,000 while assessed work remains 800,000. The opening retention balance is 30,000, the release is 15,000, and closing retention is 15,000. With no other movement, cash due for this release event is 15,000.
That cash does not represent another 15,000 of construction output. It reduces an existing withheld balance. After payment, cumulative cash is 785,000 and retained cash is 15,000, still reconciling to assessed work of 800,000.
Keep the release event identifiable in the register. Record the approval reference, assessment date, requested release, accepted release, and actual cash receipt. A forecast release date is not the same thing as an authorized amount or cleared money.
If new work and a release occur together, show both movements separately before arriving at the net payment. Otherwise, the apparent retention percentage may change in a way that cannot be explained from the current work increment alone.
Distinguish retention from other payment adjustments
An assessed gross value can differ from cash received for several reasons. Retention, recovery of an advance, tax, agreed contra charges, and other adjustments should not be collapsed into one miscellaneous deduction. Each may have a different calculation basis and documentary trail.
Similarly, the value submitted, the value assessed, the payment notified, and the amount received can be four different figures. A cash forecast should state which one it uses. Treat disputed or unapproved amounts as explicit scenarios rather than silently assuming that they will arrive with the next payment.
The percentage calculator for checking deduction arithmetic is useful for confirming a rate against its intended base. It cannot decide which base is applicable or whether a deduction is permitted. That distinction keeps a simple arithmetic check from being mistaken for a contractual conclusion.
Use accounting references for accounting questions
The IFRS Foundation’s IFRS 15 overview describes the revenue framework for entities reporting under that standard. Cash retained, revenue recognized, and the classification of a balance are not automatically interchangeable concepts.
Do not infer an accounting classification solely from the word “retention.” The conditions attached to payment and the relevant reporting framework matter. Have the finance team map the payment register to the accounting records rather than expecting a site valuation spreadsheet to establish the treatment by itself.
For cost-control context, RICS New Rules of Measurement provide structured approaches to construction measurement and cost management. Those measurement resources do not replace the particular payment documents or create universal retention terms.
Build a cash forecast that survives scrutiny
A practical forecast carries the expected work assessment and the expected receipt date separately. Payment timing can strain working capital even when the total assessed value is unchanged. Retention is only one component of that timing gap.
Prepare a base case and a delayed-release case using documented assumptions. Neither should imply that an event will occur on a particular date merely because a programme milestone appears there. Update the forecast when evidence changes, preserving the earlier assumption so the movement can be explained.
A useful review pack contains the valuation build-up, retention roll-forward, payment reconciliation, and outstanding questions. Someone unfamiliar with the spreadsheet should be able to reproduce the balance without searching email chains for the meaning of each cell.
Checks before sending the next assessment
Confirm that the percentage is stored consistently: 5% means 0.05 in the multiplication, not 5. Confirm that the cap is a money amount when using the minimum formula, not another bare percentage. Review whether the cap reference has changed before copying last month’s input.
Check that previous payments exclude any money not actually included in the chosen cumulative calculation. If payment is short or late, keep the assessment reconciliation and the bank reconciliation distinct. Otherwise, the next assessment can accidentally repeat an amount without explaining why.
Finally, inspect rounding. Calculate on the agreed basis and round at a documented stage. Small differences between line-level and total-level rounding should be visible, not hidden inside a manual adjustment. A clean ledger makes the arithmetic clear while leaving contractual interpretation to the appropriate advisers.
Calculators used in this guide
Frequently asked questions
Is retention always a fixed percentage?
No. The example uses a selected percentage and cap. The applicable documents and rules determine whether retention applies and how it is calculated; there is no universal rate in this article.
Does the cap apply to each payment?
The worked example caps the cumulative retained balance at 30,000, not each individual deduction. Other arrangements must be read on their own terms before choosing a calculation.
Why subtract previous net payments?
The example starts from cumulative assessed work. Subtracting previous net payments prevents paying the same assessed value twice. Using only this period’s work requires a different, consistently period-based calculation.
Is a retention release additional revenue?
A release changes the amount withheld and the cash received. It does not itself establish new work or determine revenue recognition; accounting treatment depends on the reporting framework and facts.
Can this calculation determine whether a deduction is lawful?
No. It checks arithmetic under stated assumptions and provides general information only. It is not contract, legal, or claims advice.
Sources and standards
About the author
Dr. Hassan Khames Eliwa holds a PhD in Construction & Built Environment and has more than 20 years of international project controls experience. He is Director of Eliwa Project Controls Limited in Auckland and founder of PMMilestone.org and PMMilestone.com.
Buy me a coffee