The Timesheet Data File Format

_______________________________________________________	__________________________________________________________________________________________________________________________________________________________________________________________________________________________________________.
Company Name	This mandatory field is the name of the company to import into. Please note that you need the correct company to be open when importing.
_______________________________________________________	__________________________________________________________________________________________________________________________________________________________________________________________________________________________________________.
Employee Number	This mandatory field is the Elite Payroll employee number and must correspond with the employee that the timesheet belongs to.
_______________________________________________________	__________________________________________________________________________________________________________________________________________________________________________________________________________________________________________.
Pay Type	This mandatory field must describe the type of payment. It must be one of the following types: $image\bullet.gif$ Time $image\bullet.gif$ Pay rate $image\bullet.gif$ Allowance $image\bullet.gif$ Deduction
_______________________________________________________	__________________________________________________________________________________________________________________________________________________________________________________________________________________________________________.
Pay Date	This mandatory field corresponds to the Pay Date for the current pay being processed. It must be in dd/mm/yyyy format.
_______________________________________________________	__________________________________________________________________________________________________________________________________________________________________________________________________________________________________________.
Date Paid	This mandatory field corresponds to the Date Paid for the current pay being processed. It must be in dd/mm/yyyy format.
_______________________________________________________	__________________________________________________________________________________________________________________________________________________________________________________________________________________________________________.
Award Name	This optional field is the name of the Elite Payroll award that the employee is to be paid under. If the employee to be paid under this award has selected the Use Award Pay Rates option on the employee record Pay Rates tab, then the employee will be paid as per the rates set up in this award.
_______________________________________________________	__________________________________________________________________________________________________________________________________________________________________________________________________________________________________________.
Date Shift Started	This mandatory field corresponds to the actual day the employee worked. It must be in dd/mm/yyyy.
_______________________________________________________	__________________________________________________________________________________________________________________________________________________________________________________________________________________________________________.
Time Shift Started	This mandatory field corresponds to the time the employee started work. It must in hh:mm (24-hour) format.
_______________________________________________________	__________________________________________________________________________________________________________________________________________________________________________________________________________________________________________.
Date Shift Ended	This mandatory field corresponds to the actual day the employee finished work. It must in dd/mm/yyyy format. This usually will be the same as Date Shift Started, unless the employee worked over midnight.
Time Shift Ended	This mandatory field corresponds to the time the employee finished work. It must in hh:mm (24-hour) format.
_______________________________________________________	__________________________________________________________________________________________________________________________________________________________________________________________________________________________________________.
Pay Type Name	This is the actual name of the pay rate, deduction or allowance and must match the Elite Payroll name. It is mandatory when importing allowances, deductions or payrates. Do not use this field when importing timesheet details.
_______________________________________________________	__________________________________________________________________________________________________________________________________________________________________________________________________________________________________________.
Amount For Pay Type	This field relates to number of hours worked when importing pay rates, deduction amount when importing deductions or allowance amount when importing allowances. Do not use this field when importing timesheet details.
_______________________________________________________	__________________________________________________________________________________________________________________________________________________________________________________________________________________________________________.
Customer:Job	This optional field relates to the Customer:Job field in the pay rate or allowance. This field should not be used for importing deductions.
_______________________________________________________	__________________________________________________________________________________________________________________________________________________________________________________________________________________________________________.
Class	This optional field is relates to the Class field in the pay rate or allowance. This field should not be used for importing deductions.
_______________________________________________________	__________________________________________________________________________________________________________________________________________________________________________________________________________________________________________.
Deduction ID	This optional field should contain a description for the deduction ID
_______________________________________________________	__________________________________________________________________________________________________________________________________________________________________________________________________________________________________________.
Super	This field is only used for deductions and should be either Yes/No, Y/N or 1/0.
_______________________________________________________	__________________________________________________________________________________________________________________________________________________________________________________________________________________________________________.
Ex Tax	This field is only used for deductions and allowances and should be either Yes/No, Y/N or 1/0.
_______________________________________________________	__________________________________________________________________________________________________________________________________________________________________________________________________________________________________________.
Union	This field is only used for deductions and should be either Yes/No, Y/N or 1/0.
_______________________________________________________	__________________________________________________________________________________________________________________________________________________________________________________________________________________________________________.
Items To Copy	This optional field can contain up to 3 of the following characters, in any order: R to copy Payrate details from the employee record to the pay record. A to copy Allowance details from the employee record to the pay record. D to copy Deduction details from the employee record to the pay record.
_______________________________________________________	__________________________________________________________________________________________________________________________________________________________________________________________________________________________________________.