Job Cost Sheet: What Goes On It + a Free Construction Template

Search this term and you get two completely different answers. Half the results are accounting-textbook definitions written for students taking a job-order costing exam. The other half want to sell you a template. This page is the contractor version: what actually belongs on the sheet, a free one you can download and use today, and a real $42,000 job filled in so you can see how it reads when the numbers go wrong.

What goes on a job cost sheet

Four blocks. Everything else is decoration.

A textbook would call the first three direct materials, direct labor, and applied manufacturing overhead, because job-order costing was invented for factories making batches of things. The idea transfers to construction perfectly. The vocabulary does not, which is why every accounting-class explanation of this feels slightly foreign to somebody who buys tile.

Download the sheet

Here is the one I would hand a contractor who asked. It is a real spreadsheet, not a picture of one, and it does the arithmetic itself:

Download the construction job cost sheet (.xlsx) — free, no email required.

What is in it:

• Cost-code rows grouped the way a remodel actually runs — demo, rough, materials, subs, finish, cleanup — with labor, materials, subs, equipment and other columns across.
• Estimate, actual, and variance columns that recalculate as you type. Variance is the column you check on Fridays.
• A totals block that computes total cost, gross profit, and margin from your contract amount — so you never have to remember whether you were dividing by cost or by price.
• A second tab with the $42,000 bathroom already filled in, so you can see a finished example before you start a blank one.

If you would rather have the fuller multi-job version, there is also a free construction job costing spreadsheet that tracks several jobs at once. This sheet is deliberately one job, one page.

A real job, filled in

This is the bathroom I bid at $42,000 expecting a 30% margin. On a job cost sheet, the story is visible in one glance — which is the entire argument for keeping one.

Notice what did not happen here. No single catastrophe. No client from hell, no supplier who doubled a price. Just five categories that each ran a bit over, adding up to $7,560 — which is almost exactly the $7,500 of receipts that never made it onto that job. I was not losing money on the work. I was losing it on the record-keeping, and the two are indistinguishable at year end.

The expensive part came later. Because that job looked cheaper than it was, I bid the next several off the same understated costs. A job cost sheet you fill in as you go catches that in week two, while you can still do something about it — call the change order, tighten the scope, or at minimum stop repeating the number.

Estimate vs. actual: the column that matters

A sheet with only an actual column is a receipt pile with better formatting. The value is in the comparison, and there are two honest ways to read it:

• Dollars overtells you the size of the problem. "Materials are $2,960 over" is a number you can act on.
• Percent complete against percent spent tells you whether you are in trouble early. A job that is 60% built and 85% spent has a problem, and it has it now — not at closeout.

That second one is the reason to fill the sheet in weekly instead of at the end. A job cost sheet completed after the job is history. Completed during the job, it is a steering wheel.

Cost codes without an accounting degree

Cost codes sound like something you need a system for. You do not. A cost code is just a label for a phase of work so you can tell where the money went, not only how much left.

For a residential remodeler, six to ten codes is plenty: demo, framing/rough carpentry, plumbing, electrical, drywall, tile/flooring, cabinets/counters, paint, fixtures, and cleanup/disposal. Big commercial outfits use the CSI MasterFormat divisions, which are excellent and enormous. You do not need fifty divisions to run a bathroom.

The one discipline that matters: use the same codes on every job. Codes that shift between jobs make comparison impossible, and comparison across jobs is where the real learning lives — the moment you can see that your tile labor runs over on every single job, you have found a bidding fix worth more than any single sheet.

The spreadsheet is right until it is not

I am giving you a spreadsheet, so let me be straight about where it stops working. It stops at the same place mine did.

A job cost sheet is only as current as the last time somebody typed into it. The sheet was never my problem — the formulas were fine. My problem was the four days between buying $900 of tile and sitting down at a laptop, and the receipt that spent those four days in a truck console. Multiply by three open jobs and a busy month and you get exactly the $7,560 above.

So: run the spreadsheet if you are on one or two jobs and you will genuinely update it weekly. That is a real answer, and it is free. The honest test of whether you have outgrown it is not job size — it is whether the sheet is still current on a Friday you did not plan for. If it is not, the fix is capture, not a bigger spreadsheet. There is a fuller comparison in job cost tracking apps vs. spreadsheets.

That gap is what I built Job Cost Pro to close: photograph the receipt at the supply-house counter, the AI reads the line items and files them to the right job, the crew clocks in on site so hours land at real cost, and the sheet above is filled in continuously instead of on a Sunday night. It exports into QuickBooks. It does not do estimating or scheduling, and it is iPhone only today. Free on the App Store: 3 projects, 50 receipts a month, AI scanning included, no card. Get it here.

Either way — spreadsheet or app — keep the sheet. The contractors who know their numbers and the ones who guess are not separated by software. They are separated by whether anybody wrote the costs down against the job while the job was still open. Start with what job costing is, or run a quick what-if through the job cost calculator.