{"id":12969,"date":"2026-09-19T15:06:22","date_gmt":"2026-09-19T15:06:22","guid":{"rendered":"https:\/\/templacity.com\/?post_type=product&#038;p=12969"},"modified":"2026-10-17T09:17:50","modified_gmt":"2026-10-17T09:17:50","slug":"inventory-tracker-spreadsheet","status":"publish","type":"product","link":"https:\/\/templacity.com\/fr\/product\/inventory-tracker-spreadsheet\/","title":{"rendered":"Inventory &#038; Stock Tracker Spreadsheet (Google Sheets + Excel)"},"content":{"rendered":"<p><span class=\"eyebrow\">\u2116 \u00b7 Log the movement, the count follows<\/span><\/p>\n<h2 id=\"an-inventory-spreadsheet-that-works-stock-out-from-every-delivery-and-sale\">An inventory spreadsheet that works stock out from every delivery and sale<\/h2>\n<p>The Inventory &amp; Stock Tracker is for a small shop, maker or wholesaler who keeps stock on shelves and needs to know what to reorder before it runs out. Add your suppliers with their lead times, then your items: a unique SKU, name, category, location, supplier, cost, price, the stock you hold today and a reorder point.<\/p>\n<h3>Never type a quantity again<\/h3>\n<p>From then on, every movement is one row on the Stock Log: In for a delivery, Out for a sale, Adjust after a count, minus for a loss. On hand is opening stock plus in, minus out, plus adjustments, so a sale logged twice shows up as a wrong count rather than a silent one. Put a price on an Out line and the Dashboard counts what you sold as well as how many.<\/p>\n<h3>What to order this week<\/h3>\n<p>Reorder lists every item at or under its reorder point with a suggested quantity, the supplier, their lead time and the cost. What If goes further: at your sales pace, the day each item runs out against its supplier&rsquo;s lead time, so you see what would sell out before an order placed today arrives. The Dashboard keeps stock value at cost and at retail, best sellers over 30 days and slow movers after 60.<\/p>\n<p>Selling one-off items across marketplaces instead? The <a href=\"\/product\/reseller-inventory-profit-tracker-spreadsheet\/\">Reseller Inventory &amp; Profit Tracker<\/a> follows each item to its profit.<\/p>\n<p>The download is a short PDF with two Google Sheets buttons, one for a blank copy in your own Drive and one for a copy filled with an example, the same workbook as blank and example Excel files, and a one-page Quick Start for each.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Stock on hand worked out from every movement in and out, a reorder list with quantities, suppliers and cost, and a dashboard of stock value, best sellers and slow movers.<\/p>\n","protected":false},"featured_media":13438,"comment_status":"open","ping_status":"closed","template":"single-product-bundle.html","meta":{"rank_math_title":"Inventory Tracker Spreadsheet for Google Sheets and Excel | Templacity","rank_math_description":"An inventory and stock tracker for Google Sheets and Excel: stock log, reorder list with supplier lead times, stock value and best sellers on a dashboard.","rank_math_seo_score":"9","_templacity_copy_live":"1","_templacity_faq":[{"q":"How is the stock on hand worked out?","a":"Opening stock plus every In, minus every Out, plus adjustments, all from the Stock Log. You never type an on-hand figure."},{"q":"How does it know when to reorder?","a":"Each item has a reorder point. At or under it, the item appears on Reorder with a suggested quantity, its supplier, lead time and the cost."},{"q":"What if a count does not match?","a":"Log an Adjust line for the difference, minus for a loss. The item's history stays intact."},{"q":"Can I track stock in more than one place?","a":"Each item carries a location, Shelf A, Back room or your own names, and the Dashboard shows stock by location and by category."},{"q":"Does it work in Excel?","a":"Yes. The download carries native .xlsx files, one blank and one filled with an example, for Excel 2010 and later, Excel for Mac and Microsoft 365. Every formula is ordinary Excel, with no macros to enable."}]},"niche":[337],"template_type":[],"templacity_topic":[],"product_brand":[],"product_cat":[24],"product_tag":[44],"class_list":["post-12969","product","type-product","status-publish","has-post-thumbnail","niche-spreadsheets","product_cat-spreadsheets","product_tag-google-sheets","first","instock","downloadable","virtual","purchasable","product-type-simple"],"_links":{"self":[{"href":"https:\/\/templacity.com\/fr\/wp-json\/wp\/v2\/product\/12969","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/templacity.com\/fr\/wp-json\/wp\/v2\/product"}],"about":[{"href":"https:\/\/templacity.com\/fr\/wp-json\/wp\/v2\/types\/product"}],"replies":[{"embeddable":true,"href":"https:\/\/templacity.com\/fr\/wp-json\/wp\/v2\/comments?post=12969"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/templacity.com\/fr\/wp-json\/wp\/v2\/media\/13438"}],"wp:attachment":[{"href":"https:\/\/templacity.com\/fr\/wp-json\/wp\/v2\/media?parent=12969"}],"wp:term":[{"taxonomy":"niche","embeddable":true,"href":"https:\/\/templacity.com\/fr\/wp-json\/wp\/v2\/niche?post=12969"},{"taxonomy":"template_type","embeddable":true,"href":"https:\/\/templacity.com\/fr\/wp-json\/wp\/v2\/template_type?post=12969"},{"taxonomy":"templacity_topic","embeddable":true,"href":"https:\/\/templacity.com\/fr\/wp-json\/wp\/v2\/templacity_topic?post=12969"},{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/templacity.com\/fr\/wp-json\/wp\/v2\/product_brand?post=12969"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/templacity.com\/fr\/wp-json\/wp\/v2\/product_cat?post=12969"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/templacity.com\/fr\/wp-json\/wp\/v2\/product_tag?post=12969"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}