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.

Inventory list template showing SKUs, quantities, stock value and a reorder flag

What’s included

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 template showing SKUs, quantities, stock value and a reorder flag

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?"

Download Excel template.xlsx · Excel and Google Sheets
Stock in and stock out log template with totals in, totals out and stock on hand per product

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

Download Excel template.xlsx · Excel and Google Sheets
Stock count sheet template comparing expected and counted quantities with shrinkage totals

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 %)

Download Excel template.xlsx · Excel and Google Sheets
Reorder planner template calculating reorder points and suggested order quantities

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

Download Excel template.xlsx · Excel and Google Sheets
Inventory valuation template with total stock value and a cost of goods sold calculation

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

Download Excel template.xlsx · Excel and Google Sheets

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

Raymond L.
Jacksonville, FL
We run a small warehouse with a lot of moving parts. Vencru made it easy to stay organized. What impressed me even more is their customer service—real people who actually reply and fix things. They even helped me set up the system properly. That kind of support is rare these days.
Jasmine A.
Chicago, IL
Vencru isn’t bloated or overwhelming like some other software I tried. It’s clean, easy to use, and does exactly what I need—track inventory, send invoices, and keep an eye on sales. I like that I can do everything without hopping between tools.
Saumil P.
Phoenix, AZ
I tell all my friends about Vencru. The application is so easy to use and the support team is always available to help address questions and issues
Studio Badge
Ghana
I run a physical store and online store - so it’s important my inventory is accurate and consistent. I also love the detailed sales reports. My accounting is up to date and it’s just the beginning of the year. Their customer support is top notch as well. Highly recommended

Inventory templates vs. Vencru inventory software

The templates cover the basics for free. Vencru’s inventory software does the updating for you.

FeatureInventory templatesVencru
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✅
PriceFree14-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 worthInventory list and stock tracker
See how stock moved, with deliveries and sales by dateStock in and stock out log
Run a stocktake and find missing stockStock count sheet
Decide when to reorder and how manyReorder planner
Value your stock for your books, a lender or insuranceInventory valuation

Free inventory calculators

Need one number fast? Each of these guides has a calculator that shows the formula with your figures:

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.

Retail inventory icon

🛍️ 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 inventory icon

🛒 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.

Warehouse inventory icon

🏢 Warehouses

Run stock audits with the stock count sheet, and set reorder points for bulk items with the reorder planner.

Accounting inventory icon

📊 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.

Screenshoot of mobile and desktop view of Vencru's accounting software

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.

Manage your inventory easier

Track inventory levels, get stock alerts, manage sales and purchases, and get business reports. 

Screenshow showing Vencru's Point of Sale and Inventory System on iPad and Mobile