> ## Documentation Index > Fetch the complete documentation index at: https://help.kwentra.com/llms.txt > Use this file to discover all available pages before exploring further. # Actual Departure Consolidated Report > Run Actual Departure once for all your hotels and see every checked-out reservation in one file. See who checked out across all your hotels in one run. ### **Business Value** * Replaces running the report hotel by hotel and merging the files by hand. * Keeps the same columns and layout staff already know. * Adds a Hotel column, so you see where each guest stayed. * Adds a **By Hotel** grouping with each hotel's totals. * Opens only for users with the report's own permission. ### **Use Cases** * A group manager sees all check-outs for the week across every hotel. * A financial controller checks rates and payers for departed guests in one file. * A multi-property night auditor downloads departures without opening each hotel. ### **How It Works** | **Where:** [Multi-Property Hub → Reports → Actual Departure](https://manage.kwentra.com/hub/#/reports/actual-departure-consolidated) | | - | Before, Actual Departure ran one hotel at a time. Now it runs across the hotels you pick and returns one file. It sits next to the [Consolidated Expected Arrival](/multi-property/multi-property-consolidated-expected-arrival-report) report. The single-hotel Actual Departure report does not change. #### **Running the Report** | **Parameter** | Description | | - | - | | **Hotels** | New. Pick one hotel or more. All your hotels are picked by default. | | **Fromdate** / **Todate** | Required. The Hijri date shows under each date. | | **With rate** | Required. **With** adds the rate columns. | | **Group by** | Channel (default), Group, Rate Code, Meal Plan, None, or **By Hotel** (new). | | **Sort by** | **Hotel** (new, default), Room number, Reservation number, Guest Name, Rate Code, Arrival Date, Departure Date or Room Type. | | **Channel**, **Rate code**, **Room type** | Optional. Pick one or more. Leave empty for all. | | **Show remarks** | Show or Don't Show. | | **Show other names** | Show or Don't Show. | | **Billing instruction** | Don't Show or Show. | | **From time** / **To time** | Optional. The check-out time window. Empty means 00:00 to 23:59. | | **File type** | XLS, XLSX, ODS or PDF. | * If Todate is before Fromdate, you see: **To date cannot be before from date.** * If From time is later than To time, you see an error. It reads: **The 'From time' value cannot be later than the field 'To time'.** * Each channel, rate code and room type name is listed once. Picking it covers every hotel that has it. | **Note:** Demo and head-office instances are never listed and never counted. | | - | #### **Report Layout** The sheet keeps today's layout. Only these parts change: * The header shows the company name and the hotels you picked, or **All hotels**. * The title row reads **Actual Departure Consolidated** with your date range. * A new first column, **Hotel**, is filled on every line. Id and Room numbers repeat across hotels. Under each reservation, extra lines can show other names, remarks and billing instructions. They always come from that reservation's own hotel. Each group has a header row and a footer row. The footer shows **Rooms**, **Adults** and **Children**. With rate adds **Rate** and **Net Rate**. One **Total** row at the bottom shows the whole group's total. | **Row** | What the Hotel column shows | | - | - | | Reservation and the lines under it | The reservation's hotel | | Group header and footer, Group by = By Hotel | That hotel | | Group header and footer, any other Group by | **All hotels** | | Total | **All hotels** | With Group by = None, there are no group rows. A hotel with no check-outs adds no rows. #### **Report Columns** | **Column** | What it shows | | - | - | | **Hotel** | New. The hotel of the row. | | **Id** | The reservation number. | | **Room** | The room number. | | **Type** | The room type. | | **Name** | The guest name. | | **Arrival** / **Time** | The arrival date and check-in time. | | **Departure** / **Time** | The departure date and check-out time. | | **Voucher no** | The voucher number. | | **Adt** / **Chld** | Adults and children on the last night. | | **Channel** | The reservation's channel. | | **Group** | The group name, for group members. | | **Rate Code** | With rate only. Blank shows **Manual**. | | **Rate** | With rate only. The rate in the reservation's currency. | | **Base rate** | With rate only. The rate in the hotel's base currency. | | **Discount %** | With rate only. | | **Net base rate** | With rate only. Base rate less the discount. | | **Billing Instruction** | Shown only when Billing instruction = Show. | | **Meal Plan** | The meal plan. | All rate columns come from the reservation's last night. #### **Totals** * **Rooms** is the number of reservation rows. * **Adults** and **Children** are added from each row. * **Rate** is the sum of Base rate. **Net Rate** is the sum of Net base rate. * Each footer and the Total equal the same figures from each hotel run one by one. #### **Names Must Match Exactly** Groups are matched across hotels by exact name. * `{code}_Booking.com` at two hotels makes one group. Its footer covers both hotels. * Names that differ even slightly stay as separate groups. #### **What Counts** * Individual reservations in **Checked Out** status count. * The actual departure date must fall between Fromdate and Todate. Both dates are included. * Group members show one by one, with the group name in the Group column. * Group block reservations are not listed. * Expected, in-house, cancelled and no-show reservations never show. | **Note:** Amounts are added as they are, in each hotel's base currency. There is no currency conversion. Use this report for hotels that share one base currency. | | - | #### **Permission** The report has its own permission pair. One permission runs it. The other opens every file format. Both go to the same roles as the [Channels Revenue YTD Consolidated](/multi-property/channels-revenue-ytd-consolidated-report) report. These include **Multi Property Financial controller** and **Multi Property Night auditor**. Without them, the report does not show in the Reports menu. This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.