Upload Template
Download the template in HR System: click Settings to switch to Upload data manually. You can also find the template here. (If accessing through this link, please note - you will need to download this by navigating to File > Download > Microsoft Excel .xlxs)
Remember to select Standard (to see employee names) or Anonymous (no names)
Data Requirements
Please ensure either way, your file covers the following fields for all your employees.
More details can be found here: Ravio Data Requirements
| Type | Field | Required |
|---|---|---|
| Employee | Employee ID | Required |
| Employee First Name | Required* | |
| Employee Last Name | Required* | |
| Role | Job Title | Required |
| Job Level | Recommended | |
| Work Location (City, Country) | Required | |
| Organisation | Job Family | Required |
| Manager Full Name | Required* | |
| Employee ID of Manager | Required | |
| Employment | Employment Type | Required |
| Start Date (D/M/YYYY) | Required | |
| Employee attributes | Gender | Recommended** |
| Date of birth | Recommended** | |
| Base salary | Currency | Required |
| Base Salary (Annual) | Required | |
| Working Hours Per Week | Required | |
| Variable pay | Type of Variable Pay | Recommended |
| Annual Variable Pay [Amount] | Recommended | |
| Pay Frequency | Recommended | |
| Performance | Performance rating | Recommended |
*Not required if you are integrating anonymously
**Required if you are using Ravio’s Pay Equity module.
If these fields are not present, it will take much longer to get access to the full Ravio capabilities. It’s much quicker to ensure that these fields are present from the beginning.
Step by Step for Manual Upload Step 1 - Create Ravio Account
Create an Account here, if you are onboarding with full data (i.e. employee names visible).
Use the link here, if you are onboarding anonymously (i.e. no PII).
Step 2 - Prepare the File
In the first step, you are prompted to upload your employee data. We are providing you with a template to download that can be filled it, if needed.
- If you have an HRIS that we do not support, you can most likely prepare a report with all fields we require, download and then upload this file.
- If you have no HRIS but have a google or excel sheet, or payroll system, that stores your salary data. Then, it’s likely easier to download the Ravio template and fill it in.
Step 3 - Upload the File
Ensure the file is saved either as CSV or Excel Sheet, as those are the only file formats we can support at this point in time and upload the file.
Important Notes
If you want to move to an integration later in time, or are uploading right now because you are in between HRIS, we need a “consistent identifier”, for example an employee email. The reason an employee ID or name might not suffice, as there often tends to be inconsistencies (e.g. Sarah Smith gets married, and is now called Sarah Miller; or employee IDs change)