Hotel & Homestay Booking System

The problem

Bookings get lost when they live in messages and separate calendars. This template is a manual booking log: you type in each stay, with the guest, dates, room, charges, and payment status, in one Notion workspace.

Who it's for

Owners of small hotels, homestays and guesthouses.

What's inside

• Pages: Dashboard, Calendar, Rooms, Housekeeping, Guest List, Guest Policy, Sales, and Payment.
• Bookings database (named Calendar): Guest Name, In & Out Date (one date range), Rooms, No. of Pax, Breakfast (yes or no), Phone, Email, Booking Status (Inquiry, Booked, Checked In, No Show, Checked Out, Cancelled), Charges, Discount, Sub Total, Total Amount, Total Nights, Weekday Nights, Weekend Nights, Weekday Rate, Weekend Rate, Deposit Collection (Pending, Collected, Not Required, Refunded), Payment Status (Pending, Partially Paid, Fully Paid), Room Cleaned, Last Cleaned Date, and a button named Mark as Cleaned.
• Rooms database: Room Name, Room Type (Small, Medium, Large), Weekday Rate, Weekend Rate.
• Dashboard views: Check-in, Check-out, Guests Arriving, Rooms Pending Cleaning, Guest Present, Occupied Rooms Overview.
• Calendar is a month calendar. Rooms has four per-room calendars. Housekeeping has a board and tables. Guest List (All Customers) is a view of Bookings. Sales has 1 chart of fully paid revenue by month and sales-by-room tables. Payment has Pending Payment and a deposit board.
• Guest Policy is a sample house-rules page.
• Buttons, by name: Mark as Cleaned, and a button on the Calendar page.

Screenshots

Questions

What is this?

A manual booking log for small hotels, homestays and guesthouses. You duplicate it into your own Notion workspace and type each booking in by hand.

What is inside?

Pages for Dashboard, Calendar, Rooms, Housekeeping, Guest List, Guest Policy, Sales, and Payment. Two databases: Bookings (the database is named Calendar) and Rooms. Guest List is a view of Bookings, not a separate guest database.

What does it cost?

It costs $24.

Does it include automations or integrations?

It has 7 formulas (nights, subtotal, total, and rate text), rate rollups, 1 chart, a button named Mark as Cleaned, and a button on the Calendar page. It does not include a percent-full figure for the rooms. It does not check whether two bookings use the same room. Statuses are set by hand. It does not sync a channel or calendar, take payment online, or send email.

Is there a separate guest database?

No. Each booking row holds the guest's details, and Guest List is a view of Bookings.

How is the price worked out?

Weekday Rate and Weekend Rate live on the room. The booking has Charges, Discount, and formula fields named Sub Total, Total Amount, Total Nights, Weekday Nights, and Weekend Nights. The formula code is not listed here.

How do I start?

Duplicate it, then delete all demo records in Guest List before you start.

Does it work on Notion's Free plan?

Yes. The one chart shows only if your workspace has not already used its free chart.