QuickBooks Online Payroll Integration

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

SKIP AHEAD TO:
Enabling the QuickBooks Payroll Integration
Mapping Employees
Preparing your Payroll data
Including Paid Time Off (PTO)
⚠️ This feature is only available for those using QuickBooks Online (US), and may require an upgrade from your current plan.

⚠️ The QuickBooks Online integration currently only supports one Company Code per 7shifts account.
🇨🇦 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) are not supported.


Enabling the QuickBooks Payroll Integration

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

1. In the left navigation bar, head to Apps & Integrations:

 

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


3. Click on 'Connect to QuickBooks.'

4. You will be taken to QuickBooks to log in and authorize the connection to 7shifts.

Screenshot 2023-12-21 at 12.59.14 PM.png

5. Click 'Connect' and you will be redirected back to 7shifts.



6. In 7shifts, click on the QuickBooks integration and click on 'Settings.'

If you have multiple Locations in 7shifts, and they don't all use QuickBooks you can simply 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' to get started.


Mapping Employees

⚠️ Once connected you will need to map your Employees. This is required in order to match your Employees in 7shifts to their counterparts in QuickBooks and to process payroll.

You can always update your mapping by completing the following:

1. Go to Apps & Integrations > Mapping.

2. 7shifts will automatically map any Employees that already exist between your payroll and 7shifts, if they are both spelled the same way, with identical capitalization and spacing. You'll find those under the 'Mapped' heading.

3. Any Employees that cannot be automatically matched will be under the 'Unmapped' or 'Ignored' tab. 

aniEMPLOYEES.png

  • 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 processing payroll.
⚠️ Remember:

  • Each time you add a new employee to 7shifts or QuickBooks, you'll need to ensure that they are properly mapped.
  • If a user is set up as a 'contractor' in QuickBooks, they will not appear on the Mapping page or be able to be mapped in 7shifts.
Click here to learn more about Employee mapping.


Preparing your Payroll data

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

⚠️ Only Admins can close all timesheets, a mandatory step to send payroll data to your integration successfully.

1. In the left navigation bar, select the 'Time Clocking' tab, and the appropriate Pay Period.

2. From there, review and 'Approve' or 'Edit' 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 can close the Timesheet.

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

⚠️ For multi-Location users, you can close and export Timesheets on a Location basis.

If you are using this method, be sure to select the correct Location in the 'Location' dropdown before selecting the 'Export' option.

5. Once the Timesheet is closed you can send it to QuickBooks by clicking 'Export' and 'QuickBooks.':



Exporting Timesheets to Quickbooks Online

⚠️ At this time, the employee worked hours sent to QuickBooks cannot be split by Role.

⚠️ 7shifts does not support exporting hours for users set up with a salary compensation in Quickbooks. Instead, you can

  • Remove the hours of salaried users before exporting.
  • Or, switch the users in QuickBooks Online from "salary" to "hourly" compensation.


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).
Was this article helpful?
3 out of 6 found this helpful