Set up Timesheet Import (CSV)
Introduction
Importing timesheets using a CSV file is a powerful way to streamline time tracking and workforce management. This guide explains how to prepare your system and correctly format your file to successfully import timesheet data.
How to Prepare
Tip
Integrated timesheets are enabled by default. If disabled, employees will not be able to submit timesheets for hours worked.
Require start/end times when entering timesheets must be enabled to import timesheets. You can read more about this requirement here .
- Log in to your Employment Hero Payroll platform.
- Navigate to Business > Payroll Settings > Timesheets.
- Enable Require start/end times when entering timesheets.
If this option is not selected, employees can enter total daily hours instead of exact start and end times. Where awards or pay conditions apply, start and end times are recommended.
Tip
Other timesheet options are not required when importing timesheets, as employees are not using an integrated clock-in or clock-out solution.
Timesheets can also be imported using supported integrations.
- Log in to your Employment Hero Payroll platform.
- Navigate to Business > Payroll Settings > Timesheets.
- Select the required integration.
- Choose the relevant date range.
- Select Import.
Learn more about importing timesheets using integrations here .
Instructions
Timesheets can be imported using CSV or TSV files. Most file formats are supported provided the following requirements are met:
- The file must be in CSV (comma-separated) or TSV (tab-separated) format.
- Each row must contain a single timesheet entry.
- Each timesheet entry must include:
- Start and end date/time, or date and units
- Employee identifier
Tip
Imports may fail if timesheet dates occur before an employee’s start date.
Available CSV Columns
| Column Type | Description |
|---|---|
| Nothing (skip) | Ignore this column during import |
| Date | Date only (US or AU format) |
| Start time | Time only |
| Start date and time | Date and time |
| End time | Time only |
| End date and time | Date and time |
| Break start/end date and time | Date and time |
| Employee external ID | External identifier for the employee |
| Work type external ID | External identifier for the work type |
| Location external ID | External identifier for the location |
| Category type | L = leave category W = work type P (or blank) = pay category |
| Category external ID | External identifier for the category |
| Rate | Optional pay rate. Default employee rates will apply if omitted. |
| Comments | Notes associated with the timesheet |
| Units | Used to override calculated hours or support unit-based pay categories |
Tip
Date and time columns can be used in the following combination:
- Start date and time + End date
Go back to Time and Attendance .