Bill of Material (BOM) – Fastest way to enter if 20 or more parts?

Hello Dav, 

Thanks for stopping by the Community this afternoon. My suggestion to you is to set up the BOM then add it to an item called inventory assembly, this way you can use that item to start building your product. To see how to assemble your product, you can check out this link: Combine your inventory items to build finished goods. Below I'm listing the steps to set up your products bills of materials. 

1. From the Lists menu, select Item List.
2. Select the Item ▼ drop-down and then New. Then, select Inventory Assembly.
3. Add your product’s name or build number.
4. If you buy from a vendor, select I purchase this assembly item from a vendor. Note: Select this if you buy this product assembled from a vendor. If you build the product yourself, skip this.
5. Add the Cost. This can be the total cost of all the parts in the bill of materials. Or it can include other expenses.
6. From COGS Account ▼ drop-down, select Cost of Goods Sold. QuickBooks uses this account to track the cost of products you sell.
7. You can also add a description of this product.
8. Add the Sales Price. Then, select the Income Account ▼ drop-down and find the account you use to track sales from finished goods. Tip: If you need a new account, scroll to the top of the drop-down list and select.
9. Under Bill of Materials, select the items you use to manufacture. You can change the quantity and unit of measure of each item.
10. Under Inventory Information, add the following:
    • Asset Account: QuickBooks uses this to track the total cost of finished goods in your inventory. You can select an account QuickBooks already set up for you. Or go to the top of the drop-down and select <Add New>.
    • Build Point (Min): This is the minimum point when you should build more of this product. QuickBooks uses this to remind you when it’s time to build.
    • Max: The max number of this product to build.
    • On Hand: The current quantity of this product you have on hand.
    • Total Value: This is the total cost of finished goods you have in stock.
11. Select OK.

I also recommend checking out this helpful article, it highlights the steps above as well as other useful information: Set up your products bill of materials.

If you have any other questions, or concerns, feel free to post down below. Thank you for your time and have a nice Monday afternoon. 

Hi @Nick_M  and QB Community -

Which is the fastest most efficient way to enter all the parts in a BOM?    Is there a way to copy and paste into QB all the parts for a BOM?   Or, is there a way to upload the BOM into QB?

Thanks for the response, @Dav.

At this time, my colleague @Nick_M has provided the fastest, most efficient way to enter all the parts in a BOM. I'm going to submit feedback to the Product Development Team about adding different ways to input this information, like uploading or pasting it in. You can visit our Blog to see updates of QuickBooks products, as well as seeing news that may benefit you and your company. 

If you have any additional questions or concerns, please don't hesitate and reach back out! Have a great rest of your day.

@Dav 

Consider having a 3rd party tool to do so

Hi Ashley and QB Team -

Have there been an updates on QB enabling a better way to enter a lengthy Bill Of Materials?

@Ashley H   @Fiat Lux - ASIA

Thanks for coming back, Dav.

I know it’s convenient to have a better way of entering lengthy bill of materials. As of now, it’s still unavailable in QuickBooks Desktop Enterprise. You may consider using a third-party tool as suggested by our Community backer, Fiat Lux – ASIA.

Our Desktop App Center contains several tools that can be integrated with QuickBooks. Just enter a keyword in the Search field, then read each feature to learn more.

You can check this reference about tracking and setting up a list of all the components you use to build a single product: Track the products you manufacture.

Don’t hesitate to let us know if you have other concerns besides bill of material updates. The Community team is always to help you. Keep safe!

@Dav 

An importer tool.

https://transactionpro.grsm.io/qbd

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

This is the most horrible way to solve that problem, it may look good for a moment, but you'll come to regret this very soon. The only proper way is to input the complete Bill of materials in each assembly and not have sub assemblies.

If you retain sub assemblies, you will need to build all of those in order for you to build the main assembly. In my case it means you are building 5 assemblies to actually build one... I'm changing all current assemblies to fully be stock parts only. Saving me 100s of builds