Report 355: Summary of Bookings By Product

Last updated 18 days ago

Overview

This report provides a high-level summary of booking volume and revenue broken down by specific Booking Products (e.g., specific van grades, touring types, or hire units). It is the primary tool for understanding which types of accommodation are most popular and how much revenue they are generating.

Best Use Case

  • Product Performance: Comparing the popularity and revenue of different accommodation types (e.g., Bronze vs. Gold vans).

  • Trend Analysis: Evaluating if marketing efforts are driving bookings for specific products during a specific booking window.

  • Inventory Review: Identifying products that exist in the system but have zero bookings (using the "Show All" filter).

Available Filters

  • Parks: Run for one, several, or all parks.

  • Booking Made Date Range: Filters based on the date the booking was created.

  • Arrival Date Range: Filters based on the date the holiday begins.

  • Product Types: Multi-select filter for categories like "Hire," "Touring," etc.

  • VAT Toggle: A specific switch to run the report as either VAT inclusive or exclusive.

  • Show All Products: If ticked, the report lists every product in your setup, even those with zero bookings.

Key Data Logic

  • Amount Shown: This report displays the Total Price of the Break. It represents the invoiced value of the booking product, not the payments received so far or outstanding balances.

  • Income Logic: Revenue is not pro-rated. The whole break price is included in the totals if the booking’s arrival date falls within your selected date range.

  • Date Range Logic: This report uses a dual filter. A booking must fall within both the "Booking Made" range and the "Arrival" range to be included.

  • Product Source: It shows the product listed on the booking itself. It does not look at the product linked to an assigned unit, making it accurate for tracking revenue even on unallocated bookings.

  • Agent Commission: Amounts include agent commission. The report shows the gross price charged to the guest/agent; it does not deduct commission costs.

  • VAT: Selectable. You can choose to see figures Inclusive or Exclusive of VAT at the point of running the report.

  • Extras: This report is focused on the core product (accommodation/pitch) and excludes miscellaneous booking extras like pets, linen, or credit card fees.

  • Owner Bookings: These are included as long as they are processed as bookings with a valid account ID and a product price.

  • Booking Statuses: Includes all active and confirmed bookings but excludes Cancelled bookings (Status 9).

  • Assignment: The booking does not need to be assigned to a specific unit or pitch; it counts all bookings where the product is selected.

  • Reporting Period: A pre-defined financial reporting period is not required; the report runs purely based on the calendar dates you enter.

  • Occupancy Logic: This report focuses on Booking Volume (count of bookings) rather than occupancy percentages. It does not compare bookings against physical unit capacity or allocations.