If you own several companies, there’s a good chance you don’t know what your group actually earns. Not because your books are wrong — each set may be perfectly clean — but because adding them together produces a number that doesn’t exist.
The culprit is intercompany billing. Your operating company pays rent to your property company. A holdco charges a management fee. One entity invoices another for shared staff. Every one of those transactions is real, necessary, and usually well-advised for tax purposes — and every one of them shows up as revenue in one company and expense in another.
Stack the statements side by side and that internal money gets counted as though it came from customers. Owners routinely believe their group is materially larger than it is, and — more damagingly — that its margin is worse.
This guide covers what multi-entity consolidation actually involves, works through the arithmetic on a realistic structure, and explains why the consolidated statements your accountant prepares at year-end don’t solve the problem you have in March.
Why Adding Up Your Entities Gives You the Wrong Answer
Consolidation isn’t addition. It’s addition followed by elimination — stripping out every transaction that happened between entities you own, so what remains is only what the group did with the outside world.
The principle is simple: a group can’t earn revenue from itself. Moving money from your left pocket to your right pocket is not a sale. But in separate accounting files, that movement looks exactly like one.
WHAT GETS ELIMINATED
→ Management fees charged between entities
→ Rent paid by an operating company to a related property company
→ Shared payroll or administration recharges
→ Interest on intercompany loans
→ Intercompany receivables and payables on the balance sheet
→ Profit on inventory sold between entities and still on hand
A Worked Example: Three Entities, One Distorted Picture
Consider a structure we see constantly in Canada. An operating company doing the actual business. A property company holding the building. A holdco providing management and holding the shares.
OpCo pays PropCo $240,000 a year in rent and pays HoldCo $360,000 in management fees. Both are legitimate, documented, and sensible. Here’s what the three files show individually:
| OpCo | PropCo | HoldCo | Simple total | |
|---|---|---|---|---|
| Revenue | $4,800,000 | $240,000 | $360,000 | $5,400,000 |
| Expenses | $4,200,000 | $180,000 | $300,000 | $4,680,000 |
| Net income | $600,000 | $60,000 | $60,000 | $720,000 |
Now eliminate the $600,000 of internal billing. It was revenue to PropCo and HoldCo, and expense to OpCo — so it comes out of both sides:
| Simple total | Eliminations | Consolidated | |
|---|---|---|---|
| Revenue | $5,400,000 | ($600,000) | $4,800,000 |
| Expenses | $4,680,000 | ($600,000) | $4,080,000 |
| Net income | $720,000 | — | $720,000 |
| Net margin | 13.3% | — | 15.0% |
Three things worth sitting with.
Revenue was overstated by 12.5%. The owner believed the group turned over $5.4M. It turned over $4.8M. Every per-customer, per-employee, and growth-rate metric built on that number was wrong.
Net income didn’t change. This surprises people. Because the internal billing was revenue to one entity and expense to another, it nets to zero at the bottom line. The profit was always $720,000 — the group just couldn’t see where it came from.
Margin was understated. The owner thought the business ran at 13.3%. It runs at 15.0%. That is not a rounding difference — it’s the number you’d use to price work, evaluate an acquisition, or argue your case to a lender.
Do you know what your group actually earns?
Book a free 30-minute discovery call. We’ll look at your entity structure and show you what a properly consolidated picture would tell you that your current reporting doesn’t.
Where It Gets Harder Than the Textbook Example
The arithmetic above is the clean case. Real structures introduce complications that quietly break a consolidation nobody is reviewing.
Why Your Year-End Consolidated Statements Don’t Solve This
Most multi-entity owners do receive consolidated statements — once a year, from their external accountant, several months after the year closed.
Those statements are prepared for a different purpose than the one you have.
YEAR-END CONSOLIDATION
Built for the bank and the CRA
Arrives three to six months late
Annual, so no trend visible
Compliance-formatted
No segment or entity detail
Answers: what happened
MONTHLY MANAGEMENT CONSOLIDATION
Built for you
Arrives within days of close
Monthly, so trends are visible
Formatted for decisions
Group view plus entity drill-down
Answers: what should we do
Both have a place. But if the only consolidated view you ever see is the compliance one, you’re steering a group of companies with a rear-view mirror that updates annually. The mechanics of getting there quickly are covered in our guide to month-end close optimization — multi-entity groups need that discipline more than anyone, because the close has to happen several times over before consolidation can start.
Doing This Properly With QuickBooks Online and Excel
QuickBooks Online doesn’t consolidate across company files natively, and neither do most mid-market platforms without a dedicated add-on. In practice, that means separate files per entity and a consolidation model in Excel — which is entirely workable, provided it’s built once with discipline rather than rebuilt from memory each month.
Excel gets a bad reputation in finance circles, much of it deserved. But for a group of three to eight entities, a well-built consolidation model is more transparent and far cheaper than migrating to an ERP — and it produces a full audit trail, which most consolidation apps do not.
in the example above
intercompany reconciliation
beats migrating to an ERP
Want a consolidation model that holds up?
We build multi-entity consolidations for Canadian groups running separate QBO files — with proper eliminations, monthly intercompany reconciliation, and check figures that catch problems before you see them.
Signs Your Multi-Entity Reporting Needs Work
✓ Worth addressing now if…
- You couldn’t state your group’s true external revenue without doing arithmetic
- Intercompany balances get reconciled at year-end, or not at all
- Your only consolidated statements arrive months after the year closes
- Each entity’s chart of accounts evolved on its own
- The consolidation lives in a spreadsheet only one person understands
- You’re adding entities faster than you’re adding reporting discipline
- A lender, buyer, or investor has asked for group figures and it took weeks
Frequently Asked Questions
The Bottom Line
Entity structures get built for good reasons — liability, tax, succession, financing. Nobody designs them for reporting clarity, and reporting clarity is what quietly gets lost.
- ✓If you have intercompany billing: your headline revenue is overstated, probably by double digits
- ✓If intercompany accounts aren’t reconciled monthly: start there before anything else
- ✓If your only group view is annual: that’s a reporting gap, not a structural one, and it’s fixable
The owners who run multi-entity groups well aren’t the ones with the simplest structures. They’re the ones who can answer, in any given month, what the whole thing actually earns.
See your whole group, not five separate pictures
Book a free 30-minute discovery call. We’ll review your entity structure and current reporting, and show you what a proper monthly consolidation would reveal.