Construction · job costing & WIP

The job looked profitable. Then it closed out.

Budget versus actual by cost code, burdened labor, committed cost, and the WIP schedule your banker keeps asking for. You find out in week three instead of at closeout. Works in Microsoft Excel and Google Sheets.
GET THE WORKBOOK $79
Works in Excel AND Google Sheets · instant download · Sheets script in the guide · free updates
Company dashboard — every job, live from the labor, purchase and subcontract tabs

Most contractors find out how a job went after it's over

By then the labor is spent, the subs are billed, and the only thing left to do is explain it. These are the three places the money actually goes missing.
01

Labor that isn't really $32/hr

Reg and OT wages, then burden on top at your rate. Payroll tax, comp, insurance, benefits. Unburdened labor is the most common way a contractor underprices work.

02

Money you owe but haven't paid

Open POs plus the unearned balance on every subcontract. Committed cost is what turns a code that looks fine into one you already blew.

03

Percent complete you can defend

Cost-to-cost, the same method your CPA and your bonding agent use. Earned revenue, over billings, under billings, calculated.

What's inside

Every figure below is live in the file. Nothing here is a mockup.

Budget versus actual, by cost code

Pick a job from one dropdown and the whole report re-filters. Every cost code shows what you budgeted, what you've spent across labor, material and subs, what's still committed, and where that lands you.

  • OVER / WATCH / OK flag on every line
  • Projected total = actual plus open commitments
  • Projected gross margin against your target
  • Codes with cost and no budget get flagged
Job cost report — one job, all cost codes

The WIP schedule

The tab that gets a spreadsheet taken seriously. Cost-to-cost percent complete, earned revenue against billings, and over/under billing per job with a company total.

  • Revised contract including approved change orders
  • Earned revenue and gross profit to date
  • Over billed and under billed, separated
  • Backlog by job and in total
WIP schedule — percent complete and over/under billings

The specifics

7,101
live formulas
10
tabs
50
jobs
Excel + Sheets
works in both

Before you buy

Why $79 when there are $19 templates?
A $19 template is a formatted grid you fill in. This one carries the accounting: burden on labor, committed cost from open commitments, cost-to-cost percent complete, over and under billings. The difference shows up the first time a job goes sideways.
Will this replace QuickBooks?
No, and it isn't trying to. This is a job costing and WIP tool. It tells you things QuickBooks won't, several weeks earlier.
Do I need Excel?
It works in both. Excel opens it as-is. For Google Sheets, upload it and run the one-minute setup script printed in the back of your setup guide — charts, color rules and dropdowns all rebuild automatically.
How long to set up?
An afternoon if your estimate is already broken to cost code. Five sample jobs are loaded so you can see how it behaves before you clear them.
What if my cost codes are different?
Replace them on the Setup tab. Thirty-five CSI-style codes are loaded as a starting point and every dropdown in the file follows whatever you put there.

Hard Numbers · Construction

The workbook plus a step-by-step setup guide. Works in Excel or Google Sheets. No login, no subscription, no seat count. Download it, open it, and put your own numbers in this afternoon.

$79
ONE TIME
30-day refund, no questions