Physical stock not matching Tally is usually an entry problem before it is a theft problem. Check seven causes in this order. First, invoices or challans that took stock out of the wrong godown. Second, unit mix-ups, where goods came in as boxes and went out as pieces. Third, scheme quantity handed to customers but never entered. Fourth, cash sales that were never billed. Fifth, transfers between godowns that were never recorded. Sixth, negative stock, where Tally let a sale go through before the purchase was entered. Seventh, goods that moved while the count was going on. Each one leaves a pattern you can spot in Tally: an item short in one godown and over in another points to the first or fifth cause, and a gap that is an exact multiple of the pack size points to the second. Only what is left after these checks is a real shortage to record and explain.
Key Highlights
- Most gaps come from entries. An item short in one godown and over in another usually means a wrong godown on a bill or an unrecorded transfer.
- A gap that is an exact multiple of the pack size, such as 24 pieces in a 24-piece carton, usually means a box and piece mix-up.
- In the example, 8 cartons short in the Main godown and 8 over in the Branch godown are one unrecorded transfer, so there is nothing to write off.
In This Article
- The seven causes, in the order to check
- The causes at a glance
- Before you blame staff
- Count again, properly
- Where Takkada fits
- Frequently Asked Questions
The seven causes, in the order to check
1. Wrong godown on the invoice
An invoice or delivery challan that names the wrong godown, or none, takes stock out of the wrong place. The total stock is right and the godown split is wrong. How to check: compare the item's stock in each godown with the count, and open the item's vouchers for the period to find bills with the wrong godown. Our post on godown on sales invoices and delivery challans shows how to stop it at the bill.
2. Box and piece mix-ups
A purchase entered in cartons and a sale entered in pieces, or the other way round, leaves a gap the size of a pack. How to check: look at the item's units in Tally and at the bills around the date the gap appeared. A shortage of exactly 24 in an item packed 24 to a carton is the usual sign.
3. Scheme quantity not entered
Buy 10, get 1 schemes send out 11 units while the bill shows 10. If the scheme unit is not on the bill, the shelf runs short by one for every scheme sale. How to check: list the scheme items for the period and compare the units given with the units billed.
4. Cash sales not billed
A counter sale paid in cash and never billed leaves the shelf without leaving the books. How to check: compare cash in hand with billed cash sales for the days around the gap, and ask whoever sits at the counter which items go out this way.
5. Transfers not recorded
Goods carried from one godown to another without a transfer entry make one godown short and the other over by the same quantity. How to check: look for matching gaps in two godowns. Recording transfers on the day they happen is covered in stock transfer between godowns.
6. Negative stock allowed
If Tally lets you bill an item before its purchase is entered, the book stock goes below zero for a while. When the purchase never comes in, the book stays wrong. How to check: look in the stock summary for any item below zero and find the missing purchase or the duplicate sale.
7. Counting while goods move
A sale, a receipt or a transfer made while the shelf is being counted turns into a false shortage or excess. How to check: compare bills dated after your cut-off with the gaps. Counting after the last bill of the day, or before the first, avoids most of it.
The causes at a glance
| Cause | What you see | Where to check |
|---|---|---|
| Wrong godown on the invoice | Short in one godown, over in another | Item vouchers, godown on each bill |
| Box and piece mix-up | Gap equal to a pack size | Item units, bills near the date |
| Scheme quantity not entered | Steady small shortage on scheme items | Scheme sales vs units given |
| Cash sales not billed | Shortage on counter items | Cash in hand vs billed cash sales |
| Transfer not recorded | Same quantity short and over in two godowns | Transfers for the period |
| Negative stock | Item below zero in the books | Stock summary |
| Goods moving during the count | Gap matches a bill after the cut-off | Bills after the cut-off |
Here is how it looks in practice. A distributor counts detergent powder and finds 8 cartons short in the Main godown. The Branch godown shows 8 cartons over. Nobody took anything; the van carried 8 cartons across on Saturday and nobody made the transfer. One transfer entry, dated Saturday, fixes both godowns, and the ₹6,800 the shortage would have cost at ₹850 a carton never needs writing off.
Before you blame staff
A shortage that is still there after these seven checks may be breakage, an expiry thrown away without an entry, or theft. Before you talk to anyone, recount the item yourself or with a second person, check the last three months of bills for that item, and note whether the gap grows count after count. A gap that grows on the same few items in the same godown is worth a closer look. A one-off gap that the entries explain is not.
Count again, properly
A good count makes most of these causes easy to see. Fix a cut-off, count one group in one godown at a time, and let the counter work without the book figure. Our physical stock verification checklist has the 18 steps, and the physical stock verification format has a sheet to print. Once the gap is explained, record what is left as in stock shortage and excess entry in Tally.
Where Takkada fits
Takkada's Physical Stock Count add-on handles the seventh cause for you. The book stock is frozen the moment the counter submits, and any item sold, bought or moved in that godown after that is marked Moved after count on your review screen, so a sale made during counting is not mistaken for a shortage. The counter works from a stock count app on their phone that shows item names and units, never the book stock. You send any doubtful item back for a recount and approve the rest. The physical stock verification for Tally page shows the whole flow. Counting tells you whether the books are right; for what to reorder, Takkada has a separate add-on.
Frequently Asked Questions
Q: Why is my physical stock different from Tally?
A: Usually because of an entry: a bill with the wrong godown, a box and piece mix-up, scheme units not billed, a cash sale not billed or a transfer not recorded. Negative stock and goods moving during the count are the other two common causes. Check all seven before you treat the gap as a loss.
Q: How do I find a stock mismatch in Tally?
A: Compare the count with the item's stock in each godown at the cut-off date. Then open the item's vouchers for the period and look for bills with the wrong godown, unit mix-ups and missing transfers. A gap that matches a pack size or appears in two godowns points straight to its cause.
Q: What is negative stock in Tally?
A: It is when the book stock of an item falls below zero, because a sale or transfer was entered before the purchase that brought the goods in. A shelf cannot hold less than zero, so negative stock always means an entry is missing or wrong. Find it in the stock summary.
Q: How do I correct stock in Tally after a count?
A: First correct the entries that caused the gap: the bill, the unit or the transfer. Then record what is still different with a Stock Journal at cost, or a Physical Stock voucher with the counted quantity. Both are explained in our posts on shortage entries and on physical stock entry in Tally Prime.
When you approve a count in Takkada's Physical Stock Count add-on, it makes the stock journal for Tally: shortages out of the godown and extra stock in, at the rates you approved, sent to Tally through Takkada's Tally connector. Batch-wise items are counted but left out of the journal; adjust those in Tally by batch. Physical Stock Count is an add-on, priced by your partner. Ask them for the add-on price, or message us on WhatsApp and we will switch it on for your company.