Payroll prerequisite import format
Use this reference when preparing an .xlsx file to import payroll prerequisites for a payout. See enter payroll prerequisites.
The import starts at row 2 and reads it as data. The template puts instructions in row 2, so delete that row before importing the file. Keep the header in row 1 and put the first data row in row 2.
The import reads these columns:
| Column | Value |
|---|---|
| 1 | Employee number |
| 2 | Not read |
| 3 | Employee name |
| 4 | Pay type |
| 5 | Description |
| 6 | Additional text |
| 7 | Quantity |
| 8 | Rate |
| 9 | Total amount |
Quantity multiplied by rate must equal the total amount. A prerequisite with a mismatch stops the import. See the payroll prerequisite Excel template for an example format.