SmartFusion Modules > Payroll > Maintenance > Special Maintenance > Time and Attendance Systems > Time and Attendance Import/Export

Recent Changes:  
6.164 - Added "Effective Date" for the Export Leave Balances functionality for Gorrie Regan2  

6.138 - Updated "Export leave information" for Time Clock Plus to add blank records if an employee's Time Clock Plus code and employee's leave code are missing from the original data pull

6.137 - Added a new checkbox for Time Clock Plus to 'Create duplicate file' when exporting employee information. 

6.112 - Changed the import for Vermont Systems to remove any double quote marks (")

6.110 - Added checkbox for Gorrie Regan to 'Exclude inactive leave types on employees'.  

Refer to bottom of page for changes prior to version 6.100

Introduction

This screen allows the user to import or export different kinds of data for a number of supported Time and Attendance system types. The user must also have the valid license for this screen to appear.

Explanation

Some things may be hidden and/or operate differently depending on the user's payroll system configuration.

Import Earnings

Import earnings filename
Object for overtime
Clear temporary earnings file
Zero regular pay
Exceptions
Disable deductions
Disable direct deposit
Disable second direct deposit
Disable additional tax

Import Leave

Import leave filename

Export Employee Information

Include employment status - visible for Time Clock Plus - employment status will be added as the last field in the export file

Exclude inactive leave types on employees - Visible only for Gorrie Regan. If checked will exclude leave types that are inactive on the leave tab of the E/E Employee.

Date range to check for employee status

Create duplicate file - visible for Time Clock Plus - When checked will allow the creation of a duplicate file to be used for Time Clock Plus employee job codes export.

Export filename -Export employee information filename

Export duplicate filename -Export employee job code information filename. It will be visible only if the 'Create duplicate file' checkbox is checked.

Export Leave Balance

Export leave balance directory or filename
Effective date - visible only for Gorrie Regan2 time and attendance system

Export Leave Information - Time Clock Plus

Important Note: Leave codes must be active and active on the employee level for leave information to be exported. Employee must also be set to export time and attendance.
Export filename
Effective date - The date that will be listed as the effective date in the leave information export for POSTDATE. This date will also be part of the NOTE field in the export.

Time and Attendance System Type

Only visible when "Multiple time and attendance vendors" is selected in the Payroll System configuration file (Page 4)

Changes Prior to Version 6.100

6.97 
- Added logic to handle earnings import for Vermont Systems 
- Fixed the exception report to show 4 decimal places and brought it up to UX Standards 

6.96 - Removed leading and trailing blanks from first name, last name, address, and city for the Time Clock Plus employee export.

6.86 - Added a checkbox on the time clock plus export screen to include Employment Status.

6.56 - Added a new effective date selection for exporting leave information below the filename selection.

6.55 - Added a new type called "Gorrie Regan 2".

6.39 - Time Clock Plus Export changes. added new fields and options to hide SSN and DOB.

6.16 - Time Clock Plus Import leave would cause an out of memory error.  This option was corrected and no longer causes this issue.