Import employee timesheets into Payroll using a CSV or TSV file, saving time and reducing manual data entry.
Before you begin
Ensure your import file meets the following requirements:
The file must be in CSV (comma-separated) or TSV (tab-separated) format.
Each row must contain one timesheet entry only.
Each entry must include:
Employee, and
Either Start/End Date & Time or Date + Units.
Timesheet dates cannot be earlier than the employee's start date.
Location rules
If no location is provided, the employee's default location will be used.
If the imported location is not currently assigned to the employee, Payroll will automatically add it to the employee's available locations.
Import timesheets
Go to Payroll, Timesheets, Import Timesheets.
Select and upload your CSV or TSV file.
Choose the correct date format (Australian or US).
Map each column to the appropriate Payroll field using the preview provided.
Choose whether to:
Replace previously imported timesheets (where applicable), and
Automatically approve the imported timesheets or send them through the normal approval workflow.
Click Import.
After the import
If errors are found, Payroll will display them so you can correct the file and import it again.
If the import is successful, you can save the column mapping as a file format for future imports.
Note: Saved file formats can be reused to avoid remapping columns each time. You can also view and delete saved formats whenever required.