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
erin-elevatehome
Level 1

How can I import timesheets from a CSV file into quickbooks?

 
2 Comments 2
Adrian_A
Moderator

How can I import timesheets from a CSV file into quickbooks?

Hi Erin,

 

I'm here to help how you can import timesheets into your QuickBooks Online account.

 

As of now, the option to import timesheets is unavailable. However, you can look for an application that can help you achieve this goal.

 

While I'm unable to recommend an app, you can go to our Apps page and explore our supported applications. Here's how:

 

  1. Go to Apps and select Find apps.
  2. Search for a keyword in the search bar and press Enter.
  3. Select an app and click Get app now to integrate.

 

Furthermore, you can save time running payroll each payday with auto payroll. This way, payday is one less thing to remember in your hectic schedule. It also works if you pay your employees by paper check or direct deposit.

 

I'm always around whenever you have concerns about keeping track of your employee's time.

Fiat Lux - ASIA
Level 15

How can I import timesheets from a CSV file into quickbooks?

@erin-elevatehome 

Prepare your 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

 

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

Need to get in touch?

Contact us