Overview: The Quickbooks Desktop integration is done through the use of the Quickbooks web connector. Sync time on demand when you're ready to process payroll or setup 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.
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 have 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. Just 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 will 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 Employee Time to Quickbooks Desktop
Now that you've got the integration all set up, now you can transfer time to Quickbooks Desktop using the web connector.
If you want to view 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 time 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 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 that was 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 Employee Time in Quickbooks Desktop
1. To view time that's been 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:
Q: When I transfer time off from Buddy Punch, will it automatically update time off balances in Quickbooks?
A: No. While we do transfer time off to Quickbooks Desktop, we do not automatically update employee time off balances.
Q: I'm getting an error which states the following, "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 which 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 as a result of 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
To view this full article outside of the chat window, please click here.