cancel
Showing results for 
Search instead for 
Did you mean: 
stoew000
Level 1

Raw Inventory converted to final product

Good morning, I work for a manufacturer that receives raw material (different alloy compositions (silver, copper, etc...)) and turns it into pieces.  The company has never used QucikBooks to track inventory, and  I am looking to set this up. 

 

The way I see it is I will keep the raw material as an Inventory Part, and then from there, I will convert the Inventory Items that are made out of these raw materials, Inventory Assemblies (this makes sense to me).  One of the questions I have is, if the raw material inventory is checked in at a certain cost will my COGs be calculated correctly if I leave the cost section on the BOM empty?  I figure the raw material is assigned a cost already, the assembly is based on weight for the U/M.  So if I know the weight per one piece this should automatically calculate based on the total weight used, correct?

 

Next question:  If inventory was never tracked in the past, would it be best to do a manual count and true up the inventory this way?  Currently raw inventory is not being depleted, but when a sale is made, the specific item depletes finished good inventory that isn't there (hence the Inventory Assembly method that I believe should be used).

 

Thank you for the help.

1 Comment 1
IamjuViel
QuickBooks Team

Raw Inventory converted to final product

I thank you for the complete details you've shared, @stoew000.

 

I can share some so you'd be able to track your raw materials and finished product in QuickBooks.

 

First, you'd want to make sure to set up your raw materials as an inventory item. Also, you can enter the manual count of the raw material as its quantity on hand. Here's how:

  1. Go to the Lists menu.
  2. Select Item List.
  3. From the bottom part of the Item List window, click the Item drop-down.
  4. Choose New.
  5. Pick Inventory as the Item type.
  6. Enter the item details.
  7. Click the Ok button.

Once completed, you can now create an inventory or the finished product that you sold. You can refer to the screenshot below:
inventory assembly item

 

You can check this article to learn more about how to combine your inventory items to build finished goods

 

On the other hand, the Total Bill of Materials Cost field is not directly tied to the cost or avg cost values. This is the sum of the cost values of the components in the Bill of Materials as the total cost of the assembly. Also, the amount reflected on the Cost value field will not be updated automatically.

This is not used to calculate the actual cost of reports like profit and loss. Though, it will display a cost on the Item Listing and Price List reports. Changes made on the components does not affect the Average cost. 

 

Lastly, I've added these articles that can help you in maximizing the advanced inventory feature in QuickBooks:

 

The Community and I are here to help you in whatever way we can. Keep me posted and enjoy your day.

Need to get in touch?

Contact us