Lesson 29 of 48 โ€“ Stock Item
58%

๐Ÿ“ฆ Stock Item in Tally Prime

A Stock Item is an individual product or material that a business purchases, stores, manufactures or sells. Every physical product maintained in inventory is created as a Stock Item in Tally Prime.

Lesson Objective Learn how to create Stock Items, assign Stock Groups, Categories and Units, manage opening balances, GST details, pricing, reorder levels and inventory reports.
1. What is a Stock Item?

A Stock Item represents an individual inventory product that can be purchased, sold or stored.

Business Example Stock Item
Computer Shop Dell Inspiron Laptop
Mobile Shop Samsung Galaxy A55
Medical Store Paracetamol 500 mg
Furniture Shop Executive Office Chair
Grocery Store Basmati Rice 25 Kg
2. Why are Stock Items Important?
  • Maintain product-wise inventory.
  • Track purchase and sales quantity.
  • Calculate stock valuation.
  • Generate inventory reports.
  • Monitor stock availability.
  • Manage GST and pricing.
  • Support reorder planning.
  • Improve inventory accuracy.
Every inventory transaction in Tally Prime is recorded against a Stock Item.
3. Information Required While Creating a Stock Item
Field Description
Name Product Name
Stock Group Product Group
Stock Category Optional Classification
Unit Nos., Kg, Litre, Box etc.
GST Details HSN Code & Tax Rate
Opening Balance Initial Quantity and Value
4. Example of a Stock Item
Field Example
Stock Item Dell Inspiron Laptop
Stock Group Computers
Stock Category Premium Products
Unit Nos.
Opening Quantity 15 Nos.
Rate โ‚น58,000
Total Value โ‚น8,70,000
The opening balance represents the stock available when inventory management begins.
5. Stock Item Workflow
  1. Create Stock Group.
  2. Create Stock Category (Optional).
  3. Create Unit of Measurement.
  4. Create Stock Item.
  5. Enter Opening Balance.
  6. Record Purchase Voucher.
  7. Record Sales Voucher.
  8. View Stock Reports.
Stock Items automatically update whenever Purchase, Sales, Stock Journal, Receipt Note, Delivery Note, Rejection In or Rejection Out vouchers are recorded.
6. How to Create a Stock Item in Tally Prime

Before creating a Stock Item, ensure that the required Stock Group and Unit of Measurement have already been created.

Steps
  1. Open Tally Prime.
  2. Go to Gateway of Tally โ†’ Create.
  3. Select Stock Item.
  4. Enter the Stock Item Name.
  5. Select the Stock Group.
  6. Select the Stock Category (Optional).
  7. Select the Unit of Measurement.
  8. Enter the Opening Balance (if available).
  9. Enter the Rate and Value.
  10. Press Ctrl + A to Save.
Example
Field Value
Name Dell Inspiron Laptop
Group Computers
Category Premium Products
Unit Nos.
Opening Balance 10 Nos.
Every Stock Item must belong to a Stock Group. Stock Category is optional.
7. GST Details, HSN Code & Opening Balance

You can maintain GST information and opening stock while creating a Stock Item.

Field Purpose
HSN Code GST classification of the product.
GST Rate Applicable GST percentage.
Opening Quantity Available stock at the beginning.
Opening Rate Cost per unit.
Opening Value Total opening stock value.
Example
Field Example
HSN Code 8471
GST Rate 18%
Opening Quantity 20 Nos.
Opening Rate โ‚น50,000
Opening Value โ‚น10,00,000
Correct HSN Codes and GST Rates help generate accurate GST invoices and reports.
8. Pricing, Reorder Level, Batch & Expiry Details

Tally Prime allows businesses to manage advanced inventory settings for Stock Items.

Feature Purpose
Standard Cost Default purchase price.
Standard Selling Price Default selling price.
Reorder Level Minimum stock level before reordering.
Batch-wise Details Track manufacturing batches.
Expiry Date Useful for medicines and food products.
Manufacturing Date Tracks production date.
Batch and Expiry features are especially useful for pharmaceutical, food and FMCG businesses.
9. Display, Alter & Delete Stock Items
Action Purpose
Create Add a new Stock Item.
Display View Stock Item details.
Alter Edit an existing Stock Item.
Delete Remove an unused Stock Item.
Navigation
  1. Gateway of Tally โ†’ Alter
  2. Select Stock Item.
  3. Choose the required item.
  4. Modify details if required.
  5. Press Ctrl + A to Save.
A Stock Item generally cannot be deleted if it has been used in inventory transactions.
10. Common Mistakes While Creating Stock Items
Common Mistake Correct Practice
Creating duplicate Stock Items. Use unique product names.
Selecting the wrong Stock Group. Verify the group before saving.
Choosing the wrong Unit. Select the correct Unit of Measurement.
Incorrect HSN Code. Verify GST details carefully.
Entering the wrong Opening Balance. Check quantity and value before saving.
Ignoring Reorder Levels. Set minimum stock limits.
Not using Batch Details where required. Enable batch-wise inventory for applicable products.
Skipping periodic stock verification. Match physical stock with system stock regularly.
Incorrect Stock Item information can result in wrong stock valuation, GST errors and inaccurate inventory reports.
11. Real Business Case Studies

Let's understand how Stock Items are managed in different businesses.

Business Stock Item Purpose
Computer Shop Dell Laptop Sales and Inventory Management
Medical Store Paracetamol 500 mg Batch & Expiry Tracking
Electronics Shop LED Television Warranty and Stock Control
Furniture Showroom Executive Chair Warehouse Management
Grocery Store Basmati Rice Daily Sales Tracking
Manufacturing Company Steel Sheet Production Planning
Every product that is purchased, manufactured or sold should be maintained as a separate Stock Item for accurate inventory management.
12. Stock Item vs Stock Group vs Stock Category
Stock Item Stock Group Stock Category
Individual Product Collection of Similar Products Additional Classification
Mandatory Mandatory Optional
Used in Transactions Used for Inventory Organization Used for Analysis & Reporting
Dell Inspiron Laptop Computers Premium Products
Samsung Galaxy A55 Mobile Phones Flagship Products
Easy Trick
  • ๐Ÿ“‚ Stock Group = Product Family
  • ๐Ÿท๏ธ Stock Category = Product Classification
  • ๐Ÿ“ฆ Stock Item = Actual Product Sold or Purchased
13. Professional Stock Item Management Tips
  • Create Stock Groups before creating Stock Items.
  • Use meaningful and unique product names.
  • Select the correct Unit of Measurement.
  • Maintain accurate HSN Codes and GST Rates.
  • Enable Batch-wise tracking for medicines and food products.
  • Set Reorder Levels for fast-moving products.
  • Update purchase and sales transactions regularly.
  • Verify physical stock periodically.
  • Review Stock Summary reports frequently.
  • Take regular backups before making inventory changes.
Professional businesses maintain complete product information, including HSN Code, GST Rate, Barcode, Batch Number and Reorder Level for every Stock Item.
14. Practical Exercise & Interview Questions
Practical Exercise
  1. Create a Stock Item named Dell Inspiron Laptop.
  2. Assign it to the Computers Stock Group.
  3. Select Premium Products as the Stock Category.
  4. Choose Nos. as the Unit of Measurement.
  5. Enter an Opening Balance of 10 Nos..
  6. Enter HSN Code and GST Rate.
  7. Set a Reorder Level.
  8. View the Stock Summary Report.

Interview Questions
  1. What is a Stock Item?
  2. Why is a Stock Item created?
  3. What information is required while creating a Stock Item?
  4. Can a Stock Item exist without a Stock Group?
  5. Is Stock Category mandatory?
  6. What is the purpose of the Unit of Measurement?
  7. What is an Opening Balance?
  8. Why is the HSN Code important?
  9. What is the purpose of GST details?
  10. What is a Reorder Level?
  11. When should Batch-wise Details be used?
  12. Can a Stock Item be altered?
  13. Can a Stock Item be deleted?
  14. How do purchases affect Stock Items?
  15. How do sales affect Stock Items?
  16. Which reports display Stock Item details?
  17. Why should physical stock be verified?
  18. How do Stock Items help inventory management?
  19. What mistakes should be avoided while creating Stock Items?
  20. Why are Stock Items important in Tally Prime?
15. Lesson Summary
  • Learned the purpose of Stock Items.
  • Created Stock Items with Groups and Categories.
  • Configured Units of Measurement.
  • Entered GST Details and Opening Balance.
  • Learned Reorder Levels and Batch Management.
  • Compared Stock Item, Stock Group and Stock Category.
  • Studied real business examples.
  • Completed practical exercises.
  • Prepared for accounting interviews.
  • Improved inventory management skills.
Congratulations! You can now confidently create and manage Stock Items in Tally Prime, maintain accurate inventory records and generate meaningful inventory reports.

๐Ÿง  Quick Quiz

Which inventory master represents an individual product in Tally Prime?