Clearer operations, more reliable information · Stock accuracy
A stock count tells you what is there. Reliable inventory records also explain how it got there, where it belongs and what happened when it moved.
When the warehouse count and the stock report disagree, another adjustment may bring the figures together for today. Understanding the difference is what helps them stay together tomorrow.
The starting point is not necessarily new software. It is a comparison of the same product, location, unit of measure and point in time, followed by a review of the movements behind the balance.
First, make sure you are comparing the same thing
A warehouse count and a system report can both be correct while covering different things. Check whether the report includes other locations, goods in transit, returns awaiting inspection or stock belonging to someone else. Confirm whether the quantity is in individual units, packs or cartons.
Also distinguish on-hand stock from stock available to sell. Reservations can reduce availability without changing the physical quantity. That is a different question, covered in our guide to stock availability and sales orders.
Follow the difference back to a movement
Once the scope is aligned, start with a recent verified balance and follow receipts, deliveries, transfers, returns and other movements up to the count time. Look for the point at which the physical activity and its record stopped matching.
Illustrative example · one product, one location
The report says 100. The count says 94.
Same unit of measure and cut-off time. No other movements in this simplified example.
What physically happened
What the system recorded
Posting an unexplained −6 adjustment would match the count, but would not explain the delivery or return.
Resolve the records, then follow the consequences
Verify the dispatch and return documents. Complete the appropriate authorised corrections without duplicating movements. Then check related billing, any credit decision and the relevant valuation or reporting treatment.
Where stock discrepancies can begin
Receiving and delivery are recorded at different times
Goods may be received before the receipt is recorded, or leave before the delivery is confirmed. Partial deliveries can add another difference if the ordered quantity is recorded instead of the quantity actually moved. Agree who records the movement, when, and which document confirms the actual quantity.
Transfers lose their destination
A movement between stores or branches changes where stock is held. If only one side is recorded, one location can appear short while another appears overstated. Review source, destination and any in-transit stage before treating the difference as a loss.
Returns and damaged goods follow an informal route
A returned item might be back on the premises but still awaiting inspection. Damaged goods may remain physically present while being unsuitable for sale. Define where these items are kept, their status and who approves their next step. This makes the distinction between physical presence, usable stock and financial treatment visible.
Product codes and units do not match
Duplicate product records, similar item names or a carton entered as a single unit can distort a balance even when the physical handling was correct. Check the item identity and conversion before adjusting the quantity.
How to investigate a stock difference
- Confirm the count. Recount the affected item and agree the locations, ownership, stock status and unit being compared.
- Set a cut-off. Pause movements in the count area where practical, or keep a clear record of movements during counting so they can be reconciled.
- Trace the documents. Compare recent receipts, deliveries, transfers and returns with the system history. Include pending and duplicated transactions.
- Correct with evidence. Use the appropriate transaction correction or approved inventory adjustment. Record the reason, supporting document and authorisation; avoid recording the same movement twice.
- Address the recurring cause. Clarify the handover, access rights, validation step or configuration that allowed the gap, then check whether it happens again.
Connect the warehouse finding to the wider business
A quantity correction is not the end of the review. A delivery discrepancy may affect what should be invoiced. A return needs a separate commercial decision about replacement or credit. Damaged goods may require a review of their value and treatment.
Follow each finding to its related records and reports with the responsible finance team. The accounting effect depends on the transaction, policies and system configuration. Clear account classification helps explain the outcome, alongside appropriate posting rules, reconciliation and review.
Build accuracy into everyday work
Use focused counts to check selected products or locations between larger stocktakes. Prioritise areas with recurring differences, frequent movements or significant business impact. Track the reasons for discrepancies as well as the quantities corrected.
If you use Odoo, physical inventory adjustments and location-based cycle counts can support this work. The workflow still needs clear responsibilities for counting, investigating and approving corrections. See Odoo’s documentation on inventory adjustments and cycle counts.
Common questions about stock accuracy
Will a stock adjustment solve the problem?
It can correct a confirmed balance, but it does not by itself resolve a missing document or recurring process gap. Establish the cause and check for pending movements before applying an adjustment.
Do stock discrepancies mean we need to replace our software?
Not necessarily. Timing, product data, responsibilities or configuration may explain the difference. Consider replacement when the system cannot reliably support the controls and workflows you need. Our software decision guide explains how to assess that choice.
How often should we count stock?
Choose a frequency that reflects movement levels, value, previous differences and operational capacity. A focused count programme should leave time to investigate and resolve findings, rather than repeatedly adjusting the same items.
Start with one product and one recent difference
Bring together the count, the movement records and the people involved. That small review can reveal whether the next step is clearer processes, better configuration or a broader system change.
Consigliere helps connect operational workflows, records and reporting through business consulting and process improvement, Odoo review and optimisation, and Odoo implementation.