Handling Missing References During Import

What Are Missing References

QuickBooks uses a relational data model where transactions reference other records. An invoice references a customer, line items reference products/services, and every transaction touches at least one account in the Chart of Accounts. These cross-references are called references.

When you import data into QuickBooks through PrimeConnect, every reference in your file is checked against the records that already exist in your QuickBooks company file. If a reference points to a record that does not exist, it becomes a missing reference.

A concrete example

Suppose you are importing a batch of invoices and one row has:

• Customer: "Acme Corp"
• Item: "Consulting Services"
• Account: "Professional Fees"

If your QuickBooks file has a customer named "Acme Corp" but does not have an item called "Consulting Services" or an account called "Professional Fees," then both the item and the account are missing references. The import cannot create the invoice until these records exist.

The Missing References Step

Step 4 of the import wizard is dedicated to resolving missing references. PrimeConnect scans your entire dataset, cross-references every value against your QuickBooks company file, and presents all missing references in an organized, tabbed interface.

Tab organization

Missing references are grouped into tabs by type:

• Items — products, services, inventory parts, and other item types that do not exist in QuickBooks
• Accounts — Chart of Accounts entries (income, expense, bank, etc.) not found in QuickBooks
• Entities — customers, vendors, and employees not found in QuickBooks
• Payments — payment methods not found in QuickBooks
• Currencies — currency codes not found (for multi-currency company files)
• Other — classes, sales reps, terms, ship methods, tax groups, inventory sites, and other reference types

Each tab displays a count of missing references so you can see at a glance which types need attention. Tabs with zero missing references are indicated accordingly.

Status indicators

Each missing reference in the list has a status indicator:

• Pending — the reference is missing and has not been resolved yet. The import will fail for records that use this reference unless it is resolved.
• Will be created — auto-create is enabled for this type and PrimeConnect will create the record automatically during import.
• Error — an attempt to create the record failed (e.g., invalid account type or missing required information).

Auto-Create References Setting

PrimeConnect can automatically create missing records in QuickBooks during the import process. This is controlled by individual toggles in the Settings window.

Available auto-create toggles

You can enable or disable auto-creation independently for each of the following 12 reference types:

How to enable auto-create

1. Open PrimeConnect and click Settings in the navigation bar.
2. Scroll to the Auto-Create References section.
3. Toggle on the reference types you want to auto-create. Each toggle is independent — you can enable Customers and Vendors while leaving Items and Accounts disabled, for example.

Manually Resolving References

If auto-create is disabled for a reference type (or if you prefer to create records manually with specific details), you need to create the missing records in QuickBooks before the import can proceed.

The manual resolution workflow

1. In Step 4 of the import wizard, review the list of missing references. Note the names and types of the records that need to be created.
2. Switch to QuickBooks Desktop (without closing PrimeConnect).
3. Create each missing record in QuickBooks. For example, if "Consulting Services" is a missing item, go to Lists > Item List > New in QuickBooks and create it with the appropriate type, account, and pricing.
4. Switch back to PrimeConnect and click Re-check (or navigate back and forward) to re-scan your QuickBooks file. The previously missing references should now be resolved.

Reference Types

Different reference types have different requirements when being auto-created. This section covers the specific details for the three most common categories.

Items

Items are the most complex reference type because QuickBooks requires additional information beyond just the name. When auto-creating items, PrimeConnect needs to know:

• Income Account — the account to credit when this item is sold (required for all item types). For example, "Sales Income" or "Consulting Revenue."
• COGS Account — the Cost of Goods Sold account (required for inventory and non-inventory part items). For example, "Cost of Goods Sold."
• Item Type — PrimeConnect defaults to creating Service items when auto-creating. If you need Inventory Part or Non-Inventory Part items, it is better to create them manually in QuickBooks with the correct type and associated accounts.

In the missing references screen, items that require account information are highlighted in yellow. You can specify the accounts directly in PrimeConnect's missing references interface, or you can go to Settings and configure default accounts for auto-created items.

Accounts

Accounts require an Account Type when created. QuickBooks supports numerous account types, including:

• Bank — checking and savings accounts
• Accounts Receivable — money owed to you
• Accounts Payable — money you owe
• Income — revenue accounts
• Expense — expense accounts
• Cost of Goods Sold — COGS accounts
• Other Current Asset — short-term assets
• Fixed Asset — long-term assets
• Other Current Liability — short-term liabilities
• Long Term Liability — long-term liabilities
• Equity — owner equity accounts
• Other Income — non-operating income
• Other Expense — non-operating expenses

When auto-creating accounts, PrimeConnect will prompt you to select the account type for each missing account. Choosing the wrong type can affect your financial reports, so select carefully.

Customers, Vendors, Employees

Customers, vendors, and employees are the simplest reference types to auto-create because they only require a name. When PrimeConnect auto-creates these records:

• The record is created with just the display name from your import file.
• All other fields (address, phone, email, terms, tax settings, etc.) are left blank.
• You can edit these records later in QuickBooks to add full details.

This is the safest and most common auto-create scenario. Most users enable auto-create for customers and vendors because the import file rarely contains full contact details — it just has names.

Common Scenarios

Here are the most common situations where missing references come up and how to handle them:

Importing invoices with new customers

You are importing a batch of invoices from an external system, and some invoices are for customers that have not been set up in QuickBooks yet.

• Easiest solution: Enable auto-create for Customers in Settings. PrimeConnect will create the customer records automatically with just the name. You can add addresses, terms, and other details in QuickBooks later.

Importing bills with new vendors

You are importing vendor bills and some reference vendors that are not yet in your QuickBooks file.

• Easiest solution: Enable auto-create for Vendors. Same behavior as customers — created with name only.

Importing transactions with new items

Your import references product or service items that do not exist in QuickBooks.

• If items are services: Enable auto-create for Items and ensure you have a default Income Account configured. Simple service items are created automatically.
• If items are inventory parts: Create them manually in QuickBooks with the correct item type, income account, COGS account, asset account, and on-hand quantities. Then re-validate in PrimeConnect.

Importing journal entries with new accounts

Journal entries reference accounts that are not in your Chart of Accounts.

• Best approach: Create the accounts manually in QuickBooks with the correct account type (Income, Expense, Asset, Liability, etc.). Incorrect account types can cause reporting errors. After creating the accounts, re-validate in PrimeConnect.

Best Practices

1. Enable auto-create for simple reference types. Customers, Vendors, Employees, Classes, Sales Reps, and Payment Methods are safe to auto-create because they need minimal information and can be edited later.
2. Create Items and Accounts manually when you need precise control. These record types have important configuration options (item type, account type, linked accounts) that affect financial reporting.
3. Review auto-created records in QuickBooks. After an import with auto-created references, open QuickBooks and review the newly created records. Add any missing details (addresses, terms, account numbers, etc.) so your QuickBooks data is complete.
4. Use consistent naming. The most common cause of missing references is inconsistent naming — "Acme Corp" vs "Acme Corporation" vs "ACME CORP." Standardize names across your import files and QuickBooks data to avoid duplicates and unresolved references.
5. Import lists first, transactions second. If you are migrating data from another system, import your master records (Customers, Vendors, Items, Accounts) before importing transactions (Invoices, Bills, Journal Entries). This eliminates most missing references from the transaction imports.
6. Check the tab counts. Before proceeding past Step 4, check that all tabs show zero pending missing references (or that all remaining ones are set to "Will be created"). Unresolved references will cause import errors in the next step.