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.

Forum|Forum|6 years ago
February 17, 2020
3 replies
66 views

No text available

QuickBooks Online

Fiat Lux - ASIA

Level 14

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

TxnDate

Name

Time

StartTime

EndTime

Description

BillableStatus

Customer

ServiceItem

HourlyRate

Taxable

Class

Location

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

M

MaryAnn_E

Level 4

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

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.

Morgan_B

QuickBooks Team

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

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!

Morgan_B

QuickBooks Team

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

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.

Sign up

Login with SSO

Let's get you signed in

Login with SSO