NetClose - Accruals Allocations

Overview

Situations may arise where an accrual should be allocated to more than one segment. To accomplish this, the Netgain product Shared Transactions is used in conjunction with NetClose. 

Once a client has purchased Shared Transactions and it has been installed into their NetSuite environment, the Shared Transactions field group will appear on accrual records with the following fields: "Expense Account Allocation Template" and "Accrual Account Allocation Template" View full size

To begin allocating, the below steps walk through how to update the accrual records. 

Step by Step Process - Manual Process

1. On the accrual record, select Edit
2. Select the applicable template for the Expense Account and Accrual Account Allocations
   1. These fields will show the active templates in Shared Transactions
   2. If new templates are needed, follow the instructions in the Creating a New Template article  View full size
   3. Once the desired templates are selected, select Save View full size
3. All future journal entries for the selected accrual will now be allocated according to the templates selected  View full size

Step by Step Process - CSV Upload

1. Create an Excel file with the following column headers:
   1. Accrual Internal ID
   2. Expense Account Allocation Template (recommended to use Internal ID of Allocation Template)
   3. Accrual Account Allocation Template (recommended to use Internal ID of Allocation Template)
2. Input the relevant allocation information for upload: View full size
3. When finished updating the Excel File, save it in a known location as a .csv file
4. Navigate to the Import Assistant by accessing Setup > Import/Export > Import CSV Records
5. With the Import Assistant open, update the Import Type to Custom Records and the Record Type drop-down to NetClose Accrual
6. Under the CSV files section, click on the Select button and upload the .csv file you saved View full size
7. Select Next to progress to the Step 2 Import Options
8. Within the Import Options section, make sure Update and "Run Server SuiteScript and Trigger Workflows" is checked View full size
9. Select Next to progress
10. After progressing through File Mapping, you will be prompted for Field Mapping
11. Note that NetSuite tries to directly map all the fields it can recognize. When fields are not recognized, they must be manually matched between the .csv upload file and NetSuite fields
    1. The recommendation is to match based on Internal ID for applicable fields View full size
12. 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
13. 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
14. When complete, the status will change to complete and show the records imported successfully View full size
15. In the event of a failed upload, review the logs for the specific reasons, make necessary updates to the CSV file, and repeat the above steps
16. Once all records have been updated successfully, all future journal entries for the applicable accruals will now be allocated according to the templates selected
    View full size