Hospitality bookkeeping for a tour operator that sells through marketplaces starts with the gross booking. GATP rebuilt a multi-city operator’s books from Xola and booked Viator, GetYourGuide and Groupon commissions as channel costs. It held prepaid tours in deferred revenue until they ran and reconciled QuickBooks to the filed corporate tax return line by line.
Business Background
A Multi-City Tour Operator Selling Through Xola and Three Marketplaces
The client runs guided experiences: walking tours, ghost tours and sightseeing. It operates in several U.S. cities and in London, and it sits inside a larger hospitality group.
Travelers book in two ways. Some book direct on the company’s own site through Xola. Others book through Viator, GetYourGuide or Groupon.
Each marketplace collects from the traveler, keeps its commission and pays over what is left. The books are kept in QuickBooks, and GATP handles the bookkeeping.
The job goes well past coding deposits. The company sells the same tour through several channels and collects the money weeks before the tour runs. It also files a corporate tax return that the books have to stand behind, for every city, every channel and every month.
The same booking stack, Xola alongside Viator and GetYourGuide, sits behind another GATP case study on multi-platform revenue reconciliation.
Key Challenges
Five Defects Behind a P&L That Still Reconciled to the Bank
On the surface, keeping a tour operator’s books current looks like a matching job. A payout lands, it gets coded to Sales, the bank reconciles, and the month is closed. Underneath sat five problems that made a multi-channel, prepaid, multi-city business describe itself wrongly.
- Marketplace revenue booked net. Viator, GetYourGuide and Groupon each pay over the booking minus their commission. The books recorded that net payout as Sales. The top line was understated, and the commissions the business paid never appeared as a cost. The real gross booking sat in Xola the whole time.
- Refunds, processing fees and marketing coded as each other. A refund paid to a traveler was booked as a processing fee. A marketing charge sat in the wrong account. Fees looked bigger than they were, and refunds vanished into the cost of doing business. The advertising spend the owner wanted to see was nowhere to be found.
- Tours paid for before they run. A traveler might book and pay in March for a tour in June. Count that cash as March revenue, and March looks like a boom while June looks empty. Deferred revenue, the money owed as a future tour, never showed up on the balance sheet.
- Money crossing entities and currencies. The London operation collects in GBP, and the funds arrive through a payment processor. Transfers left the bank to fund traveler refunds. VAT accrues on the UK side at period-end. As raw bank lines, a refund-funding transfer looked like an expense, a GBP receipt sat uncategorized, and the UK tax position was missing.
- A filed return that no longer tied. A corporate tax return was prepared and filed off one version of the numbers. The books kept moving afterward. QuickBooks and the return stopped agreeing, and nobody could prove which one was right.
None of these defects is unusual for a fast-growing experiences business. Together they produce books that reconcile to the bank to the penny and still describe a business that is not there.
Impact
What Net Payouts and Booking-Date Revenue Did to the Owner’s Decisions
Books like these fail quietly. The damage shows up in the decisions the owner makes from them.
The owner could not see which channel or which city actually made money. Every marketplace sale sat inside a net number, with its commission netted away.
Monthly results swung on when travelers happened to book, not on when tours ran. One month looked like a boom and the next looked like a stall.
Advertising spend was invisible, so there was no way to judge which marketing worked. And because the ledger had drifted away from the filed return, the first question a lender or an examiner asks had no clean answer.
Weak books here meant more than untidy records. They meant decisions made on numbers that were quietly wrong.
Requirements & Expectations
Five Standards for a Tour Operator’s Gross, Accrual-Based Books
Most published guidance on accounting for the hospitality industry is written for hotels and restaurants. A tour operator selling through marketplaces needed a narrower brief, and the engagement set five standards.
- Gross bookings and true channel costs. A P&L showing real gross bookings and the cost of every channel (Xola direct, Viator, GetYourGuide, Groupon), broken out by city.
- Revenue on delivery. Revenue recognized when the experience is delivered, with prepaid bookings held as deferred revenue until then.
- Every line coded as what it is. Refunds, processing fees and marketing each in their own account, corrected historically and kept correct going forward.
- Cross-border and owner items handled. GBP receipts, refund-funding transfers and UK VAT booked properly, with the owner’s personal accounts kept off the operating books.
- A tie to the filed return. Books that tie back to the filed corporate tax return, with any difference explained rather than unknown.
Strategic Approach
Principal vs Agent Revenue Recognition: Why Xola Became the System of Record
GATP ran the work on one rule. The P&L has to show what was really sold, what each channel really cost and when each tour was really delivered. The books also have to tie to the return filed on them.
Gross vs net revenue recognition turns on one question: who controls the service before the customer receives it? FASB’s ASU 2016-08 says a principal reports the gross amount of the sale. An agent reports only its fee or commission.
In hospitality accounting, that is the line between a business that delivers the experience and one that resells it. The operator runs the tour, so GATP booked the full booking as its revenue. The marketplace that arranged the sale earns the commission.
Travel agency accounting often lands on the other side of that line. An agency that only arranges someone else’s trip usually records its commission as revenue.
So GATP made Xola, where the full gross booking lives, the system of record instead of the marketplace payout. Revenue would be recognized as tours ran, not as cash landed. And the ledger and the return would be reconciled directly.
Comprehensive Solution
Five Moves That Rebuilt the Books From the Gross Booking Up
The rebuild broke into five moves, run in this order.
- Book every sale gross from Xola
GATP books revenue gross from Xola. Each marketplace’s commission and fees then go to their own line, by channel and by city: Xola direct, Viator, GetYourGuide and Groupon.
The net still reconciles to the bank. The P&L now shows the full booking and what each channel took out of it.
Gross reporting also matches what the return asks for. The IRS Instructions for Form 1120 ask for gross receipts or sales from all business operations on line 1a.
- Recognize revenue when the tour runs
Bookings paid in advance are parked in deferred revenue. They are released to income as each experience is delivered.
The deferred revenue journal entry has two halves. When the traveler pays, cash is debited and deferred revenue is credited. On the tour date, deferred revenue is debited and tour revenue is credited.
In practice that is a QuickBooks deferred revenue account, set up as a liability. A prepaid summer tour stops inflating the month it was booked, and the monthly trend follows tours actually run. The same deferral logic drives our guide to SaaS revenue recognition.
Tax timing can differ from book timing. IRS Publication 538 says advance payments are generally income in the year received, and an accrual-method business can elect to defer them only to the next year.
- Fix refunds, processing fees and marketing, back and forward
Refunds are booked as refunds, processing fees as processing fees and advertising as advertising. A historical cleanup corrected the past entries, and the monthly bookkeeping keeps them correct.
The fee line no longer overstates cost, and the marketing spend the owner asked to see is finally visible. Operators who want to size their own fee problem can start with our processing fee leak calculator.
- Handle the cross-border and owner items
GBP receipts from the UK operation are identified and booked to the right entity. Bank-to-processor transfers made to fund refunds are recorded as transfers rather than expense.
UK VAT is accrued at period-end. The owner’s personal accounts are kept off the operating books.
- Reconcile QuickBooks back to the filed tax return
GATP walks the books and the return to each other line by line. The two now agree, and any difference between them is explained rather than unknown.
That book to tax reconciliation is a standard part of a corporate return. On Form 1120, Schedule M-1 is titled Reconciliation of Income (Loss) per Books With Income per Return.
A ledger that ties to last year’s return is also the right starting point for next year’s business tax preparation.
Measurable Results
Gross Bookings and Channel Costs by City, Across Four Sales Channels
After the rebuild, the owner has books that match the business.
- The P&L shows real gross bookings and the true cost of each channel (Viator, GetYourGuide, Groupon and Xola direct), broken out by city. It replaced a stack of net payouts that hid both the top line and the fees.
- Revenue is recognized as tours are delivered, with prepaid bookings sitting in deferred revenue. The monthly trend reflects tours that ran, not the week a booking cleared.
- Refunds, processing fees and marketing are coded as what they are. The fee line stopped overstating cost, and advertising spend is visible.
- Cross-border receipts, refund-funding transfers and UK VAT are booked correctly instead of landing as mystery lines. The owner’s personal accounts stay out of the operating P&L.
- QuickBooks is walked back to the filed return line by line, so the two agree.
Key Takeaway
Why Hospitality Bookkeeping for Tour Operators Starts With the Gross Booking
A tour operator’s books rarely fall apart because someone missed a booking. They fall apart in three quieter ways.
Marketplace revenue gets booked at the net payout, with the commission hidden. A tour paid for in March gets counted as March revenue instead of waiting in deferred revenue. And the return gets filed while the books keep moving, until the two no longer agree.
The fix is to rebuild each booking gross from the system of record. Recognize revenue when the experience is delivered. Code refunds, fees and marketing as what they are, and tie the ledger back to the filed return.
Do that, and books that were reconciled but misleading become books the owner, the lender and the tax preparer can all stand behind.
Client Impact
What Channel-Level and City-Level Numbers Changed for the Owner
The owner can now see which channel and which city actually earn money. Marketing budget decisions rest on visible advertising spend, and the monthly trend follows tours delivered.
The business can face a lender or an examiner with a ledger that matches its filed return.
Finance stopped being a source of doubt every time a decision depended on the numbers. The owner now acts on them with confidence.
Conclusion: Let’s Talk
Hospitality Bookkeeping Services for Tour and Experience Operators
You may sell experiences on your own site and on Viator, GetYourGuide or Groupon while your books record only the net payout. Or your tax return may no longer match QuickBooks. That cleanup is the core of the hospitality bookkeeping services GATP runs.
We rebuild each booking gross from your system of record and recognize revenue when the tour runs. Then we tie your ledger back to the return you filed.
Ready for a P&L that describes the business you actually run?
Contact GATP to walk through your numbers together.
