Stock Summary in Tally: View Inventory Levels, Valuation & Movement

Stock Summary in TallyPrime displays real-time inventory quantities, valuations, and godown-wise distribution for all items in your business. Access it via Gateway of Tally > Display > Stock Summary or Alt+G, and filter by date, godown, or item category for detailed insights.

What is Stock Summary in TallyPrime?

Stock Summary is a core inventory management report in TallyPrime that provides a snapshot of your current stock levels across all items and locations. It consolidates opening stock, purchases, sales, and closing quantities into a single, easy-to-read format. This report is essential for businesses that maintain physical inventory, whether you operate from a single warehouse or multiple godowns across different cities.

Unlike transaction-level reports, Stock Summary aggregates data to show you the net position of each item at a specific point in time. It answers critical business questions: How much stock do I have? What is its value? Where is it stored? Which items are slow-moving? This makes it invaluable for inventory planning, stock audits, and financial reporting.

How to Access Stock Summary in TallyPrime

Accessing Stock Summary is straightforward in TallyPrime. From the Gateway of Tally home screen, follow this path:

1. Press Alt+G or click Gateway of Tally
2. Navigate to Display
3. Click Stock Summary
4. Select your company name
5. Choose the date for which you want to view stock (defaults to today)

Alternatively, you can press Alt+G directly from any screen, and TallyPrime will open the Gateway. The keyboard shortcut is faster for regular users. Once the Stock Summary opens, you will see all items with their current quantities and values displayed in a tabular format.

Understanding Stock Summary Columns and Data

The Stock Summary report displays several key columns that help you understand your inventory position:

Column	Description	Example
Item Name	Name of the inventory item	Cement Bag 50kg
Opening Qty	Stock at the beginning of the period	500 bags
In Qty	Quantity received or purchased	1,200 bags
Out Qty	Quantity sold or issued	900 bags
Closing Qty	Current stock (Opening + In - Out)	800 bags
Unit	Measurement unit	Bag, Kg, Litre, Piece
Valuation	Total stock value at cost	Rs 40,000

Each row represents one item. The closing quantity is calculated automatically: Opening + Purchases - Sales = Closing Stock. Valuation is computed based on your inventory valuation method (FIFO, LIFO, or Weighted Average).

Filtering Stock Summary by Godown

If your business operates multiple storage locations or godowns, you can filter Stock Summary to view inventory at a specific location. This is especially useful for businesses with warehouses in different cities or retail chains with multiple branches.

To filter by godown, open Stock Summary and look for the Godown filter option in the report. Select the godown name from the dropdown list. TallyPrime will then display only items stored in that location, along with their quantities and values. You can also run the report for all godowns combined by leaving the filter blank or selecting "All Godowns."

This feature helps you identify which items are stocked where, balance inventory across locations, and make informed decisions about stock transfers or redistribution.

Stock Valuation Methods in TallyPrime

The valuation column in Stock Summary shows the monetary value of your inventory. TallyPrime supports three standard valuation methods:

• FIFO (First In, First Out): Assumes items purchased first are sold first. Useful in industries where older stock must move before newer stock.
• LIFO (Last In, First Out): Assumes items purchased last are sold first. Often used in commodity trading and manufacturing.
• Weighted Average: Values stock at the average cost of all purchases. Smooths out price fluctuations and is widely used.

To set your valuation method, go to Gateway of Tally > F11 (Accounting Masters) > Inventory Settings. Choose your preferred method, and TallyPrime will apply it consistently across all stock reports, including Stock Summary, Balance Sheet, and Profit and Loss statements.

Working Example: Stock Summary Calculation

Let us walk through a real-world example to illustrate how Stock Summary works.

Suppose you run a retail hardware store in Purnea, Bihar. You stock three items: Steel Rods, Cement, and Paint Cans. Here is your inventory position as of 31 December 2025:

Item	Opening Qty	Purchases	Sales	Closing Qty	Rate/Unit	Total Value
Steel Rods (kg)	100	500	350	250	Rs 150	Rs 37,500
Cement (bag)	200	800	700	300	Rs 400	Rs 1,20,000
Paint Cans (litre)	50	200	180	70	Rs 500	Rs 35,000

When you run Stock Summary on 31 December, TallyPrime displays this exact data. The closing quantity for Steel Rods is 250 kg (100 + 500 - 350), valued at Rs 37,500 (250 kg x Rs 150). The total inventory value across all items is Rs 1,92,500. This snapshot helps you understand your working capital tied up in inventory and plan cash flow accordingly.

Stock Summary vs. Stock Register: Key Differences

Many users confuse Stock Summary with Stock Register. While both are inventory reports, they serve different purposes:

Stock Summary provides a consolidated view of current inventory levels by item. It shows opening, purchases, sales, and closing quantities in aggregate. Use it for quick inventory checks, valuation, and financial reporting.

Stock Register shows detailed transaction history for each item. It lists every purchase, sales, receipt, and issue with dates, quantities, and parties involved. Use it for audit trails, reconciliation, and analyzing item-wise movement over time.

To access Stock Register, go to Gateway of Tally > Display > Stock Register. You can filter by item, date range, or godown to drill down into specific transactions.

Exporting and Printing Stock Summary

TallyPrime makes it easy to share Stock Summary with stakeholders, auditors, or your accounting team. Once you have the report open, you have several export options:

• Export to Excel: Press Ctrl+E to export the report as an Excel file. This allows you to perform additional analysis, create charts, or share with team members who do not have TallyPrime access.
• Print to PDF: Press Ctrl+P and select a PDF printer to save the report as a PDF file. Useful for email distribution or archival.
• Print to Paper: Use Ctrl+P to print directly to a connected printer for physical records.
• Email: Some versions of TallyPrime allow you to email reports directly. Check your Print dialog for this option.

Exporting Stock Summary to Excel is especially useful for businesses that need to reconcile TallyPrime data with external systems or perform inventory audits by comparing physical counts with system records.

Filtering and Customizing Stock Summary Reports

TallyPrime allows you to customize Stock Summary to focus on specific items, categories, or godowns. Common filters include:

• Date: View stock as of any past date to analyze historical inventory levels.
• Godown: Filter by single or multiple storage locations.
• Item Category: Show only items in a specific category (e.g., Raw Materials, Finished Goods).
• Item Group: Display items grouped by type for easier analysis.
• Cost Center: Filter by department or project if cost centers are assigned to items.

To apply filters, open Stock Summary and look for the filter options in the report header. Use arrow keys or Tab to navigate between filters. This customization helps you generate targeted reports for specific business needs without generating unnecessary data.

Stock Summary and Financial Reporting

Stock Summary data flows directly into your financial statements. The total stock valuation appears on the Balance Sheet under Current Assets as Inventory. During year-end closing, auditors often reconcile the Stock Summary with the Balance Sheet to ensure inventory values are accurate.

The stock movement (purchases minus sales) also impacts your Profit and Loss statement as Cost of Goods Sold (COGS). If closing stock is higher than opening stock, COGS decreases, improving profit. If closing stock is lower, COGS increases, reducing profit. This relationship makes Stock Summary critical for financial accuracy.

Common Issues and Troubleshooting Stock Summary

If your Stock Summary shows unexpected values or missing items, check the following:

• Date Mismatch: Ensure you are viewing stock as of the correct date. Stock Summary is date-sensitive and will show different values for different dates.
• Godown Filter: If items appear missing, verify that the godown filter is not restricting the view. Select "All Godowns" to see complete inventory.
• Item Status: Inactive or deleted items may not appear. Check that all items you expect are marked as active in the Item Master.
• Data Integrity: If valuations seem incorrect, run a data repair. Go to Alt+Y (Data) > Repair or F1 (Help) > Troubleshooting > Repair. Always back up your company data before running repairs.

For persistent issues, contact your Tally support team or a certified partner. Global IT Care, a Tally 3 Star Certified Partner in Purnea, Bihar, can help diagnose and resolve inventory reporting issues quickly.

Stock Summary Best Practices

To get the most value from Stock Summary, follow these best practices:

• Regular Reviews: Check Stock Summary weekly or monthly to monitor inventory health and identify slow-moving items.
• Reconciliation: Compare Stock Summary with physical stock counts periodically. Discrepancies indicate data entry errors or inventory shrinkage.
• Valuation Method Consistency: Do not change your valuation method mid-year. Consistency is essential for accurate financial reporting.
• Proper Godown Assignment: Ensure all purchase and sales transactions are assigned to the correct godown so Stock Summary reflects accurate location-wise inventory.
• Archive Reports: Export and save Stock Summary reports at month-end or quarter-end for audit trails and historical analysis.

Integrating Stock Summary with Other Tally Reports

Stock Summary is one piece of a comprehensive inventory management system in TallyPrime. Combine it with other reports for deeper insights:

• Day Book: Shows all transactions (purchases, sales, receipts) for a specific date. Use it to verify Stock Summary movements.
• Trial Balance: Includes inventory accounts. Cross-check with Stock Summary valuation for accuracy.
• Outstanding Receivables: Track unpaid invoices linked to stock movements.
• TallyPrime Reports: Explore advanced inventory analytics and custom report builder for specialized analysis.

Using these reports together gives you a 360-degree view of your inventory, sales, and financial health.

Stock Summary and GST Compliance

If your business is GST-registered, Stock Summary helps you track inventory for GST reporting. TallyPrime includes GST fields in purchase and sales transactions, which flow into Stock Summary. When you file GSTR-1 (sales) and GSTR-2B (purchases), ensure your Stock Summary aligns with the quantities reported to GST authorities. Discrepancies can trigger GST audits.

To enable GST in TallyPrime, go to F11 (Accounting Masters) > Accounting Settings > Enable GST. Once enabled, all inventory transactions will capture GST details, and Stock Summary will reflect GST-compliant valuations.

Choosing the Right Tally Edition for Inventory Management

Stock Summary is available in all TallyPrime editions. However, if you run a multi-location business with complex inventory needs, consider upgrading to TallyPrime Gold, which supports unlimited users and advanced features like batch-wise stock tracking and cost center allocation. TallyPrime Silver is ideal for single-user or small businesses with simpler inventory structures.

Global IT Care offers both TallyPrime Silver (perpetual licence, Rs 22,500 + 18% GST) and Gold (Rs 67,500 + 18% GST) with 1 year of free Technical Support Services (TSS). Upgrade from Silver to Gold for Rs 45,000 + GST if your business grows. All licences are perpetual; you only renew TSS annually (Silver: Rs 4,500, Gold: Rs 13,500, +GST) to access updates and connected services like e-invoicing and GST reconciliation.

Stock Summary in TallyPrime is your window into real-time inventory health. Whether you are a small retail business in Purnea or a large distributor managing multiple godowns, this report provides the insights you need to optimize stock levels, reduce carrying costs, and maintain accurate financial records. Start using Stock Summary today to transform your inventory management. Need expert guidance on setting up inventory in TallyPrime or reconciling stock discrepancies? Contact Global IT Care, a Tally 3 Star Certified Partner in Purnea, Bihar, since 2010. Call us at +91 75469 00951 for a free consultation and discover how we can streamline your inventory and accounting processes.