An iceberg — visible success above the waterline, hidden problems below

Project KPI Dashboard: Why Real-Time Project Monitoring Determines Success or Failure

Monday, 9am. The kickoff call with the client was eight weeks ago. Every weekly standup ended the same way: "We're on track." Then the invoice for week eight lands — and with it, the reality check: 38 hours over plan, three weeks behind the original schedule, and a fifth of the work already delivered was never invoiced. The margin the project was originally calculated on has quietly disappeared.

What happened here plays out in thousands of projects every single week — not because the team did bad work, but because nobody was watching how small deviations add up, week after week. A few extra hours here, a late invoice there, a task that's "basically done" but really only 60% complete. Each individual deviation looks harmless. Added together, they can push a project into the red long before anyone sees it coming.

That's exactly what makes poor project monitoring so dangerous — arguably even fatal for a project's financial success: It doesn't destroy the project with one big blow. The moment the problem finally becomes visible — usually at final invoicing or in the closing report — is the moment it's hardest to fix.

If you've ever run a project, you know the feeling: you have a clear picture — until suddenly you don't. The team is working, tasks are getting checked off, everything feels productive. Without close, timely monitoring, that's exactly what stays invisible until it's the thing that decides whether the project succeeds or fails.

That's the structural problem with traditional project monitoring done in spreadsheets or by gut feeling: it's backward-looking instead of forward-looking. A project KPI dashboard solves this by calculating the most important cost, schedule, and profitability metrics in real time — presented in plain language, not as a raw column of numbers.

In this article, we walk through every single widget in the Zistemo project KPI dashboard in detail: what it measures, how it's calculated, why it matters, and how to tell whether action is needed.

💡
In short: A project KPI dashboard answers three questions in real time — Are we on budget? Are we on schedule? Will the project be profitable? Everything else follows from these three questions.

AProject Status at a Glance

The first group of metrics answers the operational question: is the project running to plan right now? This is where cost and schedule tracking come together in one shared, easy-to-read traffic-light logic.

A.1

Overall Status

The project traffic light: Green, Yellow, Red

Overall Status is the single most important metric in the entire project KPI dashboard: one traffic-light color that shows at a glance whether a project is on budget and on schedule. It combines two values — CPI (cost efficiency) and SPI (schedule performance) — into one shared result.

Why does this matter?

Overall Status is often the only number a project lead or client ever looks at — so it has to be right. Checked regularly, problems can often be spotted and corrected within days. Ignored, nobody notices a project has been sitting on red for weeks until the final invoice or client call brings the truth to light.

Calculation
Traffic light color = MIN(CPI, SPI)The worse of the two scores determines the color.
Green CPI ≥ 0.9 AND SPI ≥ 0.9
Yellow CPI ≥ 0.8 AND SPI ≥ 0.8
Red CPI < 0.8 OR SPI < 0.8
Read the full article on Overall Status
A.2

Budget Usage

Are hours being consumed faster than time is passing?

Budget Usage compares two percentages: how much of the hour budget has already been consumed, and how much project time has already elapsed. When both move in sync, everything's healthy — a gap means the team is burning resources faster than the schedule allows.

Why does this matter?

This is an early-warning system: a gap between hours consumed and time elapsed often shows up weeks before it's visible in the final result. Caught early, it usually just takes a small adjustment to resource allocation. Left unnoticed, it grows into a budget that's already spent by the halfway point — with the second half of the work still fully ahead.

Calculation
Gap = Budget Usage % − Time Elapsed %A negative gap means hours are being used more slowly than time is passing (good).
Green Gap ≤ +5 pp
Yellow +5 to +15 pp
Red Gap > +15 pp
Read the full article on Budget Usage
A.3

Actual Cost

What has the project really cost so far?

Actual Cost sums the personnel cost of every team member for the project hours already worked — based on each person's individual cost rate, not a flat average. This makes it visible when more expensive specialists are accounting for a disproportionate share of hours.

Why does this matter?

Without this figure, many teams plan around a rough average rate — and miss that a single expensive senior team member is single-handedly driving up cost. With a clear view of actual cost, you can rebalance the team early. Without it, you only discover at invoicing that the plan never matched the real team composition.

Calculation
Actual Cost = Σ (Hours × Cost Rate per Staff Member)The sum runs across all time entries of type "Project".
Green Cost efficiency ≥ 0.95
Yellow 0.85 – 0.94
Red < 0.85
Read the full article on Actual Cost
A.4

Progress (EV)

How much work is actually done?

Earned Value (EV) measures real progress — not how much time has passed, but how much planned work has actually been completed. Every finished task "earns" its budgeted hours as progress, regardless of how long it actually took.

Why does this matter?

Without Earned Value, a team relies on gut-feel statements like "it's going fine" — and it's exactly that kind of assessment that lets a project fall surprisingly behind schedule. With EV, progress becomes objectively measurable, so deviations from plan show up immediately instead of only at the deadline.

Calculation
Progress % = Earned Value ÷ Total Budget × 100SPI = Earned Value ÷ Planned Value (expected progress at this point in time).
Green SPI ≥ 0.95
Yellow 0.85 – 0.94
Red < 0.85
Read the full article on Progress (EV)
A.5

Forecast (EAC) Hours

How many hours will the project really need in total?

The hours forecast (Estimate at Completion) projects current cost efficiency onto the remaining work. If the team is running a bit slower than planned, the forecast rises accordingly above the original hour budget.

Why does this matter?

This forecast turns a current snapshot into a look ahead — which is exactly what lets you react early instead of discovering at project close that far more hours were needed than planned. Without this forward view, each week looks unremarkable on its own while the overrun quietly builds in the background.

Calculation
EAC (hours) = Actual Hours + (Remaining Work ÷ CPI)A CPI below 1 automatically increases the forecast.
Green Deviation ≤ +5 %
Yellow +5 % to +15 %
Red > +15 %
Read the full article on Forecast Hours
A.6

Forecast (EAC) Cost

What will the project actually cost in the end?

The cost forecast goes one step further than the hours forecast: it also factors in which team members are expected to handle the remaining work — using their individual cost rates. That produces a far more accurate estimate than a simple average.

Why does this matter?

For the commercial side of a project, this number often matters more than the raw hours forecast: it shows in dollars whether there'll be any profit left at the end. Ignored, a project can look operationally "on schedule" while quietly running away financially, because expensive specialists end up handling more of the remaining work than originally planned.

Calculation
EAC (cost) = Actual Cost + (Remaining Cost ÷ Efficiency)Remaining cost is calculated per task based on the staff member assigned to it.
Green Deviation ≤ +5 %
Yellow +5 % to +15 %
Red > +15 %
Read the full article on Forecast Cost
A.7

Billed

How much of the delivered work has been invoiced?

Not every service delivered gets invoiced right away — many projects bill monthly or at milestones. This metric shows how large the gap is between work delivered and work actually invoiced.

Why does this matter?

Regular invoicing keeps cash flow steady — neglect it, and unbilled work quietly piles up while salaries and running costs keep going regardless. A low billed percentage is often the first sign that invoicing has simply fallen through the cracks of day-to-day work.

Calculation
Billed % = Invoiced Revenue ÷ Total Revenue × 100Only time entries with status "billed" count toward the numerator.
Green ≥ 80 %
Yellow 50 – 79 %
Red < 50 %
Read the full article on Billed revenue
A.8

Unbilled

Work delivered that hasn't earned any cash yet

This value shows the dollar amount of work already completed but not yet invoiced. It's technically already earned — but hasn't reached the client yet. A high value signals a cash-flow risk: salaries and costs keep running while payment is still pending.

Why does this matter?

This metric makes an invisible risk visible: money that's technically already earned but hasn't hit the bank account yet. Checked regularly, it's easy to catch up on invoicing in time. Left unwatched, a significant amount can build up — with real consequences for cash flow, especially when several projects are affected at once.

Calculation
Unbilled = Total Revenue − Billed RevenueThe percentage is Unbilled ÷ Total Revenue.
Green ≤ 30 %
Yellow 30 – 60 %
Red > 60 %
Read the full article on Unbilled revenue

DProfitability & Margin

The second group answers the commercial question: is the project actually making money — and will it still be by the end? For service projects with varying hourly rates, this view is often more surprising than you'd expect.

D.1

Actual Margin

The profit generated so far

Actual Margin shows the profit the project has generated with the work already delivered: revenue minus staff cost. Since the project is still running, this is an interim figure — compare the margin rate against the Budget Margin (D.3) to see whether profitability is on track.

Why does this matter?

Actual Margin is the most honest look at whether a project is really making money — not at the end, but right now. Watched continuously, unprofitable projects or tasks can be spotted early and pricing adjusted for the next engagement. Ignored, a project can look busy for months while barely turning a profit.

Calculation
Actual Margin = Actual Revenue − Actual CostMargin rate = Actual Margin ÷ Actual Revenue × 100.
Green Rate ≥ Plan − 2 pp
Yellow Plan − 5 to − 2 pp
Red Rate < Plan − 5 pp
Read the full article on Actual Margin
D.2

Forecast Margin

How profitable will the project really end up being?

Forecast Margin is the most realistic estimate of total profit at project completion. It uses the same efficiency and staff-cost logic as the cost forecast (A.6), showing whether the project will land above or below the originally planned profit.

Why does this matter?

This metric answers the question that ultimately matters most: is the project worth it overall? Checked regularly, pricing or resourcing decisions can still be adjusted mid-project. Without it, you only find out at project close whether the effort actually paid off — by then it's too late to course-correct.

Calculation
Forecast Margin = Forecast Revenue − Forecast CostForecast Revenue = Actual Revenue + estimated remaining revenue.
Green ≥ Budget Margin
Yellow 0 % to −5 % vs. plan
Red > 5 % below plan
Read the full article on Forecast Margin
D.3

Budget Margin

The originally planned profit — a fixed reference value

Budget Margin is the profit that was planned in the original project calculation. It doesn't change unless the project scope is officially renegotiated. Every other margin metric (D.1, D.2, D.4) is compared against this fixed reference value.

Why does this matter?

Without a fixed reference point, every other margin figure is meaningless — "good" or "bad" can only be judged against a plan. This metric prevents expectations from quietly drifting over the course of a project just because everyone got used to the current situation.

Calculation
Budget Margin = Budget Revenue − Budget CostBudget Revenue and Budget Cost are based on budgeted hours per task and the assigned staff members' rates.
Reference value No traffic-light status — this is the fixed benchmark for every other margin KPI.
Read the full article on Budget Margin
D.4

Margin Δ Forecast

Will the project make more or less profit than planned?

Δ (Delta) means "difference." This metric shows by how many dollars the forecast profit deviates from the originally planned profit — the single most important number for financial controlling. Positive means a better outcome; negative signals action is needed.

Why does this matter?

This single number summarizes what would otherwise be spread across several widgets — which is exactly why it's so useful for reporting to management or clients. Watched closely, you immediately notice when a project starts drifting from plan. Ignored, that drift stays hidden across many individual figures until it has added up to a real, noticeable difference.

Calculation
Margin Δ = Forecast Margin − Budget MarginA positive value means the project will be more profitable than originally calculated.
Green Δ ≥ $0 (at or above plan)
Yellow 0 to −5 % of budget
Red More than 5 % below
Read the full article on Margin Δ Forecast

Why it all matters together

Each individual widget already delivers value on its own. But the metrics show their true strength together: a project can be on budget (A.2 green) and still be falling behind schedule (A.4 red) — that's exactly what Overall Status (A.1) flags immediately, before it turns into a bigger problem. Likewise, a project can look profitable (D.1 green) while a large share of the work remains unbilled (A.8 red) — a silent cash-flow risk that, without a dashboard, often only surfaces at the next bank statement.

That's exactly why real-time project monitoring isn't a "nice-to-have" reserved for large enterprises — it's a decisive competitive advantage, especially for agencies, consultancies, and SMEs operating on thin margins. Spotting a deviation early means you can still correct course, instead of only managing the damage at the end.

Keep every project in view, in real time

Try the Zistemo project KPI dashboard free for 14 days  — all 12 widgets, live on your own project data.

Start free 14-day trial →

Projects Time Tracking Business Management


Also Interesting

Powerful Attendance Time Management: Manage Flex Time, Leaves and Breaks

Flex Time, vacation days and all kinds of leave type: Is your time tracker as flexible as your business? Gone are the days of the 9-to-5 office job. Smart businesses empower their teams with flexible schedules, remote work and cleverly managed projects.

Business Management Features Small Business The Future of Work Time Tracking

Want To Create A Family-Friendly Workplace? Read This!

70% of today’s workers, male or female, feel torn between family and work. Stress, divorce and broken families are the result. It’s time to create a family-friendly workplace! Don’t worry: You don’t have to build your own day-care center to run a family-friendly business.

Small Business The Future of Work Work and Family

7 Tips for Nurturing and Managing Leads for Your IT Company

We all know that in the IT industry, managing leads is key. It’s how you generate business and get your name out there. But even with a good lead management system, it can be hard to keep up with everything when you have so many other responsibilities on your plate.

Tax

How to get paid faster with online payments as Freelancer

You can get paid faster for your freelance services. We recommend online payments to minimize the bureaucracy. Freelancing is an increasingly popular option among professionals. And why wouldn’t it be? You are your own boss, have control of your business (and your destiny), and can even work from home in shorts, t-shirt and flip flops (if that’s your thing).

Articles Tips & Tricks

How to find the best accounting software

It was once commonly accepted that if you were a small business and needed some accounting software there was a simple choice between splashing out on Sage or QuickBooks. But the reign of these leading names is being challenged by a new generation of web-based software like zistemo.

Tips & Tricks

The importance of measuring performance and future planning for freelancers and SME’s

Wouldn’t it be useful if you could analyze the performance of both a team of people as a whole, and individual members of your team? Moreover, wouldn’t it be even more useful if this analysis was performed by an automated process that left you free to concentrate on other aspects of your business?

Articles

One tool, everything under control

No credit card required. Cancel anytime.