Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Solved! Go to Solution.
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:
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!
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.
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
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:
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!
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.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here