How to Import Build Assemblies into QuickBooks

A Build Assembly in QuickBooks Desktop is a transaction that joins Inventory component items to create an Inventory Assembly Item, […]

A Build Assembly in QuickBooks Desktop is a transaction that joins Inventory component items to create an Inventory Assembly Item, like the interior door kit in the example below.  You can import Build Assemblies in bulk straight into QuickBooks Desktop from Excel files by using Dancing Numbers.

Save Time, Reduce Errors, and Improve Accuracy

Dancing Numbers helps small businesses, entrepreneurs, and CPAs to do smart transferring of data to and from QuickBooks Desktop. Utilize import, export, and delete services of Dancing Numbers software.

*No credit card required

Steps to Import Build Assemblies into QuickBooks

Please take these actions:

  • Open your QuickBooks Company File and Connect Dancing Numbers.
  • Click Start to Import and Select Build Assembly option.
  • Click to select or Drag the Excel Sheet that needs to be Imported the Select the Worksheet from the Dropdown and Click Next and Ok.
  • The File Preview Screen will show you the Data for the Excel Worksheet selected by you. If it is correct Click Next.
  • On the Mapping Screen Select the Excel Column with the Relevant QuickBooks Fields and Click Next.
  • File Updates Screen shows you Loading References to check if all the Inventory Assembly names are matching with QuickBooks or not and based on that it will show you the Missing references on the Next Screen.
  • Click Import to Start Importing the Build Assembly in QuickBooks.
  • Once Finished you can check the Build Assembly in QuickBooks by Clicking the small QB Icon on the Left side of the Imported Screen.

Where the Fields Appear on a Build Assembly

How to Import Build Assemblies into QuickBooks

Fields You Can Map with Detailed Description

QuickBooks FieldDescription
Inventory Assembly Item NameThe name of the Inventory Assembly item (matches Assembly item in QuickBooks)
Inventory Site RefInventory site for the Built assembly
Inventory Bin LocationInventory site bin location for the built assembly
Transaction DateDate of the assembly build
Reference NumberUnique Reference number to Build Assembly
MemoAdditional information
Build QuantityThe quantity of assemblies that need to be constructed; if not enough component parts are available, the construction will not succeed.
Accounting Professionals, CPA, Enterprises, Owners
Accounting Professionals

Looking for a professional expert to get the right assistance for your problems? Here, we have a team of professional and experienced team members to fix your technical, functional, data transfer, installation, update, upgrade, or data migrations errors. We are here at Dancing Numbers available to assist you with all your queries. To fix these queries you can get in touch with us via a toll-free number
+1-800-596-0806 or chat with experts.

close btn

Get Your Case Study

Call Now+1-800-596-0806