Many agencies run surprisingly large businesses on spreadsheets, chat groups and a dozen supplier tabs open at once. It works, until it does not: a payment is missed, a ticket is issued twice, or the one colleague who understands the sheet goes on holiday. A travel agency booking panel replaces that patchwork with one system, but the move itself needs planning.
This guide covers how to prepare, what to move first, how to bring staff along and how to avoid the classic mistakes of switching systems mid-season.
Signs you have outgrown spreadsheets
You probably already know, but these are the usual warning signs:
- Staff ask each other "who is handling this booking?" several times a day.
- Payments are matched to bookings by looking at bank screenshots.
- Partner agents receive fares one at a time over chat.
- Nobody can say quickly which products or partners make the most margin.
- Travellers call to ask for documents that should have been emailed.
Each of these is a symptom of the same problem: information lives in many places instead of on one booking record.
What a booking panel changes
In a travel booking panel, each booking is a single record. The passengers, the product, the supplier reference, the payments, the documents and the notes all live together. Search covers your connected suppliers in one place, markups are applied automatically, and tickets and vouchers are sent by the system rather than by hand.
That has three practical effects:
- Anyone can pick up a file. A colleague can open a booking and help the customer without asking around.
- Money is visible. Card payments, agent wallet deductions and balances are shown on the booking.
- Numbers are available. Reports show sales and margins by product, channel and agent without building a new sheet.
Step one: map how you work today
Before choosing settings, write down how work actually flows today. Keep it simple:
- Which products do you sell, and from which suppliers?
- Who sells: walk-in staff, phone consultants, partner agents, or travellers online?
- How do customers pay, and who confirms the payment?
- Which documents go to the customer, and who sends them?
- What does a typical problem look like, such as a schedule change or a refund?
This map becomes the checklist for setting up the panel. It also reveals steps that no longer need to exist.
Step two: decide what moves first
Do not try to move everything on the same day. A sensible order is:
- Your most common product. For many agencies that is flights or hotels. Connect the suppliers you already use for it.
- Your internal team. Let staff book through the admin while customers notice nothing.
- Your partner agents, if you have them, through the B2B travel portal.
- Your public website, once your team is confident.
- Other product lines, such as tours, Umrah or visas.
This staged approach keeps risk low. If something needs adjusting, only one product or channel is affected.
Step three: prepare your data
The panel will hold your future bookings, but you still need a clean starting point.
Customers and partners
Gather a list of active partner agencies with contact details and the credit terms you agreed. For retail customers, your existing customer list is useful for marketing, but there is no need to import years of history on day one.
Suppliers and credentials
Collect the agreements and API credentials for each supplier you plan to connect. Connections in the panel use your own accounts, so your negotiated rates stay with you. Confirm with each supplier whether a test environment is available.
Pricing rules
Turn the markups your staff apply from memory into written rules: per product, per channel and, where needed, per agent. These become the markup settings in the admin.
Open bookings
Decide how to handle trips that were booked in the old way but have not yet travelled. Most agencies keep them in the old sheet until they are complete, and use the panel for everything new from a chosen date.
Step four: train people by role
Different people need different training.
- Consultants need to search, book, take payment and find a booking quickly.
- Finance needs to confirm agent top-ups, check payments and read the reports.
- Operations needs to handle changes, cancellations and documents.
- Partner agents need a short guide to the portal: search, book, top up, download documents.
- Managers need the reports and the settings for markups and permissions.
Short sessions on real bookings work better than long demonstrations. Ask each person to make a test booking from start to finish.
Step five: run both systems briefly, then stop
For a short period, it is reasonable to keep the old sheet for open trips while all new bookings go through the panel. Set a clear end date. Running two systems for too long is the most common reason migrations fail: staff drift back to the familiar sheet, and the panel never becomes the single source of truth.
Setting permissions and roles
A spreadsheet usually gives everyone access to everything. A booking panel lets you be more precise, and the move is a good moment to decide who can do what.
- Consultants can search, book and take payments, but not change markup rules.
- Finance can confirm agent top-ups and refunds and see every payment.
- Operations can change and cancel bookings and resend documents.
- Managers can change prices, permissions and supplier settings.
- Partner agents see only their own bookings, wallet and statements in the B2B travel portal.
Clear roles protect your margins and make it obvious who to ask when something needs approval. Start with a few broad roles and narrow them later if needed.
Communicating the change to customers
Travellers and partners notice two things: the documents they receive and the way they pay. Before switching, check that tickets, vouchers and invoices carry your logo and contact details, and send a short note to regular customers explaining that they can now book and download documents online. For partners, a simple message with their new login, a one-page guide and a time for a call removes most of the anxiety.
Avoiding the classic mistakes
- Switching in peak season. Move during a quieter period, so staff have time to learn.
- Recreating the spreadsheet. The goal is a better workflow, not the same one on a new screen.
- Too many custom rules. Start with simple markups and permissions and refine them later.
- Skipping partner communication. Tell partner agents well in advance, and offer a short call to walk them through the portal.
- No owner. Appoint one person inside the agency to own the move and answer questions.
Keeping the old data useful
Old spreadsheets still have value after the move. Keep a read-only copy for reference, so staff can look up a past trip or a customer's preferences. Over time, as repeat customers book again through the panel, their new records replace the old rows naturally.
How long does it take?
It depends on how many products, suppliers and channels you move, and how quickly suppliers provide credentials. Installation and branding are handled by the platform team; the time on your side goes mostly into supplier paperwork, pricing rules and training. Moving in stages, as described above, lets you start benefiting from the first product while the rest follow.
What good looks like afterwards
A few months after a successful move, an agency usually notices:
- Staff answer enquiries from one search screen.
- Every payment can be traced to a booking.
- Partner agents book on their own, outside office hours.
- Managers check margins in the reports instead of building sheets.
- The busy season feels calmer, because nothing lives only in someone's head.
Related reading
If partners are part of your plan, read our comparison of a B2B travel portal and a B2C website to decide which to open first. The features page shows each part of the panel by team, and the pricing page explains how a quote is put together. When you are ready to see your own workflow in the panel, book a demo.