Private equity
Add-On Integration: Mapping the Chart of Accounts in QuickBooks
How to map an add-on's chart of accounts to the platform's, restate history, and get both companies closing on one calendar when the books are in QuickBooks Online.
In brief
The first finance task after an add-on closes is mapping its chart of accounts to the platform's. Until that crosswalk exists, consolidated reporting is a manual spreadsheet every month, and KPIs like gross margin mean different things in each company.
The work has four parts: agree on the platform's standard accounts and dimensions, build an account-by-account crosswalk, restate enough history to show trends, and put both companies on one close calendar. In the lower middle market, where many add-ons run on QuickBooks Online, this can be done without an ERP migration in year one.
Why the chart of accounts comes first
Integration plans list many workstreams: banking, payroll, benefits, systems, and reporting. Most of the reporting work waits on one decision, which is how the add-on's accounts translate into the platform's.
Practitioners who do this work say the same. ERP for Private Equity's post-acquisition checklist calls chart of accounts alignment, left until after close, "the single most time-consuming step in the entire integration," because it delays every consolidated report. Vessel Advisors' add-on integration guide lays out a typical sequence: close the first month on the add-on's existing system, then remap accounts, restate history, and produce consolidated statements in weeks 5 to 12.
The timing in those guides is a reasonable target, not a rule. What matters is that the mapping starts in the first weeks, while the add-on's finance staff still remember why each account exists.
Step 1: Agree on the platform standard
Before mapping anything, write down what the platform's chart of accounts is. This sounds obvious, but in many roll-ups the platform's own chart grew by accident.
A usable standard has:
- Natural accounts for what a transaction is: revenue by type, cost of revenue by type, operating expenses by type, and the balance sheet.
- Dimensions for where or why it happened: location, service line, or department. In QuickBooks Online, Intuit's classes and locations are the usual tools, and class tracking is available on the Plus and Advanced plans.
- Written definitions for any account that feeds a KPI. If gross margin is a board metric, the definition of cost of revenue has to say whether field labor, vehicle costs, and subcontractors are included.
Keep the natural accounts short. A common mistake is creating an account per location ("Rent - Dallas," "Rent - Tulsa") when one rent account plus a location dimension does the same job and keeps the chart readable as more add-ons arrive.
Step 2: Build the crosswalk
The crosswalk is a table with one row for every account in the add-on's chart that has had activity in the last 24 months. A simple version:
| Add-on account | Platform account | Platform dimension | Rule | Notes |
|---|---|---|---|---|
| Sales - Service | Revenue - Service | Location: Tulsa | Direct | |
| Sales | Revenue - Service / Revenue - Parts | Location: Tulsa | Split by item | Add-on used one account for both |
| Payroll | Cost of revenue - Field labor / G&A - Wages | Department | Split by employee role | Needs payroll register |
| Owner auto | G&A - Vehicles | Direct; flag | Possible addback | |
| Ask My Accountant | (none) | Reclass before mapping | Clear balance first |
Work from a trial balance and a general ledger detail export, not from the account list alone. The detail shows what was actually posted to each account, which is often different from what the name suggests.
Three kinds of rows take most of the time.
One-to-many accounts. If the add-on booked all wages to a single payroll account, the platform cannot see field labor in cost of revenue without splitting it. The split usually comes from the payroll register, by employee role. Agree on the rule once and apply it to history and to future months the same way.
Personal and non-recurring items. Owner vehicles, family members on payroll, and one-time legal fees may already appear in the quality of earnings report as addbacks. Map them to the platform's normal accounts, and flag them so the adjusted EBITDA bridge can be rebuilt from the ledger.
Holding accounts. Uncategorized expense, suspense, and opening balance equity should be cleared before mapping, not mapped. A balance in a holding account is an unfinished entry.
Step 3: Decide the basis of accounting
Many founder-owned add-ons keep cash-basis books. If the platform reports on an accrual basis, the add-on's statements have to be converted, at least for reporting.
The conversion means recording receivables and payables that were not on the books, deferred revenue for work paid in advance, accrued wages and expenses, and prepaid costs. Do this from the close date forward first. Restating prior periods on an accrual basis is more work, and whether it is worth it depends on how much history the board wants to compare.
The opening balance sheet at the acquisition date is a separate question. Purchase accounting for a business combination is generally prepared by the deal's accountants. The bookkeeping job is to make sure the add-on's ledger reflects the agreed opening balances, so the first month of combined reporting starts from the right numbers.
Step 4: Restate history
Trend lines need comparable history. Most boards want at least the trailing twelve months on the platform's accounts, and 24 months if the business is seasonal.
There are two practical ways to do it:
- Restate in a reporting layer. Leave the add-on's historical ledger alone, apply the crosswalk in a spreadsheet or consolidation tool, and report from the mapped data. This is faster and preserves the original records.
- Restate in the ledger. Reclassify historical entries in QuickBooks to the new accounts. This makes the ledger itself consistent but changes closed periods, so it should be done once, documented, and followed by a new closing date.
Whichever you choose, from the first full month after close, book new transactions directly to the platform's accounts. Mapping after the fact every month is how a temporary bridge becomes permanent.
Step 5: One close calendar
Mapping solves comparability. It does not solve timing. The platform and every add-on need to close by the same working day, using the same checklist. The QuickBooks Online month-end close checklist is a practical starting point.
A workable starting point:
- Bank and card reconciliations done in each company file by an agreed working day
- Intercompany balances agreed between companies before consolidation, and eliminated in the consolidated view
- Consolidated package assembled only from closed periods
QuickBooks Online keeps each company in its own file, so consolidation happens outside it, in a spreadsheet or a separate consolidation tool. That is acceptable for a few entities. As add-ons accumulate, the time spent consolidating is a reasonable measure of when a move to a multi-entity system is worth the cost.
After each month's numbers are final, set a closing date with a password in each company file. Intuit describes the setting in Lock your books in QuickBooks Online. It keeps a reported month from changing after the package has gone out.
A checklist for the first 90 days
- Week 1: Trial balance and 24 months of general ledger detail exported from the add-on's file.
- Weeks 1 to 2: Holding accounts cleared. Platform standard written down, with KPI definitions.
- Weeks 2 to 4: Crosswalk drafted and reviewed with the add-on's bookkeeper or controller.
- First month end: Add-on closes on its existing accounts. Mapped results produced alongside.
- Weeks 5 to 8: Basis of accounting settled. Opening balances confirmed against the agreed opening balance sheet.
- Weeks 6 to 12: History restated. New transactions booked to platform accounts. Close calendar unified, closing dates set.
Alignment Capital builds tools for portfolio company back offices, including monthly bookkeeping in QuickBooks for platforms and their add-ons. A close that finishes on time is also the first step in measuring margin expansion.
FAQ
Should the add-on move to the platform's system right away?
Not necessarily. Many integrations close the first months on the add-on's existing file and map in a reporting layer. A system migration is easier once accounts and the close calendar are already consistent.
How much history should be restated?
At least the trailing twelve months, and 24 months for seasonal businesses. Match what the board package compares.
Can QuickBooks Online consolidate several companies?
Each company has its own file. Consolidation is done outside QuickBooks Online, in a spreadsheet or a separate consolidation tool that reads each file.
Who handles purchase accounting?
Generally the deal's accountants. The bookkeeping task is to make sure the add-on's ledger reflects the agreed opening balances.