Description
Sound familiar?
- You run out of your best-selling shade halfway through a colour.
- Money sits on the shelf in products nobody uses.
- You have never worked out how much product goes into each service.
What the Salon Stock & Product Cost Tracker does
List your products with pack size, invoice cost and retail price. Log deliveries, retail sales, waste and (if you like) what goes in the bowl. The sheet keeps a running stock count, builds a reorder list from your reorder levels and works out the cost per ml or gram. On Service Costing you list what each service uses and see the product cost, its % of the price and what is left per hour. A monthly stock take corrects any gaps.
What’s inside
- Start Here – what each colour means and a quick guide to every tab
- Dashboard – stock value, low stock, retail profit and spend per month
- Products – every product with pack size, cost, retail price, reorder level and stock now
- Purchases – each delivery or invoice line
- Usage – retail sales, waste and product used in services
- Stock Take – your shelf count against what the sheet expected
- Service Costing – product cost per service and what is left per hour
- Reorder List – everything at or below its reorder level
- Settings – your salon name, VAT and suppliers
Format
- Your blank spreadsheet (.xlsx, UK edition), ready for your salon
- A filled-in DEMO copy, so you can see every tab working before you start
- A full PDF user guide: set-up, every tab explained, a routine, the rules that apply and answers to common questions
- Works in Microsoft Excel (Windows and Mac) and Google Sheets
- No macros, nothing to install, no subscription
- Yellow boxes are for you to fill in; the rest works itself out
Mix & match: pick any of our hair salon sheets on this page – any 3 for 15% off, any 5 for 25% off. The discount is added in your basket.
How it works
- Buy and download the file straight away.
- Open it in Excel, or upload it to Google Sheets.
- Open the DEMO and the PDF guide to see how it works, then fill in Settings on your blank copy and start typing your own.
Please note
This is a digital product — nothing will be posted. A record-keeping spreadsheet, not tax or accounting advice. For use in your own business only — please don’t resell or share the file.
Questions before you buy? Email hello@spreadsheetland.com — happy to help!
Salon Stock & Product Cost Tracker FAQ
Do I have to log every gram?
No. Log what you can, then do a stock take each month and the sheet corrects itself.
Does it handle VAT?
Yes. Type the cost as it is on the invoice. If you are VAT registered, the sheet takes off the VAT you can reclaim.
How many products can I add?
Up to 300 products, and the Reorder List shows up to 100 lines at once.
Do I need Microsoft Excel?
No. It works in Microsoft Excel, or free in Google Sheets.
Is it a subscription?
No. It is a one-off payment and the file is yours to keep. There are no monthly fees.
I’m not good with spreadsheets. Is this for me?
Yes. You type into the yellow boxes and everything else works itself out. There are no formulas to write, and the PDF guide walks you through it.
Can I see it before I buy?
Yes. Look through the screenshots above. Your download includes a filled-in DEMO copy and a full PDF guide as well as the blank spreadsheet, so you can see exactly how it works before adding your own.
Does it work on a Mac, iPad or phone?
Yes on a Mac: use Excel for Mac, or open it free in Google Sheets in your web browser. On an iPad or phone you can open it in the free Excel or Google Sheets app, but a computer is easier for setting it up.
Can I get a refund?
Because it is an instant digital download, I can’t offer a refund once the file has been downloaded. If the file is faulty and I can’t fix it, you were charged twice, or you received the wrong product, I will put it right or refund you. See the Refund Policy. This doesn’t affect your statutory rights.
How do I get my file?
It is an instant digital download. You will get a download link straight after checkout, and by email.
What if I get stuck?
Email hello@spreadsheetland.com and I will help you get set up.
Reviews
There are no reviews yet.