Intermediate

How to Create Stock Items and Stock Groups in Tally

Posted on by Rishit Shah
Stock Items and Stock Groups in Tally
10
Jan

Stock Items and Stock Groups in Tally are very much important for maintaining stocks in Tally.

It is very efficient and effective way to calculate all major aspects of stocks in any kind of business.

Tally helps with some of the awesome features about stocks like:

  • Quantity
  • Rate
  • Value
  • Consumption
  • Gross Profit
  • Gross Profit (%)
  • Opening Balance
  • Closing Balance
  • Stock Valuation methods such as FIFO, LIFO, Average Price and many more

These details are very helpful for a business to make good decisions.

If you want to master Tally, creating stock items and stock groups is one of the important functions of Tally.

As the name suggests, a stock item is a single item of your stock.

For example, if you have an electronics business, following can be your stock items:

  • Mobile
  • Earphones
  • Mobile Covers
  • Screen Guards
  • Micro SD Cards
  • Chargers
  • Charging Cables

And many more things which you have in stock in your shop.

So, let’s say, you have some of the below things in your shop right now.

  • 25 Mobiles
  • 50 Earphones
  • 55 Screen Guards

Then, it can be said that your stock consists of total (25+50+55) 130 numbers of items in stock.

If you have any other business, you can create simple stock items and manage your stock efficiently in Tally.

Now, let’s see you how you can create stock items in Tally.

In this example, I will be creating 3 different stock items listed above.

So, that would be

  • 25 Mobiles
  • 50 Earphones
  • 55 Screen Guards

It is very much easy and simple to create all 3 of them in less than a minute if you know how to create them.

As we already have a balance of units, I will also add Opening Balance while creating the stock items.

Take a look at the following pictures and create a stock item exactly the same way with all the same configurations.

From Gateway of Tally,

  • Go to Inventory Info.
  • Then, go to Stock Items
  • Then, select Create under Single Stock Item

Now, see the picture below and create the stock item for 25 Mobiles for ₹15,000 per unit.

Creating a Stock Item in Tally
Creating a Stock Item in Tally

Likewise, create stock items for 50 Earphones for ₹400 per unit and 55 Screen Guards for ₹200 per unit as shown in the picture.

Creating a Stock Item in Tally - Earphones
Creating a Stock Item in Tally – Earphones
Creating a Stock Item in Tally - Screen Guards
Creating a Stock Item in Tally – Screen Guards

Did you see noticed the Units option while creating Stock Items?

That is the Units of Measure which I have discussed at the end of this post.

This is how you can create Stock Items and Stock Groups you will learn in a few minutes in Tally.

It is very easy and simple to do so.

Now let’s create Stock Groups.

Creating Stock Groups in Tally

Stock Groups in Tally further divides stocks in different groups for better understanding of stocks.

This will give us a much better look and understanding of stock items and stock groups in Tally.

Even in the future if we look at the stock items and stock groups in Tally, we will know the differentiation easily.

Let’s take the current example.

We have created 3 different Stock Items which are:

  • Mobile
  • Earphone
  • Screen Guard

So, if we want to group the above stock items, they will be like this.

Mobile will come under a Group called Mobiles.

Earphones and Screen Guards will come under another Group called Accessories.

By doing it this way, it will be easy for anyone to search the item easily.

You will also have a good understanding of different types of stocks you have on the basis of Grouping.

Currently, we have all the items under same Stock group called primary.

Primary is pre-defined Stock Group in Tally.

Now, what we will do is create 2 groups which are Mobiles and Accessories.

Then, we will alter the stock items and assign them proper groups instead of just primary.

Let’s do this.

Creating Stock Groups in Tally

From Gateway of Tally,

  • Go to Inventory Info.
  • Then, go to Stock Groups
  • Then, select Create under Single Stock Group

Then create 2 stock groups as shown in the pictures below.

Creating a Stock Group in Tally - Accessories
Creating a Stock Group in Tally – Accessories
Creating a Stock Group in Tally - Mobiles
Creating a Stock Group in Tally – Mobiles

Now, as we have created two different stock groups, you have to do one last thing.

And that is to alter the stock items and assign them the groups so we can form combination of stock items and stock groups in Tally.

So, again:

From Gateway of Tally,

  • Go to Inventory Info.
  • Then, go to Stock Items
  • Then, select Alter under Single Stock Item

Then select Mobile once again from the list.

This time going through the screen, select Mobiles for Under option as shown in the picture below.

Altering Stock Items in Tally
Altering Stock Items in Tally – Mobile

In the same way, alter Earphones and Screen Guards and in them select Accessories for the option Under.

Altering Stock Items in Tally - Earphones
Altering Stock Items in Tally – Earphones

We have grouped the stock items and now it is very easy to find different stock items with the help of groups.

This is the best way to use Stock Items and Stock Groups in Tally.

The reason, I have made you alter the stock items for grouping because I want you to learn how to alter a stock item also.

So, that will be a bonus learning for you.

Creating Units of Measure in Tally

Almost every business has stocks and stocks have units.

Let me explain it to you in a simple way.

For example, you are in a business of electronics and you sell mobiles, accessories, gadgets etc.

Your stock items would be mobiles, accessories, gadgets etc.

And your unit of measure will be numbers.

You say, I have a stock of 25 mobiles and 25 is a number.

If you are in dairy business which sells milk and other milk products.

In this case, you will say I have a stock of 30 liters of milk today and the unit of measure is liter.

In Tally, you can create different units of measure with whatever name you want. 

So, if your business is somewhat different, then don’t worry at all. You can do all of that in Tally.

To create a unit of measure in Tally, you need to follow the steps, I’m telling you right now.

First of all, from Gateway of Tally,

  • Go to Inventory Info.
  • Then, go to Units of Measure
  • Then, select Create

Create Unit of Measure (No – Numbers) as shown in the picture below.

Creating Units of Measure in Tally
Creating Units of Measure in Tally

Want to know what Number of decimal places mean, watch the video. But, put it to 2.

This unit of measure will be used while creating stock items.

In short we attach Stock Groups and Stock Items and have units for the stocks in Tally vi Units of Measure in Tally.

Stock Items and Stock Groups in Tally

A Quick Exercise for you

From Gateway of Tally, go to Stock Summary and comment down below what you see.

This was the creation part and check out this post to know how to use Stock Items and Stock Groups in Tally.

Rishit Shah

I am a CA. Finalist and a big fan of Tally. I like to share knowledge and that is why I have started TallySchool.

87 thoughts on “How to Create Stock Items and Stock Groups in Tally”

    • Rishit Shah says:

      Hi, Abid!

      It is easy.
      Once you create stock items and pass purchase and sales entry, you can see unit wise sale and profit.

      You just have to go to Stock Summary from Gateway of Tally.

      Then press F7 and you will see what you wanted.

      Reply
      • stuti mohanty. says:

        may i just thought now on tally inventory info. in there entry for purchase Que.: manufacturing journals all Que.: and multi- currency all Que.: active actual Biled Qty. Que.: discount Que.:: expiry date Que.: all Que gives me for practice me

        Reply
  4. Suresh Jain says:

    Nice video sir… Got few doubts
    1) What is difference between stock groups & stock categories ?
    2) While creating group you have set can quantities be added field to NO ? not clear
    3) What is difference between single group & multiple group ?

    Kindly provide your contact details

    Reply
    • Rishit Shah says:

      Hi, Suresh!

      There is not much difference between stock groups and stock categories.
      For example, you can set Mobiles, Computers as groups.
      Further you can set iPhone, Samsung etc as categories.

      Quantities of items to be added means number of stock items added in that particular group.

      Difference between single group and multiple groups is same as single ledger and multiple ledgers.
      They just help you to create more groups fast same as ledgers.

      Reply
  5. Raj says:

    Rishit Sir,
    Thank u so much for sending my precious tally lessons everyday .. Even now i am feeling master of tally after studying ur tally lessons.

    Reply
  6. Godwin says:

    Rishit. Good work, God will bless you and make your dreams realizable. I am beginning to fall in love with Tally especially as it will help me in my job as a stores officer. However, i will be interested in the full package that will make me a master in Tally as you. Do you have any comprehensive book on it? Great work.

    Reply
  7. adhanya says:

    hi sir , First of all thank you for your easiest way of learning in tally.L hope you are correct person to solve the problem and i have some mistake on accounting feature so, not displayed in inventory and stock i don’t know what i do because i’m learn tally in few days only
    so pls rply the solution of this problem

    Reply
  8. Satheesh Kumar says:

    Whether there is any options in tally for creating Sub groups or sub category for inventory, because my inventories are having 5 layers. Please reply

    Reply
  9. Melwin says:

    Very easy to understand. Really a great video related to stocks. My suggestion is please solve a big problem including inventories so that I will be very helpful

    Reply
    • Rishit Shah says:

      Hi, Melwin!

      I have explained including inventory which is called stock items.

      Are you trying to say anything else which I am unable to understand?
      Please comment it, if it is so.

      Reply
      • Soumyajit Banerjee says:

        Hi, Rishit
        I read your article regarding Inventory. I’m working with a papermill. We manufacture industrial grade paper.Now the problem I’m facing is we have 4 /5 quality like Testliner,fluting, coreboard each quality have different Grammage and sizes like we produce Testliner 125 gsm 1050 mm,1250mm,1100mm
        fluting also same size and grammage.
        We need no. of reels and quantity produce in each quality grammage size. Please help to know about the entry .

        Reply
        • Rishit Shah says:

          Hi, Soumyajit!

          There are different ways in which you can categorize your stock items.

          You can make a group called Testliner. Then in that group you can create a sub group for 125gsm. Then you can create stock items for 1050 mm, 1250mm and so on under that group.

          Reply
          • Idowu says:

            Rishit,

            Thanks for this great lesson, I have similar problem with Soumyajit, pls after when creating group items like testliner under what is it going to be, i.e Primary or Reel.
            thanks

          • Rishit Shah says:

            Hi, Idowu!

            That is the question of two units.
            Put quantity as the units and number of reels in the narration or description.

            For example, you can set 5 125gsm units of 1050mm testliner produced. And then calculate reels on your own and put it in the narration or description.

  10. SURESH says:

    Sir
    How to create site expenses
    Our company is a infra company. we are dealing with different sites
    How to include site expenses and stock

    Reply
  11. Prateeksha singh says:

    Hi rishit
    Thank u for the video update day to day. I have easily learn the tally much. And I am feeling like master of tally. Thank u very much

    Reply
  12. Laxmi says:

    I need in stock item like mobile phone then what sizes of mobile phone and which grades it is like samsung,vivo,micromax

    Reply
    • Rishit Shah says:

      Hi, Laxmi!

      You can create Stock Groups on the basis of companies such as Samsung, Vivo and Micromax.
      Then, you can create Stock Items like Samsung Galaxy S8, Samsung Galaxy S8 Edge and so on.

      This will solve your problem.

      Reply
  13. Shantilal Patel says:

    Hi Rishit,

    Appreciate your efforts on helping out people with understanding and learning tally. Your Posts and Videos really HELP 🙂
    One quick question for you
    I Have created a Stock Group and few Stock items under that group. Now my pricing is stock item-wise. However, I could locate stock item but cannot display stock group name in invoice printing. Can you help how can I achieve that?

    Thanks,
    -Shantilal

    Reply
  14. Femis says:

    Hi Rishit,
    I have just started with tally and your explanations are very helpful.
    I have a few doubts:
    Can we delete a stock item created?
    I cant change the units in a stock item i had created earlier. Is it not possible to alter a unit in a stock item once entered?
    Thank you for your time and consideration.

    Reply
    • Rishit Shah says:

      Hi, Femis!

      Yes, you can delete a stock item you created but for that you also must delete all entries in which the stock item you wish to delete is used.

      No, it will not be possible to change the units once a stock item is used in entries.

      Reply
  15. Harsh says:

    Sir I want create stock list of my business in tally I.e sarees and suits and I have many sarees and suits of same price and different price so how can I do it.

    Reply
  16. jitu says:

    Hello sir I’m jitu borah work at tally erp 9 6.0.2 version. In business shop. Im creating a stock item in my company but wrongly entry this unit of measure. I change this unit of measure but not do it. How can i do it.please solution this process.

    Reply
  17. Ramesh says:

    I watched your explanation stock items, stock groups under stand but why S comes sometime as first and sometime last. Ex:Mobiles,Earphones, and S. What S means? Very much appreciate your precise explanation plz.

    Reply
  18. Yashovardan K says:

    Dear Sir, could you please mail me the process for getting a DVD of Tally.ERP 9 or any link available.? Also your mobile number too. Think that it’s an honourable request…..

    Reply
  21. vishnu prasad says:

    MY COMPANY IS A BUILDING MAINTENANCE COMPANY AND ALSO WE DOING LPO WORKS FOR OUR BUILDINGS. We are purchasing some of the materials from dubai as stock and we use these materials for using for the maintenance in our buidings .we have 29 building maintenacne in abudhabi .so how can i show in tally these things like which flats or villa these stock items are expended and also these expenses need to show in as per the project name .can u help me sir.

    Reply
    • Rishit Shah says:

      Hi, Vishnu!

      This is a very complex scenario.
      I am assuming you are in Dubai or your accounts are being made for Dubai.

      When you expend your stock items, you can specify the name of the seller as different flats or villas.
      This will automatically show accounts as per the projects name.

      Reply
        • Rishit Shah says:

          Hi, Vishnu!

          For example, you have 1 stock item which you used one flat and one villa.

          The expenses ledger will be Abu Dhabi Flat No. 1 and stock item name we assume to be windows.

          So when pass the entry, you will know total expenses of Abu Dhabi Flat No. 1.

          Similarly, you can also know the number of items used in Abu Dhabi Flat No. 1, when you open that ledger and see it.

          Reply
  23. Mandeep Kaur says:

    Sir , thanks for this online course. i wants to request you that you should give us exercise for practice on the topic that you learn us daily.

    Reply
  25. vishnu prasad says:

    Hello sir,

    i tried to create sock items for the company and it shows in the balance sheet as closing stock .I need one more advice from you that i want to use soem of these materials for our building maintenance day by day .For eg if i have stock of shower mixer qty : 100 , rate per pcs 20 total 2000 then ,from this i took 5 quantity for one of our building maintenance .How i will show this in tally .please advice on it .In which voucher i can show these transfers.

    Reply
  27. Rinzin lhendup says:

    after crossing cheecking the stock summary we can find the list of stocks that we have entered after reading your instruction

    Reply
  28. Rinzin lhendup says:

    HI Rishit your tally class have helped me a lot..i learn a lot but your sweet phrase says(if you want to master the tally creating stock items and group is one of the important function) i really loved it.and i did it by regrouping and all but i am little confused when we have to group stock items and stock items

    Reply
  29. Rinzin lhendup says:

    hi Ritish i have already create stock items in my tally like cgi sheet .30mm .4omm .50mm .63mm with ft units now i wanted to book this stock items in groups i tried like what you said but i still have problem in altering the stock item to group stock please do suggest me

    Reply
  30. Jain says:

    Hello Rishit Bhai,
    I want to know is it possible to displace – Qty (Pcs) – Gross Weight – Net Weight – Column In stock items as well as in invoice? Is there any way out for this?

    Reply
    • Rishit Shah says:

      Hi, Simon!

      Empty stock groups would be of no use. Therefore there are stock items in stock groups.
      Still, if you want you can create Stock Groups in Tally which are absolutely empty. 😉

      Reply
  32. Praveen says:

    How to link Stock Group with Accounts Group in Tally? e.g. Raw Material (Stock Group) is to be group under Inventory (Accounts Group).

    Reply
    • Rishit Shah says:

      Hi, Praveen!

      You do not need to link Stock with Accounts.
      Just set the option of Integrate Accounts with Inventory option to Yes in Accounting Features.

      All the inventory will now show up in the Balance Sheet and Profit and Loss Account in Tally.

      Reply
  33. Rupa says:

    Hey Rishit, first of all thanks a ton for helping all of us out.
    Kindly help me out with a problem that i am struck for too long with my client. Company is a trading concern.we have created all stock items individually as per our order BUT
    They purchases some products in KITS and sells them in KITS and also individual wise (only selling a part of kit). so i am unable to get accurate stock.There are many products on our system showing negative stock.How to link kits to individual products so that when we buy or sell in Kits or individually, stock reflects accordingly? Is it possible in tally? Kindly guide me to a solution

    Reply
    • Rishit Shah says:

      Hi, Rupa!

      It is possible to have a solution for your problem.
      You need to create a stock item called Kits and whenever you sell them in kits, you need to create a stock journal entry for that.
      In that entry, transfer the stock item that is in the kit.

      By this way, you can create kits whenever you want to buy or sell them and when individual items are being bought or sold, you can use indiviudal items as well.

      Reply
  35. Ms Myo Chaw Chaw Ei says:

    Dear Rishit Sir
    I create stock items in multiple stock items, how can I delete these items. Please help me sir.

    Reply
    • Rishit Shah says:

      Hi, Myo!

      Go to the alter option in stock items and press ALT+D to delete them.
      If you have used the stock item anywhere in tally, you will not be able to delete it unless you delete that entry where the stock item is created.

      Reply
  36. Aniket Shukla says:

    Hi Rishit,

    First of all thanks for all the stuff you provided to us. It really helped me alot. I have one doubt that while starting a new company or business when we were creating stock item n all , is it necessary to show the items in the opening balance. As the company has started it’s business newly, so it must be purchasing first. Not making entry in the opening balance will make any difference?

    Reply
  37. Ranjan Philip says:

    Dear Rishit, Thank you for your Educational video.
    I have a product with different serial numbers for eg. Samsung S9 Mobile 10 nos but all with different serial numbers.
    How do i create stock with these serial numbers and recall them when doing a sale?

    Reply
  38. Aashaq says:

    Sir i love ur experience in tally. Sir stuck in a small issue. Issue is when i use purchase voucher to fill the items than later Quantity, Rate and Amount. When i fill the Quantity e.g 200pcs. I can fill only amt. It should be shown in nos, strips, pieces etc and how to fill the Rate amount.

    Reply
    • Rishit Shah says:

      Hi, Aashaq!

      That is because, while creating the quantity, you did not insert units of measure i.e. no, strips, pcs and so on.
      Alter the stock item and enter the units.

      Then you will see them.

      Rate amount is per pcs or nos. You can enter it and the total amount gets calculated.

      Reply
    • Rishit Shah says:

      Hi, Agesha!

      We can create stock accounts or stock items whenever we require it.
      We can create it before the ledgers but if we get to know the requirement of stock item while passing the entry, we can create a stock item at the time of doing an entry also.

      Reply

Have any questions or doubts, comment it...