What’s in your download

Your blank spreadsheet – ready for your own details (Excel and Google Sheets), with a Country setting for the UK, USA, Canada, Australia and New Zealand
A filled-in EXAMPLE copy – the same sheet with two example holiday lets and a year of bookings, so you can see every tab working
A full PDF user guide – choosing your country, every tab explained, a simple routine, a worked example, the rules where you are (with official sources), troubleshooting and FAQs

Airbnb, Vrbo, Booking.com and direct bookings – each with different fees and payout dates. This brings every booking, changeover and cost for your holiday lets into one file and shows what you actually made.

Sound Familiar?

Not sure what you really earned after every platform took its cut
A double booking you only spotted when the second guest messaged
Cleaner and linen costs scattered across messages and receipts
No idea whether you’re on track for the day-count rules where you are

That’s not a you problem – it’s a missing-system problem.

One Command Centre for Your Short Lets

Log each booking once and the sheet works out nights, platform fees, payouts, occupancy, ADR and RevPAR by property and platform, flags double bookings, lists upcoming changeovers and counts the days you need for your country’s rules.

Pick Your Country

One cell on Settings switches the title, wording, currency, tax year and Day Count test: UK business-rates tests (including Wales and Northern Ireland), the US 14-day / 10% personal-use rule, Canada’s rental and personal split, Australia’s private-use apportioning and New Zealand’s mixed-use 62-day test.

Bonus: See It in Action

Your download includes a fully filled-in example with two holiday lets and a year of bookings.

What’s Inside

Dashboard – occupancy, ADR, RevPAR, income by platform and property, upcoming changeovers and charts
Bookings – every stay with platform fees, payout and a double-booking alarm
Changeovers & Cleaning – cleaner pay and linen cost per changeover
Expenses – costs grouped into your country’s categories and tax year
Day Count – nights let, available and personal use against your country’s test
Properties and Platforms – your homes, cleaning defaults and platform fee rates
Settings – country, editable rules, theme
Start Here – a plain-English guide built into the workbook

Format

Instant digital download – works in Microsoft Excel, Google Sheets and LibreOffice, on Mac, PC, Chromebook or tablet. No macros, no add-ons, no subscription.

How It Works

Purchase and download the files
Open in Excel, or upload to Google Drive and open with Google Sheets
Pick your country on the Settings tab – wording, currency and rules switch to match
Add your properties and log each booking – everything else updates itself

Please Note

This is a digital product – no physical item will be shipped or posted. Day-count and tax results are estimates to help you keep records, not tax advice. Rules are shown “as of 29 Oct 2026 – check before relying on this” and can be edited in the sheet. For personal/business use only, please don’t resell or share the file.

Questions before you buy? Email hello@spreadsheetland.com – happy to help!

vacation rental spreadsheet

Holiday Let Command Centre — Bookings, Occupancy, Platform Fees & Day Count Spreadsheet (International)