Your system says Warehouse A has 50 units of a product. Someone walks down the aisle, counts the boxes, and gets 46. Now you have four units that exist on paper but not on the shelf.
The first reaction is usually to fix the number and move on. Before you do that, ask where those four units went. Maybe a delivery came in and nobody posted it. Maybe a transfer left for Warehouse B and is still on the truck. Maybe a picker grabbed the wrong item last week.
Inventory reconciliation is the job of checking your records against what’s physically there, finding out why they don’t match, and correcting the record properly. It’s easy enough with one warehouse. Once you have two or three, it gets messy fast. That’s what this checklist is for.
Why It Gets Harder When You Have More Than One Site
With one location, most stock moves happen in front of the same people. With several, stock travels between sites, different teams handle it, and the paperwork often trails behind.
- Transfers get recorded late or wrongly. Stock leaves one warehouse, and the other site only logs it when the truck shows up. For a day or two, the numbers can’t agree.
- Receipts and shipments get posted late. The goods are already on the shelf or already gone, but the entry in the system is still waiting.
- Units and item records don’t line up. If one person counts 12 cases and the record says 144 pieces, it can look like a huge shortage when it’s the same stock in a different unit.
- Adjustments are made without asking why. The number gets fixed, everyone’s happy, and the same gap shows up again next month.
So before anyone changes a quantity, the gap needs an explanation.
Inventory Reconciliation Checklist: Six Steps to Follow
Here’s a simple routine. Use the same steps at every site so the results are easy to compare.
1. Decide What You’re Counting
Pick the warehouse, the location, and the product. Then agree on what counts as stock. Do you include reserved items, damaged goods, quarantined items, or stock in transit? Follow your company policy and write it down. Also set a cutoff time, so receipts and shipments during the count don’t change the picture halfway through.
2. Count the Stock
- Decide who counts and who double checks.
A second pair of eyes catches the mistakes the first person doesn’t see. - Count the same way at every site.
If one warehouse counts by pallet and another by piece, you can’t compare the results. - Recount when a gap looks large.
A lot of big gaps turn out to be a miscount.
3. Compare the Count with the System
Put the two numbers next to each other.
| Detail | Quantity |
|---|---|
| Recorded in the system | 50 |
| Physical count | 46 |
| Difference | -4 |
The four-unit gap is where the work starts. Don’t reduce the system quantity yet.
4. Look at What Moved
Go through the transactions that could explain the difference.
- Receipts and supplier deliveries.
Check whether anything arrived and was counted but never posted. - Sales orders, picks, and shipments.
Stock may have left the building before the record caught up. - Transfers between warehouses.
See if anything is still in transit. - Returns, damaged goods, and write-offs.
Make sure they were recorded at the right site. - Earlier adjustments.
Someone may have already corrected part of the gap.
Going back to our example, say four units are on a transfer that has left Warehouse A but hasn’t been received at Warehouse B. The fix is to finish the transfer. If you wrote off four units instead, you’d create a new problem at the other end.
5. Correct the Record
Only adjust once you’re sure the record is wrong. Plenty of gaps turn out to be timing, and those don’t need an adjustment at all.
- Write down what caused the gap.
The next person who looks at it will thank you. - Get approval if your company requires it.
It’s easier to explain an adjustment when someone signed off. - Add a clear reason and a short note.
“Count correction” by itself doesn’t tell anyone much. - Think about the accounting side.
Changing a quantity can change inventory value too.
6. Check the Result and Keep Your Records
Make sure the new quantity shows up correctly. If something still looks off, count it again.
- Keep the count sheets, references, approvals, and reasons together.
If someone asks about it in six months, you’ll have the answer. - Tell the team about repeat problems.
The people who run receiving and picking can usually fix the cause.
How to Stop the Same Gaps from Coming Back
Fixing one gap is good. Not seeing it again is better.
- Do cycle counts on a schedule.
Counting a few products each week finds problems sooner than one huge count at year end. - Post receipts, shipments, and transfers the same day.
Most gaps start with a delay. - Give every movement an owner.
If nobody is named, nobody follows up. - Keep item codes, units, and location names consistent.
When two names mean the same thing, mistakes follow. - Ask for a reason on every adjustment.
It makes odd patterns easy to spot. - Look at gaps by product, site, and type of transaction.
Repeating patterns tell you more than single events.
For example, if the same product keeps coming up short at one warehouse, check how it’s received, picked, and transferred there before you make another adjustment.
What to Look for in Inventory Management Software for Multiple Warehouses
Software won’t fix bad habits, but the right system makes the checklist a lot easier to follow. Good inventory management software for multiple warehouses should keep your stock records consistent across sites and show how stock moves between them.
- Stock by site and location.
You want to see the quantity at each warehouse, not just one total. - A clear history of movements.
Receipts, shipments, transfers, and adjustments should all show up with dates. - Controlled adjustments.
Each change should carry a reason and a note. - A link to accounting.
Inventory changes should connect to your financial records.
People often search for the best ERP for inventory management. The honest answer is that it depends on your business, how many sites you run, and how much you ship and receive. A few simple questions help more than any ranking.
- Does it handle the warehouse work your team does every day?
- Can you trace a movement when two numbers disagree?
- Does it connect inventory with purchasing, orders, and accounting?
- Which features come with the edition you’re quoted, and which ones cost extra?
Pick the one that fits how your team actually works, even if another one has a longer feature list.
How Versa Cloud ERP Fits into This Process
Versa Cloud ERP covers most of the steps above. For the count, it has a Physical Inventory Worksheet built from your active facility and product inventory records. Your team still needs a good counting routine, but the worksheet gives you a clean place to start.
When the numbers don’t match, you can open a product’s transaction history around the count date. It shows dates, facilities, units, and quantity changes, so you can check receipts, shipments, and transfers before you change anything.
If the record really is wrong, you post an Inventory Item Adjustment. You choose the product, facility, unit, and quantity, then add a reason and a note. The screen shows the current quantity on hand and what it will be after your change. Once you post it, the variance goes into adjustment history, and where general ledger posting applies, it ties to the inventory value entry. Who approves the change is still up to your team.
Versa also has an AI side. Versa AI OpsEngine is the platform behind its Digital Workers, which are AI teammates that help your people. Teams can turn written procedures into executable Playbooks, with human approval and audit history. A checklist like this one is the kind of procedure you could start with.
Signs It’s Time to Look at Your Process Again
If any of these sound familiar, it’s worth a closer look.
- Your counts rarely match the system.
Small gaps that keep repeating usually point to a process problem. - You order stock you think you already have.
It often means nobody trusts the numbers. - Transfers keep causing gaps.
Check timing and ownership first. - Adjustments are going up and nobody can say why.
Somebody should find out what’s behind them. - Finance and operations show different inventory numbers.
They’re probably working from different records.
Final Thoughts
Proper reconciliation is more than just matching up two numbers. You need a count that is available for repeating at any time, a good look into every gap, an adjustment with a purpose and some follow up to ensure that the situation doesn’t happen again. If you have more than one location, you should implement the same procedure.
And if you’d like to see how Versa Cloud ERP handles counts, adjustments, and movement history, take a look at its inventory capabilities or ask for a walkthrough.
Keep Inventory Records And Warehouse Operations Interconnected
When the count of inventory does not coincide with actual stock, it is necessary for your company to do more than just perform a quick correction. It needs an efficient way to look at stock movements, address any discrepancies, and maintain accurate records.
Discover Versa Cloud ERP to discover how inventory management links with purchasing, order management, warehouse operations, and finance.
Feel like knowing how these processes can work for you? Familiarize yourself with Versa Cloud ERP’s inventory management functions or schedule a demo of a Versa Cloud ERP.
