Enterprise DNA

Omni by Enterprise DNA

Enterprise DNA Resources

Insights on data, AI & business. Practical AI operating-system thinking for owners, operators, and teams doing real work.

220k+

Data professionals

Omni

AI agents and apps

Audit

Map the manual work

Track Consulting Project Profit Before It Disappears
Blog AI

Track Consulting Project Profit Before It Disappears

Most consulting firms discover a project went underwater weeks after it happened. Here's how to catch scope creep and cost overruns in real time.

Sam McKay

You quoted the client $85,000 for a six-week engagement. Three weeks in, your senior consultant has logged 110 hours instead of the budgeted 60. Two associates are running 30 percent over their allocation. The client asked for “just one more scenario analysis” that turned into a two-day research spiral. No one flagged it because everyone assumed someone else was watching the clock.

You find out at month-end close, six weeks later, when the project P&L shows a 12 percent margin instead of the 40 percent you modeled. By then the engagement is over, the invoice is sent, and you’re paying your team out of equity you thought was profit.

This happens in every consulting firm. The only variable is how often and how much it costs you per year. For firms doing $3M to $10M in revenue, we typically see $80K to $300K in annual leakage from projects that go underwater without anyone noticing until it’s too late to fix. The problem isn’t your people. It’s that tracking actual cost against budget in real time requires someone to do it manually, and no one has the time.

The gap between budget and reality

When you scope a project, you build a model. Six weeks, 240 hours across three people, blended rate of $210, total fee of $85K. Your cost is roughly $120 per hour all-in, so you’re targeting $57K in total cost and $28K in profit. That’s a 33 percent margin, and if you hit it across the portfolio you’re building a real business.

The model lives in a spreadsheet. Maybe it’s in your CRM as a line item, maybe it’s in a project management tool. It doesn’t matter, because none of those systems know what’s actually happening day to day. Your consultants log time in one place. Expenses go into another system. Contractor invoices sit in email. The budget is static, and the actual is scattered across four tools that don’t talk to each other.

So you do what everyone does. You wait until month-end, export the time logs, reconcile the expenses, build a pivot table, and compare actual to budget. If you’re disciplined, you do this every two weeks. If you’re busy, it’s once a month. Either way, you’re looking backward at something that already happened. You can’t fix a project that burned 40 extra hours two weeks ago. You can only decide whether to eat the cost or have an uncomfortable conversation with the client about scope.

The firms that manage this well assign someone to run the numbers weekly. That person spends four to six hours every Monday pulling reports, updating the master tracker, and emailing the team with a summary. It works, but it’s expensive. You’re paying a project coordinator or a junior finance person $35 to $50 per hour to do manual reconciliation work that a system should handle automatically. Across a year, that’s $7K to $12K in labor just to know where you stand. And even then, you’re still looking at last week’s data.

What real-time tracking actually means

Real-time project profitability isn’t a live dashboard that updates every second. It’s a system that compares actual cost to budget at the frequency that lets you intervene before the damage compounds. For most consulting firms, that means daily or every other day. You want to know by Wednesday morning that your team burned 18 hours on Monday and Tuesday when the budget allowed for 12. That gives you three days to adjust scope, reallocate resources, or flag the issue with the client before the week closes.

The system needs to pull time entries as they’re logged, apply the correct cost rate to each person, add any expenses or contractor fees, and compare the running total to the budget. It should flag variances that cross a threshold you set, typically 10 to 15 percent over budget. And it should route that alert to the person who can actually do something about it, which is usually the engagement lead or the partner who sold the work.

This isn’t complicated logic. It’s addition, subtraction, and a conditional check. The hard part is connecting the data sources and running the calculation automatically every day without someone having to remember to do it. That’s where most firms get stuck. You can build this in Excel with some VBA and a lot of manual copying. You can buy a project management platform that promises real-time tracking and then discover it requires everyone to log time in a specific way that your team won’t adopt. Or you can treat it as an automation problem and build an agent that does the work in the background.

How an agent tracks project cost automatically

An agent in this context is a piece of software that runs a repeatable task on a schedule without human intervention. It’s not magic. It’s a script that knows where to find your time logs, how to read them, how to apply cost rates, and where to write the output. The difference between an agent and a traditional integration is that the agent can handle variability. If your time tracking tool changes its export format, the agent adapts. If a contractor sends an invoice in a different structure, the agent parses it anyway. You’re not maintaining a brittle API connection. You’re giving the agent a job and letting it figure out the details.

For project profitability tracking, the agent runs every morning at 6 a.m. It pulls time entries from the previous day, matches each entry to a project and a person, applies the loaded cost rate for that person, and adds the cost to the project’s running total. It does the same thing for expenses, reading receipts or expense reports and tagging them to the correct project. It compares the updated actual cost to the budget and calculates the variance as a percentage. If the variance crosses your threshold, it writes an alert and sends it to the engagement lead via email or Slack.

The output is a simple table. Project name, budgeted cost, actual cost to date, variance, and days remaining. If you’re 15 percent over budget with three weeks left in the engagement, that’s a red flag. If you’re 5 percent under with one week left, you’re in good shape. The agent doesn’t make decisions. It just surfaces the numbers in time for you to act.

We call this the Research Agent in the Omni ops stack, though the name is a bit of a misnomer. It’s doing structured data work, not research in the traditional sense. The same agent that pulls industry reports and synthesizes competitor analysis at the start of an engagement can also pull time logs and reconcile them against a budget. It’s the same skill set, reading structured and semi-structured data, extracting what matters, and writing a summary. The only difference is the input source and the output format.

The setup takes about two hours if your time tracking and budgeting data are reasonably clean. You point the agent at your systems, give it a sample project budget, and let it run a test cycle. You review the output, correct any mismatches, and turn it on. After that, it runs every day without supervision. If something breaks, the agent flags it and waits for you to fix the input. It doesn’t guess. It doesn’t fill in blanks. It stops and asks.

Catching scope creep before it kills the margin

Scope creep is the polite term for what happens when a client asks for more work and you say yes without adjusting the fee. It’s not malicious. The client doesn’t wake up thinking about how to extract free consulting hours. They just don’t see the boundary between what was in scope and what’s a new request. And your team, trying to be helpful, says yes because no one wants to be the person who says no to the client.

The classic version is the follow-up analysis. You delivered the final report, the client reads it, and they ask for one more cut of the data to show a different scenario. It sounds small. It’s two hours of analyst time and maybe 30 minutes of partner review. But two hours at cost is $240, and if this happens three times across the engagement, you just gave away $720. Do that on six projects and you’ve leaked $4,300 in margin without anyone noticing.

Real-time tracking catches this because the agent shows you the variance the day after it happens. You see the extra hours, you check the scope document, and you realize the request wasn’t in the original agreement. Now you have a choice. You can absorb it as client service, or you can go back to the client and say, “This is outside the original scope, here’s what it will cost to add it.” Most clients are fine with that conversation if you have it early. What they don’t like is being surprised with a change order after the fact.

The same logic applies to internal scope creep, which is when your team does more work than the project requires because they want to be thorough. A junior consultant spends an extra day building a model that’s more detailed than the client asked for. A senior associate rewrites the deck three times because they’re not happy with the flow. It’s good work, but it’s not billable, and it’s not in the budget. The agent flags the hours, and you can decide whether the extra polish is worth the cost.

We worked with a strategy firm in Chicago that was losing about $140K per year to scope creep across 20 to 25 engagements. They didn’t have bad project managers. They just didn’t have a system that surfaced the variance until month-end, when it was too late to recover. We built them a profitability agent that ran daily and sent alerts to engagement leads whenever a project crossed 10 percent over budget. Within three months, they recovered about $35K by catching overruns early and either adjusting scope or having the pricing conversation with the client. Over a year, that’s $140K back in margin, which for a $6M firm is the difference between a 22 percent EBITDA and a 25 percent EBITDA.

The second-order benefit is better pricing

Once you can track project profitability in real time, you start to see patterns in where you make money and where you don’t. Some clients are consistently profitable because they respect scope and make decisions quickly. Other clients are margin killers because every deliverable turns into a negotiation and every request comes with a follow-up request. You can’t see this clearly when you’re looking at month-end summaries. You need the daily detail.

The same is true for service lines. You might think your strategy work is the most profitable part of the business because it commands the highest rate. But when you track actual hours, you discover that strategy projects run 20 percent over budget on average because the scope is ambiguous and the client keeps asking for refinements. Meanwhile, your operational improvement work, which you priced lower, comes in under budget because the scope is clear and the deliverables are concrete. Now you know where to focus your sales effort.

This also changes how you price new work. Instead of using a blended rate and a rough hour estimate, you can price based on actual cost data from similar past projects. You know that a market entry analysis for a B2B software client typically takes 180 hours, not the 150 you’ve been quoting. You know that your senior people spend 30 percent more time on financial services clients than on healthcare clients because the regulatory research takes longer. You can bake that into the price and stop leaving money on the table.

The Proposal Generation Agent in Omni ops uses this cost data when it builds new proposals. It pulls past project actuals, compares them to the new scope, and suggests a price range based on what similar work actually cost you to deliver. It’s not replacing your judgment. It’s giving you a data-informed starting point so you’re not guessing. For a firm that writes 40 to 60 proposals per year, this saves 15 to 20 hours of pricing work and reduces the risk of underpricing by 10 to 15 percent. That’s $30K to $50K in recovered margin just from better pricing.

If you’re still pricing engagements based on what you think the work will take, you’re probably leaving 10 to 20 percent on the table. The firms that price well do it because they track actual cost religiously and feed that data back into the pricing model. An agent makes that loop automatic.

What it takes to set this up

You don’t need to replace your existing tools. The agent sits on top of what you already use. If you track time in Harvest, Clockify, or Monday, the agent reads from there. If you manage budgets in a spreadsheet or in your CRM, the agent reads from there. If you track expenses in Expensify or QuickBooks, the agent pulls from there. The integration is read-only. The agent doesn’t write back to your systems. It just pulls the data, runs the calculation, and writes the output to a dashboard or a daily email.

The build takes two to four weeks depending on how many data sources you need to connect and how custom your cost model is. If you use standard loaded rates and your time tracking is clean, it’s closer to two weeks. If you have complex cost allocation rules or multiple currencies, it’s closer to four. Either way, you’re not rebuilding your entire tech stack. You’re adding a layer that automates the reconciliation work someone is already doing manually.

The cost to build and run this agent is typically $4K to $8K upfront and $400 to $800 per month to maintain, depending on the number of projects and the frequency of the updates. For a firm doing $5M in revenue with 15 to 20 active projects at any given time, that’s about $12K in year-one cost. If the agent recovers even half of the typical $80K to $300K in annual leakage, the ROI is 3x to 10x in the first year. After year one, the maintenance cost drops because the agent is stable and you’re just paying for hosting and occasional updates.

The harder part is the process change. Your team needs to log time consistently, ideally within 24 hours of doing the work. If people log time in batches at the end of the week, the agent can’t give you early warnings. You also need to define what counts as over budget. Is it 10 percent, 15 percent, or 20 percent? Do you want alerts at the project level, the person level, or both? These aren’t technical questions. They’re business decisions, and you need to make them before the agent goes live.

Most firms get this wrong the first time. They set the threshold too low and get flooded with alerts, or they set it too high and miss the problems. The fix is to run the agent in observation mode for two weeks, review the output, and adjust the thresholds based on what you learn. After that, it’s stable.

If you’re not sure where to start, the Deploy Your First Business Agent worksheet walks through the setup process step by step. It’s a practical checklist that covers data sources, cost models, alert rules, and the first 30 days of operation. You can use it to scope the build internally or to brief an outside team on what you need. Either way, it’s a faster path to deployment than starting from scratch.

Why this matters more than you think

Project profitability isn’t the most exciting part of running a consulting firm. It’s not the client work, it’s not the thought leadership, it’s not the pitch that wins the big engagement. It’s the boring operational discipline that determines whether you’re building equity or just paying yourself a salary.

The difference between a 25 percent margin and a 35 percent margin on a $5M firm is $500K per year. That’s the difference between a lifestyle business and a sellable asset. It’s the difference between being able to hire a senior person to lead a new practice area and having to do it yourself. It’s the difference between taking two months off and being afraid to step away because the numbers might slip.

You can’t get to 35 percent by working harder or winning bigger clients. You get there by eliminating leakage, pricing accurately, and catching problems early. That requires tracking project profitability in real time, and that requires automation. You can hire someone to do it manually, and plenty of firms do. But you’re paying $40K to $60K per year for work that an agent can do for $10K, and the agent doesn’t take vacation or forget to run the report.

The firms that figure this out in the next two years will have a structural cost advantage over the firms that don’t. They’ll price more accurately, deliver more profitably, and compound that advantage across every engagement. The firms that wait will keep losing $80K to $300K per year to invisible leakage, and they’ll wonder why their competitors are growing faster on the same revenue base.

This isn’t a technology problem. It’s a decision problem. You either decide that real-time project tracking is worth building, or you decide that month-end reconciliation is good enough. If you’re reading this, you probably already know it’s not good enough. The question is whether you’re going to do something about it.

The practical next step is the free Working With Claude field guide. Thirty-two pages covering the ecosystem, Claude Code, and how to govern a rollout properly. Get your copy.

Or you can keep doing it the way you’re doing it now and hope the numbers get better on their own. But we both know they won’t.

For more on how AI agents are changing the way consulting firms operate, explore the insights section or dive into the broader Omni platform that powers these automations. The tools exist. The only question is when you’ll use them.