Inventory Tracker Spreadsheet, COGS Calculator, Small Business Inventory, Materials and Supplies Log, Reorder List, Google Sheets & Excel
Know what's on the shelf, what it cost you, and what to reorder. Log the supplies you buy, the batches you make, and the orders you sell, and this tracker keeps your stock counts, average material costs, cost of goods sold, and gross profit up to date. It tells you in plain English what's running low and which products earn their shelf space.
★ WHY IT STANDS OUT
• Materials are used up automatically from each product's recipe when you log a batch
• Average-cost valuation updates as you buy supplies at new prices
• Out, Reorder, and Make more flags for every material and product
• Cost of goods sold and gross margin by month, ready for tax time
• Plain-English Insights panel with live, formula-driven sentences
• What-If inputs so you can test a change before you make it
• 10-minute numbered Quick Start on the Start Here tab
• Quick Entry tab sized for your phone in the Google Sheets app
• Business categories shared across every LeafLedgerCo Small Business Tool
• Free 2028 update
★ WHAT'S INCLUDED
SPREADSHEET (one .xlsx file that works in Google Sheets and Microsoft Excel)
• Start Here: a numbered 10-minute Quick Start and a color key
• Dashboard: inventory value, sales, cost of goods sold, gross profit, gross margin, items needing attention, a month-by-month table and chart, and a What-If (raise prices, material costs rise, sell more)
• Plain-English Insights like "Custom Name Necklace has your thinnest margin at 49%. Check its price or its recipe costs."
• Products: price, labor, packaging, make-more point, unit cost, made, sold, on hand, stock value, margin, sell-through, and status
• Materials: unit, category, starting stock, reorder point, bought, average cost, used, on hand, value, and status
• Recipes, Purchases, Production, and Sales logs
• Quick Entry: check any item's stock and log a sale, a batch you made, or a supply purchase from your phone
• Settings and Categories: labor on or off, your hourly rate, sales channels, and shared business categories
PRINTABLE PAGES (5 pages, in both US Letter and A4)
• Cover, Stock Count sheet, Purchase Log, Production Log, and a Reorder List with a COGS worksheet
★ HOW TO USE IT IN GOOGLE SHEETS
1. Download the files from the link in your purchase receipt email.
2. In Google Drive, click New > File upload and choose Inventory-COGS-Tracker.xlsx.
3. Open it and choose File > Save as Google Sheets. Work in that copy.
4. On your phone, open that copy in the free Google Sheets app and use the Quick Entry tab.
★ HOW TO USE IT IN MICROSOFT EXCEL
1. Open Inventory-COGS-Tracker.xlsx in Excel (desktop, web, or mobile).
2. If you see a Protected View bar, click Enable Editing.
3. Save a personal copy, then follow the 10-minute Quick Start on the first tab.
★ PRINTING
Print the PDF at home or at a print shop. Choose "Actual size" or "Fit" in your print settings. Print every page or only the ones you need. The pages use thin lines and little color to save ink.
★ PART OF A SET
LeafLedgerCo's Small Business Tools share the same 15 business categories (and the Side Hustle Income & Tax Tracker uses them too), so your numbers line up across the Pricing Calculator, Inventory & COGS Tracker, Bookkeeping & P&L, Invoices, Client & Project Tracker, Craft Fair Tracker, Marketing Planner, and Launch Planner.
★ PLEASE NOTE
• This is a DIGITAL DOWNLOAD. Nothing will be shipped to you.
• Download your files from the link in your purchase receipt email (a computer is easiest).
• FREE 2028 UPDATE: when the 2028 edition is ready, I'll add it to this listing and you can download it at no extra cost from your original purchase download link. I'll also email buyers when the update is ready.
• Amounts are shown in US dollars. You can change the currency format in your spreadsheet app.
• You need a free Google account or Microsoft Excel to use the spreadsheet, and a PDF reader to print.
• The listing photos show example data so you can see how it works. Your file arrives blank.
• This is an organizing and planning tool, not tax, legal, or accounting advice.
• For personal use only. Please do not share or resell the files.
• Colors may look slightly different on screen than on paper.
★ ABOUT HOW THIS WAS MADE
This product was designed with AI assistance under my direction. I planned it, set its features and look, and reviewed and tested the spreadsheet formulas and printable pages before listing.
Questions? Use the contact form on this store, or reply to your receipt email. I'm happy to help you get set up.