I’ve got the information you need, so you’ll be able to import your employees’ hours to QuickBooks, @jillirwin.
Yes, you can import employees’ hours from a third-party app into QuickBooks Online (QBO). You can utilize an importer tool to obtain this. Visit our Apps Center or go to your Apps menu to find one.
QuickBooks also offers integration to several applications so users can manage their data more efficiently. If your tracking app is one of the supported applications, you can connect it directly to QuickBooks. This way, your employees’ hours automatically sync.
I’ve added this guide to learn more about managing employees’ records in the program: Manage workers and employees. It has everything you need to get your books accurate for payroll.
And in case you need more tips and information on how to organize your account and business finances. We have available resources, webinars, and training videos on our Support page.
If you have any other questions or concerns besides importing employees’ hours, you can add them to your reply below. I’ll be here. Have a good day and always take care!
Prepare your Time Activities data with the following template
|01/10/2020||Mike's Traders||5||Sample Time Activity using hours and decimal||Janice Johnson||Hours|
|01/10/2020||Eagle Outfitters||4.5||Sample Time Activity using hours only||Janice Johnson||Hours|
|01/10/2020||Mary Smith||0.5||Sample Time Activity using hours and minutes||Billable||Janice Johnson||ENG Svs:120||75||FALSE|
then utilize an importer tool
You need to prepare with a different template for QB Desktop
|Name||Transaction Date||Customer||Service Item||Payroll item||Duration||Class||Billable||Notes|
|John Marks||01/09/2020||Nguyen, Tuan||Labor||Regular Pay||1:25|
|John Smith||02/09/2020||Nguyen, Tuan||Labor||Regular Pay||2:00|
|Karen Marks||02/09/2020||Links, John||Labor||Regular Pay||1:25|
|Kathy Linklater||02/09/2020||Links, John||Labor||Regular Pay||1:25|
|Johnny Deep||02/09/2020||Links, John||Labor||Regular Pay||2:00|
Thank you so much! I've been trying to get this info for a month. We are currently using Desktop Pro. I can't find where I would import Payroll data. I can only find where to import lists under the File Tab- Utilities. Am I in the wrong place?
Thanks for posting your concern here in the Community, @jillirwin. I’ll provide some information about your concern when importing your files in QuickBooks Desktop.
In the meantime, we’re unable to import payroll data into QuickBooks Desktop Pro.
If you don’t have payroll on your account, you can enter them on your Journal Entry. If you have payroll on your Journal Entry, you can import it into QuickBooks.
As a workaround, you’ll want to consider looking for a 3rd party app from QuickBooks Apps. From there, you can compare their features and choose which one best suits your needs.
On the other hand, you can import lists and transactions using the Intuit Interchange Format (IIF) files. Here’s an article for the steps-by-step process: Export, import, and edit IIF files.
If you’d like to export payroll data from QuickBooks, you can use the Summarize Payroll Data in Excel report. Check out this article for the more details: Export payroll data.
Please let me know if you have additional questions or concerns about your payroll data. I’ll be around to assist you further.
Utilize the importer tool and the template I mentioned earlier. You can also use the same tool to import JE and many other transactions types into QBD Pro. You will purchase the one time license of it.