Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
SanjayPatel
Level 1

Buy products in Bulk and sell individually or bulk. How to keep accounting correct

I 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.

4 Comments 4
KlentB
Moderator

Buy products in Bulk and sell individually or bulk. How to keep accounting correct

 

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:

 

  1. Click the Gear icon, select Account and Settings.
  2. Choose Sales.
  3.  In the Products and services section, click the Edit icon.
  4. Turn on the Show Product/Service column on sales forms option.
  5. Turn on both Track quantity and price/rate and Track inventory quantity on hand options.
  6. Hit Save and then Done.

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:

 

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.

Fiat Lux - ASIA
Level 15

Buy products in Bulk and sell individually or bulk. How to keep accounting correct

@SanjayPatel 

Consider having an additional app with the unit measurements feature to integrate with your QBO account.

BECorp
Level 1

Buy products in Bulk and sell individually or bulk. How to keep accounting correct

What app do you recommend?

SharonRomanovsky
Level 1

Buy products in Bulk and sell individually or bulk. How to keep accounting correct

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. 

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us