📌 Key takeaways
- Excel is fine to start basic accounting in tourism, but it hits its limits as soon as seasonality, multi-channel sales and tax obligations pile up.
- Activity providers lose several hours a week on average reconciling files that their booking software doesn’t sync automatically.
- Electronic invoicing becomes mandatory for all small and medium tourism businesses in 2026-2027, which makes Excel incompatible with the new legal obligations.
- Management software connected to accounting lets you generate CEGID/SAGE exports directly from bookings, with no manual re-entry.
- Moving from Excel to an integrated tool doesn’t mean changing accountants: most firms already work with the export formats of the main software on the market.
What is Excel accounting in tourism?
When you launch a tourism activity, Excel is often the first reflex. It’s free, familiar, and for a few dozen bookings a season, it’s more than enough. One tab for payments, another for expenses, a few formulas for the monthly total, and you’re done. Many kayak providers, nautical bases or independent guides started exactly like that, and some are still there several years after launching.
The reality is that Excel is not accounting software. It’s a spreadsheet. It can imitate the functions, but it doesn’t replace them: no automatic accounting journal, no reconciliation matching, no native VAT management by rate, no sync with your sales channels. Everything that goes into the file, you enter it. And everything that changes — a refund, a booking cancelled on GetYourGuide, a deposit received by transfer — has to be carried over by hand.
For a seasonal provider with a simple activity, this model holds. But as soon as you start selling across several channels, managing groups with quotes, tracking equipment and preparing grant applications, the Excel file becomes a constraint more than a tool.
Why does Excel become insufficient for tourism professionals?
Activity tourism has accounting specificities that generalist tools handle poorly. Seasonality creates brutal imbalances: three months at 80% of your annual revenue, then nine months empty. In an Excel file, this reality is hard to model cleanly without building complex formulas that you probably won’t maintain from one year to the next.
Multi-source revenue poses a second problem. When your bookings arrive at the same time from your website, GetYourGuide, Viator and a network of physical resellers, each channel has its own commission rules, its own payment deadlines, its own reconciliation formats. Reconciling all that manually in Excel takes considerable time — and the risk of error is constant.
💡 Good to know: According to a Xerfi study “Tourism and digitalisation” (2024), 63% of small tourism structures report spending more than a day a week reconciling their Excel files. The indirect cost often exceeds €8,000 per year.
Managing group quotes is a third friction point. A quote for 40 people on a half-day kayak outing is a document to create, send, follow up, convert into a booking, then invoice automatically. Excel does none of that: every step is manual, every email is written by hand, and the sales history is scattered between your inbox and your tabs.
Finally, the tax question is becoming increasingly structuring. VAT on tourism activities is not uniform: rates vary according to the nature of the service and the destination. And since 2026, electronic invoicing is mandatory for the large companies you work with, and will become so for all small and medium businesses in the sector in 2027. An Excel file doesn’t generate invoices in the Factur-X format. It isn’t connected to an Approved Platform. It can’t meet these legal obligations.
How to structure your accounting as an activity provider?
The right question isn’t “Excel or not Excel” but “what do I really want to steer in my business?” A provider who just wants to keep the books for their accountant can manage with Excel for a few years. But a provider who wants to steer profitability by activity, prepare a grant application, track equipment and sell across several channels needs a tool that connects all this data.
The most effective approach starts from the real financial flow. What generates revenue for you: direct bookings, OTAs, group quotes, seasonal subscriptions? What generates expense: equipment, fixed costs, platform commissions, seasonal charges? Once this mapping is done, you know exactly what your accounting tool must be able to capture automatically, and what you can still handle manually.
For structures that stay on Excel at first, three minimum rules: one tab per revenue source rather than a global tab, one line per transaction with the date, the channel, the pre-tax amount, the VAT rate and the payment status, and a regular monthly export to your accountant in CSV format rather than a year-end transmission. It doesn’t solve the structural problems, but it limits errors and makes the annual close easier.
⚠️ Watch out: An Excel file shared between several people (you, a seasonal worker, your accountant) without version control is a source of silent errors. An overwritten formula, a badly filled-in tab, and a whole season of data becomes inconsistent. If you share your file, work on Google Sheets with edit history enabled, or move straight to dedicated software.
Migrating to integrated software happens in two phases. The first consists of connecting your booking tool to your accounting, so that every confirmed sale automatically generates the corresponding accounting entry. The second consists of configuring the exports in your accountant’s format: CEGID, SAGE, EBP, Ciel — most software on the market offers these formats natively. Your accountant then no longer needs to re-enter anything: they import the file directly.
How Tourbiz manages the accounting of your tourism activities
The problem we hear most often from our clients is exactly this one: an Excel file that “holds up” for two or three seasons, then blows up as soon as the business gets structured. A kayak provider going from 200 to 800 bookings a season, who starts selling on GetYourGuide in addition to their site, and who receives an ADEME grant request, can no longer manage their accounting by hand.
At Tourbiz, we built our financial exports directly from confirmed bookings. Every payment, every refund, every OTA commission is captured at the moment of the transaction and exportable in one click in CEGID or SAGE format. Our clients who prepare grant applications can extract a report by activity type, by period and by channel in a few seconds — without rebuilding the data from scattered files. You can discover how our financial export and invoicing management concretely works from the back office.
🎯 Our tip: At Tourbiz, our most advanced clients on accounting run their CEGID export on the first of every month. Their accountant receives the file directly, imports it in five minutes, and the monthly close is done without exchanging emails or spreadsheets. What used to take half a day at year-end now takes one hour a month, spread out.
Electronic invoicing is another topic we worked on ahead of time. Since 2026, tourism businesses that work with B2B partners (works councils, local authorities, operators) must issue invoices in the Factur-X format. Tourbiz generates these invoices automatically from confirmed bookings, with no extra handling on your side. To understand everything on this subject, our article on electronic invoicing in tourism details the deadlines and the concrete impacts for your structure.
💡 Ready to simplify your accounting?
With Tourbiz, centralise your payments, generate your CEGID/SAGE exports in one click and prepare your grant applications without rebuilding your data. A single back office to steer all your financial flows — and focus on what really matters: your customers.
Request a quoteThe mistakes to avoid when managing your tourism accounting on Excel
The first mistake, and the most common, is mixing flows. Many providers have a single Excel file where direct bookings, OTA transfers, equipment expenses and personal expense claims all coexist. Untangling that at year-end is a nightmare, and your accountant will bill for the time spent doing it. The basic rule: one file or one tab per type of flow, with an explicit label on every line.
The second mistake is not building seasonality into the tracking. A nautical activity that makes 80% of its revenue between June and September has months when cash is abundant and months when it’s nil. If your Excel file doesn’t model this reality, your view of profitability is distorted. You think you’re profitable in August when you’ve already spent your September charges.
The third mistake is confusing cash received with revenue. A deposit received in April for a July outing is not revenue in April: it’s a debt owed to your customer. Excel, if you haven’t explicitly configured this distinction, will give you inflated revenue in the first months of the year.
Finally, the fourth mistake is putting off the transmission to your accountant until year-end. An accountant who receives twelve months of transactions in January works under pressure and bills accordingly. Exporting and transmitting monthly, even in a basic CSV format, reduces fees and improves the quality of the advice you receive.
Conclusion
Excel is an acceptable starting point for a tourism activity that’s getting going. It’s a tool everyone knows, that costs nothing and meets the most basic financial-tracking needs. But it isn’t designed for the accounting of a structure that manages equipment, sells across several channels, produces group quotes and must meet tax obligations specific to tourism.
Getting paid smoothly matters, and the right payment methods reduce friction at checkout.
The real question isn’t whether you should leave Excel, but when. And the answer is often sooner than you’d think: from the second serious season, as soon as you have more than one revenue source, as soon as you start preparing a funding application.
