Hardware store inventory template, free
Thousands of parts in drawers and shelves. Know where each one is, how many are left and how much money is tied up in stock.
- By category: tools, fasteners, plumbing, electrical and paint
- With each part's location: aisle, drawer or stockroom
- 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? |
|---|---|---|---|---|---|---|---|
| 16 oz claw hammer | Tools | Aisle 1 | $185.00 | $128.00 | 6 | 3 | |
| 1/4 screws (100 pcs) | Fasteners | Drawer 12 | $65.00 | $41.00 | 2 | 5 | Reorder |
| 1/2 PVC elbow | Plumbing | Drawer 30 | $9.00 | $5.40 | 60 | 20 | |
| 12 gauge wire (m) | Electrical | Stockroom | $14.00 | $9.50 | 8 | 30 | 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 part: its price, its cost, its aisle or drawer, how many you have today and the minimum.
- 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 hardware stores and small parts shops
If finding a part depends on someone remembering where it went, the location column solves half of it. The other half is knowing what's running out before a customer asks.
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.
Does it work if I sell by the meter or by the box?
Yes. Use one row for each way you sell and put the unit in the name, like “12 gauge wire (m)”. Each one gets its own price, cost and stock.
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.