Why Inventory Mistakes Keep Repeating
For most trading and manufacturing companies, inventory is one of the largest items on the balance sheet. Yet in many Saudi SMEs it is still run on a mix of spreadsheets, the storekeeper's memory and the purchasing manager's instinct. The results are familiar: best sellers run out in peak season, slow items sit at the back of the shelf for two years, and the year-end count throws up differences nobody can explain.
Inventory problems rarely arrive as one big disaster. They are small habits repeated every day: a receipt posted the next morning, one item carrying two codes, a purchase order based on gut feel instead of consumption data. Each habit costs a little. Over a year they add up to lost margin and cash tied up on the racks.
This guide walks through the inventory management mistakes we see most often, how each one shows up in practice, what it costs, and how to fix it. It ends with a 90-day correction plan you can start before changing any software.
Warning Signs You Have a Problem
If three or more of these sound familiar, inventory is costing you more than you think:
- The annual count shows differences of more than one or two percent of stock value, with no documented explanation.
- Sales staff phone the warehouse to confirm availability before promising a delivery, because they do not trust the system balance.
- Rush purchase orders with premium prices or air freight go out almost every week.
- Nobody can tell you within a few minutes how much stock has not moved in six months.
- Each branch or warehouse codes and records items its own way.
- Cost of goods sold gets a large adjustment at year end after the physical count.
Mistake 1: Late, Manual Recording
The biggest source of stock differences is usually timing, not theft. A truck arrives at four in the afternoon, the goods are shelved, and the receipt is keyed in the next morning. Meanwhile another branch tells a customer the item is out of stock, or a buyer raises a new order because the balance still shows zero.
Issues follow the same pattern. Someone takes two cartons for an urgent job and plans to raise the issue note later, then forgets. Three months on, there is a gap nobody can trace.
How to avoid it
- Set a simple rule: no movement without a document in the system, and no document left open after the shift ends.
- Scan barcodes or QR codes at receiving and issuing instead of typing quantities from paper.
- Receive against the purchase order, so only what was ordered gets accepted and any shortfall shows immediately.
- Block issues without an approved request, with a fast approval path for genuine emergencies.
Mistake 2: Dirty Item Master Data
The same product appears as "Engine oil 5W30 1 liter" and "Oil 5W-30 1L" under two codes. A carton of 24 cans is bought by the carton and sold by the can, with no correct conversion factor. These look like admin details, but they make every report built on top of them unreliable.
How to avoid it
- Adopt one coding convention based on category, supplier and specification, and apply it to every new item.
- Define a base unit of measure for each item, plus purchase and sales units with their conversion factors, once, on the item card.
- Give one person or a small team the right to create items, instead of letting every user add them.
- Clean up regularly: merge duplicates and deactivate items you no longer buy or sell.
Mistake 3: Giving Every Item the Same Attention
A distributor with 3,000 SKUs cannot watch every one daily, and should not try. The common error is treating a one-riyal screw with the same care as a product that drives a tenth of revenue. Time disappears into detail while the items that matter slip.
ABC analysis ranks items by annual consumption value. In many businesses a small share of items accounts for most of the value; those are your A items. The exact split varies, so calculate it from your own data rather than assuming the textbook ratio.
| Class | Profile | Review frequency | Cycle count frequency |
|---|---|---|---|
| A | High consumption value, few items | Weekly or daily | Monthly |
| B | Moderate value | Every two weeks | Quarterly |
| C | Low value, many items | Monthly | Twice a year or annually |
Our guide to ABC analysis covers the calculation step by step.
Mistake 4: Buying Without a Reorder Point
If purchasing starts when someone notices an empty shelf, you are always late by exactly one supplier lead time. A reorder point fixes that. It is the balance at which a new order must go out so that goods arrive before you run out.
The basic formula: reorder point = average daily usage × lead time in days + safety stock.
Hypothetical example: an item sells 40 units a day, the supplier needs 12 days, and you want five days of safety cover. Reorder point = 40 × 12 + 40 × 5 = 480 + 200 = 680 units. When the balance hits 680, the order goes out.
The related mistake is setting the number once and never revisiting it. Demand jumps in Ramadan and back-to-school season; sea freight delays stretch lead times. Review reorder points for A items at least quarterly. Our article on the inventory reorder point goes deeper.
Mistake 5: Overstocking Out of Fear
After one painful stockout, buyers often overcorrect: "order double so it never happens again." It feels prudent. It is expensive.
Carrying cost goes well beyond the purchase price. It includes the cost of capital tied up, warehouse rent, power and cooling through the Saudi summer, insurance, labor, damage and obsolescence. Together these can be a meaningful percentage of stock value every year, depending on the sector and product.
Hypothetical example: a company holds SAR 800,000 more stock than it needs. At an assumed carrying cost of 20% a year, that excess costs SAR 160,000 annually and buys almost nothing in return. That could be two or three salaries.
How to avoid it
- Estimate your own carrying cost, even roughly, and put it in front of buyers for every large decision.
- Size safety stock from demand variability and lead time, not from a round number.
- Track inventory turnover monthly by category.
Mistake 6: Leaving Dead Stock Undecided
Every warehouse has a corner nobody visits: obsolete items, returns nobody processed, materials bought for a cancelled project. This stock takes space, sits on the balance sheet at a value you cannot realize, and hides your true profit.
The decision keeps getting postponed because it hurts. Selling at a discount means admitting a loss. Postponing does not remove the loss; it adds another month of storage on top.
How to avoid it
- Define dead stock clearly, for example no issues in 180 days.
- Run a monthly report listing those items and their value.
- Make one of four decisions per item: return to supplier, discount or bundle, transfer to a branch that needs it, or write off.
- Where net realizable value has fallen below cost, write the stock down under IAS 2 and expense the difference.
See our full guide to dead stock for disposal options.
Mistake 7: Counting Only Once a Year
A full annual count is necessary, but on its own it means an error made in February is found in December, after ten months of decisions built on it. The longer the gap, the harder it is to find the cause.
Cycle counting solves this. Each week a set of items is counted, so A items are covered several times a year and everything at least once. Differences surface early and can be tied to a specific transaction.
Keep the legal side in view too. The Saudi Commercial Books Law requires year-end inventory to be recorded in the inventory book, and the new Commercial Transactions Law approved by the Council of Ministers in October 2026 will replace it 180 days after publication, so watch for its implementing rules. Our stocktaking guide covers the practical steps.
Mistake 8: Inventory Disconnected From Sales, Purchasing and Accounts
When stock lives in one program, sales in another and accounting in a third, the same problems repeat:
- A sales rep sells an item that appears on the price list but is not in stock.
- A buyer orders an item that is sitting in another branch, because branch balances are invisible.
- Accountants rekey purchase invoices, and the stock value in the ledger drifts from the warehouse figure.
- Cost of goods sold is estimated at month end rather than taken from actual cost.
The structural fix is a single system where each movement is recorded once: the sales order reserves stock, the delivery deducts it, and the invoice posts the accounting entry at the right cost.
Mistake 9: Ignoring Real Lead Times
The supplier quotes one week. In practice deliveries arrive after ten days and sometimes three weeks. If your calculations use the quoted number, you will keep running out without understanding why.
Record the order date and actual receipt date for every shipment, then calculate the real average lead time and its variability per supplier. The same data helps you rate and negotiate with suppliers. Importers should add customs clearance and inland transport from the port, because that time is part of the lead time too.
Mistake 10: Untrained Staff and Open Permissions
The best system will not stop errors if users do not know when to post a transfer versus an issue, or if anyone can edit balances directly. Open permissions make errors untraceable and invite manipulation.
How to avoid it
- Role-based training for storekeepers, buyers, accountants and sales staff, each on what they actually do.
- Segregation of duties: the receiver does not approve the invoice, the counter does not adjust the balance.
- Count adjustments above a threshold require senior approval.
- An audit trail showing who changed what and when.
Mistakes at a Glance
| Mistake | Direct impact | Core fix |
|---|---|---|
| Late manual recording | Wrong balances, count differences | Real-time scanning, receive against PO |
| Dirty item data | Misleading reports, duplicates | One coding rule, defined units |
| No classification | Wasted effort, key items unwatched | ABC analysis |
| No reorder point | Frequent stockouts, rush orders | Reorder point plus calculated safety stock |
| Overstocking | Cash tied up, carrying cost | Track turnover and carrying cost |
| Dead stock | Overstated book value | Monthly report, decision per item |
| Annual count only | Late discovery of errors | Continuous cycle counting |
| Disconnected systems | Selling unavailable stock, double entry | Integrated ERP |
| Quoted lead times | Stockouts despite open POs | Measure actual lead time per supplier |
| Weak training and controls | Untraceable errors | Role training, segregation of duties |
A 90-Day Correction Plan
Do not try to fix everything in a week. Here is a realistic sequence for a mid-sized company.
Month one: data
- A full count, or at least an A-item count, to establish a correct starting point.
- Clean item cards, merge duplicates, standardize units of measure.
- Name an owner for item creation and set permissions by role.
Month two: process
- Enforce same-shift recording for receipts and issues.
- Calculate ABC classes and reorder points for important items.
- Start weekly cycle counts.
Month three: monitoring
- Monthly dead-stock report with a decision for each line.
- Review cycle count accuracy, turnover and stockout frequency.
- Decide whether current tools are enough or an integrated system is now justified.
Metrics That Show Progress
- Inventory accuracy: share of counted items whose physical quantity matches the system.
- Turnover: cost of goods sold divided by average inventory value.
- Days of inventory: how many days current stock lasts at the current usage rate.
- Fill rate: share of orders shipped complete from stock without waiting.
- Dead stock value: value of items with no movement beyond your threshold, as a share of total inventory.
Start with these five and review them monthly. If they improve, you are on the right track.
Where an ERP Helps
Software does not repair bad processes by itself, but it makes good ones easier to follow and to check. In Tranquil, the inventory management module works with sales, purchasing and accounting in one cloud system, so each movement is recorded once and shows up everywhere it matters. It supports central inventory, pre-assemblies and assembly, and multiple units of measure per item, which are exactly the areas where simpler tools tend to break.
On the sales side, the flow runs from quotation to invoice, delivery and returns in one path, with ZATCA-compliant e-invoices. Sales, stock and VAT all work from the same numbers.
Frequently Asked Questions
Which inventory mistake costs the most?
It depends on the business, but overstocking and dead stock are often the most expensive because they tie up cash and add carrying cost every month. Stockouts show up as lost sales and damaged customer trust.
What count difference is acceptable?
There is no official universal threshold. What matters is that differences are explained, documented and shrinking over time. Many companies set a tighter internal accuracy target for A items than for the rest.
Is Excel enough to manage inventory?
It can work for a small company with few items and a single warehouse. With several branches, warehouses and users, it becomes hard to control permissions, record in real time and stay reconciled with accounting.
How often should we count stock?
At least one full count a year, plus continuous cycle counts that cover important items more often. Cycle count frequency should follow item value and how fast it moves.
How does Tranquil help avoid inventory mistakes?
Tranquil connects inventory with sales, purchasing and accounting in one system and supports central inventory, multiple units of measure and assembly. Contact the Tranquil team to review your current inventory setup.