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.

Read our best practices for building custom reports for specific business needs and common use cases.

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.
    • To add a column, click Columns at the top right. Toggle column names on or off to add or remove them.

      Available filters and columns
      Name Options Filter Column
      Alteration date Before / After / Between / etc. + date / days    
      Balance due Equals / Does not equal / Is more than / Is less than / Between + number    
      Cancellation date Before / After / Between / etc. + date / days    
      Channel reservation ID
         
      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 code    
      Confirmation date Before / After / Between / etc. + date / days  
      Creation date (date of import) Before / After / Between / etc. + date / days  
      Airbnb: Creation date - channel (date of creation in Airbnb) Yesterday / Tomorrow / Week / Month / Past / Next / Last / Set / Before / After / Today + days    
      Fully paid Yes / No  
      Guest's name Contains / Doesn't contain / Equal to {string}  
      Import date Before / After / Between / etc. + date / days  
      Listing Select from list    
      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}  
      Number of guests Equals / Does not equal / Is more than / Is less than / Between + number    
      Number of children 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    
      Platform Select from list    
      Point of sale Contains / Doesn't contain / Equal to {string}    
      Source Select from list    
      Status Select from list    
      Stay dates Dates range  
      Total paid Equals / Does not equal / Is more than / Is less than / Between + number  
      Total payout Equals / Does not equal / Is more than / Is less than / Between + number    
    • 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.
  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. Above "Filters", click the downward arrow next to the name of the current report being presented. Locate the relevant report you'd like to delete, hover over it, and click Trash icon.

Share a reservations report

Email report 

You can share the reservations report directly with contacts or cleaners who 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

To download a report, click the download csv icon . The report is sent to your email as a CSV file—direct downloads to your device aren't supported.

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 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