Description
Sound familiar?
- Renters pay on different days, some weekly, some monthly, some a share of takings.
- Part payments and “I’ll give you the rest Friday” are hard to keep track of.
- You wonder whether renting a chair really pays better than commission.
What the Chair & Room Rent Tracker does
List each renter and their deal: weekly, monthly, daily, a % of takings, fixed plus %, or whichever is greater. Add a row for each rent period and type what was paid. The sheet works out what is due, what is still owed, flags late payments and adds VAT if you charge it. The Rent vs Commission tab compares renting, commission and a wage, with the break-even takings.
What’s inside
- Start Here – what each colour means and a quick guide to every tab
- Dashboard – due, collected, owed, late payments and occupancy – or, for renters, rent as a % of takings
- Renters – each chair or room, the renter, rent type, amounts, insurance and agreement
- Rent Ledger – one row per rent period: due, paid, still owed and status
- Renter Takings – takings for % of takings deals and the renter view
- Rent vs Commission – renting, commission or a wage side by side, with break-even takings
- Settings – owner or renter mode, your details, VAT on rent and late-payment rules
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, legal or financial advice. It does not decide employment status. 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!
Chair & Room Rent Tracker FAQ
Does it decide if my renters are self-employed?
No. It keeps records only. HMRC looks at the whole arrangement – see the gov.uk guidance on employment status in hair and beauty and the CEST tool.
Can I charge VAT on the rent?
Yes, there is a setting for it. Check with your accountant how VAT applies to your lets.
I rent a chair myself. Is it for me?
Yes. Switch Settings to renter mode to track the rent you pay against your takings, and use Rent vs Commission to compare.
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.