Mapping Accounts to the Norway Income Statement Category Using CSV Import

To map accounts to the Norway Income Statement Category Using via CSV import, perform the following steps:

To map your accounts:

Create a saved search of the subsidiary’s accounts which will be used in the standard account mapping step before CSV import
- Go to Lists > Search > Saved Searches > New.
- Click Account.
- On the Criteria subtab, set the filter for the subsidiary and select your Norway subsidiary.
- On the Results subtab, set the results to only include the Internal ID and Name columns.
- Click Preview.
- On the Results page, click the icon for Export - CSV.
- Save the CSV file with the account search results.
Download the template applicable for your Norway Income Statement mapping category from the NetSuite File Cabinet.
- Go to Documents > Files > File Cabinet.
- Go to SuiteBundles > Bundle 47492 > Tax Audit Files CSV Templates.
- You can use Norway Income Statement RF-1167 Mapping Template.csv, Norway Income Statement RF-1175 Mapping Template.csv or Norway Income Statement RF-1323 Mapping Template.csv for your income statement account mapping. Click the appropriate template to download the file.
- Open the template and ensure that special characters are displayed correctly. If they are not displaying properly, perform the following steps to set the proper character encoding for the special characters:
  - Open a new Excel file.
  - Navigate to Data.
  - Click Get Data > From File > From Text/CSV.
  - Choose the income statement template that you have downloaded from the system ( Norway Income Statement RF-1167 Mapping Template.csv, Norway Income Statement RF-1175 Mapping Template.csv or Norway Income Statement RF-1323 Mapping Template.csv)
  - Under File Origin, select 65001: Unicode (UTF-8).
  - Click Load.
  - Save the file in CSV format.
Open the income statement mapping template saved from the previous step. The template contains five columns: Mapping Category, Mapping Value, Grouping Code, Grouping Code Description and Mapping Key.
- Open the account search created from Step 1 and copy both the Internal IDs and Names of the account search.
- Paste the copied Internal IDs and Names of the account search from the previous step to the standard account mapping template you opened. The columns should be pasted after the Mapping Key column.
- To map your NetSuite accounts to your Norway income statement accounts, copy your account’s internal ID and paste it on the Mapping Key column of the applicable Norway income statement account.
  
  The illustration below shows the mapping of account 1200 Inventory to Grouping Code 1130 – Anlegg, maskiner under utførelse.
- Different accounts can also be mapped to the same standard account if appropriate. Insert a new row, copy paste the applicable standard account line in the new row to map another account to the same standard account.
- Once done with the mapping, delete the Grouping Code, Grouping Code Description, Internal ID and Name columns.
- Save the CSV file with the final values of Mapping Category, Mapping Value and Mapping Key columns.
Import the saved CSV file from Step 3.7 to NetSuite. Go to Setup > Import/Export > Import CSV Records. Select the following options for CSV import:
- Import Type = Custom Records
- Record Type = NO-SAFT: Income Statement Mapping 1167, NO-SAFT: Income Statement Mapping 1175 or NO-SAFT: Income Statement Mapping 1323
- Character Encoding = Unicode (UTF-8)
- CSV Column Delimiter = Comma
Note:
On the Import Options screen, choose the Add or Update radio button. Expand the Advanced Options link and check the Run Server SuiteScript and Trigger Workflows box.

For more information about importing CSV files, see Importing CSV Files with the Import Assistant.
Verify if the record submitted using CSV import is mapped correctly.
- Go to Setup > Tax Audit Files > Audit Files Field Mapping.
- Select NO-SAFT: Income Statement 1167, NO-SAFT: Income Statement 1175 or NO-SAFT: Income Statement 1323 in the Category field.
- In the Subsidiary field, select your Norway subsidiary.
In the Account Type field, select an account type. Verify the accounts under each account type.

To map your accounts:

Related Topics