Import build assemblies into QuickBooks

Overview of importing build assemblies.

In QuickBooks desktop a build assembly is a transaction that combines component items together to make an assembly item, for example an interior door kit that is shown in the example below.  Using Zed Axis you can import build assemblies from text and Excel files directly into QuickBooks Desktop.  

Steps to import build assemblies

Please follow these steps:
  1. Open your QuickBooks company file and connect Zed Axis.
  2. Select the import tab and browse to the file that contains the build assembly data
  3. Create a new map between the columns in your import file and the QuickBooks fields
  4. Click the import button and your build assemblies will be directly imported into QuickBooks.

More help?

 Where the fields appear on a build assembly

Import Build Assemblies into QuickBooks

Detailed description of the fields you can map

QuickBooks FieldFormatDescription
Item Inventory Assembly Refstr 159 The name of the Inventory Assembly item (matches Assembly item in QuickBooks)
Inventory Site Refstr 31Inventory site for the Built assembly more here
Inventory Site Location Refstr 31Inventory site bin location for the built assembly more here
Serial Numberstr 4095The serial number of the assembly item more here
Lot Numberstr 40The lot number of the assembly item more here
Txn DateDateDate of the assembly build
Ref Numberstr 11Reference number for the assembly build
Memostr 4095Additional information
Quantity to BuildQuanThe number of assemblies to be built, if there are insufficient component items available the build will fail
Mark Pending If RequiredboolWhether the build assembly is to be marked as pending, (true) use if there are insufficient quantities on hand of component items


I downloaded the Zed Axis 12.1 and am interested in purchasing it. I cannot get the mapping to allow more than one Inventory Line Item on my mapping. My assemblies will have multiple line items per assembly. How can I get multiple inventory Line Items per mapping?
Matt Lebold (3/27/2018 at 1:22 AM)
Hi Matt, the components are set on the Item Inventory Assembly if you need to change what components are on the assembly then you need to modify the Item Inventory Assembly not the Build Assembly.
Steve (8/28/2018 at 12:12 AM)
Does the import build assembly work for Qucikbooks Enterprise with Advanced inventory (inventory sites) enabled?
I have tried many different options, including importing a super simple assembly from a text file and I always get...
This feature is not enabled or not available in this version of QuickBooks.
The Error location is

Please advise.

Richard Carman (5/15/2020 at 12:49 AM)
Hi Richard, Yes it does work with Sites and Bins in Enterprise, can you check the your company file to make sure that you have Inventory Site and Bin switched on in QuickBooks.
Steve (8/21/2020 at 12:33 AM)
Does this feature work with the QB Enterprise feature 'Automatically Build Sub Assemblies' ? This is an option when you manually create a build assembly. Please let me know. Thx!
Richard Carman (11/11/2021 at 2:45 AM)