Excel Inventory Template for Small Business
Most free inventory templates handle a product list and a low-stock flag, and stop there. What a small retailer, maker, or Etsy seller actually needs to run the business is profit by product and a reorder date tied to how fast that product is actually selling — neither of which a basic stock-count sheet gives you.
The Inventory Tracker is built around that gap: it takes your products, purchases, and sales and turns them into current stock levels, cost of goods and gross margin per SKU, and a reorder alert that accounts for your supplier's lead time, not just a static low-stock threshold.
Premium templates
Reorder points and lead time math
A reorder point that just says 'stock is below 10' doesn't tell you when to actually place the order — that depends on how fast the product is selling and how long your supplier takes to deliver. The Inventory Tracker calculates a projected stockout date from trailing sales velocity, then subtracts the supplier's lead time to give an ORDER BY date instead of a flat low-stock warning.
That distinction matters most for products with long lead times or seasonal demand spikes, where a static threshold either triggers reorders too late or, just as often, too early, tying up cash in stock that isn't moving yet.
Weighted-average cost and profit margin by product
Knowing what's in stock is only half the picture; knowing what each product actually earns is the other half. The template calculates cost of goods sold using a weighted-average unit cost per SKU as purchases come in at different prices, then derives gross margin in dollars and as a percentage for every product — so you can see which items are actually profitable, not just which ones sell the most units.
Tracking sales across multiple channels
If you sell through more than one channel — Etsy, your own site, wholesale, in person — the template tags each sale with its channel and rolls that into a breakdown showing which channel is actually driving revenue and margin. Most free inventory spreadsheets and even a lot of paid Etsy-seller trackers log a single undifferentiated sales feed, so this channel-level view is a step most of what's out there skips entirely.
That breakdown matters most once a seller has grown past a single storefront, since the channels rarely perform the same: a wholesale account can move volume at a thinner margin than a retail sale through your own site, and without the split it's easy to assume the channel with the most transactions is also the most profitable one, when it often isn't.
Frequently asked questions
Does this template calculate profit margin, or just stock counts?
Both. Current stock is calculated from starting stock, purchases, and sales, and the template separately computes cost of goods sold using a weighted-average cost per SKU to show gross margin in dollars and percentage for every product.
How does the reorder alert decide when to order?
It projects a stockout date from your trailing sales velocity for each product, then subtracts the supplier's lead time (set per product or globally) to give an ORDER BY date, rather than a flat low-stock flag.
Can I track sales from more than one channel, like Etsy and my own store?
Yes. Each sale is tagged with a channel from a dropdown list, and the dashboard breaks out sales and margin so you can compare how each channel is actually performing.
Is there a free version of the Inventory Tracker?
The Inventory Tracker is a paid template ($14). There isn't currently a free stripped-down version in this category.
Does it work the same in Excel and Google Sheets?
Yes. It runs as two separate builds using the same SUMIFS, COUNTIFS, INDEX/MATCH, and IFERROR formulas, so the calculations match exactly whether you're in Excel or Google Sheets, with no macros in either.