Use **Daily Revenue / OTB** to see captured room nights and available booked room-rate value for each stay date, then trace those figures to supporting room stays.

This is current captured business for **one property and one reservation feed**. It is not hotel occupancy, available inventory, realized revenue or a historical “as of” snapshot. Do not add feeds together as if duplicate bookings had been removed across them.

## Before you start

Sign in with access to the property you want to report on. The report does not require an Org Admin role. Reservation details remain subject to their own access checks.

Check which reservation feed you want. **ChannelRUSH Booking Engine** can supply qualified monetary values; other feeds provide captured counts without qualified value or ADR. The feed initially selected is not evidence that it contains your property's reservations.

## Run the report

1. Select the property in Channel Manager.
2. Open **Reports → Overview**.
3. Open **Daily Revenue / OTB**.
4. In **Filters**, choose **Stay dates (through inclusive)**. Use **Month** to fill a whole month, or choose a start and end date.
5. Select **Reservation feed** explicitly.
6. Choose **Currency** and **Business status**. Leave currency at **All currencies, kept separate** unless you need one currency. Active business is the default.
7. If needed, enter an exact **Channel room ID** or **Channel rate-plan ID**.
8. Click **View report**. For a later change, expand **Filters**, change the selection and click **Update report**.

Changing a field alone does not run the report. After the first run, confirm that results and the selected scope appear. For subsequent interactive updates, wait for **Report updated**, then check the date range, feed and scope shown with the results. While an update is running, the displayed results still belong to the previous completed selection. If the update fails, the old results remain on screen; do not read them as the new selection.

![Daily OTB report filters in a narrow browser, showing stay dates, feed, currency, status, blank-date period and exact channel product filters](https://support.channelrush.com/rails/active_storage/blobs/redirect/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBaFVDIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--f920cc4e153d2db02ecf7c6e97db79627f7781d1/daily-otb-filters.png)

*The filters stack vertically in a narrow window. This example includes active and canceled business separately.*

## Read the results

### Room nights and booked value

Stay dates use the property's local calendar dates. Checkout is excluded. A stay arriving on Monday and checking out on Wednesday contributes Monday and Tuesday nights. Only nights inside the selected period contribute to its **Clipped nights**. If you set a report-level rate-plan filter, only nights matching that nightly rate attribution remain; these need not be every in-range night of the stay.

The report uses the latest captured reservation version within the selected property/feed/source-booking identity. It is not a history of all versions. A multi-room booking can contribute several room stays. **Do not sum daily Bookings or Room stays to calculate distinct bookings for the whole period**: the same stay can appear on several dates.

Active and canceled business are separate when you select both. Canceled means the latest captured version is canceled; it is not a measure of when the cancellation occurred. A canceled version without usable stay dates may contribute no daily nights.

Money has a stricter coverage rule than room nights:

- A **priced night** has exactly one usable nightly price. A stored price of zero is a valid price.
- A **qualified night** also belongs to the booking-engine feed and has a known currency.
- **Known booked room-rate value** sums qualified nightly prices. **ADR on qualified nights** divides that value by qualified nights, not by every captured room night.
- Missing, null or duplicate nightly prices do not remove otherwise valid room nights. They leave those nights without qualified value.
- A dash (**—**) means value or ADR is unavailable, not zero. Blank numeric export cells have the same meaning. Partial value covers qualified nights only.
- Value includes tax already embedded in the room rate, but excludes separately stored taxes and fees. It is not net revenue after commission or profit.

Currencies are kept separate; there is no currency conversion. Compare coverage as well as value before using the figures for revenue decisions. Different display and spreadsheet formats can round the same underlying value differently.

### Stay-date calendar

Expand **Stay-date calendar — captured room nights** if needed. Each date shows nights by status and known value by currency. Darker shading means more captured nights relative to the displayed calendar, not higher occupancy.

Click a date's status/night count to open supporting stays for that date and status. The selection retains your currency and product filters. **Return to report**, when shown, takes you back to the parent selection.

![One-day Daily OTB calendar with zero active nights, unavailable value and the explanation that zero captured nights is not hotel occupancy or availability](https://support.channelrush.com/rails/active_storage/blobs/redirect/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBaFlDIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--76fdde360caeaf7e9bf224bee61a5d5d3d0581f9/daily-otb-calendar.png)

*This empty example shows how to read zero nights and unavailable value; it does not demonstrate populated production.*

The daily summary below the calendar shows counts, price coverage, mapping coverage, known value and ADR. Its date links also narrow to that row's currency and status when a link is available. A single currency or status may appear in the scope line instead of a separate column.

### Supporting room stays

Use **Supporting room stays** to inspect the bookings behind the selection. A reservation link opens the retained reservation version; that page shows the whole booking while this report clips nights to the selected period. Opening a link does not resend or change the reservation.

- **Search** finds substrings in channel room or room-stay rate-plan IDs. It is not a guest-name or reservation-number search.
- Use column filters and sorting to narrow or order the table. Multiple filters are combined: a row must match every condition.
- Choose 25, 50 or 100 rows per page. The default is 100.
- **Columns**, column reordering/resizing and **Density** change presentation. They do not change the report selection or generated download columns.
- **Reset table** clears table-specific narrowing and resets sorting and pagination; saved column and density preferences are separate. **Reset report** returns to the initial, unrun report selection.

Table searches and column filters do **not** recalculate the daily summary or calendar. Matching-table totals cover all matching pages, not only the visible page, and stay separated by currency, status and value basis. If you change the report filters, existing table filters can remain; use **Reset table** when that narrowing is no longer wanted.

If the enhanced table is unavailable, expand **Supporting stay table controls**, change the full-page controls and click **Update table**. **Find room or rate-plan ID** performs the same ID search. Expand **Selected feed room-stay detail** for the simpler fallback table. It has fewer columns than the enhanced table.

## Check and download your selection

1. Confirm the property, stay-date range, reservation feed, currency and business status in the report.
2. Check qualified-night coverage before interpreting value or ADR.
3. If the table is narrower than expected, review its search/filters or click **Reset table**.
4. Open **Download report** and choose the dataset you need:
   - **Daily summary CSV** or **Daily summary XLSX**: the daily report selection, unaffected by table filtering.
   - **All supporting stays CSV** or **All supporting stays XLSX**: all supporting stays for the report selection, ignoring table search, filtering and sorting.
5. For the table's current narrowing, use **Download matching table CSV** or **Download matching table XLSX** instead. These include all matching pages, not only the page on screen.

XLSX contains a **Context** sheet and a **Summary** or **Stays** dataset. CSV contains dataset headers and rows. Empty exports can contain headers only. The current download menus do not insert a fabricated zero-value data row.

Downloads read the data again. They are not a frozen copy of an earlier screen. If reservations change between viewing and downloading, refresh the report and compare extraction times. A report-update notice can also warn that summary and rows were read separately; refresh before reconciling a changing dataset.

**New window** opens the report without the normal navigation. **Inventory and restriction context** opens a separate report for the same property; it does not carry your Daily OTB dates, feed or product filters. Set that report's own selection before comparing it. Daily OTB viewing and downloading do not update inventory or send reservations.

## Filter reference

| Field | Meaning, defaults and accepted values |
|---|---|
| **Month** | Shortcut that fills a whole calendar month. Click **View report** or **Update report** to apply it. |
| **Stay dates (through inclusive)** | Both dates supplied, or both blank. Default displayed period starts today in the property's time zone and covers 30 days. Start must not follow end. Maximum range is 366 inclusive days; supported years are 2000–2100. With native date inputs, the labels are **Start date** and **End date**. |
| **Reservation feed** | One feed for this property. Check it before each run; do not assume the initial booking-engine selection is the feed you intend. |
| **Currency** | **All currencies, kept separate**, or one listed currency. No conversion or combined cross-currency value. |
| **Business status** | **Active** (default), **Canceled**, or **Active and canceled, kept separate**. These are latest captured states, not cancellation-event dates. |
| **Days when both dates are blank** | A whole number from 1 to 366; default 30, including when this field is cleared. With both dates blank, the period starts today and runs forward for this many days. It does not override explicit dates. |
| **Channel room ID** | Blank means all rooms. Otherwise an exact stored channel room ID, up to 200 characters; it is not a room name. Avoid accidental spaces. |
| **Channel rate-plan ID** | Blank means all rates. Otherwise an exact channel rate-plan ID, up to 200 characters. This report filter uses nightly rate attribution where available; the table's **Room-stay rate ID** can differ. Avoid accidental spaces. |

### Daily summary columns

| Column | What it means |
|---|---|
| **Stay-date period** | The stay date represented by the row. |
| **Currency** | Currency of the captured records; may be shown in the scope line when only one is present. Unknown currency cannot qualify money. |
| **Status** | Active or Canceled; may be shown in the scope line for a single status. |
| **Bookings** | Captured bookings contributing to this date/currency/status bucket. Not additive across dates. |
| **Room stays** | Room stays contributing to the bucket. Not additive across dates. |
| **Room nights** | Valid captured nights inside the selection. |
| **Priced nights / nights** | Nights with one usable nightly price compared with captured nights. |
| **Qualified priced nights** | Priced nights eligible for known value and ADR. |
| **Unmapped room nights** | Nights whose channel room does not resolve to exactly one mapped room. They remain in captured counts; mapping does not itself qualify or disqualify money. |
| **Known booked room-rate value** | Sum of qualified room-rate amounts in this currency, or a dash when unavailable. |
| **ADR on qualified nights** | Known value divided by qualified nights, or a dash when none qualify. |

### Supporting-table columns

| Enhanced-table column | What it means |
|---|---|
| **Reservation ID** | ChannelRUSH's internal ID of the retained reservation version, not the channel confirmation number. |
| **Room-stay ID** | Identifier of the room stay inside that retained reservation. |
| **Arrival**, **Checkout** | Full room-stay dates. Checkout is excluded from nights. |
| **Room ID** | Captured channel room ID. |
| **Room-stay rate ID** | Rate-plan ID recorded on the room stay; it may differ from nightly rate attribution used by the report filter. |
| **Currency**, **Status** | Currency and latest captured Active/Canceled state. |
| **Full LOS** | Full length of stay before clipping. This column cannot be sorted or filtered. |
| **Clipped nights** | Nights remaining inside the selected report period. |
| **Priced nights**, **Qualified nights** | Price coverage and the subset eligible for monetary totals. |
| **Known value** | Qualified room-rate value for those clipped nights, otherwise unavailable. |

The fallback table uses **Reservation**, **Room-stay ID**, **Channel room ID**, **Arrival**, **Checkout**, **Full LOS**, **Clipped nights**, **Price rows** and **Status**. **Price rows** is the usable priced-night count, not proof that all captured nights qualify for monetary totals.

Table limits are three sorts, ten filters and 100 search characters; each filter value is limited to 128 characters. IDs, currency and status support equality/inequality. Room/rate text also supports contains; dates and numbers support range comparisons. Use `Active` or `Canceled` for status, `YYYY-MM-DD` for date filter values and a decimal point for numeric values. ID values must be positive. There is no grouping control on this report.

### CSV and XLSX field reference

These are the exact headers used by the current download menus. The summary and supporting datasets have different schemas.

**Daily summary**, in order:

`contract, propertyId, feedId, start, end, extractedUtc, stayDate, currency, status, basis, bookings, roomStays, roomNights, pricedNights, qualifiedNights, knownValue, adr, unmappedNights, qualification`

**All supporting stays and matching table**, in order:

`contract, propertyId, feedId, start, end, extractedUtc, reservationId, roomStayId, arrival, departure, room, ratePlan, currency, status, basis, los, roomNights, pricedNights, qualifiedNights, knownValue, adr, supportingVersionId, qualification`

| Header(s) | Meaning |
|---|---|
| `contract` | Export schema identifier; current menu downloads use `report-pilot-v1`. |
| `propertyId`, `feedId` | Selected property and reservation feed IDs. |
| `start`, `end` | Inclusive report period, not full booking dates. |
| `extractedUtc` | Time this export was extracted, in UTC. Not the time the source reservation changed. |
| `stayDate` | Summary row's stay date. |
| `currency`, `status`, `basis` | Currency, captured status and monetary/counting basis. Keep these contexts separate when aggregating. |
| `bookings`, `roomStays` | Daily bucket counts, not distinct totals across the exported dates. |
| `roomNights`, `pricedNights`, `qualifiedNights` | Captured/clipped nights, usable priced nights and monetarily qualified nights. |
| `knownValue`, `adr` | Known qualified value and ADR on qualified nights. Blank is unavailable; numeric zero is a recorded/calculated zero. |
| `unmappedNights` | Summary nights without a unique room mapping. |
| `reservationId`, `roomStayId` | Retained reservation-version and room-stay identifiers. |
| `arrival`, `departure`, `los` | Full arrival/checkout dates and full stay length. |
| `room`, `ratePlan` | Channel room ID and room-stay rate-plan ID. |
| `supportingVersionId` | Retained reservation version supporting the row; for Daily OTB this matches `reservationId`. |
| `qualification` | Explanation of monetary eligibility/coverage. Read it with the numeric columns. |

Dates are exported as ISO dates. IDs remain text in XLSX. Potential spreadsheet formulas in CSV text are protected. Old bookmarked legacy CSV links can produce a different schema; use the current download controls for the headers above.

## Common problems

- **“No captured stays match these filters.”** The selected feed and period have no matching captured stays. Check the feed, widen dates or clear exact room/rate filters. Zero calendar nights do not establish zero hotel occupancy or availability. If you expect a particular booking, verify it in Reservations and contact support with the property, feed, dates and relevant error—not payment details.
- **Room nights appear but value or ADR is blank/dashed.** Check the feed, currency and qualified-night coverage. Non-booking-engine feeds are counts-only here. Missing or ambiguous nightly prices also leave value unavailable. Do not substitute zero or multiply ADR by every captured night.
- **The table and calendar show different totals.** Table filtering affects supporting rows only. Clear table filters with **Reset table** before comparing. For a fresh download mismatch, refresh and compare extraction times.
- **“Update failed. Previous results retained.”** The new selection was not committed. **Retry update** retries the report read, not a reservation or inventory send. If it persists, reload or sign in again, reselect the filters and report the error to support.
- **A date or table filter is rejected.** Correct the reported field using the limits above, then resubmit. For an invalid copied/bookmarked URL, start again from **Reports → Overview → Daily Revenue / OTB** rather than repeatedly editing unsupported query values. An error screen can use the simpler fallback controls.
- **Invalid stays or missing source identities are reported.** These are data-quality diagnostics, not additional in-period nights. Invalid stay dates cannot be assigned reliably to the selected period; missing source-identity counts can cover the whole property/feed. Give support the property, feed, selected dates and diagnostic text if reconciliation depends on these records.
- **A report or reservation link is unavailable.** Confirm the selected property and your access. A reservation-detail link does not grant permissions. If repeated drill-downs reach a return-navigation limit, use **Return to report** to step back or reopen the report from Overview.

For unresolved problems, include the property, reservation feed, selected dates, currency/status, action time and time zone, and exact error text. Do not send passwords or payment information.
