Advance Deposit Activity .ng
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