Free Inventory Management Spreadsheet Template (With the Upgrade Path When You Outgrow It)

Most ecommerce sellers start with a spreadsheet. That is not a problem, it is a rational choice. When you have 30 SKUs and one warehouse, a well-structured spreadsheet tracks inventory faster than learning new software. The problem comes when the spreadsheet stops being faster. At some point you are spending more time maintaining the spreadsheet than it would take to learn the tool that replaces it.

We see this pattern constantly. A seller launches on Shopify, tracks 40 products in Google Sheets, and everything runs smoothly for six months. Then they add eBay. Then Amazon. Then the spreadsheet becomes the bottleneck, not because it was bad, but because they outgrew it.

This guide gives you the best possible spreadsheet template for inventory management, walks you through setting it up properly, and tells you exactly when to stop using it.

What the Template Includes

The template is built for Google Sheets and works equally well as an .xlsx download for Excel. It contains four core components designed to cover the basics of inventory tracking without overcomplicating the structure.

Products Sheet

This is your master inventory list. One row per SKU, with every field you need to track stock levels and reorder timing.

Column	Description	Example
SKU	Unique product identifier	WDG-BLK-001
Product Name	Human-readable product name	Black Widget - Large
Category	Product grouping for filtering	Widgets
Location / Warehouse	Where this stock is stored	Warehouse A
Current Quantity	Units currently on hand	145
Reorder Point	Quantity threshold that triggers reorder	30
Reorder Quantity	How many units to order when restocking	200
Supplier Name	Primary supplier for this product	Acme Supply Co.
Supplier Lead Time (days)	Days from PO to delivery	14
Unit Cost	Your landed cost per unit	$4.50
Retail Price	Your selling price	$14.99
Last Updated	Date of most recent quantity adjustment	2026-03-15

Orders Sheet

A running log of every order, used to track what sold, where it sold, and whether it has shipped. You manually add rows here as orders come in, this is the step that eventually becomes the reason you upgrade.

Column	Description	Example
Order ID	Marketplace or internal order number	AMZ-1142857
Date	Order date	2026-03-18
SKU	Product identifier (matches Products sheet)	WDG-BLK-001
Product Name	Product description	Black Widget - Large
Quantity	Units sold in this order	2
Channel	Where the order originated	Amazon / eBay / Shopify / Manual
Status	Current fulfillment status	Pending / Shipped / Delivered / Returned

Low Stock Dashboard

This is not a separate sheet, it is a filtered view of the Products sheet with conditional formatting applied. Rows where Current Quantity is at or below the Reorder Point turn red. Rows where stock is healthy (more than 2x the reorder point) stay green. You get a quick visual scan of what needs attention.

The dashboard also includes summary counts: how many SKUs are at or below their reorder threshold right now, and a list of those specific items sorted by urgency.

Summary Metrics

A small section at the top of the Products sheet (or a dedicated summary tab) that auto-calculates four numbers:

• Total SKU count, how many active products you are tracking
• Total inventory value, sum of (Current Quantity x Unit Cost) across all SKUs
• Items below reorder point, count of SKUs where Current Quantity is at or below Reorder Point
• Average days since last update, flags how stale your data is getting

How to Set Up Your Inventory Spreadsheet (Step by Step)

Getting the template is the easy part. Setting it up so it actually works for your business takes about an hour of focused effort. Do not skip these steps, a half-configured spreadsheet is worse than no spreadsheet because it gives you false confidence in bad data.

1. Copy the template to your own Google Drive (or download as .xlsx for Excel).

   Make a copy so your edits do not affect the original. If you use Excel, download the .xlsx version, the formulas translate cleanly.

2. Enter your products, start with active SKUs only.

   Do not add discontinued products, seasonal items you will not restock, or samples. Every row in the spreadsheet is a row you need to maintain. Start lean. You can always add products later.

3. Set reorder points using the formula: (Average Daily Sales x Supplier Lead Time) + Safety Buffer.

   For most products, set the safety buffer at 3-5 days of stock. If you sell 10 units per day and your supplier takes 14 days to deliver, your reorder point is (10 x 14) + (10 x 4) = 180 units. When stock drops to 180, you place the order and have enough buffer to cover variability.

4. Configure conditional formatting.

   Select the Current Quantity column. Set a rule: if the value is less than or equal to the corresponding Reorder Point cell, turn the cell red. Add a second rule: if the value is greater than 2x the Reorder Point, turn it green. Everything in between stays yellow or default. This gives you a traffic-light view of your entire catalog at a glance.

5. Link to your order flow.

   After every order, deduct the quantity sold from the Products sheet. This is the manual step that eventually becomes unsustainable. At 10 orders per day, it takes 5 minutes. At 50 orders per day, it takes 25 minutes. At 100 orders per day, it is a full-time job. For now, build the habit of updating after every batch of orders.

6. Schedule weekly inventory counts.

   Pick one day per week to physically verify your top 20% selling products match the spreadsheet. These are your highest-velocity items and the most likely to drift. Update discrepancies immediately. If you consistently find gaps between the spreadsheet and reality, that is an early signal the spreadsheet is failing you.

Customizing the Template for Your Business

The base template covers the fundamentals. Depending on your operation, you may want to extend it. Here are the most common customizations and how to implement them without overcomplicating the sheet.

Adding multiple warehouse locations

Add a Location column (already included in the template) and use Google Sheets data validation to create a dropdown of your warehouse names. This prevents typos and keeps the data filterable. Use filter views to see one warehouse at a time without hiding data from other users. If you have the same SKU in two warehouses, create two rows, one per location, with separate quantity tracking for each.

Tracking by supplier

Group products by supplier to generate simplified reorder lists. Sort or filter the Products sheet by Supplier Name, then look at all the red-highlighted rows for that supplier. This gives you a single reorder email per supplier rather than sending 15 separate requests. Add a "Minimum Order Value" column if your suppliers have MOQs.

Adding images

Insert product thumbnail URLs in a new column and use the =IMAGE() function in Google Sheets to render them inline. This is surprisingly helpful during physical inventory counts, warehouse staff can visually confirm the right product instead of squinting at SKU codes.

Creating simple formulas

Two formulas cover most of what you need:

• Reorder point: =AVERAGE(daily_sales_range) * lead_time + safety_buffer: where daily_sales_range is a range of your daily sales figures, lead_time is the supplier's delivery time in days, and safety_buffer is your cushion in units.
• Inventory value: =quantity * unit_cost, multiply Current Quantity by Unit Cost for each row, then SUM the column for total inventory value.

Adding a Purchase Orders tab

For basic PO tracking, add a sheet with these columns: PO Number, Supplier, Date Ordered, Expected Delivery, SKUs (comma-separated or one row per SKU), Quantities, Total Cost, and Status (Draft / Sent / Confirmed / Received). This does not replace a real procurement system, but it gives you a paper trail for what you ordered and when you expect it. Cross-reference the Expected Delivery date with your reorder points to see if incoming stock will arrive before you run out.

The 5 Things This Spreadsheet Cannot Do

This is where honesty matters more than marketing. A spreadsheet is a tool with hard boundaries. Knowing those boundaries prevents you from trusting the spreadsheet past the point where it can actually help you.

1. Real-time sync across sales channels

When someone buys on eBay, you must manually subtract the quantity from your spreadsheet before eBay sells another unit. If you sell on 3 channels and get 50 orders per day, that is 50 manual deductions. Miss one and you oversell. There is no API connection between your spreadsheet and Amazon, eBay, Shopify, or Walmart. The spreadsheet does not know a sale happened until you tell it. An inventory management system does this automatically in seconds, the sale triggers a quantity update across every connected channel before the next customer can check out.

2. Automatic order quantity deduction

Every sale requires a human to update the sheet. At 10 orders per day, this takes about 5 minutes. At 100 orders per day, it takes 45 minutes and becomes error-prone. At 500 orders per day, it is physically impossible to keep up. The deduction has to happen fast enough that another sale on another channel does not claim the same unit. A spreadsheet cannot guarantee that timing. You are always racing against the next order, and the spreadsheet is always a step behind.

3. Bundle and kit inventory tracking

If you sell a "BBQ Starter Kit" that contains 3 individual products, the spreadsheet cannot automatically deduct component quantities when the bundle sells. You need to remember which products are in which bundles and manually adjust all of them. With 5 bundles, this is manageable. With 20 bundles, this becomes a constant source of inventory drift. One missed component deduction compounds through every subsequent count and reorder decision.

4. Multi-user concurrent editing without conflicts

Google Sheets handles concurrent editing well for simple changes, but when two warehouse staff update the same product's quantity simultaneously, the last save wins. There is no merge logic. If one person sets the quantity to 45 (received 10 units) and another sets it to 30 (shipped 5 units) at the same time, one of those updates disappears. In a busy warehouse, this creates phantom stock, the spreadsheet says you have 15 units, but you actually have 8. You do not discover the discrepancy until a customer order fails to ship.

5. Purchase order automation

The spreadsheet can tell you when stock is low. It can highlight the row in red. But it cannot generate a purchase order, send it to your supplier, or track whether the supplier confirmed the order. Every reorder is a manual email. Every follow-up is a manual check. Every receiving event is a manual update. The gap between "I know I need to reorder" and "the supplier has shipped the replenishment" is entirely managed by memory and discipline.

When to Upgrade from a Spreadsheet to Software

The decision to upgrade should not be emotional. It should be triggered by specific, measurable signals that indicate the spreadsheet is costing you more than the alternative. Here are the thresholds.

Signal	Threshold	What Happens If You Don't Upgrade
SKU count	200+ active SKUs	Update errors compound, you'll spend 2+ hours/day on data entry
Sales channels	2+ channels	Manual sync becomes a race condition, overselling is inevitable
Daily orders	50+ orders/day	Human deduction can't keep pace; expect 3-5% error rate
Warehouse staff	2+ people	Concurrent editing conflicts create phantom inventory
First oversell	Any	Your reviews and marketplace metrics take a hit you can't undo

If you hit even one of these, the spreadsheet is already costing you more than the software would. The median cost of a single oversell (refund processing + customer service time + lost repeat purchase) is $15-25. At 5 oversells per month, that is $75-125/month, more than most inventory management tools cost.

The math gets worse the longer you wait. Oversells damage your marketplace seller metrics, which suppresses your listing visibility, which reduces sales, which makes you think the problem is marketing when the problem is actually operations. By the time most sellers switch to software, they have already absorbed months of preventable losses.

How Nventory Replaces the Spreadsheet

If you decide to upgrade, here is how each column and function in your spreadsheet maps to Nventory. This is not a sales pitch, it is a translation guide so you understand exactly what changes and what stays the same.

Spreadsheet Column	Nventory Equivalent	What Changes
Current Quantity (manual)	Real-time synced quantity	Updates automatically across all channels in seconds
Reorder Point (formula)	Automated reorder alerts	Sends notifications and can auto-generate POs
Order deduction (manual)	Automatic order processing	Every sale, return, and adjustment updates inventory instantly
Location tracking (column)	Multi-warehouse dashboard	Warehouse-level inventory with transfer tracking
Supplier info (static)	Supplier management	Track supplier lead times, costs, and fill rates
Low stock alert (conditional formatting)	Smart notifications	Email, mobile push, and Slack alerts with one-click reorder

The transition takes less time than you think. Export your Products sheet as a CSV, import it into Nventory, and connect your sales channels. Most sellers are fully operational within a day. The data you already have in the spreadsheet, SKUs, quantities, reorder points, supplier info, transfers directly.

Nventory has a 14-day free trial. If you are currently running the spreadsheet, import your product list and see the difference in the first hour. No credit card required.

For a full analysis of the hidden costs of spreadsheet-based inventory management, read The True Cost of Running Ecommerce on Spreadsheets.