Hotel Operations: Reservations to Folio Billing

A guest checks out at seven in the morning and the front desk needs to produce one number. Getting to that number means the reservation, the room actually occupied, the nights charged and whatever was signed for at the restaurant all have to agree. In many small properties those four things live in four different places — a booking notebook, a whiteboard behind the desk, a spike of chits and a spreadsheet on the manager's laptop — and the reconciliation happens in the lobby while the guest waits. That gap is where hospitality operations quietly lose money and goodwill.

Where hotel records drift apart

The drift almost never starts with a big mistake. It starts with a phone booking written on a notepad because the person answering was not at the desk, a room swap granted at midnight because a shower was not draining, a late checkout approved verbally by a supervisor who then went off shift. Each one is reasonable on its own. None of them updates the record everyone else is reading.

By morning the whiteboard says one thing and the folder of registration cards says another. The housekeeping list was printed before the swap. The restaurant chit has a room number that was correct at dinner and wrong by breakfast. Nobody was careless; the information simply had no single place to land.

The fix is not more forms. It is having one record per room and one record per stay, updated at the moment the thing happens, by the person it happens to. That is the whole design idea behind the Hotel Management module in ERPat: rooms, reservations, check-in and check-out, and folio billing kept as one connected chain rather than four parallel logs.

Rooms and rates are the base record

Everything downstream depends on the room list being honest. A room that exists in the system but has been out of service since the ceiling leak is a room that will get sold. A rate that was agreed for a corporate account last quarter but never written down anywhere is a rate the front desk will have to guess at, usually in the guest's favour and always in an argument.

So the first setup task is unglamorous and worth doing carefully. List the rooms as they actually are — type, capacity, floor, and the current status of each. Record the rates you actually sell, including the ones you only sell sometimes. If your walk-in rate differs from your corporate rate, that is two entries, not one entry and a habit.

Once the room inventory is real, availability stops being a question someone has to answer from memory. It becomes something the system can answer the same way at three in the afternoon and three in the morning, whoever is on duty.

A reservation should hold something real

A booking is a promise, and the value of recording it in software is that the promise is attached to inventory. When a reservation is taken against a room type for specific dates, that capacity is committed. The next person who checks availability sees what is left, not what was left before the last phone call.

This is the point at which most double-bookings disappear, and they disappear for a boring reason: there is no longer a window between the booking being agreed and the booking being visible. The front desk, the manager reviewing tomorrow's arrivals and whoever is answering messages are all reading the same list.

It also gives you an arrivals view that is worth something operationally. Knowing who is expected, in which room type, for how many nights, lets housekeeping sequence the day and lets the desk prepare registration ahead of the rush instead of during it. The reservation stops being a note to be honoured and becomes the first entry in the guest's record.

Check-in and check-out are ledger events

Treat arrival and departure as transactions, not as a courtesy exchange at the counter. At check-in, the reservation converts into an occupied room, the folio opens, and the room is no longer available to anyone. At check-out, the folio closes, the room returns to inventory for housekeeping, and the stay becomes a settled record rather than an open question.

Recording them at the moment they happen is what keeps the rest of the system truthful. A room that was vacated at six but only marked at noon is a room you could not sell for six hours and a housekeeping assignment that went out late. A guest checked in mentally but not in the system is a guest whose restaurant charge has nowhere to go.

The discipline sounds obvious and is the single most common place small properties let things slip, usually during the busiest hour of the day — which is exactly the hour when the cost of slipping is highest.

The folio is the guest's whole story

The folio is the running account for a stay: room nights as they accrue, plus everything else the guest signs for, in one place, in order. Its job is to be complete and to be complete continuously, not assembled at the end from whatever paperwork can be found.

That continuity is what makes checkout fast. If every charge landed on the folio when it was incurred, the departure conversation is a review and a settlement. If charges are collected at the end, checkout becomes an investigation, and investigations in a hotel lobby at seven in the morning are settled by discounting whatever cannot be proven.

Charges from the outlets, recorded once

Most hotels are also small food and beverage businesses, and the counter is where a second set of books usually appears. A sale at the restaurant or the sundry counter is simultaneously revenue, stock leaving the store, and — if it was charged to a room — part of a guest's account. Handled as three separate entries, it will be wrong in at least one of them by month-end.

The Point of Sale module exists to collapse that. A counter transaction is recorded once, and it posts straight to inventory and to the ledger, so the stock movement and the accounting entry are not two people's separate jobs. On a single platform, the outlet's takings and the property's books are not two versions of the same day to be reconciled later.

Practically, that means your beverage variance stops being a mystery and your revenue by outlet stops being a spreadsheet exercise. It also means the billing documentation your accountant and the BIR expect comes out of the same records the front desk was using all along.

Where to start

If you are running a property on paper today, do not attempt the whole chain in one weekend. Get the room and rate list right first, because everything else inherits its errors. Then move reservations in, so availability has one answer. Then move check-in and check-out, which is where the habit matters most. Folio billing and the outlets follow naturally once the stay itself is a real record.

The goal is not a more elaborate system. It is a checkout where the number on the folio is the number everyone already expected, and the room is back in inventory before the guest reaches the car.