Advance Deposit Activity
Report Description: The Advance Deposit Activity provides details on all advanced deposit activity for general reservations and groups. In addition, details on advance deposit net totals and balances on a defined date.
Date Range: One day (historical dates up to 365 days)
Reservation section: Advance deposit activity by reservation for the defined date.
Available Report Columns for Following Sections:
|
Column Name |
Column Description |
Amount Includes Taxes and Fees |
Calculation |
|
Confirmation No |
Confirmation number on the reservation |
Not Applicable |
Not Applicable |
|
Guest Name |
Primary guest name on the reservation |
Not Applicable |
Not Applicable |
|
Company Name |
Company name of the reservation, if applicable |
Not Applicable |
Not Applicable |
|
Check In Date |
Check in date of the reservation (example - Mar 29, 2024) |
Not Applicable |
Not Applicable |
|
Check Out Date |
Checkout date of the reservation (example - Apr 4, 2024) |
Not Applicable |
Not Applicable |
|
Rate Plan Code |
Rate plan code on the reservation (example - IGCOR) |
Not Applicable |
Not Applicable |
|
Rate Plan |
Rate plan name (example - Advance Purchase) |
Not Applicable |
Not Applicable |
|
Payment Method |
Payment method (example - Visa, Mastercard) |
Not Applicable |
Not Applicable |
|
Last 4 Digits |
Last 4 digits of the credit card number |
Not Applicable |
Not Applicable |
|
Due Date |
Due date that the deposit needs to be processed |
Not Applicable |
Not Applicable |
|
Deposit Collected Until Date |
Shows deposit collected until date of the report |
YES |
=sum(deposit collected until date) |
|
Deposit Collected Today |
Shows deposit collected until today’s date (example - $400) |
YES |
=sum(deposit collected today) |
|
Deposit Used |
How much deposit has been applied on the reservation (will be relevant once charges have posted on the reservation) |
YES |
Not Applicable |
|
Today’s Net Change |
Mirrors the Deposit Used; if none, field will show $0 |
Not Applicable |
Not Applicable |
Group section: Advance deposit activity by group master for the defined date.
Available Report Columns for Following Sections:
|
Column Name |
Column Description |
Amount Includes Taxes and Fees |
Calculation |
|
Group Number |
Confirmation number on the group master |
Not Applicable |
Not Applicable |
|
Group Contact Name |
Group coordinator or contact on the group master |
Not Applicable |
Not Applicable |
|
Company Name |
Company name of the reservation, if applicable |
Not Applicable |
Not Applicable |
|
Start Date |
Check in date of the group (example - Mar 29, 2024) |
Not Applicable |
Not Applicable |
|
End Date |
Checkout date of the group (example - Apr 4, 2024) |
Not Applicable |
Not Applicable |
|
Rate Plan Code |
Rate plan code on the reservation (example - GCG01) |
Not Applicable |
Not Applicable |
|
Rate Plan |
Rate plan name (example - Hotel Key Group Rate) |
Not Applicable |
Not Applicable |
|
Payment Method |
Payment method (example - Visa, Mastercard) |
Not Applicable |
Not Applicable |
|
Last 4 Digits |
Last 4 digits of the credit card number |
Not Applicable |
Not Applicable |
|
Due Date |
Due date that the deposit needs to be processed |
Not Applicable |
Not Applicable |
|
Deposit Collected Until Due Date |
Shows deposit collected until date of the report |
YES |
=sum(deposit collected until date) |
|
Deposit Collected Today |
Shows deposit collected until today’s date (example - $400) |
YES |
=sum(deposit collected today) |
|
Deposit Used |
How much deposit has been applied on the reservation (will be relevant once charges have posted on the reservation) |
YES |
Not Applicable |
|
Today’s Net Change |
Mirrors the Deposit Used; if none, field will show $0 |
Not Applicable |
Not Applicable |
Net Totals section: Advance deposit activity by net amounts (collected, used and change.
Available Report Columns for Following Sections:
|
Column Name |
Column Description |
Amount Includes Taxes and Fees |
Calculation |
|
Deposit Collected Today |
Deposit collected today across all reservation types |
YES |
=sum(deposit collected today) |
|
Deposit Used |
Deposit used today across all reservation types |
YES |
=sum(deposit used) |
|
Today’s Net Change |
Equation: Deposit collected today minus deposit used today |
YES |
=sum(deposit collected) - (deposit used) |
Balances section: Opening and closing balances for Transient vs Group Master activity.
Available Report Columns for Following Sections:
|
Row Name |
Column Description |
Amount Includes Taxes and Fees |
Calculation |
|
Advance Deposit Opening Balance |
The initial balance of advance deposits at the beginning of the specified period |
YES |
=sum(opening balance) |
|
Today’s Net Change |
The net change in advance deposits on the current day, considering deposits and withdrawals |
YES |
=sum(net change) |
|
Advance Deposit Closing Balance |
The closing balance of advance deposits at the end of the specified period |
YES |
=sum(opening balance) - (net change) |
|
Group Master Opening Balance |
The initial balance of group master deposits at the beginning of the specified period |
YES |
=sum(opening balance) |
|
Group Master Change |
The net change in group master deposits on the current day, considering deposits and withdrawals |
YES |
=sum(net change) |
|
Group Master Closing Balance |
The closing balance of group master deposits at the end of the specified period |
YES |
=sum(opening balance) - (net change) |
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:
-
Not Applicable
-
-