Help for owners
The stock numbers in my system never match what is on the shelf
Short answer
Inventory numbers drift when stock moves without being recorded: returns, damage, transfers, unscanned receipts, bundles, or sales from a channel that does not update the count. Counts also drift when two systems each keep their own number. Find which movement is missing by counting one product, not the whole shop.
Does this sound like your situation?
- The system says there are items on the shelf that are not there, or the reverse.
- I oversell products that are shown as in stock online.
- Every stock take finds the same kinds of differences.
- Staff stopped trusting the numbers and count by eye.
- Returns, damaged goods or samples never appear in the figures.
Why does this happen?
Stock moves that nobody records
Damaged goods, samples, theft, gifts, returns and goods moved between shelves leave the count unchanged unless someone enters them. Square's inventory documentation puts it plainly: a computed count reflects adjustments made since the last physical count, and differences can come from loss, damage or human error.
Confirmed by developer.squareup.com
Receiving is entered late or in the wrong unit
A delivery counted in cartons but entered in pieces, or entered a week after it arrived, makes the count wrong from the first day. Everything sold in between is sold from stock the system did not know about.
Two systems keep their own number
A shop till, a web shop and a spreadsheet may each hold a count. A sale in one reaches the others late or not at all, so they disagree until someone fixes them by hand.
Bundles and variants are not linked to the parts
A gift set sold as one item does not reduce the single items inside it. A product with sizes can be tracked as one item in one tool and as variants in another.
Counts are overwritten instead of adjusted
If staff type a new total instead of recording a change, the history of what moved is lost and the same mistake returns. Some systems keep movements separate from counts so the difference can be traced.
Confirmed by developer.squareup.com
What can I do about it today?
- Count a few products, not everythingChoose five fast-moving products and count them physically today. Compare each to the system and write down the difference.
- Trace one difference backFor one product, list what came in and what went out since the last good count. The missing movement is usually visible within a few minutes.
- Stop typing over totalsAsk staff to record returns, damage and receipts as separate entries so the reason is saved, rather than replacing the number.
- Pick one place that is the truthDecide which system holds the official count, and treat the others as copies.
- Do not delete or merge products to tidy the listMerging or removing products can destroy the history you need to find the leak.
When should I bring someone in?
- The differences are large or appear again after every count.
- Stock is sold from more than one channel or location.
- The inventory data lives in a custom system whose code nobody knows.
How do I handle it?
- Choose a sample and follow every movementI take a handful of products and list every movement the system recorded, then compare to a physical count to see which kind of movement is missing.
- Separate movements from countsThe system stores each change as its own record with a reason, and the count is computed from them, so any figure can be explained.
- Fix the entry pointsReceiving, returns, damage and transfers each get a simple way to be recorded, in the unit staff really use.
- Reconcile on a scheduleA small check compares the count in each connected system and flags a mismatch before a customer meets it.
- Test with a real cycle countAfter the changes, a partial count is made against the system to confirm the differences are smaller and explainable.
The price depends on what I find, so I quote in writing after a short discovery call. Tell me what is happening and I reply within 24 hours.
What do owners ask about this?
Is it normal for counts to be slightly off?
Yes, small differences from loss and human error are normal. What matters is that differences are small, explained and found early.
How often should I do a stock count?
Counting a few fast-moving items often is easier to keep up than one large count a year. Start with the items that sell out or get oversold.
Will new software fix this by itself?
No. Software shows the numbers it is given. The movements still have to be recorded at the shelf, receiving and returns.
Why does the web shop oversell?
Usually because its count is a delayed copy of another system's. A stock check on each sale, or a faster sync, reduces the gap.
Sources
How was this page made?
I drafted this page with AI assistance from the official documents listed under Sources. Found a mistake? Tell me.