Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
srosselle
Level 1

Payroll Import Template for Quickbooks Online

I am trying to see if it is possible to import payroll hours to Quickbooks Online, and see what the template for that looks like.  I have the ability to export payroll hours from a 3rd party system, but I am not sure how to match up the columns/formatting.  Is there a template file that I should use?  And from the help menu, it seems like I have to have Quickbooks Advanced Payroll in order for that import feature to be enabled?

2 Comments 2
LollyNino_C
QuickBooks Team

Payroll Import Template for Quickbooks Online

Thanks for posting your concern here in the Community, @srosselle. We'd be glad to provide some information about your concern when importing payroll hours to QuickBooks Online (QBO).

 

Currently, there's no feature for importing hours from third-party providers to QuickBooks Online. However, we can look for a third-party application where you can import hours from a third-party app into QuickBooks Online (QBO). If you need to use one, we suggest a third-party application and navigate for an app in the QuickBooks Online App Center.

 

Here's how:

 

  1. From the left menu, click Apps.
  2. Select the Find Apps tab.
  3. Enter a brief description of the feature in the Search for an App box. 
  4. If there's a list of selections, choose the app you want to integrate, then click Get the app now to connect. 

 

QuickBooks also provides integration with several applications, allowing users to efficiently manage their data. If your tracking app is supported, you can directly connect it to QuickBooks, enabling automatic syncing of your employees' hours.

 

I've included this guide to help you learn more about managing employees' records in the program: Manage workers and employees. It contains everything you need to ensure accuracy in your payroll records.

 

I've added some resources with more insights for future reference in importing data in QuickBooks Online:

 

 

If you have any other questions or anything else besides importing hours to QBO, feel free to add them to your reply below. We're always here to assist you and ensure your business runs smoothly. Have a great day!

4Gal
Level 11

Payroll Import Template for Quickbooks Online

@srosselle 

You can 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 use an importer tool to proceed

https://get.transactionpro.com/qbo

 

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us