QuickBooks Online Payroll Integration

If you are using 7punches for time-clocking, or have a POS integration that includes labor, you can now send your regular hours, OT hours, and double OT hours directly to QuickBooks Online.

This feature is only available on The Works plan or higher and for those using QuickBooks Online.
🇨🇦 Full functionality is not available for clients using QuickBooks Online in Canada. For Canadian clients, all hours will send as regular hours, as overtime hours (OT) is not supported.

Enabling the QuickBooks Payroll Integration

Mapping Employees

Exporting your Timesheets to QuickBooks

QuickBooks Payroll Integration

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

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

  2. Seach and select 'QuickBooks', and click 'Next.'

  3. Click on 'Connect to QuickBooks.'

4. You will be taken to Quickbooks to login and authorize the connection to 7shifts.

5. Click 'Connect' and you will be redirected back to 7shifts. 6. Finally, click on the QuickBooks integration and click 'Settings. If you have multiple locations in 7shifts, and they don't all use QuickBooks you can select the ones you want to connect.

7. Your QuickBooks account is now successfully connected, but before you can start running payroll you'll need to Map your Employees.

Under the 'Payroll Mapping' tab, click 'Map Employees.'

Mapping Employees

Once connected you will need to Map your Employees.

You can always update your mapping by going to the ' More' menu > Integrations > Mapping. 

  • For unmatched Employees, you can either find a match or choose to 'ignore' them if you won't need to sync timesheets for that Employee.
  • Please review all matched Employees before clicking 'Save'.
  • Remember each time you add a new employee to 7shifts or QuickBooks, you'll need to ensure that they are properly mapped.

Prepare your Export to QuickBooks

Before you can send data to QuickBooks, you'll need to ensure that you've properly approved all punches and closed your timesheet.

1. Click the 'clock' icon at the top of the screen, then select the appropriate Pay Period.

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

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

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

4. Once the Timesheet is closed you can send it to QuickBooks by clicking  Export > QuickBooks.

Including Paid Time Off (PTO):

To include Employees' Paid Time Off, Paid Sick Time Off, and Unpaid Time Off hours within the report, you will need to enable these features under your Company Settings.

Click here to enable Paid Time Off (PTO).

Still need help? Contact Us Contact Us