Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
K
kenbrown1010
February 9, 2024
Question

sample manual time import.csv

  • February 9, 2024
  • 2 replies
  • 9 views

Where can I find the sample manual time import.csv that is referred to for importing time into timesheets?

2 replies

Bryan_M
Bryan_MQuickBooks Team
QuickBooks Team
February 9, 2024

Welcome to the Community space, @kenbrown1010.

 

Let me share insights and help you download the sample manual time import.csv.

 

To access the sample manual time import.csv, you'll need the Manual Time Import option in the Feature Add-ons in QuickBooks Time (QB Time). And to do this you'll need to reach out to support to get it added.  

 

Here's how:

 

  1. Sign in to your QuickBooks account.
  2. Select the Help (?) icon.
  3. Scroll down to select the Contact Us button and follow the prompts.
  4. You will be able to request a callback or start a live chat with an expert.

 

Once you already have the option, you can follow the steps here to import time through a CSV file: Export or import time data in QuickBooks Time.

 

You might want to get answers to common questions about QB Time and QuickBooks Desktop (QBDT) integration: QuickBooks Time and QuickBooks Desktop integration FAQ.

 

Click the reply button below if you have additional questions about importing time. I'll be willing to lend a hand. Have a good one.

    J
    jbraddock
    January 22, 2025

    Using the Punch Time Import OR Manual Time Import tool in QBTime, I am having an issue using a custom field for service item. Even after confirming the service item is in QBO and QB Time, when using the tool it states the below. I have tried changing the column header, renaming the service item, adjusting the template provided.

    Has anyone had success importing service items into QB Time with the Punch Time Import OR Manual Time Import tool? If so, what was the fix? I even tried w/ QB Time support w/ tier 2 and tier 3 w/ no luck. 

     

    Line 2: Oops! There is no custom field called:Panel Installation Time, please correct and try again.

     

    Thanks,
    Joel

    4
    4Gal
    Level 5
    February 10, 2024

    @kenbrown1010 

    Do you have QB Desktop? You can prepare 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 use an importer tool to proceed. It's $199 one time license.

    https://get.transactionpro.com/qbd

     

     

     

    K
    kenbrown1010Author
    February 10, 2024

    Thanks for the info. For the time being, yes, just QB Desktop. I just need the actual sample time import csv file. I'm a software developer, so no need for me to purchase anything 🙂 Not sure why QB does not have this sample readily available and that I have to contact QB Support to get the sample.

    Need QuickBooks guidance?
    Log in to access expert advice and community support instantly.
    Terms & ConditionsAccessibility statement