--- title: "Inventory Tracker & Reorder Workbook (Excel) | MCC Solutions" description: "Excel workbook for small product sellers: log stock received, sold and counted, see on-hand quantity, average cost, days of stock and when to reorder…" url: "https://mcc-solutionsnj.com/toolkits/inventory-tracker-reorder-workbook" --- Excel workbook # Inventory Tracker and Reorder Workbook: Stock Levels, Reorder Points, Purchase Orders and Turnover in Excel Log what comes in and goes out and see what you have, what it is worth, what to reorder and what has not sold. **$34** one time · 14-day full refund · example and blank copies · download link by email Buy now, $34 🌙 The desk is asleep. The store never is. Every kit and ebook downloads the moment you pay, day or night. Questions get answered after we open in the morning. [Browse the store](/toolkits) Who it is for Etsy and Shopify sellers, small retailers and anyone who keeps stock and wants to stop running out or over-buying. Not the right fit if You need inventory synced automatically with your store, or accounting-grade costing like FIFO. Why it is different - Reorder points come from your own recent sales and your own lead times, not a fixed rule. - It finds dead stock, the items that have not sold in 90 days, and shows what money is tied up in them. - A filled example for an invented online shop with 25 items and a blank copy with working formulas. What is inside - **Start Here.** Purpose, which cells to fill in and how stock value is worked out. - **Setup.** Default lead time, safety stock days, an as-of date and your categories and suppliers. - **Items.** Up to 150 items with on-hand quantity, average cost, stock value, days of stock left, reorder point and a status of OK, Reorder now, Out of stock or Overstock. - **Movements.** Stock received, sold, returned and adjusted, by date and item. - **Purchase Orders.** Items that need reordering with a suggested quantity and cost, with totals by supplier. - **Summary.** Total stock value, items to reorder, inventory turnover, days of inventory, the ten items holding the most value and stock that has not sold. - **Count Sheet.** A printable sheet for a physical count with the variance and its value. - **Checks.** Negative stock, duplicate item codes, unknown items and missing costs. A look inside ## Example data, real formulas [![Summary tab of the Inventory Tracker and Reorder Workbook, with example data](/img/toolkits/inventory-tracker-reorder-workbook/a.png)](/img/toolkits/inventory-tracker-reorder-workbook/a.png) Summary tab with example data. Made-up numbers. [![Items tab of the Inventory Tracker and Reorder Workbook, with example data](/img/toolkits/inventory-tracker-reorder-workbook/b.png)](/img/toolkits/inventory-tracker-reorder-workbook/b.png) Items tab with example data. Made-up numbers. Get it ## Inventory Tracker and Reorder Workbook Or pay with PayPal Uses the email and terms box above. You get the same download link by email. ZIP code (for sales tax) Want every toolkit? The [toolkit membership](/membership) includes all of them, with a lower rate if you pay yearly. Get every update for a year, $29: the [Yearly Updates Pass](/updates-pass?kit=inventory-tracker-reorder-workbook) gives you each refreshed edition we release of the kits you own. One payment, no automatic renewal. Delivered as a zip with a filled example and a blank copy. Built for Excel, tested in LibreOffice; it should open in Google Sheets but not every feature is tested there. For one business, your own use. General information, not accounting, tax or legal advice. Average cost is a simplified running average, and reorder points and suggested quantities are planning rules of thumb, not accounting figures. A physical count always wins. Not accounting or tax advice. Payment is handled by Stripe. If a file will not open or something looks wrong, reply to your order email and we will make it right. Ways to get it ## Just this kit, or more This kit **$34 one time** Inventory Tracker & Reorder Workbook. Buy this kit The set **$65 one time** 3 kits including this one, $17 less than buying them separately. [See the set](/toolkits/product-seller-bundle) Membership **$29 a month** Every kit and document pack in the store, including new ones. Cancel any time. [See the membership](/membership) Questions ## Common questions **What do I get and how is it delivered?** The Inventory Tracker & Reorder Workbook as two Excel files in one zip: a filled-in EXAMPLE so you can see every tab working, and a BLANK copy for your own numbers, plus a README. The download link arrives by email after payment. **Will it open on a Mac, Google Sheets or my phone?** Built for Excel and tested in LibreOffice, which runs on Mac and Windows; it should open in Google Sheets, but not every feature is tested there. Phone spreadsheet apps are not tested. If a file will not open or something looks wrong, reply to your order email and we will make it right. If it is not right for you, email us within 14 days of buying for a full refund. **Is this legal or tax advice?** No, it is not accounting or tax advice. **Is it the right fit for me?** It is made for Etsy and Shopify sellers, small retailers and anyone who keeps stock and wants to stop running out or over-buying. Skip it if you need inventory synced automatically with your store, or accounting-grade costing like FIFO. Rather hand it off? ### We can keep the books for you each month If tracking this yourself is more than you want to take on, we do monthly bookkeeping in QuickBooks, Xero or Excel. Tell us what you use and what is behind, and we reply with a written quote after a short review of your books. No obligation. [Get a bookkeeping quote](/bookkeeping/#interest) [Free books health check](/bookkeeping/health-check) Prefer to keep it yourself but want a hand getting started? [Book a 45 minute setup session](/workbook-setup-session) ($65). Buy it with the others [Bundle ### Product Seller Bundle This product plus 2 more, in one download. $65 instead of $82 separately](/toolkits/product-seller-bundle)[Bundle ### Food Business Bundle This product plus 3 more, in one download. $75 instead of $101 separately](/toolkits/food-business-bundle)[### Month-End Close Workbook A real month-end close in one Excel file. It tells you when a rec does not tie, which variances still need an answer, and when the period is ready to lock. $19](/toolkits/month-end-close-workbook) ## More bookkeeping and business toolkits - [Iowa Employer Compliance Kit 2027](/toolkits/iowa-employer-compliance-kit-2027) $19 - [Iowa Landlord Compliance Kit](/toolkits/iowa-landlord-compliance-kit) $19 - [Iowa Small Claims Court Kit](/toolkits/iowa-small-claims-court-kit) $19 - [Iowa Unemployment Checklist](/toolkits/iowa-unemployment-checklist) $15 - [IT and Tech Support Resume Template Pack](/toolkits/it-tech-support-resume-template-pack) $15 - [Job Search and Work Search Log Kit](/toolkits/job-search-work-search-log-kit) $14 [See every toolkit and document pack](/toolkits/all) ## Rather have someone do the books? [Get a Bookkeeping Quote](/bookkeeping/#interest)[Call (908) 444-6373](tel:+19084446373)