Introduction

OpenSimSim provides the ability to map data between OpenSimSim timecards and Heartland Payroll. Once mappings are in place the CSV export of timecard data from OpenSimSim can be imported directly into Heartland Payroll.

Prerequisite

  1. Subscribed to Attendance with Compliance
  2. Admin OR Manager + timecards level access

Navigation

Timecards -> Export button -> 'Export CSV (Heartland)'

Create mappings between OpenSimSim and Heartland

Please contact Heartland Payroll Support to obtain the codes which are specific to your Heartland 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:

  1. OpenSimSim Schedule to the Heartland Division/Location 
  2. OpenSimSim Position to the Heartland Department Code
  3. OpenSimSim Compliance to the Heartland Earning Codes.

Compliance rules include:

  • Overtime rates
  • Allowances
  • Tips
  • Clock out questions that expect a monetary based answer 

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

  1. Import Type: Timecard
  2. Template: Timeclock File
  3. File Format: Comma Delimited File
  4. Pay Group: Default (for companies w/more than one pay group, choose which one you are paying)
  5. Import Key: Employee Number
  6. Attach File: attach CSV file exported from OpenSimSim, (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.

Did this answer your question?