1. Click the Timesheet menu.
2. Click the Import Timesheets submenu.
3. Select the Custom File Upload option in the Import Timesheets drop-down.
4. Click the Select File button.
   
5. Click the Confirm Upload button.
   
6. In the Date Format drop-down, select either the Australian or USA option.
7. Choose what columns in the CSV file to map to what field in the
   Payroll platform.
8. Complete the following fields:
   • Replace a previous timesheet.
   • Approve timesheets.

   Helpful Hint

   The Approve Timesheets option allows you to choose whether the platform automatically approves the timesheets being imported or whether they need to go through your organisation's timesheet approval workflow.

9. Click the Import button.
   
   
   

   Helpful Hint

   You will now see on your screen a status message showing the successful uploading of your custom timesheet data file onto your payroll platform.

   

This Timesheet Importing feature allows you to import timesheets via a CSV file. We have not set a default file format, so you should be able to import most timesheet formats if they meet the following requirements:

• The file must be in a CSV (comma-separated) or TSV (tab-separated) format.
• There must be only one timesheet entry per line.
• Each timesheet line requires, at minimum:
  • Start time.
  • End time.
  • Start date
  • End date.
  • Employee
• The import will fail if you enter a timesheet date that falls before the employee's start date.
• If the data file you are importing does not have a location for the timesheet, then the platform will assign the employee's default location to the timesheet when importing the data.
• If the file you are importing has an employee working at a location they do not have access to, then the platform will automatically enable this location for the employee when importing the data file.

You may use the date/time columns in the following combinations:

• Start date and time + End date and time.
• Date + Start time + End time.
• Date + Units.