← All prebuilt solutions
Industry

B&B & Guest House Manager

Bookings by room and channel, occupancy, average daily rate, RevPAR, commission and double-booking checks

£20

Secure checkout. Your file is ready in your client portal as soon as payment clears.

B&B & Guest House Manager

Overview

Occupancy, average daily rate and RevPAR are the three numbers every hotelier watches. This workbook works them out from your bookings, and shows how much of your revenue goes to booking sites.

Price
£20
Who it’s for
Industry
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

Bookings

Every booking with room, dates, channel and price – with clash checks. What you do: one row per booking.

Bookings
Rooms & Channels

Step 2

Rooms & Channels

Your rooms and booking channels with commission rates. What you do: set up once.

Step 3

Monthly

Occupancy, ADR, RevPAR and commission by month. What you do: nothing to enter.

Monthly

Step 4

Who it is for

Made for people like you

  • Example – text
  • B&Bs and guest houses – See occupancy and income by room and month.
  • Small hotels and inns – Compare direct bookings with Booking.com and Airbnb after commission.
  • Owners planning their pricing – Use ADR and RevPAR to set rates for each season.

Quick start

Up and running in minutes

  1. Example – text
  1. Settings and Rooms – The year, VAT, card fees, your rooms and the commission each channel charges.
  2. Bookings – One line per booking with the room, dates, channel and total room price.
  3. Dashboard and Monthly – Occupancy, rates, revenue and commission.

Key features

  • A booking diary for every room – guest, dates, channel, price and extras – that flags double bookings, overfilled rooms and impossible dates.
  • Counts room nights in the month they are stayed to give occupancy, average daily rate and RevPAR each month and for the year.
  • Works out the commission and card fees on every booking and compares booking channels, so you can see what the online travel agents really cost.

What’s included

  • Dashboard – The year at a glance
  • Settings – Year, VAT and card fees
  • Rooms & Channels – Rooms and commission rates
  • Bookings – Every booking
  • Monthly – Occupancy, ADR, RevPAR
  • Guide – How to use this workbook

How buying works

Your file is only released to your client portal 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 file is ready in your client portal as soon as payment clears, and we email you your invoice with a link to the portal.

Explore the range

Need it tailored to your business?

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

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