Why Stocktaking Goes Wrong in So Many Companies
On the last day of the financial year the warehouse closes, staff are pulled in from other departments, printed count sheets are handed out and the counting begins. Two exhausting days later the result arrives: variances worth tens of thousands of riyals and no clear explanation. Was it a counting error, a recording error or genuine loss? A large adjustment is posted, and everything goes back to normal until the next count.
That story is familiar in retail, distribution and manufacturing. The problem is not effort; it is method. Efficient stocktaking does not mean counting fast. It means preparing properly, choosing the right counting approach, controlling movement during the count, tracing variances to their root causes and fixing those causes.
This guide covers practical tips for every stage, from planning before count day to the accounting adjustments afterwards. It compares counting methods and shows how an ERP system turns stocktaking from a painful annual event into a continuous, controlled process.
What Stocktaking Is and Why You Cannot Skip It
Stocktaking is the physical count of goods and materials in your warehouses and branches, compared against the quantities in your system, followed by reconciliation of the differences. The aim is a record that matches reality, because almost every decision depends on it: when to reorder, what you can promise customers, the inventory value on the balance sheet and the cost of goods sold that determines your margin.
In Saudi Arabia, the Commercial Books Law of 1989 required merchants to record the goods held at the end of the financial year in an inventory book. In October 2026 the Council of Ministers approved a new Commercial Transactions Law that replaces the Commercial Books Law along with two other laws; it takes effect 180 days after publication in the official gazette, so it is worth following the published text and its regulations for the new record-keeping requirements. Regulation aside, your external auditor will usually want to attend the count or review its results, because inventory is one of the balance sheet items most prone to error.
Accuracy also shapes customer service. A sales rep who promises a quantity the system shows as available, only for the warehouse to find it is not there, loses the customer's trust before losing the sale. A planner who sees phantom stock does not reorder in time, and a stockout follows.
Above all, inventory is capital. A distributor carrying SAR 8 million of stock with a 2% gap between records and reality has SAR 160,000 it cannot account for.
Stocktaking Methods Compared
No single method is right for everyone. The choice depends on the number of SKUs, their value, how fast they move and whether you can afford to stop operations.
| Method | How it works | Strengths | Limitations |
|---|---|---|---|
| Full periodic count | Count everything once or twice a year with movement frozen | Complete snapshot at a fixed date, suits year-end close | Stops operations, exhausting, errors pile up between counts |
| Cycle counting | Count a small group of SKUs daily or weekly on a schedule | No shutdown, problems surface early | Needs discipline and a system to manage the schedule |
| Spot checks | Unannounced counts of selected items | Deters negligence and manipulation | Does not cover the whole inventory |
| Blind count | Counters do not see the system quantity | Removes bias toward the expected number | Needs a recount when variances appear |
| Perpetual inventory | Every transaction updates balances in real time | Always-current balances | Still needs physical counts to verify |
For most mid-sized companies the most effective combination is cycle counting throughout the year plus one full count at year end. That final count is faster and cleaner because records have been corrected along the way. Some companies with disciplined cycle counting agree with their auditor to rely on it instead of a full count, but that is a decision to make with the auditor, not alone.
Before Count Day: Preparation Is Half the Job
1. Organize before you count
A messy warehouse doubles the time and the errors. A week before the count, consolidate each SKU into as few locations as possible, move damaged or returned goods into a clearly marked quarantine area, and make sure every rack and bin has a visible location code. If your warehouse has no location system yet, start with our guide on organizing your warehouse.
2. Clear pending documents
Unposted goods receipts, issues that left the building without being recorded, and inter-warehouse transfers still in transit all create phantom variances. Ask every department to post all documents by a fixed time the day before, then freeze movement.
3. Set a cut-off time
The cut-off is the moment system balances are frozen for comparison. Everything received before it is counted; anything arriving after it stays in the receiving area and is excluded. This one rule prevents a large share of variances.
4. Assign teams and zones
Split the warehouse into zones and assign two people to each: one counts, one records or verifies. Ideally the storekeeper does not count their own area but acts as a reference for questions, separating custody from control.
5. Prepare the tools
Charged barcode scanners connected to the system, or numbered printed count sheets if scanners are not available, plus stickers placed on each location once counted so nothing is counted twice or missed. Scanning alone removes most transcription errors because counts go straight into the system without re-keying.
During the Count
6. Count blind
When a counter sees that the system expects 120 cartons, they tend, without meaning to, to arrive at 120. Hide system quantities from counting teams and ask them to record only what they see. Comparison happens afterwards.
7. Watch units of measure
Mixing cartons, packs and pieces is one of the most common errors. An item stocked in pieces but counted in cartons of 24 produces a huge variance. Define the counting unit for every SKU before you start and print it on the count sheet.
8. Recount large variances
Set a threshold that triggers a recount, for example any variance over 5% of quantity or SAR 1,000 in value. A different team performs the recount. Many variances disappear on the second count because they were counting mistakes, not real losses.
9. Remember stock outside the warehouse
Consignment stock at customers, materials on project sites, goods in transit and stock in sales vans are all part of your inventory. List them beforehand and decide how each will be counted or confirmed.
After the Count: Where the Value Is Created
10. Analyze before you adjust
Adjusting without analysis fixes the number and leaves the cause. Classify every material variance by its likely cause:
- Counting error: caught in the recount.
- Recording error: a receipt keyed with the wrong quantity, an unrecorded issue, or an item booked under another item's code.
- Item mix-up: a surplus in one SKU matched by a shortage in a similar one, a pattern that points to identification or storage problems.
- Unrecorded damage: damaged or expired goods never written off in the system.
- Real loss: theft or misplacement, which needs investigation and stronger controls.
This analysis is what turns stocktaking from an accounting exercise into an improvement tool. For a deeper look at loss types and causes, see our article on inventory shrinkage.
11. Approve adjustments with clear authority
A storekeeper should never adjust their own variances. Set approval levels by value: small variances approved by the warehouse manager, larger ones by the finance manager. Post adjustments to a dedicated stock variance account so you can track their size over time.
12. Track inventory accuracy as a standing KPI
Inventory accuracy is the share of counted SKUs whose physical quantity matched the record within an agreed tolerance. If you count 500 SKUs and 460 match, accuracy is 92%. Track it after every cycle. Many companies aim for 98% or better on their important items, but the real test is whether your number improves from one cycle to the next.
Cycle Counting With ABC Classification
Not every SKU deserves the same attention. ABC analysis ranks inventory by value: A items are few but carry most of the value; C items are many and individually cheap. Use the ranking to set counting frequency:
| Class | Typical share | Suggested frequency |
|---|---|---|
| A | About 20% of SKUs, most of the value | Monthly |
| B | About 30% of SKUs | Quarterly |
| C | About 50% of SKUs, small value | Twice a year or annually |
Example: a warehouse with 2,400 SKUs has 480 A items. Counting them monthly means about 22 SKUs per working day, under an hour for a small team. Your most important items get counted twelve times a year without closing the warehouse for a single day. The full method is in our guide to ABC analysis.
Example: A Distributor Moves From Annual to Cycle Counts
Picture a food distributor in Jeddah with around 1,800 SKUs in its main warehouse, relying on one full count each December that took two days and halted deliveries. The last full count showed large variances, and the team could not explain most of them because errors had built up over a whole year.
Management classified items with ABC analysis, introduced short daily counts for A items and weekly counts for B items, and kept one annual full count. The first months produced plenty of variances, but analysis exposed two recurring patterns: similar-looking items being issued under the wrong code, and receipts keyed from the supplier invoice instead of the physical count at the dock. Once both procedures were fixed, variances fell steadily, and the annual count became shorter because most balances were already right.
The numbers are illustrative, but the principle holds: cycle counting reduces variances not because counting more often is magic, but because it exposes causes while they are still fresh enough to trace.
Counting Branches and Points of Sale
- Count outside peak hours: in Saudi retail, evenings and weekends are usually busiest, so early mornings are best for partial counts.
- Close pending transfers: goods sent from the warehouse that the branch has not confirmed are a classic source of variances on both sides.
- Separate returns: customer returns should be inspected and recorded before going back on the shelf, or good and damaged stock gets mixed.
- Compare branches: a branch that keeps showing variances on the same item needs its procedures reviewed specifically.
Accounting for Variances
If the physical count is lower than the record, the shortage is recorded as an inventory loss and the stock balance is reduced. If it is higher, stock is increased against the variance account. Under perpetual inventory, the adjustment is posted against the item at its cost, so quantity and value update together.
Recurring variances in the same direction are not noise. A steady monthly shortage on certain items deserves investigation, and a steady surplus may mean receipts are recorded below actual quantities, which is a supplier issue, not a counting one.
How an ERP Changes Stocktaking
Counting on paper, typing results into a spreadsheet and comparing them with records takes days and adds keying errors on top of counting errors. An ERP shortens the whole cycle:
- Generates count lists by warehouse, location or category, with system quantities hidden for blind counts.
- Freezes balances at cut-off and compares count results against them directly.
- Shows variances by quantity and value, ranked for recounting.
- Posts approved adjustments so quantities and accounting values update together.
- Keeps the history of every count, so accuracy can be compared across periods.
Tranquil inventory management gives real-time stock visibility from one place, with central inventory and multiple units of measure, connected to purchasing, sales and accounting. Warehouse management and barcode integration are also part of Tranquil's solutions. That integration is what keeps variances low in the first place, because every movement is recorded where it happens.
Frequently Asked Questions
How often should we take stock?
At minimum, once at financial year end. Better practice adds cycle counts during the year: high-value items monthly and lower-value items quarterly or twice a year.
What is the difference between cycle counting and perpetual inventory?
Perpetual inventory is a recording method that updates balances with every transaction. Cycle counting is a regular physical count of selected items to check that those balances are right. One does not replace the other.
Do we have to stop operations during a count?
For a full count, usually yes, or at least in the zone being counted. Cycle counts run without stopping the business, with movement of the counted items frozen briefly.
What variance level is acceptable?
It depends on the industry and the items. Set a tolerance per category, investigate anything beyond it and follow your accuracy trend over time rather than a single figure.
Does Tranquil support barcode counting?
Tranquil includes barcode integration and inventory management linked to warehouses and accounting. Contact the Tranquil team to discuss the right counting setup for your warehouse.