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
Tables
Rooms, Reservations
Fields
24
Views
grid, kanban, cards, timeline, calendar, form, dashboard
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.
9 fields · 5 sample rows
| RoomText | Room TypeSingle select | Rate per NightCurrency | Max GuestsNumber | HousekeepingSingle select | ReservationsLink to another table | BookingsCount | RevenueRollup | PhotoAttachment |
|---|---|---|---|---|---|---|---|---|
| 101 | Standard | ₹3,500 | 2 | Occupied | Anil Kapoor | 1 | ₹10,500 | |
| 102 | Standard | ₹3,500 | 2 | Ready | Olivia Brown | 1 | ₹10,500 | |
| 201 | Deluxe | ₹5,200 | 3 | Cleaning | Emma Schultz | 1 | ₹15,600 | |
| 202 | Family | ₹6,500 | 4 | Ready | Ramesh Pillai | 1 | ₹13,000 | |
| 301 | Suite | ₹9,800 | 2 | Maintenance | Harpreet Kaur | 1 | ₹19,600 |
15 fields · 5 sample rows
| GuestText | Booking #Autonumber | EmailEmail | PhonePhone | RoomLink to another table | Check-inDate | Check-outDate | GuestsNumber | NightsFormula | Nightly RateRollup | TotalFormula | SourceSingle select | StatusSingle select | PaymentSingle select | Special RequestsLong text |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Anil Kapoor | BK-0001 | [email protected] | +91 98765 43210 | 101 | 18 Nov 2026 | 21 Nov 2026 | 2 | 3 | ₹3,500 | ₹10,500 | Direct | Checked in | Deposit | |
| Emma Schultz | BK-0002 | [email protected] | 201 | 20 Nov 2026 | 23 Nov 2026 | 2 | 3 | ₹5,200 | ₹15,600 | Booking.com | Booked | Paid | Late check-in around 11 pm. | |
| Ramesh Pillai | BK-0003 | +91 94470 11223 | 202 | 24 Nov 2026 | 26 Nov 2026 | 4 | 2 | ₹6,500 | ₹13,000 | MakeMyTrip | Booked | Unpaid | Extra mattress for child. | |
| Olivia Brown | BK-0004 | [email protected] | 102 | 13 Nov 2026 | 16 Nov 2026 | 1 | 3 | ₹3,500 | ₹10,500 | Expedia | Checked out | Paid | ||
| Harpreet Kaur | BK-0005 | +91 98140 99887 | 301 | 29 Nov 2026 | 1 Dec 2026 | 2 | 2 | ₹9,800 | ₹19,600 | Direct | Cancelled | Refunded |
Form view “Book a room” asks for: Guest, Email, Phone, Check-in, Check-out, Guests, Special Requests.
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.
A shared address book for family, friends and business contacts, with groups for cards, invites and mailings.
1 table · 11 fieldsBaseball Roster TemplateManage a baseball team roster with positions, batting stats and parent contacts, plus a game schedule with results.
2 tables · 22 fieldsBucket List TemplateCollect life goals and dream experiences, estimate what they cost, plan target dates and celebrate the ones you tick off.
1 table · 12 fieldsChristmas Card List TemplateTrack who gets a holiday card or gift this year, where to post it, what it costs, and whether they sent one back.
1 table · 14 fieldsEmail List TemplateGrow a clean, consent-backed email list with sign-up source, interests and engagement for every contact.
1 table · 12 fieldsEmail Subscription ListRun several newsletters from one place: subscribers opt into lists, and each list shows its live subscriber count.
2 tables · 16 fields