Available for the following plans: Standard, Premium, Platinum, Unlimited
Available for the following user access levels: Admin, Owners, Employees with "Use Payroll Direct Timesheets Import" permissions
Access Restricted:
Currently, our Timesheet Import tool is only available for Ameego users. We are working hard to bring this functionality to other scheduling platforms soon.
Being able to import timesheet data to EH payroll using a CSV file is a game-changer for your business. Whether you want to save time on manual entry or make your overall scheduling much smoother, this guide will walk you through exactly how it works.
By following the simple steps below, you can easily sync data from Ameego directly into Employment Hero.
This article explains how to:
- Set up your Employment Hero platform
- Set up your CSV file
- Import your Timesheet via CSV
Getting started
To make sure your systems "talk" to each other, you need to match the IDs in Ameego with the EH Payroll IDs.
Set up Income Types:
- Go to Settings > Payroll > Income types.
- Enter the External ID (the ID from Ameego) when creating or editing an income type.
Set up Cost Centres:
- Go to Settings > Payroll > Cost centres.
- Enter the External ID (the ID from Ameego) when creating or editing a cost centre.
Set Up Your Employees
Bulk Employee Updates
If you have a lot of employees, you can perform bulk updates by downloading your employee list via the Advanced Import CSV. Then add the employee codes to the spreadsheet and upload it back into the system.
To make sure your employees' hours import correctly, follow these three steps:
1. Link Employee IDs: Enter the ID from your scheduling app into the Employee code field during onboarding. Alternatively, add it to an existing profile:
- Go to People > Employee List and select the employee.
- Go to Employment records > Employment details and click the pencil icon.
- In the Employee code field, enter their external ID and save.
2. Enable Timesheets: You must tell the platform to expect timesheets for this employee.
Bulk Update Timesheet Settings
If you have a large team, save time by using the Advanced Import CSV. Download your employee list, fill in the timesheet settings columns, and re-import the file to update everyone at once.
- Go to the employee profile > Pay & compensation > Pay run details.
- Click the pencil icon to edit.
- In the Timesheet type dropdown, select "Use timesheets to submit all time worked."
- Click Save.
3. Assign a Cost Centre:
- Go to the employee profile > Employment records > Employment details.
- Click the pencil icon.
- In the Primary cost centre field, select the correct centre and save.
Helpful Hint
All timesheets in the CSV file must have the "Approved" status.
To ensure your timesheets import correctly, follow these simple formatting rules:
- File Type: Use a CSV (comma-separated) file. While XLSX is an option, CSV is highly recommended because it handles dates and times much better.
- One Entry Per Line: Each row in your file should represent only one shift or timesheet entry.
-
Must-Have Information: Every row must include:
- Employee ID: This is the ID from your scheduling app (e.g., Ameego).
- Time Details: You need either the Start/End date and time OR the Date + Total Units.
When your timesheet CSV file is ready, you can import it to Payroll by following these steps:
- Click Time > Import Timesheets.
- Drag and drop your timesheet CSV file into the import section.
- Select the Upload button.
- If there are any import errors, follow the guides to correct the import file. You can tick this off as you go. Once the errors are fixed, click Upload file to re-upload the corrected CSV.
FAQs and Tips
When preparing your timesheet data for transfer, your CSV file aligns with the specific data requirements of the EH Payroll system.
The following table contains details about the available columns and their descriptions for clarification when creating your import file.
| Column name | Mapped EH Payroll Field | Notes |
|---|---|---|
| EMPLOYEE_ID | EH Payroll employee’s External ID | Identifies the employee who’s submitting the timesheets exported from Ameego. When onboarding an employee in Employment Hero, the Custom external ID must be selected and Ameego’s employee information is filled out in this field. |
| NAME | SKIP | Employee’s name |
| DEPT_NAME (OPTIONAL) | EH Payroll business location’s External ID | If not specified, EH Payroll will default this to the employee’s primary cost centre. Equivalent to the Department name on Ameego export. |
| INCOME_TYPE | EH Payroll business pay category’s External ID | If not specified, EH Payroll will default this to the employee’s primary income type. Equivalent to Pay Code in Ameego. |
| RATE_UNIT | EH Payroll rate unit associated with the specified income type in other columns. | Optional field. Will default to the rate unit associated with the Income type as configured on the eOS. If RATE_UNIT is specified in the file import, and there’s a mismatch between the income type and its intended rate unit, the timesheet entry will not be saved and a validation error is thrown. |
| RATE | EH Payroll pay rate associated with the specified income type in other columns. | |
| UNITS | Units |
Optional.
|
| TIME_IN (Date time) | Start time (Date time) | Start time (Date-only if UNITS are specified). Required for tracking purposes. |
| TIME_OUT (Date time) | End time (Date time) | End time (Date-only if UNITS are specified). |
| BREAK_LENGTH (h:mm:ss) | Break duration | Leave blank if UNITS are specified. |
The most common reasons are:
- Dates before start date: The system cannot process hours for dates before an employee's official start date.
- Rate Unit mismatch: If you use the Rate Unit column, it must exactly match the setting in Employment Hero (e.g., "Hourly").
No, this column is optional. It serves as an extra safety check. If you don't need the extra verification, you can leave it blank.