Skip to main content
T
tom1
February 17, 2020
Question

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.

  • February 17, 2020
  • 3 replies
  • 0 views
Original commenter did not share additional details

3 replies

Fiat Lux - ASIA
Fiat Lux - ASIA
February 17, 2020

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  
M
MaryAnn_E
February 18, 2020

 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.

 

T
tom1Author
February 18, 2020

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.  

MorganB
MorganB
February 17, 2020

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.

T
tom1Author
February 17, 2020

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!

MorganB
MorganB
February 17, 2020

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.

S
sonya70
March 27, 2021

kinda furious. i just upgraded to qb pro services desktop a couple months ago. my new book keeper is not making change to online. so first of all i got pretty much no credit for the money i just spent on pro. SECOND....the import of csv or timer activities was an integral part of desktop pro services...NOW I FIND OUT I CAN'T DO THIS WITHOUT PAYING ANOTHER SERVICE?????????

I wish i could leave QB, but you guys have us by the you know what. 

    Terms & ConditionsAccessibility statement