United States United Kingdom Australia Brasil Canada (English) Canada (French) France Mexico Singapore South Africa Global Ireland
Created with Sketch.Learn about PPP and Loan Forgiveness, stay informed with the latest changes.
Created with Sketch.Questions about how to close your books for 2020? Visit our Year End Resources page.
Created with Sketch.New to QuickBooks or using a new product? Visit our Get Started resource page to help you get going.
Created with Sketch.Need to make changes to your account? Visit the Account Manager Portal.
cancel
Turn on suggestions
Showing results for 
Search instead for 
Did you mean: 
gerdgoebel
Level 2
posted
‎November 18, 2020 10:26 AM
last updated ‎November 18, 2020 10:26 AM

Importing Build Assemblies using Excel or CSV file

I am using QB Prem 2020 with latest updates.

I work with lots of assembly items, thus, have to build them regularly. After this is rather cumbersome as I have to do one at a time, I am looking for some import templates I could use. Like an Excel or CSV template.

Is this possible with a template? And if yes, does anybody have such a Build Assembly. template and would share it?

I found a set of Excel import templates on the Internet but it did not have an Build Assembly template included.

Reply Join the conversation
2 Comments
JasroV
QuickBooks Team
QuickBooks Team
‎November 18, 2020 12:18 PM

Importing Build Assemblies using Excel or CSV file

Good day to you, @gerdgoebel.

 

I appreciate you for sharing the details with me. I can see how convenient it is to import your build assembly item.

 

As of this time, there isn’t an option to import them in QuickBooks Desktop (QBDT) using Excel or CSV template. In QuickBooks, we can only import Inventory Parts. Then, you can create the Inventory Assembly items using the imported items.

 

Nevertheless, you can consider looking for a third-party app that lets you import assembly items in QBDT. You can go to the App Center on your software and look for an app from there. You can also visit our QuickBooks Apps Store for additional reference.

 

Let me also add this article that you can utilize in case you need to edit an item in QBDT: Add, edit, and delete items.

 

You can always keep in touch with me whenever you have other questions about inventories. I’m always here to lend a hand. Keep safe and take care!

Reply Join the conversation
Fiat Lux - ASIA
Level 15
‎November 18, 2020 06:07 PM

Importing Build Assemblies using Excel or CSV file

@gerdgoebel 

Prepare the Item Assembly data with the following template

Assembly Item NameParent Item NameIncome AccountCOGS AccountAsset AccountPurchase CostPurchase DescriptionSales PriceSales DescriptionBuild PointComponent Item NameComponent Item QtyUnit of Measure
Kit1 General SalesCost of Goods SoldInventory Asset56Sample Kit90Sample Kit Carpeting1 
Kit1 General SalesCost of Goods SoldInventory Asset56Sample Kit90Sample Kit Pad1 
Kit2 General SalesCost of Goods SoldInventory Asset60Sample Kit105Sample Kit Wood Door1 
Kit2 General SalesCost of Goods SoldInventory Asset60Sample Kit105Sample Kit Toilet1 
Kit2 General SalesCost of Goods SoldInventory Asset60Sample Kit105Sample Kit Sink1 

 

then utilize one of these importer tools.

https:// transactionpro.grsm.io/qbd

https:// partners.saasant.com/affiliate/idevaffiliate.php?id=5051_2

 

 

Reply Join the conversation
Featured
Your guide to W-2s for 2020 taxes | QuickBooks Desktop
This pre-recorded webinar will go over how to make sure your company is set...
Read more
Important Year End Dates
*Not sure which Payroll service you have? Check versions and dates here!
Read more
Your guide to W-2s for 2020 taxes | QuickBooks Online
This pre-recorded webinarwill go over how to make sure your company is set ...
Read more
Top

Need to get in touch?

Contact us