Report 302: Bookings by Status and Value

Last updated 18 days ago

Overview

A comprehensive financial health report that shows the current status, total price, and payments received for bookings, with the ability to view data retrospectively ("As Of" a specific date).

Best Use Case

  • Month-End Reconciliation: Viewing the state of your booking ledger as it was on the last day of a previous month.

  • Agent vs. Guest Analysis: Splitting balances between what is owed by an agent and what is owed by a guest.

Available Filters

  • Parks: Multi-select parks.

  • Booking Made Date Range: Filters by when the booking was created.

  • Arrival Date Range: Filters by when the holiday takes place.

  • As Of Date: Allows you to see the data exactly as it was on that specific date.

  • Booking Statuses: Select specific statuses or "All".

  • Booking Sources: Filter by where the booking originated.

Key Data Logic

  • Amount Shown: Displays Full Cost, Total Paid, and Balance calculated for the "As Of" date.

  • Income Logic: Not pro-rated. Full holiday costs are used.

  • Product Source: Shows the product listed on the booking.

  • Agent Commission: Explicitly tracks agent-specific balances separately where applicable.

  • VAT: Included in the prices.

  • Extras: Included.

  • Owner Bookings: Excluded.

  • Booking Statuses: Flexible based on the state at the "As Of" date.

  • Assignment: Includes assigned and unallocated bookings.

  • Reporting Period: Not required.