Night Audit and Handover Sheet
One page that shows the house was counted, the money balanced and the building walked. The morning shift gets what it needs on the same sheet.
HG-17 1 page
Hotels and guest accommodation · HG-18
Occupancy and Rate Record
A free printable hotel occupancy sheet — one row per night with rooms let, guests, room revenue, occupancy and average rate worked out by hand.
Download Free · no sign-up
One page. Choose your paper size — both versions are laid out identically, so neither one gets shrunk to fit.
Print it and write on it
Fill it in type and save
The fillable versions have real form fields — open them in any PDF reader, type into them and save. Printing help.
What this sheet is for
See which nights and which rates worked without waiting for a monthly report. The figures sit side by side where you can read them.
Who it is for
Owners and managers of small hotels, guest houses and bed and breakfasts who keep their own numbers.
How to use it
- Write in the number of rooms available once at the top; print two pages a month.
- At the end of each night record rooms let, off sale, guests and room revenue.
- Divide rooms let by rooms available for occupancy, and revenue by rooms let for the average rate.
- Note walk-ins, no-shows and anything that explains a good or bad night.
- Total the page at the bottom and mark the best and worst nights.
What is on the sheet
One page, top to bottom:
Printed under the title: Half a month of nights on one page — rooms let, guests, room revenue and the two figures a small hotel actually watches, occupancy and average rate, worked out by hand each night. Neither is a target: the sheet shows what happened, against your own expectations.
Write-on lines: Property · Month · First or second half · Rooms available · Kept by
Nightly record — one row per night; two pages make a month
Table, 16 rows: Date · Day · Rooms let · Off sale · Guests · Room revenue · Occupancy · Average rate · Walk-ins · No-shows · Notes
Write-on lines: This page: room nights · Room revenue · Occupancy · Average rate · Best night · Worst night
Questions
Why is there no target occupancy on the sheet?
Because a target is yours, and it changes with the season and the house. The sheet shows what happened each night so you can compare it against your own expectations, not against a figure somebody else printed.
Why half a month per page?
Because a row you can actually write in takes more room than thirty-one of them will allow on one sheet. Two pages side by side make the month, and the totals at the foot of each page add up to it.
Related sheets
Minibar and Room Stock Sheet
Get minibar charges onto the bill before the guest is at the desk. The fridges stay stocked and in date without a second visit.
HG-16 1 page
Daily Takings and Cash Reconciliation
Cash up consistently and record the difference every day, which is how a problem gets noticed in a week rather than in an audit.
IM-08 1 page
Holiday Let Guest Register
Keep a simple register of who stayed and when, in a form you can produce if somebody asks for it.
RP-05 1 page
