MestraMestra
All posts

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.

M
Mestra Team
Warehouse inventory tracking in Mestra: products, quantities and minimum stock

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

  1. Take the item's stock at the start of the month.
  2. Add all receipts from suppliers and returns from clients.
  3. Subtract sales, transfers to other warehouses and write-offs.
  4. Compare the result with what's actually on the shelf.
  5. 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

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.

Keep reading

Sign up for a demo and see it in action

Niche analysis with ready scenarios and fields

Sign up for a demonstration

Leave your contacts and we will schedule a short demo.

We use cookies

Cookies keep Mestra running, remember your preferences and help us understand how the site is used. See our Privacy Policy, Terms of Service and Consent Form.