We're here to help.

Browse articles, help and advice to get the most out of Ento.

Import public holidays

Import public holidays  to be observed by specific locations or the entire company.

Core HR > Account Data > Import Data
Public holidays will need to be loaded into your account based on your region. Your Implementation Consultant will set up your initial public holidays for the current year, and you will need to set them up for each following year.
Best practice is to do this around November or December for the following year, to ensure you have them entered prior to rostering for the new year, as some of these, particularly local public holidays, can change from year to year.

Importing public holidays

To start a new file import, go to Core HR > Account data > Import data and click Create new.
Open the Type dropdown list and select ‘ public holiday’. This name may change depending on your chosen terminology for public holidays .
The purple bar under the file selection will then update to include a ‘Click here’ link for downloading a CSV template that includes all the fields necessary to get importing.
More general information on preparing import files can be found in Importing data overview.

public holidays import requirements

The import will require a unique ID for the public holiday, a name, a specified date, and an ‘Attached to’ reference.
public holidays can be attached to Company, location, or (if location groupings are enabled), the name of a location grouping such as State or Division etc, specify by using the name reference here (not ID). Below the locations are called Store:

Name Data type Length limit Example Mandatory Description
ID String 20 PH10001 Yes
A unique identifier for the public holiday record. An ID can be comprised of text and/or numbers up to 20 characters in length. If the ID used belongs to an existing deleted public holiday, it will be un-deleted.
Name String Christmas 2014 Yes
A short name used within the roster and drop-down lists to help you identify the record.
Date Date 2014-12-25 Yes
The date the public holiday falls on. In YYYY-MM-DD format.
Attached to Reference Company Yes
The level within your company the public holiday affects. In most cases this will be set to ‘Company’ as the holiday will affect all areas within it. It could also be attached to specific ‘Areas’ only. Enterprise customers can also attach holidays to their groupings by selecting their group names here.
Affects Reference List No
Comma separated list of ID’s. Each must match a predefined, non-deleted ID of records belonging to the ‘attached to’ level. Note: If ‘attached to’ setting is ‘company’ this field will be ignored.
Affects Helper No
Each of the ‘attached to’ levels the public holiday is attached to. If the ‘attached to’ setting is ‘company’ this field will not show.


When setting Company wide holidays, the ‘Affects’ column will be ignored. You can comma separate a list of location IDs or location grouping IDs to create holidays that will only affect those specific locations orlocation groupings, such as States or Regions.
Once you have imported the data successfully, it will show up and can be edited under Payroll & leave > public holidays .
PLEASE NOTE: If you create or import a public holiday for a period where there are already shifts rostered, please contact Ento Support to arrange a recost of the existing shifts, to ensure any updated earning rates can be applied.

Other relevant articles

Import data overview

Clocking in, requesting leave and more

New manager? Start here!

A closer look at how it all works

Quick answers to common questions

Get the most out of Ento

Popular topics

Create rosters, edit shifts, use fill-in finder, and learn about publishing and costing

In its simplest form, Ento is software that you and your staff can access over the Internet, via a web browser or one of our specially built apps

There are several ways you can capture time and attendance information for comparison against what was rostered.

There are three ways you can access your Staff area - the Website, iPhone or Android.

Capture and review data for staff clocking in and out before it’s sent to payroll. Here’s what you need to know.

Wondering how to set up Auto-recharge? Want to check your credit or renewal date? Making a one off payment? What is an Active staff member?

Create or update multiple records, or sync data from existing HR, payroll & POS systems using CSV templates for file imports

Find the answer to Frequently Asked Questions relating to this topic.

Hook directly into Xero and send through your Ento timesheets for an easy payroll process

Find the answer to Frequently Asked Questions relating to this topic.

Export your timesheet data in one easy file for direct import into MYOB AccountRight

Find the answer to Frequently Asked Questions relating to this topic.

Live chat support

Start a live chat.

Email support

Call support

Call on 03 9999 1234.

Book a demo of Ento