One tour generates the most bookings. Another brings in more sales per departure. A third looks successful until cancellations and refunds are taken into account.

Which product is performing best?

The answer depends on what you measure and how you define it. Comparing booking totals alone can hide differences in group size, price, cancellations, and the number of departures offered.

For tour and activity operators, useful revenue reporting connects commercial results with what actually happens to reservations. It shows which products attract demand, how much of that demand remains, and where cancellations create operational work.

This guide explains how to track revenue and cancellations across tour products, calculate comparable metrics, and use the results to investigate performance.

1. Define What Your Revenue Report Measures

The word “revenue” is often used for several different figures in an operations dashboard.

A reservation’s original value, the amount a customer has paid, and the amount remaining after a refund are not necessarily the same.

Define the figures you want to track before comparing products.

MeasureWhat it tells youOriginal booking valueThe recorded value when the reservation was first confirmedCurrent booking valueThe value after recorded amendmentsPayments receivedMoney recorded as collectedRefunds issuedMoney recorded as returnedNet collectionsPayments received minus refunds issuedChannel fees or commissionsRecorded distribution costsDelivered activity salesSales associated with activities that have taken place, using your stated rules

These are operational reporting definitions. Keep them distinct from formal accounting revenue, which should follow your accounting policies.

Also state whether amounts include taxes, discounts, and optional extras. A report is difficult to interpret if different products use different treatments.

RebridPro helps tour and experience providers organize bookings, tasks, staff, resources, availability, weather checks, and analytics. Consistent booking and product records provide the foundation for meaningful performance reporting.

2. Choose the Right Date for the Question

A booking can involve several relevant dates:

• Reservation creation.

• Activity departure.

• Cancellation.

• Payment.

• Refund.

Each supports a different analysis.

Booking-Date Reporting

Use the booking creation date to understand when customers are purchasing.

This can help you examine demand patterns and the effect of sales activity.

Departure-Date Reporting

Use the activity date to compare the tours scheduled or delivered during a period.

This is useful when reviewing product performance alongside staffing, resource use, and operating conditions.

Cancellation-Date Reporting

Use the cancellation date to understand when cancellation work and lost reservations occur.

Payment-Date Reporting

Use payment and refund dates to examine recorded money movements.

Keep these views clearly labeled. Cancellations processed in July may relate to tours in August, while July payments may include reservations for several future months.

3. Create Consistent Product Records

The same tour may appear under different names across your website, marketplaces, and reseller arrangements.

Map those listings to consistent internal products before comparing results.

Useful product fields include:

• Internal product identifier.

• Activity name.

• Shared or private format.

• Duration.

• Location.

• Relevant options.

• External listing identifiers.

Do not combine products merely because their names are similar.

A private excursion with transport and a shared walking tour may follow a similar route but have very different pricing and delivery requirements.

Decide How to Handle Variants

You may want to report a product family together while retaining detail for individual variants.

For example, a city tour could have several languages or a pickup option.

Use a structure that allows you to see both the overall product and the differences that affect its performance.

4. Keep Cancellations in the Dataset

Deleting cancelled reservations removes information needed to understand demand.

Retain the cancelled record with its original product, departure, participant count, value, and cancellation details where available.

A useful cancellation record includes:

• Booking reference.

• Product.

• Intended departure.

• Cancellation date.

• Initiating party.

• Reason.

• Number of affected participants.

• Full or partial cancellation.

• Related financial adjustment.

Preserve the link between the booking and any refund without treating the two as identical events.

A cancellation does not always produce an immediate refund, and a refund can occur without a full cancellation.

5. Distinguish Cancellations from Rescheduling

A customer moving to another date is different from a customer leaving the business entirely.

Your reporting should identify transfers between departures so that a reschedule does not automatically appear as both lost demand and a completely new sale.

Where your system creates a replacement booking, retain the relationship between the original and replacement records.

Track separate outcomes such as:

• Completed activity.

• Active future booking.

• Rescheduled booking.

• Full cancellation.

• Partial cancellation.

• No-show.

This helps you understand whether demand disappeared, moved, or remained unresolved.

6. Track Booking and Participant Cancellation Rates

Booking counts and participant counts answer different questions.

Booking Cancellation Rate

Cancelled bookings ÷ All bookings in the defined reporting group × 100

If twenty of two hundred bookings are cancelled, the booking cancellation rate is 10%.

Define how partially cancelled reservations are treated. One useful approach is to report full cancellations and partial changes separately.

Participant Cancellation Rate

Cancelled participant places ÷ Originally reserved participant places in the same group × 100

This shows how much participant demand was removed.

A single cancelled group reservation can affect many more places than several cancelled solo bookings.

Use a Consistent Reporting Group

For example, review all reservations associated with departures in September and assess their final status after the period has closed.

Avoid dividing cancellations recorded this month by bookings created this month unless you specifically intend to measure that relationship. Those populations may contain different reservations.

7. Measure Cancelled Booking Value Separately

Cancelled booking value helps show the sales value associated with cancelled reservations.

It is not automatically equal to refunded money or final revenue loss.

A cancelled place may be resold. Some cancellations may involve retained charges. A partial cancellation may reduce the booking value without removing the whole reservation.

Track the relevant figures separately:

• Value removed through cancellation.

• Refund amount.

• Retained amount, where applicable.

• Subsequent sales for the affected departure.

Be Careful When Estimating Lost Revenue

Suppose a €100 reservation is cancelled and the released places are later sold for €120.

The cancellation still occurred, but the departure did not necessarily lose €100 in final sales.

To understand the result, review both the cancellation event and the departure’s eventual performance. Avoid automatically labeling every cancelled booking value as permanent revenue loss.

8. Compare Revenue per Participant and per Departure

Total sales can favor products that operate more often.

Add measures that account for the scale of delivery.

Revenue per Participant

Defined sales amount ÷ Corresponding participant count

This helps explain pricing and product mix.

Use matching populations. Do not divide sales from delivered tours by all future booked participants.

Revenue per Operated Departure

Defined delivered activity sales ÷ Number of operated departures

This helps compare the average sales associated with each run.

Track cancelled departures separately so they do not disappear from the operational picture.

How to Interpret the Results

A product with high sales per departure may require more staff or expensive resources. These revenue measures do not establish profitability.

Use them to identify questions for further review, then examine relevant delivery costs.

9. Record Cancellation Reasons Consistently

Free-text notes can provide useful detail, but structured categories make comparison easier.

Possible categories include:

• Customer change of plans.

• Customer travel disruption.

• Weather or operating conditions.

• Operator staffing issue.

• Vehicle or equipment issue.

• Supplier unavailability.

• Insufficient participation.

• Duplicate or mistaken booking.

• Reason unknown.

Record who initiated the cancellation separately from why it happened.

For example, the operator may process a cancellation requested by the customer. The person clicking the cancellation button is not necessarily the initiating party.

Keep “Unknown” as a Valid Category

Do not force staff to guess.

A visible unknown category shows where data is incomplete. Invented reasons make the report look more precise while reducing its usefulness.

10. Track How Close to Departure Cancellations Occur

Cancellation timing affects the opportunity to refill places and adjust preparation.

Measure the interval between cancellation and the scheduled activity.

Useful categories might include:

• Same-day cancellation.

• One to two days before.

• Three to seven days before.

• More than a week before.

Choose intervals appropriate to your booking patterns.

Connect Timing with Operational Impact

An early cancellation may allow the team to release a resource or resell capacity.

A late cancellation may arrive after equipment is prepared or external transport is confirmed.

Record relevant operational consequences where practical, such as unnecessary supplier commitments or additional rescheduling work.

11. Compare Products Across the Same Period and Conditions

Product comparisons need context.

Consider:

• Number of departures offered.

• Sellable capacity.

• Season.

• Departure times.

• Private versus shared format.

• Sales-channel mix.

• Price changes.

• Booking lead time.

• Weather disruption.

A seasonal outdoor tour and a year-round indoor workshop may have very different cancellation patterns.

Also show the underlying counts. A 20% cancellation rate based on five bookings represents one cancellation. The same percentage across five hundred bookings represents a much larger body of evidence.

An Illustrative Product Comparison

Consider two fictional products operating during the same reporting period.

The following example uses a simplified dataset with no partial cancellations or reschedules.

MeasureRiverside WalkCoastal ExcursionTotal bookings in the departure-period group200120Fully cancelled bookings2018Booking cancellation rate10%15%Delivered activity sales€9,000€14,400Operated departures3024Sales per operated departure€300€600Main recorded cancellation reasonCustomer plans changedWeather

The coastal excursion has fewer bookings, a higher cancellation rate, and higher sales per operated departure.

That does not establish which product is more profitable or easier to operate.

The next questions are practical:

• What does each departure cost to deliver?

• How many weather-related cancellations were rescheduled?

• Could cancelled places be resold?

• Were cancellations concentrated in a particular month or time slot?

• Did the coastal excursion require more external resources?

A useful report leads to those questions rather than declaring a winner from one figure.

12. Build Separate Views for Daily Action and Product Review

Your operations team and business review need different levels of detail.

Daily Cancellation View

Show recent cancellations, affected departures, resources needing review, customer follow-up, and unresolved financial actions.

Weekly Product View

Show participant changes, departure occupancy, cancellation reasons, and recurring operational disruptions.

Monthly or Seasonal View

Compare product sales, revenue per departure, cancellation patterns, channel mix, and relevant delivery costs.

Keep the reports connected to consistent underlying records.

RebridPro’s tour operations platform helps organize bookings alongside staff, resources, tasks, and analytics. That operational context can help explain why a cancellation affected more than the reservation itself.

Data Checks Before Trusting the Report

Review a small sample of bookings against their original records.

Check that:

• Products are mapped correctly.

• Cancelled bookings remain identifiable.

• Partial cancellations are handled consistently.

• Rescheduled bookings are linked.

• Payments and refunds are not duplicated.

• Dates use the intended time zone.

• Currency treatment is consistent.

• Reporting cutoffs are visible.

If multiple currencies are involved, state the conversion method and date used. Do not add different currencies together as if they were the same unit.

Also identify missing data explicitly. An unknown refund amount should not silently become zero.

How to Use the Findings

Choose actions based on the pattern you have identified.

Frequent Early Customer Cancellations

Review booking lead times, product descriptions, and customer questions to understand whether expectations are clear.

Repeated Weather-Related Cancellations

Review affected dates and departures, the rescheduling process, and how resources are reassigned.

Operator-Caused Cancellations

Investigate staffing, equipment, supplier, or capacity-planning issues.

High Sales with Heavy Operational Effort

Examine preparation time, external resource costs, and manual coordination before concluding that the product is performing well.

Strong Demand in a Few Departure Slots

Review whether additional capacity or a schedule adjustment is operationally feasible.

Document the change you make and compare subsequent results using the same definitions.

Common Reporting Mistakes

Mixing Booking Dates and Departure Dates

Choose the date that answers the question and label it.

Treating Every Cancellation as a Refund

Track reservation status and financial movements separately.

Deleting Cancelled Reservations

Preserve the history needed for analysis.

Counting Reschedules as Entirely New Demand

Retain the relationship between original and replacement bookings.

Comparing Total Revenue Alone

Include departures, participants, capacity, and relevant costs.

Reporting Percentages Without Counts

Show the size of the underlying dataset.

Assuming Revenue Equals Profit

Review the costs associated with delivering the activity before drawing profitability conclusions.

Frequently Asked Questions

What is the best way to compare revenue across tour products?

Use a consistent sales definition and reporting period, then review total sales alongside participants, operated departures, cancellations, and relevant delivery costs.

Should refunds be included in cancellation reporting?

Show them alongside cancellations, but keep them as a separate measure. Their amounts and dates may differ from the cancelled reservation’s value and timing.

How should partial cancellations be tracked?

Record the affected participant places and value adjustments while preserving the remaining active reservation. Define whether the booking appears in a separate partial-cancellation category.

What is a good cancellation rate for tours?

There is no universal rate suitable for every activity. Compare your own products and similar operating periods, then investigate reasons and operational impact.

Should rescheduled bookings count as cancellations?

Report them separately where possible. A reschedule may release one departure’s capacity while preserving the customer’s booking elsewhere.

Can RebridPro produce these reports?

RebridPro includes analytics within its operational scope. Confirm which measures, breakdowns, exports, and calculations are available in your intended setup before designing your reporting process around them.

Understand What Your Product Results Are Telling You

Revenue and cancellation reporting becomes useful when the definitions are consistent and the records preserve what happened.

Separate booking value from money movements, distinguish cancellations from reschedules, and compare products using the same time basis. Review the operational causes behind the figures before deciding what to change.

Explore RebridPro to organize your bookings, staff, resources, tasks, and analytics, and build a clearer view of performance across your tour products.