A physical stock verification format is simply the sheet you use to compare what your software says you have with what is actually sitting on your shelves and in your godown. If you run a kirana store, supermarket, pharmacy, hardware shop or wholesale business, that gap between “system stock” and “real stock” quietly eats into your profit. This guide gives you a ready-to-copy count-sheet layout, explains when to do a full count and when a cycle count is enough, and shows how to approve and post the stock adjustment so your books and your shelves finally agree.

What physical stock verification actually means
Physical stock verification is the process of counting, weighing or measuring every item you hold and recording the result against the quantity shown in your stock register or billing software. The difference between the two is called the variance. A positive variance means you found more than the system expected; a negative variance means stock is missing.
Variance is rarely caused by one big event. It usually builds up from small, everyday slips:
- A purchase bill entered with the wrong pack size (a box of 12 entered as 1 unit, or the other way round).
- Items billed under a similar-looking code, so one item shows too much stock and another too little.
- Damaged, expired or sample stock taken off the shelf without an entry.
- Supplier returns sent back without a debit note in the system.
- Loose items such as rice, sugar or dal sold by weight, where small differences add up over weeks.
- Theft or pilferage, which our guide on shrinkage in retail covers in more detail.
The goal of a stock verification is not only to correct the numbers. It is to find out why they were wrong, so the same gap does not appear again next month.
Physical stock verification format: the columns you need
You can keep this format in a notebook, an Excel sheet or print it from your billing software. What matters is that every counter fills the same columns in the same way. Here is a practical layout that works for most Indian shops:
| Column | What to write | Who fills it |
|---|---|---|
| Sl. No. | Running number for each line | Pre-printed |
| Location / Rack | Godown, Rack B2, Shelf 3, Counter display, etc. | Pre-printed |
| Item code / Barcode | The code used in your billing software | Pre-printed |
| Item name | Full name with size or variant (e.g. Sunflower oil 1 L pouch) | Pre-printed |
| Unit | Pcs, box, kg, litre, strip, metre | Pre-printed |
| Batch / Expiry | For pharmacy, food and other batch-tracked items | Counter |
| System quantity | Stock as per software at the cut-off time | Supervisor (hidden from counter, see below) |
| Physical quantity | What was actually counted | Counter |
| Variance (qty) | Physical minus system | Supervisor |
| Variance (value) | Variance qty x purchase cost | Supervisor |
| Reason | Damage, expiry, wrong entry, unit mismatch, not found, etc. | Supervisor after re-check |
| Counted by / Checked by | Initials of both people | Counter and checker |
Add a header block at the top of each sheet with the shop or branch name, date, count start and end time, the stock cut-off time and the sheet number (for example, Sheet 4 of 18). That header is what makes the sheet useful later if your accountant, a bank or an auditor asks how the closing stock figure was arrived at.

Why the counter should not see the system quantity
This is the single most useful rule in the whole format. If the person counting can see that the system expects 48 packets, there is a strong temptation to write 48 after a quick look. Print the count sheet with the system quantity column blank, or use a separate copy for the supervisor. This is called a “blind count”, and it is the only way to get an honest physical figure.
Excel version of the format
If you prefer Excel, keep the same columns and add two simple formulas. In the variance quantity column use =PhysicalQty - SystemQty, and in the variance value column use =VarianceQty * PurchaseCost. Then sort the sheet by the absolute variance value so the most expensive differences come to the top. You rarely need to investigate every line; you need to investigate the lines that matter.
Full count or cycle count: which one should you do?
There are two ways to verify stock, and most growing shops end up using both.
Full (wall-to-wall) count
Everything in the shop and godown is counted on the same day, usually after closing or on a holiday, with billing stopped. A full count gives you a clean closing stock figure for the year-end, which is why many businesses in India do one around 31 March. The downside is that it takes a lot of people and time, and tired counters make mistakes.
Cycle count
A small group of items is counted every day or every week, so that the entire stock is covered over a month or a quarter. Billing can continue while you count, as long as you freeze or note the system quantity at the exact time each section is counted.
A sensible way to decide what to count and how often is to use your item value. Our guide to ABC analysis in inventory explains the method. In simple terms:
- A items (high value or fast moving, such as mobile phones, branded oil, costly medicines): count every week or two.
- B items (medium value): count once a month.
- C items (low value, slow moving): count once a quarter, plus the annual full count.

An illustrative example
Here is a made-up example to show how a cycle count works in practice. A supermarket in Thrissur decides to count its edible oil rack every Monday morning before opening. The system shows 120 one-litre sunflower oil pouches. The blind count finds 108. The supervisor re-counts and gets the same figure, then checks the last purchase entry and finds that a carton of 12 pouches was entered twice. Nothing was stolen; it was a data entry error. The correction is posted, and the purchase entry habit is fixed by making the second person check the received quantity against the supplier invoice.
Without the count, that “phantom” stock would have stopped the reorder from happening, and the shelf would have run empty on a busy weekend.
Step-by-step physical stock verification process
Whether you do a full count or a cycle count, the process is the same. Write it down once and follow it every time.
- Fix a cut-off. Decide the exact time after which no purchase, sale or return is entered for the items being counted. For a full count this is usually closing time the night before.
- Clean up pending entries. Enter all purchase bills, supplier returns, transfers between branches and damaged-stock notes up to the cut-off. Counting against an out-of-date system figure creates false variances.
- Arrange the shelves. Face the products, group the same item in one place, and separate damaged or expired stock into a marked box so it is counted on its own line.
- Print location-wise sheets. Print the count sheets rack by rack, not alphabetically. Counters walk the shop in a line instead of running back and forth.
- Count in pairs. One person counts, one person writes. For high-value racks, a second team re-counts independently.
- Count in the selling unit. If you sell by the piece, count pieces, not boxes. Write opened boxes as loose pieces. Weigh loose items on the shop scale.
- Enter the counts. Type the physical quantities into the software or the Excel sheet the same day while the details are fresh.
- Re-count large variances. Set a simple rule, for example: re-count every line where the variance value is above a limit you choose, and every line for A items. Many “shortages” disappear on a re-count because stock was kept in a second location.
- Record reasons. For every variance that remains, write a reason. “Unknown” is acceptable, but if it appears often it is telling you something.
- Approve and post the adjustment. Only after approval should the stock in the system be changed (see the next section).
Approval flow and stock adjustment entries
A stock adjustment changes the value of your inventory, so it should never be a one-person job. A simple approval flow for a small or mid-sized shop looks like this:
- Counter team submits the count sheets, signed.
- Store supervisor checks the re-counts and reasons, and prepares the adjustment list.
- Owner or manager reviews the total variance value and any single line above the limit, then approves.
- Accounts posts the adjustment and keeps the signed sheets with the month’s records.
In the software, a shortage is posted as a stock reduction and an excess as a stock increase, each with a reason. Keep damaged and expired stock as separate reasons from “shortage”, because they tell different stories: one is a storage or ordering problem, the other is a control problem. Your accountant can advise on how write-offs should be treated in your books and for GST, since input tax credit on goods that are lost, stolen or destroyed may need to be reversed. Speak to your tax adviser for your specific case.
If you are moving to new software, a careful physical count also becomes your starting point. Our guide on opening stock entry in billing software explains how to load those counted figures correctly.

Common mistakes to avoid
- Counting while billing continues without a cut-off. Items sold during the count get counted as missing.
- Mixing units. One counter writes boxes, another writes pieces. Always pre-print the unit on the sheet.
- Ignoring the back store. Stock on the top rack of the godown or in the delivery van is easily missed.
- Adjusting without asking why. If you only correct the number, the same variance returns next month.
- Not looking at slow stock. A count is the best time to spot items that have not moved in months. Use our dead stock management guide to decide what to discount, return or stop buying.
How billing software makes stock verification easier
A paper format works, but software removes most of the manual effort. With a good inventory management system for retail, you can print location-wise count sheets, scan barcodes instead of reading item names, see variance and value instantly, and post approved adjustments with a reason so there is an audit trail. Low-stock and reorder alerts also become trustworthy once your system quantity matches your shelf.
Caddayn Biller supports barcode billing, inventory with low-stock and reorder alerts, batch and expiry tracking for pharmacies, units of measure and multi-branch stock, and it runs as both a Windows app and a web app. If you want your next stock count to be quicker and your stock figures to stay accurate between counts, you can download Caddayn Biller and try it with your own items.
Frequently asked questions
How often should a shop do physical stock verification?
Most shops benefit from a full count at least once a year, usually at the financial year-end, plus regular cycle counts. High-value or fast-moving items can be counted every week or two, and low-value items once a quarter.
What is the difference between stock verification and stock audit?
Stock verification is the act of counting and comparing physical stock with records. A stock audit is a wider review, often by an outside auditor or a bank, that checks the verification process, valuation and records as well as the count itself.
Can I continue billing during a stock count?
For a cycle count, yes, if you note the system quantity at the moment each section is counted. For a full count, it is safer to stop billing or count after closing so that sales during the count do not create false variances.
What should I do with the variance after verification?
Re-count large differences, record a reason for each remaining variance, get it approved by the owner or manager, and then post a stock adjustment in your software. Review the reasons every month to fix the root causes.
