Skip to content
EverAskStart free

Inventory spreadsheet template

Stock levels that flag what to reorder before you run out.

Maple & Moss · StockStock

Examples

Stock, rooms, value and the slow movers. One sheet of items, four ways in.

Maple & Moss · Stock
E2fx=C2/D2
A
B
C
D
E
F
G
H
I
J
K
L
M
N
1
SKU
Item
On hand
Sold / wk
Cover
Status
2
MM-104
Linen throw, sage
46
9
5.1 wk
OK
3
MM-117
Stoneware mug
18
14
1.3 wk
Reorder
4
MM-122
Oak serving board
31
6
5.2 wk
OK
5
MM-130
Beeswax candle
22
16
1.4 wk
Reorder
6
MM-141
Wool cushion, rust
12
4
3.0 wk
OK
7
MM-156
Glass carafe
7
5
1.4 wk
Reorder
8
MM-163
Jute rug, small
9
2
4.5 wk
OK
9
MM-178
Ceramic planter
0
3
0.0 wk
Out
10
11
On hand against reorder point
Reorder atOn handUnder
ThrowMugBoardCandleCarafePlanter
+

On hand against weekly sales, the cover worked out, anything under two weeks flagged.

How it works

  1. Set up your items

    Type SKUs or import a product list. Each item takes a name, category, location, unit cost and reorder point, and you can add your own fields.

  2. Log stock movement

    Record deliveries, sales and adjustments, or upload a sales export. Stock on hand updates per item and per location as you go.

  3. Act on the flags

    Items at or below their reorder point are highlighted with a suggested order quantity. Export the list and send it to whoever places the order.

Features

Who it’s for

  • Maple & Moss · StockStock
    Synced with September sales
    412 orders · 4 to reorder

    Small ecommerce stores

    Keep stock counts in line with sales exports and know what to reorder before a best seller runs out.

  • Maple & Moss · StockRooms
    Stocktake sheet ready
    Front and back room

    Retail and hospitality

    Track stock across a shop floor, a back room or several sites, with a count sheet for the weekly stocktake.

  • Maple & Moss · StockValuation
    Month-end value
    $23,046 at cost

    Makers and small warehouses

    Raw materials and finished goods in one sheet, with values that roll up for the accountant at month end.

Frequently asked questions

What should an inventory spreadsheet include?

SKU, item name, category, location, quantity on hand, unit cost, reorder point and a movement log, with stock value and reorder flags calculated from them.

Is the inventory template free?

Yes. There is a free plan available, and you can set up, track and export your inventory on it.

Can I import my existing product list?

Yes. Upload a CSV or spreadsheet and EverAsk maps the columns to SKU, name, quantity and cost for you to confirm.

Can it tell me when to reorder?

Yes. Items at or below their reorder point are flagged with a suggested quantity, based on your sales rate and the lead time you enter.

Can I export to Excel or Google Sheets?

Yes. Export to .xlsx or CSV with formulas intact, so the file keeps working outside EverAsk.

One prompt in.
Real work out.

Stock levels that flag what to reorder before you run out.

Open the inventory templateSee pricing

EverAsk on your phone and your Mac

EverAsk for iPhone

Ask for the tracker on the train, check the columns, and open it from your phone. Every sheet you make here is on your phone.

Download on the App Store

EverAsk for Mac

Sheets on your desktop, with the exports and CSVs you already have to hand.

Download for macOS