Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
July 19, 2024
Question

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

  • July 19, 2024
  • 2 replies
  • 1 view
No text available

2 replies

QuickBooks Team
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!

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