Free Inventory Templates for Excel and Google Sheets
Download 5 free inventory templates: a stock list, a stock in and out log, a stock count sheet, a reorder planner and an inventory valuation sheet. Each one has working formulas and opens in Excel or Google Sheets. No sign-up needed.
What’s included
- Inventory list and stock tracker: what you have, what it’s worth, and what to reorder
- Stock in and stock out log: every delivery and sale, totaled per product
- Stock count sheet: counted vs. expected, with shrinkage
- Reorder planner: reorder points and order quantities
- Inventory valuation: stock value at average cost and COGS
Download free inventory templates
Pick the template that fits the job. Each file is a standard .xlsx with working formulas and example rows you can delete.
- Inventory list and stock tracker
- Stock in and stock out log
- Stock count sheet
- Reorder planner
- Inventory valuation (average cost)

Inventory list and stock tracker
One row per product with quantity on hand, cost, stock value and a reorder flag. Start here if you need a simple stock sheet for a shop or stockroom.
Columns: SKU, name, category, location, quantity, cost and selling price, stock value, reorder point, "Reorder?"

Stock in and stock out log
Record every delivery, sale, return and write-off on one tab. A second tab totals them into stock on hand for each product.
Columns: Date, SKU, movement type, quantity in, quantity out, reference (PO or invoice number), on hand

Stock count sheet
Compare what you counted with what your records say, item by item and in dollars. The summary shows shrinkage and the shrinkage rate.
Columns: Expected and counted quantity, difference, book value, counted value, shrinkage ($ and %)

Reorder planner
Work out each product’s reorder point from daily sales, lead time and safety stock, then see what to order and how many.
Columns: Average daily sales, lead time, safety stock, on hand, reorder point, "Order now?", suggested order quantity

Inventory valuation (average cost)
Value your stock at average cost and work out cost of goods sold for the period. Includes a tab for updating average cost when new stock arrives.
Columns: Quantity on hand, average unit cost, total value, beginning inventory, purchases, COGS
Using Google Sheets? Download the file, then in Google Sheets choose File > Import > Upload. The formulas carry over. Every template is free, has no macros and needs no sign-up. Looking for something else? See the purchase order templates and bookkeeping templates.
When an inventory spreadsheet stops working
A spreadsheet works well for one person and one stockroom. It starts to slip when:
- more than one person updates stock, and copies of the file drift apart;
- you sell in a store and online, and each sale has to be keyed in twice;
- you hold stock in more than one location;
- your accountant needs cost of goods sold that matches your sales.
Vencru is inventory software with invoicing and accounting built in. Stock goes down as you sell or invoice. Purchase orders and receiving bring it back up (Growth plan and above). Cost of goods sold is recorded at average cost with every sale, and Shopify orders sync in (Amazon and WooCommerce on Enterprise). You can import your product list from a CSV file, and the inventory list template above already uses Vencru’s import column names.
14-day trial · No credit card required
Here are some of the top reviews of Vencru's inventory management software
Inventory templates vs. Vencru inventory software
The templates cover the basics for free. Vencru’s inventory software does the updating for you.
| Feature | Inventory templates | Vencru |
|---|---|---|
| Track stock levels | ✅ | ✅ |
| Stock updates when you sell or invoice | ❌ (manual) | ✅ |
| Cost of goods sold | ⚠️ Manual (valuation template) | ✅ (average cost, with every sale) |
| Reorder points and low-stock alerts | ⚠️ "Reorder?" column | ✅ (in the app and by email) |
| Purchase orders and receiving | ❌ | ✅ (Growth plan and above) |
| Shopify sync | ❌ | ✅ (Amazon and WooCommerce on Enterprise) |
| Stock by location | ⚠️ One column per row | ✅ (Enterprise) |
| Several people working at once | ⚠️ Copies drift apart | ✅ |
| Price | Free | 14-day free trial, paid plans from $6 a month |
How to use an inventory template
The steps are the same whichever template you start with.
1. Give every product a SKU
A SKU is a short, unique code for each product and variant, such as SHI-BLU-M-001. No SKUs yet? Make them with the free SKU generator.
2. Enter your opening stock
Count what you have and enter the quantity and unit cost for each product. Delete the grey example rows first.
3. Record every movement
Add deliveries when they arrive and sales as they happen. In the stock in and out log, use the PO or invoice number as the reference so you can trace any figure later.
4. Count regularly
Use the stock count sheet monthly or quarterly, and spot-check fast sellers more often. Record any difference as an adjustment, with a note on the cause.
5. Reorder before you run out
Set a reorder point for each product:
Reorder point = (average daily sales × lead time in days) + safety stock
The inventory list flags anything at or below its reorder point, and the reorder planner suggests how many to order.
Using Google Sheets
Download the .xlsx file. In Google Sheets, choose File > Import > Upload and select the file. The formulas and formatting carry over.
Which template do you need?
| If you need to… | Use |
|---|---|
| Keep a simple list of what you stock and what it’s worth | Inventory list and stock tracker |
| See how stock moved, with deliveries and sales by date | Stock in and stock out log |
| Run a stocktake and find missing stock | Stock count sheet |
| Decide when to reorder and how many | Reorder planner |
| Value your stock for your books, a lender or insurance | Inventory valuation |
Free inventory calculators
Need one number fast? Each of these guides has a calculator that shows the formula with your figures:
- Reorder point calculator
- Cost of goods sold (COGS) calculator
- Inventory turnover calculator
- Days sales in inventory calculator
- Inventory shrinkage calculator
For reports, see the inventory on hand report template, the inventory valuation report template and the product pricing calculator template.
Inventory template FAQs
Yes. All 5 templates on this page are free Excel (.xlsx) files: an inventory list, a stock in and out log, a stock count sheet, a reorder planner and an inventory valuation sheet. There’s no sign-up, and the files have no macros.
Create one row per product with columns for SKU, name, quantity on hand, unit cost and reorder point. Add a stock value column (quantity × unit cost) and a reorder flag that shows when quantity falls to the reorder point. The inventory list template above is already set up this way.
Yes. Download the .xlsx file, then in Google Sheets choose File > Import > Upload. The formulas and formatting carry over.
Start with a list of products and opening quantities, then record every delivery and sale. The stock in and stock out log does this: each movement goes on one tab, and SUMIFS formulas total them into stock on hand per product. Count your stock regularly to catch errors.
At minimum: SKU, product name, quantity on hand, unit cost and a reorder point. Useful extras are location, category, stock value, and a log of deliveries and sales so you can see how each quantity was reached.
When several people update stock, you sell in more than one place, or keeping the spreadsheet accurate takes more time than it saves. Inventory software such as Vencru updates stock as you sell and records cost of goods sold automatically.
Why Use Inventory Templates?
Inventory templates are simple tools that help small businesses track products without complex software. If you’re starting out or need a quick way to organize stock, these templates can save time and reduce errors.
Here’s why they’re useful:
Easy to use – No special skills needed. Just open the file and start filling it in.
Saves time – Quickly track what’s in stock, what’s sold, and what needs restocking.
Cost-effective – They’re free! A great option if you’re not ready for paid software.
Customizable – Add your own product names, prices, and categories.
Helps prevent stock issues – Stay ahead of low stock or missing items.
Using an inventory spreadsheet template is a smart first step to stay organized and grow your business with confidence.
Who Are These Inventory Templates For?
These free inventory spreadsheet templates help a wide range of businesses manage inventory without complex systems or costly software.
🛍️ Retailers
Track daily stock levels, product movement, and sales using the inventory list and stock tracker. Perfect for shops needing a quick view of what’s in or out of stock.
🛒 E-commerce Sellers
Use the stock in and stock out log to record online orders and deliveries. When order volume grows, ecommerce inventory software syncs stock with your store.
🏢 Warehouses
Run stock audits with the stock count sheet, and set reorder points for bulk items with the reorder planner.
📊 Accountants
Use the inventory valuation template to value stock at average cost and work out cost of goods sold for the period.
Get Simple Inventory & Accounting Software
Sign up today and take control of your business on the go.
With Vencru, you can: send professional invoices, view real-time sales reports, monitor inventory levels, track expenses easily, access accurate accounting statements
All in one place—anytime, anywhere.
Free Accounting & Billing Templates
Easily manage your finances, issue receipts, and send professional invoices with Vencru’s free templates and tools. Whether you’re tracking expenses or creating a purchase order, we’ve made it simple and fast.
Accounting Templates
Stay on top of your business finances with ready-made templates for tracking income, expenses, and profits—all designed to be easy to use.
Estimate Generator
Create professional estimates and quotes for your customers in seconds, free and ready to send.
Expense Templates
Record and organize business expenses with simple templates that help you stay on budget and ready for tax season.
Purchase Order Generator
Speed up your procurement process with an easy-to-use PO generator. Great for keeping vendor orders clear and consistent.
Invoice Templates
Send clean, professional invoices using customizable templates. Perfect for accurate billing and smooth customer communication.
Invoice Maker
Need a quick invoice? Use our simple invoice creator to generate professional bills anytime—no design skills needed.