Chart of accounts mapping across add-on acquisitions: when a system conversion changes the margin
By Derwin Lucas ·
Every add-on acquisition arrives with its own chart of accounts. Chart of accounts standardization in a roll-up is usually done once, during add-on acquisition integration, as a mapping from each brand’s accounts to the platform’s lines. The harder part comes later. A brand converts to a new accounting system, a cost moves to a different line, and the mapping set at integration no longer puts the same costs on the same lines. Every figure still reconciles to the brand’s ledger. The margin no longer means what it meant.
This guide follows one such conversion through Goverisyn’s demonstration portfolio, with synthetic data: what it did to gross margin, what it did to a variance explanation, and what a mapping has to keep so the platform can still compare the brand with its own plan and its own past.
One brand’s conversion, two portfolio margins
Exhibit 1. Gross margin as reported and on the common basis, sum of brands (demonstration portfolio, synthetic data)
| Period | As reported | Common basis | Plan |
|---|---|---|---|
| June 2026 | 36.9% | 36.3% | 34.5% |
| January to June 2026 | 34.2% | 33.8% | 34.3% |
From March 2026, one brand, Chesapeake Exteriors, kept its books in a new accounting system whose chart of accounts classifies sales commissions in sales and marketing rather than cost of goods. From March to June that moved $408.5k of commissions out of cost of goods. The brand’s gross margin rose, and so did the portfolio’s. The common basis keeps commissions in cost of goods, as the plan does, for every brand that submits line detail; five brands that submit totals only are carried at reported margin. One brand had not submitted June.
On the reported figures, the half-year margin is 0.2 points below plan. On the basis the plan was built on, it is 0.6 points below, both computed before rounding. Neither figure is wrong. Only one of them can be compared with the plan.
A variance explanation written on the new chart
The same brand ran below plan on EBITDA. Its explanation said revenue stayed below plan on fewer jobs sold, and that operating expenses had run above plan since March, mainly two sales managers hired ahead of the volume the plan assumed. The platform’s FP&A lead questioned it: on the plan’s classification, the question noted, operating expenses ran below plan in every month from March to June, and the “above plan” reading may reflect commissions moving into operating expenses at the conversion.
The explanation is its author’s statement, and every figure in it reconciled. It was written on the new chart and compared with a plan on the old one, and until the question is answered the board can’t tell how much of the variance is reclassification. At the record date it was still unanswered, and the record shows it with its owner.
A chart of accounts mapping is a definition. When it changes, the change needs a date, an approval and the earlier months shown on the same basis.
What chart of accounts standardization has to keep after integration
1Each mapping, approved and dated
Mapping a brand’s accounts to the platform’s lines decides what its gross margin and EBITDA mean. In the demonstration, all 30 brands’ account mappings are approved. A mapping that changes should keep its earlier version and the date the change took effect, so earlier months can still be read on the basis they were built on.
2The classification the plan was built on
A plan is a set of figures on a classification. When a brand’s chart changes during the year, the plan doesn’t, so actual against plan has to be read on the plan’s classification or the variance is partly a reclassification.
3Both bases, side by side
The brand’s figures as submitted stay as submitted. The common-basis figure sits beside them, with the amount moved and the months it covers. Neither replaces the other.
4The restatement and its reason
When the brand resubmitted June from its new system, the resubmission carried its reason: commissions classified in sales and marketing in the new chart. The first submission stays in the record.
5The brands it can’t reach
A common basis needs line detail. In the demonstration, five brands submit totals only, so they are carried at their reported margin, and the figure says so rather than adjusting them by estimate.
What this guide does not claim
It doesn’t say where commissions belong. Cost of goods and sales and marketing are both defensible classifications, and the platform’s finance team approves which its common basis uses. It doesn’t ask any brand to change its chart of accounts or its accounting system. The figures are from a demonstration portfolio with synthetic data, and the brand and the people are synthetic.
The brands to check first
List every brand that converted its accounting system or changed its chart of accounts since it was acquired, with the month it happened. For each, check three lines first: sales commissions, installation labor and financing fees. Those are the classifications that move gross margin most in home services, and the ones a conversion most often moves.
Where each of those items can be booked, and what it does to margin and brand EBITDA, is set out in EBITDA comparability across portfolio companies. How definitions drift over time is in Definition drift in portfolio reporting, and how a new brand’s measures are brought in, in Acquisition KPI integration.
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 . About Goverisyn