Manufacturing in QuickBooks: Inventory Assembly, Sub-assemblies, Pending Builds

QuickBooks 30-day free trial + 30% off for 12 months:
quickbooks.int...
Excerpt of 06/02/2016 QB Power Hour Episode on: Manufacturing and Assemblies. Hector shows the process of creating sub-assemblies for work in process (WIP) and final inventory assemblies for Finished goods.
Topics contained in this video:
00:00:13 - Create inventory assembly in QuickBooks Desktop
00:09:37 - Build assembly (step by step)
00:10:53 - Bill
00:11:28 - How this re order points are useful?
00:12:28 - Create Auto PO’s
00:13:41 - Create PO’s
00:14:00 - Purchase order
00:14:22 - Create bill
00:15:00 - Inventory stocks status by item
00:16:07 - Build assembly and select item (work in progress)
00:18:08 - Mark pending
00:19:01 - Build assembly (shortage report)
00:19:32 - Create PO’s
00:19:56 - Pick up the PO’s just created in bill
00:20:34 - Remove pending status button
00:21:20 - Item list
00:21:42 - Balance sheet
00:22:08 - Create new inventory assembly (example) (step by step) and how it works
00:26:04 - Build assembly (some feature only on QuickBooks Enterprise or Premier edition)
00:27:39 - Build and close
QuickBooks Premier and QuickBooks Enterprise only

[@lushengtao5153]

Hi Hector, Am I able to delete 100 pending builds at a same time?

[@HHPrecisionAg]

How can i track inventory parts separately from a PO that purchased the inventory assembly. Example we can either buy the inventory parts separately and put the assembly together or buy the assembly from the vendor then sell the assembly or just the parts to customers

[@jamshidnadimi4568]

Hi Hector, I make BOM based on Inventory on hand ( stock) but I faced with does not have enough component in assembly section what should I do . In fact there is enough Inventory part to make it and I do not want to purchase new Inventory.

[@grantwilson6378]

I know this is an old video and hopefully someone can answer this question. I have the same sort of setup and at the very end of the video 26:35 you make the build for the chandelier when I do that I have 2 entries in my QBs desktop file and support hasn't been able to answer why or how to fix it. I get a credit to WIP debit to Final and then another entry that credits Final and debits COGS and I am not doing any sort of sale, just building an assembly. Is this how it worked when you did this video, is that normal? Then, just to confuse it further, if I do then make an invoice and complete the sale for the nested build, there is a zero dollar entry between Final and COGS.

[@marcelogavotti4965]

Hectór cómo estás? Qué pasa si el inventory assembly lo produce un tercero y no lo hago yo? Es decir, el PO que yo envío son inventory assembly y los componentes de ese inventory assembly se lo doy yo al tercero que los procesa y hace un producto final ?

[@SabithaG-kv5qq]

Hi Am using quickbooks pro 2016 .. I can't use build assembly option for manufacturing

[@gayanekanayake9637]

Hi Hector I my company , we have several by-products from the main product. We sell those at a lower value, but still their value is above the materiality threshold of the company. So I want to know how to treat those by-product in assembly or how we should take into account in assembly. Thanks

[@BuuLe-sh1mi]

Thank you for all your videos. I have a question on how to assign serial numbers for items at Wip or Finish Good process. I faild in many attempts to assign serial numbers when Build Assembies.

[@zeeshan6239]

Hi your videos are very helpful and I learned a lot from them can you please advise "can we prepare build assembly report in quickbooks"

[@HectorGarciaCPA]

No that report doesnt exisit

[@freesoul4eva]

Thank you Hector. I will have a chat with my partner to see if we wanna purchase the Enterprise instead.

[@HectorGarciaCPA]

Cool. If you buy through us, you get a 20% discount for life.

[@freesoul4eva]

⁠Ok. And what about the QuickBooks online? How much would that cost with you? Can it be in Portuguese language as my manager doesn’t really understand English properly.

[@brendawilson5905]

Hi Hector, I hope you can help me. I am using SKU numbers for my Item numbers in QB. When I "build assemblies" from WIP to Finished Goods. The finished goods asset account on the balance sheet is debited and the WIP account on the balance sheet is credited. That's all good, but the inventory center (where my SKU # (QB Item Number) does not show that the quantity has been updated. On the Inventory Stock Status report, they are shown in the Assembly category. Do I need to do something else after I "build assembly" to get QB to update my quantity in the inventory center showing that I have more products available? Thanks so much! Brenda Wilson

[@user-lt7pq1zx4u]

Hello Hector, first I want to say I'm so glad to find your videos. We own a manufacturing company and I took over the bookkeeping after outsourcing it. You've cleared up a lot of questions. But, I do have one for you, hoping you can help. We have desktop Premier Plus Mfg. Wondering if I can use assemblies with sub items to have product varieties. Our BOM is large and the only item changing between 4 or so varieties is the color of the molded parts. Could I do one parent assembly and then have a sub item for each color? Would it have just the molded part in it or would I have to have all the BOM on that item too. Thinking it would be easier if an item changes to change in the parent instead of all 4 parts. Also, we have products that are sold to distributors and although they are the same part (sku), we'd like to track them differently than the ones that we sell direct. Since I don't want to "assemble" a dealer version, wondering how to handle that. Your help is greatly appreciated!

[@HectorGarciaCPA]

There are too many moving parts on those questions. Maybe if we can look at your file, we can give you a better answer

[@user-lt7pq1zx4u]

@@HectorGarciaCPA I totally get it. To make it simpler, I am trying to find a way to have a sub-item of an assembly that would pull from the inventory without having to do a build. How might I show you our file?

[@rexespiritu6153]

Hi, Hector. I think you missed out to discuss also the site list and the transfer of item here wherein the raw materials and/or sub-assemblies are not stored in the production department. And Pending Builds has to be avoided in the real world because it will give an additional cost/loss and will hamper the production output level of the Company. Since a certain Company has Production Plan for their confirmed orders, therefore, when setting up the Inventory Part, it must have the Reorder Point min/max number of items both in the Production Site and Warehouse Site to comply with the Production Department Production Plan by the Purchasing Department/Warehouse Department, thus, avoiding future overruns of cost and avoidance of losses.

[@HectorGarciaCPA]

Good points, is hard to cover it all in every video :)

[@rexespiritu6153]

Yes, I agree with you and aside from that, the sample that was presented in this video is a Chandelier Manufacturing that needs not much Inventory Warehousing Management. Mr. Hector, I visited the website for Enterprise Expert and I sent the request in joining. Kindly accept my request. Thank you so much, and best regards.

[@HectorGarciaCPA]

REX ESPIRITU you are right... none of that is covered.

[@PacbasicEauClaire]

Thank you for this instruction. We are using Enterprise with Advanced Inventory, having assemblies within assemblies and have confusion how inventory is pulling from various sites. It's hard to know whether you are building to a bin or from a bin. Especially when you build "to" a site and bin at the top, and have to break it down per line item within the form.

[@HectorGarciaCPA]

Send me a screenshot

[@shar0526]

Can you change an existing Product in inventory to an assembly product without messing any past information?

[@HectorGarciaCPA]

If you don’t want to mess with history; just create a new inventory assembly and disable the inv item.

[@Priyanshu-vq6es]

Hi, Hector, can you please tell me how to add labour and overhead charges in manufacturing???

[@sophiestorontolife6566]

I want to know about it too😂

[@sophiestorontolife6566]

Labour can be an item. Overhead can be an item .

[@freesoul4eva]

Hi Hector. Can I use this quickbooks enterprise for assembled items and ready made items also? Can I put it on the cloud?

[@HectorGarciaCPA]

Enterprise works with assemblies well. Yes there is an option to host QuickBooks Enterprise

[@ramjemanish]

I have a production output efficiency of 90%. When I do the build assembly it gives us the cost based on 100% production output efficiency, but in reality, there is some 10% scrap generation which is of no use. How to enter a production efficiency in the system so that my 100% cost spread on 90% of the production output.

[@HectorGarciaCPA]

All you do is increase the materials usage be 10% so the costs reflect the yield/scrap variance

[@eddievargas3447]

Hi Hector, please it is possible to watch this same video in Spanish. Thank you

[@HectorGarciaCPA]

This one is not in Spanish

[@lydianyamahunge2702]

This would be helpful,but words are not visible,and I seriously need this information

[@darrylsegal6398]

I have a cosmetic Manufacturing factory, We make shampoos and skin creams. We use QuickBooks which is ideal if you buy an item and sell it. And make a profit. But we build a shampoo....which has a bottle, cap, label, box and let's say 15 ingredients. Right now we use excel to keep track of everything and its a headache. I heard there are a Quickbooks specifically fir manufacturers. Is there such a think. Or is there just enterprice and premiere?

[@HectorGarciaCPA]

QuickBooks Desktop Premier and Enterprise do manufacturing. QuickBooks Online and Desktop Pro do not.

[@halemanjr21]

Hector, I have two employees (I'm production supervisor), they work in acct. Dpt. they doesn't speak English, is possible get QuickBooks literature in Spanish for them?

[@ridanmahmood5813]

How to edit or cancel an old build assembly

[@HectorGarciaCPA]

You need to delete it

[@gwurd]

Thank you for the information; it is very helpful. I am using Quickbooks Premier Plus Manufacturing and Wholesale Edition 2023. My "Cost" field shows the drop down menu, but it is not active. I cannot choose a cost like global preference, user defined , or BOM. Why would this menu not be active? I can enter a value manually, but we would like for the BOM to automatically fill this field. Do I need to change to a different Industry Edition?

[@HectorGarciaCPA]

Do you have multiple currencies turned on?

[@gwurd]

@@HectorGarciaCPA No, I am set up for one currency. I did try changing editions to retail, general business, and they all leave that drop down menu inactive. I can see the menu, but it will not let me toggle between the choices you show in the video.

[@sophiestorontolife6566]

Hector, Quickbooks online can be used in manafacturing company? I heard about that QBS online is no good for manufacturing company which has many of inventory, is that so? Our new company is a manufacturing company, I don't know how to make a dicision. Thank you so much! your videos are the best !

[@HectorGarciaCPA]

Yeah QB enterprise Platinum is good for manufacturing

[@sophiestorontolife6566]

@@HectorGarciaCPA thank you so much! But enterprise platinum is online or desktop?

[@bilalather4268]

Is there any way to outsource assembly service?, but material is our own, they just assemble it and return to us.

[@HectorGarciaCPA]

It would work the same way.. you just need to add the labor cost

[@manarulhidayat3760]

Hi Hector, I want to ask Does the Assembly & Disassembly process change the Inventory Stock Qty ? Sample : BOM Parent Product : Z Component : Product A = Qty 1 and Product B = Qty 2 ASSEMBLY In Inventory Stock I have Product A = Qty 1 , Product B = Qty 2 and then I did Assembly Product Z Whether in the stock inventory will be formed as follows: Product Z = 1 Product A = 0 Product B = 0 DISASSEMBLY In Inventory Stock I have Product Z = Qty 1 and then I did disassembly Product Z Whether in the stock inventory will be formed as follows: Product Z = 0 Product A = 1 Product B = 2 Please your advise, thanks a lot

[@HectorGarciaCPA]

Sorry, this is too long to answer in a KZbin comment. If you want to hire a consultant from our firm, call 954-414-1524 9a-5p EST

[@cinderussell8313]

I built an assembly and noticed when I ran a report it showed that it was pending. when you look at the items that are pending it shows that there is zero and have already been taken out of inventory on a build. Then why is it showing pending?

[@HectorGarciaCPA]

Probably another transaction dated before affected the inventory

[@ogechukwunwankwo3075]

Hi Hector. I work in manufacturing company that is into water hose production. I use QuickBooks desktop 2014. I find it difficult to build assembly of the hose. Please can you help me on the bill of materials?

[@HectorGarciaCPA]

There are several videos that explain it

[@hvactechoffice4355]

Dear sir how to activate cost use global preferences

[@HectorGarciaCPA]

In the preferences

[@mariasolis803]

How can I create a pick list for BOM

[@HectorGarciaCPA]

You cant

[@YourBrainOnReligion]

Your videos have been very helpful! Thank you! I do have one question though: When you're adding items (which will later be put into an assembly), is it okay to leave the "Sales Price" field blank? I suspect so as they allow you to; however, I cannot find confirmation anywhere. This should not throw something off somewhere down the line since these items are never pieced out individually.... right?? I hope my question makes sense! :) Thank you again!!

[@HectorGarciaCPA]

sales price is not a required field.

[@faisalmasood5986]

How do i get cracked verison of QuickBooks Premier and QuickBooks Enterprise ?

[@HectorGarciaCPA]

No

[@hkathuria]

Hello Sir, Is there a way that assemblies are auto build if invoice is created ? Thanks for your response.

[@HectorGarciaCPA]

No

[@onyekachiaugustine8201]

Please I am making a switch to Accountant Role in a manufacturing concern. I need to get it right from the beginning, I have no prior praxtival knowledge in the sector. The company is into Manufacturing of food ingredients and beverages

[@HectorGarciaCPA]

I have a whole training series about this topic. Is $500 Hectorgarcia.teachable.com

[@maysemsaeed8182]

Hi, i need to contact you ?

[@alliewightman]

Can you assign a class to a build? When your average cost is higher than your new build price it pulls the differences out of COGS it there any way that this will not happen?

[@HectorGarciaCPA]

You can’t. It will always avg. cost regardless

[@alliewightman]

@@HectorGarciaCPA (ps your videos rock) do you know of a way to assign a class to a build assembly? Or map it to an asset account on the balance sheet to be written off later? thanks

[@sajithsuhaifdeen932]

Thank you for the video. I could not find the inventory menu next to employees in order to build assemblies

[@HectorGarciaCPA]

Is the edition of QB that you have installed.

[@sajithsuhaifdeen932]

@@HectorGarciaCPA it is the Quickbook Enterprise Solutions E18.0

[@HectorGarciaCPA]

You must reinstall and select “manufacturing and wholesale” as the version.

[@sajithsuhaifdeen932]

@@HectorGarciaCPA Thank you very much

[@jamesmares4206]

How to xreate an assembly in Desktop Pro

[@HectorGarciaCPA]

You cant.. need Premier

[@jamesmares4206]

@@HectorGarciaCPA thank you I was. Struggling to do the impossible

[@claudiacox9382]

Very informative. In Enterprise, I set up a use car dealership using assemblies to add all the cost to the finished product. The non-inventory items such as transport, detailing, mechanical service and body work. The costs of the non-inventory items can change daily depending on the vehicle. What frustrates me is if I enter all the components and build the assembly . Then I find that I have to add an item to the original build. When I delete the assembly build and go to the assembly item all the cost have changed from the original costs entered due to the daily changing costs of the non inventory items being billed and paid. Can you tell me what I am doing wrong.

[@HectorGarciaCPA]

Claudia Cox don’t use Assemblies for used cars... use a unique inventory part for each and adjust the value as you go.

[@rexespiritu6153]

Hi Claudia, the "Inventory Assembly" Item in the Inventory List pertains to products to be built/produced in a manufacturing type of business. Since you are engaged in a Used Car Dealership, therefore, the Standard Costing procedures in Cost Accounting shall apply. For costing purposes, you can do it first in Excel to arrive at the new cost of a certain car in bringing them into the good shape and/or perfect condition. All these used cars will be part of your Inventory at the Balance Sheet - FG USED CARS and will be entered either individually or by batch in the Item list as "INVENTORY PART".

[@rexespiritu6153]

Definitely, if you changed occassionally the cost of the non-inventory items that forms part also of the BOM of your finished goods, therefore, the cost of the Assembly Item will also be affected thru cost updating.

[@mudassirnaeem3447]

Q. How to make the multiple assembly? Please guide me!

[@HectorGarciaCPA]

One at the time

[@mudassirnaeem3447]

@@HectorGarciaCPA yes

[@4556031]

Do Quickbooks online PLUS have the option of assembly/ manufacturing?

[@HectorGarciaCPA]

Ghulam Ali no, only QB Desktop

[@4556031]

@@HectorGarciaCPA in fact, our finished goods are Food/ meal, and we want to enter Recipes of dishes. Could you pls share some pricing details of QB desktop with 5 users.

[@shahoodgmail]

Is there a way to charge/build overheads in the cost of the finished inventory item?

[@HectorGarciaCPA]

Shahood ul Hassan not really, because overhead comes from multiple accounts... it you can create an Service item that points to an expense account that can be added to the assembly, kind of like the same way you would with payroll

[@phoolAlvi]

@@HectorGarciaCPA what about labour cost??

[@rajangurung9284]

Sir, is this function available also at Desktop premier 2020 US Version.

[@HectorGarciaCPA]

Rajan Gurung yes

[@rajangurung9284]

@@HectorGarciaCPA I have found it. Thank you.

[@acuradoors4745]

Hey Hector, Is there a way we can import assembly items through excel ?

[@HectorGarciaCPA]

Acura Doors the assembly items yes.. but not the BOM’s... you need to use a 3rd party tool for that.

[@viviannesegura4601]

Do you know what 3rd party tool to make BOM's? Thanks@@HectorGarciaCPA

[@DavidSaquing]

Is there a way to un-assemble an assembled item? Thanks.

[@HectorGarciaCPA]

David Saquing no... you need to do an inventory adjustment

[@DavidSaquing]

Thanks

[@rexespiritu6153]

In reality or in the production process, why you need un-assemble the assembled items? Very costly! Build Assembly or Production Report (Daily) is just the support or recording process in the producing such a Finished Goods and or Sub-Assemblies. I think it is illogical to disassemble it. Therefore, it might be considered as Scrap Materials and needs to make an Adjustment and create an account in the Chart of Account to record these scrap materials.

[@jorge-sw3wh]

Hector....from what I understand the enterprise is the top of the line when it comes to assembly right? In qbooks online I don't think we have all that

[@futureconceptz112204]

Hello, Im new to Inventory Assemblies. I encountered an issue that i see you didn't cover.. I would love to speak to you actually if you have a chance.. Number is C: 347-256-3530 / Question? : After invoicing the build assembly: i need my warehouse team to see what exactly goes into making that built assembly.. why does my finished invoice not show all items in the finished good... ?? Thank you .. I speak spanish as well if your more comfortable.. Thank you

[@HectorGarciaCPA]

Cesar Florez i am not sure exactly what your question is.... however, with item groups it may get u want

[@noelkisnel7640]

All of my problemes are solved