{"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-09-27T15:14:03","modified_gmt":"2026-09-27T15:14:03","slug":"inventory-tracker-spreadsheet","status":"publish","type":"product","link":"https:\/\/templacity.com\/es\/product\/inventory-tracker-spreadsheet\/","title":{"rendered":"Inventory &#038; Stock Tracker Spreadsheet (Google Sheets + Excel)"},"content":{"rendered":"<p>An inventory spreadsheet that counts stock from movements rather than asking you to overwrite a number. Log stock in, sales and count adjustments, and On hand stays right.<\/p>\n<ul>\n<li><strong>Dashboard<\/strong>: stock value at cost and at retail, what to reorder, what is out, best sellers, slow movers, stock by category and location.<\/li>\n<li><strong>What If<\/strong>: what to order this week, and the day each item runs out against its supplier&#8217;s lead time (the textbook reorder point). Levers: a sales change from the recent pace, and safety days.<\/li>\n<li><strong>Items<\/strong>: every item with SKU, location, supplier, cost, price and reorder point.<\/li>\n<li><strong>Stock Log<\/strong>: one row per movement: in, sold, or an adjustment after a count.<\/li>\n<li><strong>Reorder<\/strong>: every item at or under its reorder point, how many to order, from whom, their lead time and the cost.<\/li>\n<li><strong>Suppliers<\/strong>: details, lead times, and how many of their items need ordering.<\/li>\n<li><strong>Settings<\/strong>: categories, locations, and the windows for best sellers and slow movers.<\/li>\n<\/ul>\n<p><strong>What you get:<\/strong> a one-page PDF with two buttons. One makes a blank copy of the Google Sheet in your own Drive, the other a copy filled with an example so you can see every tab working first. The same workbook comes as two Excel files, blank and example, checked in Excel with every formula recalculated. No year is printed anywhere, so it starts the day you do.<\/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":"","_templacity_faq":[]},"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\/es\/wp-json\/wp\/v2\/product\/12969","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/templacity.com\/es\/wp-json\/wp\/v2\/product"}],"about":[{"href":"https:\/\/templacity.com\/es\/wp-json\/wp\/v2\/types\/product"}],"replies":[{"embeddable":true,"href":"https:\/\/templacity.com\/es\/wp-json\/wp\/v2\/comments?post=12969"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/templacity.com\/es\/wp-json\/wp\/v2\/media\/13438"}],"wp:attachment":[{"href":"https:\/\/templacity.com\/es\/wp-json\/wp\/v2\/media?parent=12969"}],"wp:term":[{"taxonomy":"niche","embeddable":true,"href":"https:\/\/templacity.com\/es\/wp-json\/wp\/v2\/niche?post=12969"},{"taxonomy":"template_type","embeddable":true,"href":"https:\/\/templacity.com\/es\/wp-json\/wp\/v2\/template_type?post=12969"},{"taxonomy":"templacity_topic","embeddable":true,"href":"https:\/\/templacity.com\/es\/wp-json\/wp\/v2\/templacity_topic?post=12969"},{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/templacity.com\/es\/wp-json\/wp\/v2\/product_brand?post=12969"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/templacity.com\/es\/wp-json\/wp\/v2\/product_cat?post=12969"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/templacity.com\/es\/wp-json\/wp\/v2\/product_tag?post=12969"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}