Free tool
Homestay Excel template: bookings, calendar, revenue
Free homestay Excel template: a bookings log, monthly room calendar, revenue, expenses and occupancy. Works in Excel and Google Sheets.
Free, no sign-up. Opens in Excel or Google Sheets; if Excel opens it in Protected View, click Enable Editing so the formulas run.
What is inside
- BookingsOne booking per row: guest, phone, check-in and check-out, room type from a list, total, deposit, note.
- RoomsYour rooms with their nightly rate; the calendar and occupancy read from here.
- CalendarA rooms × days grid for one month that colours booked nights and turns red when two bookings overlap.
- RevenueTwelve months of a year: bookings, total booked, deposits, still to collect, nights sold, occupancy and profit.
- ExpensesLog each cost by category (electricity, water, laundry, OTA commission…) and see the total for each month.
- GuideHow to use the file in a few minutes, and how to import it into HostBooking when you need to.
This file imports straight into HostBooking: when you want a calendar that syncs with Airbnb, Booking.com and Agoda, upload the Bookings sheet instead of retyping it.
How to use it
- Download the English or Vietnamese file and open it in Excel, or upload it to Google Sheets (File → Import).
- On Rooms, list your rooms. On Bookings, delete the 3 sample guests and add one booking per row: dates as dd/mm/yyyy, money as plain numbers.
- The Calendar sheet colours booked nights and turns red on a double booking. The Revenue sheet adds up bookings, deposits, nights and occupancy by month.
- Log expenses on the Expenses sheet to see each month's profit. When you move to software, this file imports straight into HostBooking.
Frequently asked questions
Is Excel enough to run a homestay?
With 1–5 rooms and few sales channels, one workbook holding bookings, the calendar and money in and out works. Selling on several OTAs at once, Excel cannot block rooms by itself, so double bookings creep in; that is when software with calendar sync pays off.
Does the file work in Google Sheets?
Yes. The formulas use only COUNTIFS, SUMIFS, SUMPRODUCT and EDATE, which run in Excel 2010 or later and in Google Sheets. Upload the file to Google Drive and open it with Google Sheets.
How is occupancy calculated in the file?
Nights sold in the month divided by rooms times days in the month. Rooms are counted from the Rooms sheet; a stay across two months has its nights split between them.
Can I move this data into HostBooking?
Yes. In the HostBooking admin, go to Bookings → Import bookings from a file and upload it. Columns are matched by their headings; bookings from today on are created and hold their rooms.