A single source of truth: why your hotel’s numbers must be traceable

A hotel’s most expensive problem is almost never a wrong number. It’s having five versions of the same number. The manager opens her spreadsheet and sees one occupancy figure; the front desk reports another; the channel report shows a third; finance brings a fourth from yesterday’s close; and the owner, from his phone, swears he saw a fifth. Nobody is lying. Each of them is simply reading a different copy of reality. And as long as that happens, the meeting is never about what to do with the hotel: it’s about where the number came from.

What “a single source of truth” really means

The phrase sounds technical, but the idea is simple. A “single source of truth” means everyone, front desk, finance, the manager, the owner, reads from the same living origin of information, not from loose copies each person saved on their own. There is one place where the reservation exists, where the payment was logged, where the shift was closed. Every report, every dashboard, every question is answered by returning to that one place.

The opposite is what’s common: the data is born in operations, someone copies it into a sheet, the sheet is emailed, someone else edits it, adds a column by hand, forwards it again, and by Friday three versions of the same file with the same name are circulating. In that world there is no truth: there’s a file that won the argument because it was the most recent, or belonged to whoever spoke loudest.

When there are five copies of a number, you don’t have five data points. You have zero data and five opinions.Operating principle

Traceability: following a number back to its origin

A single source solves the “where.” Traceability solves the “why.” Traceability means being able to take any total, the month’s revenue, yesterday’s occupancy, the cash in the drawer, and follow it backward, step by step, to the real transaction that produced it: this reservation, this payment, this cash movement, at this time, made by this person.

A traceable number doesn’t ask you to trust it. It lets you open it up. If Tuesday’s revenue shows a figure, you can drill down to the forty reservations that make it up, and inside one of them, the exact payment that backs it. A number without traceability is a rumor in nice formatting: it looks serious, but you can’t ask it where it came from.

Why the hand-edited spreadsheet breaks both

The spreadsheet isn’t the villain: it’s an extraordinary tool. The problem is what we do to it. The moment someone types a number by hand onto a sheet, two breaks happen at once.

• It breaks the single source: that sheet no longer reads from live operations. It’s a snapshot of the past that someone also retouched. From the moment it’s saved, it starts going stale.
• It breaks traceability: a typed number doesn’t remember where it came from. You can’t click it to see the reservations behind it, because it’s no longer connected to them. There’s only the number, alone and without a past.

And because each copy can be edited separately, errors aren’t corrected: they multiply. A cell with a broken formula, a filter someone left on by accident, one extra pasted row. Nobody notices, because nobody can see at a glance whether the total squares with the reality underneath. The file becomes a building with no blueprints: it holds up, until one day it doesn’t.

The real cost: meetings spent on “where does this number come from?”

Here is the cost almost no one measures, because it shows up on no invoice. It’s time. Imagine, as an illustrative example, a weekly one-hour management meeting. If the first twenty minutes go to reconciling which file each figure came from and why two reports disagree, that’s a third of the meeting spent on data archaeology, not on decisions. Week after week, that piles into a mountain of expensive people’s hours debating not what to do, but what to believe.

And the worst part of the cost isn’t the wasted time: it’s the decision that didn’t get made. When half the meeting goes to defending a number, the other half is no longer enough for the conversation that mattered, raise rates, shift inventory, attack cancellations. Doubt about the data crowds out strategy.

Getting a number wrong isn’t expensive. Not knowing whether the number is right is ruinously so.Hallway wisdom, applied to hotels

Why this weighs more and more as you grow

One small hotel forgives; two do not

With a single hotel and a small team, the five versions get reconciled with a hallway chat. Everyone knows each other, everyone knows “which file to believe.” The single source, in practice, is one person’s memory. It works, fragilely, as long as that person is around.

As you grow, a second hotel, a third, shifts that don’t overlap, new people, that memory stops being enough. What used to be settled by talking now demands that the truth live in a place, not in someone’s head. Without that, each new hotel doesn’t add up: it multiplies the disorder.

Balancing the cash drawer: where truth admits no copies

Balancing cash is the most physical example of all this. The cash in the drawer is a stubborn fact: it either matches what was recorded or it doesn’t. If cash movements, payments, and shifts live in separate origins that someone stitches together by hand, the discrepancy becomes impossible to trace. A missed charge? Logged twice? A badly closed shift? With traceability, the answer is a few clicks away. Without it, the shortfall gets “explained” with a shrug.

The investor and the auditor don’t ask for the number: they ask where it comes from

In front of an investor or an audit, a pretty number is worth little. What counts is being able to prove it. An auditor doesn’t want your revenue report; they want to drill from that total down to the transactions that form it and verify they close. If your figure lives in a hand-edited sheet, every number is a claim you’ll have to defend from memory. If it’s traceable, every number defends itself: you open it, show the transaction, and the conversation moves on. Traceability isn’t bureaucracy; it’s what turns your numbers into something credible to whoever puts in money or signs the books.

Signs you do NOT have a single source of truth

You don’t need an audit to know. If you recognize three or more of these scenes, your hotel is running on copies, not on reality:

1. Two people present the same metric with different numbers, and both have “their” file to prove it.
2. There exists a file whose name includes “final,” “final2,” “final_good,” or “real latest version.”
3. To answer a simple question from the owner, someone has to “assemble” the figure by cross-referencing several sheets by hand.
4. When a number looks off, no one can click it to see what’s underneath; you can only “ask whoever made it.”
5. Monday’s report describes Friday: you’re always looking at the past, never at what’s happening now.
6. If the person who “knows where everything is” goes on vacation, the reports stop.
7. No one is 100% sure which is the current version, so when in doubt everyone uses their own.

What changes when your numbers finally become traceable

When the whole operation, reservations, cash, channels, payments, guests, orders, shifts, and cash movements, is read from one living origin, the five versions stop existing. There is one. And because every total can be opened down to the transaction that produced it, the question “where does this number come from?” stops stealing meetings. AI, over those same numbers, helps go one step further: ask in plain language, get a summary, flag an anomaly or a hidden pattern. But it’s worth being honest about scope: this measures and explains, what happened and why, it doesn’t set your prices for you. The rate decision is still yours; what changes is that you now make it on solid ground.

That’s the real prize, and it isn’t technical. It’s human. When everyone at the table trusts the same number, the discussion can finally be the one that matters: not whether the data is right, but what we’re going to do about it. The truth stops being a subject of debate and goes back to being what it always should have been, the starting point.