Skip to main content
English (Australia) English (United Kingdom) English (Malaysia) English (New Zealand) English (Singapore)

How to set up your Timesheet Import (CSV)

Updated

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

Step 1: Initial Setup

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:

  1. Go to Settings > Payroll > Income types.
  2. Enter the External ID (the ID from Ameego) when creating or editing an income type.

Set up Cost Centres:

  1. Go to Settings > Payroll > Cost centres.
  2. Enter the External ID (the ID from Ameego) when creating or editing a cost centre.

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.

  1. Go to the employee profile > Pay & compensation > Pay run details.
  2. Click the pencil icon to edit.
  3. In the Timesheet type dropdown, select "Use timesheets to submit all time worked."
  4. Click Save.

3. Assign a Cost Centre:

  1. Go to the employee profile > Employment records > Employment details.
  2. Click the pencil icon.
  3. In the Primary cost centre field, select the correct centre and save.
Step 2: Preparing Your CSV File

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.
Import completed timesheet to EH Payroll

When your timesheet CSV file is ready, you can import it to Payroll by following these steps: 

  1. Click Time > Import Timesheets.
  2. Drag and drop your timesheet CSV file into the import section.
  3. Select the Upload button.
  4. 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

Ameego to EH Payroll: CSV Import File Column Reference

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.
 

  • If UNITS are entered: TIME_IN/OUT must be Date-only format, no BREAK_LENGTH.
  • If UNITS blank: TIME_IN/OUT/BREAK_LENGTH can be DateTime format.
  • If both are entered: System will raise an error.
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.
Why did my import fail?

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").
Do I have to fill out the "Rate Unit" column?

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.

Explore similar topics

Powered by Zendesk