Get inventory off spreadsheets — track stock movements and purchase orders in one system
When inventory lives in a spreadsheet, the count on the sheet and the count on the shelf drift apart the moment two people update it at the same time — and purchase orders tracked in a different document make it worse. A proper stock-movement ledger, computed from every inbound and outbound transaction, keeps the number honest.
Why spreadsheet inventory drifts from reality
A spreadsheet has no concept of “this many units moved in, this many moved out.” Someone edits a running total by hand, and if two people update it around the same time, or someone forgets an entry, the number quietly stops matching what is actually on the shelf. Nobody notices until a stocktake turns up a mismatch.
Purchase orders tracked in a separate document make it worse — there is no automatic link between “we ordered this” and “this arrived and is now in stock,” so someone has to reconcile the two by hand.
Compute stock from a movement ledger, not a running total
d-bye’s inventory template tracks every inbound and outbound transaction as a stock movement record, and computes on-hand quantity per product and warehouse from that ledger — not from a number someone edits directly. That is the same principle behind double-entry bookkeeping: you trust the transaction log, not a hand-maintained total.
Products, categories, suppliers, and warehouses are proper master data with foreign keys, so a purchase order and the resulting stock movement stay linked, and typed search lets you filter by any of them.
See stock levels and pull a report without a manual count
The dashboard and list screens show current stock by product and warehouse directly, with typed search and filtering built in. When you need a paper or PDF stock report — for an audit, a stocktake, or a supplier — it generates straight from the same data, not a separately maintained document.
Try it before you build anything
The template previews with sample products, warehouses, and stock movements already in place. It is faster to see how the ledger and dashboard behave with real data first, then adjust the fields to match your own product catalog.
See it for yourself
Preview this exact template and generate working code from it.