Your Cart
Loading

Stock Inventory Template with Reorder Alerts (Excel & Google Sheets)

On Sale
MYR14.90
MYR 14.90
Added to cart

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 档案,里面有说明页。

- 适合几百样商品以内的小店,不是收银系统。

You will get a XLSX (121KB) file