Time clock XML file data structure

Show expandable text

We moved!

Help articles have been migrated to the new Help and Support. You can find help for your products and accounts, discover FAQs, explore training, and contact us!

For live payroll processing only

Each data block in an XML-format file for time clock import contains the following information.

Employee ID. (Required) This must exactly match the Employee ID in the application.

Employee Note. (Optional) This is a text field that allows you to send additional information such as information about the employee or special instructions for allocations.

Period begin date. (Required) The date the payroll period began.

Period end date. (Required) The date the payroll period ended.

Payroll items. (Optional) One or more payroll items describing amounts that apply to the specified period. Payroll items also include the following information.

  • Description. (Required) The description must exactly match the payroll item description in the application. The names are case-sensitive.
  • Department. (Required if a Location is specified, otherwise Optional) This is used if it's necessary to identify which department the payroll item is associated with. When it is used, it must exactly match the department name in the application.
  • Location. (Required if a Department is specified, otherwise Optional) This is used if it's necessary to identify which location the payroll item is associated with. When it is used, it must exactly match the location name in the application.
  • Deduction item specifics.
    • Amount. (Optional) Defines a fixed amount (with no more than two decimal places) which will be used to override the amount calculated by the application.
  • Pay item specifics.
    • Rate override. (Optional) This is used when you need to provide an override value for a rate that already exists in the application. When this is used, it must be accompanied by values for Regular Hours, Overtime Hours, or Double-time Hours. The same rate applies to all hourly values in the pay item. This rate will update the rate set up for the employee in the Payroll Items tab of the Setup > Employees screen. For salary payroll items, the amount included will be annualized.
    • Regular Hours. (Optional) Allows no more than two decimal places.
    • Overtime Hours. (Optional) Allows no more than two decimal places.
    • Double-time Hours. (Optional) Allows no more than two decimal places.
    • Fixed Amount. (Optional) When used, this defines a fixed amount for the payroll item and will have no relation to the hour-based amounts. This field is only recognized when no hours are associated with the pay item and does not affect salary items.
  • Accruable Benefit Item Specifics. (Optional)
    • Description. (Required) The description must exactly match an accruable benefit description in the application.
    • Hours. (Optional) Allows no more than two decimal places.

Note: Tips are payroll items, and are displayed in the file just like all the other payroll items. They do not require a separate Tips entry (as they do using the ASCII file format).

Was this article helpful?

Thank you for the feedback!

Internal only

Per ADO 858925, a difference in the time zone offset can prevent xml timesheet import.
Solution can possibly be changing the date and time stamp in the file. (changing -5:00 (Eastern time zone) to -6:00 (Central).
A reference table for zone offset: http://www.timetemperature.com/tzus/gmt_united_states.shtml

Zone offset definition.
What is a "zone offset"? A zone offset is the difference in hours and minutes between a particular time zone and UTC. In ISO 8601, the particular zone offset can be indicated in a date or time value. The zone offset can be Z for UTC or it can be a value "+" or "-" from UTC. For example, the value 08:00-08:00 represents 8:00 AM in a time zone 8 hours behind UTC, which is the equivalent of 16:00Z (8:00 plus eight hours). The value 08:00+08:00 represents the opposite increment, or midnight (08:00 minus eight hours)