How Do You Prepare Consolidated Financial Statements?
A consolidated financial statement combines all financial information of a parent company with its subsidiaries. It shows the financial results of the parent company and its subsidiaries as if the group were a single company with multiple branches. In fact, it is commonly used by single companies that have multiple branches or divisions that operate under their own financial statements. Step 1 Open a new spreadsheet and save it with an appropriate name. The first line should be the title, including the parent company name. Add a line below to show the beginning and ending dates you’ve selected. Leave a blank line and proceed to the next step. Step 2 Enter all category descriptions in column A. This should include income, expenses and all of the formulas for calculating totals, margins and percentages. Make sure that you refer to all of your individual financial statements so that you don’t miss any categories or formulas. Step 3 Enter the name of your first branch, division or subsidia
