Consolidating financial statements worksheet

(13 printed pages)Ron de Bruin, Microsoft Office Excel MVPFrank Rice, Microsoft Corporation August 2008Applies to: Microsoft Office Excel 2007, Microsoft Office Excel 2003, Microsoft Excel 2002, Microsoft Excel 2000Contents or consolidate the data in each worksheet into a summary worksheet.The samples described in this article add a worksheet to the active workbook and then copy a range of cells from every worksheet to the summary worksheet.The consolidated financial statements only report income and expense activity from outside of the economic entity.Any revenue earned by the parent that is an expense of a subsidiary is omitted from the financial statements.The General Ledger module's multi-level reporting facility enables users to prepare financial statements for individual companies and locations, for groups, and for all locations for all companies.Financial statements can be prepared for all locations for all companies.

consolidating financial statements worksheet-49

Prepare consolidated statement of financial position of Mommy Group as at 31 December 20X4.Let’s be more practical today and learn some advanced accounting techniques.After summaries of standards related to consolidation and group accounts, I’d like to show you how to prepare consolidated financial statements .This ensures that the data is always up-to-date after you run the code.Next, the code loops through the range on each worksheet and copies the values and formatting to the summary worksheet.

Leave a Reply