Instructions for Uploading Compensations via Spreadsheet
1. Download a sample Spreadsheet here.
![](https://cdn.prod.website-files.com/63c50a0cab4c86831ccbeef6/6493f21721fd79b364414bd4_image%20(2).png)
2. Email: This column should include the user's email. (Mandatory)
3. CompensationType: This column should include a valid Compensation Type (Salary, Pay, Bonus, Incentive, Severance, and Other). (Mandatory)
4. Amount: This column should include the amount value. (Mandatory)
5. Period: This column should include a valid Period (Hourly, Daily Rate, Weekly, Biweekly, Bimonthly, Monthly, Quarterly, SemiYearly, Yearly, and One Off). (Mandatory)
6. Currency: This column should include a valid Currency Code (ISO 4217). (Mandatory)
7. EffectiveDate: The preferred date format is yyyy-MM-dd. (Mandatory)
8. EndDate: The preferred date format is yyyy-MM-dd.
9. Notes: Max 50 characters.
10. ChangeType: This column should specify the change type.
Note: Effective Date and End Date should be date-type columns. The amount should number type column.