Acquisition KPI integration
By Derwin Lucas · · Revised
Acquisition KPI integration is the work of bringing a newly acquired company’s metrics into portfolio reporting so that they mean what the rest of the portfolio’s metrics mean. On the day a deal closes, the add-on keeps reporting under the definitions it arrived with. Until those definitions are mapped to the portfolio’s, its figures can be added to a total but not fairly compared with the other brands.
A deal has a closing date that everyone plans toward. The first month in which the add-on’s figures can be compared with the other brands also has a date, and it can be planned in the same way, starting before close. This guide follows an add-on from diligence to that month. All figures are illustrative.
From diligence to the first comparable month
Exhibit 1. From diligence to the first comparable month
| Stage | Finance work | How the add-on’s figures can be reported |
|---|---|---|
| Diligence | Ask how each figure is calculated, not only what it is | Not yet in portfolio reporting. The target’s figures were prepared for a sale |
| Close | Record the definitions the add-on arrived with; agree how its data will reach the portfolio | In portfolio totals where the basis allows, with the add-on named. Not compared with other brands |
| First months | Map each measure to the portfolio definition; restate where the records allow; set the history boundary | Measure by measure: compared once mapped and restated, otherwise reported with the limitation stated |
| First comparable month | Mappings approved and recorded with dates | Compared with the other brands on the portfolio’s definitions |
| Thereafter | Review the deal’s adjustments as the add-on reports | Adjustments accepted at the transaction tested again, not carried forward |
The stages overlap in practice, and different measures move through them at different speeds. A measure the add-on can recalculate from its records, such as contribution after dealer fees on its financed sales, may be comparable early; a margin that depends on how it books commissions may take longer.
Before close: diligence is the first draft of the integration
The questions that matter for integration are questions about method, and they are easiest to ask while the target is still answering questions. Each answer records one of the add-on’s definitions before it reaches the portfolio’s reporting.
- How are a lead, an acquired customer and an installed job counted, and in which system?
- When does a contract count as a sale, and are cancellations and financing declines deducted?
- Which month does a sale, a cancellation or a completed job belong to?
- Where are commissions, financing fees and installation labor booked?
- Does reported EBITDA carry any shared or owner-level costs, and which adjustments are proposed?
- Which figures can be traced to individual records, and which exist only as totals?
- Who prepares the monthly figures, and has the method changed in the last two years?
The installed revenue, contribution margin and gross margin behind the sale materials were defined for the people who ran the company before. None of them was built to match your portfolio’s definitions. That is not a criticism of the target; it is the starting position of every add-on. How to prepare portfolio KPIs for diligence
At close: portfolio reporting after an acquisition
On the day the deal closes, the add-on arrives with its own systems, its own definitions and a reporting history built for a different owner. The portfolio’s first decision is how its data will arrive: a connection, an export, an extract or a monthly submission, in the form the add-on already holds. Moving the add-on onto the portfolio’s systems may be worth doing later. It isn’t a prerequisite for reporting it on the portfolio’s definitions. Does this mean replacing systems? What a collection request should ask for
From the first month, the add-on’s figures can be included in portfolio totals where the basis allows, as long as the add-on is named and the limitation stated. What they cannot yet do is sit beside the other brands in a comparison. The pressure to compare is often greatest in these months, when the sponsor wants to see whether the acquisition is performing.
In Goverisyn, every figure carries an evidence state (Substantiated, Qualified, Limited or Not Available), so the limitation travels with the figure. What each state means
The first months: mapping, restating and the history boundary
Mapping means writing down, measure by measure, where the add-on’s definition matches the portfolio’s and where it differs. The differences are the integration work. A difference you have recorded can be managed; one you haven’t will surface later as an unexplained change.
Exhibit 2. One add-on’s first figures, as submitted and on the portfolio’s definitions
Illustrative: cases from this site applied to one add-on.
| Measure | As submitted | On the portfolio’s definition | Can it be restated? |
|---|---|---|---|
| Contribution margin | Excludes dealer fees on financed sales | Includes them: $10,000,000 financed at a 2.5% dealer fee is $250,000 | Yes, if the add-on’s records show its financing programs and fee rates |
| Brand EBITDA | $1,500,000, carrying no shared-service costs | $1,350,000 after its $150,000 share | Yes. The allocation is a portfolio decision applied to the add-on’s ledger |
| Gross margin | As the add-on books commissions and installation labor | Depends on where the portfolio places those costs | Only if the add-on’s P&L shows them as separate lines |
| Months before the acquisition | Built on the add-on’s old definitions | Restated where the records allow | Only where the records allow; otherwise the series is marked as broken at the history boundary |
Compared on day one, this add-on would show contribution $250,000 higher than on the portfolio’s definition and EBITDA $150,000 above its portfolio-basis figure, from the same business. Neither number is wrong on the add-on’s own terms. See the dealer fees case See the brand EBITDA case
Restatement depends on what the add-on can provide. Record-level data can be recalculated. A monthly template of totals can’t be, and a margin submitted without the cost lines behind it can’t be restated at all. Missing figures are stated as missing, never estimated.
The history boundary is the decision about which pre-acquisition months can be restated. Months built on the old definitions stay out of like-for-like comparisons until they have been restated, so a growth rate never compares two different calculations. If the add-on joins mid-year, every year-to-date figure that includes it states the months it covers.
A deal closes on one day. Comparability arrives when the definitions do.
Setting the first comparable month
Set a target month for the add-on’s first comparable figures, and report progress against it: which measures are mapped, which are restated, and which are still reported only. A board that can see the plan is less likely to read the add-on’s unmapped figures as results.
Each mapping needs an approver and a date. The CFO should approve the mappings for the measures the board and sponsor rely on, so the basis of the add-on’s figures can be shown when a lender, board or buyer asks.
Thereafter: the deal’s adjustments
Adjustments accepted at the transaction can keep being added back after it, whether or not they still qualify. A cost presented as one-time in the sale materials that recurs in the add-on’s first year under new ownership is no longer one-time. Reviewing the add-on’s adjustments against the portfolio’s criteria as it reports, rather than at the next transaction, keeps them from passing into the platform’s adjusted EBITDA untested. How adjustments are reviewed between deals
An add-on’s definitions can also move after they have been mapped. A CRM migration or a new controller in its first year changes its figures a second time. Definition drift in portfolio reporting
Start before the deal closes
Begin add-on integration with the measures your board and sponsor rely on most, and ask the target how each one is calculated. Those answers make the differences known before close rather than discovered after it, and they set the first comparable month as a date rather than a hope.
Goverisyn’s Portfolio Measurement Review does this work across selected brands, after a free 45-minute Portfolio Review that needs no data in advance. For comparing brands already in the portfolio, see How to compare performance across acquired companies and EBITDA comparability across portfolio companies.
More guides on measurement over time
Start with a Portfolio Review.
45 minutes. No data needed in advance.
By Derwin Lucas, founder of Goverisyn, with a career in management and information systems in home services. Published . Revised . About Goverisyn