Warehouse Inventory Tracking: How to Track Stock, Run Stock Counts and Not Lose Money
Management4 min read
How to track goods in a warehouse: the stock formula, receipts, sales, returns and transfers, stock counts and discrepancies. A worked example and software.

Warehouse inventory tracking means recording every movement of goods: what came in, what was sold, returned, transferred or written off. If even one movement isn't recorded, recorded stock drifts from the shelf, and the company only finds out about losses at the stock count.
Below: the stock formula, the tracking process, a worked example and stock count rules.
One-minute calculation
- Take the item's stock at the start of the month.
- Add all receipts from suppliers and returns from clients.
- Subtract sales, transfers to other warehouses and write-offs.
- Compare the result with what's actually on the shelf.
- Investigate the difference using the movement log.
The stock formula
Closing stock = Opening stock + Receipts + Returns − Sales − Transfers − Write-offs.
Example: engine oil over a month
| Movement | Quantity |
|---|---|
| Stock on the 1st | 40 |
| Receipt from supplier | +120 |
| Client returns | +3 |
| Sales | −131 |
| Transfer to another bay | −10 |
| Write-off (damaged containers) | −2 |
| Recorded stock | 20 |
| Actual on the shelf | 17 |
| Shortage | 3 |
Three canisters are 3 × 1,900 ₽ = 5,700 ₽ a month. If the log shows that all sales were recorded, look for the cause in receiving, mis-grading or theft.
What to track for each item
| Field | Why |
|---|---|
| Name and SKU | Quick search and no duplicates |
| Unit of measure | Pieces, packs, litres — no confusion |
| Warehouse | Where the goods are |
| Minimum stock | When to reorder |
| Cost price | Profit on every sale |
How to run a stock count
The stock count procedure for accounting purposes is described in the Guidelines approved by Order of the Russian Ministry of Finance No. 49 of 13.06.1995. For management purposes, three rules are enough:
- Regularity. Fast-moving items monthly, the rest quarterly.
- Selectivity. You don't need to recount the whole warehouse: start with expensive and frequently sold items.
- Investigating causes. Every discrepancy is checked against the movement log before it's written off.
Common causes of discrepancies
- A sale was recorded, but the goods were issued from another warehouse.
- A transfer was made without a record.
- Mis-grading: one item was sold but a similar one was written off.
- Receiving without counting: the supplier delivered less than the delivery note says.
Related reading: warehouse software, stock levels, cost of goods.
How it works in Mestra

Movement log: who changed stock, when and why
Mestra is a CRM system: clients, messengers and marketplaces, tasks, finance, analytics and an AI operator in one window.
- Products with SKUs. A product card with name, SKU and cost price.
- Stock by warehouse. Quantity and minimum for each item at each warehouse.
- Automatic movements. A sale or visit reduces stock; a receipt or return increases it.
- Transfers with a comment. Moving goods between warehouses is recorded with a reason.
- Movement log. Who changed what and when — the basis for investigating discrepancies.
- Minimum stock. An "Order from supplier" task appears automatically, and the responsible person is notified.
FAQ
How often should you run a stock count?
Fast-moving and expensive items monthly; the rest quarterly or every six months.
Can you track inventory in Excel?
At the start, yes. As the range and the number of warehouses grow, the spreadsheet can't keep up with sales.
What should you do about a shortage?
First check the movement log, transfers and receiving. Write off a shortage only after investigating the causes.
Do service businesses need inventory tracking?
Yes, for consumables: dye in a salon, materials in a clinic, parts in a car service.
Bottom line
Inventory tracking rests on the stock formula and recording every movement. Regular selective stock counts reveal losses, and the movement log reveals their causes. In Mestra, stock changes automatically on sale and receipt — try it free for 15 days.


