Consolidated Financial Statements in Excel: 3 Companies, Step by Step

Consolidated financial statements in Excel, step by step: a parent and two subsidiaries in one worksheet. Map each company's accounts to one group chart, eliminate intercompany balances with your own formulas, and prove it ties with checks. What you'll build: one column per company, an Eliminations column with three entries (an intercompany management fee, an intercompany loan, and the investment against share capital), a Consolidated column, and checks that every balance sheet balances and every intercompany balance nets to zero. The example group is 100% owned and uses one currency; different currencies, partial ownership and acquisitions need extra steps that are not covered here. Chapters 0:00 Intro: a parent and two subsidiaries 0:10 The consolidation worksheet 0:26 Map every company's accounts to one group chart 1:16 Intercompany eliminations 1:57 Consolidated column and checks 2:34 Currencies, partial ownership and acquisitions 2:46 Using Xero? Fill each company's column live Try XO Report free for 14 days: https://xo-report.com Guide: consolidate several Xero companies in Excel: https://xo-report.com/xero-to-excel/c... All companies and figures in this video are demo data. Music: "Wallpaper" by Kevin MacLeod (incompetech.com), licensed under CC BY 4.0