Revised Date:
Scheduled Advance Deposits by Arrival
Report Description: Provides a list of scheduled advance deposits including guest name, stay details, amount due and deposit status (paid or failed).
Date Range: This report can render the data for up to 94 days in the future
Available Report Columns for Following Sections:
|
Column Name |
Column Description |
Amount Includes Taxes and Fees |
Calculation |
|
Guest Name |
Primary guest name on the reservation |
Not Applicable |
Not Applicable |
|
First Name |
First name of the guest. Split of the Guest Name |
Not Applicable |
Not Applicable |
|
Last Name |
Last name / surname of the guest. Split of the Guest Name |
Not Applicable |
Not Applicable |
|
Room Number |
Room number on the reservation (if assigned) |
Not Applicable |
Not Applicable |
|
Reservation Status |
Current status of the reservation (example: Arrival, Canceled, etc.) |
Not Applicable |
Not Applicable |
|
Deposit Status |
Current status of the deposit payment (example: Paid, Unpaid, Failed) |
Not Applicable |
Not Applicable |
|
Source Name |
Name of the source of the reservation. |
Not Applicable |
Not Applicable |
|
Source Code |
Unique code associated with the source name. |
Not Applicable |
Not Applicable |
|
Sub Source Code |
Unique sub code of the source of the reservation. |
Not Applicable |
Not Applicable |
|
Due Date |
Due date of the reservation |
Not Applicable |
Not Applicable |
|
Payment Type |
The payment source currently on the reservation |
Not Applicable |
Not Applicable |
|
Action Required |
Is action required by property to process the deposit payment manually |
Not Applicable |
Not Applicable |
|
Total Deposit Required |
Deposit amount required from the reservation. |
Not Applicable |
Not Applicable |
|
Remaining Balance |
Deposit paid minus the actual amount to be paid is remaining balance. |
Not Applicable |
Not Applicable |
|
Check In Date |
Date when the guest was scheduled to arrive |
Not Applicable |
Not Applicable |
|
Nights |
Total number of nights for the reservation |
Not Applicable |
=sum(number of nights) |
|
Room Type |
The room type currently on the reservation |
Not Applicable |
Not Applicable |
|
Confirmation Number |
Unique identifier for the reservation confirmation |
Not Applicable |
Not Applicable |
|
Group Code |
Unique identification code of the Group. |
Not Applicable |
Not Applicable |
|
Group Name |
The name of the group against the reservation |
Not Applicable |
Not Applicable |
|
Rate Plan |
The rate plan currently on the reservation |
Not Applicable |
Not Applicable |
|
Company Name |
Name of the company associated with the reservation, if applicable |
Not Applicable |
Not Applicable |
|
Local First Name |
The given name of the guest written in their localised native language, alphabet, or regional character set. |
Not Applicable |
Not Applicable |
|
Local Last Name |
The family name or surname of the guest written in their localised native language, alphabet, or regional character set. |
Not Applicable |
Not Applicable |
|
Sub Source Name |
Breaks down the primary booking source into specific detail (such as identifying the exact third-party website or specific travel agency partner used). |
Not Applicable |
Not Applicable |
|
Cancel Due By |
The absolute deadline date and time by which a guest must cancel their reservation to avoid paying a cancellation penalty or fee. |
Not Applicable |
Not Applicable |
Misc Report Information:
Available Features:
-
Export: ability to download and save the file into an alternate format.
-
Filter: filter a range of data based on criteria defined by the user.
-
Highlight: also known as conditional formatting is the ability to highlight certain values making them easier to identify.
Available Configuration:
-
User Preferences: allows the user to customize their report view by repositioning or removing columns.
-
Property Preferences: allows the property to customize the report view for all users by repositioning or removing columns.
Baseline Configuration:
-
Property Preferences Settings:
-
Following columns to be disabled for initial deployment:
-
None
-
-