How to Pull Booking and Revenue Reports from Customer Booking Engines / Property Management Systems

Booking Revenue: The value of the reservations made in a given month, regardless of arrival date. This number will include the value of future stays.

Actual/Earned Revenue: The actualized earnings from reservations in a given month, typically for arrival dates within the date range.

B&B, Inn, Hotel, Resort, and Lodges Booking Engines

ThinkReservations

Booking Revenue

  1. Reports
  2. Reservations by Booking Date
  3. Put in your dates
  4. Group by: Month
  5. Click generate
  6. Pull the “Subtotal”

Actual/Earned Revenue

  1. Reports
  2. Revenue by Room
  3. Put in your dates
  4. Click generate
  5. Pull the “Subtotal”

ResNexus

Booking Revenue

  1. Reports
  2. Reservations section
  3. Reservations reserved on
  4. Put in your dates
  5. Click update
  6. Pull the total amount

Actual/Earned Revenue

  1. Reports
  2. Reservations section
  3. Reservations by stay date
  4. Put in your dates
  5. Click update
  6. Pull the total revenue amount at the bottom of the table

Rezstream

Booking Revenue

  1. Reports
  2. Reservations
  3. Reservations by date made
  4. Put in your dates and click update report
  5. Pull Total Revenue (Pre-tax)

Windsurfer

Booking Revenue

  1. Report
  2. Summary
  3. Click the Monthly tab
  4. Input the following:
    1. Source = All Reservation
    2. Date Type = Book Date
    3. From = 1st of the month that you’re pulling booking revenue for
    4. To = Last day of the month that you’re pulling booking revenue for
  5. Click Search
  6. Pull the Total

QuickSight Reports (Best Western/Hammondsport Hotel)

Booking Revenue

  1. Login to the Hotel Portal.
  2. Click “Hello (insert name)” in the top right-hand corner.
  3. Click MemberWeb.
  4. Click D.A.R.T.  – QuickSight and then click Reports
  5. Open the “RES – Advance Booking Pattern” dashboard.
  6. Navigate to the Booking Date tab.
  7. Select your Booking Start Date and Booking End Date.
  8. Select Revenue for “Reservations or Revenue”
  9. Scroll to the bottom to the “Table: Bookings by Days Out” section and use the total of the Total Revenue column as your Booking Revenue.

Cloudbeds

Booking Revenue

  1. Reservations
  2. In the Filter section, input your date range for Date Booked
  3. For Status, make sure only Confirmed, Confirmation Pending, In-House, and Checked Out are selected.
  4. Click Apply
  5. On the right side of the screen, click the tiny Export Reservations button next to the tiny printer icon.
  6. Click Export Reservations in the pop-up that appears.
  7. Open the Excel file that just downloaded
  8. The SUM of the Grand Total column is the Booking Revenue (you will need to calculate this using the SUM formula in Excel).

Actual/Earned Revenue

  1. Reservations
  2. In the Filter section, input your date range for Check in Date and Check out Date. This should be the same date range for both (i.e. 3/1/21-3/31/21 for both fields).
  3. For Status, make sure only Confirmed, Confirmation Pending, In-House, and Checked Out are selected.
  4. Click Apply
  5. On the right side of the screen, click the tiny Export Reservations button next to the tiny printer icon.
  6. Click Export Reservations in the pop-up that appears.
  7. Open the Excel file that just downloaded
  8. The SUM of the Grand Total column is the Booking Revenue (you will need to calculate this using the SUM formula in Excel).

E-GDS

Booking Revenue

  1. Select Hotel (top right corner drop-down menu)
  2. Bookings
  3. Bookings Refine Search
  4. Advanced Search
  5. Filter By Dates = Bookings Made In
  6. Date of Search = Date Range
  7. Enter Dates
  8. Filters should be set to ALL bookings, source, and room types
  9. Sales Value Total (in right-hand corner) is your booking revenue

Shacknet

Booking Revenue

  1. Reports
  2. Managers Reports
  3. Advanced Sales
  4. Select date/month from the “Run dates” drop-down
  5. Pull Total CHARGES

 

Lodgify

Booking Revenue

  1. Select Reports
  2. Booking Transactions
  3. Select the filter on the top right corner
  4. Input the dates in the calendar
  5. From the Status tab select all but “Failed” and “Canceled” and click Apply
  6. Add the Total amounts for all transactions

Vacation Rental Property Management Systems

Escapia

Booking Revenue

  1. Reservations
  2. Reports
  3. Booking Summary Report
  4. Put in your dates
  5. In the Bookings Existing/Entered Between dropdown, select Bookings Entered Between
  6. Skip to the last page of the report
  7. Pull the “Rent” total at the bottom

Actual/Earned Revenue

  1. Reservations
  2. Reports
  3. Booking Summary Report
  4. Put in your dates
  5. In the Bookings Existing/Entered Between dropdown, select Bookings Existing Between
  6. Skip to the last page of the report
  7. Pull the “Rent” total at the bottom

Streamline

Booking Revenue

  1. Go to Reports
  2. Go to Reservation Analysis Report
  3. Set Revenue recognition to “Creation Date”
  4. Leave reservation type details, reservation status and sort by as they are
  5. Important fields to have checked under data to export: Lease ID, Arrive, Nights, Location Name, Unit Name, Total Nightly Rates, Heard About Source
  6. Do not queue for processing, give results immediately
  7. Scroll to the bottom of the page for Gross Total

Booking Revenue (New System)

  1. Go to Accounting
  2. MISC Category (Far Right) > Monthly Reservation Summary
  3. Input dates for the month
  4. Select Creation Date in the Use Date Type dropdown.
  5. Export to Excel
  6. Open the Excel File
  7. Sum the revenue in the “Room Rates” column
  8. Input that total in the VR Reporting Sheet.

Actual/Earned Revenue

  1. Click the bar graphs in the top-right, “Reports”
  2. Under Analysis, click “Revenue Pacing Report”
  3. It will automatically load Dec 2018 – Dec 2019, click “create report”
  4. Use the 2018 row, to pull revenue from last year

V12

Booking Revenue

  1. Reservations
  2. Reports
  3. Reservations Made report
  4. Set the “Booked From” and “Booked Through” dates for range of interest
  5. Keep the “Stays From” and “Stays Through” dates empty, so all bookings made during the Booked From/Through range are captured
  6. Select “no” in the “Show Notes” field
  7. Click Run
  8. Pull the “Total Rent” number, which does not include taxes and fees

Actual/Earned Revenue

  1. Reservation set up
  2. Reports
  3. Rental statistics by Month report
  4. Set your “Year” and As-Of Dates
  5. Click Run

Barefoot

Booking Revenue

  1. Login/Dashboard
  2. Folios/ Reports
  3. Search for Folios
  4. Filter by Contract Date
  5. CTRL + F and type Rent 
    1. Located under Provides Service > Rent.
    2. services provided rent
  6. Click Run Report in the top right
  7. Use “Gross Rent (no discounts)” totals

Actual/Earned Revenue

  1. Login/Dashboard
  2. Folios/ Reports
  3. Marketing Analysis
  4. Booking Snapshot Report
  5. Filter by Arrival Date
  6. Click Run Report in the top right
  7. Use “Gross Rent (no discounts)” totals

LiveRez

Booking Revenue

  1. Reports
  2. Sales Cycle Itemized Tax Report
  3. Put in the dates you need
  4. For the reservations BOOKED that month, you will want to make sure that the drop-downs show as follows:
    liverez reporting
  5. Use GROSS RENTAL RATE ADJUSTED (this value is the base rate after any specials are removed)
      1. If GROSS RENTAL RATE ADJUSTED does not exist, your booking revenue for the month is:

    = GROSS RENTAL RATE + GROSS RENTAL RATE (TAX WAIVED) + RENTAL RATE ADJUSTMENTS TOTAL (if applicable) – TOTAL DISCOUNTS (if applicable)

Actual/Earned Revenue

  1. Reports
  2. Sales Cycle Itemized Tax Report
  3. Put in the dates you need
  4. For the reservations BOOKED that month, you will want to make sure that the drop-downs show as follows:
  5. Then, in the DATE PROCESSED dropdown, change the dates to the departure dates
  6. Use GROSS RENTAL RATE ADJUSTED (this value is the base rate after any specials are removed)

Owner Rez

  1. Reports
  2. Summary Reports > Bookings
  3. Period: Last Month > As of Last Day of the Month Prior
    1. owner rez report snapshot
  4. Run Report
  5. Pull the Total.

Track

  1. Open the Reports tab.
  2. Under the Guest Column, open Reservation Analysis
  3. Enter the appropriate date range, then click the “Search By”
  4. Select Reservation Date
  5. Run Report
  6. Scroll down to the bottom and pull the total from the Rent column.

HOSTAWAY

  1. Click the Financial reporting tab on the left-hand side.
  2. Select the “Listings Financials” tab
  3. Enter the appropriate date range
  4. Select “Reservation Created” from the “Events” dropdown
  5. Scroll down to the bottom and pull the total “Rental Revenue”.

 

CamP GROUND and RV Parks

CAMPSPOT

Revenue

  1. Select the Reports tab at the top right.
  2. Select Invoices from the dropdown menu
  3. Select Revenue Summary by Site Type (Reservation Origination Date)
  4. Enter the appropriate date range and select PDF
  5. Click download and pull the Reservation Charges Total

Leave a Reply