Account Type Mapping in Close Management and Consolidation Sync

To create the mapping:

1. In NetSuite, go to NetSuite EPM > Close Management and Consolidation > Configuration Checklist.

   You'll see a list of features that you can set up for Financial Consolidation and Close in your NetSuite account.

2. For The Account Type Mapping is set for FCCS, click View, and then do one of the following:

   • To update an existing account type mapping, click Edit next to the mapping.

   • To create a new account type mapping, click Add Account Type Mapping.

3. From the Source Account Type list, select the NetSuite account type you want to map to Financial Consolidation and Close.

4. (Optional) To map to a specific parent account member in Financial Consolidation and Close, enter the relevant account number in the Source Account Number field.

   If you use this option, you can expect the following behavior:

   • Adding a unique account number lets you map the same NetSuite account type to different Financial Consolidation and Close account types.

     Note:

     You can find the account number at Lists > Accounting > Accounts.

   • When you set an account number in the account type mapping, it takes priority and is used instead of the source account type. If no account number is defined, the existing logic based on account type is used.

   Read these guidelines for using account numbers when mapping the same NetSuite account type to different Financial Consolidation and Close account types:

   • Don't add account numbers to existing mapping records. Always create a separate record with the account number, and place it after the existing record. Make sure you use a different target account type.

   • If you want to map only a specific account number, first create a record for the same NetSuite account type and leave the account number field empty. Then, create the record with the account number.

     Important:

     The record with the specific account number must be placed after the record with an empty account number.

     The following screenshot shows the correct mapping:

     

   • Use the account number only one time for each NetSuite account type. If you use it a second time, the record is considered a duplicate, and only the earlier record appears in the generated saved search result.

     In the following screenshot, the second record is a duplicate and won't appear in the saved search result:

     

5. In the Target Account Type field, enter the name of the Financial Consolidation and Close account type you want to map to.

6. Click Save.

Related Topics