How to Track Project Profitability in Real Time (UK Guide)

Most project-based businesses in the UK discover a job was unprofitable after it has finished. By then there is nothing to be done - the margin has gone, the team has moved on, and the post-project review is an exercise in understanding a problem that cannot be fixed. Real-time project profitability tracking changes this by showing you the margin position of every active project while there is still time to act.

The information you need

Real-time project profitability requires three data streams connected: revenue - what the project is contracted for, including approved variations; costs to date - labour hours at cost rate, materials, subcontractors, any other direct costs; and forecast to complete - the estimated cost of finishing the project based on current progress. With these three connected, you can see current margin and forecast final margin for every active project.

Why most businesses cannot see this

The data exists - in the accounting system, the time recording tool, and the project management platform. The problem is that nobody has connected these three sources in a way that produces a live profitability view. The project manager knows the job feels like it is running over. The finance manager sees the costs hitting the accounts. Neither has a single view showing both against the contracted revenue.

What the fix looks like

A Power BI dashboard or automated Excel report connected to all three data sources gives a live project profitability view - updated automatically as costs are posted and revenue is recognised. Project managers can see their margin position without waiting for a monthly report. Management can see which jobs need attention before they become problems.

The gap between project revenue and project profit

Most project-based businesses know what each project invoiced. Very few know what each project cost in terms of the actual time spent on it. The difference between the two is project margin - and it varies far more than most businesses expect. Projects that seemed straightforward end up requiring three times the hours budgeted. Projects that seemed complex run smoothly and deliver excellent margin. Without tracking, the profitable projects and the loss-making ones look identical in the accounts.

Time recording as the foundation

Project profitability tracking requires knowing where time is being spent. This does not have to mean elaborate timesheets - even a simple daily log of hours by project, captured in a shared spreadsheet or a basic time recording tool, gives you enough data to build a picture. Toggl, Harvest, and Clockify all integrate with accounting software and can feed project cost data automatically. The key is consistency: time recorded accurately is far more valuable than time estimated retrospectively.

Building the dashboard that shows it clearly

Once time recording is in place, connecting it to revenue data produces the project profitability view that most businesses want. Power BI can pull time data from your recording tool, apply a cost rate per person, and set it against invoiced revenue by project. The result is a dashboard that shows margin by project, by client, and by project type - updated automatically as time is logged and invoices are raised. The businesses that build this typically find three or four immediate actions: projects to reprice, clients to have a scope conversation with, and project types to prioritise or deprioritise.

Related articles