How to Import Time Activities into QuickBooks Online?

Accurate time tracking plays a central role in managing payroll, billing, and project profitability. In QuickBooks Online, time activities refer to recorded work hours linked to employees, vendors, customers, or specific services. Businesses use these entries to generate invoices, calculate wages, and analyze productivity across projects.

However, manually entering large volumes of time data can introduce errors and consume valuable resources. In this guide, we’ll discuss prerequisites for import, file preparation, manual and automated import methods, common errors, and best practices to ensure a smooth and accurate time activity import process.

Prerequisites for a Successful Time Activity Import

Before importing time activities into QuickBooks Online, make sure your system and data are properly set up. A few key configurations can prevent most import errors and ensure accurate results.

Enabling Time Tracking in QuickBooks Online Settings

Turn on time tracking under Settings > Time Tracking so QuickBooks can process and use imported entries for billing and payroll.

Setting Up Employees and Vendors in the Payroll Center

Create all employees and vendors in advance, and ensure their names exactly match your import file to avoid reference errors.

Configuring Service Items and Customer Projects

Set up service items and link them to customers or projects to ensure proper tracking and reporting of time data.

Ensuring Proper Administrative Permissions

Use an admin or accountant account to access import features and complete the process without restrictions.

Preparing Your Time Activity File for Import

A well-structured file ensures a smooth import into QuickBooks Online. Clean, consistent data reduces errors and simplifies field mapping during the process.

Supported File Formats: Excel vs. CSV

You can use Excel (.xls, .xlsx) or CSV files, but CSV is more reliable since it avoids hidden formatting issues and ensures consistent data parsing.

Standardizing Data: Date, Name, and Duration

Keep all entries uniform by:

• Using a consistent date format
• Matching employee/vendor names exactly with QuickBooks
• Maintaining a single format for duration values

Handling Time Formats: Decimal Hours vs. HH:MM

QuickBooks accepts both decimal hours (e.g., 1.5) and time format (1:30). Choose one format and apply it across the entire file to avoid conflicts.

Mapping Billable Status and Hourly Rates

Include clear values for billable status (Yes/No) and hourly rates where applicable. Proper mapping ensures accurate invoicing and payroll calculations after import.

What are the Steps to Manually Import Time Activities into QuickBooks Online?

Importing time data into QuickBooks Time requires a structured approach to ensure accuracy and prevent errors, and following a step-by-step process helps you validate, upload, and finalize your data with confidence.

Method 1: Manual Import Using Native QuickBooks Online

You can import time data directly through QuickBooks Time by following a guided process. Each step ensures your file is correctly formatted and validated before final import.

Step 1: Access Feature Add-ons

This step helps you locate the import options within the platform. Here are the steps to access Feature Add-ons:

• Open QuickBooks Online and go to the Time tab on the left navigation bar.
• Select Time Entries and then click “Go to classic QuickBooks Time” (the import add-on lives here).
• On the left-side menu, click Feature Add-ons.
• Select either Punch Time Import or Manual Time Import based on your requirement

Step 2: Review Data Requirements

Before importing, you need to confirm that your data follows the correct structure.
Here are the steps to review your data:

• Go to the Help tab
• Check formatting guidelines and required fields
• Ensure your data aligns with QuickBooks Time standards

Step 3: Prepare Your CSV File

This step ensures your file is properly formatted for import. Here are the steps to prepare your file:

• Download the sample manual time import.csv file as a reference
• Add or adjust your data according to the sample format
• Save the file in CSV format once completed

Step 4: Upload Your CSV File

Now you will upload your prepared file into the system. Here are the steps to upload your file:

• Go to the Import tab
• Click Browse…
• Select your saved CSV file

Step 5: Choose Import Preferences

This step defines how your data will be handled during import. Here are the steps to set preferences:

• Select Append to add new data or Replace to overwrite existing data
• Check the box for Test Mode to run a trial import

Step 6: Finalize the Import

After resolving errors, you can proceed with the actual import. Here are the steps to complete the process:

• Re-upload the corrected CSV file
• Ensure Test Mode is unchecked
• Click Import to complete the process

Method 2: High-Volume Import Using Dancing Numbers

Using Dancing Numbers simplifies bulk imports of time tracking activities into QuickBooks Online by automating mapping and reducing manual effort. Follow these structured steps to complete the process efficiently.

Step 1: Connect Dancing Numbers to QBO

• Access the Dancing Numbers Online and log in with your credentials.
• Select the Connect to QuickBooks option. You will be redirected to the Intuit login page to authorize the app.
• If you manage multiple businesses, select the specific QuickBooks Online company file you want to work with.

Step 2: Start the Import Process

• On the main dashboard, locate and click the Import button.
• From the list of available QuickBooks entities (like Invoices, Expenses, etc.), select Time Activity.

Step 3: Upload Your File

• Click Select File to browse your computer for the Excel (XLS/XLSX) or CSV file containing your time entries.
• Once the file is uploaded, select the specific Sheet (if using Excel) that contains the data.
• Choose the correct sheet from the file

Step 4: Select Time Tracking Options

It ensures your data is mapped to the correct QuickBooks module. Here’s how to configure time tracking selection:

• Under Select Excel sheet to use, choose Time Tracking.
• On the right side, under Select a QuickBooks transaction or list, select Time Tracking.
• Click Next, then confirm the prompt by clicking OK

Step 4: Preview Your File Data

Before mapping, review your uploaded data for accuracy. Here are the steps to verify your file:

• Check the file preview screen
• Ensure all rows and columns display correctly
• Click Next to proceed

Step 5: Map Fields

This step links your file columns with QuickBooks fields. Here’s how to map your data:

• Use dropdowns to manually match each field
• Or click Field Match for automatic mapping
• Click Save As to store your mapping template
• Use Load Map in the future for quicker imports
• Click Next

Step 6: Confirm File Update

You will now proceed with updating the data in the system. Here are the steps to confirm the update:

• Review the file update screen
• Click Next in the bottom-right corner

Step 7: Handle Missing References

It helps identify any missing or unmatched data. Here’s how to resolve missing fields:

• Review the Missing Reference section
• Check for incomplete or unmatched entries
• Make corrections if needed

Step 8: Import the File

Now you are ready to complete the import process. Here are the steps to import your data:

• Click on Import File
• Confirm the prompt by clicking OK

Step 9: Complete the Import

• Once the data looks clean and error-free, click Import (or Finish).
• A progress bar will appear. Once finished, a confirmation message will display the total number of records successfully imported.

Preventive Tips to Avoid Data Corruption

Applying a few preventive checks before importing into QuickBooks Online can significantly reduce errors and ensure clean, reliable data.

Validating Data Consistency Before Execution

Review your file for missing values, incorrect formats, and mismatched names to avoid import failures and mapping issues.

Running a Trial Import for Large Datasets

Test a small portion of your data first to catch errors early and verify that mapping and formatting work as expected.

Maintaining a Master Backup of Your Company File

Always keep an updated backup so you can quickly restore your data if something goes wrong during the import.

Standardizing Entry Descriptions for Cleaner Reporting

Use consistent labels and descriptions across entries to improve report accuracy and make data easier to analyze.

Similar Errors Related to Time Activity Imports

When importing time activities into QuickBooks Online, you may encounter common errors that can interrupt the process or affect data accuracy. Understanding these issues helps you resolve them quickly and maintain clean records.

Resolving QuickBooks Error Code PS038

This error usually appears due to stuck or unprocessed payroll transactions. To fix it, update your payroll data, locate pending transactions, and ensure they are properly processed before attempting the import again.

Fixing “Invalid Reference ID” and “Entity Not Found”

These errors occur when referenced names, such as employees, vendors, or customers, do not exist or do not match exactly in QuickBooks. Verify that all entities are pre-created and ensure your file uses identical naming conventions.

Managing Duplicate Entry and Overlap Conflicts

Duplicate or overlapping time entries can lead to inaccurate reporting and billing issues. Review your data beforehand, remove duplicates, and ensure that time logs for the same resource do not conflict within the same time range.

Handling “Date Out of Range” Warnings

This warning appears when dates fall outside the allowed accounting period or into closed books. Check your company’s fiscal settings and ensure all dates in your file are valid and within an open reporting period.

Conclusion

Importing time activities into QuickBooks Online becomes far more efficient when you follow a structured approach, from preparation to validation. Accurate time imports ensure that payroll calculations and invoicing processes run smoothly, helping you save time, improve billing accuracy, and gain better visibility into project costs. Before completing your import, confirm that time tracking is enabled, all entities are correctly set up, your file is properly formatted, mappings are accurate, and a test run has been performed to catch any potential errors.

---

Frequently Asked Questions