How to Track Room Availability When Bookings Come From Everywhere

A practical system for tracking room availability across walk-ins, Messenger, and OTAs: one master calendar, clear booking statuses, and a 5-minute nightly check.

How to Track Room Availability When Bookings Come From Everywhere

A message comes in on your Facebook page at 9 p.m.:

"Hi po, available pa po ba ang 2 rooms this Saturday to Monday? 4 pax."

You think Room 2 and Room 5 are free. Probably. Room 5 had a pending Messenger guest who never sent the deposit. Did your sister take a walk-in for Saturday? And you haven't opened the Agoda extranet since lunch.

If answering that question means checking four places and still guessing, your problem isn't the guest or the OTA. It's that your property doesn't have one answer to "what's available?"

This guide covers the system, not the software. It works with a notebook, a spreadsheet, or a PMS.

Rule 1: Pick one master calendar, and make it the only truth

Every small property gets bookings from several places: walk-ins, Messenger, phone calls, repeat guests texting you directly, and one to three OTAs. Each OTA keeps its own calendar. Messenger keeps a conversation, not a calendar. Your memory keeps whatever it feels like keeping.

You need one place where every booking ends up, no matter where it came from. That's your master calendar. Everything else (Booking.com, Agoda, the whiteboard) is a copy of it.

It can be:

  • a paper calendar grid on the wall (rooms down the side, dates across)
  • a spreadsheet (here's a free hotel booking spreadsheet template with a double-booking check)
  • a property management system (PMS)

The tool matters less than the rule: if it's not on the master calendar, it's not booked. Say it out loud to your staff and family. If your tita takes a booking over the phone and only tells you about it at dinner, it doesn't exist yet.

Rule 2: Log it before you confirm it

The order of operations matters more than people think.

The wrong order:

  1. Guest asks on Messenger
  2. You say "Yes po, available!"
  3. You'll write it down later

The right order:

  1. Guest asks
  2. You check the master calendar
  3. You put a hold on the room in the master calendar
  4. Then you reply "Yes po, available"

The gap between "yes" and "I'll write it down later" is where double bookings come from. On a quiet weekday the gap doesn't hurt. On a long weekend, when three people ask about the same room in one hour, it does.

Rule 3: Track the room, not just the count

"We have 2 rooms left on Saturday" is not availability tracking. "Room 2 and Room 5 are free on Saturday" is.

Count-based tracking breaks the moment your rooms aren't identical. A family of four can't use your two remaining double rooms if one has a broken aircon. A guest who booked the sea-view room on Booking.com will notice if you put them in the garden room. Track by room number, always.

Rule 4: Give every booking a clear status

Most availability confusion comes from bookings that are "sort of" booked. Give each one a status and agree on what each means:

StatusRoom blocked?What it means
InquiryNoGuest asked. Nothing promised. Don't write it on the calendar.
Hold / pending depositYes, with a deadlineYou've promised the room if they pay by a set time (e.g. 24 hours).
ConfirmedYesDeposit received or OTA booking confirmed.
Checked inYesGuest is in the room.
Cancelled / no-showNoRelease the room right away on the master calendar and every OTA.
Out of orderYesRepairs, deep cleaning, family using the room.

The hold with a deadline is the important one for Philippine properties. Messenger guests often say "sige po, I'll send the GCash later" and then disappear. If you block the room forever, you lose real bookings. If you don't block it, you might double-book when they come back. Set a deadline like "we'll hold the room until 6 p.m. tomorrow," write that deadline on the hold, and release the room when it passes.

Rule 5: Do a 5-minute close-out every night

Even with good habits, things slip in. OTA bookings arrive while you're busy. Cancellations come by email. Someone forgets to log a walk-in.

So every night, before you sleep, take five minutes:

  1. Open each OTA extranet or app. (Booking.com Pulse, Agoda YCS, Airbnb.) Check for new bookings, modifications and cancellations since this morning.
  2. Compare them against the master calendar. Anything missing goes in now.
  3. Check holds that have expired. Release the room and update the OTAs.
  4. Look at tomorrow: who's arriving, who's leaving, which rooms need cleaning.

It feels unnecessary on quiet nights. Do it anyway. The habit is what saves you in December.

Rule 6: Make availability readable by someone who isn't you

At a lot of family-run guesthouses, the owner is the only person who really knows what's booked. That works until you're sick, at a wedding in Manila, or just want one day off.

A good availability system passes the "could your staff answer it?" test: if a guest messages while you're away, could someone else open the master calendar and answer correctly in under a minute, without calling you?

If the answer is no, the system lives in your head, not on the calendar.

Choosing the right tool for your size

You don't need software just because you have rooms. Here's an honest guide:

Your situationWhat usually works
1–4 rooms, walk-ins and Messenger only, one person handling bookingsPaper calendar grid or a simple spreadsheet
3–10 rooms, one OTA plus Messenger, 2+ people taking bookingsShared spreadsheet or a free PMS
5–20 rooms, two or more OTAsA PMS for the master calendar, plus a plan for keeping the OTAs in sync
Two or more OTAs and you're updating extranets by hand several times a dayPMS + channel manager

If you're in that last row, see How to Manage Booking.com, Agoda, and Airbnb at the Same Time for the manual approach, and Channel Manager vs PMS for when it's worth paying for automation.

If most of your bookings come through Messenger, our guide on managing bookings from Facebook Messenger covers the conversation side: confirmations, deposits and follow-ups.

A quick test of your current system

Answer these without opening anything:

  • Which rooms are free next Saturday?
  • Which bookings this week still haven't paid their deposit?
  • When does your oldest unpaid hold expire?

If you had to guess on any of them, your availability is in more than one place. Fix that first, before you think about any tool.

Where GoOverbooked fits

GoOverbooked is a free PMS built for this exact problem at small Philippine properties. It started at a 9-room guesthouse in Bantayan that was juggling Booking.com, Agoda, walk-ins and a Messenger inbox. Every booking goes onto one room calendar, a booked room is blocked for those dates, and payments and balances sit on the same booking. Staff can have their own accounts, so the calendar doesn't live only on the owner's phone.

It won't fix a habit of saying "yes" before checking, but it makes the right habit faster to follow. If you want a master calendar without building one yourself, you can look around the demo. It has sample data and needs no signup.

Free to start

Run your hotel without the headaches.

Try the live demo in 30 seconds. No signup needed.

Try the demo →