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

Working the Extra Mile: Managing Overtime and Extra Hours

You need to meet a deadline, your boss requires you to finish a task tonight, or you have to pull a double shift to help out a sick teammate: sometimes you just have to work the extra mile.

Business Management Freelancer Small Business Tax Time Tracking Work and Family

Tips for Creating a Killer Explainer Video

We think that explainer videos are a great way to engage with our customers and familiarize them with our business. Check out tips for creating killer explainer video. The hard part is to get them right.

Business Management Tips & Tricks

Security Strategies You Need to Know When Employees Work Remotely

As more and more businesses are having their employees work remotely, it is important to consider the security strategies needed to protect data and resources. Remote working opens up a variety of security threats that need to be addressed, and there are nine key security strategies to keep in mind when allowing employees to work remotely.

Tax

3 Creativity-Boosters To Make Your Business Succeed

What do Bill Gates, Mark Zuckerberg and Warren Buffet have in common? They are rich, yes. But how did they get there? Hard work? Sure. Determination? Probably. Luck? Maybe. But most of all: they use creativity as a business tool.

Business Management Projects

Forecast (EAC) Hours: How Many Hours Will Your Project Actually Take to Complete?

Project budgets rarely collapse in a single moment. They erode hour by hour — until the end of the project reveals a shortfall that could have been spotted weeks earlier. The Forecast (EAC) Hours KPI makes exactly that possible: a reliable projection of total hours based on real project data, not gut feeling.

Projects Time Tracking Business Management

Industry 4.0: Robots, AI and the Future of Jobs

Robots, Artificial Intelligence and industrial automation are challenging the future of jobs. Industry 4.0, the Fourth Industrial Revolution, has been discussed by the world’s leaders at the World Economic Forum last week.

The Future of Work

One tool, everything under control

No credit card required. Cancel anytime.