Kolumn

08 / 20 · Purchasing and stock

Inventory with reorder points

Stock levels, reorder points and stock value.

SEK 109

Incl. 25% Swedish VAT. Buyers outside the EU and EU businesses with a valid VAT number pay 20% less.

Also part of the bundle with all 20 templates for SEK 499. All 20 templates

Middle Earth Consulting AB contributes 1% of your purchase to removing carbon dioxide from the atmosphere.

What it does

A simple stock system: items, stock movements and current balance. Each item has a reorder point, and the template tells you when to reorder and shows the stock value.

What you get

Sheets
Items, Movements
Each file also has an instructions sheet and a lists sheet.
Formulas
1002
Files
2 × .xlsx: English and Swedish
Works in
Excel (Windows, Mac, web), Google Sheets, LibreOffice
Macros
None
Licence
One licence per business or household, unlimited internal users

Screenshots

English version with example data
English version with example data
Swedish version with example data
Swedish version with example data

How to use it

  1. Set up your items on the Items sheet with opening stock, reorder point and unit cost.
  2. Record every stock movement on the Movements sheet (item no., date, type, quantity).
  3. Balance, stock value and status update automatically.
  4. Filter the Status column on "Reorder" to get a shopping list.