Import CSV time sheets into Quickbooks online.

dan543 · ‎May 18, 2021

The recent changes with intuit payroll and tsheets have killed some basic functionality we need for time tracking, so i am looking for another time tracking solution. I found one that doesn't integrate with QBO but can produce a CSV export of a timesheet.

How can I import a timesheet into quickbooks online?

LieraMarie_A · ‎May 18, 2021

Thanks for sharing your concern with us, @dan543.

I'd suggest using an importer tool to upload your timesheets into QuickBooks Online. QuickBooks supports various third-party applications for any functionality you may need. To see if there's an app that can help you accomplish this, head to the Intuit App Center. Then, type a keyword in the search bar.

You can follow these steps:

On the left panel, click Apps.
Go to the Find Apps tab.
Use the search bar to look for an app.

Refer to these articles for more info:

Lastly, I'd like to let you know that our developers are constantly uncovering and considering new ways to improve the program. To be updated with our latest news and enhancements, you can visit our QuickBooks Online Blog.

Stay in touch if you have any other questions or concerns. I’ll be right here to answer them for you. Enjoy the rest of the day.

View solution in original post

Fiat Lux - ASIA · ‎May 18, 2021

What kind of business do you run? There are some 3rd party time tracker app supporting QBO.

If the app doesn't support QBO, you may prepare the Time Activity data with the following template

TxnDate

Name

Time

StartTime

EndTime

Description

BillableStatus

Customer

ServiceItem

HourlyRate

Taxable

Class

Location

01/10/2020

Mike's Traders

5

Sample Time Activity using hours and decimal

Janice Johnson

Hours

01/10/2020

Eagle Outfitters

4.5

Sample Time Activity using hours only

Janice Johnson

Hours

01/10/2020

Mary Smith

0.5

Sample Time Activity using hours and minutes

Billable

Janice Johnson

ENG Svs:120

75

FALSE

then utilize an importer tool.

https:// transactionpro.grsm.io/qbo

LieraMarie_A · ‎May 18, 2021

Thanks for sharing your concern with us, @dan543.

I'd suggest using an importer tool to upload your timesheets into QuickBooks Online. QuickBooks supports various third-party applications for any functionality you may need. To see if there's an app that can help you accomplish this, head to the Intuit App Center. Then, type a keyword in the search bar.

You can follow these steps:

On the left panel, click Apps.
Go to the Find Apps tab.
Use the search bar to look for an app.

Refer to these articles for more info:

Lastly, I'd like to let you know that our developers are constantly uncovering and considering new ways to improve the program. To be updated with our latest news and enhancements, you can visit our QuickBooks Online Blog.

Stay in touch if you have any other questions or concerns. I’ll be right here to answer them for you. Enjoy the rest of the day.

Topics

Training

Community

Resources

Import CSV time sheets into Quickbooks online.