Why AutoCount Stock Balance Differs From Your Physical Count
You open AutoCount.
The stock balance shows one number.
The warehouse count shows another.
Now accounts, sales, and warehouse are all asking the same thing:
Why does AutoCount stock not match the physical count?
Most of the time, the first answer is not "AutoCount is wrong".
The mismatch usually starts when the real stock movement and the AutoCount document no longer match.
It may be caused by timing, posting settings, document transfer, receiving mistakes, stock location, unit of measure, unrecorded stock movement, or stock adjustments.
The fastest way to find the problem is simple:
Pick one item with a mismatch and trace where the physical stock and AutoCount stock started to split.
This is a count-to-report diagnosis.
The goal is to compare the same item, same location, same unit, and same cut-off before changing settings or posting another adjustment.
Why AutoCount Can Look Right, But The Shelf Count Is Different
AutoCount shows stock based on documents, dates, locations, units, and posting rules.
The shelf count shows what is physically in the warehouse.
If the two are not checked using the same cut-off and the same location, the numbers can be different.
Common causes include:
- stock moved before the document was updated
- a document was created but did not post to stock
- a Delivery Order (DO) or Invoice was retyped instead of transferred
- the report was printed for the wrong date
- stock was posted to the wrong location
- cartons, boxes, and pieces were mixed up
- samples, damaged goods, internal use, or free-of-charge (FOC) items were not recorded
So instead of only asking, "Is AutoCount wrong?", ask:
Which physical movement happened, and which AutoCount document recorded it?
First, Check The Count Date And Report Date
Before checking settings, check the timing.
Was the physical count done at the same date and time as the AutoCount report?
Example:
Your warehouse finishes counting at 5pm.
Later, someone keys in documents using an earlier date.
Now the AutoCount report changes after the count sheet was already signed.
This can make a timing issue look like missing stock.
Check these first:
- physical count date
- physical count time
- AutoCount report date
- report filters
- stock location filter
- transactions keyed after the count
- backdated Goods Received Note (GRN), Delivery Order (DO), Invoice, Purchase Invoice, or stock adjustment
If the count and the report do not use the same cut-off, you may be comparing two different moments.
Check Which Document Posted To Stock
Next, find out which document actually changed the stock balance.
In AutoCount, different documents can affect stock differently depending on your setup and document flow.
For example:
A Goods Received Note (GRN) usually records goods received into inventory.
A Delivery Order usually records stock going out.
Invoices and Purchase Invoices need more care, especially when they are transferred from earlier documents.
If an Invoice is transferred from a Delivery Order that already reduced stock, the document trail matters.
If a Purchase Invoice is transferred from a GRN that already increased stock, the source trail also matters.
So do not only ask:
Was the document created?
Ask:
Which document posted to stock in this setup, and was it transferred from the correct source?
Check Whether The Invoice Was Transferred Or Retyped
Document transfer is a common place where the trail breaks.
When staff transfer from the correct source document, it is easier to trace what happened.
When staff create a fresh document by retyping, the numbers may look correct, but the document trail becomes weak.
Example:
- A Delivery Order reduces stock.
- Later, staff creates a new Invoice manually instead of transferring from the DO.
- The Invoice looks correct to the customer.
- But the link between delivery and billing is broken.
The same can happen on the purchasing side.
- A GRN records received stock.
- Later, accounts creates a new Purchase Invoice manually instead of transferring from the GRN.
- The supplier bill may look correct.
- But the link between receiving and supplier invoice is weak.
When AutoCount stock does not match the physical count, check whether the documents were transferred or retyped.
Check The Receiving Flow From PO To GRN To Purchase Invoice
Receiving is where your stock number starts.
If the receiving number is wrong, the shelf and AutoCount may disagree later.
Common receiving problems include:
- supplier sends 80 units, but staff records 100
- damaged goods are received as normal sellable stock
- supplier DO quantity is not checked
- GRN is created late
- goods are placed on racks before location is recorded
- Purchase Invoice is keyed later without checking the GRN
You do not need to check every receiving issue at once.
Start with this question:
Did the PO, supplier document, GRN, Purchase Invoice, stock location, and unit of measure all show the same story?
For more detail, read why goods receiving is where inventory problems start.
Check Stock Location And Unit Of Measure Before Adjusting
Not every mismatch means stock is missing.
Sometimes the stock is in the wrong location.
Sometimes the stock is recorded in the wrong unit.
Example:
AutoCount shows 50 units in total.
But all 50 are shown under Main Warehouse.
Physically, 30 are in Main Warehouse and 20 are at a branch.
The total stock is correct, but the location is wrong.
Another example:
Supplier sends 10 cartons.
Each carton has 24 pieces.
The system records 10 pieces instead of 10 cartons.
The shelf has 240 pieces, but the report shows 10.
Before posting a stock adjustment, check:
- stock location
- default location
- unit of measure rate
- report unit of measure
- whether the report is showing cartons, boxes, or pieces
Separate Normal Stock Movement From Stock Adjustment
Not every stock movement is a sale.
Stock may also move because of:
- samples
- damage
- expiry
- warranty replacement
- FOC items
- showroom use
- internal use
- repacking
- write-off
These movements need clear rules.
Some may need a stock issue document.
Some may be write-off.
Some may need approval.
If these movements only happen through WhatsApp messages or staff memory, AutoCount may never get updated.
Later, the physical count is short.
Then someone posts a stock adjustment.
The adjustment fixes the number, but it does not explain why the stock moved.
If adjustments have become normal, read why stock adjustments hide the problem.
Trace One SKU Before Changing Settings
Before changing AutoCount settings, choose one item that often has a mismatch.
Trace it step by step.
Check:
- Stock Card
- Stock Balance by location
- Source document
- Posting status
- Stock location
- Unit of measure
- Receiving record
- Delivery or stock issue record
- Transfer record
- Adjustment history
You are looking for the first point where the physical movement and AutoCount movement became different.
That point tells you what to fix.
It may be:
- report timing
- posting setup
- receiving process
- document transfer
- stock location
- unit of measure
- adjustment control
Do this before posting another blind stock adjustment.
When The Problem Is Workflow, Not AutoCount
If your stock mismatch is small and rare, a checklist may be enough.
Start with the missing stock checklist.
But if stock moves through warehouse, sales, delivery, purchasing, branches, and accounts, a checklist may not be enough.
You need a workflow that captures the physical movement first, then sends clean data into AutoCount at the right time.
That may mean improving the inventory and warehouse system around AutoCount, not replacing AutoCount itself.
AutoCount can still be your accounting backbone.
But the warehouse process around it must be clear.
If AutoCount stock does not match your physical count, do not start with blame.
Pick one recurring stock variance and trace it from shelf, to document, to AutoCount.
For the fix path, read the AutoCount stock not matching physical count solution or review AutoCount integration.