Consolidating Financial Statements of Multiple Companies in Microsoft Excel

previous page next page

Consolidating the Financial Statements of Multiple Companies in Microsoft Excel

To consolidate Excel financial statements for multiple companies:

Open the largest company in Sage ERP Accpac.
Open General Ledger > Financial Reporter > Statement Designer.
Open the Financial Statement that you want to consolidate and generate it using FR View. These instructions will refer to this generated sheet as Co#1.
Scroll to the generated portion of Co#1 (below the specification section) and align the first line of descriptions at the topmost cell of your screen.
Go to the tool bar at the top of your screen and click New, select Sheet, then click OK. You will have a blank sheet covering your screen. (These instructions will refer to this blank sheet as "Consol".)
Turn off "automatic calculation" in the new spreadsheet. If you do not do this, the system will update your consolidated spreadsheet continuously, slowing down the system.
Start with Sheet 2, leaving Sheet 1 for the consolidating sheet.
Copy, Paste, and Link all companies to separate sheets and then consolidate within Excel to Sheet1. This will eliminate the problem of viewing the tiled spreadsheets while copying cell references.