Construction retainage: track balances and release evidence

Your project is nearing completion, and the receivables report still includes money withheld from earlier payment applications. Track construction retainage as a separate balance with the rule that created it and the evidence needed for release. A completed punch-list item, a release request, an approval, and a bank receipt belong to different stages of that record.

The amount and release conditions depend on the applicable contract and law. Do not copy a percentage or deadline from another job into the register. Procore’s retainage overview discusses differences in laws and contract terms; the workflow below records the determination made by your authorized contract and legal owners rather than choosing that determination for them.

Record the rule behind every withheld amount

Start with company, project, contract, payer, payee, and the contract administrator responsible for the interpretation. Record the document reference and relevant clause, the eligible billing base, the agreed calculation, and any authorized change in treatment. If work and stored materials use different rules, preserve those rules as separate inputs instead of averaging their percentages.

Keep the original basis and effective date when a rate or withholding method changes. The next application may need a different calculation without making previous applications wrong. Your owner should specify whether the change affects prior retained amounts, future applications, or both. A formula copied down an entire workbook (including prior periods) can apply a later decision to periods it never covered.

AIA Contract Documents’ G702 instructions distinguish completed and stored value, retainage, previous certificates, and the current payment request. Keep those categories separate in your working records. A gross billing total can conceal a retained amount if the export presents only the net request.

Reconcile withheld, released, and collected amounts

Use a retained-balance rollforward with an explicit cutoff: opening unreleased retainage plus newly withheld retainage, less authorized releases, equals closing unreleased retainage. In a separate column, show approved releases not yet collected. This definition avoids treating an approval as a bank receipt or leaving the same amount in both unreleased and released balances.

Assume the following hypothetical US-dollar case: a contract-specific 5% withholding applies to $200,000 of eligible cumulative value, with no tax, credits, disputed adjustments, or prior releases. The resulting $10,000 is an illustrative retained amount, not a recommended rate. The authorized team later approves a $4,000 partial release, but no cash has arrived at the report cutoff.

After approval, $6,000 remains unreleased and $4,000 has moved to collection tracking. The total uncollected retained amount is still $10,000. When the $4,000 payment arrives and is matched to that release, the uncollected amount falls to $6,000. Store the release ID and cash reference so the movement can be reconstructed without subtracting the release twice.

If another $50,000 of eligible value is billed under the unchanged hypothetical rule before final release, newly withheld retainage is $2,500. Add that amount to the unreleased balance and link it to its application. The register must show whether an apparent increase came from new withholding, an adjustment, or a failed match to a release.

Build a release-evidence register

Use one release record for an identifiable requested amount. Include the contract ID, request date, amount requested, rule or milestone invoked, supporting-document links, responsible reviewer, decision, decision date, amount approved, and expected collection date. Leave the expected date blank or labeled unresolved when the collection owner cannot support it.

Add evidence requirements only after the responsible owner confirms they apply to this agreement and jurisdiction. Possible project requirements include accepted completion records, closeout documents, or required releases from other parties, but the register does not decide their legal sufficiency. Store received date and review status beside each item so possession of a document cannot be mistaken for acceptance.

Keep the payer’s retained amount separate from retainage you hold against a subcontractor. They can have different agreements, scopes, conditions, and dates. Link the contracts for investigation where useful, but do not net the balances or infer that receiving money authorizes a downstream payment. Contract administrators must resolve the applicable obligations.

For a request returned with comments, preserve the submitted evidence and the reviewer’s reason. Give the next required action an owner and due date, with a link to the replacement document if one is supplied. Changing a status to pending without recording what is missing leaves the next reviewer unable to distinguish a waiting period from an incomplete package.

Keep payment applications and cash dates distinct

Tie newly withheld amounts to the accepted billing version. If the application changes during review, reconcile the retained amount to that version instead of combining the original gross request with a revised net total. The schedule of values article follows the allocation and stored-material calculations that precede this check.

Give approved release collections their own receipt lines in the construction cash flow forecast. Keep the expected receipt date, its source, and the collection owner alongside the contractual date. If the receipt is uncertain, use an explicit scenario rather than placing the amount into the base schedule without explanation.

Do not subtract retainage from a net progress receipt a second time. Confirm whether each source amount is gross or net before building the cash schedule, then trace a sample application through the request, approval, and collection records. This catches a definition mismatch that a check of column totals alone will miss.

Review exceptions that can change the next action

• Find a retained amount without a contract clause or owner-approved calculation basis, and assign interpretation before using it in a release estimate.
• Find a release marked paid without a matched receipt reference, and distinguish collection evidence from an approval email.
• Find a missing document whose requirement has not been confirmed for this contract, and ask the responsible owner to resolve the requirement.
• Find a retained amount appearing in both unreleased and released totals, and reconcile it by release ID.

Save the review cutoff and exception owner with the register. Follow up on the specific missing decision or match rather than treating the entire balance as overdue because the project is old. Aging supports a review, but the relevant contractual and legal dates must be established before anyone labels a payment late.

Where Permute fits in retained-balance reporting

Permute is the context layer we sell between business records and AI tools. We can scope reporting across permitted Sage or QuickBooks transactions, an Excel release register, and contract evidence in Google Drive. Preserve company and contract identities so a payment from the same counterparty cannot be assigned to the wrong job.

We apply your declared definitions of unreleased, approved but uncollected, and collected amounts. A controller can ask Claude or ChatGPT which balances lack release evidence and inspect the source records allowed by current permissions. The report should expose unresolved rules and unmatched cash rather than choosing a plausible completion date.

Keep legal interpretation and payment authority with their owners

We do not determine retainage entitlements, statutory deadlines, lien rights, or accounting treatments. We are not a forecasting engine, and an expected receipt date remains an owner-approved assumption. For this reporting workflow, we read supporting records; we do not submit release requests, authorize payments, or write back into the system of record.

The construction WIP report addresses earned revenue and billing under an approved accounting basis. Keep retainage tracking connected to that work without using a release decision to redefine earned revenue. Your finance owner determines how the retained amount is presented in financial reports.

Make each retained amount explainable

Construction retainage needs a traceable calculation and a separate path through release and collection. Reconcile the withheld balance, preserve the evidence required for each request, and distinguish approval from cash. Use contract-specific rules with named owners instead of assuming that completion creates a universal release date. Keep unresolved conditions visible until the responsible person settles them.

Questions about construction retainage