Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Simplify payday and set payroll to run automatically on QuickBooks. Explore QuickBooks Payroll
tim-wells-njsnet
Level 1

Is there an option to upload/import a CSV file of our employee timesheets to QB for a quicker entry method of employee hours? We use QB Online

 
2 Comments 2
4Gal
Level 11

Is there an option to upload/import a CSV file of our employee timesheets to QB for a quicker entry method of employee hours? We use QB Online

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

 

Shania_C
QuickBooks Team

Is there an option to upload/import a CSV file of our employee timesheets to QB for a quicker entry method of employee hours? We use QB Online

Welcome to the Community, @Tim-wells.

 

As of the moment, the ability to upload/import a CSV file of an employee's timesheet for a quicker entry method of employee hours to QuickBooks is not yet available; however, you can follow @4Gal's recommended Time Activities data template.

 

Additionally, you can use a third-party application to import CSV files into QuickBooks Online. This way, you can handle each task and ensure the data is sent exactly where it needs to go. Check out this link: https://quickbooks.intuit.com/app/apps/home/.

 

Moreover, I'll be providing an article that you can use to help your future work: Create and run your payroll.

 

I'm always here to help with any concerns you have regarding your employee timesheets. Please click the Reply button below or make a new post in the Community if you need further assistance. Take care!

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

Need to get in touch?

Contact us