Free Template

Free job cost tracker template

An Excel job costing sheet that shows budget versus actual by category, with variance and estimated profit calculated for you. Free, no email, no signup.

Get the template

Grab the Excel file to work in with the formulas live, or the print-ready PDF to fill in by hand.

Both are free, no email or signup. The Excel file has the formulas live; the PDF is print-ready.

See where the job is bleeding

Most jobs go wrong quietly, a little over here and there, until the profit is gone. This tracker puts budget against actual by category so you can see it while there is still time to react.

Enter your budget for labor, materials, subs, equipment, and the rest, then update the actual as the costs come in. The variance calculates on each line, and the estimated profit at the bottom subtracts your total actual from the contract amount.

The committed column is the one people skip and regret. When you sign a purchase order or a sub contract, the cost is real even though the bill has not arrived. Logging it as committed keeps a surprise from showing up at the end.

A spreadsheet like this works, but only as well as you keep it fed, and updating it by hand is the part that slips. When it slips, you are back to finding out at closeout.

FAQ

Job Cost Tracker Template questions

Is this a real Excel file?

Yes. The variance, totals, and profit formulas are live. Enter your budget and actuals and it calculates.

What is the committed column for?

Costs you have signed for but not yet been billed, like a purchase order or a sub contract. It keeps them from surprising you later.

How is estimated profit figured?

It subtracts your total actual cost from the contract amount you enter at the top.

Is this really free?

Yes. No email, no signup. Download it and use it on every job.

Job-cost in real time, not at closeout

Werx tracks labor, materials, and POs against the budget as the job runs, so you see the number before it is too late to fix. 14-day free trial, no credit card.

No credit card required · Free migration assistance · Cancel anytime

Disclaimer: These free tools and templates are provided for general information and estimating purposes only. All results — including quantities, material and cost estimates, load, sizing, and span figures, scores, and any guidance or warnings — are rough approximations that may not fit your specific project, site conditions, local building codes, or current prices. They are not engineering, architectural, structural, legal, financial, or other professional advice, and are not a substitute for a licensed engineer, architect, contractor, or other qualified professional. Always confirm quantities, sizing, and structural, electrical, mechanical, and code requirements with a licensed professional and your local authority having jurisdiction before purchasing materials or performing any work. Werx makes no warranty as to accuracy and accepts no liability for any decision made using these tools. Use at your own risk. See our Terms of Service.