Consolidating Two Canadian Entities in a Small-Company Ledger
Two corporations, one accounting package with no consolidation module, and a bank that wants combined statements. This is the worksheet, the eliminations and the monthly discipline that makes it repeatable.
A second entity usually arrives for a good reason. A new division gets its own corporation to isolate risk. A holding company is inserted above the operating company. A small acquisition stays separate because untangling it is not worth the trouble. Then the bank, or an investor, or the practitioner doing the year end, asks for consolidated statements, and the company discovers its accounting software has no consolidation feature and never will.
That is fine. Consolidation for two entities is a worksheet, not a system. What makes it repeatable is the discipline that happens during the month, not the arithmetic at the end of it.
First, confirm you are supposed to consolidate
Do not assume. The answer depends on your reporting framework, and for private Canadian companies it is genuinely a choice.
| Framework | Treatment of a controlled subsidiary |
|---|---|
| ASPE (Section 1591) | A private enterprise makes an accounting policy choice: consolidate its subsidiaries, or account for them by the equity method, or by the cost method. The choice is applied to all subsidiaries. The standard sets out how each method is measured, so confirm the mechanics with whoever reports on your statements before you build anything. |
| IFRS (IFRS 10) | Control means consolidation. There is no policy choice. |
Two practical notes. First, a lender asking for “combined” or “consolidated” statements may be asking for something narrower than a full set of consolidated financial statements, and it is worth asking exactly what they need before you build to the heavier standard. Second, Canada does not have consolidated corporate income tax returns. Each corporation files its own return on its own results. Consolidation is a financial reporting exercise, and it never replaces the separate books of either entity.
Everything below assumes you have confirmed that consolidation is the right answer.
The monthly discipline, which is the actual work
Ninety percent of consolidation pain is intercompany balances that do not agree. Fix that during the month and the year end becomes an afternoon.
Use dedicated, paired intercompany accounts. In each entity, create accounts that exist only for transactions with the other entity, and never post anything else to them.
| In the parent’s ledger | In the subsidiary’s ledger |
|---|---|
| 1300 Intercompany receivable, Sub, trade | 2300 Intercompany payable, Parent, trade |
| 1350 Intercompany loan receivable, Sub | 2350 Intercompany loan payable, Parent |
| 4900 Management fee revenue, Sub | 6900 Management fee expense, Parent |
| 8100 Interest revenue, Sub | 8200 Interest expense, Parent |
Never let an intercompany transaction land in the general AR or AP accounts. Once it does, finding it again means reading transaction descriptions, and that scales badly.
Post both sides in the same period. An intercompany charge recorded by one entity in one month and the other in the next creates a difference that is real, self-correcting, and enormously irritating to explain. Post both sides from the same source document on the same day.
Reconcile intercompany before anything else closes. Add one line to the month-end close calendar, on the reconciliation day: the paired intercompany accounts must net to zero across the two ledgers before either entity’s balance sheet is reviewed. If the paired accounts do not agree, the difference is listed transaction by transaction and cleared, not carried.
Keep an intercompany agreement file. Management fees, cost allocations, rent between entities and intercompany loans should each rest on a written agreement with a stated basis and a stated rate. This matters for reporting, and it matters more the moment anyone outside the company reads the statements. An intercompany charge with no agreement behind it is a question you will be asked and will not enjoy answering.
The worked example
Parent Co owns 100 percent of Sub Co. Parent incorporated Sub and subscribed 100,000 dollars of share capital, so there is no goodwill and no fair value uplift to deal with. Both entities have the same year end and the same reporting framework. During the year:
- Parent charged Sub a management fee of 120,000 for shared administration.
- Parent lent Sub 200,000 and charged 10,000 of interest on the loan.
- Parent sold 400,000 of goods to Sub. Parent’s cost on those goods was 300,000, so the margin on intercompany sales was 25 percent of the selling price.
- At year end, Sub still holds 80,000 of those goods in inventory, valued at what Sub paid Parent.
- The intercompany trade balance owing from Sub to Parent at year end is 95,000.
- This is the first year of intercompany trading, so there is no unrealized profit in opening inventory.
The elimination entries
Six entries do all the work. Post them in the worksheet, never in either entity’s ledger.
E1, the investment. Parent’s investment in Sub and Sub’s share capital are the same 100,000 counted twice.
| Account | Debit | Credit |
|---|---|---|
| Share capital (Sub) | 100,000 | |
| Investment in Sub (Parent) | 100,000 |
E2, intercompany trade balances. The receivable and the payable are the same amount owed to yourself.
| Account | Debit | Credit |
|---|---|---|
| Intercompany payable, trade (Sub) | 95,000 | |
| Intercompany receivable, trade (Parent) | 95,000 |
E3, the intercompany loan.
| Account | Debit | Credit |
|---|---|---|
| Intercompany loan payable (Sub) | 200,000 | |
| Intercompany loan receivable (Parent) | 200,000 |
E4, the management fee. Real cost to the group, but it is one company charging itself. Both sides come out.
| Account | Debit | Credit |
|---|---|---|
| Management fee revenue (Parent) | 120,000 | |
| Management fee expense (Sub) | 120,000 |
E5, intercompany interest. Same logic.
| Account | Debit | Credit |
|---|---|---|
| Interest revenue (Parent) | 10,000 | |
| Interest expense (Sub) | 10,000 |
E6, intercompany inventory sales. This one has two parts and it is where consolidations go wrong.
The first part removes the gross-up. The group did not sell 400,000 to itself, so revenue and cost of sales both come down by the full intercompany sales figure. Net income does not change from this part, but revenue and gross margin do, which is exactly the point.
| Account | Debit | Credit |
|---|---|---|
| Revenue, sales to Sub (Parent) | 400,000 | |
| Cost of sales (Sub) | 400,000 |
The second part removes profit the group has not earned yet. Sub still holds 80,000 of those goods. At a 25 percent margin, 20,000 of profit sits inside that inventory balance and has never been sold to an outside customer. Inventory comes down to group cost and the profit reverses.
| Account | Debit | Credit |
|---|---|---|
| Cost of sales | 20,000 | |
| Inventory (Sub) | 20,000 |
In the following year, that 20,000 reverses back into income as the goods are sold onward, and the entry becomes a debit to opening retained earnings and a credit to cost of sales. Keep a standing schedule of unrealized profit in inventory, opening and closing, or year two will be wrong and nobody will notice.
The consolidation worksheet
| Line | Parent | Sub | Elim Dr | Elim Cr | Consolidated |
|---|---|---|---|---|---|
| Cash | 180,000 | 60,000 | 240,000 | ||
| Accounts receivable, third party | 420,000 | 210,000 | 630,000 | ||
| Intercompany receivable, trade | 95,000 | 95,000 | 0 | ||
| Intercompany loan receivable | 200,000 | 200,000 | 0 | ||
| Inventory | 260,000 | 150,000 | 20,000 | 390,000 | |
| Capital assets, net | 340,000 | 180,000 | 520,000 | ||
| Investment in Sub | 100,000 | 100,000 | 0 | ||
| Total assets | 1,595,000 | 600,000 | 1,780,000 | ||
| Accounts payable | 310,000 | 120,000 | 430,000 | ||
| Sales tax payable | 45,000 | 45,000 | |||
| Intercompany payable, trade | 95,000 | 95,000 | 0 | ||
| Intercompany loan payable | 200,000 | 200,000 | 0 | ||
| Bank loan | 250,000 | 250,000 | |||
| Total liabilities | 605,000 | 415,000 | 725,000 | ||
| Share capital | 10,000 | 100,000 | 100,000 | 10,000 | |
| Retained earnings, opening | 480,000 | 45,000 | 525,000 | ||
| Net income for the year | 500,000 | 40,000 | 20,000 | 520,000 | |
| Total equity | 990,000 | 185,000 | 1,055,000 | ||
| Total liabilities and equity | 1,595,000 | 600,000 | 1,780,000 |
And the income statement, which is where the eliminations change the story most.
| Line | Parent | Sub | Elim Dr | Elim Cr | Consolidated |
|---|---|---|---|---|---|
| Revenue, third party | 2,800,000 | 1,150,000 | 3,950,000 | ||
| Revenue, sales to Sub | 400,000 | 400,000 | 0 | ||
| Management fee revenue | 120,000 | 120,000 | 0 | ||
| Interest revenue | 10,000 | 10,000 | 0 | ||
| Total revenue | 3,330,000 | 1,150,000 | 3,950,000 | ||
| Cost of sales | 1,900,000 | 700,000 | 20,000 | 400,000 | 2,220,000 |
| Operating expenses | 930,000 | 280,000 | 1,210,000 | ||
| Management fee expense | 120,000 | 120,000 | 0 | ||
| Interest expense | 10,000 | 10,000 | 0 | ||
| Total expenses | 2,830,000 | 1,110,000 | 3,430,000 | ||
| Net income | 500,000 | 40,000 | 520,000 |
Three proofs before this goes anywhere.
The entry proof. Across all six eliminations, total debits and total credits are each 945,000. Every entry was two-sided, so this must hold.
The column proof. On the balance sheet worksheet the elimination columns each total 415,000 and it balances on its own. On the income statement worksheet the columns are 550,000 debit against 530,000 credit, and the 20,000 gap is not an error: that is the unrealized profit entry, whose debit sits in cost of sales on the income statement while its credit sits in inventory on the balance sheet. The bridge between the two sheets is the net income line, which carries the same 20,000. If your income statement columns balance exactly, you have almost certainly forgotten to push the unrealized profit through to inventory.
The income proof. Consolidated net income of 520,000 must equal the two separate net incomes of 500,000 and 40,000, less the 20,000 of unrealized profit. If it does not, an entry was posted one-sided or an intercompany balance did not agree before you started.
Look at what the eliminations did to the reported picture. Separate revenue added up to 4,480,000. Consolidated revenue is 3,950,000. If you had handed a lender the simple sum of the two entities, you would have overstated group revenue by more than half a million dollars, and the gross margin percentage would have been wrong in both directions at once.
Complications worth flagging before they arrive
| Situation | What changes |
|---|---|
| Parent owns less than 100 percent | A non-controlling interest is presented in equity, and the subsidiary’s income is attributed between the parent and the NCI. The eliminations above are unchanged, but the equity section grows a line and the worksheet needs an NCI column. |
| The subsidiary was bought, not incorporated | Acquisition accounting applies. Identifiable assets and liabilities are measured at the acquisition date, any residual is goodwill, and the elimination of the investment runs against the acquisition-date equity, not the current balance. This is a materially harder exercise and it is not a worksheet you should build alone the first time. |
| The subsidiary has a different functional currency | Assets and liabilities translate at the closing rate, income and expenses at rates approximating the transaction dates, and the difference goes to a separate component of equity rather than through income. Intercompany balances then generate translation differences that do not eliminate cleanly, which is the point at which you need a standing schedule. |
| The two entities have different year ends | Align them if you possibly can. If you cannot, you are into interim reporting for one of them every period, forever. |
| Intercompany transfers of capital assets | Unrealized profit sits in the asset and unwinds through depreciation over the asset’s remaining life, not in one period. Keep a schedule per asset. |
Making it repeatable
Build the worksheet once, then treat it as a controlled document.
- Keep one workbook with a tab per entity trial balance, one elimination tab, and one consolidated tab. Trial balances are pasted in from exports, never typed.
- Freeze the elimination entry numbering. E1 is always the investment, E2 always intercompany trade, and so on. Recurring eliminations that repeat every period get a standing schedule so nobody re-derives them monthly.
- Add the three proofs as formulas at the bottom of the worksheet, so a broken consolidation announces itself instead of being discovered.
- Align the two charts of accounts. If the entities use different account codes for the same thing, every consolidation starts with a manual mapping, and manual mappings drift. Align them once, ideally as part of a proper chart rebuild.
- Save the completed worksheet, both trial balances as pasted, and the intercompany reconciliation into the close binder for the period. When the practitioner asks how the consolidated inventory number was derived, the answer is a file, not a memory.