Stationery store inventory template, free
Hundreds of low-priced items, and back to school takes them all at once. See how many you have of each and what to order before it runs out.
- By category: school, office, art, gifts and copies
- Flags in red what to reorder before the season
- Stock count sheet that works out the difference for you
Download it free
Leave your email and it downloads right away.
What's inside
Five tabs, each doing one job
| Product | Category | Location | Price | Cost | Stock | Minimum | Reorder? |
|---|---|---|---|---|---|---|---|
| Notebook | School | Shelf 5 | $35.00 | $22.00 | 40 | 20 | |
| HB pencils (box) | School | Shelf 1 | $48.00 | $31.00 | 3 | 6 | Reorder |
| Letter folder | Office | Shelf 3 | $4.00 | $2.20 | 120 | 50 | |
| Copy paper (pack) | Copies | Stockroom | $120.00 | $92.00 | 2 | 5 | Reorder |
Inventory
One row per product, with its price, what it cost you, where it is and the minimum you want to keep. Stock updates itself and what needs reordering turns red.
Incoming
What your supplier delivers, with its cost per unit. Whatever you enter here adds to your stock.
Outgoing
Everything that takes stock away, with its reason: sale, shrinkage, transfer, internal use or return to supplier.
Stock count
Pick the product, type what you counted on the shelf and the template shows the difference against what should be there.
Summary
How many units you have, how much money is in stock, what needs reordering and the total by category, with this trade's categories already set.
How to use it
Your inventory, in three steps
- 1
Add your products
In “Inventory”, one row per item: its price, its cost, how many you have today and the minimum for the season.
- 2
Log what comes in and goes out
Deliveries go in “Incoming”; what's sold or lost goes in “Outgoing” with its reason. Stock moves by itself.
- 3
Count and compare
When you count the shelf, enter it in “Stock count”. The difference shows in red and “Summary” tells you what to reorder.
Who it's for
For stationery and school supply stores
If you have a huge number of items and lose count, start with your fastest sellers and your seasonal orders. The sheet lets you grow without entering the whole store on day one.
Frequently asked questions
See all free toolsIs the template free?
Yes. Leave your email and it downloads right away. No card, no account.
Does it work in Google Sheets and on my phone?
Yes. It's built with formulas that work the same in Excel, Google Sheets and the Excel mobile app. For Google Sheets, upload it to your Drive and open it from there.
How do I keep track of so many small items?
Group them by category and start with your best sellers. What sells individually and what sells by the pack go on separate rows, each with its own price and cost.
What if I switch to Arca later?
You don't start from scratch. Save the “Inventory” tab as a CSV and upload it in Arca under Products, Import (from the Basic plan up). Your products come in with their price, cost and current stock.
What do you do with my email?
We use it to send you the template and, only if you ticked the box, to send you business tips now and then. We don't sell or share it, and you can unsubscribe anytime.
When Excel falls short
The same inventory, updated by every sale
The sheet works as long as someone remembers to log every sale. With Arca, each sale takes stock down by itself, from your phone or the counter computer.
And you don't start over: from the Basic plan you upload the “Inventory” tab and your catalog comes in whole, with prices, costs and stock.