Softwiro
Free Excel template

Construction Project Tracker for Excel

A free Excel workbook for a general contractor, remodeler or small builder who runs several jobs at once. Each project has a contract value, a cost log, change orders, progress invoices and a milestone schedule. The sheet then tells you, job by job, what has been spent against the budget, what the client owes you, what you owe your subcontractors and suppliers, which milestones are late and what profit and margin you are heading for. It opens in Excel, LibreOffice and Google Sheets and works in any currency.

Excel file (.xlsx) · 204 KB · 12 tabs · works in Excel and Google Sheets · no sign-up

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

Try the sheet here, on the example

The sheet is open below with sample numbers. Change any white cell and watch the results update, or press the blank-copy button to type your own data from scratch. Nothing you type leaves your browser.

Example from the sheet

Example from the “Dashboard” tab, with the numbers and formulas that are in the file.
CompanyRidgeway Home BuildersAs of46346
Active projects (In progress)3Costs to date145,430.40
Revised contract value335,800.00Unpaid bills (payables)30,650.00
Billed to date128,850.00Unpaid and past due5,400.00
Received to date86,000.00Projected profit59,010.00
Owed to you (billed - received)42,850.00Projected margin17.6%
Overdue invoices (balance)12,000.00Pending change orders5,050.00
Late milestones1Rows to fix0
ProjectRevised contractProjected costBilledReceived
Maple Lane Kitchen Remodel48,250.0034,500.0034,000.0024,000.00
Oak Street Garage Conversion63,700.0052,000.0027,000.0015,000.00
Birch Court Bathroom22,850.0019,340.0022,850.0022,000.00
Pine Ridge Second-Storey Addition182,800.00155,500.0045,000.0025,000.00
Cedar Lane Deck and Patio18,200.0015,450.000.000.00

Example from the “Dashboard” tab, with the numbers and formulas that are in the file.

What is inside

  • Dashboard: Active projects, revised contract value, billed, received and owed to you, overdue invoices, late milestones, costs to date, unpaid bills, projected profit and margin and pending change orders. Four charts: revised contract vs projected cost, budget vs actual by cost category, billed, received and costs by project, and milestones by status.
  • Projects: One row per job: ID, name, client, site, contract value, start, target finish and status. A Check column catches duplicate IDs and missing values. Room for 20 projects.
  • Costs: The job cost log: date, project, vendor or subcontractor, category (labour, materials, subcontractor, equipment, permits, other), amount, Paid or Unpaid and a due date. Unpaid bills past their due date turn red. Room for 1,000 entries.
  • Change Orders: Every change with its amount (credits are negative) and an Approved Yes or No. Only approved ones count toward the contract. Room for 200.
  • Billing: Progress invoices and payments received, with the balance, days open and a status of Paid, Open or Overdue based on your payment terms. Room for 500 invoices.
  • Schedule: Milestones with planned and actual dates. Each is marked Done, Done late, Due soon, Upcoming or Overdue, with the number of days late. Room for 200.
  • Subcontractors: For each subcontractor: billed to you, paid, unpaid, unpaid and past due, and the number of unpaid bills. Room for 30.
  • Budget vs Actual: Type a budget for each project and each of the six cost categories. The sheet sets it against actual costs and shows remaining budget, % used and a status.
  • Profit: Per project: revised contract, costs to date, budget, projected cost, projected profit, margin, billed, received, owed to you, unpaid bills and an alert.
  • Settings: Company name, currency symbol, as-of date, payment terms, due-soon window, margin warning level, budget warning level and the cost category list.

The file opens on a start tab (“Start here”) that explains how to use it.

What makes it different

Most free construction trackers are a task list or a budget. This one follows the money through a whole job: the contract and its approved change orders, what you have spent, what you have billed, what has actually been paid to you and what you still owe others. It puts a projected profit and margin on every job, so you see a thin job before it is finished. The sample is five fictional residential jobs as of 2026-11-20.

How do I track costs and profit on a construction job in Excel?

Give every job a short ID, then log each bill, wage run and purchase against that ID with a category and whether it is paid. Total cost to date for a job is the sum of its entries. The profit view takes the revised contract (contract value plus approved change orders), subtracts the projected cost and shows the margin.

Projected cost is the larger of the budget and the costs logged so far, so a job that runs over shows the overrun at once. In the sample, the Birch Court Bathroom has a revised contract of 22,850.00, costs of 19,340.00 against a budget of 17,400.00, a projected profit of 3,510.00 and a margin of 15.4%, and is flagged Over budget. The Pine Ridge addition shows 27,300.00 projected profit on 182,800.00, a margin of 14.9%, below the 15% warning level in Settings, so it is flagged Low margin.

How do I keep a change order log?

Log each change when it is asked for, not when it is approved. Put the description, the amount (a credit to the client is a negative number) and Approved Yes or No. Pending changes stay visible on the Dashboard as pending change orders: in the sample that is 5,050.00 of work not yet approved.

Only approved changes raise the revised contract. On the Maple Lane Kitchen Remodel the contract is 44,000.00 and approved change orders add 4,250.00, giving a revised contract of 48,250.00. The 1,150.00 pantry shelving change is not counted until you set it to Yes.

How do I track what I owe subcontractors and what clients owe me?

Mark every cost Paid or Unpaid and give unpaid bills a due date. The Subcontractors sheet adds up each trade, and the Dashboard shows total unpaid bills (30,650.00 in the sample) and the part that is past due (5,400.00, a roofing bill due on 2026-11-12).

On the other side, Billing shows each invoice with its balance and days open. The sample has 128,850.00 billed, 86,000.00 received and 42,850.00 still owed to you, of which 12,000.00 is overdue on 30-day terms. Retainage, lien waivers and tax rules differ by place, so check your local rules; this sheet does not give advice on them.

How to use it

  1. On Settings type your company name, currency symbol, the as-of date (type =TODAY() to update it daily), your invoice payment terms, the days ahead that count as "due soon", the margin you want to protect and your cost categories.
  2. On Projects add one row per job: a short unique ID (such as P-101), the name, client, site, contract value, start, target finish and status.
  3. On Costs log every bill, wage run or purchase: date, project ID, vendor or subcontractor, category, amount, Paid or Unpaid, and a due date for what you still owe.
  4. On Change Orders log every change with its amount (a credit is negative) and whether the client approved it. Only approved ones raise the contract.
  5. On Billing log each progress invoice and, when the money arrives, the date and amount received. Schedule holds the milestones with planned and actual dates.
  6. Type your budget for each project and category on Budget vs Actual. Subcontractors shows what you owe each one. Profit and Dashboard do the rest.

Before you start:

  • Capacity: 20 projects, 1,000 cost entries, 200 change orders, 500 invoices, 200 milestones and 30 subcontractors.
  • Revised contract = contract value + approved change orders. Change orders marked No are shown as pending and do not count yet.
  • Projected cost is the larger of the project budget and the costs logged so far. Projected profit = revised contract - projected cost; margin = projected profit / revised contract.
  • Budget vs Actual covers the six categories on Settings. A cost with a category that is not on the list is flagged in the Check column.
  • A milestone is Overdue when its planned date has passed and it has no actual date. Done late means it was finished after the planned date.
  • An invoice is Overdue when it still has a balance and more days than your payment terms have passed since it was issued.
  • Use one currency in one workbook. The currency symbol on Settings is only a label. Check your local rules for retainage, lien and tax matters; this sheet does not give advice on them.

Excel file (.xlsx) · 204 KB · 12 tabs · works in Excel and Google Sheets · no sign-up

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

Still running this on Excel?

This sheet suits a start and a limited amount of data. If your way of working grows, or you need more than one person working on it at the same time, Softwiro can build you a program that fits the way you work.

In this sheetIn Custom Software from Softwiro
One file that one person edits at a time, and copies reach you on WhatsApp.A program with a login for each user and permissions you define, and everyone sees the same data.
You type everything and check the numbers by hand.We design the screens around your work steps, so each person records only what concerns them.
Columns and formulas are fixed as the sheet was designed.We build what you need: reports, alerts and screens your way.
Backups and security are your own responsibility.The program runs on a secured server with regular backups.

See Custom Software from Softwiro · Ask for a demo

Frequently asked questions

Is this construction project tracker really free?

Yes. Download it, use it on your jobs and change anything you like. There is nothing to sign up for to open the file.

Does it work in Google Sheets and LibreOffice?

Yes. It uses ordinary formulas such as SUMIFS, COUNTIFS, INDEX and MATCH, so it works in Excel 2016 and later, LibreOffice and Google Sheets.

How many projects and entries can it hold?

20 projects, 1,000 cost entries, 200 change orders, 500 invoices, 200 milestones and 30 subcontractors. Keep each year or each batch of jobs in its own copy of the file.

How is profit and margin calculated?

Revised contract (contract value plus approved change orders) minus projected cost, where projected cost is the larger of the budget and the costs logged so far. Margin is that profit divided by the revised contract.

Why does a row show Unknown project or Unknown category?

The project ID or category does not match one on Projects or Settings. Pick it from the dropdown, or add the project or category first. The Check column on each log tells you what is wrong, and the Dashboard counts the rows to fix.

Is the template free?

Yes, with no sign-up and no email address. Use it, edit it and share it as you like.

Does it work in Google Sheets and on mobile?

The sheet uses formulas supported by Excel 2016 and later, Google Sheets and LibreOffice, so you can upload it to Google Drive and open it with Google Sheets on a computer or a phone.

What is the difference between the white and the gray cells?

You type in the white cells; the gray cells are calculated automatically. Don't type in a gray cell, or you will erase its formula.

Can I use the sheet from an AI assistant?

Yes. Add our MCP server (URL https://softwiro.com/api/mcp, no key needed) to your assistant and ask it to do the calculation in this template. The numbers come from the sheet's own formulas, and we do not store your data. The steps and a ready-made prompt are in this article: https://softwiro.com/blog/mcp-excel-templates-ai-agent-guide.html

More free templates for: Contracting and finishing

More free templates

All templates · Free tools