QuickBooks Desktop Excel imports: choose the right path or the import stalls

QuickBooks Desktop users who need to bring spreadsheet data into the company file have two separate routes, and choosing the wrong one is the usual reason an Excel import stalls. The accepted answer in the QuickBooks Desktop community thread on importing and exporting Microsoft Excel files walks through both paths: a standard wizard for customer, supplier, and item lists, and a dedicated import window for the chart of accounts. Both depend on column mapping, and both have limits around inventory that the wizard does not make obvious.

Two routes into QuickBooks Desktop

There is no single Import Excel button that handles every list. The standard import path is File, Utilities, Import, Excel Files. Use that for customers, suppliers, and the products you sell. When the wizard starts, it may also open an Add/Edit Multiple List Entries window. If that happens, choose No. That window is a manual list editor, and it will not run the Excel import. The wizard continues after you dismiss it.

QuickBooks then opens a formatted Excel workbook for you to fill in. Paste or type the information into the matching columns, save the file, and close it. Only after the file is closed does the wizard make an Add My Data Now button available. Clicking it starts the actual import. The review screen that follows gives a summary of the records that were brought in, and Close finishes the job.

The same path works if you need to import additional batches. Go back to File, Utilities, Import, Excel Files and run the wizard again. There is no need to export a template separately, because the wizard generates a fresh workbook each time.

Separate import for the chart of accounts

The chart of accounts has its own import, and users who look for it under Utilities often do not find it. Open the Lists menu, choose Chart of Accounts, and then use the Account dropdown at the bottom of the window. The entry reads Import from Excel. Browse to the spreadsheet, select the file, and pick the sheet that holds the accounts. QuickBooks reads only the active sheet you choose, so placing accounts on the wrong tab in the workbook can cause the import to come up empty.

A backup of the company file is worth making before this step. The accepted answer recommends it, and it is the move that rescues users when a mapping error creates accounts with duplicate names or incorrect types.

Mapping the account columns

The chart of accounts import does not happen until columns are mapped. QuickBooks column headings are usually not identical to the headings in your own spreadsheet. The wizard displays QuickBooks fields on one side and your Excel columns on the other. Name the mapping, set Account as the import type, and match each QuickBooks field to the Excel column that holds that data. Save the mapping when it is complete.

On a first import, QuickBooks asks you to confirm that you want to proceed. Answer Yes and the import runs. Later imports can reuse the saved mapping, which removes the need to match columns again. If the mapping is wrong, accounts can be created without account types, so check the result screen before closing it.

Inventory quantities cannot be changed by import

The item import rules catch many users off guard. For existing inventory items, the import can update descriptive fields such as names and descriptions, but it cannot change quantity on hand, value on hand, or average cost. There is no Excel column you can add to override that. New inventory items, by contrast, can be created with a starting quantity and value. QuickBooks records the opening balance by debiting the item asset account and crediting Opening Balance Equity, so the balance sheet stays balanced.

One configuration blocks item imports altogether. If Advanced Inventory is active and Multiple Inventory Sites is enabled, those site-based quantities cannot be imported. The accepted answer states that Multiple Inventory Sites must be disabled before importing item quantities or values. You can re-enable it after the import completes.

The same answer notes that Subtotal, Payment, and Sales tax items cannot be brought in through the advanced import. They function differently from ordinary items, so the import path does not accept them.

Export side remains thin

The thread title covers export as well as import, but the accepted answer devotes most of its detail to importing. Users who need a batch export of transactions will have to look beyond this thread. For import problems, the resolution is consistent: use the correct path for the list, map columns before importing, keep a backup, and understand that inventory counts on existing items will not update through Excel. Plan to reconcile quantities separately after the import.