Accurate stock comes from small, frequent counts and from recording every movement when it happens, not from one big count a year.
Why the numbers drift
Stock records drift away from the shelf for ordinary reasons. Goods are received but the receipt is entered the next day. Material is taken for a rush job without a stock entry. A return sits in a corner, physically present but not yet booked. A unit of measure is mixed up, so a box of twelve is recorded as one.
Each of these is small. Together they produce the familiar situation where the system says forty and the shelf says thirty-one, and nobody trusts either number. Once that trust is gone, people start keeping their own spreadsheets, and the drift accelerates.
Record movements at the moment they happen
The most effective accuracy measure is not counting; it is recording. Every movement in Sundial's Inventory module is a document that posts to the stock ledger: purchase receipts, delivery notes, material transfers, material issues for production, returns. The ledger is the single history of what moved, where, when and why.
Make it easy to record at the point of work:
- Receive goods against the purchase order at the dock, from a phone, rather than from paperwork at the end of the day.
- Pick against a pick list, so what leaves the shelf is exactly what was ordered.
- Use a material transfer, not a verbal request, when stock moves between warehouses or to the shop floor.
If a movement is hard to record, people will skip it. The design goal is that recording takes less effort than not recording.
Replace the annual count with cycle counts
A full physical count once a year is disruptive, rushed and often less accurate than people assume. Cycle counting spreads the work across the year: a small set of items is counted every day or every week, and over a cycle every item is counted at least once.
A simple way to set the frequency is by value and movement:
- High-value or fast-moving items: count monthly.
- Medium items: count quarterly.
- Slow, low-value items: count once or twice a year.
When a count differs from the book, post a stock reconciliation with the counted quantity. The difference goes to a stock adjustment account, so finance sees the cost of inaccuracy every month instead of discovering it at year end.
Investigate the difference, not just the number
The value of a cycle count is not the corrected number; it is the reason for the difference. When an item is off, look at its recent ledger entries before adjusting. Typical findings are a receipt entered twice, a transfer received at the wrong warehouse, a unit-of-measure mistake, or a production issue that was never booked.
Fix the process that caused it, not just the quantity. If the same item is wrong two counts in a row, it needs a closer look at how it is handled.
Batches: knowing which lot went where
For food, chemicals, pharmaceuticals, cosmetics and many components, knowing the quantity is not enough. You need to know which batch is on the shelf, when it expires and which customers received it.
With batch tracking switched on for an item, every receipt creates or references a batch with its manufacturing and expiry dates, and every issue and delivery records which batch left. That gives you:
- First-expiry, first-out picking, because the pick list can suggest the batch closest to expiry.
- Expiry reports that show what will expire in the next month while there is still time to sell or use it.
- Traceability in both directions: from a supplier lot to every customer who received it, or from a customer complaint back to the supplier lot.
Serial numbers: one record per unit
For equipment, electronics and anything with a warranty, track individual units with serial numbers. Each serial number has its own history: when it was received, which warehouse it sat in, which customer it was delivered to and when the warranty ends.
That history connects directly to after-sales work. When a customer calls about a fault, the support team can look up the serial number and see the delivery date, the warranty status and any earlier repairs, all in the same system. Sundial's Support module uses the same serial records for warranty claims and maintenance visits.
A routine that keeps stock honest
Accuracy is a habit, so give it a routine:
- Daily: post all receipts, deliveries and transfers the same day. Review documents left in draft.
- Weekly: run the scheduled cycle counts and investigate every difference above a threshold you set.
- Monthly: review the stock adjustment account with finance, check negative-stock attempts and look at items with no movement.
We are building Sundial so an AI agent can prepare the weekly count list and summarize the likely causes of each difference from the ledger, leaving the adjustment decision to your team. To see batches, serials and reconciliation on sample data, try the demo.





