Last updated September 24, 2026
Ready to switch to JourneyFuse? This guide walks you through how to export your data from the most common travel agency platforms so you can import it using JourneyFuse's CSV import tool.
Export before you cancel. Most platforms delete your data when your account is closed. Always confirm you have a complete export in hand before canceling any subscription.
You don't have to run any of this yourself. Open a migration request and send us your export files — attach them to the request, or reply to the ticket email with them, whichever is easier. We analyze everything and build you a migration dashboard right inside your support ticket: what we found (clients, trips, bookings and their value), any questions that need your input — each with our suggested handling, so answering is usually one click — and live progress through every stage, from Files received to Import complete.
Two things stay in your hands the whole way:
Our team loads your contacts, rebuilds your trips and invoices, and records any prior payments so your balances are correct from day one.
Tern has strong self-serve CSV export, so most of your data can be pulled without a support request. You own your data and can export it anytime.
Your trips come across, and the trip list itself is one download. In Tern's Reporting section, open Agency Trips (on an independent advisor account it is called Your Trips), and on the table of trips use the three-dot menu, then Download, then CSV. That file carries each trip's name, status, travel start and end dates, lead contact and advisor. Send it alongside your bookings export and we rebuild your trips with the right names, dates and balances.
Tern's reports come in two versions. The Your versions (Your Trips, Your Clients) hold only the book of whoever ran them. The Agency versions (Agency Trips, Agency Clients, and the agency bookings report) hold every advisor's work in one file, with a column naming the advisor on each row. Your advisors do not each need to export their own.
So for a team, the owner or an admin with agency reporting runs the downloads below once, and we place every trip, booking and client under the advisor who owns it in Tern. Two things make that work:
If you are an advisor under a host agency and only see the Your reports, that is fine: they are your whole book, and you send them yourself.
This CSV maps directly into JourneyFuse's client import.
For a team, make sure the export covers every advisor's contacts, not only the person running it. Reporting's Agency Clients report is a useful second file: it lists every contact in the agency with its owner, which is how we catch anyone the Contacts export missed. It carries no passports, and its birthdays have no year, so send it as well as the Contacts export, never instead of it.
Tern's commission area exports booking and commission history to CSV:
Tern has two different bookings exports, and one is much better than the other. Take the fuller one if your account offers it:
| Export | Filename looks like | Columns |
|---|---|---|
| Commissions / Reconciliation → Bookings | bookings_1786832314.csv or bookings_20260728_123557.csv | Supplier, Client, Booking Date, Start Date, Conf #, Est. Commission, Expected Commission Date, Agent, Status, Total Cost |
| Reporting → a bookings report → three-dot menu → Download → CSV | all-bookings-2026-07-28.csv | The above, plus the commission you have received, Commission Status, and, if you add them with Edit Columns in that same menu, Trip Name, trip travel start and end dates, and what each client has paid (Total Paid, Balance Due, Final Payment Due Date) |
The difference is bigger than it looks. On one recent migration the shorter file held 917 bookings and the Reporting one held 1,287 of the same advisor's bookings, so it is worth a minute to look. The filename tells you which you have: a Reporting download ends in the date (-2026-07-28.csv), a table export ends in a timestamp (_20260728_123557.csv). The Back office Bookings page's own Export button produces the shorter file, and that page has no way to add columns, so do not look for one there.
The second carries what you were actually paid, not just what was estimated, plus the agency-income split. Edit Columns on that same report also offers Total Paid, Balance Due and Final Payment Due Date, so one download can carry balances as well as commission — add them if they are there. If you only have the first, send it anyway — it rebuilds your trips fine, it just can't tell us which commissions have already landed.
Not every account has a bookings report in Reporting. The Reports list is set by your plan and, on a host-agency account, by your host — some carry Agency Clients, Agency Trips and the commission reports with no bookings report at all. If yours has none, you are not missing a setting: send the table export above for the bookings themselves, and the balances export below for the money. Tell us which reports you do see and we will name the right ones.
Three things neither export has, worth knowing before you go looking:
In the Reporting bookings report, use the three-dot menu on the table, choose Edit Columns, and add Total Paid, Balance Due and Final Payment Due Date. Then download it from the same menu with no date range. That one file carries what every client has paid across your whole history, travelled trips included, and it is the version to send.
Your Bookings page also downloads a payments view with Total Paid, Balance Due and the next payment due, but it covers open bookings only, inside a booking-date range, so it cannot show the money on a trip that has already travelled. It is fine as an extra; it is not a substitute for the columns above — and it is the one to send if your account has no bookings report to add columns to. Clear the filters before you download: that page remembers the last supplier, group or date range you looked at, and a filtered download quietly covers a fraction of your book. On its own it has no travel dates, no booking date and no commission, so trips built from it alone arrive undated with no commission history.
Only bookings marked Booked appear in the bookings report. If your team tracks some bookings without flipping them to Booked in Tern, they are not in that file, and neither is their money. Mark them Booked and download again, or tell us, and for a group we take the cabins from the group's Travelers export instead.
Download from the table, not a summary tile. A Tern report opens on summary tiles with the table underneath, and each tile has its own three-dot menu. A tile's download is a one-row file holding a single number, saved under the report's name. Scroll to the table and use its menu; the right file has one row per trip or booking.
The payments view also lists quotes next to bookings. On one recent group sailing, 37 of 50 rows were cabin options the advisor had priced but nobody had booked, including five rows against a single real booking. Send it as it comes and we filter those out. If you are importing it yourself, keep only the rows that are booked, carry a confirmation number, or already show money paid.
If the trip is part of a Tern Group Trip, every traveler is exportable. Open the group in Tern, go to Travelers, use the three-dot menu, then Download, then CSV. The file is named <agency>_grp_<group name>_travelers_<stamp>.csv and holds one row per traveler: name, email, phone, date of birth, the full passport block, confirmation number(s), room, and the cabin's cost, paid and balance. One export per group. Send those alongside your bookings file and we place every cabin, with everyone in it, onto the right sailing.
For an individual (non-group) trip, there is no second traveler in any Tern export. A Tern booking holds one client name, which Tern documents as the lead traveler, and a Tern trip attaches to one contact. There is no additional-traveler field to add, so this is worth not spending a week looking for.
The good news is that you almost certainly already have those people. Companions are separate contacts in Tern, so they come across with your contacts file as clients in their own right. What is missing is only the link between a booking and the second person on it, and there are three ways to rebuild it:
Tell us which of these you have when you send your files and we will do the linking as part of the migration.
That bookings CSV imports straight into JourneyFuse — no support ticket needed if all you want is your commission history:
A few things worth knowing before you do:
This loads commissions, not trips. Each row becomes a logged commission. It does not rebuild trips, bookings, invoices, or balances, and it does not create client records (an existing client is linked when the guest matches one). If you want your trip history rebuilt properly, send us the file and we will do the full migration — see below.
The bookings export sits in more than one place, and not every Tern account has all of them:
Send the file unedited. Guessing at columns is our job, and tidying it up first tends to remove the very fields we match on.
What Tern does not export, so plan around it rather than hunting for it:
One quirk worth knowing: a Tern trip still marked New Request or Inbound exports no bookings at all, and shows a $0 total, even when real deposits have been taken against it. If bookings seem to be missing from your file, convert those trips out of New Request in Tern and export again.
To make the migration complete, export everything you can:
For a team, the owner or an admin gathers all of these once, using the Agency version of each report. Individual advisors do not need to export anything.
Switching over on a set day? Keep working in Tern until then, and download the same set again on the evening before. We load it as a top-up, adding trips, bookings, clients and payments created since your first files without duplicating what is already here. Include Agency Trips in that set too, since a trip started in Tern that has no booking yet only appears there.
If anything isn't covered by a self-serve export, email Tern support to request a complete data export before you cancel:
Subject: Complete Data Export Before Switching Platforms
Hi Tern team,
We're migrating to a new platform and want a complete export of our data. We've already pulled our contacts and bookings CSVs. Could you also send any notes recorded against contacts or trips, and a payment-by-payment ledger of client deposits against each booking, if such a report exists? CSV or Excel is ideal.
Don't ask Tern support for your itineraries. There is no written-itinerary export and asking produces a round trip and a no. The trip skeleton comes from the Bookings not yet marked Booked report described above, and for a booked trip our supplier and confirmation-email imports rebuild most of the rest rather than you typing it in.
Contact: Tern support via the in-app help widget or help.tern.travel
Tip: Tern offers hands-on migration assistance for agencies and larger hosts. If you have a high booking volume, ask them about a guided export before you start.
TESS has no single "export everything" button. Data is spread across a few separate export areas, and trip/booking history requires contacting TESS support directly.
Client list:
client.export.date.MM.DD.YYYY.xlsx — first, middle and last name, birth date, telephone, email, the address block, and Agent Name⚠️ This export does not include passport data or anniversaries, despite being the file most people assume carries everything. It is thirteen columns. Passport numbers have to come from the bookings workbook you request from TESS support, or be re-entered.
Commission data (Agency Admin only):
⚠️ Checks Paid carries no booking number, so it can total what you were paid but cannot put commission against the trip that earned it. For commission that attaches to bookings, ask TESS for Rolling Commission Earned, which has a Booking Number column on every row.
Agent/user list (Agency Admin only):
There is no bulk export for trip or booking history. TESS offers custom reports on the Advanced plan, but these are built by TESS staff for you — not a self-serve report builder. There is also no documented way to export trip notes or client notes.
Email TESS support to request a full data export before migrating or canceling your account:
Subject: Data Export Request for Agency Migration
Hi TESS Support,
We are migrating our agency data to a new platform and need a complete export. We've already pulled our client list. Could you please provide:
- The Extended Booking Report, with the Trips, Bookings, Payments and Commissions tabs
- If that report isn't available on our plan: a single workbook with three tabs — bookings, payments (one row per payment), and client notes
- Rolling Commission Earned, so our commission history carries booking numbers
Please make these agency-wide rather than filtered to my login, with the Agent Name column included, and send in Excel format. Thank you.
🚨 Name the tabs you want, or you will not get them. That workbook is assembled by hand at TESS, and across four we've received, no two had the same tabs — one arrived with no payments tab at all. A vague "bookings report" request can cost you a week and come back without your payment history.
🚨 Ask for it agency-wide. Every TESS report is filtered to whoever is logged in, so an owner's export contains the owner's book and nobody else's. An agency-wide copy carries an Agent Name column, which lets each advisor's clients and sales be filed under their own name in one pass instead of queueing advisors up one at a time.
Contact: support@travelesolutions.com
Important: TESS deletes account data upon cancellation. Export everything before you cancel.
Your templates, forms and task lists are not in any of this, and they do not need to be. They come over by paste or by link, see Your templates, forms and task lists come with you below.
Everything you need to rebuild your trips, invoices and commission history in JourneyFuse is self-serve, in two reports you can pull today. Start there rather than with a support request.
Do not wait on a full data export from TravelJoy support. Advisors who ask are being told the export cannot be produced and that trips have to be downloaded one at a time. You do not need it. The Commissions and Sales report below carries the same trips, invoices, suppliers, dates and amounts, and it is a report you can run yourself in a couple of minutes.
Step 1 — Clients (self-serve):
The file downloads as traveljoy_clients.csv and it is genuinely rich — 46 columns covering passport, birthday, wedding anniversary, notes, tags, and your travel preferences (seat, bed, meal, hotel, vibe and activity). It maps straight into JourneyFuse's client import, so it is worth pulling even if you have already typed some clients in by hand, because re-uploading it fills in the fields that were blank.
What's NOT included in the client export: trip and booking details, invoices, payment records, notes on trips, and activity history. Those come from the report in step 2.
Step 2 — Trips, invoices and commissions (self-serve):
Run TravelJoy's Commissions and Sales report and export it twice, because the two views carry different things and we use both:
That pair rebuilt one advisor's entire TravelJoy history: 46 trips, 90 bookings and 45 commissions, reconciling to the penny against their own export.
Save it as CSV or Excel, not PDF. The detailed view is a very wide table, and printing it to PDF slices the columns into separate strips stacked down the page, so the file opens looking like a two-column list of names with none of your dates, suppliers or amounts. The data is still in there, but not in a form anything can read back reliably. Our importer accepts
.csv,.xlsxand.xls.
Step 3 — What no TravelJoy export carries:
Notes, activity history, documents and proposals have no bulk export. Group booking pages do not export either, but a live one is readable from its public link, so send us the link rather than rebuilding it. If a handful of trips hold detail that matters and is nowhere in the reports, download just those and send them over. There is no need to do that trip by trip for your whole account.
Ask anyway, if you have time before cancelling. It costs one email and occasionally produces something useful. Treat it as a bonus rather than the plan, and never delay cancelling or migrating while you wait on it:
Subject: Complete Data Export Before Account Cancellation
Hi TravelJoy team,
I'm preparing to migrate to a new platform. I've already exported my client list and my Commissions and Sales report. I'd like to request whatever you can provide of: (1) all trips and bookings with client associations, supplier names, travel dates, and amounts, (2) all invoices and payment records, (3) any client notes or activity history.
Please send to [your email]. I'll cancel my subscription after confirming the data was received.
Contact: hello@traveljoy.com
Step 4 — Load it yourself, or send it to us:
Owners, admins and advisors can run this without a support ticket (an advisor's import files everything under them). Go to Settings → Data Import and open the TravelJoy importer, or go straight to /imports/traveljoy. Drop both exports in, in either order and under whatever name your browser gave them, and you get a per-trip preview before a single row is written. Check those totals against what TravelJoy shows you, then import.
A few things worth knowing about how it lands:
<Client>'s Trip, and one client's name covers several unrelated trips, so grouping on it would fold a client's whole history into one row. Trips TravelJoy never really named come across dated instead, like "Emma Nix — March 2027".Or send it to us and stop there. Open a migration request and attach your client export and both versions of the Commissions and Sales report — or reply to the ticket email with them. Your ticket becomes a migration dashboard showing what we found and your Approve button, and our team runs the import. Either way, do not load supplier confirmations one at a time while you wait. Those come across with the rest.
No TravelJoy export carries your templates or task lists. They are in neither report, and they are not in anything TravelJoy support can send you. That is worth knowing before you spend an evening looking for the button. You do not have to rebuild them by hand, though, because they come over by paste — see Your templates, forms and task lists come with you below.
Travefy has a self-serve contact export. There is no bulk export of your itineraries, and asking support for one will not produce one — Travefy has confirmed in writing that trip and itinerary content cannot be exported. Your trips are still recoverable, one link at a time, and JourneyFuse reads them directly.
Your bookings and commissions do export, even though your itineraries don't. Travefy's bookings export carries booking reference, confirmation number, booking amount, your expected and already received commission, the commission split, traveler name and email, supplier, travel and booking dates, the date each commission is expected to be paid, trip name, status and payout name.
JourneyFuse reads that file directly. Go to Commissions → Quick Add → Import commissions (CSV) and upload it — the columns map themselves, including the received-commission and payout columns, so your banked commission arrives as banked rather than as a pile of zeroes. No support ticket needed.
Your ExpectedOn dates come with them. That is the date each supplier is due to pay you, and it is what JourneyFuse counts "days overdue" from — so anything Travefy already had marked Overdue arrives here already flagged, rather than looking current until the trip travels.
One thing about that file is still worth knowing before you send it: the trip name column is usually empty, even though it exists, so the bookings arrive as commission records rather than attached to the trips you import in Step 2 — we match them up by traveller and travel date.
If your Travefy account has no bookings export, the feature may not be switched on for your plan. Send us whatever you can get and we will work from that.
Step 1 — Contacts (self-serve):
The export is eleven columns: first and last name, email, phone, address, labels, birthday, anniversary, who created the contact, and the created and last-updated dates. It maps straight into JourneyFuse's client import.
There is no passport data in this export, and no notes. Notes have no second route.
Passport data has a second route, and it works. In Travefy, open the Contacts tab, turn the passport columns on, and use Export Current View. Confirmed 3 September 2026 by an advisor who moved 59 contacts that way: passport number, expiry date, issue date, country of issue and nationality all came across for the travelers who had them filled in. Full name as printed on the passport, gender and place of birth are not in that file, so those still come from a passport scan or from re-entry.
Two things to expect. The passport columns usually match on their own, but some Travefy exports write the headings without spaces, and those can arrive unmatched on the import screen. If that happens, pick the JourneyFuse field for each of them from the dropdown once. And where a passport was scanned into Travefy rather than typed in by hand, the number column can carry the whole machine-readable strip from the bottom of the passport instead of just the number. The real number is the first nine characters, so it is worth a glance down that column before you import.
Step 2 — Trips (paste the share link):
Every Travefy trip you have shared with a client has a share link, and JourneyFuse reads the full itinerary out of it — days, flights, hotels, times, timezones, confirmation numbers and prices — along with who is travelling.
travefy.com/trip/itinerary/… (what the Share dialog gives you to send a client) or travefy.com/trip/…The travelers come across with the trip. The share link names everyone on it, and when you add the imported itinerary JourneyFuse puts each of them on the trip's travel party — the trip's client first, then every co-traveler it can match to a client in your account. Travefy only shares a first name and a last initial (“Kate G”, never “Kate Green”), so a traveler is added only when exactly one of your clients answers to that name. Anyone it cannot place, or could place two ways, is named in a message after the import rather than guessed, and you add them from the trip's Travel Party card. Import your Travefy contacts in Step 1 first, so the names have someone to land on.
Confirmation numbers and prices land on the matching itinerary block — open a hotel or flight in the itinerary to see them.
If your trips live on your own web address, paste those links as they are. Travefy serves trip pages under an advisor's own domain, so your links may read trips.youragency.com/trip/itinerary/… rather than travefy.com. Those work the same way and need no editing. Do not try to rewrite them back to a travefy.com address — the two carry different codes and a hand-edited link will not open.
If a trip has never been shared, turn sharing on in Travefy first — an unshared trip is not readable from the link. A per-trip PDF export works too if you would rather send those.
Step 3 — Commission history: the bookings export above, loaded through importing commissions from CSV. If your account has no such export, commission history comes from your host agency or your own records instead.
What Travefy genuinely cannot give you is day-by-day itinerary content in bulk, and notes on contacts. The itineraries come back through the share links in Step 2; notes have to be re-entered.
Send us the links and we'll do it. Open a migration request and paste your Travefy trip links into it — or reply to the ticket email with them — and our team will rebuild the trips, attach the right clients, and record prior payments so your balances are right from day one. You do not have to do this trip by trip yourself.
Your templates, forms and task lists are not in any of this, and they do not need to be. They come over by paste or by link, see Your templates, forms and task lists come with you below.
ClientBase is one of the most commonly used legacy platforms, and also one of the most complex to export from. The self-serve tools cover client profiles but not booking history (Res Cards) — for a full export you'll likely need professional help.
Self-serve export — ClientBase Windows:
Self-serve export — ClientBase Online:
What CAN be exported via self-serve: client names, addresses, phone numbers, email, traveler info (passport numbers, etc.)
What CANNOT be exported via self-serve: Res Cards (booking history), travel history, activity history, and notes with full fidelity.
For a full migration including booking history, contact Tres Technologies and ask about their Tres Certified Consultants (TCCs) — independent specialists who perform full database extractions:
Subject: Data Migration Export — Full Database Extract Needed
Hi Tres Technologies support,
We are migrating our agency from ClientBase [Windows / Online] and Trams Back Office to a new platform and need a complete export of: (1) all client profiles with contact info, traveler data, and custom fields, (2) all Res Cards and booking history, (3) Trams Back Office transaction history, commission records, and financial data, (4) activity and notes history.
We understand a Tres Certified Consultant may be needed for the full Res Card and booking history extraction. Could you recommend a TCC with migration experience?
Contact: support@trestechnologies.com
Your templates, forms and task lists are not in any of this, and they do not need to be. They come over by paste or by link, see Your templates, forms and task lists come with you below.
PIE has the most complete self-serve export of any platform on this page. Both files come out of the export area as Excel, and between them they carry nearly everything JourneyFuse needs.
Reservations (PIE_All_Reservations_<date>_Export.xlsx) — 28 columns, and unusually it includes both a start and an end date:
Confirmation #, Booked Date, Booking Supplier, Advisor Name, Client Name, Client Email, Trip Code, Trip Name, Reservation Category and Sub Category, Reservation Title, Destination, Supplier with email/phone/address, Start Date and End Date, Reservation Status, Payment Status, Payment Due Date, Payment to Supplier Status, Total Price, Total Net, Total Commission, Commission Received, and Commission %.
That is enough to rebuild trips with real date ranges, correct balances, and commission that attaches to the right booking — no support request needed.
CRM contacts (PIE_CRM_Contacts_<date>_Export.xlsx) — 126 columns, including passport and visa details, emergency contacts (primary and secondary), billing address, special requests, full travel preferences (air, accommodation, cruise, pace, interests), and ten loyalty program slots.
Send both and there is very little left to do by hand. The one thing to watch: the contacts export is wide enough that some spreadsheet tools truncate it, so send the file as PIE produced it rather than re-saving it.
Your templates, forms and task lists are not in any of this, and they do not need to be. They come over by paste or by link, see Your templates, forms and task lists come with you below.
TravelWorks is primarily a back-office accounting system. Exports are available through their reports module.
Dolphin is an enterprise mid/back-office system with 60+ built-in report types. Contact your account manager or email info@dolphind.com to request a data migration export.
For Sabre Agency Manager (SAM), log a case through the Sabre Hub at sabre.com/support-agencies/ or call 1-877-367-2269 and ask for the Agency Migration team. Request: client profile export, booking history, and commission data. Sabre offers a complimentary profile migration service for agencies transitioning off SAM.
Your templates, forms and task lists are not in any of this, and they do not need to be. They come over by paste or by link, see Your templates, forms and task lists come with you below.
No platform on this page exports your email templates, your forms, or your task lists as a file. Not Tern, not TESS, not TravelJoy, not Travefy, not ClientBase, not PIE. They are in none of the exports above and they are not in anything the vendor's support team can send you, so it is worth knowing that before you spend an evening looking for the button.
You do not have to retype any of it. All three come over by paste or by link, and much of it is already in your account:
[First Name], {{first_name}} or <<Client>> are matched to the JourneyFuse merge field that fills them in when the email sends. Paste one template or paste a document holding all of them, separated by a line of dashes or a "Subject:" line, and each one comes back as its own template with a tick box for the ones to keep. Screenshots and PDFs work too, up to ten at a time. Nothing saves until you have reviewed it, and nothing you save sends itself.traveljoy.com/share/questionnaire_templates/… link. Every question comes across with its type, its choices and whether it was required, and a form TravelJoy asked clients to sign arrives with a signature field on it.Or send it to us. Attach your templates, checklists and form links to your migration request — or email them to hello@journeyfuse.com — and our team will load them for you alongside the rest of your data.
Once you have your CSV file(s), the easiest path is to open a migration request and attach them (replying to the ticket email with the files works too) — our team handles the import, and the ticket becomes a dashboard where you review the plan and approve it before anything lands. Or bring your clients and leads in yourself with JourneyFuse's import tool:
See Importing Clients & Leads from CSV for full details on the import process, supported fields, and how to handle duplicates.
If you kept your bookings in a spreadsheet, or your old platform's export leaves out something you need (TravelJoy's has no status column, so a cancelled trip looks live), bring the sheet itself. Go to Settings → Data Import and choose Your own spreadsheet, or go straight to /imports/spreadsheet. Owners, admins and advisors can all run it, and an advisor's import files everything under their own name.
Understand the relationship between trips, bookings, and commissions in JourneyFuse.
Search help articles from the command palette and read them in a side panel without leaving your work.
A step-by-step guide from creating your first trip to collecting commission — the complete advisor workflow.