Introduction
Workforce provides the ability to map data between Workforce timecards and Heartland Payroll. Once mappings are in place, the CSV export of timecard data from Workforce can be imported directly into Heartland Payroll.
Prerequisite
Administrator or Manager with 'manage timecards' sub-permission
Navigation
From Lighthouse Business Manager, click on Workforce->Timecards.
From the Timecards dashboard, then click Export > Export to Payroll > Heartland Payroll (CSV)
Create mappings between SkyTab Workforce and Heartland
Please contact Heartland Payroll Support to obtain the codes which are specific to your Heartland Payroll account.
Important: The mapping of Earning Codes is mandatory. The mapping of Division/Location codes and Department codes are optional.
Click 'Create Mapping' to map the following data:
SkyTab Workforce Department to the Heartland Division/Location
SkyTab Workforce Department Job to the Heartland Department Code
SkyTab Workforce Department Compliance Rule to the Heartland Earning Code.
Compliance rules include:
Overtime rates
Allowances
Tips
Export CSV file
Once mappings have been created, click 'Export' to generate the Heartland CSV file.
Maintaining mappings
All mappings are saved and will be remembered the next time you perform an export. However, be aware that new data can be created in Heartland Payroll that will need to be mapped. Any data that does not have a mapping will be blank in the export file. It is prudent to check the mappings prior to running an export to ensure all data has been properly mapped.
Import CSV file to Heartland Payroll
Perform these steps to import your file into Heartland Payroll.
Choose the following in the 'Time Card Import' screen
Import Type: Timecard
Template: Timeclock File
File Format: Comma Delimited File
Pay Group: Default (for companies w/more than one pay group, choose which one you are paying)
Import Key: Employee Number
Attach File: attach CSV file exported from Workforce, (click to browse where file is saved)
Click the ‘Validate’ button
Once you get the next page, you must ALWAYS view the ‘validation’ results. If any of these have a number other than zero, you must ALWAYS view the details by scrolling to the bottom of the page and clicking on the ‘View Validation Details’ button.
If there are no errors, proceed by clicking on the ‘Import’ button.