Why Your Consulting Firm Still Runs on Spreadsheets (and What to Do About It)

Most law firms handle new client intake the same way they did ten years ago. Here's exactly what that costs and how to fix it.

Ask most managing partners at consulting firms of 8–30 people how they track their pipeline, and they'll describe the same thing.

They use one or more spreadsheets. One person manages it, but not regularly. When someone leaves or joins, it gets worse. Before board meetings or partner reviews, someone spends hours pulling data from different systems to create a report that is outdated as soon as it’s reviewed.

This happens almost everywhere. The principals are not unsophisticated; they spend their careers telling clients to fix exactly this issue. But internal operations always lose to client work for attention.

The hidden cost of the spreadsheet operating model

The visible cost is time: someone is spending 8–12 hours a month assembling operational data that should be available instantly. Partners are spending time in status update meetings that should take 5 minutes but end up taking 30 because nobody has a reliable picture.

The invisible costs are larger.

Pipeline decisions are made on stale data. By the time a pipeline review happens, the data in the spreadsheet is 2–3 weeks old. Deals have moved, timelines have changed, a prospect has gone quiet, and nobody's chased them because the flag didn't exist.

Resource allocation is guesswork. Without a live view of project delivery status and team capacity, capacity planning runs on gut feel. Work gets allocated to whoever seems available rather than whoever is actually available. Projects run over. Consultants get stretched.

The revenue forecast is unreliable. If pipeline data is inaccurate and project delivery status is unclear, the revenue forecast for the next 90 days is essentially a guess. Financial decisions get made on guesses.

Reporting takes so long that it happens less. When creating a pipeline report takes 3 hours, it happens monthly. Monthly is too infrequent. Problems that could be caught and corrected in 2 weeks, rather than compounding for 4.

When creating a pipeline report takes 3 hours, it happens monthly. Monthly is too infrequent. Problems that could be caught in 2 weeks compound for 4.

Why consulting firms specifically struggle with this

Consulting revenue is irregular and project-based. Unlike a subscription business, revenue comes in lump sums when a project closes, an engagement begins, and a payment arrives. This makes real-time pipeline visibility more important, not less, because cash flow is genuinely hard to predict without it.

In addition to unpredictable revenue, utilization is the core operational metric, and it's almost never tracked properly. Utilization rate (the percentage of fee-earner time that's billable) is arguably the most important operational number in a consulting firm. Most firms don't have a reliable real-time view of it. They calculate it retrospectively, if at all, discovering capacity problems after they've affected revenue rather than 6 weeks earlier, when something could still be done.

Complicating matters, tool proliferation without integration is common. A typical consulting firm uses a CRM for sales pipeline, a project management tool for delivery, a time-tracking tool for billing, and accounting software for financials. None of these talks to the others. The picture of the business is always fragmented, assembled manually, if assembled at all.

What a consulting firm operations dashboard actually looks like

The goal is a live view of the business that doesn't require anyone to assemble it. A well-built dashboard covers four areas:

1. Sales pipeline

   Deals by stage with values and close dates

   Deals requiring action (14+ days no activity)

   Pipeline value by month, next 90 days

2. Delivery

   Active projects by status (on track / at risk / delayed)

   Upcoming milestones and deliverables

   Client satisfaction indicators

3. Team capacity

   Utilization by fee earner (current + 4-week rolling)

   Availability for new work by person and team

   Upcoming capacity gaps flagged in advance

4. Financial

   Revenue recognized vs. forecasted

   Outstanding invoices and overdue payments

   90-day revenue forecast from live data

This dashboard is built on data the firm already has. It just lives in different places, and nobody has connected it.

The tools involved

Building this doesn't require replacing your CRM, project management tool, or accounting system. It requires connecting them. The typical consulting firm stack looks like this:

• HubSpot / Salesforce / Pipedrive CRM / pipeline
• Asana / Monday / Notion Project management
• Harvest / Toggl Time tracking
• Xero / QuickBooks Accounting
• n8n / Make Automation layer
• Looker Studio / Metabase / Retool Dashboard

Each of these has an API. The automation layer connects them, feeding a single dashboard that compiles in seconds what currently takes 3 hours to assemble manually.

What changes when you build this

The direct return is time recovered. The indirect return is better, faster decisions. A managing partner who sees in 30 seconds that two projects are at risk, three high-value prospects are overdue for follow-ups, and team utilization will drop 30% in 6 weeks makes sharper decisions than one who learns this at the monthly review.

Over a year, these more informed decisions not only save time but also generate value that far exceeds the build cost.

What it costs and how long it takes

The starting point is not picking a dashboard tool. The starting point is understanding exactly which decisions currently require manual data assembly, and what data they need. That's what the Operations Audit is for.

Engagement	What's included	Cost	Timeline
Operations Audit	Maps your current operation, identifies manual data flows, delivers a prioritized build roadmap	$2,500	2 weeks
Dashboard build	Full connected operations dashboard from CRM to financials	From $4,000	3–5 weeks

The most common reason consulting firms don't fix this is that they don't know where to start; every system is connected to every other system. The Operations Audit solves that: a complete picture of where your operation is leaking time and money, and a prioritized roadmap for fixing it.

Frequently asked questions