| 1. G/L Consolidation Import |
| 1.1. Prerequisites for G/L Consolidation Import |
|
Users MUST have full rights to the "GL Consilidation Export/Import" in Accounting Security . Users with “Accounting Security Supervisor” rights will automatically have access. The user must first set up the GL Divisions/Departments for Headquarters and Local Divisions. Once the consolidating divisions are set up and all of the accounts copied (Note: The Headquarters Division 01 must contain the Local Divisions and the accounts for all of the other divisions), the user may start the consolidation process. |
| 1.2. Introduction for G/L Consolidation Import |
The ManEx General Ledger Consolidations assumes that there are more than one independent ManEx systems in use, say one for the Main Company and one or more subsidiaries. There is a Consolidation system which must be Division 00. The Main Company would be Division 01, the Subsidiaries, Division 02, 03, etc.
When the user is satisfied with all of the individual divisional Trial Balances, the import of divisions into the Consolidated Div 00, may take place. Then the user prepares and enters the consolidation elimination journal entries into Division 00. These are setup as reversing entries and are reversed at the beginning of the following month. Once the consolidated elimination journal entries are posted, the user may print off the consolidated Trial Balance. Then the Consolidated financials may be printed. |
| 1.3. Fields and Definitions for G/L Consolidation Import | ||||||||||
Divisions
|
| 1.4. How To ..... for G/L Consolidation Import |
| 1.4.1. General Ledger Consolidation Import | ||
The Division Names will forward from the G/L Divisions/Departments setup. Note: Division 00 does not appear because it is reserved for Consolidation. The following screen will become available: Click on the < > buttons to include or exclude the division(s0 for Consolidation. Depress the "Locat CSV files from ......" The following prompt will appear:  Depress OK and the following screen will appear which includes the files exported from the secondary division(s): Open each file as instructed at the top of the screen.
 Once all three files have been Opened the following messge will appear informing the user that the Consolidation completed successfully and you may print the consolidated reports.
 Depress the Reports button.
 The Trial Balance Report is displaying all of the account activity for the 00, 01, & 02 accounts.
 |
| 1.4.2. Consolidating Elimination Entries |
The consolidation elimination entry(ies) is(are) made in the Division 00. It is set up as a Reversing General Journal Entry and is reversed in the next period. |
| 1.5. Print The Financials |
Once the user is satisfied with the Consolidated Trial Balance, the financials can be printed. Please refer to the General Ledger Reports module. |