Seller Inventory Tracker Spreadsheet | Materials, Finished Goods, Stock and Low Stock Alerts

You cannot sell what you ran out of last Tuesday. This tracker keeps a maker's stock honest: the materials on your shelf, the finished products ready to ship, what sold, and — before it bites — what is about to run out. Log a sale once and the product's stock drops by itself; drop below your reorder point and the row flags itself LOW STOCK.

Transparency note: every design in our shop is AI-assisted then hand-finished — this spreadsheet was designed with AI assistance, then hand-built and formula-tested by our shop.

PLEASE NOTE — THIS IS A STOCK TRACKER FOR MAKERS: it tracks materials inventory and finished-goods stock levels (what you hold, what sold, what is running low). It is NOT the shop's Reseller Inventory & Profit Tracker — that separate spreadsheet tracks per-item flipping profit, platform fees and margins for resellers. This one does not calculate per-item profit, fees or margins; it counts stock.

THE 6 TABS

• Start Here (Dashboard) — total stock value (materials + finished goods), materials stock value, finished goods stock value, units on hand for both, the low-stock alerts count, total units sold and total sales revenue — every number a live formula

• Materials — one row per supply: item, supplier, unit, qty on hand, unit cost and reorder point. Stock Value (qty × unit cost) and the LOW STOCK / OK status figure themselves

• Finished Goods — one row per product you make: qty made and price. Qty Sold is added up from the Sales Log by itself; Qty On Hand (made − sold), Stock Value and the LOW STOCK / OK status figure themselves

• Sales Log — one row per sale: date, product, qty, unit price and channel. Revenue figures itself per row, and the sale flows into Finished Goods automatically

• Low Stock — every material and every finished product mirrored with its live flag, plus the flagged counts for both sections, so a reorder pass takes one look

• Settings — what this tracker is (and is not), and how every number is calculated

THE SAMPLE SHOP

It comes loaded with one fictional handmade candle and soap shop: 10 materials (soy wax, fragrance oil, jars, wicks, shea butter and more — $499.55 of stock), 8 finished products with 239 units on hand worth $2,648.00, and 14 logged sales totaling $1,074.50. Five lines are already flagged LOW STOCK — fragrance oil, cotton wicks, warning labels and dried lavender on the materials side, and the Citrus Soy Candle on the finished side, down to 5 after a wholesale order — so you can watch the alerts work before you delete the samples and type your own. Formulas are pre-filled down 20 material rows, 15 product rows and 40 log rows, ready to go.

A FINISHED FILE, DELIVERED INSTANTLY

This listing is a digital item, delivered instantly as a file at checkout. The file is a finished template, ready to use as it is. If a formula or number in the file is wrong, message us and you'll receive a corrected copy free — forever, no time limit.

REQUIREMENTS: a free Google account. Your tracker lives in Google Sheets — nothing to install, and it is right there on your phone at the supply store, the craft fair and the studio shelf.

This is a digital product — no physical item will be shipped, and all sales are final (we can't accept returns or cancellations on digital downloads). Your files are available instantly after checkout. But don't worry: if anything isn't working right, message us anytime and we'll fix it for you — no time limit.