200-Person Consultancy Discovers $180k in Hidden Costs

The challenge

No Answer to "Is This Client Profitable?"

This 200-person consulting firm had grown rapidly over five years, expanding from a single-practice operation into a multi-disciplinary consultancy spanning strategy, technology, and change management. Growth brought complexity: time was tracked in Harvest, client relationships and pipeline were managed in Salesforce, and all financial transactions - invoicing, expenses, and payables - lived in Xero. Each system told part of the story, but no system told the whole truth about client profitability.

Partners relied on a patchwork of spreadsheets and quarterly finance reviews to assess which clients were profitable. But these reviews were backward-looking and incomplete. Harvest tracked hours, but not at the granularity needed to match against Xero's invoice line items. Salesforce held the contracted rates and scope, but had no visibility into actual delivery effort. The firm literally could not answer the question: "Is this client making us money?" without a multi-week manual analysis that was out of date by the time it was finished.

The consequences were insidious. Senior consultants - the firm's most expensive and scarce resource - were being allocated to engagements based on relationship history and availability rather than profitability data. Some of the firm's longest-standing clients, assumed to be cornerstone accounts, had never been subjected to rigorous profitability analysis. Leadership suspected there were problems, but without unified data, suspicion was all they had.

The solution

Unified Profitability Scorecards

DataSpec connected Salesforce, Xero, and Harvest into a unified client profitability model. Each client record in Salesforce was enriched with real-time data from both Harvest and Xero: actual hours delivered by role and seniority, invoiced amounts, collected revenue, outstanding receivables, and direct expenses. DataSpec's cross-domain query engine normalised the data automatically, matching Harvest projects to Salesforce opportunities and Xero invoices without requiring changes to any existing workflow.

The firm configured automated profitability scorecards for every active engagement. These scorecards calculated true blended cost per hour (factoring in consultant seniority, overhead allocation, and non-billable time logged against the client), compared it against effective billing rates (actual collected revenue divided by actual hours), and surfaced the real margin in percentage and dollar terms. For the first time, partners could see not just revenue per client, but genuine profit contribution after all costs were accounted for.

DataSpec also introduced forward-looking utilisation alerts. By combining Salesforce pipeline data with Harvest capacity planning, the system could flag when senior resources were being committed to low-margin work while higher-margin opportunities sat understaffed. This shifted resource allocation from a reactive, relationship-driven process to a data-informed strategic decision - without removing the human judgment that partners valued.

"We'd been patting ourselves on the back about our biggest client for years. Turns out they were our third-least profitable engagement. Without DataSpec pulling Harvest, Xero, and Salesforce together, we'd never have seen it."

- Managing Partner, Strategy & Advisory Practice

The results

Three Hidden Loss-Makers Exposed

Within the first month of deployment, DataSpec's unified profitability model identified three client engagements operating at a net loss. Two of these were legacy accounts that had been grandfathered in at below-market rates years ago and never repriced. The third was a large-scope engagement where chronic scope creep had eroded margins to the point where every additional hour worked was costing the firm money. Combined, these three accounts represented over $180,000 in annual losses that had been invisible across the disconnected systems.

Armed with clear data, partners renegotiated terms with two of the three clients - one accepted a rate increase, and the other agreed to a restructured scope with tighter change management. The third engagement was transitioned to a more junior team with appropriate oversight, aligning the cost structure to the revenue reality. In parallel, the firm reallocated freed senior consultant capacity to two high-margin pipeline opportunities that had been languishing due to resource constraints, generating an estimated $95,000 in additional revenue in the first quarter alone.

The cultural impact was equally significant. Partners began using the profitability scorecards in their weekly leadership meetings, replacing anecdotal assessments with hard numbers. Resource allocation discussions shifted from "who's available" to "where does our capacity generate the most value." The firm reported that the DataSpec-driven visibility fundamentally changed how they thought about growth - pursuing fewer, more profitable engagements rather than chasing revenue volume.