By structure

Comparable numbers across a portfolio that runs six different systems

The recurring problem in a mid-market portfolio is not that any single company reports badly. It is that eight companies report differently — different charts, different definitions of gross margin, different close calendars — so the consolidated view is assembled by an analyst rather than computed, and every board pack is a reconciliation exercise.

Their QuickBooksas filed
1000 · Cash412,880.14
1200 · Accounts receivable286,401.00
2010 · Accounts payable(94,220.55)
4000 · Revenue(1,842,110.00)
6000 · Operating expense1,237,049.41
Trial balance0.00
erp.io shadow ledgercomputed
1000 · Cash412,880.14
1200 · Accounts receivable286,401.00
2010 · Accounts payable(94,220.55)
4000 · Revenue(1,842,110.00)
6000 · Operating expense1,237,049.41
Trial balance0.00

184 consecutive days tied · variance $0.00

No forced platform migrationComparable KPIs across companiesDiligence-ready by default

The situation

Six things that make portfolio reporting expensive.

Six systems, six definitions

One company puts hosting in cost of revenue, another in opex. Both are defensible and the portfolio gross-margin comparison is meaningless until somebody normalises it by hand every quarter.

Close calendars that do not align

One company closes on day five, another on day nineteen. The portfolio view waits for the slowest, and nobody can see what is blocking it.

Charts that cannot be mapped once

Mapping happens at consolidation time, differently each period, usually in a workbook maintained by one analyst who is now indispensable.

Diligence starts from scratch

Every exit or add-on acquisition rebuilds the same normalisation work, because none of it was ever captured as a durable mapping.

Finance capability varies enormously

A $40M company with a strong controller and a $12M one with a bookkeeper cannot be held to the same reporting standard without doing something about the second.

Platform mandates fail

Requiring every company onto one ERP is the standard answer and it produces two years of implementations, distracted management teams, and at least one failure.

Standardise the reporting layer, not the ledger

The instinct in most portfolios is a platform mandate: everyone moves to one ERP, then the numbers are comparable. It is coherent and it is expensive — two years of implementations across companies whose management teams have other priorities, with the predictable outcome that at least one goes badly and becomes the reason the programme stalls.

The alternative is to standardise a layer above the ledgers. Each company keeps whatever it runs — QuickBooks, NetSuite, Sage Intacct, Acumatica, Dynamics — and a shared model reads all of them into one set of definitions. The mapping is captured once per company and maintained rather than rebuilt quarterly.

A platform mandate makes the numbers comparable in two years. A reporting layer makes them comparable in a quarter, and nobody’s management team is distracted by it.

What comparable actually requires

  • A portfolio chart of accounts that each company maps to, once, with the mapping versioned rather than re-derived.
  • Agreed definitions for the handful of metrics that matter — what is in cost of revenue, how recurring revenue is counted, what counts as an add-back. Most disputes are definitional rather than arithmetic.
  • A common close calendar, at least for the reporting deadline. Companies can close differently; they cannot report on different days.
  • Drill-through to source. A consolidated figure that cannot be traced into the company and the transaction is a number the board will not trust twice.

Where it pays off hardest

Diligence, at both ends. An add-on acquisition arrives with its own chart and its own definitions, and normalising it into the portfolio view is a mapping exercise rather than a project. At exit, consolidated statements that trace to source transactions turn a multi-week quality-of-earnings exercise into a data-room link.

The second-order benefit is that underperformance surfaces earlier. When every company reports on the same definitions on the same day, a margin drift at company four is visible in month two rather than in the annual review.

The companies that should move ledgers

Some will. A portfolio company still on QuickBooks Desktop with four entities and a fifteen-day close is a genuine constraint, and the reporting layer will make that visible rather than hide it. But that becomes a targeted decision about one company with a clear business case, rather than a portfolio-wide mandate applied to companies that did not need it.

Where to start

How a portfolio rollout usually runs.

Weeks 1–3

Define the portfolio chart

Agree the reporting chart and the metric definitions with the operating partner and two or three controllers. This is the part that determines everything and it is a decision exercise, not a technical one.

Weeks 3–8

Connect the first three companies

Read-only, mapped, reporting live. Start with the best-run companies so the pattern is established before the harder ones.

Months 2–5

Roll through the rest

Each additional company is a mapping exercise of one to two weeks. The weaker finance functions take longer and surface real issues, which is the point.

Ongoing

Add-ons on arrival

A newly acquired company is mapped into the portfolio view during the first close rather than after the first annual cycle.

Questions

What people ask.

Do all portfolio companies need to move to your platform?
No, and we would advise against mandating it. Each company keeps its ledger; the reporting layer sits above them. Individual companies may move later on their own business case.
How is this priced across a portfolio?
Per company, with portfolio-level agreements for firms running it across several. The operating partner view is included rather than a separate product.
How long until we get a comparable portfolio view?
First three companies in roughly eight weeks, including the definitional work. Each additional company is one to two weeks of mapping.
Does this help at exit?
It is where the return concentrates. Consolidated statements traceable to source transactions turn a quality-of-earnings exercise from weeks of reconstruction into a data-room link.
What about companies with weak finance functions?
The reporting layer will make that visible quickly rather than hiding it, which some operating partners find uncomfortable and all of them find useful. Those companies are usually the ones where an implementation or rescue engagement is genuinely warranted.

Make eight companies comparable in a quarter.

Tell us the portfolio shape and what you report today, and we will scope what standardising actually takes.