NetClose - Reconciliation Upload Template

Overview

The Reconciliation Upload feature allows users to batch-upload reconciliation details using Netgain's standardized templates. The process is completed in stages: first, users upload account groupings, followed by child groupings if applicable. Both upload steps are described below. Then, the user can proceed with the GL Account Mapping upload.

Step by Step Process - Parent Account Grouping

1. Fill out the applicable information in the NetClose Reconciliation Upload Template
2. Prepare the "Account Grouping Template" tab as a CSV file for upload
   1. Delete any informational or example rows View full size
   2. When finished updating the Excel File, save it in a known location as a .csv file
3. Navigate to the Import Assistant by accessing Setup > Import/Export > Import CSV Records
4. With the Import Assistant open, update the Import Type to Custom Records and the Record Type drop-down to NetClose Account Grouping
5. Under the CSV files section, click on the Select button and upload the .csv file you saved View full size
6. Select Next to continue to the Step 2 Import Options
7. Within the Import Options section, make sure Add is selected and "Run Server SuiteScript and Trigger Workflows" is checked View full size View full size
8. Select Next to continue
9. After progressing through File Mapping, you will be prompted for Field Mapping
10. Note that NetSuite tries to directly map all the fields it can recognize. Fields not automatically recognized must be manually mapped to the corresponding NetSuite fields.
    1. The recommendation is to match based on Internal ID for applicable fields View full size
11. If the fields are mapped correctly and the field contents match the field values in NetSuite, select Save & Run or Run as desired View full size View full size
12. To view the status of the upload, select "Import Job Status" in the Confirmation banner or navigate to Setup > Import/Export > View CSV Import Status View full size
13. When complete, the status will change to complete and show the records imported successfully View full size
14. In the event of a failed upload, select "CSV Response" to review the error logs, make necessary updates to the CSV file, and repeat the above steps

15. To review your account groupings, go to NetClose > Setup > Account Groupings & Rules and select the View as Parent Groupings Only

View full size

Step by Step Process - Child Account Grouping

1. Fill out the applicable information in the NetClose Reconciliation Upload Template
2. Prepare the "Child Account Grouping" tab as a CSV file for upload
   1. Delete any informational or example rows View full size
   2. When finished updating the Excel File, save it in a known location as a .csv file
3. Navigate to the Import Assistant by accessing Setup > Import/Export > Import CSV Records
4. With the Import Assistant open, update the Import Type to Custom Records and the Record Type drop-down to NetClose Account Grouping
5. Under the CSV files section, click on the Select button and upload the .csv file you saved View full size
6. Select Next to continue to the Step 2 Import Options
7. Within the Import Options section, make sure Add is selected and "Run Server SuiteScript and Trigger Workflows" is checked
8. Select Next to continue
9. After progressing through File Mapping, you will be prompted for Field Mapping
10. Note that NetSuite tries to directly map all the fields it can recognize. Fields not automatically recognized must be manually mapped to the corresponding NetSuite fields.
    1. Please note that you must select Internal ID for the Applied to Subsidiary(s) field. View full size View full size
    2. Additionally, be sure to map Parent Rule, which references the Parent Account Grouping View full size
11. If the fields are mapped correctly and the field contents match the field values in NetSuite, select Save & Run or Run as desired
12. To view the status of the upload, select "Import Job Status" in the Confirmation banner or navigate to Setup > Import/Export > View CSV Import Status
    1. View full size
13. When complete, the status will change to complete and show the records imported successfully View full size
14. In the event of a failed upload, select "CSV Response" to review the error logs, make necessary updates to the CSV file, and repeat the above steps
15. To review your child account groupings, go to NetClose > Setup > Account Groupings & Rules and select the View as Child Groupings Only View full size

1. You may also review by selecting the parent account grouping record and the 'Children' subtab View full size

Next Steps

• Once Account Groupings are uploaded, the user can proceed with mapping GL accounts to those groupings
• To review monthly reconciliations, you will need to generate reconciliations
• Once the above is complete, it is recommended to review and validate your data to confirm that groupings and mappings were applied correctly.