How to Transfer Inventory Quantities to a New QuickBooks File

QuickBooks Desktop (Pro, Premier or Enterprise) > Transaction Pro Importer
Please follow the steps below to transfer inventory quantities to a new QuickBooks company file.
  1. Using Transaction Pro Exporter export your entire item list
  2. Open up the file in Excel and remove any item type lines that do not have the word inventory in the Item Type column
  3. Open up Transaction Pro Importer and browse for the item list file
  4. Select an import type of Inventory Adjustment
  5. Create a mapping similar to the one below.  Please update any fields in yellow to match your QuickBooks company file

Add Feedback