Is there an Import file template and instructions to import hours from 3rd party time keeping system?

SUGGESTED

We are implementing a new time clock/ time keeping system that has the ability to create an import file of employee hours.  I am looking for the required template that this file needs to match and instructions covering the creation of the needed file and how to import this file in Sage HRMS.  Any help would be appreciated.

  • 0
    SUGGESTED

    In the Sage Knowledge there is article ID: 29342 - 'Fields required on a Time Card import in Sage HRMS'.

    Time cards have many fields in Sage HRMS but only eight are required to import time.

    Additional fields may be required for specific situations.

    Resolution

    The required fields to import time cards in Sage HRMS are:

    1. RECTYPE
    2. EMPLOYEE
    3. PEREND
    4. TIMECARD
    5. LINENUM
    6. CATEGORY
    7. EARNDED
    8. HOURS

    I recommend backing up your data prior to doing any import.  You can import timecards from within a timecard by selecting File > Import.  I suggest doing a timecard export to see the values in all the fields.  Do an export for the different earnings that you have.  For an example, an accrual will look different than regular pay, etc. 

  • 0 in reply to Lynn C

    Thank you for the information.