{"product_id":"inventory-stock-tracker","title":"Inventory and Stock Tracker Spreadsheet","description":"\u003cp\u003eThis inventory tracker spreadsheet gives makers and small business shops a stock count that matches what is actually on the shelf. Everything you make and everything you sell is counted off one stock log, so the number on the dashboard cannot drift away from the one in the room.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003ePlease read:\u003c\/strong\u003e This is a tracker tool only, not financial, tax, legal, medical or any other professional advice or advisory service. It records and calculates what you enter; you are solely responsible for checking all figures, rates, dates and results and for every decision you make. By purchasing, downloading or using it, you accept these terms (your statutory consumer rights are not affected).\u003c\/p\u003e\u003ch2\u003eThe dashboard\u003c\/h2\u003e\u003cp\u003ePick all categories or a single one and the whole page follows. Nothing on it is typed; it fills itself from what you enter.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eStock at cost: what the stock on your shelves cost to make, and what it sells for\u003c\/li\u003e\n\u003cli\u003eIn and out by month: everything made and everything that left, with the count on hand at each month end\u003c\/li\u003e\n\u003cli\u003eRestock list: lines at or under their reorder level, how many to make and what it costs\u003c\/li\u003e\n\u003cli\u003eFastest movers: the products that sold most in the last 90 days\u003c\/li\u003e\n\u003cli\u003eHow many weeks your stock lasts at the pace of the last 90 days\u003c\/li\u003e\n\u003cli\u003eValue by category, with every share as a percentage\u003c\/li\u003e\n\u003cli\u003eStock by location: shelves, stockroom, market box and more\u003c\/li\u003e\n\u003cli\u003eNot selling: stock with no sale in 90 days, its last sale and the cash it ties up\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eOne file, actually connected\u003c\/h2\u003e\u003cp\u003eA product is entered once, on the Products tab. The recipe, the pricing calculator, the stock valuation and every order line all read that same row. Change one thing and everything that depends on it follows, with no copying a figure from one spreadsheet into another and hoping you remembered.\u003c\/p\u003e\u003ch2\u003eEleven connected tabs\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eProducts:\u003c\/strong\u003e 120 rows, the one place a product is entered\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eMaterials:\u003c\/strong\u003e a materials tracker with 120 rows and the unit cost of each\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003ePricing:\u003c\/strong\u003e cost, suggested price, your price, and margin before and after fees\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eInventory:\u003c\/strong\u003e stock on hand, valued at cost and at retail\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eOrders:\u003c\/strong\u003e 400 lines with profit per line\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eSales:\u003c\/strong\u003e the year by month, with fees and postage taken off\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eStock Log:\u003c\/strong\u003e every batch made and every unit that left, with a reorder level per product that flags itself\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eRecipe:\u003c\/strong\u003e the materials in each product, priced from the Materials tab\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eDashboard:\u003c\/strong\u003e six live figures and what each product did\u003c\/li\u003e\n\u003cli\u003e\u003cstrong\u003eSetup and Start Here\u003c\/strong\u003e\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWhat it does for you\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003ePrices every product from its own recipe of materials\u003c\/li\u003e\n\u003cli\u003eAdds your labor rate and overhead per item automatically\u003c\/li\u003e\n\u003cli\u003eShows the margin you actually keep after the platform's cut\u003c\/li\u003e\n\u003cli\u003eValues your stock at cost and at retail\u003c\/li\u003e\n\u003cli\u003eFlags anything below your reorder level, or below your target margin\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eIt is a stock tracker, cost tracker and reorder tracker for a handmade or craft business. The filled copy holds a whole year of a working shop, so you can see how it behaves before you type anything.\u003c\/p\u003e\u003ch2\u003eWorks with\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eMicrosoft Excel 2016, 2019, 2021 and Microsoft 365, on Windows and Mac, and LibreOffice. No Microsoft 365 subscription needed.\u003c\/li\u003e\n\u003cli\u003eGoogle Sheets with a free Google account. You get real spreadsheet files, not a PDF with a link in it.\u003c\/li\u003e\n\u003cli\u003eNo add-ins, no macros and no subscription\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWhat you download\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eThe Excel workbook, filled with a worked example\u003c\/li\u003e\n\u003cli\u003eThe same workbook, blank and ready for your own numbers\u003c\/li\u003e\n\u003cli\u003eThe instruction guide, with one-click links to the Google Sheets versions (filled and blank)\u003c\/li\u003e\n\u003cli\u003eThe terms of use as a PDF\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eYour files are ready as soon as payment clears. The template is for use in your own business; please do not share or resell the files. Questions before or after you buy? Use our contact page and we will help.\u003c\/p\u003e\u003ch2\u003eFrequently asked questions\u003c\/h2\u003e\u003ch3\u003eDoes it work in Excel and Google Sheets?\u003c\/h3\u003e\u003cp\u003eYes. The Excel workbook runs in Excel 2016 or later on Windows and Mac, and the instruction guide has two one-click links to the Google Sheets versions.\u003c\/p\u003e\u003ch3\u003eHow many products and orders can it hold?\u003c\/h3\u003e\u003cp\u003eThe Products and Materials tabs have 120 rows each, and the Orders tab has 400 lines with profit per line.\u003c\/p\u003e\u003ch3\u003eWill it tell me when to restock?\u003c\/h3\u003e\u003cp\u003eYes. Each product has a reorder level that flags itself when stock drops, and the dashboard's restock list shows how many to make and what it costs.\u003c\/p\u003e\u003ch3\u003eCan I track stock in more than one place?\u003c\/h3\u003e\u003cp\u003eYes. The dashboard shows what is kept where, such as shelves, stockroom and market box.\u003c\/p\u003e\u003ch3\u003eDoes it work out what my products cost to make?\u003c\/h3\u003e\u003cp\u003eYes. The Recipe tab prices each product from its materials, and the workbook adds your labor rate and overhead per item.\u003c\/p\u003e","brand":"OPXVIA","offers":[{"title":"Default Title","offer_id":67597861748830,"sku":"OPX-026","price":22.0,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0769\/2094\/6782\/files\/inventory-stock-tracker-01.jpg?v=1790832072","url":"https:\/\/opxviashop.com\/products\/inventory-stock-tracker","provider":"OPXVIA","version":"1.0","type":"link"}