Trace subcontractor holdbacks from invoice retention to payment

A subcontractor holdback sits between an approved cost and a later payment. When release documentation arrives, the workpaper should show which original withheld amount is being paid rather than clearing the oldest balance by convenience.

A workable subcontractor holdback payments schedule names the entity, period, currency, source systems, cutoff, preparer, and reviewer. It also records the report filters and extraction time. Those details let the next reviewer reproduce the work instead of trusting an unexplained total.

Export the complete in-scope population before sorting or filtering it. Save a read-only copy with its row count and control total. Compare it with the prior open-item list, then note missing locations, accounts, customers, vendors, or transactions in the exception log.

Do not quietly replace a source file when an updated version arrives. Retain both versions, record who supplied each one, and explain which version the workpaper uses.

Collect the subcontract, approved invoice, pay application, lien document, retention schedule, payment approval, and bank proof. Give each record a stable reference. Capture the source, date, amount, currency, status, and responsible owner. If a document is missing, say so plainly and keep the item open. An estimate or private-message screenshot does not become source evidence merely because the deadline is close.

Begin with the last reviewed position. Put additions, applications, releases, refunds, credits, reversals, and corrections on separate lines. Tie the calculated ending position to the current ledger or operating report. Investigate offsetting differences rather than allowing a net zero to clear them.

Use specific labels such as missing record, timing difference, amount mismatch, duplicate, stale item, or judgment question. Every exception needs an owner, requested action, due date, age, known financial effect, and evidence reference. Close it only when the stated record or approval arrives.

The preparer can compare observed fields, check arithmetic, and draft a focused question. The preparer should not decide release eligibility, lien compliance, and contract disputes. Route that decision to the construction controller, include the amount and deadline, and retain the answer with the workpaper.

Trace selected source records into the schedule and selected schedule lines back to their source. Reperform large entries, manual adjustments, old exceptions, and changes made after the first review. Record the observed mismatch before proposing its cause.

Package the untouched exports, reconciliation, evidence index, exception queue, approvals, and a short status note. State what tied, what remains open, who owns the next action, and which decisions still await review. The file should stand on its own when another person opens it next month.