How to Track Subcontractor Costs by Project
Reconcile subcontract commitments, progress, invoices, retainage, payments, and cost to finish without counting the same work twice.
Reconcile subcontract commitments, progress, invoices, retainage, payments, and cost to finish without counting the same work twice.
Track subcontractor costs by project with one connected ledger for the agreed scope, work performed, invoices, retainage, and payments. A paid-invoice list answers who received money; it does not show all work already performed or the cost still needed to finish. Review those amounts together at a dated cutoff.
For an established contractor, the useful question is: does this subcontract's forecast still cover its complete scope? Start with one active subcontract and reconcile it before combining vendors into the project total.
Give every subcontract a unique identifier tied to the vendor, project, phase, and cost category. Record the original amount, authorized amendments, revised commitment, scope exclusions, and supporting agreement. Split a vendor's work across projects using identifiable lines; the vendor name alone cannot establish where the cost belongs.
Keep an invoice detail tab with document number, service period, gross work amount, credits, retainage withheld or released, approval status, and accounting reference. Link payments by invoice and payment reference. Preserve previous applications so a cumulative progress request is not entered again as entirely new work.
Retain the underlying documents. The IRS recordkeeping guide identifies invoices, paid bills, receipts, and other supporting records as evidence for accounting and tax entries. This proposed worksheet is an internal management method, rather than an IRS form.
Ask the project manager to verify work performed through the cutoff using installed quantities, completed milestones, or another supported measure. Compare that evidence with the subcontractor's cumulative request. Record disputed quantities and missing documentation as exceptions with an owner and resolution date; do not turn a payment application into unquestioned evidence of physical progress.
Identify work performed but not yet included in posted invoices. For this worksheet, that amount is the unbilled incurred estimate. Accounting should determine whether an accrual or other adjustment belongs in the books. Deposits and stored materials need separate evidence and treatment; a payment does not establish that installation is complete.
Retainage belongs in the payment reconciliation. Document the actual withholding and release terms, approvals, and outstanding amount. Do not assume one percentage or release milestone applies to every subcontract. Have the responsible adviser assess contract terms and applicable requirements when the payment obligation is uncertain.
Checked hypothetical management worksheet: assume a fixed-price electrical subcontract begins at $80,000 and an authorized amendment adds $8,000. The revised commitment is $88,000. All amounts are invented; the example excludes taxes, deposits, stored materials, credits, and disputes.
At the reporting cutoff, supported work performed totals $50,000. Cumulative approved and posted gross work invoices cover $44,000 of that work. The remaining $6,000 is an unbilled incurred estimate. Assume $4,400 retainage has been withheld, none released, and payments total $35,000.
| Cost-to-finish bridge | Amount |
|---|---|
| Posted gross work invoices | $44,000 |
| Work performed but unbilled | $6,000 |
| Committed scope still to perform | $38,000 |
| Revised commitment reconciled | $88,000 |
| Additional uncommitted finish work | $3,000 |
| Forecast final subcontract-related cost | $91,000 |
The $38,000 equals $88,000 minus $50,000 performed. Assume the project manager identifies $3,000 of necessary testing outside the agreed scope, not already included anywhere else. Forecast final cost becomes $44,000 + $6,000 + $38,000 + $3,000 = $91,000. Against an assumed $90,000 subcontract cost budget, this is a $1,000 forecast overrun.
The payment bridge answers a separate question: $44,000 gross invoiced minus $4,400 held equals $39,600 net invoiced. Subtract $35,000 paid to leave $4,600 unpaid excluding retainage. Add $4,400 retainage to reconcile total unpaid invoiced amounts of $9,000. These are worksheet balances, not a conclusion that every amount is currently payable.
A system may show $44,000 remaining commitment because it subtracts posted invoices from $88,000. That amount already contains the $6,000 unbilled work plus $38,000 future work. Adding $50,000 incurred to that untouched $44,000 would overstate the scope by $6,000. Either use posted invoices plus the system's remaining amount, or reconcile incurred work plus the unperformed amount. Then add separately identified uncommitted finish work once.
Trimble's Vista Subcontract Ledger documentation illustrates a system that reduces remaining committed costs as invoices post through accounts payable. Check your own report definitions before applying a formula. Also exclude an accrual already present in posted costs from a second unbilled adjustment.
Payments do not add another cost to this forecast, and releasing previously recorded retainage does not create another scope charge. When the $6,000 invoice arrives, replace its unbilled estimate with the posted amount and investigate any difference. Keep the forecast bridge intact.
Compare each subcontract's forecast with its budget, then check missing invoices, stale unbilled estimates, scope gaps, and duplicated payment applications. Reconcile posted figures to accounting records and document timing differences. Our cost-code guide supports consistent classification; our change-order guide addresses customer changes and pending exposure separately.
Yes, provided connected identifiers, source documents, controlled updates, and reconciliations remain reliable as volume grows. Assign one reviewer for each reporting cutoff.
No. It includes future work and management estimates. GAAP financial statements and tax returns require their applicable recognition, classification, and timing rules. TaxBowl's job-costing accounting service can connect this management review with reconciled books and explain the differences.
The accompanying 2021 Intuit QuickBooks overview illustrates project-level and committed-cost reporting in QuickBooks Enterprise. It is a vendor product overview, not a retainage or reporting-cutoff reconciliation tutorial. Editions and setup differ; check current documentation and reconcile source records rather than treating automated reports as proof of completeness.