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
| Company | Ridgeway Home Builders | As of | 46346 | |
|---|---|---|---|---|
| Active projects (In progress) | 3 | Costs to date | 145,430.40 | |
| Revised contract value | 335,800.00 | Unpaid bills (payables) | 30,650.00 | |
| Billed to date | 128,850.00 | Unpaid and past due | 5,400.00 | |
| Received to date | 86,000.00 | Projected profit | 59,010.00 | |
| Owed to you (billed - received) | 42,850.00 | Projected margin | 17.6% | |
| Overdue invoices (balance) | 12,000.00 | Pending change orders | 5,050.00 | |
| Late milestones | 1 | Rows to fix | 0 | |
| Project | Revised contract | Projected cost | Billed | Received |
| Maple Lane Kitchen Remodel | 48,250.00 | 34,500.00 | 34,000.00 | 24,000.00 |
| Oak Street Garage Conversion | 63,700.00 | 52,000.00 | 27,000.00 | 15,000.00 |
| Birch Court Bathroom | 22,850.00 | 19,340.00 | 22,850.00 | 22,000.00 |
| Pine Ridge Second-Storey Addition | 182,800.00 | 155,500.00 | 45,000.00 | 25,000.00 |
| Cedar Lane Deck and Patio | 18,200.00 | 15,450.00 | 0.00 | 0.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
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
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 sheet | In 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. |
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
- Project budget vs actual sheet
- Production tracking sheet for home textiles factories
- Fabric requirements and marker sheet
- Customer accounts, credit sales and customer statement sheet
- Cash book and customer accounts sheet
- Student attendance sheet
- Study planner and lesson tracker
- Weekly study routine sheet
- Online store orders and profit sheet