Export
Export booking data, discounts, and costs to Excel (XLSX) in Tourpaq Office. Filter by booking/departure periods, include cancelled or moved bookings, and manage scheduled exports.
Overview
The Export module allows users to extract operational and financial data from the system into external files for reporting, supplier communication, integrations, or offline processing.
Exports typically include:
bookings and passengers
hotel and rooming lists
transport and transfers
guides and operational data
financial or reporting datasets
Exports are used both internally (analysis, reporting) and externally (suppliers, partners, accounting systems).
Business Context
In a tour operator environment, large volumes of data must be shared across stakeholders:
suppliers need arrival and rooming lists
guides need passenger lists
finance teams need structured datasets
management needs reporting extracts
Manual data extraction leads to:
inconsistencies
outdated information
operational delays
The Export module ensures:
standardized data output
repeatable export formats
alignment between system data and external processes
When to Use
Use Export when:
data must be shared externally (supplier, guide, partner)
reporting is required outside the system
integrations require structured files
operational teams need lists (arrival, pax, etc.)
Do NOT use when:
real-time access is available (use dashboards instead)
data is incomplete or not validated
exports are used as a workaround for missing configuration
Export types
There are three export types available:
Export Type
Description
Bookings (XLSX)
Exports all bookings within the selected booking or departure period, including general booking details.
Discounts (XLSX)
Exports information related to discounts applied to bookings. Useful for financial reconciliation and promotion analysis.
Cost (XLSX)
Exports all costs associated with bookings, including Creditor information. This report is typically used for cost control, supplier invoicing, and financial overview.
Fields and filters
Field
Description
Export Type
Selects which type of data to export: Bookings, Discounts, or Cost.
Booking start / Booking end
Defines the range based on the booking creation date. Only bookings created between these dates are included.
Departure start / Departure end
Filters bookings based on the departure date. Only bookings departing within this range are included.
Include Cancelled Bookings and Details
When enabled, cancelled bookings and their related details will also be included in the export.
Include Moved Bookings and Details
Includes bookings that were moved to a different departure or travel period, along with their updated details.
Include past bookings with changes in the departure period
Include bookings where edits were made after departure, as long as the change date falls within the selected departure period. Available for Bookings and Cost exports. Not available for Discounts exports.
More filters
Expands additional filtering options (if available).
Clear
Resets all filters and date selections.
Buttons and actions
Button
Description
Export
Generates the export file based on the selected filters and export type. The exported file is downloaded in .XLSX format.
Show Schedules
Displays a list of all previously generated or scheduled exports. From here, users can monitor progress or re-download files.
For recurring exports, see Export - Scheduled Reports.
Example Scenario
Scenario: Export booking and cost data for bookings created in September and October 2025, including changes after departure.
Set Export Type → Bookings (XLSX) or Cost (XLSX).
Define Booking start and Booking end dates (e.g., 23-09-2025 to 23-10-2025).
(Optional) Define Departure start and Departure end.
Enable Include past bookings with changes in the departure period to capture all post-departure updates.
Enable or disable Cancelled and Moved bookings as needed.
Click Export to generate the report.
Use Show Schedules to view or download previous exports.
Export file columns
The data will contain information regarding each booking that corresponds to the given filters:
Booking number - A unique identifier assigned to each booking.
Adults number - The total number of adults included in the booking.
Children number - The number of children included in the booking.
Infants number - The number of infants included in the booking.
Seats - The number of seats reserved for the booking.
Booking date - The date when the booking was created.
Booking status - The current status of the booking (e.g., Confirmed, Cancelled, Pending).
Booking total price - The total price paid for the booking, including all products and services.
Customer No - The customer number.
Customer name - Name of the customer.
Customer email - The primary email address of the customer.
Seller - The individual or platform that made the booking.
Agent - The travel agent or representative involved in the booking, if any.
Transport code - A code identifying the mode or provider of transport.
Travel length - The total duration of the trip in days.
Hotel code - A code representing the booked hotel.
Resort code - A code identifying the resort associated with the hotel.
Destination - The booking destination of the travelers.
Room code - A code for the specific room type booked.
Room price - The cost of the room per booking or per night, depending on context.
Rooms number - The number of rooms included in the booking.
Gender - The gender of the passenger.
Age - The age of the passenger at the time of travel.
First name - Passenger’s first name.
Last name - Passenger’s last name.
Passenger’s status - The role or status of the passenger.
Customer postcode - Postal code of the customer’s address.
Customer fax - Fax number provided by the customer.
Customer phone number - Contact phone number of the customer.
Customer CPR - The customer’s CPR (civil registration number or ID, depending on locale).
Customer city - The city in which the customer resides.
Customer address - The full street address of the customer.
Has cancellation insurance - Indicates whether cancellation insurance was purchased (Yes/No).
Cancellation insurance price - The cost of the cancellation insurance.
Has transfer - Indicates whether a transfer service (e.g., airport shuttle) is included.
Transfer price - The price paid for transfer services.
Travel insurance type - The type or tier of travel insurance selected.
Travel insurance price - The price of the travel insurance policy.
VIP product - Specifies if a VIP product or service was included.
VIP product price - The cost associated with the VIP product.
Party package product - Indicates if a party package was added to the booking.
Party package product price - The price of the party package product.
Pension product - Describes whether a pension/meal plan product was booked.
Pension product price - The price for the pension product.
Catering product - Shows if a catering or food service product was included.
Catering product price - The cost of the catering product.
Car product - Indicates if a rental car or car-related product was booked.
Car product price - The total price for the car product.
Extra bed discount - Discount applied for an extra bed, if applicable.
Cancellation fee - Any fee charged for cancelling the booking.
Passenger total price - The total price assigned to a specific passenger.
Departure date - The date of departure from the origin location.
Arrival home date - The date the traveler returns home.
Discounts/Supplements - Any discounts or additional charges applied.
Other products - Additional products included in the booking not listed above.
Transport costs - Total costs related to transportation.
Transfer cost - Total cost for transfer services.
VIP cost - Total cost for VIP services.
Party package cost - Total cost for party package.
Pension cost - Total cost for pension/meal plan.
Catering cost - Total cost for catering or food service.
Car cost - Total cost of car rental or car services.
Other products cost - Cumulative cost of all other additional products.
Insurance cost - Total cost of all types of insurance (travel, cancellation, etc.).
Discounts/Supplements cost - Total value of discounts and supplements applied.
Hotel cost - Total cost paid for the hotel accommodation.
Best Practices
Always validate filters before export
Use consistent export formats across teams
Avoid manual editing of exported data
Archive exports for audit purposes
Align exports with operational workflows
Last updated
Was this helpful?