Bookings report

Introduction

The bookings report provides all bookings and associated booking data throughout a date range.

How do I create a report?

  1. Select the 'Reports' icon on the navigation
  2. On the Booking reports panel, select a date range
  3. Under report type, select Bookings
  4. Select the properties you wish to be included
    5 . Select 'Request report.'
  5. The report will be sent to your email within a few minutes.

How can I filter my data?

You can filter your report exports by:

  • Date range
  • Listing
  • Include cancelled bookings true/false

📘

Your report will be emailed to your registered email address and downloadable as a CSV spreadsheet file.

Example bookings report

Below is a sample bookings report. Scroll left/right to see all columns.

What does each heading mean?

Header title

Meaning

Property ID

The Uplisting property ID

Property name

The Uplisting property nickname

Multi-unit name

If the property has Multi-units, this is the name of the unit

Booked at

Date and time the booking was created

Booking ID

The Uplisting booking ID

Check in

Check in date

Arrival time

Arrival time

Check out

Check out date

Departure time

Departure time

Number of nights

Number of nights guest is staying

Channel name

Booking site name (eg. Airbnb)

Booking source

Direct bookings can have a source which you manually select

Guest name

Guest name

Guest email

Guest email

Guest phone

Guest phone

Currency

Currency the booking was made in

Confirmation code

Airbnb or Booking.com confirmation code or booking ID

Number of guests

Number of guests booked

Accommodation total

The accommodation total is the sum of the night rates. This figure includes booking commission.

Cleaning fee

The cleaning fee if present

Extra guest charges

Any fees for extra guests specifically

Extra charges

The sum of any additional charges.

On Airbnb, charges include linen fee, management fee, etc.

On Booking.com extra charges include linen fee, service fee, etc.

Also included are any extra charges you add manually on a booking and upsells (a feature being released in future).

Discounts

Discounts applied to a booking. eg. weekly discount, or new listing discount on Airbnb.

Booking taxes

The sum of any taxes related to the booking.

On Booking.com, this could be the sum of the city tax and VAT for example.

Payment processing fee

This is the sum of any Stripe transaction fees

Commission

The booking site service fee/commission

Commission tax

Tax on the booking site commission

Total payout

This is the total amount earned for the booking.

It sums the accommodation total, extra guest charges and extra charges minus discounts, taxes, commission and payment processing fees.

Cancellation fee

Exclusive to Airbnb and Booking.com currently.

If your cancellation policy means you earn all or a portion of the booking value, this figure will be included here.

Accommodation management fee

This amount is calculated based on the accommodation total and the % accommodation management fees you have set.

Cleaning management fee

This amount is calculated based on the cleaning fee and the % cleaning management fees you have set.

Total management fee

This is the sum of the accommodation and cleaning management fees.

Note

Any notes you have added on a booking.

Status

Booking status can be confirmed or cancelled

How can reporting be used?

  • Client invoicing
  • Filter to an individual property monthly to quickly calculate client invoices.
  • Task scheduling and operations
  • Get a list of upcoming bookings to help plan cleaning, maintenance and welcomes.
  • Accounting
    Reports include price breakdown for all bookings. Work out your earnings and tax deductibles (cleaning, booking site commission).
  • Performance analysis
  • Nights sold
  • Average daily rate (per listing or client/portfolio)
  • Average nightly occupancy (per listing or per client/portfolio)
  • Average length of stay
  • Marketing
    Import your guest's details, including email and phone numbers, to your favourite marketing solution
  • Collect accessible records of:
  • guest lists
  • guest name, phone number and email address
  • number of guests
  • booking site confirmation code
    c

Did this page help you?