Scheduling

Construction project tracker template

A construction project tracker puts every active job on one sheet: who runs it, when it finishes, how far along it is, what is billed, and what could go wrong next. Download this template as a CSV for Excel or Google Sheets, or print it for the Monday meeting.

Two construction professionals review paper plans beside a tablet at a jobsite workbench.
Plan reviews connect field conditions, drawings, and the next decisions on a job. AI-generated illustration.

A construction project tracker template is a one-row-per-job summary of everything you have running. It is not a schedule and it is not a job cost report. It is the sheet an owner or operations manager reads in five minutes to know which jobs need attention this week. Each row shows the PM, the contract value, start and target completion, percent complete, the next milestone, billed to date, and a plain-language risk flag.

Once a company has more than four or five jobs going, nobody can keep them all in their head. Things slip through the gaps between the schedule, the billing, and the PM's notebook. The tracker is where those three meet.

What the project tracker is for

Use it for a weekly operations meeting. Walk the list top to bottom, and for each job ask three questions: is the next milestone still on its date, is billing keeping up with the work, and what is the one thing that could hurt us? If a job has no answer to the third question, the PM probably has not looked hard enough.

The tracker also helps with crews and cash. Two jobs both hitting rough-in the same week tells the superintendent something. A job at 70 percent complete and 40 percent billed tells the bookkeeper something different.

Keep one master copy that the office owns, and have PMs update their own rows before the meeting rather than reading numbers aloud while someone types. A tracker that takes 20 minutes to fill in during the meeting will not survive a busy month.

How to fill in each column

  • Job no. and project: the number and name used in accounting, so the tracker ties to the books.
  • Client and PM: who you work for and who owns the job internally.
  • Contract value: current contract, including approved change orders.
  • Start date and target completion: from the current schedule, not the original bid. If the date moved, the risk column should say why.
  • Percent complete: the PM's estimate of physical progress. Compare it with billed to date.
  • Billed to date: the total invoiced. Billed to date divided by contract value gives a quick billing percentage to compare with progress.
  • Next milestone: the next event that matters: inspection, delivery, substantial completion, a pay app due date.
  • Status and risk: on track, watch, or at risk, plus one short reason.

Common mistakes

  1. Letting the tracker become a second schedule with 40 columns. Keep it to what fits on one screen.
  2. Updating it only before the bank meeting. Weekly or it is stale.
  3. Using the original completion date after the schedule has moved.
  4. Marking every job on track. If nothing is ever at risk, the column is not being used honestly.
  5. Leaving closed-out jobs off while retainage is still unpaid. Keep them until the last dollar is in.

Related forms and guides

For running several jobs at once, see how to manage multiple construction projects at once and how to write a construction project status report. Detail for each row lives elsewhere: dates in the construction schedule template and the three-week look-ahead template, money in the WIP report template. The milestone column often tracks long-lead items and substantial completion.

Smart Business Automator keeps project status, billing, change orders, and shipment tracking in one place, so the tracker builds itself from live job data. See construction workflow automation and pricing.

Active project tracker

Download CSV
Job no.ProjectClientPMContract valueStart dateTarget completionPercent completeBilled to dateNext milestoneStatus and risk
J-2401Dental office TIHarbor Dental GroupR. Ortiz482,652.502026-04-062026-08-1450%262,000.00Ceiling grid inspection 2026-06-18On track
J-2402Retail shell buildingPine Street PartnersK. Walsh1,250,000.002026-03-022026-12-1830%340,000.00Steel erection complete 2026-06-26Watch: switchgear lead time pushed to 2026-08-03
J-2403Church roof replacementGrace FellowshipR. Ortiz215,000.002026-05-042026-07-0290%204,250.00Final roof inspection 2026-06-24On track
J-2404Warehouse office buildoutDunmore LogisticsS. Patel86,500.002026-06-012026-08-0725%21,625.00Rough-in inspection 2026-06-30On track
J-2405Clinic renovationValley HealthK. Walsh640,000.002026-01-122026-07-1790%560,000.00Punch walk 2026-07-08At risk: owner furniture delivery may delay turnover
J-2306Bank branch remodelFirst County BankS. Patel312,400.002025-09-082026-02-27100%312,400.00Retainage release request due 2026-06-30Watch: retainage of 15,620.00 unpaid
  • Sample data only. Replace the example jobs with your own active and recently completed jobs.
  • Billed to date divided by contract value gives a quick billing percentage to compare with percent complete.
  • Use the current schedule's completion date, not the original bid date.
  • Keep jobs on the tracker until retainage and final payment are collected.
  • Update weekly, before the operations meeting.

Frequently asked questions

What should a construction project tracker include?

At minimum: job number, project name, client, PM, contract value, start and target completion dates, percent complete, billed to date, next milestone, and a status or risk note.

Is a project tracker the same as a construction schedule?

No. A schedule lays out the activities on one job. A tracker summarizes all jobs at a high level so managers can see where to focus.

How often should the project tracker be updated?

Weekly is the common rhythm, ideally right before an operations meeting where each PM walks their jobs.

Can I use this project tracker template in Excel?

Yes. Download the CSV and open it in Excel or Google Sheets. Add conditional formatting on the status column so at-risk jobs stand out.

Written and edited by

Maurice Francois writes and edits construction operations guides for Smart Business Automator. More from Maurice on the Scaling Legends podcast.

Get a free assessment