cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Created with Sketch. Learn about the Paycheck Protection Program application with QuickBooks. Start now.
Level 1

How do I import employee hours from a 3rd party timekeeping system? We use ZipClock to gather the employee hours, and that data is available to export in Altametrics.

 
14 Comments
Highlighted
Level 6

How do I import employee hours from a 3rd party timekeeping system? We use ZipClock to gather the employee hours, and that data is available to export in Altametrics.

Utilize the importer tool

https://transactionpro.grsm.io/qbo

https://partners.saasant.com/affiliate/idevaffiliate.php?id=5051_2

 

The template to be imported should be like this

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  
Highlighted
Content Leader

How do I import employee hours from a 3rd party timekeeping system? We use ZipClock to gather the employee hours, and that data is available to export in Altametrics.

Hello, tom1.

 

Thanks for reaching out here in the Community. I'd be glad to help point you in the right direction so you're able to import your employee hours.

 

Fiat Lux - ASIA provided a great option to consider for importing data. If you'd like to explore additional resources to help get this job done, I recommend checking the available third-party apps. These apps integrate directly with your QuickBooks Online account to make your work easier. You can find apps here: https://apps.intuit.com/app/apps/home

 

Feel free to reach back out here if you have any other questions or concerns.

Highlighted
Level 1

How do I import employee hours from a 3rd party timekeeping system? We use ZipClock to gather the employee hours, and that data is available to export in Altametrics.

Must I purchase a 3rd party tool to execute the import?  I can manipulate an Excel/CSV file to get it into the proper format, if I knew what the format should be.  Does QB Online have an import process that a user can access and execute for timekeeping data?  We are committed by our franchisor to using ZipClock so I cannot consider switching to one of the other 3rd party timekeeping apps listed in the link.  

 

Thanks!

Highlighted
Content Leader

How do I import employee hours from a 3rd party timekeeping system? We use ZipClock to gather the employee hours, and that data is available to export in Altametrics.

Thanks for that additional info, tom1.

 

The groups that can be imported into QuickBooks Online via Excel or CSV are bank data, customers, vendors, Chart of Accounts, products and services, and invoices.

 

I can see how having the ability to import employee hours would be useful. I'll do my part and pass your feedback along to the Product Development Team. Many software updates come directly from great user suggestions like yours. You can find out more about these types of updates by viewing our blog.

 

I'll be here if you need assistance with anything else.

Highlighted
Level 1

How do I import employee hours from a 3rd party timekeeping system? We use ZipClock to gather the employee hours, and that data is available to export in Altametrics.

Thanks for your help Morgan.  It would appear from your list that timekeeping data is not one of the data types that can be imported into QBO PR directly by a user of QBO.  But there are 3rd party tools, available at an additional cost of course, that can import timekeeping data?  Both Saasant and Transaction Pro reference "time activities" as something they can import.  Is that the same as timekeeping data?  I suppose it could refer to billing time (IE. a lawyers office) so I want to make sure payroll data can be imported and used for our payroll runs, as opposed to manually keying in hours.  Thanks again for your continued assistance!

Highlighted
QuickBooks Team

How do I import employee hours from a 3rd party timekeeping system? We use ZipClock to gather the employee hours, and that data is available to export in Altametrics.

 Hi there, @tom1.

 

You can check our App Center and find an app that lets your employees do timestamp and timesheet.

 

The App Center has all kinds of third-party applications to choose from. Get a better comparison of these apps and see if one of them meets your needs.

 

Also, there’s available login in QuickBooks Online where employees can timestamp instead of them manually creating the timesheet.

 

To view the applications, go to the Apps menu at the left panel of your QuickBooks Online or go to https://appcenter.intuit.com/.

 

 

Please leave a comment below if there’s anything else I could help. Have a good day.

 

Highlighted
Level 1

How do I import employee hours from a 3rd party timekeeping system? We use ZipClock to gather the employee hours, and that data is available to export in Altametrics.

Hi MaryAnn,

Our timekeeping solution is already chosen by our franchisor, so we need to continue using ZipClock.  Now I just need to get the hours from ZipClock, by pay period, into QBO PR so I don't have to re-key them every time I want to run a payroll.  

Highlighted
Level 6

How do I import employee hours from a 3rd party timekeeping system? We use ZipClock to gather the employee hours, and that data is available to export in Altametrics.

@tom1 

Unfortunately ZipClock does not support QB yet. Should you need to import the data in bulk to your QBO, you don't have any other option but using an importer tool as I have mentioned earlier.

 

Hope it helps.

Highlighted
Level 1

How do I import employee hours from a 3rd party timekeeping system? We use ZipClock to gather the employee hours, and that data is available to export in Altametrics.

Morgan,

 

I want to reinforce how important it is that QB Online add this functionality. We shouldn't need a 3rd party app to import hours data. Please ask development teams to make this a priority. I'm running Harvest and need an easier way to import the data. 

 

thanks!

Highlighted
Level 6

How do I import employee hours from a 3rd party timekeeping system? We use ZipClock to gather the employee hours, and that data is available to export in Altametrics.

@mission-minded-Zach 

Company has their own feature to automate the time tracking (i.e TSheets). The 3rd party importer tool is the only solution for now.

Highlighted
Level 1

How do I import employee hours from a 3rd party timekeeping system? We use ZipClock to gather the employee hours, and that data is available to export in Altametrics.

This makes me so mad that I'm looking at other options than Quickbooks. TSheets is a terrible product with a lousy UI. Intuit's attempts to force users to only be able to use their proprietary tools is wrong. This is a product decision that should be reconsidered immediately. 

Highlighted
Level 6

How do I import employee hours from a 3rd party timekeeping system? We use ZipClock to gather the employee hours, and that data is available to export in Altametrics.

@mission-minded-Zach 

There are a few time tracking apps in the market supporting QBO. You don't need other 3rd party importer tool. Explore one of them:

https://buddypunch.grsm.io/quickbooks

 

 

Highlighted
Level 1

How do I import employee hours from a 3rd party timekeeping system? We use ZipClock to gather the employee hours, and that data is available to export in Altametrics.

I am using the trial version of Transaction Pro and it appears that there is no way to import timekeeping data.  Both TP and Saasant can import "Time Activites" but these appear to require a customer code which is not applicable to basic employee punch in/out activities.  So it would appear that while I have been able to use Zip Clock to move off of paper timecards (again, I have no option to use another timekeeping application) I cannot move that data electronically into QBO payroll.  Can you please confirm that there is no import method for this type of data?  And if so, can you please stress to the development team on how this type of data would be key to improving the functionality of QBO.  When I did my research of the various payroll platforms, I was told there was a method to import timekeeping data.  But it appears I was misled.  Thanks for any clarity and priority you can provide!

Highlighted
Level 1

How do I import employee hours from a 3rd party timekeeping system? We use ZipClock to gather the employee hours, and that data is available to export in Altametrics.

I have to agree with Mission-minded Zach!  There should be a method to import basic timekeeping data.  The 3rd party tools Transaction Pro and Saasant do not have a template for this type of data.  What kind of payroll system has no way to import hours for the next payroll?  I know there are some apps that do integrate with QBO, but I cannot change my app as that is required and provided by the franchisor.  I suppose I could change my payroll processing system to one that allows a basic import of hours worked by an employee.

Need to get in touch?

Contact us