View Physical Stock Register in TallyPrime: 2 Ways + Example

Here’s how to view the Physical Stock Register in TallyPrime and understand the information it provides:

1. Accessing the Physical Stock Register Report:

There are two ways to access the Physical Stock Register:

  1. Go to the Gateway of Tally (Alt+F12).
  2. Navigate to Display > Inventory Books > Physical Stock Register.

Alternatively, you can use a keyboard shortcut:

  • Press Alt+G (Go To) and type or select “Physical Stock Register.”

2. Understanding the Physical Stock Register Report:

The Physical Stock Register summarizes the stock adjustments made through Physical Stock Vouchers during a specific period.

It provides insights into discrepancies between the book stock (system records) and the actual physical stock count.

The report typically includes:

  • Month: Month for which the physical stock adjustments were recorded.
  • Date: Date of the Physical Stock Voucher entry.
  • Voucher No.: Reference number of the Physical Stock Voucher.
  • Item Name: Name of the stock item for which the physical stock was counted.
  • Godown (Optional): If you maintain multiple godowns, this column shows the godown where the physical stock was counted.
  • Batch (Optional): If batch tracking is enabled, this column shows the specific batch for which the physical stock was adjusted.
  • Book Stock: Quantity of the stock item as per the system records before the physical stock adjustment.
  • Physical Stock: Quantity of the stock item found during the actual physical count.
  • Difference: Variation between the book stock and the physical stock. This can be positive (physical stock is higher) or negative (physical stock is lower).
  • Narration (Optional): You can add a brief explanation for the difference in the Physical Stock Voucher itself. This information might be reflected in the report.

3. Example of Physical Stock Register in TallyPrime:

Let’s assume you conducted a physical inventory count on May 25th, 2024. The report might show:

MonthDateVoucher No.Item NameGodown (Optional)Batch (Optional)Book StockPhysical StockDifferenceNarration (Optional)
May25-May-2024PHY-001Monitor2018-2Possible breakage
May25-May-2024PHY-002Keyboard50522Additional stock found

4. Benefits of Physical Stock Register in TallyPrime:

  • Provides a summary of physical stock adjustments made during a period.
  • Helps identify discrepancies between book stock and physical stock.
  • Assists in investigating the reasons for stock variances.
  • Enables you to reconcile inventory records based on physical count results.

5. Additional Considerations about Stock Register in TallyPrime:

  • You can utilize filters in the report to narrow down the results by date, item name, or godown (if applicable).
  • Analyze the “Difference” column to understand discrepancies and take corrective actions.
  • The “Narration” column can provide valuable context for the differences and aid in future inventory management procedures.

By effectively utilizing the Physical Stock Register in TallyPrime, you gain valuable insights into the accuracy of your inventory records and can take steps to minimize stock discrepancies for better inventory control.

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

2 FREE Lessons Daily from TallySchool