Always know what you have. Log supplies you buy, batches you make and items you sell; your recipes use up supplies automatically, so stock levels stay right. Get REORDER and LOW STOCK flags, stock value and a simple dashboard. Works in Excel and Google Sheets. Includes a filled example. Built with AI assistance, checked by hand.

WHAT IT DOES

• Supplies stock = opening + bought - used in making
• Making a batch uses up supplies through your recipes
• Product stock = opening + made - sold
• REORDER and LOW flags at the levels you set
• Stock value for supplies and finished products
• Dashboard with what to reorder and what is running low
• Blank template + filled example + printable PDF (stock check and production/sales log)

TABS: Start Here, Dashboard, Supplies, Products, Recipes, Purchases, Production, Sales

YOU GET: blank .xlsx template, example copy with made-up data, printable PDF.

HOW TO USE: download from the Content section after checkout. Google Sheets: File upload, then File > Save as Google Sheets. Excel 2016+: just open it. Coloured cells are where you type.

GOOD TO KNOW: one-time purchase, 12 months of download access, nothing shipped, any currency, use in your own shop (no resale). Not affiliated with Etsy. Questions: tidysheets@mail.tab.bot. Built with AI assistance, every formula tested.