Insights
The PE Firm Just Closed. Your Reporting Bar Just Moved.
New ownership raises the Monday pack overnight. Acquisition performance starts with one trusted model across plants, not another Excel combine.
The deal closed Friday. On Monday, the operating partner wants the same pack the portfolio runs everywhere else.
Your plants still close three different ways. Margin means something different in each workbook, and working capital lands after a week of combines. That was fine under the old ownership. It is not fine now. The reporting bar just moved, and another Excel zip will not clear it.
Ownership changed. The Monday pack did too.
Mid-market manufacturers under new PE ownership feel the shift in the first operating review, not the press release. On paper the ask is simple: plant margin, cash conversion, scrap, and backlog, using the same definitions the rest of the portfolio already uses.
What you actually have is five plants, five extracts, and a finance analyst who stitches them together Sunday night. The room gets a slide, and the slide does not survive a follow-up question about grain.
Acquisition performance visibility is not another dashboard. It is one definition of margin, revenue, and working capital that every add-on can defend. Power BI becomes useful when that definition lives in a semantic model, not when you redraw the same Excel as prettier tiles.
This sits next to why Power BI reports show different numbers. Mismatched plant logic looks like a tool problem. It is an ownership problem.
How the bar rises overnight
Before close, “good enough” meant each plant manager trusted their own file. After close, it means the portfolio can roll up plants without a reconciliation meeting.
Operating partners compare you to peers. They do not care that Plant B books scrap differently. They care that your pack cannot explain the gap.
Add-on diligence assumed a consolidation path. Day-one reality is still ERP plus MES plus tribal Excel, because the path was never built.
Finance still owns the close and ops still owns the floor, but nobody owned the shared language. New ownership notices that gap first.
Board calendars do not wait for a twelve-month BI program. The first packs set the trust trajectory for the whole hold period.
The costs of keeping the old bar
-
The first board pack becomes Excel theater. Plants paste numbers into a template, nobody can drill, and follow-ups become offline homework.
-
Margin arguments burn the operating review. Three plants bring three contribution definitions, and the room debates formulas instead of price or scrap. It is the same failure as margin definitions that don’t survive.
-
Working capital stays invisible until it is late. Inventory, AR, and AP only land after a manual combine, so cash conversations start with “we’ll get that by Thursday.”
-
Add-on integration looks like more workbooks. Each acquisition adds another extract, and sprawl grows with the portfolio thesis.
-
Trust leaves the product before it ships. After one wrong plant total, leaders ask for the file. Adoption dies while the dashboard count grows.
-
Analysts become the gateway. One person knows how the zip is built, so vacation or turnover becomes close risk.
-
CapEx conversations stall on data quality. You cannot defend an investment while plant performance is still a negotiation.
-
The hold-period clock keeps ticking. Every quarter without a trusted model is a quarter of slower decisions under owners who expect speed.
How to fix it: raise the model, not the slide count
-
Name the Monday decisions first. Which questions must the operating pack answer every week? Margin by plant, cash conversion, scrap, backlog. Write them down before you open Desktop.
-
Pick one grain and stick to it. Use item, plant, customer, and period, or whatever the portfolio standard is. Shared grain beats pretty consolidations. Without it you are combining, not comparing.
-
Land measures before visuals. Revenue, cost, margin, and inventory turns each get one owned definition, described in the model. No private plant variants labeled “final.”
-
Build one semantic model across plants, not five report copies. Plants can have their own apps, but they must share the certified measures. The semantic model is the product.
-
Assign measure owners by name. Who may change contribution margin? Publish the list. Orphan measures fail the first serious review, the same lesson as who can change a measure.
-
Retire the Sunday combine on purpose. Run the pack in parallel with the old zip for a short window, then stop shipping the zip. Silence is how Excel stays the source of truth.
-
Sequence plants instead of boiling the ocean. Start with the two plants that drive most of the board conversation. Prove one trusted loop, then expand.
-
Put refresh and freshness on the close calendar. A green tile with yesterday’s inventory is still a miss. Name the SLA and the failure path.
-
Refuse certification without a dictionary. If finance cannot explain the measure in under a minute, it is not ready for the operating partner.
-
Treat acquisition performance as a product, not a project. New add-ons plug into the same model instead of inventing a new pack format.
What good looks like
The operating partner opens one app. Plant and period slicers work, margin matches the definition finance signed, and a plant question drills down without a side file.
When a new add-on closes, integration means mapping its sources into the shared grain, not starting another workbook culture. Leaders still argue about the business. They stop arguing about which Excel file is real.
A practical first thirty days
In week one, list the Monday questions and the plant files that answer them today. Mark where definitions diverge.
In week two, lock the grain and the five measures behind the operating pack, and get finance and ops sign-off in writing.
In week three, stand up the first semantic model slice for two plants and run it side by side with the old combine in one real meeting.
In week four, run the meeting from the model. Capture every “where’s the file?” moment, fix those paths, and set the date the zip retires.
It is a dull sequence that builds trust faster. Leaders should ask: “If the operating partner calls Monday, do we have one margin or five plant stories?” If the answer is five stories, the bar already moved and the pack did not.
Where teams waste the first ninety days
They buy another visualization layer and keep the plant Excel files underneath. The tiles are prettier and the fights are the same.
They kick off a six-month “enterprise analytics” program while the operating partner still needs next Monday’s pack. That is ambition without a first loop.
They certify a dashboard that still exports to Excel for every serious decision. Certification without defensible measures is decoration.
They let each plant “migrate when ready.” Ready never arrives on the same calendar, so portfolio roll-ups stay blocked.
The fix is narrower: one meeting, one model slice, one retired combine. Expand after trust lands, not after the roadmap looks complete on a slide.
Executive takeaway
New ownership raises the Monday pack overnight. Acquisition performance starts with one trusted model across plants, built on shared grain, owned measures, and a deliberate end to the Excel combine. Another dashboard that still needs a zip to defend itself will not clear the bar.
Need a board-ready path from plant sprawl to one operating pack? See Acquisition Performance Visibility, or book a session to map the first trusted loop under new ownership. Or start with a free Model Health check.
Next step
Book a Session
Need a clearer finance or executive reporting stack? Book a Session.