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 and sample files, then update the sample CSV file with your employee rates 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 need to enter the Internal ID of the employees in the CSV file. To show the internal ID on the employee record, check the Show Internal IDs box on the Set Preferences page. For more information, read Setting the Show Internal IDs Preference.
-
The date format in your CSV file needs to match the date format set in your NetSuite user preferences (Home > Set Preferences > Date Format). The SuiteApp supports all date formats in NetSuite user preferences except for DD Month, YYYY and D Month, YYYY.
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.