cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get unlimited expert tax help and powerful accounting in one place. Check out QuickBooks Online + Live Expert Tax.
JoeSweeney
Level 1

Inventory for services that change a part to multiple different parts of assemblies

We use QuickBooks Enterprise Solutions Manufacturing and Wholesale 24.0. We have a brass item that we bring in raw. That item is then sent out to one vendor for them to cut it in various ways. One is a bell, one is a beer tap, another is a bottle opener. They send it back to us transformed.

 

Sometimes we also send those items that are transformed to a second vendor to be powder coated.

 

These are in as a service right now. We ended up setting up the initial system having the raw brass item in the build for all these different build assembles that go on to make a final product. Then we have the services listed as well in the build along with another inventory part that goes into the assembly and packaging. 

 

Tracking this way doesn't allow me to know how many bottle openers or bells I can make because it's counting all the raw brass items as the same. Is there a way to transform them when we send it out to the new part they become for the build so I can know how many bottle openers I can make for example? 

 

For this we would send out the raw brass item to Vendor A, The inventory transfers to them. Then they return to us cut as a bottle opener. Our inventory should then receive back the bottle opener instead of the raw brass item. Then the build will have the bottle opener piece as part of the assembly. 

 

I hope I explained this well as I am taking over our inventory at our company but am not well versed in the accounting side of it beyond basic work with it. Our Accountant also is unaware of how to best do this. The only idea we can think of is setting up both raw parts and adjusting inventory on receipt but that seems less than ideal. 

 

Thanks,

 

Joe

3 Comments 3
MirriamM
Moderator

Inventory for services that change a part to multiple different parts of assemblies

Navigating the complexities of inventory management in a manufacturing setup can be challenging, especially when dealing with multiple transformations, Joe. Let's dive into how you can effectively manage the transformation of your raw brass items into various finished products like bells, beer taps, and bottle openers.

 

You can create a separate inventory items for each transformed part in QuickBooks Desktop (QBDT). This way, you can track each item individually. Here's how:

 

  1. Go to the Lists menu at the top of your QBDT account.
  2. select Item List.
  3. Click the Item button at the bottom left and select New.
  4. Choose Inventory Part from the Type drop-down menu.
  5. Enter the Item Name/Number (e.g., Bottle Opener, Bell).
  6. Fill in the necessary fields, such as DescriptionCost, and Sales Price.
  7. Click OK to save the item.

 

Next, record the inventory activities when you send out the raw brass and receive the transformed parts. After that, update your build assemblies to use the transformed parts.

 

To help you enhance your production practices, you can visit this resource: Combine your inventory items to build finished goods (assemblies). This article serves as a key resource for streamlining the assembly and tracking of your finished products, ensuring accuracy and efficiency in your inventory management.

 

Finally, consider consulting with your accountant to ensure your inventory is properly accounted for in terms of Cost of Goods Sold and assets.

 

In the fast-paced world of manufacturing, keeping track of the products you create is crucial to maximizing efficiency and ensuring a smooth production process. To support you in this endeavor, we invite you to explore our comprehensive guide: Track the Products You Manufacture.

 

We recognize that effective inventory management is a cornerstone of your business success, and we are genuinely excited to support you in optimizing these processes, Joe. Should any questions come up or if you need further assistance, don't hesitate to reach out. 

JoeSweeney
Level 1

Inventory for services that change a part to multiple different parts of assemblies

Thank you for this information. I will get with Accounting and let you know if we need any further help.

Bryan_M
QuickBooks Team

Inventory for services that change a part to multiple different parts of assemblies

I'm glad to see that the information provided by my colleague was helpful for you, Joe.

 

Let us know if you have additional questions about inventory management in QBDT. We'll make sure to provide the best respond. Take care, and enjoy the rest of the week!

Get answers fast!
Log in and ask our experts your toughest QuickBooks questions today.

Need to get in touch?

Contact us