{"product_id":"inventory-spreadsheet","title":"Inventory Spreadsheet, Inventory Tracker for Small Business, Raw Material and Product Inventory Management, Recipe Cost, Google Sheets Excel","description":"\u003cp\u003e\u003cstrong\u003eINVENTORY SPREADSHEET FOR GOOGLE SHEETS AND EXCEL\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eAn inventory spreadsheet for makers and small businesses that buy materials, make products in batches and sell in more than one place. Each purchase, batch, sale or move is one line, and the file keeps stock, cost and your restock list up to date.\u003cbr\u003eFor candles, soap, jewelry, crochet, or anything you make from materials.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003e📊 WHAT IT DOES\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003e✓ Log: one line per purchase, batch, sale, move or correction. A batch uses up its materials by the recipe.\u003cbr\u003e✓ Materials: stock on hand, average cost per unit, use per week, days left and a status: OK, Low, Short for plan or Out.\u003cbr\u003e✓ Recipes: what goes into one piece, the cost of each line, how many pieces it allows, and which line holds production back.\u003cbr\u003e✓ Products: cost per piece, margin, 30-day sales, how many more you can make, and how many to make for your plan.\u003cbr\u003e✓ Restock: a shopping list by supplier, rounded up to whole packs, with an approximate cost and the day to order by.\u003cbr\u003e✓ Batches: every batch with its cost per piece and the day it is ready to sell after curing.\u003cbr\u003e✓ Locations: what is in your studio, your market box or a consignment store, and what sold from each place.\u003cbr\u003e✓ Price Watch: how each material's price changed since your first purchase, and what that adds to the cost of a piece.\u003cbr\u003e✓ Year \u0026amp; COGS: cost of goods sold for the tax year, laid out line by line like Schedule C, Part III.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003e📂 WHAT'S INSIDE: 14 TABS AND 37 CHARTS\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003e✓ Start with these three: Start here, Log, Home\u003cbr\u003e✓ Set up once: Materials, Recipes, Products, Settings\u003cbr\u003e✓ What to do next: Restock, Batches, Locations, Stock Count\u003cbr\u003e✓ Money: Price Watch, Month, Year \u0026amp; COGS\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003e📝 HOW IT WORKS\u003c\/strong\u003e\u003c\/p\u003e\n\u003col\u003e\n\u003cli\u003eOpen the PDF and click the link to make your own copy in Google Sheets. Or open the Excel file.\u003c\/li\u003e\n\u003cli\u003eOn Start here, type your business name. Then set up once: your materials, your products with prices, and a recipe for each product.\u003c\/li\u003e\n\u003cli\u003eFrom then on, type only on Log: Bought, Made, Sold, Moved or Adjust, with the date, the item and the quantity.\u003c\/li\u003e\n\u003cli\u003eEverything else fills in by itself. Home shows your stock value, what is running low, what to make next, what to order and this month's sales.\u003c\/li\u003e\n\u003c\/ol\u003e\n\u003cp\u003e\u003cstrong\u003e📥 WHAT YOU GET\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003e✓ Google Sheets version (the link is in the PDF)\u003cbr\u003e✓ Excel version (.xlsx) for desktop Excel on Windows or Mac\u003cbr\u003e✓ A filled example to look around, and a blank copy for your own data\u003cbr\u003e✓ A PDF guide: a picture of every tab and your first five minutes, step by step\u003cbr\u003e✓ A video guide for this planner (the link is in the PDF)\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003e💻 GOOD TO KNOW\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003e✓ Works with a free Google account. No add-ons, no subscription, no barcode scanner.\u003cbr\u003e✓ Type only in the input cells. Formulas are protected, so you can't break them by accident.\u003cbr\u003e✓ It does not connect to your online store. Type each sale, or one line per product for a day's sales.\u003cbr\u003e✓ Gift sets and bundles of your own products use up their parts when they sell.\u003cbr\u003e✓ Costs use your average cost per unit. Year \u0026amp; COGS is bookkeeping help, not tax advice.\u003cbr\u003e✓ Room for 60 materials, 40 products and 1,500 Log lines.\u003cbr\u003e✓ Best on a computer. The Google Sheets app works for quick entries on your phone.\u003cbr\u003e✓ Amounts show in dollars. The formulas work the same in any currency.\u003cbr\u003e✓ The Excel version may look slightly different from the photos (fonts, colors, charts). The photos show Google Sheets.\u003cbr\u003e✓ English only. Not made for Apple Numbers.\u003cbr\u003e✓ Free updates for life.\u003c\/p\u003e\n\u003cp\u003eThis is a digital download. Nothing will be shipped. Because it is a digital file, it can't be returned, but if anything is unclear, message me and I will help you set it up.\u003cbr\u003eThis planner is a tool for your own records, not financial or tax advice.\u003c\/p\u003e","brand":"GrowlyLab","offers":[{"title":"Default Title","offer_id":67638936469657,"sku":null,"price":13.95,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0738\/8613\/8521\/files\/il_fullxfull.8692754423_dtqd.jpg?v=1791480067","url":"https:\/\/growlylabstudio.com\/products\/inventory-spreadsheet","provider":"GrowlyLab","version":"1.0","type":"link"}