Importing average holiday days for payment

Average holiday If an Employee's work has no fixed or regular hours, their holiday pay will be based on the average pay they received over the previous 52 weeks (or a average based on the available number of weeks if less than the full 52. days can be imported for payment from the Employees screen. Days are processed in the current open payrun or carried into the next payrun.

New payments or a history of payments can be imported for average holiday days.

Before importing average holiday days

Make sure the following have been done before importing:

• An Average Holiday Pay If an Employee's work has no fixed or regular hours, their holiday pay will be based on the average pay they received over the previous 52 weeks (or a average based on the available number of weeks if less than the full 52. scheme is set up for the employer.
• The import file uses the correct column names and accepted values listed in the Import file columns section.
• Information for required columns have the details entered for every row.

How to import average holiday days

To import average holiday days payment information: 

1. Go to Employees, then select Import.
2. Select Average Holiday Pay, then select either: 
   • Importing new payments — select Import Average Holiday for Payment.
   • Importing a record of previous payments made — select Import History for Average Holiday Pay.
3. Upload the file.

Days are processed in the current open payrun. If there is no open payrun, they are included in the next payrun.

Average Holiday import file columns

When creating an import file for Average Holiday, the file must include the columns in the Import file columns table.

If a required column is missing or contains the wrong value, the import will not process it. Check that all required columns are in the file and have accepted values entered.

Import file columns table
Column Name	Required field	Accepted vales	Useful information
Payroll Code	Yes	The exact Payroll Code as it is on the employee's record.	To find an employee's Payroll Code, go to Employees, select Employment, then Overview.
First Name	No	Must be entered exactly as the Name is displayed on the Employee record in Staffology Payroll.
Last Name	No	Must be entered exactly as the Name is displayed on the Employee record in Staffology Payroll.
Type	Yes	Holiday must be entered.	Any other value enter causes the import to fail.
Payment	Yes	Average Days must be entered.	Any other value enter causes the import to fail.
Open Ended Absence	Yes	Enter TRUE if the absence does not have an end date.   If the absence has an end date, enter FALSE if it is not.	If set as TRUE only a From date is required in the file.   If set as FALSE, both From and To date must be entered
From	Yes	The date for the start of the absence in dd/mm/yyyy format.
To	Yes	The date for the end of the absence in dd/mm/yyyy format. If not known, leave blank.
Pro Rata Rule	No	TRUE if Pro Rata Rule applies, and FALSE if it does not.	If left blank, the scheme default is used.