Free Construction Project Tracker for Small Business Contractors
Most contractors don't need more jobs first — they need a clearer view of the jobs they already have. Track one job completely: budget vs. actual cost, change orders, materials, and deadlines, so no job quietly loses money.
Free · Works in Excel and Google Sheets · No sign-up required to download
Scored low in Operations on your BizHealth assessment? This is where you start.
Interested in a full Business Health Assessment?You're in the Right Place If…
- You've finished a busy job and the bank account didn't really grow.
- Change orders get approved and built — but slip through without being billed.
- You only find out you're over budget at the end of the job.
- Materials or deadlines keep surprising you mid-job.
- You need a simple way to run one job well before investing in bigger software.
What You're Getting
Two files, built to work together — a working tracker and the plain-English guide that shows you how to run it.
Construction Project Tracker (.xlsx)
- One clean file per job
- A dashboard that shows projected profit, margin, and cash at a glance
- Budget-vs-actual cost tracking with automatic over-budget flags
- A change-order log that surfaces approved work you haven't billed yet
- Material shortage and deadline flags
- Works in Excel and Google Sheets
How-To Guide (PDF)
- Plain-English, first-time-owner friendly
- 10-minute setup walkthrough
- A full worked example carried all the way through
- What each dashboard number means and what to do when it's red
- Common mistakes, a glossary, and the margin-vs-markup math that raises your prices
How It Works
- 1
Save One File Per Job
Open the tracker, choose File ▸ Save As, and name it for that job.
- 2
Set It Up in About 10 Minutes
Enter your contract, dates, and budget by category — you'll see your bid margin instantly.
- 3
Update It Weekly
Log costs, change orders, and materials as they happen.
- 4
Read Your Dashboard
It shows profit, margin, cash, and — in plain English — the single most important thing to do next.
See It Work: A $48,000 Kitchen Remodel
In the guide, one job is carried all the way through. The dashboard shows a projected 18.4% margin — above the 15% target, so it reads HEALTHY. And yet the “do next” line says collect a payment, because cash on the job is running about $19,800 negative. That's the whole point: the tracker tells you the real priority — a job can be profitable on paper and still run out of cash mid-build.
How to Keep One Job on Budget from Day One
Good job control starts before the first invoice. The one question to ask: can I see this number, or am I guessing?
- Enter the full budget before work starts
- Log committed cost when you sign a sub or P.O., not when the invoice lands, and track true cost by job as you go
- Update actuals weekly
- Bill every approved change order the week it's approved
- Track materials against their needed-by dates
Quick-filter tip. If you can't see the number, you can't defend it.
Warning Signs a Job Is Quietly Losing Money
A job usually doesn't blow up — it drifts. Here's the drift to watch for.
Warning signs
- You're busy but the bank balance isn't moving
- Change orders are done but not billed
- You learn you're over budget only at closeout
- Materials arrive late and idle the crew
- “We'll sort the paperwork later.”
A busy job is not the same as a profitable job. Pair this tracker with a habit to keep an eye on job-level cash across the business.
Make Job Decisions with Numbers, Not Memory
Pride and momentum are real, but the numbers should make the call.
- Is this line over budget, and why?
- Is every approved change order billed?
- Will a late material or slipped milestone push cost or push the deadline?
- Is projected margin still above your target?
If you couldn't see this job's numbers today, would you still say it's going fine? If you're not sure, the tracker is the fix.
Straight talk. The contractors who keep the most profit aren't the busiest — they're the ones who always know where each job stands. This tracker is how you become one of them.
Other Tools for Construction Businesses
Estimate it → win it → track it here → watch your cash. The tools work as a system.
Keep Building Your Construction Know-How
Getting Your Jobs Under Control?
See where else your business is leaking time or money — explore a full BizHealth Business Health Assessment.
See PricingFAQs — Questions Contractors Ask
Is the Construction Project Tracker really free?
Yes. The single-job tracker and the how-to guide are free to download and use. A paid multi-job version is planned for contractors running many jobs at once.
Do I need Excel, or does it work in Google Sheets?
Both. The workbook opens and works in Microsoft Excel and Google Sheets.
How is this different from a job-costing calculator?
A job-costing tool prices a bid — is this job profitable? This tracker runs the job after you win it — actuals vs. budget, change orders, materials, and deadlines over the life of the job.
How long does it take to set up?
About 10 minutes for one job. The guide walks you through it step by step.
Do I use one file for all my jobs?
No — one file per job (File ▸ Save As per job). It keeps each job simple and deep. A single screen across all jobs is the paid roll-up built on top of these files.
What if I'm not a numbers person?
That's who it's built for. You fill in a few boxes; the tracker does the math and tells you, in plain English, what to do next.
The Construction Project Tracker and its guide are educational tools. They are not legal, tax, or accounting advice.