The annual stock take is the event most Indian manufacturers dread. Two days of factory shutdown, a tired team counting tagged drums of chemical at midnight, an auditor breathing down the storekeeper's neck, and a final variance report that nobody fully believes. It doesn't have to be this way. A well-prepared physical inventory count can be done over a weekend with discipline, with variances under 1% and no shouting matches.
This is a field-tested checklist for SME manufacturers running a year-end physical stock count without losing sleep.
Why Most Stock Takes Go Wrong
Before the checklist, understand the failure modes. Almost every painful stock take fails at one of three points:
- Cut-off not respected — material is still moving in or out during the count. Counts go stale before they are entered.
- Locations not mapped — material in shadow locations (under the bench, in the QC hold, in a corner of the godown) gets missed.
- Reconciliation without root cause — variances are adjusted on paper without anyone asking why. The same variances repeat next year.
Fix these three and 80% of the pain disappears.
Preparation: The Three Weeks Before
The work that determines whether your stock take is painful or smooth happens in the three weeks before, not on the count day itself.
Three weeks out: Housekeeping
- Identify and clear obsolete stock. Items not consumed in 24+ months — get management approval to scrap or sell as is. Don't count them at full value.
- Consolidate locations. If the same SKU is sitting in four physical locations, move it into one. Less to count, fewer reconciliation errors.
- Resolve open WIP. Jobs that have been on the floor for 6+ months — close them, scrap them, or restart them. WIP is the single biggest source of stock-take variance.
- Clear all open GRNs and dispatch challans. Material physically received but not booked, or vice versa, will create variance. Close the loop.
Two weeks out: Tagging and Mapping
- Walk every location with the store-keeper and supervisor. Mark every bin, rack, drum, and corner with a location code.
- Print a master location list. Anything not on the list either gets added or gets cleared.
- Print stock tags (3-part: one stays on the item, one goes to count team, one goes to audit). For larger operations, use barcode-printed tags that scan into a phone.
One week out: People and Process
- Form count teams. Two-person teams: one counts, one records. Never let the regular store-keeper count his own area — pair them with someone from production or accounts.
- Brief everyone in writing. Count sheet format, tag procedure, what to do with damaged stock, how to escalate doubts. A 1-page SOP, signed by everyone.
- Confirm cut-off date with sales, purchase, production. No material movement on count day. No exceptions. A single rogue dispatch destroys an entire team's count.
The Count: Day-Of Execution
Cut-off discipline
At 6 PM the day before count:
- Stop all material movement
- Close all open vouchers in the system
- Print the system stock report (this is your baseline — do not regenerate after the count starts)
- Lock the inventory module for new entries
Anyone who needs material on count day raises a manual indent and gets it post-count.
Count execution
The teams sweep through assigned zones with count sheets. Rules that prevent rework:
- Count by location, not by item. Every team sweeps its zone, counts everything physically there, regardless of what the system says should be there.
- Two counts on A items. Same team or different teams — but every A-class item gets counted twice and the numbers reconciled before entry.
- Mark counted with a tag or sticker. No item is "counted twice by mistake" because every counted item has a visible mark.
- Scanner over paper, where possible. Phone-based scanners feed counts directly into the system — fewer transcription errors, faster reconciliation.
A 1,500-SKU manufacturer with 8 count teams typically finishes the count in a single Saturday. Bigger operations spread it over a weekend.
What to do with WIP
WIP is where most counts fall apart. The discipline:
- Every WIP job has a job card with current operation marked
- The count team values WIP at material cost only (input material × % complete), not full cost
- For jobs more than 80% complete, count finished goods location instead and reverse the WIP
- For jobs less than 20% complete, count input material instead
This eliminates the "is this job 60% or 70% complete?" arguments.
Reconciliation: Where the Real Work Happens
The count is the easy part. Reconciliation is where most teams give up and just accept the variance.
Step 1: Quick reconciliation
For every item, compare physical count to system stock:
- Variance within 1% — accept and adjust
- Variance 1–5% — flag for review
- Variance above 5% — recount before adjustment
The recount catches counting errors before they become journal entries.
Step 2: Root cause on the big variances
For every variance above ₹25,000 or 10% (whichever is lower), the storekeeper and accounts must agree on a root cause. Common ones:
- Unrecorded scrap from production
- Material returned to vendor without GRN reversal
- Sample issues to QC never booked
- Theft or pilferage (yes, it happens — face it, don't hide it)
- Unit-of-measure conversion errors (kg vs. tonnes, nos vs. boxes)
A variance without a root cause is a variance that will repeat next year. Spending an extra day investigating top 20 variances saves a month of grief next March.
Step 3: Accounting adjustment
- Shortages above book stock — debit to stock variance account, charged to cost or P&L
- Excess over book — credit to stock variance, but flag for review (real excesses are rare; usually it means a prior issue wasn't recorded)
- Damaged or obsolete identified during count — write down with management approval
Get the auditor involved during this step, not after. Surprises during the audit are expensive.
After the Count: Locking the Period
Once reconciliation is complete:
- Lock the inventory period in the ERP. No back-dated entries.
- Publish a stock take report — variance summary by category, top 20 variances with root cause, action items for the year ahead
- Update reorder points based on actual consumption seen during the year
- Schedule the next physical count — quarterly cycle counts on A items, not just one annual marathon
The annual stock take should be the audit confirmation, not the only count of the year. Manufacturers who shift to cycle counting — counting 20–30 items per week on a rolling basis — find their year-end stock takes become a 4-hour formality with near-zero variance. Most modern manufacturing systems including QuoteERP support cycle counting natively.
The Auditor's Perspective
A few things auditors want to see and most manufacturers don't prepare:
- Signed count sheets with date, team names, and counter signatures
- Variance report with root cause for items above a threshold
- Cut-off documentation — last GRN number, last dispatch challan number, last production booking, all before count time
- Slow-moving and obsolete identification with management's decision on each
- Reconciliation of book stock to financials — both physical to book, and book to general ledger
Walking into the audit with this binder ready cuts the audit time in half and avoids most qualification risks.
Common Mistakes to Avoid
- Counting on a working day. Material movement during count creates impossible reconciliations. Use a Saturday or a planned shutdown.
- One person counting their own area. Conflict of interest. Always pair with an outsider to that area.
- Skipping WIP. WIP is usually 8–15% of total inventory value. Skipping it skips the variance.
- Adjusting straight to expense. Some variances are timing differences. Investigate before adjusting.
- No retrospective. Hold a 1-hour debrief two weeks after the count. What worked, what didn't, what will we change next year.
A painless annual stock take is not luck. It is preparation, discipline, and a tool that supports the workflow. If you want to move to a cycle-counting model that makes the annual count a formality, talk to the QuoteERP team at quoteerp.com/contact and we'll show you how SMEs across India have made the switch.