Physical Stock In Tally: Complete Guide to Inventory Counting and Reconciliation

Physical stock in Tally refers to the actual quantity of inventory physically present in your warehouse or godown. You count it manually, record the data in TallyPrime using Stock Journal, and reconcile it with system records to identify and correct discrepancies.

Understanding Physical Stock and Why It Matters

Physical stock is the real-world quantity of goods sitting in your godown or storage location. Your TallyPrime system maintains a theoretical stock balance based on all purchase, sales, and transfer transactions entered into the software. In a perfect world, these two numbers match exactly. In reality, they often do not.

Discrepancies between physical stock and system stock occur for many reasons: theft, damage, evaporation, breakage, data entry mistakes, unrecorded transactions, or simple human counting errors. Physical stock verification is the process of counting actual goods and reconciling them with TallyPrime records. This reconciliation is critical for accurate financial reporting, GST compliance, and inventory management decisions.

For businesses managing thousands of items across multiple godowns, physical stock verification is not optional. It is a fundamental control that prevents financial misstatement and helps you understand where inventory is leaking.

When to Conduct Physical Stock Counts

The frequency of physical stock counts depends on your business type, inventory size, and regulatory requirements.

• Annual counts: Standard for most businesses. Typically done at year-end for financial audit and GST reconciliation.
• Quarterly counts: Recommended for businesses with moderate inventory turnover or high-value items.
• Monthly counts: Common in retail, pharmaceuticals, and fast-moving consumer goods (FMCG) where shrinkage is significant.
• Cycle counting: Continuous verification of specific items or godowns on a rolling basis, spreading the work throughout the year.

Many businesses in Purnea and Bihar follow an annual physical count aligned with their financial year-end (31 March) and GST filing deadlines. This approach ensures your GST records match your actual inventory position.

Preparing for Physical Stock Count

Proper preparation makes the counting process faster and more accurate. Before you start counting, take these steps in TallyPrime:

1. Print a Stock Summary report from Gateway of Tally > Display > Inventory > Stock Summary. This shows system balances for all items.
2. Print Godown-wise Stock reports if you have multiple storage locations. This helps you organize the count by location.
3. Freeze or lock your transactions for the count period. Ideally, stop data entry 24 hours before counting begins so the system balance does not change during the count.
4. Organize your counting team. Assign one person to count, another to verify, and a third to record quantities on the count sheets.
5. Ensure your godowns are clean and organized. Move items so they are easy to access and count.
6. Prepare count sheets in advance. You can use the printed Stock Summary as a base, or create a custom spreadsheet with item codes, names, and system quantities.

This preparation reduces counting time and minimizes errors. A well-organized count takes 1-2 days for a small business and 3-5 days for a larger operation.

Recording Physical Count Data

As your team counts items, record the physical quantities on count sheets. Use a simple format: Item Code, Item Name, System Quantity, Physical Quantity Counted, and Variance.

Example count sheet for a small retail business:

Item Code	Item Name	System Qty	Physical Qty	Variance
SKU-001	Rice (10 kg bag)	150	148	-2
SKU-002	Wheat Flour (5 kg)	200	205	+5
SKU-003	Cooking Oil (1 L)	80	75	-5
SKU-004	Sugar (2 kg)	120	120	0

In this example, Rice shows a shortage of 2 units (possible theft or damage), Wheat Flour has 5 extra units (likely an unrecorded purchase or data entry error), and Cooking Oil is short by 5 units. Sugar matches perfectly. These variances must be investigated and adjusted in TallyPrime.

Reconciling Physical Stock with System Records

Once counting is complete, compare physical quantities with TallyPrime system balances. For each item, calculate the variance: Physical Quantity minus System Quantity. A positive variance means you have more stock than the system shows. A negative variance means you have less.

Before adjusting, investigate significant variances. Ask questions like:

• Was a recent purchase or sales transaction not entered into Tally?
• Was stock transferred between godowns but not recorded?
• Is there damage or expiry that was not written off?
• Did a data entry error occur (wrong quantity or wrong item)?

Once you understand the reason for each variance, you are ready to adjust TallyPrime records.

Using Stock Journal for Physical Stock Adjustment

The Stock Journal in TallyPrime is the proper tool for recording physical stock adjustments. It creates an audit trail and maintains inventory integrity.

To access Stock Journal:

1. Press Alt+G to open the Gateway of Tally.
2. Select Inventory from the main menu.
3. Choose Stock Journal.
4. Press Ctrl+A to create a new Stock Journal entry.

In the Stock Journal entry, you specify:

• Date: The date of the physical count.
• Reference: A description like "Physical Count Adjustment - March 2026".
• Godown: The storage location where the count was done.
• Item details: For each item with a variance, enter the item name, quantity adjustment, and rate (use the average cost or last purchase rate).

If physical quantity is higher than system quantity, enter a positive quantity (inward adjustment). If physical quantity is lower, enter a negative quantity (outward adjustment).

Worked Example: Physical Stock Adjustment in TallyPrime

Let us work through a real scenario. Suppose you run a grocery store in Purnea and conduct a physical count on 15 March 2026.

Your count results:

• Rice (10 kg): System shows 150 bags, physical count is 148 bags. Variance: -2 bags.
• Wheat Flour (5 kg): System shows 200 bags, physical count is 205 bags. Variance: +5 bags.
• Cooking Oil (1 L): System shows 80 bottles, physical count is 75 bottles. Variance: -5 bottles.

Step 1: Create Stock Journal entry. Go to Gateway of Tally > Inventory > Stock Journal > Create New (Ctrl+A). Enter the date as 15 March 2026.

Step 2: Record the adjustment for Rice. In the Stock Journal, add a line item: Rice (10 kg), Quantity -2 (outward, because you have less than the system shows), Rate Rs 450 per bag (your average cost). This records a loss of 2 bags valued at Rs 900.

Step 3: Record the adjustment for Wheat Flour. Add another line: Wheat Flour (5 kg), Quantity +5 (inward, because you have more than the system shows), Rate Rs 300 per bag. This records a gain of 5 bags valued at Rs 1,500. You may investigate this later (perhaps an unrecorded purchase), but for now, you are correcting the system balance.

Step 4: Record the adjustment for Cooking Oil. Add a line: Cooking Oil (1 L), Quantity -5 (outward), Rate Rs 200 per bottle. This records a loss of 5 bottles valued at Rs 1,000.

Step 5: Save the entry. Press Ctrl+S. TallyPrime updates the stock balances for all three items and creates a Stock Journal report for your records.

After this adjustment, your system balances are:

• Rice: 150 - 2 = 148 bags (now matches physical count).
• Wheat Flour: 200 + 5 = 205 bags (now matches physical count).
• Cooking Oil: 80 - 5 = 75 bottles (now matches physical count).

The total loss is Rs 1,900 (2 bags of rice + 5 bottles of oil). The net gain from wheat flour is Rs 1,500. Your net loss for the period is Rs 400. This figure should be recorded as a loss in your profit and loss account for GST and income tax purposes.

Creating Stock Items and Godowns for Accurate Tracking

To make physical stock verification easier, ensure all your items and godowns are properly set up in TallyPrime. A well-structured inventory master reduces counting errors and makes reconciliation faster.

When you create stock items in Tally, include:

• Unique item code (SKU).
• Item name and description.
• Unit of measurement (bags, bottles, pieces, etc.).
• Opening balance (if migrating from another system).
• Reorder level and maximum stock level.

Similarly, when you set up godowns in Tally, assign each storage location a clear name and code. If you have a main warehouse and a branch store, create separate godowns so you can track stock by location and conduct location-specific counts.

Using Stock Reports for Verification

After adjusting physical stock in TallyPrime, run reports to verify your changes. These reports help you confirm that the system now reflects your physical count.

Key reports for physical stock verification:

• Stock Summary: Shows current balance for all items. Go to Gateway of Tally > Display > Inventory > Stock Summary.
• Stock Item Summary: Detailed report for individual items including opening balance, receipts, issues, and closing balance.
• Godown-wise Stock: Stock balances organized by godown location. Useful if you have multiple warehouses.
• Stock Journal Report: Shows all Stock Journal entries you created for adjustments.

Print these reports and file them with your count sheets. They form part of your audit trail and are important if your GST authority or auditor questions your inventory figures.

Handling Batch and Expiry in Physical Stock

If you deal with batched or perishable items (pharmaceuticals, food, chemicals), physical stock verification becomes more detailed. You must track not only quantity but also batch number and expiry date.

When you set up batch and expiry tracking in Tally, each stock item can have multiple batches with different expiry dates. During physical counting, record the batch number and expiry date for each lot. In TallyPrime, you can then adjust stock at the batch level, ensuring expired items are written off correctly.

This is especially important for GST compliance. If you write off expired stock, you must document it in Stock Journal with the batch details so your GST records are accurate.

Integrating Physical Stock with Reorder Levels

Once your physical stock is verified and reconciled, use the corrected balances to review your reorder levels in Tally. Reorder level is the minimum quantity at which you should place a new purchase order to avoid stockouts.

If your physical count revealed consistent shortages (like the Rice example above), you may need to raise your reorder level. Conversely, if you found excess stock, you might lower the reorder level to reduce carrying costs.

Accurate physical stock reconciliation ensures your reorder levels are based on real data, not flawed system records.

Common Physical Stock Discrepancies and Solutions

Different types of variances require different investigations and adjustments:

• Shortage (negative variance): Investigate theft, damage, evaporation, or unrecorded sales. Adjust in Stock Journal as outward (negative quantity).
• Overage (positive variance): Check for unrecorded purchases, data entry errors, or returns from customers. Adjust as inward (positive quantity).
• Batch expiry: If items have expired, write them off in Stock Journal with zero rate to remove them from inventory.
• Damaged goods: Separate damaged items during counting. Adjust them in Stock Journal and track the loss.
• Unit mismatch: If an item was counted in a different unit (e.g., counted in pieces but system shows in dozens), convert and adjust accordingly.

Document the reason for each adjustment in the Stock Journal reference or notes field. This creates an audit trail that auditors and GST authorities expect to see.

Physical Stock and GST Compliance

Physical stock reconciliation is closely tied to GST compliance. Your GST return (GSTR-1 and GSTR-3B) must reflect the inventory position at the end of each quarter. If your physical stock differs significantly from your system records, your GST filings may be questioned.

When you adjust physical stock in TallyPrime using Stock Journal, the adjustments flow into your inventory reports and ultimately affect your GST calculations. Ensure all adjustments are made before you file your GSTR-3B (due on the 20th of the following month for regular taxpayers).

To enable GST in TallyPrime and ensure your physical stock adjustments are GST-compliant, press F11 to open Company Settings and enable GST under the Statutory and Taxation section.

Best Practices for Accurate Physical Stock Management

To minimize discrepancies and make future counts easier, follow these practices:

• Regular counts: Do not wait until year-end. Monthly or quarterly counts catch errors early.
• Cycle counting: Count high-value or fast-moving items more frequently.
• Organize storage: Keep godowns clean and organized so items are easy to locate and count.
• Segregate damaged goods: Separate damaged or expired items immediately so they are not counted as usable stock.
• Reconcile promptly: Adjust TallyPrime records within a few days of counting while details are fresh.
• Investigate variances: Do not just adjust; understand why discrepancies occurred.
• Train staff: Ensure your team knows how to count accurately and how to use TallyPrime for adjustments.
• Document everything: Keep count sheets, Stock Journal entries, and reports for audit purposes.

These practices build a culture of inventory accuracy and reduce the risk of financial misstatement or GST non-compliance.

Conclusion

Physical stock verification in TallyPrime is not a one-time task but an ongoing process that ensures your inventory records are accurate, your financial statements are reliable, and your GST filings are compliant. By counting regularly, reconciling promptly using Stock Journal, and investigating discrepancies, you maintain control over one of your most important assets: inventory.

If you manage a business in Purnea, Bihar, or nearby areas and need help setting up physical stock verification processes in TallyPrime, Global IT Care is here to assist. We are a Tally 3 Star Certified Partner with over 15 years of experience helping businesses in Bihar master TallyPrime inventory management. Whether you need help with Stock Journal entries, inventory setup, or GST compliance, our expert team can guide you through every step. Contact us today at +91 75469 00951 for a free consultation on your inventory management needs.