Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Get 50% OFF QuickBooks for 3 months*
Buy nowI have product which I buy in bulk (5 pkts/case). We sell that item in Bulk and individual packs. How do I make sure that Cost of Goods Sold and Sales of Product for both Bulk and Individual packs is tracked correctly? Any ideas would be helpful. We use Quickbooks Online version.
I can share some tips on how you can track them correctly, SanjayPatel8rs,
When you purchase products that you resell to your customers, you'll have to set them up as inventory items in QuickBooks. This way, you'll be able to track the sale of each product and stay on top of what you have in stock. To get started, you'll have to turn on the Inventory Tracking feature. I'll show you how:
Once done, you can now enter the inventory items and services you sell into QuickBooks. Feel free to visit the articles below to be guided in doing it:
Add service items (these are the services you sell to your customers)
Please know that QuickBooks doesn't track quantities for services, non-inventory items, and bundles. It also uses the FIFO (first in, first out) concept in handling your inventory accounting. The program will always consider the first items purchased to be the first units sold and will adjust your assets and COS (Cost of Sales) accordingly whenever sales of inventory items are entered.
After setting up all your inventory products, you track them when they sell by issuing an invoice if you’ll get paid later or creating a sales receipt if your customer paid on the spot. Keep in mind that only the COGS account is affected when you sell inventory items on invoices or sales receipts.
To learn more about how the Inventory Tracking feature works, you can read this article: Set up and track your inventory.
Additionally, here are some resources that you can visit help manage your inventory in QuickBooks Online:
Visit us again here if you have any other concerns or follow-up questions. We're open 24/7 and always ready to help.
Consider having an additional app with the unit measurements feature to integrate with your QBO account.
What app do you recommend?
We have this issue on a very small scale. We buy cases of product and sell by the case or sell singles. We had set up both case and singles in items — but since we never purchased singles (only cases), QuickBooks did not add a value when we adjusted inventory to minus a case and add 6 single units.
To get around the issue and have proper inventory count and proper valuation, we now create a bull from a dummy vendor (Boxes to Singles) and record the negative number of cases with the positive number of singles. The “cost” of the singles is added manually to offset the amount of the cases “returned”. The bill amount is zero.
I think this only works for us because, as I said, it is on a very small scale and
it applies to only a few products and staff record when cases are allocated to non-case sales. Not sure if it would work with la greater number of items and higher sales.
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