10 tabsGoogle Sheets + Excel
Project Management Spreadsheet
Tasks, Kanban board, Gantt chart and dashboard in one sheet that keeps itself up to date.
$7.00$14.0050% off
Overview
Keeping stock on a notepad works until something sells out unnoticed. With this tracker, you record each purchase, sale, return or damaged item as it happens, and every product's stock on hand, value and status (in stock, low or out) is worked out for you.
Anything at or below its reorder point lands on the reorder list with the quantity to order, the cost and the supplier. When you do a physical count, type what you found and the sheet shows any difference. A filled-in soap and candle shop example lets you see every tab working first.
Stock that updates itself
Log moves once and the on-hand count follows.
Low-stock alerts
Each product shows In stock, Low stock or Out of stock.
A ready reorder list
What to order, how many, the cost and from whom.
Know what it's worth
Stock value at cost and at your selling price.
What's inside
Dashboard
Products, units on hand, stock value at cost and price, low and out of stock, best sellers in the last 30 days, units sold by month, reorders
Products
SKU, name, category, variant, location, cost, price, reorder point, reorder quantity and supplier, with stock, value and status
Stock Moves
Starting stock, purchases, sales, returns, damages and adjustments
Reorder List
Everything at or below its reorder point, with quantity to order, cost and supplier
Stock Count
Enter what you counted and see any difference
Suppliers
Contacts, lead times and minimum orders
Example & guide
A filled-in small soap and candle shop and a Start Here guide
How it works
- 1
Buy on Etsy, then download the START-HERE PDF and the Excel files from your Etsy Purchases page.
- 2
For Google Sheets, open the link in the PDF and choose Make a copy. For Excel, open the .xlsx file.
- 3
Add your products and starting stock, then log purchases and sales. Stock, value and reorders update on their own.
Good to know
- Digital download: nothing is shipped
- For use in your own business: please don't share or resell the template
Questions
How do I track inventory in Google Sheets?
List your products once, then log each purchase, sale, return or damage on the Stock Moves tab. This template works out stock on hand, value and low-stock status from those moves.
Does it tell me when to reorder?
Yes. Set a reorder point and quantity for each product. Anything at or below that point appears on the Reorder List with the cost and supplier.
How many products can it hold?
Up to 200 products and 1,000 stock moves.
Do I need Excel?
No. It works in Google Sheets with a free Google account, on a computer, tablet or phone. It also opens in Microsoft Excel, and Apple Numbers can open the Excel file.
How it's made: designed by Sorted Templates. We use AI tools to help draft text and lay out pages, and every page is reviewed and edited by us before it's listed. Lifestyle and mockup images may be AI-generated or AI-edited; the page previews show the actual files.
You might also like
9 tabsGoogle Sheets + Excel
Book Tracker Spreadsheet
A cozy digital reading journal: every finished book becomes a colored spine on your shelf.
$6.00$12.0050% off
6 tabsGoogle Sheets + Excel
Assignment Tracker Spreadsheet
Enter your syllabus once and see every due date, exam countdown and class grade update.
$3.50$7.0050% off
7 tabsGoogle Sheets + Excel
Job Application Tracker Spreadsheet
Your whole job search in one sheet, with follow-up reminders so no lead goes quiet.
$4.00$8.0050% off