Skip to content
Construction

Construction Project Dashboard: What to Track Across Every Job (2026)

What a construction project dashboard should show: 8 numbers per job, a four-job example, how to build it from your job sheets and how to review it weekly.

By Ryan Kramer, founder of Wisegrid. Last updated November 2026.

A construction project dashboard is one screen that shows how every job is doing. For each job it pulls a handful of numbers from the job’s own sheets: contract value, billed to date, projected margin, schedule status and the open items that could cause trouble. Owners and project managers use it to spot the one job that needs attention this week.

Most small contractors have the numbers. They are spread across a job costing file, a change order log, a schedule and a stack of invoices. A dashboard puts them side by side so problems show up early. This guide covers the eight numbers worth tracking, a four-job example, how to build the dashboard from sheets you already keep, and how to review it in 20 minutes a week.

Key takeaways

– Track a few numbers per job, not everything. Eight is enough for a weekly decision.

– Projected margin is the headline number. It combines cost so far, cost to finish and approved changes.

– Open items predict trouble. Late requests for information (RFIs), late submittals and unsigned change orders show up before cost and schedule slip.

– Cash belongs on the dashboard. Unpaid invoices and retainage decide whether you can make payroll.

– Feed the dashboard from job sheets so nobody retypes numbers on Friday afternoon.

What is a construction project dashboard?

It is a summary sheet with one row per active job. Each column is a number that comes from that job’s detailed records. The dashboard does not replace those records. It points to the job that needs a closer look, and the detail lives one click away.

A good dashboard answers three questions every week: Is each job making the money we expected? Is it on schedule? Is anything about to go wrong? If it cannot answer those, it is a report, not a dashboard.

Which numbers should a construction dashboard track?

These eight cover money, time and risk. The table shows what each one means. You can add more later, but start here.

Number What it shows
Projected margin (Contract − projected cost) ÷ contract
Billed vs complete Billing ahead of or behind the work
Cost variance Budget − projected cost
Schedule status Days ahead or behind the plan
Open RFIs and submittals Count, and how many are late
Pending change orders Count and value not yet signed
Unpaid invoices Amount billed but not received
Safety incident rate Recordable cases per 200,000 hours

Projected margin comes from your construction job costing sheet: actual cost plus cost to complete. Billed vs complete compares the percent you have billed with the percent of work done, line by line on your schedule of values. Billing well ahead of the work can upset the owner, and billing behind means you are paying for the job yourself. For a single line, the free cost variance calculator checks the math.

The safety number uses the formula from the U.S. Bureau of Labor Statistics: recordable cases × 200,000 ÷ hours worked. The 200,000 stands for 100 full-time workers for a year. Two recordable cases in 96,000 hours gives a rate of about 4.2.

Construction dashboard example

A contractor with four active jobs. The first table is the money and schedule view. The bold row is the job that needs attention.

Job Contract Billed Margin Schedule
Maple St addition $186,000 $93,000 22.8% On track
Medical office fit-out $492,400 $286,000 9.4% 6 days late
Riverside retail shell $1,240,000 $310,000 14.1% On track
Elm St kitchen remodel $258,750 $194,000 18.6% 3 days late
Total $2,177,150 $883,000

The second table is the risk and cash view for the same jobs. The bold cells are the items to act on this week.

Job Open RFIs Late submittals Pending changes Unpaid
Maple St addition 0 0 1 $46,500
Medical office fit-out 2 1 2 $50,895
Riverside retail shell 4 3 0 $0
Elm St kitchen remodel 0 0 2 $0
Total 6 4 5 $97,395

What this tells you: the medical office job is the problem. Its margin has dropped to 9.4%, it is six days late, and it has two open RFIs and a late submittal. Those are probably connected. Riverside looks fine on money and time, but three late submittals on a shell building usually mean late materials in a month. And $97,395 is billed but unpaid, so the cash conversation is as urgent as the schedule one.

Watch: Construction Project Dashboard from Scratch (2 minutes)

Watch “Construction Project Dashboard from Scratch” on YouTube →

How to build a construction dashboard, step by step

  1. Give every job the same sheets with the same columns. Job costing, change order log, RFI log, submittal log and billing. Our construction project management templates list the full set.
  2. Pick one cell per number on each job sheet, such as total projected cost or count of late RFIs. The dashboard reads those cells, nothing else.
  3. Build one row per job on the dashboard with references to those cells. No retyping.
  4. Set simple flags. Margin more than two points below plan, more than three days late, any RFI or submittal past due, any invoice older than 30 days.
  5. Add a cash section with unpaid invoices and retainage held. The retainage guide explains why that money matters.
  6. Review it at the same time every week and write one action per flagged job.

How to review the dashboard each week

Twenty minutes, same day every week. Start with the flagged rows only. For each one, open the job’s detail and find the cause: a cost line in the job costing sheet, a late item in the RFI log or submittal log, or an unsigned change in the change order log. Agree one action and one owner, then move on.

Unpaid invoices get their own two minutes. Check each one against the payment terms, and call about anything past due. If a payment application was cut, compare it line by line with the American Institute of Architects (AIA) G702 payment application you sent.

Common dashboard mistakes

  • Too many numbers. Thirty columns means nobody looks at any of them.
  • Numbers typed in by hand. They are out of date by Monday, and nobody trusts them.
  • Only lagging numbers. Cost and schedule tell you what already went wrong. Open RFIs and pending changes tell you what is about to.
  • No cash view. A profitable job can still empty your bank account.
  • No action after the review. A flag with no owner and no date is just decoration.

From spreadsheet to a live dashboard

You can build this in Excel with one workbook per job and a summary file that links to them. It works until a file is renamed, a link breaks, or someone works in a copy and the summary shows last week’s numbers.

In Wisegrid, each job is a set of sheets in one workspace, and the dashboard uses cross-sheet references to pull the numbers live. When a superintendent logs an RFI or the office signs a change order, the dashboard updates. Owners and partners can view it for free. The construction project dashboard template has the layout above ready to copy, and the executive project status report template turns it into a monthly summary.

FAQ

What KPIs should a construction company track?

Start with projected margin per job, cost variance, schedule status, billed vs complete, unpaid invoices and a safety incident rate. Add open RFIs, late submittals and pending change orders as early warnings. Track them weekly per job, then roll them up for the whole company.

How often should a construction dashboard be updated?

The numbers should update whenever the job sheets do, ideally the same day. Review the dashboard weekly. Monthly reviews are too slow on jobs that last a few months, because a problem found in week eight is hard to recover.

What is the difference between a dashboard and a status report?

A dashboard is a live, one-screen view of every job, used to decide what to look at. A status report is a written summary for a specific audience, such as an owner or a partner meeting. Most teams build the report from the dashboard.

Can I build a construction dashboard in Excel?

Yes, with a summary sheet that links to each job’s workbook. It gets fragile as jobs and people grow, because links break and files get copied. A shared workspace that references sheets directly avoids that.

Sources


See every job on one screen

Start with the construction project dashboard template, feed it from the construction job costing template, and track changes in the change order log.

Start free → · Dashboard template → · Wisegrid for construction →


About the author Ryan Kramer is the founder of Wisegrid, a higher-capacity work management grid built around a 1,000,000-cell-per-sheet limit, date-triggered automations with run history, and cross-sheet reporting. He writes about the project management documents teams actually keep updated. More from Ryan →