Book a live demo

Articles

Stock Reconciliation: A Monthly Count That Actually Ties

Stock reconciliation made practical: a monthly count routine that gets your godown, your stock register and your books to agree.

Stock reconciliation means comparing what is physically in your godown with what your records say, explaining every difference, and correcting the records so stock and accounts agree. A monthly routine reconciles when you do four things in order: freeze movement, count blind, investigate before you adjust, and post every adjustment through the books. Skip any one of them and next month's numbers will drift again.

Why your counts never seem to match

Most owners who dread the monthly count have the same experience. The storekeeper's register says one thing, sales says another, accounts has a third figure, and the shelf shows a fourth. Usually nobody is lying. The figures disagree because stock moves without being written down.

The usual culprits are ordinary:

  • Unrecorded movements. A carton goes out as a sample, a party returns goods and they are stacked in a corner, raw material is lent to the production floor "for today only".
  • Timing gaps. Goods arrive on the 30th but the purchase bill is entered on the 3rd, so the godown has stock the books do not.
  • Unit confusion. One person counts cartons, another records pieces, a third counts dozens.
  • Damaged and rejected goods. They sit on the same shelf as good stock and get counted as saleable.
  • Duplicate or missing entries. One delivery is entered twice, another is never entered at all.

If you keep extra buffer stock "just in case", be honest about why. Often it is because nobody trusts the register. A routine that reconciles is how you earn that trust back.

Before count day: set it up properly

A good count is mostly decided before anyone touches a carton.

Pick a cut-off and freeze movement

Choose a cut-off time, for example closing on the last working day of the month. After that, nothing enters or leaves the godown until counting is done. If a truck must be loaded, keep those goods in a marked area with their own paperwork so they are counted once, on the right side of the cut-off.

Make sure every receipt, dispatch, return and production issue before the cut-off is entered in the records. If an entry is late, the count will look wrong when it is actually right.

Divide the godown into zones

Split the space into zones or racks and give each one a number. Every zone gets a count sheet. This stops two teams counting the same shelf and makes recounts quick, because you know exactly where to go back to.

Plan around load-shedding. A count that stops halfway in the dark, then restarts an hour later with half the team gone, is how items get counted twice or skipped.

Prepare blind count sheets

The count sheet should list the item and its unit, with no system quantity shown. If the counter can see what the register expects, they will find that number. Blind counting is the single biggest change most businesses can make.

Count day: a simple routine

Run the count the same way every month so people know what to expect.

  1. Work in pairs. One person counts, the other writes. Where possible, the pair should not be the people who run that zone day to day.
  2. Count in the recorded unit. If the record is in pieces, count pieces. Open cartons are counted loose, sealed cartons are counted as cartons and converted on the sheet.
  3. Tag what is counted. A chalk mark or sticker on each counted stack prevents double counting.
  4. Separate damaged stock. Write it on its own line so it does not inflate saleable stock.
  5. Sign each sheet. Both counters sign and note the time.
  6. Compare and recount. Only now do you compare the count with the records. Any difference above a value you set in advance gets a recount by a different pair.

That last step matters. Many differences disappear on recount because the first count was wrong, not the register.

After the count: investigate before you adjust

This is where most monthly counts fail. The tempting move is to overwrite the register with the counted figure and call it reconciled. That fixes the number for one day and teaches you nothing.

Sort every remaining difference into one of four groups:

  • Timing differences. A receipt or dispatch is on the wrong side of the cut-off. Fix the entry date, not the stock.
  • Recording errors. A wrong item code, wrong unit or duplicate entry. Correct the original entry.
  • Counting errors. Found on recount. No adjustment needed.
  • Genuine loss or gain. Damage, theft, breakage, or goods received but never entered. Only this group becomes a stock adjustment.

For each genuine difference, look at who made the related entries and when, and ask the people involved. You are not hunting for a culprit. You are finding the gap in the process that lets stock move unrecorded.

Then post the adjustment properly. It should be approved by someone other than the storekeeper and it must flow into the accounts. If the stock adjustment never reaches the books, your cost of goods sold is wrong, your profit is wrong, and the figures will disagree again at audit time.

Making next month's count easier

The monthly count is a check, not a cure. The cure is in daily habits:

  • Record every movement on the day it happens, including samples, returns and goods lent to production.
  • Nothing leaves the godown without a gate pass or delivery note.
  • Keep a marked area for returns and damaged goods until they are inspected and entered.
  • Count your highest-value or fastest-moving items in small batches every week, so the month-end count holds fewer surprises.
  • Review the month's adjustments with the owner or the director, not just the storekeeper.

When differences shrink month after month, you will know the routine is working.

Where Sentinel fits

The physical count will always be done by people walking the racks. What software can do is keep the record side honest, so the count has something trustworthy to compare against.

In Sentinel, inventory, warehouse, purchase, sales, manufacturing and dispatch sit in one system with accounting, so there is one stock figure instead of three. Every entry records who made it and when, so when you investigate a difference, the stock ledger shows who did what. The books reconcile, with a trial balance that ties, across one company or several.

Sentinel's AI agent works inside the ERP and runs checks across every department: stock below zero, totals that do not add up, missing fields and work left unfinished. Each problem goes to the person responsible for it. A manager can simply ask "Kis item ka stock kam hai?" and get an answer. The agent never changes a record by itself, so adjustments stay a human decision with a clear trail.

Access by role means the storekeeper sees and changes only what their role allows. Shop floor screens can be in Roman Urdu for staff who used to work in Excel, and it all works on desktop and on every phone.

Questions owners ask

How often should we do a full stock count?

Most businesses do a full count monthly or quarterly, with smaller weekly counts of high-value items in between. The right rhythm depends on how fast your stock moves and how much a missing item costs you. If month-end differences are large, count more often until the habits improve.

Should we update the register as soon as we find a difference?

No. Investigate first. Many differences are timing or recording errors that should be fixed at the original entry. Only genuine losses or gains should become an adjustment, and that adjustment should be approved and posted through the accounts.

What if the storekeeper resists blind counting?

Explain that it protects them. A blind count that matches the register is proof their records are good. Rotate counters across zones so it feels like routine, not suspicion, and share the results openly each month.

If you would like to see how one system keeps stock, warehouse and accounts on the same figure, book a live demo. We will walk through it with sample data and answer your questions about your own godown.

Sentinel

ERP · CRM · AI agent