Physical stock verification is the process of counting the goods actually lying in your godown, shop or warehouse and matching that count with the stock shown in your books. If the two do not agree, you find out why, correct the records and fix the cause. It sounds simple. In practice it is one of the most dreaded jobs in any trading or manufacturing business, because it means stopping work, pulling staff off the floor and spending days with clipboards.
This guide walks through how to plan and run a physical stock verification, a ready Excel format, how to record the result in Tally Prime, and how RFID counting turns a three-day exercise into a few hours.
What is physical stock verification and why it matters
Your accounting software only knows what you tell it. Every missed GRN, wrong unit of measure, unbilled dispatch, damaged carton or theft creates a gap between book stock and real stock. Physical verification is how you find that gap.
It matters for four reasons:
- Statutory audit. Under CARO 2020, Clause 3(ii)(a), the auditor of a company must report whether management has physically verified inventory at reasonable intervals and whether discrepancies of 10% or more in aggregate for each class of inventory were found and properly dealt with.
- Bank limits. Under Clause 3(ii)(b), where working capital limits above ₹5 crore are secured against current assets, the quarterly stock statements filed with the bank must agree with the books. A wrong count means a wrong drawing power.
- GST. Stock that is lost, stolen or destroyed requires reversal of input tax credit, and an unexplained shortage can be treated as unrecorded sales. See our guide on stock mismatch and GST.
- Working capital. You cannot reorder smartly, or stop over-buying slow movers, without knowing what is really on the shelf.
Types of physical stock verification
- Annual (wall-to-wall) count. Every item is counted once a year, usually around 31 March. Thorough but disruptive.
- Periodic count. Full counts every quarter or half-year. Common where bank stock statements are involved.
- Cycle counting. A few categories are counted every week so the whole stock is covered over a cycle. High-value and fast-moving items are counted more often (an ABC approach).
- Surprise count. An unannounced count of selected items or locations, used to check controls and deter theft.
Physical stock verification procedure: step by step
1. Plan the count
Fix the date, cut-off time and scope. Freeze inward and outward movement during the count, or at least record every movement after the cut-off separately. Print or export the book stock as at cut-off, item-wise and location-wise.
2. Prepare the floor
Arrange stock so each item sits in one place, mark damaged and expired goods separately, and label bins or racks with a location code. Goods received but not yet entered, and goods sold but not yet dispatched, should be kept aside and listed.
3. Form count teams
Use teams of two: one person counts, the other records. The team should not be the same people who maintain that stock. Give each team a fixed set of locations so nothing is counted twice or skipped.
4. Count and tag
Count every item and mark it counted (a sticker or chalk mark). Record item code, description, unit, location and quantity. Do not let the counter see the book quantity; that avoids "adjusting" the count to match.
5. Recount the exceptions
Compare the count sheet with book stock. Any item with a difference above your tolerance (for example 2% or ₹5,000 in value) gets a second, independent count.
6. Investigate differences
Typical causes are entries posted to the wrong item, unit mix-ups (box vs piece), unrecorded returns, pending GRNs or invoices around the cut-off, damage, and theft. Document the reason for each difference.
7. Approve and adjust the books
The owner or finance head approves the final count. Only then are the books adjusted, with a clear note of reasons. Shortages due to loss, theft or destruction also trigger ITC reversal under GST.
8. Report and act
Prepare a physical stock verification report and fix the root causes, not just the numbers.
Physical stock verification format in Excel
Use one row per item per location with these columns:
| Column | What to enter |
|---|---|
| Item code | SKU or Tally stock item name |
| Description | Short name |
| Location | Godown, rack or bin code |
| Unit | Pcs, box, kg |
| Book qty | From the stock summary at cut-off |
| Physical qty | Counted quantity |
| Difference | Physical qty minus book qty |
| Rate | Valuation rate per unit |
| Difference value (₹) | Difference x rate |
| Reason | Wrong entry, damage, theft, pending GRN and so on |
| Counted by / Checked by | Names and initials |
Add a summary at the top: total book value, total physical value, net difference and difference as a percentage. Conditional formatting that turns any row red above your tolerance makes review much faster.
Physical stock verification report format
A short report should cover: date and scope of the count, method used, team members, summary of book vs physical value, list of significant differences with reasons, adjustments made, control gaps found and actions agreed with owners and dates. Signed copies help at audit time.
How to record physical stock in Tally Prime
Tally Prime has a dedicated Physical Stock voucher. From the Gateway of Tally, go to Vouchers and press Alt+F10 (Physical Stock) under inventory vouchers. Select the godown and stock item and enter the counted quantity. Tally treats the physical quantity as the stock on that date and posts the difference automatically, so you can see the shortage or excess in the Stock Summary and the Physical Stock Register.
Two tips: enter the physical stock voucher on the cut-off date, and post transactions that happened after the cut-off with later dates so they are not mixed into the count. With TrueStock you can sync physical counts with Tally directly instead of typing them in item by item.
Common mistakes to avoid
- Counting while goods are still moving in and out
- Letting counters see book quantities
- Ignoring unit of measure differences
- Adjusting books before investigating
- Treating verification as a once-a-year event
How RFID makes stock verification fast
Barcode counting still needs a person to find and scan each label one at a time. With UHF RFID, each item or carton carries a passive tag, and a handheld reader picks up hundreds of tags per second without line of sight. A godown that takes a team three days to count by hand can often be counted in a few hours, and the count can be repeated every week instead of once a year.
TrueStock tags stock with low-cost UHF labels, counts it with a handheld reader, compares the result with your Tally book stock and shows the differences item by item. A trained operator tags around 300 to 500 units a day, so most SMEs can tag their entire stock in a short, one-time project.
Conclusion
Physical stock verification protects your audit, your bank limits, your GST position and your working capital. Plan it, count with independent teams, investigate every difference and fix the causes. When counting becomes the bottleneck, RFID removes it.
Want to count your godown in hours, not days?
Frequently asked questions
What is physical stock verification?
It is counting the actual stock on hand and comparing it with the stock in your books, then investigating and correcting differences.
How often should physical stock verification be done?
At least once a year for audit. Businesses with bank limits or high-value stock usually count quarterly, and cycle counting spreads the work across the year.
How do I enter physical stock in Tally Prime?
Use the Physical Stock voucher (Alt+F10 under inventory vouchers), select godown and item, and enter the counted quantity. Tally posts the difference automatically.
What is the difference between stock audit and physical verification?
Physical verification is the counting exercise. A stock audit is wider: it also checks valuation, records, controls and, for banks, whether stock statements are accurate.
Can RFID replace manual stock counting?
Yes. A UHF RFID handheld reads many tags at once without line of sight, so counts are faster and can be done far more often.
