Multi-Entity Consolidation Workbook (Free XLSX) · See Every Company You Run as One Group

The problem it solves

If you run more than one entity — a holding company and an operating company, an LLC per property, a separate company per location — most accounting software charges you a separate subscription for each one, and still can’t show them to you together. So every month, someone exports each file and stitches it together in a spreadsheet by hand.

This workbook is that spreadsheet — done properly, once. Build the mapping a single time, and every month after you just paste in fresh trial balances and get a consolidated picture back.

How it works

STEP 1

Map once

Match each entity’s accounts to one master chart. You do this a single time — it’s saved in the file forever.

STEP 2

Paste your trial balances

Each month, export each entity’s trial balance and paste it in. The saved mapping re-applies itself automatically.

STEP 3

Get consolidated statements

A consolidating schedule, a consolidated balance sheet and income statement, intercompany eliminated — on demand.

What you get

Every entity in one place — one workbook, not a file and a login per company.
A mapping that persists — build the crosswalk once; new accounts get flagged so you only ever map the new one.
Real consolidation — a consolidating schedule with each entity in a column, an eliminations column, and the group total.
Intercompany eliminations — net out the loans, management fees, and rent between your own entities.
Built-in checks — each entity in balance, the group in balance, intercompany cleared, and an unmapped-accounts report.
Your data stays yours — it’s a file on your machine, in Excel or LibreOffice. Nothing uploaded anywhere.

Who it’s for

Real estate investors An LLC per property — a portfolio view without a portfolio of subscriptions.

Holdco / opco owners A holding company over operating companies — one consolidated group at last.

Multi-location operators An entity per location — all units side by side, on demand.

Family-business successors Inheriting several related companies and needing one combined picture.

Bookkeepers & fractional controllers Producing a monthly group package for a client without an ERP.

Search-fund & small-PE operators Rolling up a few acquired entities before the system catches up.

What’s inside the file

Nine tabs, in the order you use them. It comes pre-loaded with a three-entity worked example so you can see it run — then clear it and drop in your own.

Read Me

How to use the workbook, the order of the tabs, and the single-currency assumption.

Master Chart of Accounts

The one chart everything rolls up to. Edit it to match how you want the group reported.

Mapping

The crosswalk that persists — each entity’s accounts matched to the master, saved once.

Trial Balances

The only tab you replace each month. Paste each entity’s exported trial balance here.

Eliminations

Intercompany entries — loans, management fees, rent between your own entities.

Consolidating Schedule

Each entity in a column, an eliminations column, and the group total across.

Balance Sheet

The consolidated balance sheet, built from the consolidating schedule.

Income Statement

The consolidated income statement for the group.

Checks

Each entity in balance, the group in balance, intercompany cleared, unmapped accounts flagged.

Honest about what it is

This is a management-consolidation tool, not audited financial statements. It assumes a single currency (US dollars). And it sits on top of wherever you keep the books — it gives you the consolidated picture, but each entity still records its own day-to-day transactions somewhere.

For anything you’ll file or hand to a lender, have a qualified CPA review it.

See all your companies as one.