How do I separate a bulk inventory delivery into individual flavors? I receive same item from 2 vendors, 1 sends in bulk @ $13, the other sends by flavor @ $16.50.

itsdave04 · ‎January 16, 2020

ie:
I receive 14pcs each of 24 flavors(336 pcs) for $16.50 per item from vendor A. (created sales item with $16.50 COG)

later:
I receive Bulk shipment of 336 pcs mixed flavors for $13 per item from Vendor B.

**I only sell by individual flavor**

How do I move product from bulk received inventory item into the individual flavors items in order to sell and retain the lower cost so my average COG is lower.

SarahannC · ‎January 16, 2020

Hello itsdave04, I agree with you.

We can manually adjust the quantity of the item. This way, the bulk "drink" will show as 180 quantity and the "cherry" will show as 11 quantity in your book.

The steps below will walk you through the process:

Go to Sales on the left side and select the Product and Services tab.
Locate the bulk item and click the drop-down arrow next to Edit under the Action column.
Select the Adjust Quantity option and enter the new quantity of the item. Once ready, you can now hit the Save and Close button.

I've added sample screenshots for additional reference:

You can also check this article for further information: Adjust inventory quantity on hand in QuickBooks Online.

Please get back to me if you have more questions about it. I'm right here and the Community people to assist you further! Thanks. Take care!

View solution in original post

MorganB · ‎January 16, 2020

Hi, itsdave04.

Thanks for joining us here in the Community. I'd like to offer my assistance regarding your question about bulk inventory.

The cost of goods sold (COG) is based off the items on a bill/expense. This amount is generated directly from what you receive from your vendors. There are a couple of ways to approach this situation. You could assign an item to a category, but the system won't recognize that you bought an item equal to 336 pieces. Or, you could say an item is 336 pieces and sell it that way, but QuickBooks wouldn't know what the individual flavors are. Lastly, you could break the bulk order down into pieces and flavors and sell it that way, perhaps even with a recurring transaction to make it easier. I'm including a few articles below that I believe you'll find useful:

It's never a bad idea to talk to your accountant to see which option would be the best fit. Please feel free to follow up with me here if there's anything I can help with.

itsdave04 · ‎January 16, 2020

Thank you for the quick response.

Some additional clarification:

Lets say the item is a drink that has over 20 flavors.

When I order from vendor A(original vendor for this "drink"), I get to pick my flavors and it ships/invoiced as I order - XX amount of each flavor of "drink". (multiple line items) I receive them individually in QB.

When I order from Vendor B, I get a random assortment of flavors and it ships/invoiced as - XX amount of "drink", but at a lower cost. (one line item)

I created an additional product/service for Vendor B called "Drink" bulk and I receive them as one item in QB

I will sometimes sell a large order to a customer for a discount on a random assortment of flavors as "Drink" Bulk. But I usually try to use the bulk order to replenish my individual flavor stock.

So if I receive an order of 200 Bulk "drink", What is the best way to then move 20 to "drink"cherry" from bulk "drink" so I can sell it and carry the low COG into the "drink"cherry COG average?

Example QB shows Bulk "drink" qty 200 and "drink"cherry qty -9. Of the 200 bulk "drink", 20 are cherry flavored. I need make my Bulk drink to show qty 180 and cherry to show qty 11. And the COG less than the original COG based on Vendor A's cost.

Sorry for the long explanation, I'm just not quite sure what to ask.

Thank you

SarahannC · ‎January 16, 2020

Hello itsdave04, I agree with you.

We can manually adjust the quantity of the item. This way, the bulk "drink" will show as 180 quantity and the "cherry" will show as 11 quantity in your book.

The steps below will walk you through the process:

Go to Sales on the left side and select the Product and Services tab.
Locate the bulk item and click the drop-down arrow next to Edit under the Action column.
Select the Adjust Quantity option and enter the new quantity of the item. Once ready, you can now hit the Save and Close button.

I've added sample screenshots for additional reference:

You can also check this article for further information: Adjust inventory quantity on hand in QuickBooks Online.

Please get back to me if you have more questions about it. I'm right here and the Community people to assist you further! Thanks. Take care!

RaphaelR · ‎April 14, 2023

Quick Books Online, in this operating model, would be "missing" on the "manufacturing" portion of the business process.

when you buy a MATERIAL taht will later be converted in a PRODUCT and in the process you change its properties (like you purchase a bundle with Random Drinks, than split that bundle and specialize them in Orange drink, Strawbery drink, etc) you are doin what is commonly known as Manufacturing / Productization.

Buy Materials from Vendor. Use Materials to define Products, and sell products.

in this process you would DEPLETE stock levels of Material A and increase stock levels of Product B.

For COGS calculation, the Materials used to assemble the product you sell will compose a portion of the costs of selling goods for that product (other costs may include packaging, effort to rebrand / relabel, restock and distribute the product to its selling point).

None of it is automatically handled in QBO and the concept of Materials vs Products is not present at all.

The closest QBO designed was bundles, which allow a "product composition" (so you could buy Materials as products ans sell them as bundles) but that is not viable as bundles do not allow you to setup price manually.

Also lacking is the definition of how to auto deplete the inventory of materials as products are sold (consuming from X manufacturer before consuming from Y manufacturer).

Better support seems to be available in Quick Books desktop.

Topics

Training

Community

Resources

How do I separate a bulk inventory delivery into individual flavors? I receive same item from 2 vendors, 1 sends in bulk @ $13, the other sends by flavor @ $16.50.