Bookings report

Prev Next

Plan for the days ahead and follow up unpaid bookings by checking every booking for the dates you choose. For each booking, the report shows when guests are coming, how many are expected, what the booking is worth and how much is still owing. The Unpaid total at the top shows what's still to collect across those bookings.

The permission required to open the Bookings report is Can access Sales reports. The administrator and manager roles have this permission enabled by default. Staff with Can view bookings can also open it. The administrator, manager and booking agent roles have that permission by default.

Open the report

The Bookings report sits in the Sales section of All reports. If you use it often, select the star icon next to it to add it to Favorite reports at the top of the page.

  1. From Venue Manager, go to Reports > All reports.

  2. Search for and select Bookings.

Filter the report

Narrow the report to the bookings you need to act on (eg tomorrow's bookings that aren't canceled).

Filter

What it does

Search

Find one booking by its booking ID, or by the booking name or the booking holder's first or last name.

Date selector

Shows bookings by the date guests are booked to visit, not the date they paid. For a booking with items on more than one date, the report uses the earliest date.

Status

Shows bookings with one status, or a group of statuses. The options are in the next table.

After you change a filter, select Apply filters.

Status

Shows

All

Bookings with any status

All reserved

Bookings that aren't canceled or a venue draft: Pending, On Account, Complimentary, Partially Paid and Fully Paid

Pending

Bookings with no payment made yet, including tentative bookings waiting for payment before their hold ends

On Account

Reseller bookings charged to the reseller's account, with a balance still owing. You'll see these only if you have the advanced channel management add-on and take reseller bookings on account. To learn more, see the guide Get started with the reseller portal

Complimentary

Bookings that need no payment

Partially Paid

Bookings with part of the cost paid and a balance still owing

Fully Paid

Bookings paid in full, with nothing owing

Canceled

Canceled bookings

Venue Draft

Bookings saved as a draft in Venue Manager or started from a guest's form response. A draft doesn't hold capacity

To show more columns, group rows or download the report, see the guide Filter, customize and download a report.

What the report shows

The totals give you the headline for the dates you filtered. Each row under them is one booking you can open and act on.

Total

What it shows

Sales

The value of the filtered bookings, not counting complimentary bookings

Unpaid

The balance still owing across the filtered bookings

Tickets

The number of guests expected across the filtered bookings, counted the same way as Headcount

With Status set to All, canceled bookings count toward Sales and Tickets. To leave them out, select All reserved.

Columns marked (hidden) don't show until you add them. To add one, right-click the grid and select it.

Column

What it shows

Booking Date

The date guests are booked to visit (eg the Saturday of a birthday party booked three weeks earlier). For a product with no set visit date, it's the date the booking was made. For a pass valid a set number of days from redemption (eg a 7-day pass), it changes to the day the guest first redeems it

Session Time

The start time of the booking's session (eg 10:00 AM for a jump session). If the booking has sessions at different times, it shows the earliest

Booking Id

The booking's ID. Select it (eg to check a party's details before you call the host) to see the booking's details in a side panel, then select Go to booking to open it

Headcount

Guests expected, based on the passes and party packages in the booking. A party package counts the guests it includes plus any extra guests added (eg 12 for a 10-guest party with 2 extra guests)

Amount

The booking's total value (booking items less any discounts), whether or not it's been paid. A $300 party with a $50 discount shows $250

Balance

What's still owing on the booking (eg $200 when a guest has paid a $50 deposit on a $250 party)

Status

The booking's status (eg Partially Paid for a party with a deposit paid). See the status table earlier in this guide

Booking Name

The name on the booking (eg Mia's 7th birthday). If no booking name was entered, it's the booking holder's name

Company (hidden)

The company, for a company booking (eg the school for a school group)

Contact Name (hidden)

The booking holder's first and last name, even when the booking has its own booking name (eg Sam Lee on a booking named Mia's 7th birthday)

Email (hidden)

The booking holder's email address (eg to send a reminder before the visit)

Mobile (hidden)

The booking holder's mobile number (eg to call or text a guest about an unpaid balance)

Channel (hidden)

Where the booking was made (eg POS for a walk-in, online checkout for a guest booking on your website or Venue Manager for a phone booking)

Transaction Date

The date and time the booking was made, in your venue's time zone (eg 8:14 PM on 3 October, for a party on 25 October)

Referral Source (hidden)

Shows Google for bookings made through Google Things to Do (eg a guest who found your venue on Google Maps and booked from there)

Follow up on bookings with money owing

Bookings with a balance owing are money you haven't collected yet. Find them before the visit date and you can contact guests while there's still time.

  1. From Venue Manager, go to Reports > All reports, then search for and select Bookings.

  2. Select the date selector and choose the dates to check (eg Within the next... 7 days).

  3. In Status, select All reserved to leave out canceled bookings.

  4. Select Apply filters.

  5. Select the Balance column header to sort the bookings by what's still owing.

  6. Select a Booking Id, then select Go to booking to open the booking and follow up.

The Unpaid total shows the full amount still to collect for those dates.

Email the day's bookings to your team

Send each day's bookings to the people who prepare for them (eg party hosts or the kitchen), without anyone opening Venue Manager. Recipients don't need a ROLLER login. A scheduled report sends every booking and every column for the period. It doesn't keep your filters or the columns you hid.

To set one up, see the guide Email reports on a schedule.

FAQs

How is this report different from All bookings?

It shows the same bookings as Bookings > All bookings in Venue Manager, with totals for sales, unpaid balances and tickets at the top. To export bookings with the form data guests entered, use All bookings. To learn how, see the guide Manage bookings from All bookings in Venue Manager.

Why is Sales lower than the Amount column adds up to?

Sales leaves out complimentary bookings. Their value still shows in Amount for each booking.

What does Headcount count?

The guests expected, based on the passes and party packages in each booking. It's who's booked, not who arrived. To compare booked and redeemed guests for a day, see the guide Daily Summary report.

How do I leave canceled bookings out?

In Status, select All reserved, then select Apply filters.

Can I see which channel a booking was made in?

Yes. Add the Channel column: right-click the grid and select Channel.

Can I filter bookings by referral source?

The Referral Source column shows Google for bookings made through Google Things to Do. Add the column, then download the report and filter it in your spreadsheet.