What is on the shelf, what it cost, and what to reorder
Know what is on the shelf, what it cost you and what to reorder, for up to 500 products. Excel and Google Sheets.
What you get
- Excel workbook, 8 tabs and 6 chartsStart here, Settings, Dashboard, Products, Stock in, Stock out, Stock take and value, Low stock and reorder
- Google Sheets versionA make-a-copy link puts it in your own Drive in one click
- 9 page PDF guideSettings, products, stock in and out, reordering, the stock take and the value for your accounts, each with a worked example
- Open me first pageThe Google Sheets button and the three things to do first
Why this one
- Landed cost, not just the invoice priceDelivery, duty and fees on a delivery go into the cost of each unit, and each product's average cost blends every delivery with your opening stock.
- A date to order byDays of stock left come from what you sold in the last 90 days, and the order-by date allows for each supplier's lead time.
- A stock take that fixes the numbersAfter a count, each product is your count plus everything in and out since, and the differences are shown at cost.
- A value for your accountsEach product at the lower of its average cost and what it would sell for less selling costs, the way HMRC's Business Income Manual describes it.
- Sales, returns and write-offs kept apartOnly sales count towards the speed of sale and your gross margin. Damaged, lost and gifted stock leaves the shelf without a sale.
How it works
- ProductsEach product once, with its opening stock and cost, selling price, reorder point and reorder quantity
- Stock in and stock outEach delivery, sale, return or write-off as it happens. Stock on hand updates itself
- Low stock and reorderOrder what it lists, and count your stock on Stock take and value at least once a year
Who it is for
UK small sellers who hold their own stock: Etsy, eBay, Amazon, TikTok Shop and website shops, market traders and small wholesalers, from 20 products to 500. Landed cost means what one unit really cost you once it reached you: the supplier's price plus delivery, duty and fees. A reorder point is the stock level at which you order more.
Questions
Do I need Microsoft Excel?
No. It comes with a Google Sheets version, which is free with a Google account. The Excel file also opens in the free web version of Excel.
How do I get it?
Straight after payment it is in your library on this site: the Excel file, the PDF guide and the Open me first page with the Google Sheets button.
How much can it hold?
Up to 500 products or variants, 2,000 delivery lines and 2,000 lines for sales, returns and write-offs.
What happens when a supplier changes its price?
Type the new cost on the next delivery and the average cost moves by itself. Add new products at any time.
Is this accounting advice?
No. It is a stock-keeping tool, not tax or accounting advice. Your accountant or HMRC have the final word on your figures.
Made by Izhar Shah. I built a brand in the evenings alongside a full-time engineering job, and in its first twelve months it passed £500,000 in sales. I make the sheets I wish I had when I started.
Works in
Instant access in your library after payment. A stock-keeping tool, not tax or accounting advice.