Mini-App · Templates

Inventory spreadsheet template: stock in, out, left and what to reorder

For small shops, cafés and online sellers who keep stock and want to know what is left, what it is worth and what to order before it runs out.

One line an item: code, name, group, opening count, in, out, the minimum to keep and its cost. The page works out what is left and its worth, lists what to reorder, and carries the closing count into next month.

Inventory tracker template: stock in, out, left and what to reorder

Try 24 styles:

DataMimiInventory tracker

StockNovemberExample figures

Stock worth525 $9 items

Running low4 itemsGround coffee, Soy sauce, Oat milk 1L

In / out this month440 / 598

To order

Code	Item	Left	Minimum	State
SKU-126	Ground coffee	0	25	● Out of stock
SKU-019	Soy sauce	12	15	● Low
SKU-012	Oat milk 1L	18	20	● Low
SKU-087	Olive oil 1L	8	10	● Low

Worth by group

Worth524.8

Dry goods38%

Pantry24%

Snacks22%

Drinks16%

Items holding the most

Basmati rice 5kg152

Biscuit tin117.6

Olive oil 1L54.4

Pasta 500g45.6

Still water 500ml45.5

Sugar 1kg40.7

Oat milk 1L37.8

Soy sauce31.2

This month's stock

Item	Open	In	Out	Left
Oat milk 1L	40	60	82	18
Pasta 500g	60	48	70	38
Still water 500ml	200	240	310	130
Olive oil 1L	18	12	22	8
Basmati rice 5kg	30	20	34	16
Ground coffee	22	0	22	0
Sugar 1kg	35	20	18	37
Soy sauce	16	10	14	12
Biscuit tin	24	30	26	28

Made with DataMimi · Use this template free

Want it to work exactly your way?

Keep this tool in your Mini-Apps to run it again in one click, or describe the job and AI builds an app of your own.

✦ Make your own app

How to use it

1Press “Add to my Mini-Apps”, then “Enter figures”.
2Type a line at a time; the page does the sums and draws the charts as you go.
3Pick one of 24 styles, light or dark, and print to PDF when you need it.

Common questions

Does this template cost anything?

No. Typing, viewing, changing the style and printing are free and use no credits.

Where is my data kept?

In your DataMimi account, a month at a time. Nobody else sees it unless you share the board.

Can I print it or send it to someone?

Yes. Press Print / PDF, or share the link so others can see your board.

More templates Mini-Apps

Monthly budget template: income, spending, bills and savings on one pageA household budget template you use on the web: type income, spending, bills and savings and the page works out what is left to spend. 24 styles, no Excel.Sign-in sheet template: visitors, staff and deliveries in and outA sign-in sheet for offices, workshops and shops: log visitors in and out and see at once who is still inside. 24 styles, print to PDF, no Excel.Timesheet template: hours, late arrivals, overtime and payA shift timesheet for cafés, shops and small teams: works out hours, late arrivals, overtime and pay for each person. 24 styles, PDF, no Excel.Order tracker template: every sales channel on one pageAn order tracker for online shops: orders from every channel, takings, unpaid orders and the best-selling channel at a glance. 24 styles, no Excel.