Skip to main content

Legal

Tax & Accounting

Trade & Supply

Risk & Fraud

News & Media

Books

Developers

Integrate payroll data

Time clock XML file data structure

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 you can use 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's used, it must exactly match the location name in the application.
  • Deduction item specifics.
    • Amount.
       (Optional) Defines a fixed amount (with no more than 2 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
       then
      Employees
       screen. For salary payroll items, the amount included will be annualized.
    • Regular Hours.
       (Optional) Allows no more than 2 decimal places.
    • Overtime Hours.
       (Optional) Allows no more than 2 decimal places.
    • Double-time Hours.
       (Optional) Allows no more than 2 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 doesn’t 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 2 decimal places.

This article applies to:

  • Product: Accounting CS, Accounting CS Client Access
Chat now

error-icon

Triva isn't available right now.

Check out the support page for our phone number and hours

error-close