Guesty’s reservations report provides a centralized view of your booking data, offering information on key aspects of each reservation. Use this tool to efficiently track reservations, monitor key metrics, and stay organized.

The reservations report default view is displayed when navigating to the reservation page. Customize the report by adding columns and filters to include additional information, such as payment status, booking channel of origin, and a financial breakdown of each reservation’s price.

Learn about key financial terms you can add to the report as columns or filters.

Follow the instructions to create, print, or download a reservations report.

Create a custom reservations report

A reservations report can include a maximum of 50,000 rows. Contact us if you need a longer report.

Step by step:

  1. Sign in to your Guesty account.
  2. In the top navigation bar, click More, then select Reservations.
  3. Add filters and/or columns to adjust the data.
    • Click the circle plus icon next to "Filters" and select the desired filter. Enter the relevant information, then click Save.
      Available filters
      Filter name Options
      Alteration date Before / After / Between / etc. + date / days
      Balance due Equals / Does not equal / Is more than / Is less than / Between + number
      Canceled by Select from list
      Cancellation date Before / After / Between / etc. + date / days
      Check-in Before / After / Between / etc. + date / days
      Check-in form submission status Select from list
      Check-out Before / After / Between / etc. + date / days
      Confirmation date Before / After / Between / etc. + date / days
      Created by Select from list
      Creation date Before / After / Between / etc. + date / days
      Fully paid Yes/ No
      Guest's name Contains / doesn't contain / Equal to {string}
      Guest's review date Before / After / Between / etc. + date / days
      Lead time (from creation to check-in) Before / After / Between / etc. + date / days
      Listing Select from list
      Listing ID Contains / doesn't contain / Equal to {string}
      Listing's city Select from list
      Listing's nickname Contains / doesn't contain / Equal to {string}
      Listing's title Contains / doesn't contain / Equal to {string}
      Mid-stay relocation Yes/No
      Mid-stay relocation date Before / After / Between / etc. + date / days
      Number of guests Equals / Does not equal / Is more than / Is less than / Between + number
      Number of nights Equals / Does not equal / Is more than / Is less than / Between + number
      Number of pets Equals / Does not equal / Is more than / Is less than / Between + number
      Override availability rules? Yes/ No
      Platform Select from list
      Point of sale Contains / doesn't contain / Equal to {string}
      Secondary source - not final Contains / doesn't contain / Equal to {string}
      Source Select from list
      Status Select from list
      Stay dates Dates range
      Stay status Select from list
      Total payout Equals / Does not equal / Is more than / Is less than / Between + number
      Upload ID Contains / doesn't contain / Equal to {string}
    • To edit a filter, hover over the name of a filter and click the Pencil icon. In the pop-up, make the necessary changes and click Save. In the top-right corner, click Save to update the current filter or Save as to save as a new filter.
    • To delete a filter, hover over the name of a filter and click ✕ or click the Pencil icon and in the pop-up, click Remove. In the top-right corner, click Save to update the current filter or Save as to save as a new filter.
    • To add a column, click Columns at the top right. Toggle column names on or off to add or remove them.
  4. Click Save as new custom report.
  5. Type a name for the custom report and click Save.

Note:

  • The "Stay dates" filter displays all reservations that include a date within the specified filter.
  • If you encounter a problem adding columns or filters (for example, adding a "resort fee" filter), check that you have at least one reservation with this value. Only values recorded in at least one reservation can be used in the report. 

View and bookmark saved reports

To view your saved reports, click the downward arrow next to the name of the current report being presented, above "Filters". Select the relevant report from the list.

To bookmark a report, hover over it and click the star to the right. It will be added to the "Favorites" section of the reports list.

Delete a custom reservations report

The default reports cannot be deleted, only the additional reports you've created. Locate the relevant report you'd like to delete by clicking the downward arrow next to the name of the current report being presented, above "Filters". Hover over it, and click Trash icon.

Share a reservations report

Email report 

You can share the reservations report directly with contacts or cleaners that have a valid email address updated in Guesty. To share, apply filters to your report and at the top-right corner click the square share icon . Select the relevant contacts or cleaners from the dropdown menu. Configure the message attached to the report and choose to send it Once or Repeat weekly on selected days. Click Share

Share link

You can share the reservation report with non-Guesty users such as owners, cleaners, and operations teams, via a secure link that displays live, read-only data. To share, apply filters to your report and at the top-right corner click Share link icon. Select the relevant contacts or users from the dropdown menu, configure your message and click Share. Recipients receive an email with the report link, which can be shared through any communication method without requiring a Guesty login to view the report.

You can revoke access to a link at any time or let it automatically expire after 1 year.

To revoke access, click the vertical ellipsis at the top-right corner of the report, select Manage sharing preferences. In the pop-up click Trash icon next to the link, and click Save.

Expired links generate the following message: “This report has expired. Please contact {account.email} to request a new link.”

Rename a reservations report

To rename a report or manage its sharing rules, click the vertical ellipsisat the top-right corner of the report and select Rename. Click Save in the pop-up.

Print or download a reservations report

To print a reservations report click the vertical ellipsis at the top-right corner and select Print

When downloading your reservations report, two CSV file formats are available:

  • Comma-Separated CSV
  • Semicolon-Separated CSV

The semicolon format is compatible with spreadsheet tools in regions where commas are used as decimal points (Poland, Germany, France etc.). Both formats use UTF-8 encoding to support special characters.

To download a report click the download csv icon . The report is sent to your email as a CSV file.

To download the report as a semicolon-separated CSV, under "Need a different CSV format?" click Click here.

Note:

  • When working with multi-currency data, make sure to include the Currency column (located under "Payments"), in your reservation report before exporting to CSV. Without this column, exported data won't show currency symbols.
  • To ensure a quick download of your reports, remove any columns that aren’t relevant and sort the report by check-in date.

Was this article helpful?
0 out of 1 found this helpful