cancel
Showing results for 
Search instead for 
Did you mean: 
Thequestionmaster20
Level 1

Import timesheet as a CSV file

Hey,

 

I am using different software to track my employee's hours.

The hours are saved in a CSV file.

Does QB desktop support CSV files? Can I upload a CSV file and have the data transferred or I need to convert the file to IIF?

 

Thanks for the help

 

2 Comments 2
Fiat Lux - ASIA
Level 15

Import timesheet as a CSV file

Prepare your Time Tracking data with the following template

NameTransaction DateCustomerService ItemPayroll itemDurationClassBillableNotes
John Marks01/09/2020Nguyen, TuanLaborRegular Pay1:25   
John Smith02/09/2020Nguyen, TuanLaborRegular Pay2:00   
Karen Marks02/09/2020Links, JohnLaborRegular Pay1:25   
Kathy Linklater02/09/2020Links, JohnLaborRegular Pay1:25   
Johnny Deep02/09/2020Links, JohnLaborRegular Pay2:00   

 

then utilize one of these importer tools

https://transactionpro.grsm.io/qbd

https://partners.saasant.com/affiliate/idevaffiliate.php?id=5051_2

 

FritzF
Moderator

Import timesheet as a CSV file

Hi there, @Thequestionmaster20.

 

I'm here to share information about importing CSV files in QuickBooks Desktop (QBDT).

 

With the help of QuickBooks Import Excel and CSV toolkit, yes, you can import CSV files in QBDT. However, you can only import lists and transactions (same with importing IIF files). The option to import your employee hours timesheet is currently unavailable.

 

To learn more about exporting and importing data in QBDT, you can check out these articles:

 

 

In the meantime, you can look for a third-party application that will allow you to import your employee hours timesheet to QBDT. Here's how:

 

  1. Go to this link: https://desktop.apps.com/home.
  2. Look for an Import app in the search bar.

 

For more tips and other resources, I recommend visiting our website for future reference: Self-help articles.

 

Please let me know if you have more questions about this or anything else QuickBooks. I'm always here to help. Keep safe.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us