An English Excel (XLSX) workbook for small product businesses to list products, record stock movements and see current units, stock value and a reorder list. One-time digital download with a short READ-ME text file.

The problem it solves

Stock counts, sales, deliveries and returns end up in separate notes, so it is hard to know current units, what the stock is worth and what needs reordering.

Who it is for

Small product businesses, makers and online sellers who want a simple spreadsheet to keep track of stock levels and what to order next.

What you get

• Products sheet works out current units as opening stock plus all signed movements, with stock value at unit cost
• Set a reorder point and a target for each product: at or below the reorder point the workbook shows Reorder and the units and cost to order
• Overview sheet summarises products listed, units on hand, stock value, products to reorder, suggested order cost and input issues
• Record sales, receipts, returns and write-offs as signed quantities with date, SKU, reference and notes
• Input check messages flag problems such as negative stock before you rely on the figures
• Room for 200 products and 2,000 stock movements in one file

How you use it

1. Download and extract the ZIP, open MAXORI-INVENTORY.xlsx in desktop Excel and save a working copy.
2. Read the Start Here sheet, then clear the example inputs in Products and Movements, leaving the formula cells unchanged.
3. Enter your business name and currency label in Overview, then add products with a unique SKU, opening units, unit cost, reorder point and target units.
4. Record each movement with a date, SKU, reason and signed quantity.
5. Check Overview and Products: filter Stock status to see what to reorder, and resolve any Input check messages.

Questions