Heartland Payroll Export

If you are using 7punches for time-clocking, or have a POS integration that includes labor, you can now export your worked hours in a Heartland-ready format.

⚠️This feature is only available on the Works plan or higher.
⚠️To access the export you must be using 7punches or have a POS integration that includes labor data.

Activating the Heartland Export

To enable the export, you'll need to do the following:

1. Hover over the 'More' menu > Integrations > click on 'Add Integration.'

2. Search and select Heartland, thenclick 'Connect.'

3. Once you have added your integration into your account, you will need to enable and customize some of the individual features of the integration. 

To find these settings, hover over to the  'More' menu > Integrations.

4. My Integrations > Heartland and click on 'Settings.'

5. Choose whether to 'Split Hours by Role.' 

⚠️ If this setting is enabled, Employee hours will be split into separate columns in the spreadsheet, but will not be associated with your payroll provider’s departments, pay codes, or wage codes. (However, this can be manually added to the spreadsheet before uploading to the payroll program.)

For more information please reach out to support at support@7shifts.com.

7. Click on 'Edit Employee IDs' or 'Edit Location Mapping' to navigate to the mapping page.

You will need to complete entering both the Location and Employee IDs on the mapping page before setup is finalized. This required in order to match your Employees and Locations in 7shifts to their Heartland ID numbers and have those included in the CSV.

Enter the Employee's File Number next to their name.

Be sure to hit 'Save' at the bottom of the page when you're done mapping your Employees.

Under the 'Locations' tab, update the Payroll Export Shop Numbers for each corresponding Location in 7shifts.

Be sure to hit 'Save' at the bottom of the page when you're done mapping your Locations.

⚠️In the export, the column LABOR VALUE 1 is the Location code (Payroll Export Shop Number in Heartland). 

Preparing your Export File

Before you can run the Heartland payroll export, you'll need to ensure that you've properly approved all punches and closed your timesheet.

1. Click the Time Clocking tab at the top of the screen, then select the appropriate Pay Period.

2. From there, review and 'Approve' or 'Modify' any unapproved punches, or choose to 'Approve All.'

3. For multi-Location users, you can also choose to sort by Location and approve punches by Location.

4. Once you've approved all punches, you're ready to close the Timesheet.

To close it, select 'Close Timesheet' in the top right corner.

⚠️For multi-Location users, you can close Timesheets on a Location basis. However, the Heartland export will export punches from all locations, regardless of if Timesheet is closed. 

5. With the Timesheet closed, you can export it by selecting 'Export' then 'Heartland.'

6. You can now import your payroll data to Heartland.

The columns included in the Heartland export are:

Key
E_Regular_Hours
E_Overtime_Hours
LaborValue1
LaborValue2
E_Regular_ORRate
E_Overtime_ORRate
⚠️Contact your Heartland representative if you have questions about this step.
Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us