Construction Job Costing Template
Job costing tracks what a single project costs against what you priced it at, broken down by cost code — labour, materials, subcontractors, equipment. A contractor can finish a profitable year made up of jobs that individually lost money, and never know which ones.
The column most spreadsheets miss is committed cost: work ordered but not yet invoiced. A job can look 60% spent against budget while the subcontractor who will consume the rest has already signed. Budget, committed, actual and forecast-final-cost belong on the same row, because the only number that matters mid-job is the forecast — what this job will cost by the time it closes, not what it has cost so far.
Cost codes should be few enough that site staff actually use them and granular enough to tell you something. Splitting labour from materials and subcontractors is usually where the real information is: an overrun in materials points at pricing or waste, the same overrun in labour points at the estimate or the schedule. One blended cost per job tells you only that you lost money.
Two lines decide whether the template matches reality on a construction job: variations and retention. A variation that was done but never signed is an unpriced cost and belongs in the sheet as such; retention held until the defects period closes is revenue you have earned but will not see for months. Both have to sit in the job sheet, or the margin it reports is a number you cannot bank.
Costs land across bank payments, supplier invoices and payroll, which is why job costing in a spreadsheet drifts out of date within weeks. Finmap tags each of those to a project as it happens, so the cost side of the sheet stays current without a monthly reconstruction.
