Image 1 of 3
Image 2 of 3
Image 3 of 3
Holiday Let Income & Expense Tracker
Twelve months, night by night. What a holiday let actually earns.
EACH MONTH, YOU ENTER
• Nights available and nights booked
• Gross income
• Platform fees
• Cleaning and laundry
• Other costs
IT WORKS OUT, MONTH BY MONTH
• Occupancy rate
• Net income
PLUS YOUR ANNUAL FIXED COSTS
Mortgage interest, insurance, utilities and broadband, council tax or
business rates, maintenance, licensing and compliance, accountancy.
THE DASHBOARD GIVES YOU
• Gross booking income for the year
• Nights booked versus available, and your occupancy rate
• Average nightly rate (ADR)
• Booking costs, and net booking income
• Total fixed costs
• PROFIT for the year
• Revenue per available night (RevPAN)
RevPAN is the number that tells you the truth. A high nightly rate with poor
occupancy loses to a modest rate that's always full.
Note: the Furnished Holiday Lettings regime was abolished in April 2025.
Holiday lets no longer get the old tax treatment — this tracker records what
you earn and spend, and doesn't assume FHL reliefs that no longer exist.
Excel (.xlsx). Works in Microsoft Excel and Google Sheets. Instant download.
Educational tool only. Not financial or tax advice. Correct as of July 2026.
Twelve months, night by night. What a holiday let actually earns.
EACH MONTH, YOU ENTER
• Nights available and nights booked
• Gross income
• Platform fees
• Cleaning and laundry
• Other costs
IT WORKS OUT, MONTH BY MONTH
• Occupancy rate
• Net income
PLUS YOUR ANNUAL FIXED COSTS
Mortgage interest, insurance, utilities and broadband, council tax or
business rates, maintenance, licensing and compliance, accountancy.
THE DASHBOARD GIVES YOU
• Gross booking income for the year
• Nights booked versus available, and your occupancy rate
• Average nightly rate (ADR)
• Booking costs, and net booking income
• Total fixed costs
• PROFIT for the year
• Revenue per available night (RevPAN)
RevPAN is the number that tells you the truth. A high nightly rate with poor
occupancy loses to a modest rate that's always full.
Note: the Furnished Holiday Lettings regime was abolished in April 2025.
Holiday lets no longer get the old tax treatment — this tracker records what
you earn and spend, and doesn't assume FHL reliefs that no longer exist.
Excel (.xlsx). Works in Microsoft Excel and Google Sheets. Instant download.
Educational tool only. Not financial or tax advice. Correct as of July 2026.

