Summary
The steps below along with the video provide the steps to setup your Master Company where you can merge multiple companies into one Master Company for General Ledger reporting purposes
Resolution
Combining financial reports for multiple companies can be achieved by using the Multi-Company Consolidation option in Sage BusinessWorks.
- This feature is for reporting purposes only
- All transactions should be posted in the individual or subsidiary companies instead of the consolidation company
- The chart of accounts for each subsidiary company must be similar in that account numbers must be set up using the same account type and account class across all companies
- The individual companies can have additional accounts, but those account numbers must not be used in a different fashion (account type and class) in another company with in the consolidated companies
Steps for setting up a Master Consolidation company:
- Create the company by selecting Utilities (on the Launcher), Maintain Companies, New.
- Create GL data files by selecting GL, Utilities, Create G/L Data Files.
- Click OK on 'Initial Chart of Accounts from'.
- Select Another Company and select one of the subsidiary companies from the Company/Sample ID drop down list.
- Select Master Consolidation company.
- Define the setting selections in this window.
- Click OK and OK.
- Type the word CREATE and click OK.
- Select GL, Transfer, Multi-Company Consolidation.
- Click OK and define a list of companies in Subsidiary Company List.
- Select the Build Chart of Accounts tab, make selections, and click Build Master Chart of Accounts.
- Click the Consolidate tab and select Import Subsidiary Company Balances. Note: Perform the import each time you use the Master Consolidation company to transfer the current account balances from your subsidiary companies.
- Save.
- Use the Reports menu to print the combined financial reports from the master consolidation company.
Note: When new accounts are added to subsidiary companies, rerun the Build Chart of Accounts option from GL, Transfer, Multi-Company Consolidation, Build Chart of Accounts to update the master consolidation company chart of accounts