Skip to main content
December 6, 2023
Question

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

  • December 6, 2023
  • 2 replies
  • 0 views
Original commenter did not share additional details

2 replies

December 6, 2023

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

 

December 6, 2023

Welcome to the Community, @Tim11_2-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!