image

Import Style #62 Public Holidays

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 #62 Public Holidays

When an employee is paid for working on a public holiday, there are four considerations. These are

    Entitlement - What is the employee entitlement, bearing in mind this
  • may differ depending on whether the employee worked on the public holiday, or alternatively did not work on the public holiday, but would have worked if it were not a public holiday.
  • Amount Of Payment - An employee may be paid based in hours and an hourly
  • rate, a daily rate, or a specific amount decided by the user.
  • Days In Lieu Entitlement - Having paid the employee for working, or not
  • working as the case may be, on a public holiday, are they also entitled to additional days in lieu at a later date?
  • Additional Details - Many users like to record a brief reason for the
  • public holiday, and a field is provided for this reason.

When importing data from an external source for public holidays, each of the above is considered.



Public Holidays may be imported to Ace Payroll by adding a line within the generic import file. The line contains a maximum of 8 fields, as follows

#62, Employee ID, Entitlement, Hours Paid, Hourly Rate, Amount Paid, Lieu Days Added, Reason

The specification for public holidays is identical to that for styles 60 to 63 apart from fields 1,3 and 7.



Field 1 Style
For public holidays, this is always #62.

Field 2 Employee ID
Up to 5 characters identifying the employee, as identified by Ace Payroll. This field is always validated, and import will not proceed if this field does not identify a valid employee.

Field 3 Entitlement
Currently, this field is either left blank, or contains a zero. The data contained in the line is always imported irrespective of the employee entitlement.

The specifications for this field may be enhanced at a later date.

The value of this field is currently not validated, but the field must exist. It must be either blank, or contain a zero.

Field 4 Hours Paid
This field is optional. If used, payment will be made to the employee based on the number of hours in the field, multiplied by an hourly rate.

Field 5 Hourly Rate
This field is optional, and is only relevant if a value exists in the previous field. If both fields exists, the employee is paid by multiplying the values together.

If this field is blank, and a value exists in the hours paid field, the employee is paid using the value of their first pay rate used.

Field 6 Amount Paid
This field is optional, and is only used if the hours paid field is either zero, or blank. If so, the amount in this field is paid as the total dollar amount.

Note: It is permissable for fields 4, 5 and 6 to all be blank. This is

done if the purpose of the import is to reduce an employee entitlement, without making specific payment for it. This could be done if an employee is paid by salary, and the user prefers to leave the salary payment untouched.

Field 7 Lieu Days Added
This field is optional, and if used contains the number of days in lieu the employee is entitled to from working on the public holiday.

Field 8 Reason
This field is optional, and contains up to 25 characters decribing the leave entry. If the field is either blank, or does not exist, the reason is shown as "imported data".

Examples

#62,JS,0,8 - this line pays employee JS for 8 hours leave, at the rate of their first pay rate used. No adjustment is made to the employee entitlement, and the reason is shown as "imported data".

#62,JS,0,8,12.75 - this line pays employee JS for 8 hours leave,

at the rate of $12.75 an hour. No adjustment is made to the employee entitlement, and the reason is shown as "imported data".

#62,JS,0,0,0,115.75 - this line pays employee JS $115.75 for leave

taken. No adjustment is made to the employee entitlement, and the reason is shown as "imported data".

#62,JS,0,0,0,115.75,1.25,"took easter days" - this line pays employee JS $115.75

for working on the public holiday, and increases their entitlement to days in lieu by 1.25 days. The reason is shown as "worked over easter".

#62,JS,0,0,0,0,1.25,"took easter days" - this line does not pay the employee any

amount, but increases their entitlement to days in lieu by 1.25 days. The reason is shown as "worked over easter".

#62,JS,0,22,0,0,2.75,"worked over easter" - this line pays the employee 22 hours at

their first pay rate used, and increases their entitlement to days in lieu by 2.75 days. The reason is shown as "worked over easter".

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