Importing Data into QuickBooks

Import Wizard Overview

PrimeConnect's import wizard is a guided, multi-step process that takes you from a raw spreadsheet file to fully imported QuickBooks records. The wizard is designed to catch errors before they reach QuickBooks, saving you time and preventing data quality issues.

The import wizard consists of six steps:

1. Choose Entity Type — select what kind of QuickBooks record you are importing (e.g., Invoices, Customers, Journal Entries).
2. Upload Your File — drag and drop or browse to select your Excel or CSV file.
3. Map Fields — match your spreadsheet columns to QuickBooks fields, with automatic fuzzy matching.
4. Handle Missing References — resolve any customers, items, accounts, or other references that do not yet exist in QuickBooks.
5. Validate Data — PrimeConnect checks every row for errors, invalid formats, and missing required fields.
6. Preview & Import — review your data one final time and execute the import.

You can navigate back and forth between steps without losing your work. The wizard preserves your mapping selections, file data, and validation state throughout the session.

Supported File Formats

PrimeConnect accepts the following file formats for import:

Need to convert your file format? Try our free accounting tools to transform files between formats. For example, you can convert CSV files to IIF format for QuickBooks Desktop import, or convert Excel files to CSV if your workflow requires it.

For detailed guidance on preparing your files, including column naming conventions, date formatting, and encoding, see the Sample Import Files & Templates article.

Step 1: Choose Entity Type

The first step is to tell PrimeConnect what kind of QuickBooks record you want to import. Entity types are organized into two categories:

Lists (master records)

Lists are the foundational records in QuickBooks — the things that transactions reference. These include:

• Accounts — Chart of Accounts entries (Bank, Income, Expense, etc.)
• Items — Products and services (Service, Inventory Part, Non-Inventory Part, etc.)
• Customers — Customer and job records
• Vendors — Vendor/supplier records
• Employees — Employee records
• Classes — Class tracking categories
• And more — Sales Reps, Payment Methods, Ship Methods, Terms, Price Levels, etc.

Transactions

Transactions are the day-to-day financial records that reference list items. These include:

• Invoices — Sales invoices with line items
• Bills — Vendor bills/payables
• Journal Entries — General journal debits and credits
• Sales Receipts — Point-of-sale transactions
• Credit Memos — Customer credit memos
• Estimates — Quotes and proposals
• Purchase Orders — Vendor purchase orders
• And many more — Checks, Deposits, Transfers, Receive Payments, Sales Orders, Credit Card Charges, etc.

For a complete list of all 40+ supported entity types and which operations each supports, see Supported QuickBooks Entity Types.

Step 2: Upload Your File

Once you have selected an entity type, the next step is to provide your data file.

Uploading

You can provide your file in two ways:

• Drag and drop — drag your Excel or CSV file directly onto the upload area in PrimeConnect.
• Browse — click the upload area to open a file picker dialog and navigate to your file.

What happens after upload

PrimeConnect immediately parses your file and performs several checks:

1. File format validation — confirms the file is a valid Excel or CSV file.
2. Header detection — reads the first row of your spreadsheet as column headers. These headers are used for automatic field matching in the next step.
3. Row count — counts the total number of data rows (excluding the header) and displays the count so you can verify the file was read correctly.
4. Data preview — shows a preview of the first several rows so you can confirm the data looks correct.

Step 3: Map Fields

Field mapping is where you tell PrimeConnect which column in your spreadsheet corresponds to which field in QuickBooks. This is a critical step — correct mapping ensures your data ends up in the right places.

Automatic matching

PrimeConnect uses fuzzy matching to automatically map your column headers to QuickBooks field names. For example:

• "Invoice Number" or "Inv #" maps to RefNumber
• "Customer Name" or "Customer" maps to CustomerRef
• "Amount" or "Total" maps to the appropriate amount field
• "Date" or "Invoice Date" maps to TxnDate

Auto-matched columns are shown with a green checkmark. Columns that could not be auto-matched will have an empty dropdown, allowing you to select the correct field manually.

Manual mapping

For columns that were not automatically matched, click the dropdown next to the column header and select the appropriate QuickBooks field from the list. The dropdown includes a search/filter input at the top so you can quickly find the field you need.

Required fields

Required fields are marked with an asterisk (*). The import cannot proceed until all required fields are mapped. Which fields are required depends on the entity type — for example, Invoices require CustomerRef and at least one line item, while Customers only require a Name.

Saving and loading templates

If you import the same type of file regularly, you can save your mapping configuration as a template and load it later to skip the manual mapping step entirely. For detailed instructions, see the Field Mapping & Saved Templates article.

Step 4: Handle Missing References

When your import data references other QuickBooks records — customers, items, accounts, vendors, etc. — PrimeConnect checks whether those records already exist in QuickBooks. Any references that cannot be found are flagged as "missing references."

For example, if you are importing invoices and one row references a customer named "Acme Corp" but no customer with that name exists in your QuickBooks file, it will appear as a missing reference.

Resolution options

You have two options for handling missing references:

• Auto-create — PrimeConnect can automatically create the missing records in QuickBooks during the import. This is the fastest option and is controlled by toggles in Settings.
• Manual resolution — Go into QuickBooks, create the missing records yourself with the exact data you want, then return to PrimeConnect and re-validate.

Missing references are organized into tabs by type (Items, Accounts, Entities, etc.). Each tab shows the missing values along with their current resolution status. For a deep dive into this step, see Handling Missing References During Import.

Step 5: Validate Data

Before any data is sent to QuickBooks, PrimeConnect performs a thorough validation of every row in your file. This step catches errors that would otherwise cause import failures, saving you time and preventing partial imports.

What gets validated

• Required fields — every required field must have a value in every row.
• Date formats — dates must be in a recognized format (MM/DD/YYYY, YYYY-MM-DD, etc.).
• Numeric values — amounts, quantities, and rates must be valid numbers.
• Reference existence — all referenced items, customers, accounts, etc. must exist in QuickBooks (or be set to auto-create).
• Duplicate detection — when update mode is disabled, PrimeConnect flags records that already exist in QuickBooks to prevent accidental duplicates.
• Field length limits — some QuickBooks fields have maximum character lengths that PrimeConnect checks against.

Validation results

After validation, each row receives a status indicator:

• Green check — the row is valid and ready to import.
• Red X — the row has one or more errors. Click the row to see the specific error message.
• Yellow warning — the row has a non-critical issue that may need attention (e.g., a value will be truncated to fit the field length limit).

For detailed information on fixing validation errors and re-validating, see Data Validation & Preview.

Step 6: Preview & Import

This is the final step before your data is sent to QuickBooks. The preview screen shows your data in a table format exactly as it will be imported, giving you one last chance to review everything.

Reviewing your data

The preview table displays all rows with their mapped field values. Scroll through the table to verify that the data looks correct. Pay special attention to:

• Date values — are they in the correct format and expected range?
• Amounts — do the numbers look right? Are there any unexpected zeros or very large values?
• References — are customer names, item names, and account names spelled correctly?

Executing the import

When you are satisfied with the preview, click the Import button to begin. PrimeConnect sends each record to QuickBooks one at a time and displays a progress indicator showing:

• The current record number out of the total (e.g., "Processing 23 of 150")
• A progress bar showing overall completion
• Running counts of successful, updated, and errored records

Understanding Results

After the import completes, PrimeConnect displays a results summary showing the outcome for every row.

Result statuses

Overall summary

The results screen shows a summary bar with the total counts for each status. A fully successful import shows all records in green. A partial success shows a mix of green and red/yellow. The summary also includes the total elapsed time for the import operation.

Error details

Each errored row includes the specific error message returned by QuickBooks. Common error messages include:

• "Object not found" — a referenced item, customer, or account does not exist in QuickBooks.
• "Invalid date" — the date value could not be parsed.
• "Duplicate name" — a record with this name already exists (for list items like Customers or Vendors).
• "This feature is not enabled" — the QuickBooks edition or company file settings do not support this record type.

Every import operation is saved to your operation history so you can review it later or roll it back if needed.

Tips for Successful Imports

Follow these best practices to ensure smooth, error-free imports:

1. Start with a small test batch. Before importing your full dataset, try importing just 5-10 rows first. This lets you verify that your field mapping is correct and there are no unexpected issues. You can always roll back a test import.
2. Use the sample files as templates. PrimeConnect includes sample Excel files for every entity type. Download these from the Sample Import Files article and use them as a starting point for your own data.
3. Enable auto-create for references. If your import references customers, items, or accounts that may not exist yet, enable auto-create in Settings. This prevents missing-reference errors and streamlines the import process.
4. Save your mapping templates. If you import the same type of file regularly (e.g., monthly invoices from an external system), save your field mapping as a template. Next time, load the template and skip the mapping step entirely.
5. Name your columns descriptively. Use column headers that closely match QuickBooks field names. This improves auto-matching accuracy and reduces manual mapping effort.
6. Use .xlsx format over CSV. Excel files preserve data types (dates, numbers) more reliably than CSV. With CSV, all values are text and must be parsed, which can lead to ambiguities (e.g., "01/02/2025" could be January 2 or February 1 depending on locale).
7. Import lists before transactions. If you need to import both customers and invoices, import the customers first. This ensures they exist in QuickBooks when the invoices reference them.
8. Review results carefully. After every import, check the results screen for errors. Fix the errored rows in your source file and re-import only those rows.