Creating Employee Rates
You can create employee payroll rates in NetSuite by performing either of the following tasks:
Importing an Employee Rates CSV File
The following template and sample CSV files for importing employee rates are available in the File Cabinet of your NetSuite account:
File name |
Path in File Cabinet |
---|---|
TemplateImportEmployeeRates.xlsx |
SuiteBundles > Bundle 305364 > com.netsuite.payrollallocation > Templates folder |
SampleImportEmployeeRatesCSV.csv |
SuiteBundles > Bundle 305364 > com.netsuite.payrollallocation > CSV files folder |
Download the template as well as sample files and update the sample CSV file with your employee rates records. The following table shows a CSV file with sample records:
Employee Internal ID |
Employee Name |
Employee Pay Type |
Rate Per Hour |
Frequency |
From Date |
To Date |
---|---|---|---|---|---|---|
21 |
John Doe |
Direct Salaries and Wages |
50 |
Weekly |
8/1/2020 |
10/31/2020 |
32 |
Stella James |
Direct Fringe Benefit |
10 |
Monthly |
8/1/2020 |
10/31/2020 |
32 |
Stella James |
Direct FICA Tax |
5 |
Monthly |
8/1/2020 |
10/31/2020 |
When creating your CSV file, take note of the following:
-
You must enter the Internal ID of the employees in the CSV file. To display the internal ID on the employee record, check the Show Internal IDS box in the Set Preferences page. For more information, read Setting the Show Internal IDs Preference.
-
The date format on your CSV file must follow the date format set on your NetSuite user preference (Home > Set Preference > Date Format). The SuiteApp supports all date formats in the NetSuite user preference except for DD Month, YYYY and D Month, YYYY formats.
After creating the CSV file, import the file in the application.
To import an employee rates CSV file:
-
Go to Expense Management > Allocate Using Employee Rates > Import Employee Rates CSV > New.
The Employee Rates CSV page opens.
-
In the Name field, enter the rate name.
-
Click the plus icon next to the Employee Rates CSV File field.
A popup window opens for attaching the CSV file.
-
From the Folder list, select the folder where you want to save the employee rate CSV file.
-
Click the Choose File button and attach the employee rates CSV file.
-
In the popup window, click Save.
-
In the Employee Rates CSV page, click Save.
-
To check the status of the import, click Track Status.
The Employee Rate CSV Status page opens. The Status field displays the status of the import.
Fixing employee rate errors
If the employee rates have errors, fix the errors, and import the employee rates CSV file again.
To fix employee rate errors:
-
From the Employee Rate CSV Status page, click List.
The Employee Rate CSV Status List page opens.
-
In the Error File column, click Download.
The error file is downloaded.
-
Open and review the error file.
-
In the employee rates CSV file, fix the errors.
-
Import the employee rates CSV file again.
Manually Creating an Employee Rate
From the Employee Rate page, manually create new rates for an employee for a specified period.
To create an employee rate manually:
-
Go to Expense Management > Allocate Using Employee Rates > Create Employee Rates > New.
The Employee Rate page opens.
-
From the Employee ID list, select the employee ID.
-
In the From Date field, specify the date from which the employee rate is applicable.
-
In the To Date field, specify the date up to which the employee rate is applicable.
-
In the Rate Per Hour field, enter the rate.
-
From the Employee Pay Type list, select the employee pay type.
-
From the Frequency list, select the frequency of pay.
-
Click Save.