1 / 8
Tap any image to enlarge, then swipe or use the arrows to page through every sheet.
A shoe store is won or lost on two numbers per style: the margin you keep and how fast a size run sells. Most free retail templates do a stock count OR a markup table, never both — and almost never the markdown maths that decides whether an end-of-season clearance still makes money. This kit is the whole retail operating system in one file. On Products you list each style with its wholesale cost and retail price, and the margin and markup are worked out for you, named correctly, plus the margin left after a markdown and the exact price to hit a target margin.
Pricing is where owners slip, so both percentages sit side by side: margin as a share of the price and markup as a share of the cost — a 100% markup is only a 50% margin. Set a clearance price and the kit shows the margin it still leaves, so you never mark down into a loss; set a target margin and it gives you the price to charge; and it shows the break-even pairs at your price so you know how many of each style pays the rent.
And it keeps your stock room — the thing a plain pricing sheet leaves out. Opening plus received minus sold gives what you hold, valued at cost; a sell-through % shows how fast each style is moving; and a reorder point built from your own daily sales and your supplier's lead time flags every style as OK, REORDER or OUT OF STOCK before a size run sells out. The Sales sheet logs each day and the Dashboard adds it all up: revenue, cost of goods, gross profit and margin, net after fixed costs and the tax you should set aside, stock value, how many styles need reordering and which earn the most.
Built for Excel 2016+ and Google Sheets with classic, compatible formulas only — no macros, no add-ons, nothing locked. Any currency (one symbol cell). Sample data for a real shoe store — men's, women's and kids — is filled in so every number and the chart are alive on first open; clear the yellow cells and it is yours. Every headline figure in this listing was measured from the built file, recalculated by LibreOffice and checked against an independent model of the same arithmetic.
What you get
- 6 sheets: Start Here, Products, Inventory, Sales, Dashboard, Checks
- Per-style wholesale cost and retail price → margin % and markup % side by side, named correctly
- Markdown / clearance price with the margin it still leaves — never mark down into a loss
- Price for a target margin, and break-even pairs per style at your price
- A full stock room: on-hand, stock value, sell-through %, reorder point from your sales and lead time, and a REORDER / OUT OF STOCK flag per style
- Sales log with revenue, COGS and profit per line; monthly totals
- Dashboard: revenue, gross profit and margin, net after fixed costs and tax to set aside, stock value, items to reorder, revenue by style
- Any currency (one symbol cell) · no tax jurisdiction baked in · works worldwide
- Excel 2016+ and Google Sheets · no macros · nothing locked · instant download (.xlsx + PDF guide)
- Recalculated by LibreOffice and checked against an independent model — 0 errors
Preview every page
Click any page to zoom.
What's inside
Questions
Does it work in Google Sheets?
Yes. Upload the .xlsx to Google Drive and choose File → Save as Google Sheets. Every formula (SUMIFS, VLOOKUP, COUNTIF, IFERROR) and the chart are Sheets-compatible. A short PDF walks you through it.
Which currency does it use?
Any. You set a currency symbol on Start Here; it is decorative only — the arithmetic uses plain numbers, so the file works in any country with no tax rules baked in.
How does the markdown / clearance margin work?
Enter a markdown price next to a style and the kit shows the margin it still leaves against your wholesale cost, so you can see at a glance whether an end-of-season price is still profitable before you put it on the sale rack.
What does sell-through tell me?
Sell-through % is pairs sold ÷ (pairs sold + pairs on hand) — how much of what you bought has already sold. A high sell-through means reorder; a low one means it may be time to mark it down. The Inventory sheet shows it per style automatically.
What is the difference between margin and markup?
Margin is profit as a share of the price; markup is profit as a share of the cost. A 100% markup is only a 50% margin. The Products sheet shows both, named correctly, so you never confuse them again.
Does it handle sizes?
Track it at whatever level you count stock: one row per style, or one row per size SKU — the maths is the same. Add, rename or remove rows freely; it fits any shoe shop, from a market stall to a boutique.
Is anything locked or macro-based?
No. No macros, no protected sheets, no external links. Blue-on-yellow cells are your inputs; black cells are formulas.
Reviews
No reviews yet — this product is new. Every review here comes from a verified purchase.
Personal-use license for one household. No resale or redistribution. Delivered as a ZIP download immediately after payment. No physical item will be shipped.
Shoe Store Business Kit
Cost, price, stock, sell-through and profit for a shoe store — one Excel & Google Sheets file, any currency, no subscription
Pay with PayPal or any card
- Works in any country · your own currency
- Download link on the confirmation page and by email
- What you need: Excel 2016+ · Google Sheets
- Full refund within 24 hours — just message us, no reason needed
- 6 sheets · 1,573 formulas
- Formats: .xlsx (Excel 2016+, Google Sheets) + PDF guide
- ZIP: 79 KB
Ask within 24 hours of paying and we refund the whole amount — no form, no reason needed. Up to 30 days we still refund, minus the 4% payment processing fee. Files that will not open are always refunded in full, with no time limit.
