image

Import Style #70 Holiday Pay

Import Style Specifications

image  Overview

image  Style #61 Alternative Days Taken

image  Basic Generic Import

image  Style #62 Public Holidays

image  Style #15 Add New Employee

image  Style #63 Bereavement Leave

image  Style #50 Hours Worked and Departments

image  Style #70 Holiday Pay

image  Style #51 Allowances and Deductions

image  Style #89 Delete File After Import

image  Style #52 Hours Worked & Pay Rate

image  Style #99 User Interface Customisation

image  Style #60 Sick and Special Leave

image  Inserting Comments

Style #70 Holiday Pay

Style #70 is used for importing holiday pay data from an external source, such as a third party timeclock.

Ace Payroll supports the payment of holiday pay using all the methods currently used by New Zealand businesses. These methods are

Percentage Of Gross - this method accrues holiday pay as a percentage of gross.

If less than a full years service this method when set at 6% gives the same result as the Annual Leave method, and a close approximation if employed longer.

Annual Leave - this method pays holiday pay exactly in accordance with the

Holidays Act 2003 by accounting for both days taken and dollars paid.

Casual Holiday Pay - this method is designed for casual employees, and pays out

holiday pay each pay period as a percentage of gross.

No Holiday Pay - this method is used for the rare situations in which no holiday

pay is paid to an employee, such as the employment of contractors, etc.

Within some of the above methods, different methods are called based on the employee circumstances at the time holiday pay is paid.

In other words, using the Annual Leave method, the calculation and payment of holiday pay is completely different depending on whether an employee is continuing their employment, or terminating it.


When designing this import style, we have excluded support for those methods where the automated import of data makes no sense. The methods excluded are

No Holiday Pay - self explanatory. Casual Holiday Pay - if an employee is set to be paid holiday pay using

this method, the holiday pay is based entirely on gross wages. No additional information is required.

Annual Leave and Percentage Of Gross - for these two methods, we have

assumed that the employee is continuing their employment, rather than receiving a termination pay.

If the employee holiday calculation method is set as either "No Holiday Pay" or "Casual Holiday Pay" the line is ignored. Otherwise it is imported on the assumption the employee is continuing their employment.


Holiday Pay is imported into Ace Payroll by adding a line within the generic import file. The line contains a maximum of 9 fields, as follows

#70, Employee ID, Entitlement, Days Taken, Daily Rate, Tax Weeks,

Amount Paid, Hours Paid, Hourly Rate


Field 1 Style

Field 2 Employee ID

Field 3 Entitlement

Field 4 Days Taken

Field 5 Daily Rate

Annual Leave

Percentage of Gross

Field 6 Tax Weeks

Field 7 Amount Paid

Annual Leave

Percent Of Gross

Field 8 Hours Paid

Annual Leave

Percent Of Gross

Field 9 Hourly Rate

Annual Leave

Percent Of Gross


Examples

#70,JS,0,1.25,,,,10

Annual Leave - pays the employee 1.25 days at their average daily rate, and reduces their holidays entitlement accordingly.
Percent Of Gross - records that 1.25 days of holiday have been taken, and makes payment of 10 hours at the first pay rate used by the employee.

#70,JS,,,,,,40

Annual Leave - will fail validation and import cannot proceed, because no days have been specified.
Percent Of Gross - pays 40 hours of holiday pay at first rate used. No days taken can be recorded, which results in incomplete holiday records.

Import Style Specifications

image  Overview

image  Style #61 Alternative Days Taken

image  Basic Generic Import

image  Style #62 Public Holidays

image  Style #15 Add New Employee

image  Style #63 Bereavement Leave

image  Style #50 Hours Worked and Departments

image  Style #70 Holiday Pay

image  Style #51 Allowances and Deductions

image  Style #89 Delete File After Import

image  Style #52 Hours Worked & Pay Rate

image  Style #99 User Interface Customisation

image  Style #60 Sick and Special Leave

image  Inserting Comments

Associated Documentation

image  System Information Utility

image  Importing Data Into Ace Payroll

Alphabetical Index   FAQ Questions   FAQ Contents Back to top