Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
April 16, 2019
Question

Co-Packing Services Set Up

  • April 16, 2019
  • 1 reply
  • 3 views

Hi Everyone,

 

The company I work for uses a co-packer for two of their items.  We send all of the raw materials and packaging to them and they produce the pouches we need and send them all back in huge boxes.  We receive them, package them into their cases, and ship them out to our customers.  Here are my questions:

 

1.  They have the co-packing services set up as a service for one and "other charge" for the other item.  Shouldn't they both be set up as a service? They also have the account listed as an inventory asset account.

 

2.  Each item has their own number and a corresponding item (ex., item 100 and item 100-c) included in the build so it can pull in the materials used at the co-packer.  The co-packer has a build (including the raw materials and packing needed to make the item) and then there is another build used to package the product in our facility when it is received back. (co-packing item 100-c and the remaining packaging needed to ship out). The 100-c item is in our inventory valuation as an assembly item even though it always shows 0.  Is this correct?

 

3.  Lastly, when we send out the material to the co-packer, it's shown in QB as a transfer to an offside warehouse.  When it's received, they create an item receipt using the service and the other charge item number and use the cost the co-packer charges them.  The balance sheet shows the difference as that exact item receipt.  How do we receive the items back into our inventory?  

 

The items were not set up properly and I need to know how to create a better process.

 

Thank you so much for any help you can provide!!

1 reply

April 17, 2019

There is more than one way to handle this.  I didn't completely understand your process - so this is more discussion than answer. 

It sounds like the 'raw materials' you talk about are actually finished widgets that just need to be packed.

I am guessing that the 'warehouse transfer' process was chosen to help in reconciling the 'raw material' inventory and account for the items that are 'missing' while at the packer. 

The packing fee should probably be a 'service item' - other charge items are thinks that go below the first subtotal on an invoice.

You are using 'assembly item' which is good.  That probably means you have QB Premier (or Enterprise) - which also means you should access to use 'multiple units of measure'.  Look for this option. But how to use it depends on how you like to count your inventory.  If you count and sell by the case - then 'case of widgets' does need to become its own separate assembly item.  But if you tally the total widgets within all the different cartons then 'MUoE' is the way to go.

For separate items then the first assembly should be 1 raw widget + 1 pouch + 1 packing fee = 1 packaged widget. Second assembly (if no MUoE) would be +10 packed widget = 1 case (final sales item)

Not sure how 'item receipt' come into this - unless you are actually recording the assembly as a vendor purchase? Thats a different alternate QB path that bypasses the first assembly.

Any inventory and assembly items should have both Count and Value records in Inventory (unless theres no stock). Valuation is always zero sounds wrong - but im unclear.

 

 

 

mb722Author
April 17, 2019

Thanks for your response!

 

Sorry if my post was unclear.  I knew the item receipt was wrong and I was talking through another way to bring the items back into inventory.  My thought process was to bring them back in my using the first assembly which included the raw material and the packaging to make the pouch.  We know how many was made from the item receipt.  Then once they are packaged and "built", I can enter the second assembly build to bring the cases into finishing goods.  Correct?

IamjuViel
Level 8
April 17, 2019

Glad to hear to again from you, @mb722.

 

I'm here to share additional insights on how you can create and build your inventory assembly items.

 

To cover the labor cost in packing your item and other fees, you're correct in creating a service item for it.

  1. Go to Lists menu.
  2. Choose Item List.
  3. Click Item drop-down, then select New.
  4. Choose Service.
  5. Enter a desired name of the item and specific amount.
  6. Choose the Account where you want to post your property maintenance income and expenses.
  7. Click OK.

You'll also need to create an inventory item for each item or raw material that will be part of the inventory assembly.

 

Here's how to add an inventory item:

  1. Go to Lists menu.
  2. Choose Item List.
  3. Click Item drop-down, then select New.
  4. Choose Inventory Part.
  5. Enter a desired name of the item and specific amount.
  6. Choose the Account where you want to post your machinery maintenance expenses.
  7. Click OK.

 

Once completed, you can now create the assembly item with the service item on it.

 

By following this process, you'll  be able to track the total cost for each item included on each assembly.

 

Feel free to visit us here in the Community if you have other questions about creating assembly item in QuickBooks. I'm always here to help.