← All prebuilt solutions
Property

Holiday Let Tracker

Bookings, occupancy, channels, profit and tax for up to 10 holiday lets

£20
Buy nowAsk a question

Secure checkout. Your download link is sent as soon as payment clears.

Holiday Let Tracker

Overview

Running holiday lets means juggling bookings from several websites, deposits and balances, changeovers, owner stays, VAT, business rates and – since April 2025 – a very different tax position. This workbook brings it all together. You log each booking, cost, clean and owner stay once, and it works out occupancy, average nightly rate (ADR), revenue per available night (RevPAR), what every booking channel really costs you, profit property by property, whether each property passes the business-rates test, how close you are to the VAT threshold, and an estimate of the income tax on your share of the profit.

Price
£20
Who it’s for
Property
Works with
Microsoft Excel for Windows and Mac
Buy now

See how it works

A walk through the main sheets

The sheets you will use most, in the order you will use them – shown with the sample data every workbook comes with.

Step 1

Properties

Up to 10 lets with ID H1–H10, ownership share, values, mortgage and rates status. What you do: one row per property.

Properties
Bookings

Step 2

Bookings

Every stay, with calculated value, commission, fees, VAT, net to you, balance, due date and check. What you do: one line per booking.

Step 3

Expenses

Running costs, repairs, mortgage interest, replacements and capital spending. What you do: one line per payment.

Expenses
Cleaning

Step 4

Cleaning

Changeovers, mid-stay and deep cleans with labour, laundry and supplies. What you do: one line per clean.

Who it is for

Made for people like you

  • Example – text
  • Owners of 1–10 holiday cottages, flats, lodges or huts – Occupancy, ADR, RevPAR and profit for each property and for the portfolio.
  • Owners using Airbnb, Booking.com, Vrbo, an agency and direct bookings – Commission and payment fees worked out automatically, and a side-by-side comparison of each channel.
  • Couples and joint owners – Enter everything in full once – your ownership share is applied in the tax estimate.
  • Former FHL owners – A tax estimate that follows the post-April 2025 rules: 20% mortgage interest credit, replacement of domestic items relief and the 2027/28 property rates.
  • WATCH OUT – This workbook doesn't cover holiday lets owned through a limited company (corporation tax), overseas property, non-resident landlords, capital gains on a sale or serviced accommodation run as a trade (e.g. a B&B with substantial services). It prepares figures – it doesn't file anything with HMRC.

Quick start

Up and running in minutes

  1. Example – text
  1. Settings – Enter your name, trading name and tax year. Leave the report date blank so it uses today. Choose cash basis or accruals, enter your other income and the PAYE tax already paid on it, and anything brought forward (losses, mortgage interest, the old FHL capital allowances pool). If you're VAT registered, enter the date.
  2. Booking channels – Check the commission %, payment fee % and balance due days for each channel against your own statements – these are used whenever a booking leaves commission or fees blank.
  3. Properties – One row per property: name, area, nation (England, Wales or Scotland), bedrooms, sleeps, YOUR share, the date it was first let if it's new, purchase price, value, mortgage, what you're billed now (business rates or council tax) and whether it counts towards your VAT turnover.
  4. Bookings – One line per stay. Enter the property ID, guest, channel, arrival date, nights, guests, rent and cleaning fee as the guest pays them. Add the deposit and the dates you actually received the deposit and the balance or payout.
  5. Expenses, Cleaning and Owner Use & Closures – Log every cost, every clean and every night a property isn't available to paying guests.
  6. Read the results – Start on the Dashboard, then Property Performance, Channels, Rates & VAT, Arrivals and the Tax Estimate. Fix any line whose Check column starts 'Check:'.

Key features

  • A bookings log for up to 2,000 stays with automatic commission, payment fees, VAT, balances due and a double-booking check.
  • Occupancy, ADR and RevPAR by property and by month, revenue by channel, and the true cost of every booking channel.
  • Profit by property with expenses in the SA105 categories, cleaning costs per changeover and your share of jointly owned lets.
  • Tax estimate under the post-April 2025 rules (FHL abolished), 2027/28 property rates, Scottish option, business rates vs council tax test and a VAT watch.

What’s included

  • Dashboard – Results at a glance
  • Settings – Tax year, channels, levy and test thresholds
  • Properties – Your lets and ownership share
  • Bookings – Every stay
  • Expenses – Running costs and purchases
  • Cleaning – Changeovers and laundry
  • Owner Use & Closures – Nights not available
  • Property Performance – Occupancy, ADR, RevPAR and profit
  • Monthly Figures – Month-by-month figures
  • Channels – Commission analysis
  • Rates & VAT – Business rates test and VAT watch
  • Arrivals – Upcoming guests and balances
  • Tax Estimate – Income tax on your share
  • Categories – Expense categories and SA105
  • Tax Rates – Rates and allowances
  • Guide – How to use this workbook

How buying works

Your file is only released once payment has cleared.

1

Click Buy now

You are taken to our secure checkout.

2

Pay securely

Checkout takes a minute and you get a receipt by email.

3

Download your file

Your download link arrives as soon as payment clears.

Explore the range

Trial Balance to Accounts Mapper

Trial Balance to Accounts Mapper

Turning a trial balance into statutory accounts means mapping every account to the right heading, posting year-end adjustments, and then building a profit and loss account, balance sheet and notes in the format the Companies Act requires – for this year and last year.

£20
View details →
Staff Appraisal & Performance Tracker

Staff Appraisal & Performance Tracker

Good appraisals are fair, consistent and joined up: objectives agreed at the start of the year, regular 1-to-1s, honest ratings against a clear competency framework, a calibration meeting so one manager's…

£20
View details →
Practice Timesheet & WIP

Practice Timesheet & WIP

An accountancy practice sells time, but most of its fees are fixed.

£20
View details →

Need it tailored to your business?

We can adapt any prebuilt solution or build something bespoke, with a lifetime bug-free guarantee.

Custom spreadsheetsTalk to us

Part of AML Finance Group

Need an accountant too?

Our sister firm, AML Accountancy Solutions, is an award-winning accountancy practice helping businesses and individuals across the UK with their accounts, tax, bookkeeping and payroll.

Visit AML Accountancy Solutions
AccountsTax compliance and planningBookkeeping and VATPayroll and CISCloud accounting softwareBusiness growth and planning

Get In Touch

We're open Monday to Friday, 9am – 5pm. Call our Plymouth office on 01752 42 72 82 or send us a message below, whether it's about consultancy, spreadsheets or our document templates.

Services
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

Quick Links

Business ConsultancyCustom SpreadsheetsPrebuilt Spreadsheet SolutionsBusiness Document TemplatesAbout UsTestimonialsInsightsFAQsContactAccountancy – AML Accountancy Solutions

Company information

Offices
Plymouth
First Floor, Unit D2, 4 Neptune Park, Plymouth, PL4 0SJ
Phone Number
01752 42 72 82
Email
info@amlconsultancysolutions.co.uk
Opening hours
Monday to Friday: 9:00 am to 5:00 pm

Legal

Privacy PolicyCookies PolicyDisclaimer PolicyTerms and ConditionsComplaints ProcedureAccessibility Statement

AML CONSULTANCY SOLUTIONS LTD
Registered Address: First Floor, Unit D2, 4 Neptune Park, Plymouth, United Kingdom, PL4 0SJ. Company Number: 12747461