Inventory Template for Excel (Free Excel)
A free Excel inventory sheet. Track quantity, unit cost and reorder levels, and see stock value and what needs reordering.
Download the free Excel template (.xlsx)
Free. No email or sign-up needed. One Excel file, 2 sheets.
What is inside the inventory template
| Sheet | What it does |
|---|---|
| Inventory | 300 item rows with SKU, category, quantity, reorder level, unit cost, supplier and notes. Stock value and a REORDER flag calculate automatically, with summary totals. |
| Read me | Short instructions. |
Yellow cells are for your own numbers and text. Green cells calculate by themselves, so do not type over them. Sample data is included so you can see how it works, then replace it with your own.
How to use it
- Download the file and open it in Excel 2010 or later. It also opens in Google Sheets and LibreOffice.
- Replace the sample data in the yellow cells with your own.
- Read the totals and results that update automatically.
- Save a copy for each month, project or client, or print it from File > Print.
The template is free to use and edit. If you want a version built around your own process, with your branding, extra sheets or automation, tell us what you need.
Free pricing tips for your business
Get short, practical tips on pricing jobs and using our free calculators. No spam, unsubscribe any time.
Frequently asked questions
How do I track inventory in Excel?
List each item with quantity and unit cost, and update quantity as stock moves. Value and reorder flags are automatic.
What is a reorder level?
The quantity at or below which you should order more. Items at that level show REORDER in red.
Can it handle many products?
It holds 300 items. Copy the formulas down for more.
Does it track sales?
It tracks stock on hand. Update the quantity after each sale or delivery.
Need a custom spreadsheet built for your business?
Talk to usMore free tools: All free Excel templates · Price list template · Bookkeeping template · Margin calculator