Bonus Import
You can import bonus CSV data when the Compensation Tracking features is enabled. For more information about bonuses, see the help topic Awarding a Bonus to an Employee.
Usage Notes
Consider these usage notes when you map the following fields.
-
Employee — A record for the employee must exist in your account. The employee and bonus type must have the same subsidiary.
-
Bonus Type — A record for the bonus type must already exist in your account. The employee and bonus type must have the same subsidiary.
-
Percentage — If you include both percentage and amount, only amount is used. If the employee’s base wage is hourly, you must use amount.
-
Amount — If you include both percentage and amount, only amount is used. The currency used for amount is taken from the Compensation Currency field on the Compensation Tracking tab of the employee record. For more information, see the help topic Recording Base Pay Compensation for an Employee.
CSV File Example
The following table shows how you might structure a file for importing bonus data in a CSV file.
You cannot include symbols for percentage or amount. For a 3% bonus, use 3. For a $400 bonus, use 400.
Employee |
External ID |
Bonus Type |
Percentage |
Amount |
Award Date |
---|---|---|---|---|---|
Julie Bauer |
659 |
Holiday |
— |
400 |
12/21/2020 |
Jennifer Sanders |
640 |
Annual |
3 |
|
12/10/2020 |
John Smith |
671 |
Holiday |
— |
400 |
12/21/2020 |
Importing a Bonus CSV Table
To import bonus CSV data:
-
Go to Setup > Import/Export > Import Tasks > Import CSV Records
-
In the Import Assistant, choose Employees as the Import Type, and Bonus as the Record type.
-
Click Select and specify the CSV file you want to import. Click Next.
-
Select the appropriate data handling for your import. Click Next.
-
Review the field mappings to make sure that your CSV data fields map into NetSuite fields.
-
Click Next and follow the assistant’s instructions.
For more information about using the import assistant and importing CSV records, see the help topics Importing CSV Files with the Import Assistant and Guidelines for CSV Import Files.