Day 90: the spreadsheet says $15M, the P&L says nothing
Here's the meeting I've sat in too many times. It's roughly 90 days after close. The integration lead pulls up a synergy tracker with 47 line items, color-coded green, and a footer that reads "$15M captured." Everyone nods. Then the CFO opens the actual monthly P&L, and operating expenses are exactly where they were the week before the deal signed. Nobody can reconcile the two numbers, and the room gets quiet.
The tracker wasn't lying on purpose. It was measuring the wrong thing. Almost every synergy spreadsheet I inherit tracks activities — "vendor consolidation meeting held," "sales playbook delivered," "HR systems review complete" — and then quietly maps each completed activity to a dollar figure that was assumed in the deal model. Activity completion gets confused with cash in the bank. A meeting happened, so the $50K is marked green, even though no contract was actually cancelled and no department budget was reduced.
This matters more on the revenue side, and the data is brutal about it. McKinsey finds that roughly 70% of revenue synergies never materialize in the P&L. Cost synergies are a contract you tear up — binary, you either killed the duplicate ERP license or you didn't. Revenue synergies depend on a salesperson at the acquired company changing what they pitch to a customer who may not buy. One is a decision; the other is a behavior change spread across dozens of people. Yet the spreadsheet treats both as equally certain, with the same green cell.
So this isn't a piece about a better tracking philosophy. It's an audit. Open your current synergy tracker right now and check it against the six columns below. If a line item is missing any of them, you don't have a synergy — you have a hope with a dollar sign in front of it.
The six columns your template either has or doesn't
Run this against the spreadsheet you already use. I'd bet it has the first column and is missing at least three of the rest. A disciplined synergy tracking framework lives or dies on these distinctions.
1. Hard vs. soft, as a forced binary
Every line gets one or the other, no "medium." Hard: it happens regardless of how the market behaves — closing the redundant office, dropping the duplicate cyber insurance policy, decommissioning the second payroll system. Soft: it depends on customers or pricing cooperating — cross-sell, list-price increases, upsell into the acquired base. Bain, looking across 22,000 deals, found cost synergies typically land within two years while revenue synergies average five — if they show at all. So apply a probability weight to every soft line (50% is a reasonable starting discount) and report the weighted number to the board. An unweighted soft column is how a $10M cross-sell assumption becomes a guarantee in a deck nobody will defend in year three.
2. One-time cash vs. recurring run-rate
Two separate columns, never one. Selling the vacated building is a one-time cash event. Not paying that building's lease ever again is recurring run-rate EBITDA. Blend them and you'll inflate your Year 1 number and corrupt the quality of earnings story at the next exit, when a buyer's diligence team strips the one-timers right back out and your "EBITDA improvement" shrinks in front of you.
3. Cost to achieve
Synergies aren't free, and the deal model usually pretended they were. Cutting $1M of duplicate headcount might cost $400K in severance first. Capturing $5M of cross-sell needs sales enablement, comp redesign, and a CRM migration before a single new dollar lands. A column showing the benefit without the cost to achieve overstates your first-year cash and hides the J-curve — the very real period where integration spend dips cash flow before the savings catch up. If a line has a benefit and a blank cost cell, it's incomplete.
4. The GL code
This is the column that separates real trackers from theater: every line item points at a specific general ledger account. No GL code means there is no place in the actual books where this dollar can land, which means it can't be verified, which means it isn't a synergy yet. If you can't name the account number, you're tracking an idea.
5. Named owner with budget authority
Not a function. A person who can actually move money — someone whose own department budget gets cut when the synergy lands, so they feel it. A synergy owned by "the integration team" is owned by nobody.
6. Status with a date, not a color
"Green" is a feeling. "Contract terminated 4/14, OpEx reduced in May close" is a fact. Replace the RAG color with the specific event and date that proves capture. The moment a line can't cite an event, its color is decoration.
Two tests that make the tracker tell the truth
Columns are structure. These two routines are what keep the structure honest after the deal team has moved on.
The GL test — run it cold, on a random line
Pick a line marked "completed." Say it reads "Vendor consolidation — $50K annual savings, closed." Now walk to the CFO and ask to see that $50K reduction in last month's P&L for that specific cost center. If they can point to the lower OpEx line, the synergy is real. If they shrug — and they will, more often than you'd like — the synergy is fiction. The reason is simple and it's in the quote I keep coming back to: until the department's budget is formally cut, the money doesn't disappear, it gets reallocated. The team finds something else to spend it on, and your "savings" evaporates with nobody making a decision to lose it. Run this test on three random lines per quarter. It's the fastest way to find the gap between your tracker and reality.
The weekly kill-or-commit review
Thirty minutes, every week, owners present their own lines. The rule that does the work: any line that's been off-track for three consecutive weeks faces a decision on the spot. Either the owner commits to a dated recovery plan, or the line comes out of the board forecast entirely. No third option, no "let's monitor it." This kills the most expensive failure mode in integration — the synergy that sits at-risk for six months, still counted in the forecast, still propping up the EBITDA story, until it quietly vanishes the week before the audit and someone has to explain a $2M hole. A synergy that's been dying for a quarter should be killed in week three, while you can still re-plan around the gap.
So this Monday: open the tracker, check it against the six columns, and run the GL test on three completed lines. Whatever survives is your real captured EBITDA. Everything else is a number you've been carrying that the P&L was never going to back up.
