Consolidated Ledger > Consolidation Processes > Map Chart of Accounts

When you click the Generate button in the Chart of Accounts Mapping > Selection Criteria page, AccountMate displays the Account Mapping page. This page allows you to review the results of automatic mapping of the accounts and to make changes, if necessary.

Manual account mapping may take longer, but it allows you to choose the consolidation company’s GL Account IDs to be mapped to the subsidiary company’s GL Account IDs. Two or more GL Account IDs in the subsidiary company can be mapped to a single GL Account ID in the consolidation company, but not vice versa. Users usually perform automatic mapping of the chart of accounts and then perform manual mapping for the rest of the GL Account IDs that were not automatically mapped since they did not fit the criteria.

Perform the following steps in this page:

1.Mark either one or both of the following checkboxes:

oShow Mapped Accounts

Mark this checkbox to display in the grid the subsidiary GL Account IDs that are mapped to the consolidation company’s GL Account IDs.

oShow Unmapped Accounts

Mark this checkbox to display in the grid the subsidiary GL Account IDs that were not mapped to the consolidation company’s GL Account IDs in the previous session (i.e., no mapped records yet in the database).

2.Review whether the subsidiary company’s GL Account IDs are mapped to the appropriate GL Account IDs in the consolidation company.

Note: A grid is provided to show information about the consolidation company full chart of accounts and the account category assigned to each GL Account ID. This is provided for your reference without the need to drill down to the Chart of Accounts Maintenance function.

3.If you need to make changes to the mapping or you need to manually map the subsidiary company GL Account ID to a specific consolidation company GL Account ID, perform these steps.

3.1. Highlight the subsidiary company GL Account ID that you want to map.

3.2. Specify in the Mapped To field the consolidation company GL Account ID to which you want to map the selected subsidiary company GL Account ID.

4.Click Save to save the mapping of GL Account IDs; otherwise, click Cancel.

Note: If any of the subsidiary company’s GL Account IDs are not mapped to the consolidation company GL Account IDs, AccountMate will display a message box displaying the remaining number of subsidiary company GL Account IDs to be mapped and an option to continue mapping. Click Yes to proceed with mapping; otherwise, click No to save your entries and exit the function window.

Account Mapping Page

Account Mapping Page