





Inventory Tracker Spreadsheet
Inventory Tracker Spreadsheet for small shops and makers – know what's in stock, what each product really costs and what to make or buy next. Log stock in…
- Instant download after checkout
- Secure checkout on Etsy
- Print at home or use digitally
Inventory Tracker Spreadsheet for small shops and makers – know what's in stock, what each product really costs and what to make or buy next. Log stock in and sales, and current stock, low-stock alerts, margins and your reorder list update by themselves. Light and dark versions included.
✦ WHAT'S INCLUDED – SPREADSHEET (10 tabs, light + dark version)
• Start Here – how to use it + your shop at a glance
• Settings – default reorder point, labor rate, target margin, selling fees and your own categories, sales channels and units
• Products – 300 products / variants with SKU, category, supplier, location, sale price, opening stock, reorder point and qty; stock in, sold, in stock, status (In stock, Low stock, Out of stock), stock value, retail value, margin and sales this year fill in
• Stock Log – 2,000 rows: stock in, sales, returns, damaged / lost and count corrections, with sales channel, sales, cost of goods and gross profit
• Reorder List – everything at or below its reorder point, most urgent first, with order qty, estimated cost, supplier lead time and email – plus materials to reorder
• Materials – 150 materials and supplies: pack size and price → cost per unit, on hand, reorder status and value
• Suppliers – contacts, lead times, minimum order and terms, with low-stock counts
• Cost Calculator – 30 cost cards: materials + making time + packaging + selling fees = true cost, suggested price, profit and margin
• Dashboard – stock value, units, low-stock count, units sold, sales, gross profit and margin, month-by-month table, best sellers, sales by channel, stock by category and 3 charts
• Example – a filled-in sample handmade shop
✦ WHAT'S INCLUDED – QUICK-START GUIDE (PDF, 7 pages, US Letter + A4)
• Opening the file in Google Sheets or Excel, step by step
• Your first 10 minutes
• A tour of every tab
• Tips & answers + a 15-minute weekly stock check-in
✦ GREAT FOR
• Online shop owners and handmade makers
• Candle, soap, ceramics, jewelry, print and craft businesses
• Market stall and craft fair sellers
• Anyone who wants to stop running out of best sellers
✦ FORMAT
• 2 XLSX spreadsheets (light and dark version) for Microsoft Excel and Google Sheets (free)
• Quick-start guide PDF in US Letter and A4
• Digital download – no physical item will be shipped
✦ HOW TO USE
1. Complete checkout
2. Go to You > Purchases and reviews on Etsy (or the link in your email)
3. Click Download Files. Upload the spreadsheet to Google Drive and open it with Google Sheets, or open it in Excel
✦ GOOD TO KNOW
• Works in Excel (desktop, web and mobile) and Google Sheets – no macros, no add-ins
• Dark version for on-screen use, light version for printing – both have the same tabs and formulas
• Money cells use $ – switch to your own currency in a click (Format > Number). A record-keeping tool, not tax or financial advice
• Personal use only; please do not share or resell the files
• Because this is a digital item, returns are not accepted – but if anything is wrong with your file, message us and we will fix it quickly
✦ ABOUT THIS DESIGN
Original design by Pagevine Studio, created with digital design tools (including AI assistance) and checked page by page before listing.
✦ MORE FROM PAGEVINE STUDIO
See more spreadsheets, planners and templates in our shop: https://www.etsy.com/shop/PagevineStudio
How your download works
Check out on Etsy, then open You › Purchases and reviews to download right away (Etsy also emails you a link). Unzip if needed, then print, import to GoodNotes, or open in the app named in the listing. Full guide.
License & use
For personal use unless the listing says commercial use. Please don't share or resell the files. Colors can vary a little between screens and printers.
Need help?
If anything is wrong with a file, message us with your Etsy order number and we'll fix it quickly.