Solved

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.

Forum|Forum|6 years ago
January 16, 2020
1 reply
0 views

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.

QuickBooks Online

Best answer by SarahannC

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!

MorganB

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.

I

itsdave04Author

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

S

SarahannCAnswer