NowPrice:$8.83
Original Price: $11.04
20% off
Sale ends on October 15
Inventory Spreadsheet | Stock Tracker with Reorder List and Stock Take Sheet | Small Business Inventory | Excel & Google Sheets Template
You can only make an offer when buying a single item
Highlights
INVENTORY SPREADSHEET THAT TELLS YOU WHAT TO REORDER BEFORE YOU RUN OUT
Keep every product, delivery and sale in one Excel and Google Sheets workbook. Log stock in and stock out, and the sheet works out current stock, stock value and an OK / LOW / OUT status for every item. Anything at or below its reorder point drops onto a reorder list by itself, with the supplier, the order quantity and the estimated cost. Count the shelves on the printable stock take sheet and see the variance in units and pounds.
It opens with 40 sample products and 120 sample stock movements so you can see how it works. Clear them in a couple of minutes (instructions inside) and add your own.
WHAT'S INSIDE (8 sheets)
• Start here - 8 numbered steps, what each sheet does, and how to clear the sample data
• Dashboard - total stock value, items OK / LOW / OUT, movements this month, top 10 items by value, and stock value by category with a chart
• Items - one row per product (room for 150). Current stock, stock value, OK / LOW / OUT status, last movement and days since movement all calculate themselves
• Stock movements - log IN, OUT and ADJUST with a SKU dropdown (room for 1,000 movements); the item name and value fill in for you
• Reorder list - builds itself from your reorder points, with supplier, order quantity, estimated cost and supplier lead time
• Stock take - printable count sheet with expected, counted, variance and variance value, plus count date and counted-by fields
• Suppliers - supplier names and lead times in days (contact fields are there for your own notes)
• Lists - editable dropdowns for categories, locations and units
HOW IT WORKS
1. Set up your categories, locations and units on the Lists sheet.
2. Add your products on Items: SKU, cost, supplier, reorder point, reorder quantity and opening stock.
3. Log every delivery (IN), sale or issue (OUT) and correction (ADJUST) on Stock movements.
4. Check the Dashboard, order from the Reorder list, and count the shelves on the Stock take sheet.
WHO IT'S FOR
Small shops and online sellers, workshops and trade counters, warehouses and stockrooms, offices with a supplies cupboard, and anyone who has outgrown a notebook but does not want stock software.
GOOD TO KNOW
• Works in Microsoft Excel 2016 or newer, Excel 365 and Google Sheets
• Formulas only: no macros, add-ins or external links
• Dates are dd/mm/yyyy and money is in pounds sterling
• A4 print layout on the register, reorder list and stock take sheets
• Instant download: one .xlsx file
• Licence: one business, unlimited users at that business. Do not resell.
• A real person answers messages within 24 hours
Works well with our other SafetyDeskStudio trackers.
Instant Download
Your files will be available to download once payment is confirmed. Here's how.
Instant download items don’t accept returns, exchanges or cancellations. Please contact the seller about any problems with your order.
Etsy Purchase Protection
Shop confidently on Etsy knowing if something goes wrong with an order, we've got your back for all eligible purchases —
see program terms
Be the first to review this item
More from this shop
Visit shop-
Digital download
Cleaning Schedule Template | Cleaning Checklist, Office and Kitchen Cleaning Rota, Sign-off Log | Excel and Google Sheets Template
Sale Price $6.62
Original Price $8.28
-
Digital download
Training Matrix Excel Template | Employee Training Tracker, Staff Training Log, Skills Matrix | Excel and Google Sheets Template
Sale Price $8.83
Original Price $11.04
-
Digital download
Etsy Seller Spreadsheet | Etsy Fee Calculator, Profit Tracker and Order Log | Etsy Bookkeeping | Excel & Google Sheets Template
Sale Price $9.94
Original Price $12.42
-
Digital download
Small Business Bookkeeping Spreadsheet UK | Self Employed Income and Expense Tracker, VAT and Mileage | Excel & Google Sheets Template
Sale Price $11.04
Original Price $13.81
Shoppers with similar taste loved these
-
Digital download
Small Business Bundle Bookkeeping Inventory Tracker Order Tracker Product Handmade Pricing Calculator Smart Bill Calendar Google Sheet Excel
Sale Price $14.67
Original Price $29.34
-
Digital download
Expense Income Tracker Spreadsheet Business Finance Log Personal Budget Organizer Money Tracking Template Google Sheets Excel Accounting
$4.50
-
Digital download
Small Business Reseller Spreadsheet, Automated Monthly Inventory, Profit, Sales Dashboard, Order & Stock Status View, Google Sheets Excel
Sale Price $13.69
Original Price $27.39
-
Digital download
Sales Tracking Spreadsheet Multi-Platform Tracker Product Costing Template Excel Google Sheets Sales App for Business Revenue Analytics
$5.50
-
Digital download
Small Business Spreadsheet Inventory Tracker Order Sales Tracker Product Handmade Pricing Calculator Client Tracker Google Sheets Excel
Sale Price $8.07
Original Price $16.13
-
Digital download
Small Business Bookkeeping Tracker Inventory Tracker Order Tracker Handmade Product Task Tracker Pricing Calculator Google Sheets Excel
Sale Price $11.00
Original Price $22.00
-
Digital download
Small Business Finance Tracker Notion Template, Income and Expense, Bookkeeping, Notion Financial Planner
Sale Price $6.85
Original Price $10.54
-
Digital download
Small Business Planner Budget Spreadsheet: Income, Expense, Inventory Tracker, Sales Tax, Bookkeeping Template Accounting (Google Sheets)
Sale Price $9.81
Original Price $16.34
-
Digital download
Small Business Bookkeeping Spreadsheet Inventory Tracker Order Tracker Product Handmade Pricing Calculator Client Tracker Google Sheet Excel
Sale Price $12.10
Original Price $24.20
-
Digital download
All-in-One Business Spreadsheet Bundle | Editable Google Sheets & Excel Templates |Complete Sales and Inventory Management System|PLR Rights
Sale Price $1.23
Original Price $2.45
-
Digital download
PLR Small Business Digital Product Bookkeeping Tracker Task & Invoice Tracker Financial Planner Client Tracker Digital Download
Sale Price $7.02
Original Price $14.05
-
Digital download
Etsy Seller Bookkeeping Spreadsheet Small Business Planner Income Expense Profit Tracker Google Sheets Excel Accounting Template Tax Tracker
Sale Price $8.07
Original Price $16.13