NetClose - Creating Accrual Types
Overview
NetClose enables users to set up multiple accrual types. Before creating an accrual or uploading a CSV of accruals, accrual types need to be configured in the system.
There are two ways to configure accrual types in NetClose: manually or via CSV upload. The below instructions will walk through the fields needed to create an accrual type and the two methods to configure accrual types.
Accrual Type Fields
Name | Description | Example |
---|---|---|
Name | Name of Accrual Type to be completed. | Software |
Accrual Account | The Accrual Account is the account that is specified where you will book the accrual for expenses that have yet to occur | 1305 Prepaid Expenses: Prepaid Software |
Expense Account | The Expense Account is the account that is specified where the accrual will get reversed in the following period | 6240 Software Expense |
Step by Step - Manual Process
- To access the accrual types list, navigate to NetClose > Setup > Accrual Types
- On the NetClose Accrual Type List, you can edit current accrual types or add a new NetClose accrual type
- To add a new accrual type select "New NetClose Accrual Type"
- Fill out the name, accrual account, and expense account in the primary information section
- Click "Save"
Step by Step - CSV Upload Process
- Fill out the applicable information in the NetClose Accruals Upload Template
- Prepare the "Accrual Types" tab as a CSV file for upload
- Delete any informational or example rows
- When finished updating the Excel File, save it in a known location as a .csv file
- Delete any informational or example rows
- Navigate to the Import Assistant by accessing Setup > Import/Export > Import CSV Records
- With the Import Assistant open, update the Import Type to Custom Records and the Record Type drop-down to NetClose Accrual Type
- Under the CSV files section, click on the Select button and upload the .csv file you saved
- Select Next to progress to the Step 2 Import Options
- Within the Import Options section, make sure Add is selected (or Update if doing a bulk update to Amortizations) and "Run Server SuiteScripts and Trigger Workflows" is checked
- Select Next to progress
- After progressing through File Mapping, you will be prompted for Field Mapping
- 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.
- The recommendation is to match based on Internal ID for applicable fields
- The recommendation is to match based on Internal ID for applicable fields
- If the fields are mapped correctly and the field contents match the field values in NetSuite, select Save & Run or Run as desired
- 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
- When complete, the status will change to complete and show the records imported successfully
- 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.