Hotel Reports for Independents: The Five to Open on a Monday Morning

A small hotel or B&B needs five reports, not fifty: last week against the same week last year, what's on the books for the next six weeks, what picked up since last Monday, where those bookings came from, and who's arriving owing money. Twenty minutes, in that order — and if a report doesn't end in a decision, close it.

Every property management system ships with a reports menu long enough to lose a morning in. Most of it was built for hotels with a revenue manager, a finance team and a night auditor. If you run twelve rooms and do the breakfasts yourself, the question isn't which reports exist. It's which ones change what you do this week.

This is the Monday routine we'd recommend to a 5–40 room independent, with a worked example on a 12-room hotel so you can see what each report actually looks like when it's telling you something.

The Monday five at a glance

And once a month, on the first Monday, a sixth: your rolling 12-month turnover against the VAT threshold. More on that at the end — it's the one most small places forget.

Report 1: Last week against the same week last year

Start with what happened. Occupancy, ADR and RevPAR for last week — Monday to Sunday — set against the same week last year, not the week before.

Week-on-week comparison is the most common reporting mistake at a small property. Last week and the week before sit in different parts of the season, sometimes either side of a half term, so the difference tells you about the calendar rather than about your hotel. The same week a year ago is the fair fight. (If you need a refresher on the three numbers themselves, our explainer on occupancy, ADR and RevPAR walks through each one.)

The worked example. Twelve rooms, seven nights, so 84 available room nights.

Occupancy is down 3.6 points, which looks like a bad week. It isn't. It's three room nights. ADR held £6 higher and RevPAR came out 57p ahead. The hotel sold fewer nights for more money and finished slightly better off.

The small-property trap. At 12 rooms, one room night is worth 1.2 points of weekly occupancy. At six rooms it's 2.4 points. Percentages that would mean something at a 150-room hotel are just rounding at yours. A useful rule of thumb: below about five room nights in either direction, a week's result is weather, not a trend. Note it, and move on.

Decision: almost always none. Report 1 is there to stop you reacting to noise, which is why it goes first.

Report 2: What's on the books for the next six weeks

This is the report that actually changes things. "On the books" means room nights already booked for future dates. Pull it by stay week for the next six weeks, and put last year's figure next to it as it stood on the same day last year — not last year's final result.

That distinction matters. Comparing what you've booked so far against what last year finished on will make every future week look like a disaster. The comparison you want is like-for-like: your position today against your position a year ago today. That gap is your pace.

Why six weeks? Across independent properties, the average booking is made about 40 days before arrival, and closer to 47 in Europe (Cloudbeds, 2026 State of Independent Hotels). Six weeks catches the window where most of your bookings are still arriving and there's still time to do something about a gap. Further out is mostly empty for everyone; closer in, it's too late to move much.

Report 3: Pickup since last Monday

Pace tells you where you stand. Pickup tells you how fast you're moving: room nights booked in the last seven days, split by the week they're for. HSMAI defines pickup simply as the bookings made since the last report. Put reports 2 and 3 side by side and they read as one table.

Six weeks, and only one of them needs you. Read each week against this grid:

• Week +3 is behind by six room nights and barely moving. That's the one. Before you touch the rate, check why: was there an event in that week last year that isn't on this year? A closeout or minimum stay you forgot to lift? Are you showing on every channel? If the answer is simply softer demand, then a targeted offer for those dates, or relaxing a two-night minimum, is a better first move than dropping the rate across the week. (Our seasonal pricing guide explains why minimum stays are a self-imposed tax on any date that didn't sell out last year.)

• Week +5 is behind too, but it picked up six nights in a week. It's catching up. Leave it alone and look again next Monday.

• Week +6 is four nights ahead with steady pickup. That's permission to hold your rate, or test a small increase on the busiest nights.

That's the whole method: one week to act on, one to leave, one to lean into. You don't need a revenue management system to do it, and under about 20 rooms we'd argue you shouldn't start with one — your booking data is too thin for an algorithm to see much that this table doesn't.

If your system can't show "same point last year". Plenty of small-hotel software can't, because it only stores bookings, not a record of what was on the books on a given date. The fix is low-tech: every Monday, write the six on-the-books figures into a spreadsheet with the date. It takes two minutes. A year from now you'll have your own pace history, which is worth more than any national benchmark.

Report 4: Where last week's bookings came from, and what they cost

Last week the hotel picked up 42 room nights. Where they came from decides how much of that money you keep. (The direct vs OTA commission post has the full arithmetic; this is the Monday version.)

£602 went on distribution for one week's bookings. Direct was 28.6% of room nights.

Two things to watch here, and one not to:

• Direct share as a four-week rolling figure, not a weekly one. One week of 12 direct nights is too small to read. Four weeks averaged will show you whether a change you made — a better booking button, a rate that's genuinely cheaper direct, a welcome offer — is working.

• Cancellations, by channel. Across independents, OTA bookings cancel at roughly twice the rate of direct ones: 21.8% against 10.6% (Cloudbeds, 2026). That means an OTA-heavy week on the books is softer than it looks. If week +3's 41 nights were 30 OTA and 11 direct, and your cancellations ran at those averages, you'd end up nearer 33 nights — 39.6% occupancy, not 48.8%. Treat that as an upper bound on the damage rather than a forecast, because some of those bookings have already survived part of their cancellation window. But it's another reason week +3 is the one to work on. Better still, track your own cancellation rate by channel; after a few months it'll be a far better haircut than any average.

• Don't react to one channel having a quiet week. OTA volume moves with their own promotions and ranking changes. Delisting because of one week is how you lose the next month.

Report 5: Who's arriving this week, and what they owe

The last report is operational rather than strategic, and it saves the most awkward conversations. Pull every arrival for the next seven days and look for three things:

1. An unpaid balance or missing deposit. Chase it now, by message, rather than at the desk on a Friday night.

2. OTA bookings where you haven't yet taken payment from a virtual card or confirmed how the guest is paying. Better to find a declined card on Monday than at checkout.

3. Anything you need to prepare: a late arrival, a cot, a dietary note, a guest who hasn't had a pre-arrival message.

Three minutes, and the week's check-ins run themselves.

First Monday of the month: the VAT check

If you're a 12-room hotel, you're almost certainly VAT-registered already and can skip this. If you're a smaller B&B or guest house trading under the threshold, this is the most important number you're probably not watching.

You must register for VAT when your taxable turnover over the last 12 months goes above £90,000 — a rolling test, checked every month, not your financial year. Breakfast included in the room price counts, and so do dinner, bar and anything else you sell. You then have 30 days from the end of that month to register, and you're VAT-registered from the first day of the second month after you went over (GOV.UK). There's also a forward-look test: if you expect to go over £90,000 in the next 30 days alone, you register straight away — rarely a live issue for a small B&B.

Here's the part that makes it a Monday report rather than a job for your accountant in March. Each month, your rolling total drops the same month last year and adds this month. So you cross the threshold in the month you beat the same month last year by more than your headroom.

Take a five-room B&B whose last 12 months come to £86,900 in rooms and £1,350 in dinners and extras — £88,250 in all. The headroom is £1,750. At £95 a night, that's about 18 room nights. If September beats last September by more than that, September is the month you crossed.

Our seasonal pricing guide shows why this matters: just over the line, a B&B can take more money and keep less of it. If you're within a few thousand pounds, talk to your accountant before the month you cross, not after. This isn't tax advice — it's the reason to look.

The reports you can close

Some reports are worth having and not worth opening every Monday:

• Daily rate shopping against competitors. Look before you set a season, not every week. Small properties that follow the comp set end up priced at the local average.

• Profit reports (GOPPAR and the like). Monthly, with your bookkeeper, once costs are in.

• Market segment and forecast accuracy reports. Built for properties with a sales team. At 12 rooms, the pickup table above is your forecast.

• Housekeeping and night audit reports. Daily operational tools, not Monday decisions.

What to do this Monday

1. Pull last week against the same week last year. If the difference is under five room nights, note it and move on.

2. Pull on-the-books by stay week for the next six weeks.

3. Add last year's on-the-books figure for the same date — or, if your system can't, start the Monday spreadsheet today.

4. Add pickup since last Monday, and mark each week on the ahead/behind, fast/slow grid.

5. Pick at most one week to act on. Check events, restrictions and channel visibility before you touch the rate.

6. Check where last week's bookings came from, and update your four-week direct share.

7. Go through this week's arrivals for balances, payment and anything to prepare.

8. If it's the first Monday of the month and you're under the VAT threshold, work out your headroom.

FAQ

What reports should a small hotel look at every week?

Five: last week's occupancy, ADR and RevPAR against the same week last year; room nights on the books for the next six weeks; pickup since the previous week; where last week's bookings came from and what they cost; and arrivals with balances due. Together they take about twenty minutes.

What's the difference between pickup and pace?

Pickup is how many room nights you've booked for a given week since your last check — it measures speed. Pace compares what's on the books now with what was on the books at the same point last year — it measures position. A week that's behind on pace but picking up fast is catching up; a week that's behind and slow needs action.

What does "on the books" mean in a hotel?

Room nights already booked for future dates, usually counted by stay night or stay week. It's the starting point for any forward-looking report, and it's more useful compared with the same date last year than with last year's final figure.

Should I compare this week with last week or with last year?

With the same week last year. Consecutive weeks sit in different parts of the season and often either side of a school holiday, so week-on-week changes mostly reflect the calendar. The same week a year earlier is the fair comparison.

My PMS doesn't show last year's on-the-books figures. What can I do?

Record them yourself. Each Monday, write down the on-the-books room nights for the next six weeks in a spreadsheet with the date. After a year you'll have your own pace history — more relevant to your property than any national average.

Do I need a revenue management system to do this?

Not under about 20 rooms. A small property's booking data is too thin for pricing software to see much that the pickup table above doesn't, and it tends to pull your rate toward the local average. A twenty-minute Monday routine gets you most of the benefit for none of the cost.

Monday shouldn't start with hunting for the numbers. In Stayvieo, occupancy, ADR and RevPAR are live for every property, and reports and insights are included on every plan — so the first report on this list is already waiting when you sit down. See how it works.