Overview: The QuickBooks Desktop integration is done using the QuickBooks web connector. Sync time on demand when you're ready to process payroll or set up auto-run.
Important Notes: In order to use the QuickBooks Desktop integration, you'll need an Administrator account with Buddy Punch. You will also need access to the QuickBooks main administrator account - a different user with admin rights will not work and may cause unexpected behavior.
Buddy Punch does transfer Time Off; however, we do not update any Time Off accrual balances in QuickBooks Desktop.
Instructions:
Additional Resources:
QuickBooks Desktop Integration Setup
1. Start by clicking Settings in the top navigation, followed by Integrations:
2. Click the Integrate with QuickBooks Desktop button:
3. On the QuickBooks Desktop Integration page, you'll want to start the integration setup process by downloading the QuickBooks Web Connector. By default, the downloaded file should go to your Downloads folder. Once downloaded, extract the file and open the installer:
4. Next, you will need to download the Buddy Punch Web Connector file:
5. Now that you've downloaded both files and installed the web connector, you will want to open it. If this is the first time using the web connector, you'll be presented with a screen that looks like the one below.
Start by clicking the Add an Application button:
6. Navigate to the folder where the Buddy Punch web connector file was saved and open it:
7. After you've selected the Buddy Punch web connector file, it should now be added to the web connector itself. To initiate the first sync to pull employee information into Buddy Punch, check the box next to the Buddy Punch application:
8. You will then be prompted to enter a password. Each Buddy Punch account has a unique password, which can be found on the QuickBooks Desktop Integration page in the same area where the web connector download link is found:
9. To begin the sync and pull employee information in, just click the Updated Selected button:
10. Once the process is complete, you'll then need to map your employees, which you can do from the QuickBooks Integration page by clicking the Map Employees button:
Mapping employees is an easy process. Select the dropdown next to the employee's name and choose the corresponding option. Save once done.
11. You will also need to map your payroll items, which you can do from the QuickBooks Integration page by clicking the Map Payroll Items button:
Payroll items are pulled in from QuickBooks during the sync. The additional categories outside of Regular, Overtime, and Double Time are controlled by your Time Off Types, which can be found by going to Settings --> Time Off in Buddy Punch. Once you've mapped your employees, Save once done:
Please Note: If you don't see the correct payroll items, these may need to be updated in QuickBooks. You can do this by clicking Employees in the top navigation of QuickBooks, followed by Employee Center. You'll then want to click on an employee's name and select Payroll Info.
Important: If an employee doesn't have rates, then we won't be able to transfer time for that employee, as we will not know which rates to associate with the employee:
If you add a new employee or change payroll information, you need to re-sync using the web connector to pull in new details.
12. As a final step, you will need to enable Time Tracking in QuickBooks Desktop if this is the first time you're using the option. QuickBooks has a great support article explaining the process, which can be found here: https://quickbooks.intuit.com/learn-support/en-us/manage-timesheets/set-up-time-tracking/00/186222
Transfer Time to QuickBooks Desktop
Now that you've got the integration all set up, you can transfer time to QuickBooks Desktop using the web connector.
If you want to view the time that is available to transfer, you can do this from the QuickBooks Desktop Integration page by clicking the View Available Time button:
If you're not seeing time that you believe should be in the Available Time section, check the unavailable time, which you can do by clicking the View Unavailable Time button.
There you'll find all unavailable times and a reason the time is not available, such as, "This punch is too old to export based on your QuickBooks Desktop integration settings."
1. To begin the sync, launch QuickBooks Desktop and the web connector;you should see the Buddy Punch application that was added during the integration setup.
Simply check the box next to the Buddy Punch application and click the Update Selected button. The sync will begin automatically, and will let you know once completed:
2. To view the data synced with QuickBooks, click the View Sync History button on the QuickBooks Desktop Integration page and then View next to the sync you ran. If any error occurred during the sync, it will be visible here:
View Time in QuickBooks Desktop
1. To view the time transferred into QuickBooks Desktop, start by selecting Employees in the top navigation, followed by Enter Time. Then click Use Weekly Timesheet:
2. You will then be able to see all hours transferred over from Buddy Punch and their corresponding Payroll Item code:
Video:
FAQ:
Q: When I transfer time off from Buddy Punch, will it automatically update time off balances in QuickBooks?
A: No. While we transfer time off to QuickBooks Desktop, we do not automatically update employee time off balances.
Q: I'm getting an error stating, "QBWC1039 Unique Owner ID/File ID pair value required." How can I fix this?
A: We have a detailed article that goes over how to resolve this error, which can be found here: QBWC1039 Unique Owner ID/File ID pair value required Resolution
Q: I'm getting an error that states, "Failed to transfer time for (Employee Name). Please check the box labeled "Use time data to create paychecks" in QuickBooks for (Employee Name). How can I resolve this?
A: This error occurs due to not having "Use time data to create paychecks" checked in QuickBooks. This article goes over how to resolve this issue in more detail: Set up Time Tracking In QuickBooks Desktop
Q: Why can't I transfer a shift/punch that is more than 24 hours to QuickBooks Desktop?
A: If an employee has a single shift/punch time that is more than 24 hours, QuickBooks Desktop will not allow you to transfer that time. QuickBooks has a limitation in that they only allow transfer of up to 24 hours in a single time activity.