Excel template: inventory management
Stock, incoming and outgoing goods and stock value in one file – with an automatic alert when an item reaches its reorder level. No registration, ready to use.
What's in the template
Item
SKU, description, location, opening stock, reorder level, order quantity, purchase price – stock, stock value and status are calculated.
Movements
Every goods receipt and issue with date, SKU, type (drop-down list) and quantity.
Overview
Total stock value, units in stock and number of items to reorder.
In three steps
- Create items with opening stock and reorder level
- Record incoming and outgoing goods on the “Movements” sheet
- Reorder items highlighted in red
You fill in the yellow fields; the template calculates the grey ones. You can overwrite the example rows.
Frequently asked questions
Does the template also work in LibreOffice or Google Sheets?
Yes. It only uses standard formulas such as SUMIFS and COUNTIF, which LibreOffice and Google Sheets also support.
When is an Excel list no longer enough?
As soon as you sell on several channels, you have to adjust stock everywhere by hand – which quickly leads to overselling. Multichannel software syncs stock automatically.