Book stock vs physical stock: why they don’t match, and how to close the gap
Short answer: book stock is the quantity your accounting software says you hold; physical stock is what’s actually in the warehouse when you count it. They drift apart because software moves stock when paperwork is entered, while goods arrive short, leave without a bill, get damaged or go missing on their own schedule.
Every distributor meets this gap sooner or later — usually at a year-end count, when the books say 100 cartons and the godown has 92. You’ll also hear it called system stock vs actual stock, or stock in books vs stock on hand. Whatever the name, the causes are the same.
What “book stock” and “physical stock” mean
Book stock (system stock, stock in books) is calculated: opening stock, plus purchases entered, minus sales entered, plus or minus adjustments. Physical stock (actual stock, counted stock) is observed: what someone counts on the shelves. The book figure is only as good as the entries behind it.
Seven reasons they don’t match
| Reason | What you see | How to prevent it |
|---|---|---|
| Short supply: the bill says 50, the truck brought 45 | Books higher than the shelf, on inward goods | Check the supplier bill against a signed delivery note before accepting it |
| Goods leave without a bill, or the bill is entered days later | Shelf lower than books, then the books “catch up” | Require a dispatch slip or gate pass for every movement out |
| Damage, expiry and free samples never recorded | A slow, steady drift downward | Record them as their own entry type, the same day |
| The same invoice entered twice | Books off by exactly one invoice | Match every entry to a unique supplier invoice number |
| Wrong item or unit (cartons vs pieces) | One item over, a similar item under | Fix item masters and units before the next count |
| Transfers recorded on one side only | One warehouse over, another under by the same amount | Record both ends of every transfer together |
| Theft or pilferage | Unexplained loss after everything else is ruled out | Make every movement need proof, so a gap points to a time and a person |
The first two matter most for distributors, because both come from stock moving on paperwork rather than on proof. Tutorials written for Tally users list the same culprits — incomplete voucher entries, unrecorded damage and counting errors (svtuition).
How to find the gap
- Count a sample, not everything: pick your 20 fastest-moving items and count them weekly (a cycle count).
- Compare each count with book stock at the same moment — after the day’s entries, before the next day’s.
- For every difference, find its reason in the table above before you adjust anything.
- Record the count in your ledger. In TallyPrime that’s a Physical Stock voucher, and the Physical Stock Register then shows each variance (TallyHelp, TallySchool). QuickBooks Online, Xero and Zoho Books each have their own way to record a stock adjustment.
Adjustments fix the number, not the cause
An adjustment makes the books agree with the shelf today. It doesn’t stop tomorrow’s gap, because the next short delivery or unbilled dispatch opens it again. The lasting fix is to stop stock moving on paperwork alone: hold every purchase until the supplier bill, the ledger entry and a signed delivery note agree, and every dispatch until there’s proof it left. That’s a 3-way match, and it turns a year-end surprise into a same-day flag.
BPS CA works exactly this way on top of Tally Prime, Zoho Books, Xero or QuickBooks Online: synced entries wait as pending trades, and stock only moves once the bill, the books and the delivery proof agree. See BPS CA.
Questions people ask
What is book stock?
Book stock is the stock quantity your accounting records show: opening stock plus purchases entered, minus sales entered, plus or minus adjustments. It is also called system stock or stock in books.
Why is physical stock less than book stock?
Usually because goods left, or never arrived, without the books knowing: short supplies billed in full, dispatches without a bill, unrecorded damage or samples, and theft. Duplicate purchase entries also inflate book stock.
How do I record a physical stock count in Tally?
In TallyPrime, record the count with a Physical Stock voucher. The Physical Stock Register then shows the difference between book and counted quantities.
How do I stop book and physical stock drifting apart?
Stop stock moving on paperwork alone. Hold each purchase until the supplier bill, the ledger entry and a signed delivery note agree, hold each dispatch until there is proof it left, and count your fastest-moving items weekly.
Need something built around your own process instead? Start a project — you’ll get a plain-language blueprint before you commit to anything.