Hotel Reservation Management

Run front-desk bookings for a small hotel: rooms and rates, reservations with nights and totals, payment status and occupancy.

Sign in with your Edesy account, then click Use template in the preview to copy the base, with its sample rows, into your workspace.

Category

Lists

Tables

Rooms, Reservations

Fields

24

Views

grid, kanban, cards, timeline, calendar, form, dashboard

Tables, columns and sample rows

The 2 linked tables in this template, with their real columns, field types and sample rows. Copy the template to edit them in Edesy Tables.

Rooms

9 fields · 5 sample rows

  • Rooms (Grid)
  • Housekeeping (Kanban)
  • Room cards (Cards)
RoomTextRoom TypeSingle selectRate per NightCurrencyMax GuestsNumberHousekeepingSingle selectReservationsLink to another tableBookingsCountRevenueRollupPhotoAttachment
101Standard₹3,5002OccupiedAnil Kapoor1₹10,500
102Standard₹3,5002ReadyOlivia Brown1₹10,500
201Deluxe₹5,2003CleaningEmma Schultz1₹15,600
202Family₹6,5004ReadyRamesh Pillai1₹13,000
301Suite₹9,8002MaintenanceHarpreet Kaur1₹19,600
Field details
Room · Text
Room Type · Single select
Standard, Deluxe, Suite, Family
Rate per Night · Currency
INR
Max Guests · Number
Housekeeping · Single select
Ready, Occupied, Cleaning, Maintenance
Reservations · Link to another table
Links to Reservations
Bookings · Count
Revenue · Rollup
sum of Total via Reservations
Photo · Attachment

Reservations

15 fields · 5 sample rows

  • Reservations (Grid)
  • Front desk (Kanban)
  • Occupancy (Timeline)
  • Calendar (Calendar)
  • Book a room (Form)
  • Revenue (Dashboard)
GuestTextBooking #AutonumberEmailEmailPhonePhoneRoomLink to another tableCheck-inDateCheck-outDateGuestsNumberNightsFormulaNightly RateRollupTotalFormulaSourceSingle selectStatusSingle selectPaymentSingle selectSpecial RequestsLong text
Anil KapoorBK-0001[email protected]+91 98765 4321010118 Nov 202621 Nov 202623₹3,500₹10,500DirectChecked inDeposit
Emma SchultzBK-0002[email protected]20120 Nov 202623 Nov 202623₹5,200₹15,600Booking.comBookedPaidLate check-in around 11 pm.
Ramesh PillaiBK-0003+91 94470 1122320224 Nov 202626 Nov 202642₹6,500₹13,000MakeMyTripBookedUnpaidExtra mattress for child.
Olivia BrownBK-0004[email protected]10213 Nov 202616 Nov 202613₹3,500₹10,500ExpediaChecked outPaid
Harpreet KaurBK-0005+91 98140 9988730129 Nov 20261 Dec 202622₹9,800₹19,600DirectCancelledRefunded
Field details
Guest · Text
Booking # · Autonumber
Email · Email
Phone · Phone
Room · Link to another table
Links to Rooms
Check-in · Date
Check-out · Date
Guests · Number
Nights · Formula
IF(AND({Check-in}, {Check-out}), DATETIME_DIFF({Check-out}, {Check-in}, 'days'), BLANK())
Nightly Rate · Rollup
sum of Rate per Night via Room
Total · Formula
IF({Nights}, {Nights} * {Nightly Rate}, 0)
Source · Single select
Direct, Booking.com, MakeMyTrip, Expedia, Walk-in
Status · Single select
Booked, Checked in, Checked out, Cancelled, No-show
Payment · Single select
Unpaid, Deposit, Paid, Refunded
Special Requests · Long text

Form view “Book a room” asks for: Guest, Email, Phone, Check-in, Check-out, Guests, Special Requests.

Hotel Reservation Management: questions

Yes. Copy the template, then import a .csv, .tsv or .xlsx file into any of its tables and map the columns. Delete the sample rows first if you do not need them.

Yes. An automation runs when a record is created, updated or matches a filter, when a form is submitted, on a schedule or when a date arrives, and can update or create records, call a webhook or post to a connected Slack channel.

Related templates