cancel
Showing results for 
Search instead for 
Did you mean: 
jillirwin
Level 1

How do you import hours into QBO

Is it possible to import employees hours into QBO from a 3rd party tracking app?
7 Comments 7
MadelynC
Moderator

How do you import hours into QBO

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.

 

Here’s how:

 

  1. Log in to your QBO account.
  2. Go to your Apps menu.
  3. You can enter “Importer” on the Search field, then select the app.
  4. Click the Overview, Pricing, Reviews, and FAQs to view the details.
  5. Select Get app now.


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!

Fiat Lux - ASIA
Level 15

How do you import hours into QBO

@jillirwin 

Prepare your Time Activities data with the following template

TxnDateNameTimeStartTimeEndTimeDescriptionBillableStatusCustomerServiceItemHourlyRateTaxableClassLocation
01/10/2020Mike's Traders5  Sample Time Activity using hours and decimal Janice JohnsonHours    
01/10/2020Eagle Outfitters4.5  Sample Time Activity using hours only Janice JohnsonHours    
01/10/2020Mary Smith0.5  Sample Time Activity using hours and minutesBillableJanice JohnsonENG Svs:12075FALSE  

 

then utilize an importer tool

https://transactionpro.grsm.io/qbo

 

jillirwin
Level 1

How do you import hours into QBO

Would this be the same in Desktop Pro? or Enterprise?

Fiat Lux - ASIA
Level 15

How do you import hours into QBO

@jillirwin 

You need to prepare with a different template for QB Desktop

NameTransaction DateCustomerService ItemPayroll itemDurationClassBillableNotes
John Marks01/09/2020Nguyen, TuanLaborRegular Pay1:25   
John Smith02/09/2020Nguyen, TuanLaborRegular Pay2:00   
Karen Marks02/09/2020Links, JohnLaborRegular Pay1:25   
Kathy Linklater02/09/2020Links, JohnLaborRegular Pay1:25   
Johnny Deep02/09/2020Links, JohnLaborRegular Pay2:00   

 

jillirwin
Level 1

How do you import hours into QBO

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?

JamaicaA
QuickBooks Team

How do you import hours into QBO

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. 

Fiat Lux - ASIA
Level 15

How do you import hours into QBO

@jillirwin 

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.

Need to get in touch?

Contact us