To create the export from the subsidiary database:

1. Access General Ledger from a subsidiary database. On the navigation bar, click Administration.
2. On the Administration page, click Create consolidation export file. The Create Consolidation Export File screen appears.
3. In the Export file type field, select “Account structure”.
4. In the Export file path field, enter the location where you want to save the account setup export file, as well as a name for the export file. For example, “C:\Files\account_setup_file_1.mdb”. Click the browse button to navigate to a save location. It may be helpful to write down the path and file name, although they are both included in the control report.
5. To automatically print a control report, mark Print a control report on and select a default printer. If you would rather preview the control report before printing, do not mark this checkbox.
6. When you are ready to create the export file, click Create Now. Once the export file is created, a confirmation screen appears notifying you of success.
7. Click OK. Your account setup export file is complete.


Once you create account structure export files, you can import them from the consolidation database and use them to create consolidation maps. The steps will vary depending on the scenario:


If the headquarters database already has a consolidation map for the subsidiary database:

1. In the headquarters database, select Consolidation > Consolidation Maps and open the map dedicated to that subsidiary.
2. From the menu bar, select Consolidation Map > Refresh Account Structure
3. Browse to the account structure .mdb file created from the subsidiary database
4. Once complete, map any un-mapped / new account codes, etc. as needed
5. Save and close the map


If this is the first time you are creating a consolidation map for a particular subsidiary:

1. In the headquarters database, select Consolidation > Consolidation Maps and open the map dedicated to that subsidiary.
2. Click New at the top and browse to the .mdb account structure file created from the subsidiary database
3. Map (or auto-map) each tab in order to define the account structure of the subsidiary database
4. Save and close the map