Spreadsheet profitability: the €50K blind spot

"How confident are you in your project margins?" Ask ten managing directors at mid-size consulting firms this question and most will say "within 5%." Some will say "pretty confident." A few will pause and think about it. The ones who pause are often the closest to the actual number — which tends to be a 5 to 8% systematic understatement of true costs, compounding to a portfolio-level gap that for a firm doing €800K in annual revenue can represent over €50,000 in phantom profit that exists in the spreadsheet but not in the bank account.

Five common Excel errors in project profitability tracking

1. Overhead as a single flat rate

The most common error. A firm calculates its total overhead as a percentage of revenue — say, 28% — and applies this uniformly to all projects. But overhead isn't uniform. Software and tooling costs are fixed regardless of revenue volume. Facilities costs vary by headcount, not by billing rates. Sales and marketing costs are front-loaded in pipeline months, not delivery months. A blended rate systematically overstates margin on short, high-intensity projects and understates it on long, relationship-heavy ones.

2. Missing indirect time

Most firms track direct project hours reasonably well. Few track indirect project-adjacent time with the same discipline. Sales support hours — proposals, pitches, scoping calls — often get folded into the project budget for the engagement that follows, understating the true cost of winning the work. Internal project meetings attended by people nominally working on other things get logged as general overhead rather than project-specific cost. Pre-sales technical work done by billable staff before contract signature is rarely allocated anywhere.

3. Stale rate cards

Rate cards updated annually in January get applied to projects running through December. During that time, salary levels may have increased 4 to 6%, two senior staff members may have been promoted, and market billing rates may have shifted. The effective margin calculation uses a cost model that no longer reflects the actual cost structure. For a project staffed primarily with recently promoted mid-level consultants, this alone can produce a 3 to 4 percentage point overstatement of margin.

4. Manual consolidation errors

The portfolio view is assembled by someone — usually a finance analyst or operations manager — who pulls data from multiple project trackers maintained by different project managers with different formatting conventions. This process introduces both transcription errors and timing mismatches. A project that closed in October may not appear in the November portfolio summary. An invoice paid in December may be recognised in January. These timing gaps mean the portfolio view is never an accurate snapshot of the firm's actual financial position.

5. No distinction between gross and net margin

Gross margin — revenue minus direct costs — is easy to calculate and looks flattering. Net margin — after all overhead, indirect costs, and non-billable time — is what actually predicts cash position. Many firms report and act on gross margin because it's the number that's readily available from their tracking tools. They only discover the net margin when the annual accounts are filed, which by then is too late to act on any individual project.

The €52K gap

Take a portfolio of 12 active projects with a combined annual revenue of €860K. The portfolio-level gross margin tracker shows 22%. Apply a realistic correction for the five errors above — per-category overhead allocation, missing indirect time at 4% of hours, updated rate cards reflecting a 5% salary increase, a 1% adjustment for consolidation errors, and a 6-point gap between gross and net margin — and the true net margin settles at approximately 16%.

The difference between 22% reported gross margin and 16% actual net margin on an €860K revenue base is €51,600. This isn't money that has been lost. It's money that was never there — it existed only in the spreadsheet model. The firm's bank account has been telling the truth all along. The spreadsheet was telling a different story.

Why firms don't catch this

The explanation that many managing directors reach for is timing: "The margins look lower than the model because invoices haven't cleared yet" or "We had a slow collection month." Cash flow timing is a real phenomenon and it does create temporary gaps between reported margin and bank balance. The problem is that timing delays have become the default explanation for every gap, masking the structural errors underneath.

After eighteen months of explaining away the gap with timing, it becomes accepted background noise. The spreadsheet says 22%. The bank account suggests 16%. Somewhere in between is the truth, and nobody has the time or the mechanism to find it precisely.

The spreadsheet says 22%. The bank account suggests 16%. Somewhere in between is the truth, and nobody has the time or the mechanism to find it precisely.

The fix isn't better Excel

The problem with spreadsheet-based profitability tracking isn't the spreadsheet per se. A well-designed Excel model with proper per-category overhead, live rate card data, and disciplined consolidation could theoretically produce accurate numbers. The problem is that maintaining such a model accurately requires continuous data entry, regular reconciliation, and discipline that degrades under delivery pressure.

The fix is a system that produces accurate margin figures continuously — not because someone remembered to update a sheet, but because the data flows automatically from where it's created (timesheets, cost records, project budgets) to where it's needed (management dashboards, project reviews, forecasts). The firms that have solved the €50K blind spot aren't necessarily smarter or more disciplined than the ones that haven't. They've just stopped relying on manual assembly to tell them the truth.