Skip to main content
January 26, 2022
Question

How can I import timesheet csv files in QBO or QB Time?

  • January 26, 2022
  • 2 replies
  • 0 views

How can I import timesheet csv files in QBO or QB Time? It is possible to import invoices, but I don't find the way to import timesheets. 

2 replies

January 27, 2022

Hi SergioM,

 

Welcome back to the Community! QuickBooks Online offers the flexibility you need in order to manage your business and stay on top of your transactions. I'll be glad to provide more information about importing transactions you can get back to doing what you love. 

 

Based on the information you've shared, I highly recommend you to check out the following article that shows you how to: Import/export CSV files.

 

The article shows you how to import your files to your account. I encourage you to check it out and let me know if you have questions as you go through the article. It's also important to note that you can only import the following: 

  • Bank Data
  • Customers
  • Suppliers
  • Chart of Accounts
  • Products and Services
  • Invoices
  • Bills
  • Journal Entries

Here's another helpful article with more info on common questions about importing data to QuickBooks Online. Feel free to ask other questions. I've got your back in case you need anything else. 

Fiat Lux - ASIA
January 27, 2022

@SergioM 

Prepare the 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 utilize an importer tool

https://transactionpro.grsm.io/qbo