Find captured reservations for one property, narrow the result and download either the complete report selection or the rows matching your table filters.

## Before you start

- Select the property you want to investigate. You need access to that property. This report is available through **Reports → Reservations → List & Export**; it is separate from the **Reservations → Search** screen.
- This page reports the **current property only**. Check the property shown under **Filters → Properties**. To change it, select the other property and reopen the report. For several properties together, use the [organization reservations report](https://help.channelrush.com/hc/channelrush/articles/org-reservation-report).
- Results contain the latest captured version of each reservation, not every modification or a historical snapshot. **New**, **Modified** and **Canceled** are reservation-version states, not delivery results.
- Viewing, filtering and downloading this report does not change or resend reservations. Files can contain booked-by names and confirmation numbers; share them only with authorized recipients.

## Run the report

1. Select the intended property in the application header.
2. Open **Reports → Reservations → List & Export**.
3. Confirm the property under **Filters**.
4. Set both dates under **Date range**. Alternatively, use **Month** to select a whole month. If the enhanced date picker is unavailable, use the **Start date** and **End date** fields.
5. Choose **Date basis**. Use the reference below to distinguish receipt dates from stay dates.
6. Select the **Channels** and **Status** values you want included.
7. Click **Update report**.
8. Check the date basis, date range and matching-reservation count above the table before using or downloading the results.

On a fresh page, the displayed dates start at the property's current local date and end 28 days later. **Booking date** is selected, with all offered channels and all three statuses checked. These are proposed criteria: the report does not run until you click **Update report**.

![Property reservation report filters with dates, date basis, channels, statuses and Update report](https://support.channelrush.com/rails/active_storage/blobs/redirect/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBaElDIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--030b15b1385b0dc70e533fa50e2825b15bae8677/reservations-list-export-filters.png)

*Example from a demo property. Canceled is unchecked here, so this selection includes New and Modified versions only.*

### Date and selection reference

| Control | What it selects | What to check |
|---|---|---|
| Properties | The current property. This is a scope label, not a multi-property picker. | Confirm it before running the report. |
| Month | Sets the date range to a whole calendar month. | Check the resulting start and end dates. |
| Date range | Both boundaries for the selected date basis. | End must be on or after start. Dates alone do not select the meaning of the period. |
| Booking date | Receipt of the latest captured reservation version. | This is not necessarily the original sale date. A modification can move a booking out of an earlier receipt-date selection. |
| Arrival date | Reservations with a room arrival within the selected dates, including both boundary dates. | Other rooms in that reservation can have dates outside the range. |
| Departure date | Reservations with a room departure within the selected dates, including both boundary dates. | This is not an occupied-night filter. |
| Stay overlap (checkout included) | Reservations whose room date ranges overlap the selected dates. | Checkout counts. Incomplete room-date boundaries can also qualify. Do not use this as an occupied-room-night count. |
| Channels | The recorded reservation channel/feed. All checked means no channel narrowing. | The offered list need not contain every historical or PMS-only feed. With all checked, those captured records can still appear. |
| Status | New, Modified and/or Canceled for the latest captured version. | A newer version supersedes the earlier version even if it no longer matches your selected status or dates. |

Use the checkbox beside **Channels** or **Status** to select or clear that list, then confirm the selected count. Keep at least one status selected and at least one channel when channels are offered. A property with no offered channels can still have captured reservations. A retained **Recorded channel** entry means the report link names a channel no longer in the offered list; it remains a filter until you change the selection.

The dates decide which reservations qualify. They do **not** clip a reservation's dates, stay nights or amounts to that period.

**For receipt-date reconciliation, retain the report URL and use the same output path.** **Version receipt UTC** is displayed in UTC. Do not assume the calendar dates establish property-local midnight boundaries or that a separate legacy Excel/CSV report uses identical receipt boundaries. If a reservation near a date boundary differs between outputs, retain both selections and the receipt timestamp for support to compare; the difference alone does not prove a missing booking.

## Check and adjust the result

A matching count means captured reservations matched the current selection. It does not establish that every booking has been received or delivered. Zero matches is not proof that the property has no business.

Click a **Confirmation** link to open that captured reservation's details. Check the property and reservation identifiers before investigating. See [Review reservation details](https://help.channelrush.com/hc/channelrush/articles/reservations-view) for the detail fields.

To change dates, channels or statuses, open **Filters**, make the changes and click **Update report** again. Existing table filters can remain active after changing report criteria; use **Reset table** if you want to remove that extra narrowing.

- **Reset report** keeps the property context but clears the report selection and table choices. Choose the dates and run the report again; dates appearing in the controls do not mean results have loaded.
- **Reset table** keeps report dates, property, channels and statuses while clearing table search, filters, sorting and paging choices.
- **New window** opens the report in a separate tab/window, retaining its selection.
- If a legacy link shows **No date filter — the dates above are ignored**, choose a date basis and click **Update report**. The visible dates alone do not establish that a date filter is active.

If a refresh fails, the old rows can remain visible. Check the error and selected criteria rather than treating those rows as the result of your pending changes. **Retry**, when offered, repeats report retrieval; it does not resend a reservation.

## Narrow or arrange the table

1. Open **Table filters and sorting**.
2. Choose a **Sort** column and **Direction**, if needed.
3. To add a filter, choose its field under **Add filter**, then its **Operator** and **Value**.
4. Optionally enter a **Property/channel search** and choose **Rows**.
5. Click **Apply table**.
6. Check the resulting matching count and active selection before exporting.

**Property/channel search** searches property and channel names, not guest names or confirmation numbers. For a booking identifier, add a **Confirmation** or **PMS confirmation** filter.

### Table-filter values

| Fields | Supported operators | Value example |
|---|---|---|
| Internal ID, Property ID, Channel ID | Equals; Does not equal | A positive whole-number identifier. |
| Status | Equals; Does not equal | `New`, `Modified` or `Canceled`. |
| Confirmation, PMS confirmation, Property, Channel, Currency | Equals; Does not equal; Contains | A confirmation number or `USD`. Text matching is case-insensitive. |
| Arrival, Departure | Equals; Does not equal; At least; At most | `2026-10-24`. |
| Stay nights, Before tax, After tax | Equals; Does not equal; At least; At most | `3` or `1250.50`, without thousands separators. |
| Version receipt UTC | Equals; Does not equal; At least; At most | `2026-10-24T12:00:00Z`, or a timestamp with an explicit UTC offset. |

The operator menu can offer an operator that is invalid for the selected field. Use a supported combination from this reference. **Booked by** and **Single rate plan** cannot be filtered or sorted.

Additional filters combine with **AND**: every condition must match. Up to ten filters and three distinct grid sorts are supported. Search is limited to 100 characters and an individual filter value to 128 characters. Applying the table form's single sort replaces any multi-column grid sort.

**Rows** offers 25, 50 or 100; the initial page size is 100. Paging limits the displayed page, not the complete matching download. The initial order is **Internal ID**, ascending.

Use **Columns** to show or hide columns; you can also resize and reorder them. **Density → Comfortable / Compact** changes presentation. These choices do not remove fields from the default CSV/XLSX downloads.

## Download the right selection

1. Confirm the property, date basis, dates and current result.
2. Open **Download**.
3. Choose the scope and file type:
   - **Full report CSV** or **Full report XLSX** includes the report's property, dates, channels and statuses. It ignores additional table filters, search and sorting.
   - **Matching table CSV** or **Matching table XLSX** retains table filters, search and sorting. It includes all matching pages, not only the page currently displayed.
4. Check the file's property, identifiers, currency and date basis before using its values.

Downloads query the data again. A newly captured or modified reservation between viewing and downloading can change the result. A file is not a permanently frozen copy of an earlier screen.

The XLSX file includes **Context** and **Reservations 1** sheets, with additional reservation sheets when required. Context records the selection, scope, extraction time, row count and interpretation notes. The CSV includes the context fields described below on each data row. A no-match CSV can contain only its header.

These downloads are not the separate legacy **Excel View**. If an old bookmark opens **View - Excel** or a different field layout, reopen **Reports → Reservations → List & Export** to follow this guide. Do not mix schemas or receipt-date boundaries without reconciling them.

## On-screen column reference

| Column | Meaning |
|---|---|
| Confirmation | The channel's reservation identifier. The link opens the captured reservation version. |
| Booked by | The supplied booked-by name, not a list of every staying guest. Blank means no usable name is supplied here. |
| Property | The property associated with the reservation. |
| Channel | The recorded reservation channel/feed, which can differ from the booking's ultimate sales source. |
| Status | New, Modified or Canceled for the latest captured version. Not delivery status. |
| Arrival / Departure | The captured whole-reservation date envelope, not dates clipped to the filter period. Missing boundaries remain unknown. |
| Stay nights | The span of that date envelope, not summed room-nights. A zero can reflect incomplete dates; inspect the reservation before interpreting it as a zero-night stay. |
| Currency | The source currency. Amounts are not converted to a common currency. |
| Before tax / After tax | Captured source totals. Missing or unavailable amounts remain blank; zero is different from missing. These are not proof of collected payments or complete accounting revenue. |
| Version receipt UTC | When ChannelRUSH received this captured version, displayed in UTC. Not necessarily the original sale time. |
| Internal ID | ChannelRUSH's identifier for this captured reservation version. Different versions can have different IDs. |
| Property ID / Channel ID | ChannelRUSH identifiers for the property and recorded channel. |
| PMS confirmation | The captured PMS reservation identifier. Its presence does not prove the latest delivery succeeded. |
| Single rate plan | The channel rate-plan identifier when the reservation's room entries share one. Blank can mean missing or multiple rate plans. |

If the interactive grid is unavailable, the plain table groups some of these fields together. Its **Amount / currency** chooses one source total according to currency tax treatment; an unavailable chosen total remains missing rather than being replaced with the other total.

## CSV and XLSX field reference

The default download fields are the same for both file types, in this order. Hiding a grid column does not remove its export field.

| Exact header | Meaning |
|---|---|
| `contract` | Export schema identifier: `reservations-v1`. |
| `propertyId` | ChannelRUSH property ID. |
| `propertyName` | Property name. |
| `channelId` | ChannelRUSH recorded channel ID. |
| `channelName` | Recorded channel/feed name. |
| `reservationId` | Internal captured-version ID—not the channel confirmation. |
| `confirmation` | Channel reservation identifier. |
| `pmsConfirmation` | Captured PMS identifier, if supplied. |
| `guestName` | Booked-by name. |
| `ratePlan` | Single shared channel rate-plan identifier; blank for missing/multiple plans. |
| `status` | New, Modified or Canceled. |
| `currency` | Source currency; missing is unknown. |
| `totalBeforeTax` | Source total before tax; blank when unavailable. |
| `totalAfterTax` | Source total after tax; blank when unavailable. |
| `arrival` | Captured reservation arrival date. |
| `departure` | Captured reservation departure date. |
| `nights` | Whole-reservation date span, with the missing-date limitation above. |
| `receiptUtc` | Receipt instant of the captured version, in UTC. |
| `sourceEditedUtc` | Source-supplied edit instant, in UTC; blank when absent. It does not fall back to receipt time. |
| `extractedUtc` | Report extraction time. Not a delivery time or proof of a fresh channel response. |
| `dateBasis` | The report's date-basis label. |

Dates use `YYYY-MM-DD`; timestamps include an explicit UTC offset. CSV numbers use a decimal point without grouping separators. Preserve identifiers as text when importing CSV so leading zeros and long IDs are not altered. Formula-like text can have a protective leading apostrophe in CSV; XLSX stores such text literally. Missing dates and totals remain blank rather than being invented as zero.

## Common problems

| Symptom | Safe next action | When to escalate |
|---|---|---|
| No matching reservations | Confirm property and date basis, widen dates if appropriate, include the required statuses/channels and use **Reset table** to remove extra narrowing. | A known captured booking remains absent after its latest version and criteria are checked. |
| A booking disappeared from an earlier report | Check its latest captured version. A modification, cancellation or later receipt can move it outside the original selection. | The latest version appears to satisfy every filter but is still absent. |
| Update report cannot run | Supply both dates, correct reversed dates and keep the required checklist selections. | Valid criteria still produce an error. Retain the error text and report URL. |
| An added table filter is rejected | Check the field/operator combination and the value format in the table-filter reference. | A supported combination still fails. |
| Old rows remain after an update error | Treat them as the previous successful result. Correct criteria or use **Retry** when offered. | Retrieval continues failing; do not resend reservations to repair a report display. |
| Download contains more rows or fields than expected | Check Full report versus Matching table. Both export all matching pages; hidden columns remain in the default schema. | Scope still differs after those distinctions are checked. |
| Receipt-boundary results differ between extracts | Keep the same report path and retain both URLs, date bases and the relevant UTC receipt timestamp. | Ask support to compare the exact date boundaries before treating a difference as a missing booking. |
| The property or report is unavailable | Confirm the selected property and ask your organization administrator to check access. | Access is expected but the page remains unavailable. |

For support, provide the property, recorded channel, appropriate reservation identifier, report URL, date basis, dates, action time/time zone and error text. Do not send passwords, card details or an unrestricted guest export.

## Related

- [Read and export reservations across properties](https://help.channelrush.com/hc/channelrush/articles/org-reservation-report)
- [Review reservation details](https://help.channelrush.com/hc/channelrush/articles/reservations-view)
- [Check reservation delivery status](https://help.channelrush.com/hc/channelrush/articles/reservations-delivery-status)
