What an audit actually finds in a travel agency's books

Most travel agency owners assume their books are broadly right. A little messy, maybe. Behind, probably. But right.

They usually aren't. Not because anyone did anything wrong, and not because the owner is careless. They aren't right because the money moves faster than the record, and nothing in the system forces the two to agree.

The findings below come from reconciling a working travel agency's own records against the reports from its booking system, line by line, booking by booking. None of them were exotic. None of them required looking hard. And every one of them was invisible until someone went looking.

Here is what turned up.

1. Bookings that simply aren't there

An agent keeps a spreadsheet. The booking system produces a report. You would expect the two to describe the same month.

They don't. The spreadsheet is short a handful of bookings, and with them several thousand dollars of sales that nobody missed. You cannot notice the absence of a record you never had.

This is the most dangerous finding on the list, and the quietest. The other four are errors you might eventually stumble on. A missing booking generates no discrepancy, no complaint, no red flag. It is simply not there. Commission was never calculated on it. Nobody chased the balance.

2. A refund larger than the client ever paid

Somewhere in the records sits a refund for more money than the client handed over in the first place.

Nothing stopped it. Nothing flagged it. The refund was entered, the money left, and the booking's balance quietly went negative.

This happens because refunds and payments usually live in different places, or in the same place with no rule connecting them. Nothing in the process asks the obvious question: has this client actually paid this much?

3. The same payment, two different amounts, because nothing tied it to a confirmation number

The agent's spreadsheet says a booking was paid one figure. The system report says another. The gap runs into the thousands.

Neither number is obviously wrong. Neither is obviously right. Nobody can say which to trust, because both were entered by hand, from different documents, at different times. Neither was filed against the one thing that would have settled the argument.

That thing is the confirmation number.

The only fact two records can share

A client's name is not unique. The same customer books three trips in a year, and two customers share a surname. A date is not unique: five payments land on the 14th. An amount is not unique: deposits cluster at round numbers, and half of them are $500.

The booking reference is the one value in the whole transaction that means exactly one thing.

When a payment is not filed against that number, matching stops being a lookup and becomes a judgment call. And judgment calls are where two records begin to diverge. One record shows $2,400 received from Customer 1. The other shows $2,400 received against Booking A. Nobody notices for four months that Customer 1 also has a Booking B, and the money was applied to the wrong one.

It fails hardest where money actually moves

• One person pays for another person's trip. The name on the payment does not match the name on the booking.
• A single deposit covers two bookings. Which one is paid?
• A client pays in three installments, and the third arrives after a change was made and the price moved.
• A wire lands with a memo the bank truncated to twelve characters.
• The bank statement shows a transfer, a first name, a last initial, and nothing else.

That last line is where identity goes to die. A payment arrives, the money is real, and no human being can say which booking it belongs to without opening an email thread.

Everything downstream inherits the failure

Once a payment floats free of its booking, nothing built on top of it can be trusted:

• You cannot validate a refund against payments that were never attached to the booking. That is finding 2, and this is its cause.
• You cannot recalculate a commission when the booking changes, because you do not know what has actually been collected against it.
• You cannot tell a client what they still owe without doing arithmetic by hand.
• At year end, you cannot prove any of it. You can only assert it.

The rule

No money moves without a confirmation number. In, out, or refunded.

A payment that arrives without one is not income yet. It is unallocated cash, and it should stay that way, visibly and uncomfortably, until someone assigns it to a booking. An agency that lets unallocated cash quietly become revenue has stopped keeping records and started keeping impressions.

In practice this means three habits: the confirmation number goes on every invoice and every payment request you send; you ask clients to put it in the transfer memo; and your system refuses to file a payment that has no booking behind it.

4. Commissions that nobody can explain

Your standard commission is, say, 15%. Then you find bookings at 12.5%. At 10%. At 18%. At zero.

Some of these are certainly negotiated. A big client, a difficult supplier, a favour repaid. Those are legitimate business decisions, and any agency that never makes them is not really negotiating.

The problem is not the exception. The problem is that the exception was never written down. Six months later the reason lives in one person's memory, and a business cannot be run on memories. When that person leaves, or simply forgets, the number becomes permanent and unexplainable.

5. Reports whose totals don't equal the sum of their rows

This one sounds impossible. It isn't.

A booking system exports a report. At the bottom is a total. Add up the rows above it and the two figures don't match.

The usual explanation is a filter: the report excludes cancelled bookings from the detail, but its total is calculated before the filter runs. The result is a report that quietly disagrees with itself. Anyone reconciling against that total inherits sales and commission that don't exist anywhere in the detail.

What all five have in common

None of these is an accounting failure. Every one of them is a traceability failure.

A client's deposit arrives and lands in the bank as cash. A supplier invoice arrives and gets paid. A commission is calculated once and never revisited when the booking changes. At no point is anything forced to point back at the booking it belongs to.

So the booking exists in one place, the money in another, and the relationship between them lives in a spreadsheet, an email thread, and somebody's memory.

That is why an agency can close a record sales month, see a healthy profit in the report, and find almost nothing in the bank. The profit is real. It just was never traceable, and untraceable profit cannot be collected, chased, or defended.

What to do about it

You do not need to buy anything to start. Run the five checks above on a single month. They take an afternoon, and they will tell you the size of your problem.

Most owners find that the amounts are smaller than they feared and the pattern is worse than they hoped. It is rarely one large hole. It is dozens of small ones, all created the same way: a payment that was never tied to the booking it paid for.

Fixing it permanently means changing where the relationship lives. Not in a spreadsheet next to the system, but inside the record itself: every client payment linked to its reservation, every supplier invoice validated against a real booking before the money leaves, every commission recalculated when the booking changes, and every exception carrying a written reason.

That is what Wihemi Travel does. It is accounting and back-office software built for travel agencies, by a finance team, out of exactly this problem. It does not replace your accounting system; it feeds it. A payment is not a row that sits near a booking; it belongs to one, and it cannot exist without one. The confirmation number is not a field someone remembers to fill in. It is the structure. You record the booking and you record the payment; the software handles the commissions, the margins, the balances, the deadlines, and the audit trail.

You don't need to be an accountant. You need the record to hold together.

Part of the bigger picture: read the full guide to travel agency back-office accounting.