Setting Up Barcode Scanning in QuickBooks Desktop

QuickBooks Desktop Enterprise users with Advanced Inventory can scan barcodes directly onto transactions, but the setup involves several moving parts — and a few hardware caveats that trip people up before they ever open the wizard.

Scanner Compatibility

Not every scanner works with the built-in barcode feature. QuickBooks expects a scanner that reads EAN-13 or Code-128 symbologies and transmits a single carriage return at the end of the scanned string. Serial-port scanners are incompatible with the native feature, and the Warehouse Manager app and the sales order fulfillment worksheet each require their own specific scanner types. If a scan does nothing on screen, the hardware itself is the first thing to check.

Enabling Barcodes

The toggle lives under Edit → Preferences → Items and Inventory → Company Preferences. Click Advanced Inventory Settings, then the Barcodes tab, then Enable Barcode and Open Barcode Wizard.

The wizard asks which item field the barcode should map to. The field must be unique per item — Item Name or Part Number are the safe choices. Picking a non-unique field means one scan could pull the wrong item onto a transaction. After choosing the field, select which item types to generate barcodes for, then finish.

Once enabled, scanning works across most sales and purchasing forms: estimates, sales orders, invoices, sales receipts, refunds and credits, purchase orders, item receipts, bills, write checks, and inventory transfers. The scanned item appears as a new line on whichever form is open.

Adding Barcodes One at a Time

For a handful of items, open Lists → Item List, double-click an item, and go to Custom Fields → Define Fields. Add a new field — “Barcode 2” is a common label for a secondary code — check Use, and save. You can then type or scan the barcode value into that field for each item individually.

Bulk-Importing Barcodes Through Excel

When hundreds or thousands of items need barcodes, manual entry is impractical. The accepted method uses Excel export and re-import, but it requires single-user mode — File → Switch to Single-user Mode — before importing.

The workflow:

1. Export the item list. From Lists → Item List, open the Excel dropdown at the bottom and choose Export all items to a new workbook.
2. Add barcode values. In the exported spreadsheet, find the custom field column (matching the label created above) and enter the barcode for each item.
3. Import back. Go to File → Utilities → Import Excel Files. Decline the Add/Edit Multiple List Entries prompt and choose Advanced Import.
4. Map the columns. Select the saved file and sheet, then create a new mapping. Set the import type to Item. Match Type to Type and Name to Item. Scroll to the custom barcode field line and match it to the corresponding column in your data. Leave other fields blank.
5. Replace, do not overwrite. Select the option to replace existing data with import data, ignoring blank fields. This ensures only the barcode column updates — everything else in the item records stays untouched.

After the import completes, return to Preferences → Items and Inventory → Company Preferences → Advanced Inventory Settings → Barcodes and reopen the Barcode Wizard to assign or verify the scanned values against the enabled barcode field.

Common Stumbling Blocks

The setup fails most often when the scanner sends the wrong terminator, when the mapped field is not truly unique, or when the import runs in multi-user mode. Verifying the scanner’s carriage-return behavior and confirming single-user mode before importing eliminates the majority of problems before they surface.