Bookings report
Introduction
The bookings report provides all bookings and associated booking data throughout a date range.
How do I create a report?
- Select the 'Reports' icon on the navigation
- On the Booking reports panel, select a date range
- Under report type, select
Bookings - Select the properties you wish to be included
5 . Select 'Request report.' - 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
Updated about 1 year ago