Utilize the importer tool
The template to be imported should be like this
|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|
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.
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 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.
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!
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.
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.
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.
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.
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.
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!
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.