Subcontractor retainage ledger: separate held, released and received amounts

One retainage total can hide several different states

Consider an illustrative Texas subcontractor whose project ledger shows $7,500 in retainage. The contractor approves a $3,000 partial release, but only $2,000 arrives. If the office changes the retainage cell to $4,500 and marks the release paid, the missing $1,000 disappears from view.

A useful ledger distinguishes held retainage, an approved release that remains receivable and the amount actually collected. The figures can move between categories without changing the total amount still owed. Keep the policy consistent so a transfer is not mistaken for a payment.

The retainage-notice guide addresses separate legal notice questions. This guide is an operational reconciliation of the payment records. It does not set a legally required percentage, determine a release entitlement or provide statutory deadline calculations.

Retainage receivable vs. payable: identify who owes whom

For the subcontractor office, retainage receivable describes retained amounts owed to your business by a customer. Retainage payable describes retained amounts your business owes downstream. They can occur on the same project without being the same transaction or having the same release conditions.

Original simplified illustration: the customer retains $4,000 from your earned billings, while your business retains $1,000 under a separate lower-tier agreement. Those records show $4,000 receivable and $1,000 payable. A $3,000 difference is an internal comparison, not proof that either obligation has been settled or that net presentation is appropriate.

Maintain the counterparty, contract reference and release evidence on both sides. For downstream statement differences, use the supplier reconciliation guide. For basic terminology and the earning calculation, use the retainage guide. Financial-statement classification and journal entries should follow the accounting policy reviewed with your accountant.

Start with the application register and its calculation basis

Record each pay application reference, cumulative earned amount, retained amount, rate or approved calculation basis and any release instruction. For line-specific treatment, keep the affected scope line visible. Preserve the source agreement and application version rather than using a percentage remembered from another project.

AIA’s official payment guidance distinguishes completed and stored amounts, retainage, prior certificates and current payment requests. It also distinguishes fixed and variable retainage treatment. Those are form-specific descriptions; follow the actual form edition, project instructions and agreement.

Tie the record to the progress-billing reconciliation and schedule of values. If an application uses cumulative figures, do not sum every month’s cumulative retained amount as though each were a new withholding.

Worked example: an approved release is only partly paid

Original simplified illustration: cumulative earned work is $75,000 and retainage held before release is $7,500 under an assumed 10% agreement. All nonretained earned amounts are paid. An authorized record approves release of $3,000 of that retainage, and $2,000 is then actually received and allocated to the release.

Under this illustrative ledger policy, the held-retainage category falls to $4,500 when the approved $3,000 transfers to a release receivable. That receivable falls to $1,000 after the $2,000 receipt. Total uncollected retainage-originated amounts are $5,500: $4,500 still held plus $1,000 released but unpaid.

The bridge also equals the original $7,500 less $2,000 collected. Subtracting the approved $3,000 release as though it were cash would understate the open total. Keeping the full $7,500 as held and adding a separate $3,000 release receivable would overstate it. Use one documented policy and confirm the accounting treatment with your reviewer.

Carry the balance through two billing periods

This is a separate fictional scenario from the single-event example above. Opening earned work is $75,000, with $7,500 held under an illustrative 10% agreement and $67,500 nonretained work already paid. Opening released-unpaid is zero. Period A adds $25,000 earned work and $2,500 new withholding; Period B adds $10,000 earned work and $1,000 new withholding. The new nonretained portions ($22,500 and $9,000) are fully paid. There are no taxes, changes, credits, disputes or other releases or receipts. These assumptions isolate retainage; ordinary unpaid invoices need a separate bucket. The percentage is not a required Texas rate, and this arithmetic establishes no release entitlement, posting rule or legal deadline.

Calculate in this order: closing held = opening held + new withholding − approved transfer. Closing released-unpaid = opening released-unpaid + the same transfer − actual receipts allocated to releases. Total uncollected = closing held + closing released-unpaid. Carry both closing balances into the next period’s opening fields.

Period A: $7,500 + $2,500 − $3,000 = $7,000 held; $0 + $3,000 − $2,000 = $1,000 released-unpaid. Total = $8,000. Period B: $7,000 + $1,000 − $1,500 = $6,500 held; $1,000 + $1,500 − $2,000 = $500 released-unpaid. Total = $7,000.

Independent cash bridge: $7,500 opening + $2,500 + $1,000 new withholding − $2,000 − $2,000 receipts = $7,000. Earned-value cross-check: $110,000 earned − ($99,000 nonretained receipts + $4,000 release receipts) = $7,000. Approval transfers have equal amounts leaving held and entering released-unpaid; they do not reduce the total as cash would. Never add the $7,500, $8,000 and $7,000 snapshots as three new debts.

The progress-billing calculator and methodology explain the separate earned-value/request bridge. The general retainage guide also separates ordinary unpaid billing from retained amounts.

Trace applications, approvals and receipt allocations

All references below are fictional. APP-OPEN supports the opening $7,500. APP-A supports $2,500 new withholding and APP-B supports $1,000. REL-A authorizes a $3,000 transfer; REL-B authorizes $1,500. Preserve the application version, affected scope and authorized approval with the ledger.

RCPT-A / ALLOC-A assigns $2,000 to REL-A, leaving $1,000 on that release. RCPT-B / ALLOC-B assigns $1,000 to the remaining REL-A balance and $1,000 to REL-B. REL-A is then settled and REL-B remains $500 unpaid. A bank deposit alone does not identify these allocations. Use the remittance-allocation review to preserve the supporting detail.

Keep closed periods intact. Record later corrections with their own period, source version and explanation, then bridge to the corrected balance. At final-payment closeout, reconcile these categories to the overall customer ledger so released amounts included elsewhere are not counted twice.

Keep an approval separate from the payment event

Retain the release request, approved amount, conditions and affected application or line. If the request remains pending, preserve that status. A form edit or office calculation is not proof of the customer’s approval or proof of cash receipt.

AIA’s Catina guidance explains how retainage entries can be changed on a final payment application. That software action changes the application’s presentation; it does not itself transfer funds into the subcontractor’s account. Verify the underlying authorized release and financial event.

When payment arrives, use the remittance allocation review to determine which application or released balance it covers. Keep an unexplained receipt or deduction separate until the evidence supports an allocation.

Preserve rate changes and unresolved deductions

If a rate changes or a prior application is corrected, preserve both versions and record the affected period or line. Do not rewrite historical retained amounts without an explanation. Check whether the change is prospective, a cumulative adjustment or an actual release instruction.

Keep disputed deductions outside an unexplained retainage subtotal. A challenged back charge, pending change and contractually retained amount can have different supporting records. Use the invoice dispute log for the disputed position rather than presenting it as an agreed withheld percentage.

At closeout, reconcile the held and released-unpaid categories with the overall receivable ledger. Confirm that the same balance is not also counted in a final invoice total without an appropriate bridge. Use the final-payment closeout guide to assign remaining document and collection tasks.

Save a retainage movement sheet with the monthly review

Download the blank period-movement worksheet (CSV) and the filled fictional companion (CSV). They share the same columns and match the Opening, Period A and Period B snapshots above. Numeric amounts are USD values without currency symbols. CSV files contain static values, no formulas or automatic calculations; opening the blank file will not calculate a balance.

Use one row per project/scope and period. Enter opening held, new withholding and the supported approved transfer; calculate closing held. Enter opening released-unpaid, add the same approved transfer and subtract only actual allocated release receipts; calculate closing released-unpaid and the total. Carry both closing amounts forward. The transfer column serves as both transfer out of held and transfer into released-unpaid. Preserve application, approval, receipt/allocation evidence, exceptions and review owner.

In the filled file, APP-OPEN, APP-A and APP-B are application references; REL-A and REL-B identify approvals. Receipt evidence records ALLOC-B’s split between the two releases. Example reviewer is a fictional role, not evidence of a real review. Replace sample references and independently verify all amounts before live use.

The original 14-column single-event review sheet remains available for existing users. In that version, Held before movement means opening held plus supported new withholding; Released receivable before receipt means opening released-unpaid plus approved transfer. Calculate Held after movement by subtracting the transfer, then Released unpaid balance by subtracting the allocated receipt. It has no separate period-opening/new-withholding columns; use the period worksheet for the carry-forward example.

Save a dated reviewed copy and its sources. These original internal review aids do not reproduce an AIA form, select a required rate, establish release entitlement or calculate statutory notice deadlines. Keep separate notice and waiver review records.

• Document the cumulative versus period movement policy.
• Preserve the calculation basis and source application.
• Separate request, approval and actual receipt.
• Reconcile transfers without double counting.
• Assign remaining financial and document exceptions.

Retainage ledger questions

Is 10% required on every Texas subcontract? The rate in the example is fictional. Check the actual agreement and applicable requirements.

Does approval of a release mean the amount is paid? No. Preserve the released-but-uncollected balance until supported receipts or authorized adjustments resolve it.

Should I add every month’s cumulative retainage figure? No. Identify cumulative snapshots and period movements before totaling the ledger.

Does moving an amount into a release receivable change a notice deadline? This guide does not determine that legal effect. Keep deadline and document review tied to the actual project facts and applicable rules.