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

Question

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.

Lynn C · Answer

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:

RECTYPE 
 EMPLOYEE 
 PEREND 
 TIMECARD 
 LINENUM 
 CATEGORY 
 EARNDED 
 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.

Sage HRMS

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

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING