Stock Inventory Template with Reorder Alerts (Excel & Google Sheets)
Log stock in and stock out. The sheet keeps the count and turns orange when an item hits its reorder level.
What you get
- Product list with cost, selling price, reorder level and opening stock
- Stock in hand and stock value at cost, updated from your stock moves
- Reorder alert column you can filter
- Sales value this month and a 12-month chart
- Room for 300 products and 2,000 stock moves
Good to know
- Works in Excel 2016 or newer, Google Sheets and LibreOffice. No macros.
- Green cells are for your input. Formula cells are locked so you can't break them by accident.
- Comes with sample data so you can see how it works. Clear the green cells and start.
- Labels in English and Chinese (简体中文).
- Instant download: one .xlsx file with a guide sheet inside.
- Works best for shops with up to a few hundred products. It is not a POS system.
---
记进货、出货,表格帮你数库存,低过补货点就变橙色。
内容
- 商品清单:成本、售价、补货点、期初库存
- 现有库存和库存值(照成本算)自动更新
- 「要补货」一栏,筛选就看到要买什么
- 本月出货金额和 12 个月图表
- 可放 300 样商品、2,000 笔进出货
说明
- Excel 2016 以上、Google Sheets、LibreOffice 都能开,没有宏。
- 浅绿色格子是你填的,公式格锁住了,不怕改坏。
- 里面有示例资料,先看懂怎么用,清掉浅绿色格子就能开始。
- 中英双语标题。
- 付款后马上下载:一个 .xlsx 档案,里面有说明页。
- 适合几百样商品以内的小店,不是收银系统。