How to Check Approved Subcontractor Retainage Releases Before Billing
The project team approved a $4,500 retainage release. The pay application includes only $3,000. An older release is already in the prior application. Friday’s review needs the amount still missing from this round.
Compare approved releases with billed releases at commitment and schedule-of-values line level. Keep the approval date, prior releases, held balance, and current application amounts together.
Three approved releases and one current exception
All amounts are in dollars. The remaining held balance is sufficient for the listed approvals in this sample.
| SOV line | Approved release | Previously billed | Current application | Approved and unbilled |
|---|---|---|---|---|
| 03-01 Concrete | $4,500 | $0 | $3,000 | $1,500 |
| 05-02 Steel | $2,000 | $2,000 | $0 | $0 |
| 09-01 Finishes | $1,800 | $0 | $1,800 | $0 |
Concrete is the only $1,500 follow-up. The $2,000 Steel release already appeared in a prior application and should stay out of the current correction.
Export approvals and invoice detail
Get commitment, subcontractor, schedule-of-values line, approved release amount and approval date. Add the current and prior pay-application release amounts. Match a release or approval reference where available and check whether the totals in the source are period or cumulative values.
Check the amount still held
Reconcile release amounts to the remaining balance, taking current withholding, adjustments and previous releases into account under the contract and billing policy. Flag missing approval, cut-off timing or a release larger than the balance separately.
Give the project accountant a line-level follow-up
Keep application references and approval evidence on the exception list so the calculation can be reviewed before any change.
Which approved retainage releases are still unbilled after prior and current applications? Show SOV line, approved amount, billed amounts, remaining balance and source rows.
Review the Concrete line with the project accountant before correcting the application.
Procore on setting and releasing retainage
The contract and figures in this example are synthetic. Confirm release terms and approvals before changing an application.
Calculate the amount to review
For each approved release, subtract the amount already billed in prior applications and the amount in the current application. For Concrete: $4,500 − $0 − $3,000 = $1,500. Steel: $2,000 − $2,000 − $0 = $0. Finishes: $1,800 − $0 − $1,800 = $0. Use one row per approval and do not subtract cumulative billing totals twice.
This is a manually checked synthetic example. A live Jolene.pro result has not been verified.
Compare the approval and application exports in Jolene.pro using the question above. For a downloadable reconciliation exercise, try the vendor statement workbook, or browse Workbook Studies.
Try this with your own spreadsheet at Jolene.pro. Follow Jolene.pro on LinkedIn for more spreadsheet guides.