Keep one ledger row per contract holding the retention percentage, the amount withheld, each release trigger and its due date. Then let AI turn every row that has passed its trigger into a reminder that quotes your contract's own wording. The ledger is the control; AI only drafts the emails and flags rows that need chasing.
Retainage, retention and holdback are the same money: a slice of each payment that the other party keeps until a milestone is met. It is your profit sitting in someone else's bank account, and it rarely moves unless somebody asks at the right time, in the right words, with the right paperwork. That makes it a tracking problem before it is a writing problem.
Retainage, retention, holdback: one idea, three names
Different contracts use different words for the same mechanism, and the reader you are writing to will use their contract's word. Use it too. A reminder that says "retainage" when the clause says "retention" hands the payer an excuse to ask which clause you mean.
The size varies, so read yours. A construction law article published by ConsensusDocs describes the prevailing range, where a range is set, as 5% to 10% of the contract amount or of each progress payment, and notes that some contracts stop withholding or reduce the rate once the work is half complete. Retained money is generally released after substantial completion (called practical completion in many contracts), with final payment following later. A common pattern is two releases, the first at completion and the second at the end of the defects period, often around twelve months afterwards. Some owners will take a bond or a letter of credit in place of cash retention, though a second ConsensusDocs article notes that this does not happen routinely on private work. It costs nothing to ask at tender stage.
Whatever the norm, your contract overrides it, and the ledger is where its numbers should live from the day it is signed.

The Complete Excel Course with AI Integration
From formulas and pivot tables to Power Query, DAX, VBA and AI with Copilot, ChatGPT and Claude — hands-on from the first lesson.
By Sagnik Bhattacharya and Virginia Thorn, Primetime Emmy Award winner
Buy nowThe ledger: columns that make chasing automatic
One row per contract. The columns do the thinking so the reminder prompt does not have to:
| Column | What it holds |
|---|---|
| Ref, job, counterparty, contact | Who to write to, and who signs for the money |
| Contract value and billed to date | Inputs for the withheld amount |
| Retention rule | Rate and any reduction (for example 10% to half value, then 5%) |
| Held to date, released, still held | Formulas: held from the rule, still held = held minus released |
| Trigger 1: event and date | For example practical completion certificate, with its date and number |
| Release 1: amount and due date | Amount from the contract; due date = trigger date + days allowed |
| Trigger 2: event and date | For example end of the defects period, counted from the completion date |
| Conditions | Documents or notices the contract makes a condition of release |
| Days overdue, last chased, next action | The columns you sort by every week |
Illustrative ledger for a small contractor, as at 30 November 2026:
| Ref | Job | Rule | Held | Released | Still held | Next release | Due | Days overdue |
|---|---|---|---|---|---|---|---|---|
| R-01 | Warehouse office fit-out | 5% | $9,300 | $0 | $9,300 | Half after practical completion (14 Aug): $4,650 | 11 Sep 2026 | 80 |
| R-02 | Retail unit refurbishment | 5% | $3,725 | $0 | $3,725 | Half after practical completion (2 Oct): $1,862.50 | 30 Oct 2026 | 31 |
| R-03 | Classroom block package | 5% | $17,000 | $0 | $17,000 | Completion not yet certified | n/a | 0 |
| R-04 | Care home extension | 3% | $3,840 | $1,920 | $1,920 | Balance at end of defects period (5 Mar 2027) plus 28 days | 2 Apr 2027 | 0 |
| R-05 | Dental surgery fit-out | 10% to half value, then 5% | $7,200 | $0 | $7,200 | Half after practical completion (27 Sep): $3,600 | 11 Oct 2026 | 50 |
| R-06 | Cafe refit | 5% | $1,900 | $950 | $950 | Balance at end of defects period (30 Nov 2026) plus 28 days | 28 Dec 2026 | 0 |
| Total | $42,965 | $2,870 | $40,095 |
Three jobs are late: $4,650 on R-01, $1,862.50 on R-02 and $3,600 on R-05, which is $10,112.50 of first releases already overdue. For a firm invoicing about $100,000 a month, the $40,095 still held is roughly twelve days of billing sitting in other people's accounts. R-06 is not late, but its defects period ends today, so the request for its balance goes out tomorrow, provided the defects close-out has been done.
Held to date, flat rate: =Billed*Rate
Held, 10% to half value then 5%: =MIN(Billed,Value/2)*0.10 + MAX(0,Billed-Value/2)*0.05
Still held: =Held-Released
Release 1 due: =IF(TriggerDate="","",TriggerDate+DaysAllowed)
Days overdue: =IF(AND(Due<>"",Paid="No",Due<TODAY()),TODAY()-Due,0)
Any AI assistant will write these formulas if you describe your column letters, and you can test each one against a row you worked out by hand. Reconcile the Released column to your bank statements monthly, because a release that was paid but never recorded will produce a reminder you are embarrassed to have sent.
How retention builds up, application by application
The Held column is a running total of per-application deductions, and a rate that changes part-way through a job is where mistakes creep in. Illustrative build-up for the dental surgery fit-out (R-05): a $96,000 contract, retention at 10% until half the contract sum ($48,000) has been valued and 5% afterwards.
| Application | Valued this period | Cumulative valuation | Retention this period | Cumulative retention |
|---|---|---|---|---|
| 1 | $18,000 | $18,000 | $1,800 | $1,800 |
| 2 | $20,000 | $38,000 | $2,000 | $3,800 |
| 3 | $16,000 | $54,000 | $1,300 | $5,100 |
| 4 | $22,000 | $76,000 | $1,100 | $6,200 |
| 5 | $20,000 | $96,000 | $1,000 | $7,200 |
Application 3 straddles the threshold: the first $10,000 of that period takes 10% ($1,000) and the remaining $6,000 takes 5% ($300). The cumulative figure ends at $7,200, which matches the ledger row. Compare the retention line on every payment certificate with your own figure as it arrives. A payer who withholds 10% when the clause drops to 5% after the halfway point is a surprise you want to find in month three, while it is one line on one certificate, not in month fifteen.
Pull the terms out of each contract, and check the quotes
Filling the first row is the slow part. Paste the retention clause, the completion and defects clauses, the definitions and any amendments schedule into an assistant, and ask for a table with a quotation for every value. Do not paste the whole contract: it adds cost and noise, and you only need four or five clauses.
From the contract text below, extract the retention terms into a table with columns:
Item | Value | Clause | Exact quote
Items: retention percentage and what it applies to; any reduction or cap and when it applies; first release trigger and how many days after it; second release trigger and timing; conditions that must be met before release (documents, notices, certificates); who certifies; any late-payment rate; whether a retention bond is allowed; any notice you must give to claim release.
Rules:
- Copy quotes word for word. Write "Not found" where the text is silent.
- If amendments or contract particulars change a value, list both and flag the conflict.
- Do not interpret the law and do not calculate dates.
TEXT:
[paste]
Illustrative output for the dental surgery fit-out (R-05), trimmed:
| Item | Value | Clause |
|---|---|---|
| Rate | 10% until half the contract sum is valued, then 5% | 9.2 |
| Release 1 | Half of retention within 14 days of the practical completion certificate | 9.4 |
| Release 2 | Balance within 14 days of the end of the 12-month defects period | 9.5 |
| Conditions | As-built drawings and manuals delivered before release 1 | 9.4.2 |
| Late-payment rate, bond | Not found | None |
Check three things against the original. The assistant may paraphrase "within 14 days of the date the certificate is issued or should have been issued" as "within 14 days of the certificate", which drops the second half. It may quote the printed 12 months and miss an amendment that made it 18. It may also treat "the balance" as release two when a third release is tied to the final account. One wrong number moves every reminder that follows, so read each quote against the page before it goes in the ledger.
Release triggers: what has to happen before you can ask
A release trigger is an event, not a date, and the ledger should record the evidence that it happened. Common triggers:
- Practical or substantial completion certificate. The client or its agent controls the date. Record the certificate number and the date on it.
- Sectional completion, where a large job is certified in parts and each part releases its share.
- End of the defects period, counted from the certified completion date. You can calculate this the day the certificate arrives.
- Final account agreed or a final certificate issued, which can release the last part or a third stage.
- Documents and forms that the contract makes a condition: as-built drawings, manuals, warranties and any release forms the contract lists.
Sort the list into what you control and what the other side controls. Documents, snag closure, your final account submission and your notices are yours; certificates and sign-off are theirs. Chase what is yours first, because a delay on your side hands the payer a reason to wait. The handover pack tracker shows how to prove the document conditions are met, and the final account tutorial covers the agreement that often triggers the last release.
Reminders that quote the contract: a five-step sequence
A fixed sequence stops you improvising when you are annoyed. Drive each step from a ledger row, not from memory:
| Step | When | Purpose |
|---|---|---|
| 1 | 14 days before the expected trigger | Confirm the date and list what you will supply |
| 2 | Trigger day | Request release: amount, clause and any invoice or application the contract asks for |
| 3 | 7 days overdue | Polite chase asking for a payment date |
| 4 | 21 days overdue | Firm: ask for written reasons for any withholding and copy a senior person |
| 5 | 35 days overdue | Formal: reserve your position and say you are taking advice. Solicitor reads it first |
Steps 1 and 2 are short and factual. Step 1 is a heads-up: practical completion is expected on a date, the clause allows release a set number of days later, and here is the paperwork you will send. Step 2 repeats the amount and clause on the trigger day and attaches whatever the contract requires, usually an invoice or application. Steps 3 and 4 add the days-overdue figure and one specific question. The routine first two steps are the cheapest, because they ask for nothing and make the trigger date visible to the payer's accounts team before it passes.
Write the reminder for STEP [n] from the ledger row and clause below. Use ONLY these facts.
- Use the contract's own word: "retention".
- State the clause number, the amount, the trigger event and its date, the due date and the days overdue.
- Under 140 words. Courteous. No threats before step 5. No legal conclusions. No interest unless the Late-payment field gives a rate.
- Ask one specific question: the date the payment will be made, or the written reason it cannot be.
- Sign off "[your name]". Use "[first name]" for the recipient.
ROW: R-02 | Retail unit refurbishment | 5% | release 1 = $1,862.50 | trigger: practical completion certified 2 Oct | clause 9.4: 28 days | due 30 Oct | days overdue 31 | Late-payment rate: none | Handover documents: issued [date]; snag list closed [date]
CLAUSE 9.4: [paste]
Illustrative output for step 4:
Subject: Retention release overdue: retail unit refurbishment
Hello [first name],
Practical completion on the retail unit was certified on 2 October. Clause 9.4 provides for half of the retention, $1,862.50, to be released within 28 days of that certificate, which was 30 October. I have not received it, and it is now 31 days overdue.
Could you confirm by [date] when it will be paid, or tell me in writing what is outstanding that prevents release? The handover documents were issued on [date] and the snag list was closed on [date].
I will call you on [day] to agree the date.
Thanks,
[your name]
Three faults to delete from output like this: an invented history ("as discussed on Tuesday"), interest "accruing" when the contract has no interest clause, and the wrong clause number. Compare every figure, date and clause with the ledger row before you send. If your firm already has a tone for late payments, the tutorials on late payment reminders that sound human and payment notices and their deadlines cover the neighbouring ground.
The second release: start the defects close-out early
The second release depends on the defects period ending without open items, so the work starts weeks before the end date. Illustrative timetable for the cafe refit (R-06), whose defects period ends on 30 November:
- Eight weeks before (5 October): ask the client for its defects list, and book a joint inspection for about four weeks later.
- Four weeks before (2 November): inspect together, agree what is open, and book the trades.
- One week before (23 November): sign off the agreed list, with photographs of each closed item.
- The day after the end date: send the release request for the balance, quoting the clause, and set the due date 28 days later (28 December).
AI helps with the paperwork around that. Give it the defects log and ask for a one-page summary by trade: items reported, items closed with dates, items still open. A plausible result for a log of fourteen items over twelve months is twelve closed with dates, two open (a cracked tile and a door closer), both in your scope, with a suggested visit date. The assistant summarises; you decide what counts as closed, and a log kept with a date, a trade and a status on every line summarises far better than one kept in email threads.
Four ways a retention ledger quietly goes wrong
- Release recorded on the invoice date, not the cash date. A release you have invoiced is not a release you have received. The Released column follows the bank, and a separate Invoiced column can sit beside it.
- Trigger dates typed from memory. Take the date from the certificate and record the certificate number. A date remembered as the 14th that the certificate gives as the 18th shifts every later date by four days and can put a reminder in the wrong week.
- Net in the accounts, gross in the sheet. If your accounts record invoices net of retention while the ledger works from gross valuations, the two will never reconcile. Decide which figures each one uses and write a one-line reconciliation note under the table.
- Several phases under one reference. A job completed in sections needs a row per section, because each section has its own completion date and its own release. A single row averages the dates and chases none of them correctly.
An assistant is a quick second pair of eyes for these. Paste the ledger, with client names swapped for references, and ask it to list rows where Held is not the rate times billed, where the due date is not the trigger date plus the allowed days, or where a trigger date is blank but days overdue is above zero. Each check is a formula you could write yourself, which is why the assistant is the auditor and never the author of the figures.
A twenty-minute weekly review
- Sort the ledger by days overdue, largest first.
- Update the status of any trigger that happened this week and enter the evidence.
- Generate that week's reminders, one row at a time, and read each before sending.
- Record the send date in the Last chased column.
- Check bank receipts against the Released column.
- Look at the triggers due in the next 30 days and start any pre-trigger messages.
Once a month, total the Still held and Overdue columns and feed them into your cash forecast. Retention that is late is cash you planned to have, which is why the cash flow forecast tutorial treats release dates as inputs rather than hopes. How retention interacts with job margins and work in progress is covered in AI in construction accounting.
When the money still does not arrive
If steps 3 to 4 bring nothing, change what you are doing rather than the volume. Ask for the written reason, compare it with the contract's conditions, and check whether you owe any notice that you have not given. Some places set statutory deadlines for owners to release retained funds, and your contract may set notice steps for claiming them, so a solicitor should see a release that is a month late. They can often tell you in one conversation whether time is running against you.
Prepare for that conversation with a chronology. Paste in your ledger row, the relevant emails and the dates of each certificate, and ask for facts only:
Build a dated chronology table from the material below: Date | Event | Source document.
Facts only. No opinions, no legal conclusions, no gaps filled by guesswork. If two sources conflict, list both.
Finish with a list of documents that are referred to but missing.
MATERIAL:
[paste ledger row, certificate details, emails]
A solicitor can do far more with a clean table than with a folder of forwarded emails. If your subcontract ties your release to the main contractor's own receipt of money, read that clause with the same care, because some regimes limit such terms and your solicitor will want to see it.
The mirror ledger: retention you hold on your own subcontractors
If you withhold retention from your own trades, add a second tab with the same columns. The triggers match, the amounts are what you hold, and the disciplines are the same in reverse: release on time when the conditions are met, and do not hold longer than the subcontract allows. Pairing the two tabs shows where cash coming in and going out line up, which makes the monthly forecast honest. Use the assistant to draft release letters conditional on documents, such as "release follows receipt of your as-built drawings and manuals", and keep the same rule of quoting clauses.
One ledger row and one clause: all a reminder prompt needs
The reminder prompt works on a single row and a single clause, which is also the safest way to use it. Swap the client's name for the job reference (R-02 rather than the retailer's name) while you draft, and add the real name and contact in your own email at the end. The amounts and dates have to go in, because a reminder is useless without them, so check where they go. On a personal ChatGPT or Claude plan, turn off the model-training switch in privacy settings first. If you want to paste whole contracts for the extraction step, use a business plan, which keeps business content out of training by default.
Retention and retainage questions from small contractors
How much retainage is normal on a construction contract?
Contracts commonly set it between 5% and 10%, and some reduce or stop the withholding once the work is half complete. Your contract's own percentage and release schedule override any norm. Read the clause, then put the rate and the release triggers in your ledger so the number never depends on memory.
Can I charge interest on retention that is paid late?
Only if your contract or the law that applies to it provides for it, and many contracts are silent. An AI-drafted reminder that mentions interest you are not entitled to can weaken your position. Check the clause and ask a solicitor before claiming it, and where the contract does give a late payment rate, add it to the ledger so reminders can quote it.
What is the difference between retainage and retention?
They describe the same arrangement: a slice of each payment held back until a milestone is reached. Retainage is the wording many contracts use in one market, retention in others, and holdback in some regions. Use whichever word your contract uses in every reminder, because quoting its own term and clause number leaves no room for confusion.
Should I chase retention by email or by letter?
Follow your contract's notices clause for any formal request, and use email for friendly reminders. Keep the formal request short and factual: the clause, the trigger, the date it happened, the amount and what you want. Keep dated copies of everything you send, and ask a solicitor before sending anything that threatens action.
Further reads
- Pay Applications for Subcontractors: Schedule of Values With AI — The pay applications that create the retention in the first place
- Workmanship Warranty: Exclusions to Draft With AI, Then a Solicitor Check — Warranty terms that sit alongside the defects period
- AI in Contracting: Subcontractor Paperwork Chasing Checklist — Chasing the paperwork that releases your own retention
- Can AI Check a Construction Payment Application Before You Send It? — Check an application before it is sent
- Snagging Report Template: Sections, Severity Order and AI Captions — A snag list that closes cleanly before release
- AI Construction Contract Review Software: What Builders Should Test — Test AI contract review on an old subcontract with an answer key and planted changes, then read payment, retention, damages and indemnity yourself.
- Best AI for a Small Construction Company's Financials and QuickBooks — How AI connects to QuickBooks for a small construction firm: three routes compared, the plan job costing needs, and ten entries no AI should post.
- AI Automation for Construction Companies: Daily Logs to Invoices — Six paperwork steps from dictated daily log to progress invoice, one tool each, with a ten-person firm's costs, sums and who signs what.
- Builder Invoice Template: Stage Payment Requests Written With AI — How to turn a contract's payment schedule into stage payment requests and a four-step polite reminder sequence with AI, keeping the figures and tax lines yours.
- Concrete Contract Template: Payment, Cracking and Delay Terms With AI — A staged payment schedule, measurable cracking wording and weather-delay terms for a concrete job, drafted step by step with AI and checked by a lawyer.
- Custom Home Builder Proposal: Draft Allowances and Exclusions With AI — Draft a custom home proposal in ChatGPT or Claude: allowance table, exclusions in full sentences, payment stages that match the work, and pre-send checks.
- Design-Build Proposal Example: A Two-Stage Fee Letter With AI — See a two-stage design-build fee letter with numbers: a stage-one fee built from hours, a stage-two guaranteed maximum price, and AI-drafted wording.
- Finding Construction Bids Worth Pricing: An AI Bid/No-Bid Screen — Where bids come from, a weighted score for fit, margin, competition and client, a prompt that summarises tender packs, and the break-even hit rate.
- Lien Waivers for Small Contractors: Track Conditional and Final Releases — A three-tab sheet that matches each conditional and final lien waiver to the payment it covers, with red-flag formulas and a worked HVAC example.
- Practical Completion Certificate: What Each Clause Means, Then an AI Draft — Each clause of a practical completion certificate in plain English, a filled-in kitchen extension example, and an AI draft you check against the contract.
- AI Tools and AI Development: The Complete 2026 Guide — the AI hub, including every tutorial in the AI-for-business series.
Sources: ConsensusDocs articles on retainage fundamentals and release (July 2025) and on retainage strategies for contractors, both read on 1 November 2026; OpenAI business data page; Anthropic privacy centre.