1. The chart of accounts for a company that will be consolidated must specify accounts for consolidation. For each posting general ledger account in each company, you must specify the general ledger account in the consolidated company to which the balance will be transferred on consolidation. This is a mapping that will allow companies with different chart of accounts to be consolidated together.

   For more information about how to specify accounts for consolidations, see How to: Enter Consolidation Information on General Ledger Accounts.

2. To consolidate several companies' financial data in a consolidated company, you must enter information about the subsidiary as business units to be included and about how much their figures will be included.

   For more information about how to enter information about the subsidiary, see How to: Enter Basic Information for Consolidated Companies.

3. You can specify exchange rates when consolidating the financial statements of business units if the financial statements are in a foreign currency. The three exchange rates that are used are Average Rate (Manual), Closing Rate, and Last Closing Rate.

   For more information about how to specify exchange rates, see How to: Specify Exchange Rates for Consolidations.

4. You can consolidate dimension information and general ledger accounts. In the Dimensions Value window, fill out the Consolidation Code field. How the Consolidation Code field is filled in depends on whether dimension information is transferred to the consolidated company when you consolidate.

   Dimension information	Field definition
   If you do not want to consolidate dimension information.	Leave the Consolidation Code field blank. Note Make sure not to select any dimensions in the Copy Dimensions fields in any consolidation functions or reports described later in this topic.
   If you want to consolidate dimension information.	Leave the Consolidation Code field blank. Note However, the consolidation will only work if the dimension values in the business unit are the same as the consolidated company.
   When the dimension value code in the business unit is to be consolidated to a different dimension value code in the consolidated company.	Fill in the Consolidated Code field. Note The contents of the field should be the dimension value code that is contained in the consolidated company. For more information about how to consolidate dimension information, see How to: Set Up Dimensions and Dimension Values.

1. For each exported line, if the total of the Amount fields is a debit, the account number that is set up in the business unit's Consol. Debit Acc. field is exported to the line. If the total is a credit, the corresponding number in the Consol. Credit Acc. field is exported to the line.

2. The date used for each exported line is either the period's ending date or, if the transfer occurs each day, the exact date of the calculation.

3. The dimension value exported for the entry will be the consolidated company dimension value that is set up in the Consolidation Code field for that dimension value. If no consolidated company dimension value has been entered in the Consolidated Code field for that dimension value, the dimension value itself will be exported to the line.

4. The XML files also contain the currency exchange rates in the consolidation period. These rates are included in a separate section at the beginning of the file.

1. There are two reports that are designed to test a database and file.

2. For more information about how to test a database, see How to: Test Databases Before Consolidating.

3. For more information about how to test a file, see How to: Test Files Before Consolidating.

• This process can be done by either consolidating from the same database or consolidating from files.

  For more information, see How to: Consolidate from Databases or How to: Consolidate from Files.

1. Manually calculate the eliminations.

2. Enter the amounts in a general journal.

3. Post the journal.

Before you post the eliminations, you can verify the effect on the trial balance of the consolidated company by using the G/L Consolidation Eliminations report. The report displays a tentative trial balance. It shows the consequences of eliminating the entries by comparing the entries in the consolidated company with the eliminations that have been entered in the general journal. Calculating the eliminations is a time-consuming manual process that may be aided by setting up specific intercompany accounts, intercompany customers/vendors, and intercompany posting groups.