Every founder we sit across from has, at some point, said a version of the same sentence: “Our stock count was fine last month.”
That sentence should worry you more than it comforts you.
A physical count tells you what’s sitting on the shelf right now. It says nothing about why the number on the shelf disagrees with the number in your books, your GST filings, your bank-funded working capital limits, and the production plan your ops head swears by. In manufacturing and distribution, those four versions of the truth rarely match- and the gap between them is where cash quietly disappears.
Counting Stock Is Not the Same as Reconciling It
A count is a snapshot. Reconciliation is an investigation. When a business physically counts 4,800 units of a SKU but the accounting software shows 5,200, the count doesn’t tell you whether the difference is theft, a wrong GRN entry, a return that was never booked, or raw material consumed in production but never relieved from inventory. Most businesses stop at the count and adjust the number to match, quietly, in a journal entry nobody questions. That adjustment becomes the new “truth,” and it compounds, quarter after quarter, until an auditor, a bank, or a due-diligence team asks a question nobody can answer.
We’ve seen this pattern often enough to know it isn’t rare. It’s the default state of most mid-sized manufacturing and distribution businesses running on Tally and Excel.
Where the Real Mismatches Hide
Beyond the shelf count, inventory reconciliation in this sector actually has four layers, and most businesses are only doing one:
- Physical vs. book stock — the count everyone does
- Stock vs. GST returns — e-way bills and GSTR filings that quietly diverge from what actually moved
- Stock vs. production data — BOM consumption, yield loss, and WIP that never gets relieved correctly
- Stock vs. cash — inventory sitting on the books as an asset while it’s actually obsolete, damaged, or simply gone
A distributor running fifteen depots across three states doesn’t have one inventory problem. They have fifteen versions of it, updated on fifteen different timelines, reconciled by fifteen different people with fifteen different definitions of “close enough.”
Two Businesses, Two Warnings
Kwality Limited, once one of India’s largest dairy businesses, ran into a forensic audit that found its actual routed sales fell dramatically short of what its books showed- a gap investigators linked to fabricated documents and reverse entries across its accounts. The business is now years into insolvency proceedings, owing thousands of crores to lenders who trusted numbers that didn’t hold up.
Manpasand Beverages built a distribution network claimed at over 600,000 outlets, but investigators later found the business had created dozens of fake trading entities to inflate turnover through inter-unit transactions that never involved real stock movement at all. Its auditor resigned months before the fraud became public. By the time GST officials moved in, the damage to lenders, investors, and employees was already done.
Neither business started with an intent to collapse. Both started with small, unreconciled gaps between what the warehouse said and what the books said, gaps that nobody was structurally forced to explain.
You don’t need fraud for this to hurt you. Ordinary sloppiness in reconciliation is enough to misprice your margins, misstate your working capital need, and hand your auditor a reason to qualify your books right before a funding round.
What Actually Fixes This
Not a bigger spreadsheet. Not a once-a-quarter count with more people involved. What fixes this is treating inventory reconciliation as a continuous, systemized discipline, where automated accounting workflows flag exceptions the moment a GRN, invoice, and stock movement don’t match, instead of waiting for someone to notice months later.
That’s the approach behind Akounter AI, an accounting software built by iZoe to help businesses identify these gaps before they turn into costly errors or forensic audit findings.
If your stock count looked fine last month, but no one could explain why the books showed something different, that’s worth looking into.
FAQs
Q: How often should manufacturing businesses reconcile inventory?
Physical counts can happen monthly or quarterly, but book-to-system reconciliation, matching stock movement against invoices, GST filings, and production consumption– needs to happen continuously, ideally daily for high-SKU or multi-location operations.
Q: What's the biggest blind spot in inventory reconciliation?
Production consumption. Raw material relieved through BOM and yield loss rarely gets reconciled against actual output, which is where manufacturing businesses lose visibility fastest.
Q: Can automated accounting really catch these mismatches early?
Yes, when the accounting layer flags exceptions at the point of entry (a GRN that doesn’t match a PO, a dispatch without a corresponding invoice) rather than at month-end, small gaps get caught before they compound.
Q: Is this only a large-business problem?
No. Mid-sized manufacturers and distributors are more exposed, because they usually have the transaction complexity of a large business without the finance headcount to reconcile it manually.
