Skip to main content
July 19, 2024
Question

How do you import time card data (exel spreadsheet) into Quickbooks Online?

  • July 19, 2024
  • 2 replies
  • 0 views
Original commenter did not share additional details

2 replies

July 19, 2024

Hello jonathan-c3darla,

 

Welcome to Community!  At this time, the option to import timesheets in QuickBooks Online, is unavailable. However, you can review third party apps 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.

 

I can understand the time saving benefit of being able to import timecard data, and recommend submitting a suggestion to our Development Team. Recommendations are greatly appreciated in assisting us with improving your overall customer experience with QuickBooks Online.

 

If you have any other questions, feel free to reach back out. We would be glad to help!

July 20, 2024

@jonathan-c3darla 

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