Project Profitability Dashboard: How to Track the Real Margin on Every Project

A project profitability dashboard shows the real margin on every project in real time. It sets the income tied to a project against the costs booked against it, so you can see whether each one actually makes money while the work is still happening, not in a report at month’s end. The practice underneath is simple to say and harder to do: track income and expense per project, not just for the business as a whole.

For any business that runs on projects or jobs, agencies, consultancies, contractors, studios, any firm that bills by engagement, this is the number that matters most. Company-level profit tells you the business made money. Project-level profit tells you which clients drove it, which jobs ate into it, and whether the price you set at the proposal stage is holding up against what delivery actually costs.

Plenty of owners already have a dashboard. Most of the time it reports at the company level and never tells them which projects are the problem. Here’s what a project profitability dashboard should actually show, how to calculate the core numbers, and how to build one that stays current without a spreadsheet.

What Project Profitability Is and Why It Matters

Project profitability is the margin a specific engagement generates after the costs tied to it are taken out of the income it brings in. Did this project make money, and how much?

It matters more than company-level profit for one reason. A business running 15% net margin overall might have five projects going at once. Two at 35%. Two breaking even. One losing money on every hour delivered. The company number hides all of that. The project number shows it.

The businesses with the sharpest financial performance track profit at the project level in real time, not from a monthly report that tells them what already happened. They know which work pays and which doesn’t, and they’ve stopped taking on the work that doesn’t. We get into

The Project Profitability Formula

The math is simple. The discipline is in the inputs.

Gross margin

Project gross margin = (project income minus direct project costs) divided by project income, as a percentage. It’s the same gross margin you’d run for the whole business, pointed at a single project.

A project invoiced at $20,000 with $11,000 in direct costs makes $9,000, or 45%.

What counts as a direct project cost

This is where most businesses get it wrong. Direct costs are everything spent specifically for this engagement:

• Freelancer and contractor fees billed to the project
• Reimbursed expenses approved against the project
• Software or tools bought or licensed just for this work
• Any third-party pass-through cost you don’t bill the client separately

If salaried people deliver the work, their time is a real cost too. Capturing it properly means a loaded hourly rate (salary plus taxes, benefits, and a share of overhead), fed from a time tracker, not a billing rate and not a bare salary. That’s a separate layer from the money moving in and out, and it’s the piece most owners either skip or get wrong. If you’re not tracking time yet, at least account for the direct money costs above, since those are the ones you can watch move.

On the income side, count what the project actually brings in, including approved change orders. If extra scope got delivered but never billed, that’s margin leaking quietly, because the cost was real even if the income never showed up.

Net margin

Project net margin = gross margin minus a share of overhead (rent, software, admin, the time you spend running the business), usually allocated as a percentage of income. Net is the more complete measure. Gross is the most useful one day to day, because you can act on it directly.

For most project work, aim for a gross margin of 50% or higher. Below 40%, the project won’t contribute much once overhead comes out.

The KPIs a Project Profitability Dashboard Can Track

A good dashboard keeps the metric count low. Pack in twenty numbers and none get acted on. The owner opens the screen, feels swamped, and closes it. Eight is a sane ceiling, each one mapping to a specific decision when it goes red.

Two things to know before the list. Some of these come straight from your income and expense data. Others, like utilization and cost per hour, only work if a time tracker is feeding them. Know which you can actually populate before you design the screen.

KPI	What it measures	Target benchmark	Red flag
Project gross margin	Revenue minus direct costs, divided by revenue	50% or above	Below 40%
Billable utilization	Billable hours divided by available hours per person	65 to 75%	Below 60%
Actual vs. budgeted hours	Hours spent vs. hours scoped and sold	Within 10% of the budget	Over by more than 15%
Revenue per employee	Total revenue divided by headcount, including contractors	$120,000 to $200,000	Below $100,000
Cost per project hour	Total project cost divided by hours delivered	Benchmark against your own history	Rising quarter over quarter with no rate increase
Aged receivables	Outstanding invoices grouped by days past due	Under 15% over 30 days	More than 30% over 30 days
Project net margin	Gross margin minus allocated overhead	20 to 30%	Below 15%
Client profitability	Net margin across all of one client’s projects	At or above your agency average	Consistently below average; consider repricing

The first four run on money in and out, straight from your income and expense data. The rest need time tracking or headcount data feeding them. Treat the benchmarks as rough service-business rules of thumb and calibrate to your own history.

Why Spreadsheet-Based Tracking Fails

Most businesses that track project profitability at all do it in a spreadsheet. Someone pulls the costs from one tool, checks the invoiced amount in another, and works out margin by hand. That’s 30 to 60 minutes per project, done monthly if the business is disciplined and at project close if it isn’t.

The problem isn’t the math. It’s timing and completeness.

By the time the spreadsheet is done, the project has often already closed. The insight that it ran 20% over budget arrived after the money was spent. The insight that a client has never cleared 40% margin arrived after three jobs for that client shipped at a loss.

Spreadsheets also depend on complete data. A freelancer expense submitted after the sheet was built isn’t in the number. A late invoice isn’t either. The margin looks right and reflects an incomplete picture. That’s the core reason a scattered set of tools creates a visibility problem, which we cover in . When income and costs live in separate places, the calculation needs manual assembly, and manual assembly means lag and gaps.

How to Build One Without Spreadsheets

A dashboard that runs without spreadsheets needs one thing: the inputs, income and costs, have to live in the same place. If they don’t, there’s no automatic path from data to margin, and the dashboard can’t build itself.

Step 1: Tie every project cost to the project

Every freelancer fee, reimbursed expense, and project-specific tool cost should attach to the project it belongs to as it happens. In a connected system that mapping is automatic. In a scattered stack it’s a manual export. In-house labor is the exception, since allocating it accurately needs time data.

Step 2: Connect expense capture to the project

Every expense approved against a project should flow into that project’s costs on its own, not as a manual step that adds lag and errors. We get into that in how to automate freelancer expense tracking. The dashboard is only as accurate as the expense data behind it.

Step 3: Tie income to the project

Recognize income at the project level as payments land, not just at the company level. A project on a $30,000 contract with $10,000 collected so far should show $10,000 of income against its costs, not the full $30,000 and not zero. That’s what keeps the current margin on an in-progress project honest.

Step 4: Let it update as money moves

With income and costs flowing from one layer, the margin recalculates as data arrives. A client pays, and the income side moves. A freelancer expense is approved, and the cost side adjusts. The dashboard reflects the state of every project right now, not a snapshot from the last time someone ran the numbers.

How OffBooks Handles Project Profitability

OffBooks tracks project profitability as income versus expense. It maps every payment you receive to the right client or project (cash in) and every cost to the same place (cash out): freelancer fees, reimbursed expenses, project tools, contractor payments. It reads those transactions from your inbox, your invoicing tools, and the bank and card statements you upload, then sorts them automatically.

What you get is a live income-vs-expense view for each project and client. You see margin as the money actually moves, not from a spreadsheet someone rebuilds every month. Which clients pay well and which quietly cost you shows up in the numbers instead of a gut feeling. Freelancer expenses submitted through Slack and approved land in the right project’s costs. And when a transaction looks off, you can ask Penny, the agent, what it is in plain language.

OffBooks gives you the income-vs-expense truth on every project, updated as the money moves, which is the part most owners are actually missing.

For anyone working out margin in a spreadsheet once a month, that shift is real. A project that’s slipping shows up while it’s still live. An unprofitable client becomes clear from their history instead of a hunch. And your next proposal gets priced against what comparable work actually earned, not an optimistic guess. That’s what treating your finances as one live system makes possible, which we get into in .

Conlcusion

A project profitability dashboard isn’t a reporting chore. It’s a diagnostic tool. Built right and kept live, it tells you which projects are healthy, which need attention, and which clients are worth growing, before the project closes and the chance to act is gone.

The formula isn’t hard: income minus direct costs, over income. The discipline is capturing every cost completely and on time and tying it to the income it earned, so the number is always current. Spreadsheets can do the math. They can’t do the live update. That’s the specific gap a connected system closes, and the reason owners working from a live income-vs-expense view make better calls than those working from last month’s export.

OffBooks gives you real-time project profitability, income versus expense on every project, for businesses of every kind. Try OffBooks for yourself.

Frequently Asked Questions

What is project profitability?

Project profitability is the margin a single engagement earns after the costs tied to it are taken out of the income it brings in. It tells you whether a project made money and how much. It’s more useful than company-level profit because it shows which clients and jobs drive your results and which drain them.

How do you calculate project profitability?

Project gross margin = (project income minus direct project costs) divided by project income, as a percentage. Direct costs include freelancer and contractor fees, reimbursed expenses tied to the project, and project-specific tools. If salaried staff deliver the work, their loaded labor cost belongs there too, which takes time tracking to capture accurately.

What’s the project profitability formula for a service business?

Income minus direct costs, over income. Count all income the project brings in, including approved change orders, and track delivered-but-unbilled scope as a cost since the work was real. On the cost side, include every freelancer fee, approved expense, and project-specific tool. For in-house labor, use a loaded rate (salary plus taxes, benefits, and overhead), not a billing rate.

What KPIs belong on a project profitability dashboard?

Keep it to about eight: project gross margin, project net margin, client profitability, aged receivables, billable utilization, actual vs budgeted hours, cost per project hour, and revenue per employee. The first few run on your income and expense data. The hours-based ones need a time tracker feeding them, so only include what you can actually populate.

How do you measure profitability for a service business?

At three levels: project, client, and company. The project level shows whether individual jobs are healthy. The client level adds up a client’s projects to show whether the relationship is worth growing or repricing. The company level shows overall health. Most businesses track only the company level and skip the two where the actionable insight lives.

Why does spreadsheet-based project profitability tracking fail?

Timing and completeness. By the time the sheet is built, the project is often done and the window to fix an overrun has closed. And because the numbers get pulled by hand from different tools, the calculation often misses late expenses or invoices. A connected system fixes both by updating as data arrives.

What software is best for project profitability tracking?

One that ties income and costs to individual projects and updates as money moves, with no manual assembly. General accounting software like QuickBooks reports at the company level and doesn’t surface project margin on its own. OffBooks is built around project-level income and expense, so each project’s margin is visible in real time as payments and costs land.