Who has already paid? Tracking payments per booking without a spreadsheet

A booking is rarely paid in one go. A typical week looks like this: one guest paid a 30% deposit through a payment link back in May, a second booked through an OTA that collects the money itself, a third pays cash on arrival, and a fourth asks for an invoice and transfers the money two weeks after checkout. Four bookings, four completely different money flows.

With five bookings a month you keep that in your head. With thirty you no longer can. And then it starts: a guest who says at checkout that he "already paid", an outstanding amount you only discover in January while closing the year, or a second reminder sent to someone who did in fact pay.

The fix is not more discipline. It is a different way of recording.

"Paid" is not a yes or no

The core mistake is ticking a booking off as paid or unpaid. In a small accommodation business that is almost never accurate. Every booking has three amounts you need to know separately:

• The total — the room rate plus breakfast, surcharges, tourist tax and any extras.
• The amount already received — the sum of all payments you actually collected.
• The outstanding balance — the difference, and therefore the only figure that requires action.

Once you track those three separately, most disputes disappear. A guest who paid 30% is neither "paid" nor "unpaid": he has 70% outstanding, and that is what you want to see the moment he is standing at your door.

Record per payment, not per booking

The rule that makes the difference: every receipt is a separate line under the booking, with four details.

1. Date — when the money actually arrived, not when you entered it.
2. Amount.
3. Method — payment link, bank transfer, cash, card on site, or collected by the platform.
4. Reference — the transaction number, the payment description, or simply "cash on arrival".

It looks bureaucratic, but it answers exactly the questions that come up later. Why is there 340 euro in my bank account and 280 in my calendar? Because those were two payments from two bookings. Who took that cash? It says so. Was that refund after the cancellation actually processed? Also a line, with a minus sign.

A booking whose outstanding balance is zero with five lines behind it can be verified. A booking with only a tick mark is a memory test.

The four ways money comes in

Up front, through a payment link. The cleanest scenario: the money is in your account before the guest arrives, and the recording happens automatically. How to decide how much to ask up front is covered in asking for a deposit on a direct booking.

On site, in cash or by card. The most error-prone moment. Not because anything happens to the money, but because the recording gets postponed: you take it during breakfast with your hands full, and by the evening you remember that something was paid but not exactly how much or by whom. Record it there and then, on your phone, at the table. Thirty seconds that saves you an hour of searching in January.

Collected by the platform. With prepaid OTA bookings you receive nothing from the guest; you get a payout later or charge a virtual card, with commission deducted somewhere along the way. The booking is paid as far as the guest is concerned, but nothing hits your account until the platform pays out. Record those as collected by the channel, not as outstanding — otherwise you send reminders to guests who owe you nothing. The mechanics of those cards are explained in the Booking.com virtual credit card.

On invoice, after the stay. Typical for business guests. Here the outstanding balance is not an oversight but an agreement, with a due date. The risk is that such a booking drops out of sight because the stay is over: in your calendar that room has been sold twice since, while the money still has not arrived.

Why this mostly saves your bookkeeping

At the end of a quarter your revenue has to reconcile with your bank account. That only works if you know which booking every euro belongs to. The classic pain points:

• One transfer for two bookings. A family that booked two rooms pays in a single transaction. Without splitting it, one booking looks double-paid and the other unpaid.
• Cash that was never recorded. The money exists, but not in your administration. During an audit that is a harder story than a plain mistake.
• Refunds that only exist on the bank statement. A cancellation where you returned the deposit has to be visible on the booking too, otherwise your revenue is wrong.
• Tourist tax inside the total. That part is passed on to the municipality and is not revenue. Keep it visible separately, also within a payment.

How to get that reconciliation to your accountant without retyping everything is covered in automating your bookkeeping.

What you need for this

A spreadsheet can do this, but a spreadsheet does not know when a guest arrives. What actually makes the work light is that payments hang off the booking itself:

• the outstanding balance sits on the booking, visible at check-in;
• a cash or card payment is added in two taps;
• payment links record themselves once they are paid;
• OTA payments are recognised as collected by the channel;
• and there is one list of every booking that still owes money.

That last list is the whole point. Not searching, just looking once a week. BedFlow PMS tracks payments this way per booking, with the outstanding balance on the booking and the partial payments underneath it. What it costs is on the pricing page; the details are in the documentation.

A checklist for this week

1. Open your next five arrivals and note the outstanding balance for each. If you cannot do that in thirty seconds, that is where your problem is.
2. Agree on one fixed place where cash gets recorded — and record it on the spot.
3. Go through last month's bank statements for receipts you cannot link to a booking.
4. Put departed guests with an outstanding balance on a separate list and follow them up weekly.

Bookkeeping afterwards is addition. Tracking payments is simply forgetting nothing at the moment itself. If you want to see how that works in a system that keeps your calendar, your invoices and your payments together: BedFlow PMS is free to try for 30 days at bedflow.eu, no card details required.