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 yesterday’s date)
The report includes the following columns:
|
Reservations |
|
|
Confirmation Number |
Confirmation number on the reservation |
|
Guest Name |
Primary guest name on the reservation |
|
Company Name |
Company name of the reservation, if applicable |
|
Check In Date |
Check in date of the reservation (example - Mar 29, 2024) |
|
Check Out Date |
Checkout date of the reservation (example - Apr 4, 2024) |
|
Rate Plan Code |
Rate plan code on the reservation (example - AP1) |
|
Rate Plan |
Rate plan name (example - Advance Purchase) |
|
Payment Method |
Payment method (example - Visa, Mastercard) |
|
Last 4 Digits |
Last 4 digits of the credit card number |
|
Due Date |
Due date that the deposit needs to be processed |
|
Deposit Collected Until Date |
Shows deposit collected until date of the report |
|
Deposit Collected Today |
Shows deposit collected until today’s date (example - $400) |
|
Deposit Used |
How much deposit has been applied on the reservation (will be relevant once charges have posted on the reservation) |
|
Today’s Net Change |
Mirrors the Deposit Used; if none, field will show $0 |
|
Groups |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Net Totals |
|
|
Deposit Collected Today |
Deposit collected today across all reservation types |
|
Deposit Used |
Deposit used today across all reservation types |
|
Today’s Net Change |
Equation: Deposit collected today minus deposit used today |
|
Balances |
|
|
Advance Deposit Opening Balance |
The initial balance of advance deposits at the beginning of the specified period |
|
Today’s Net Change |
The net change in advance deposits on the current day, considering deposits and withdrawals |
|
Advance Deposit Closing Balance |
The closing balance of advance deposits at the end of the specified period |
|
Group Master Opening Balance |
The initial balance of group master deposits at the beginning of the specified period |
|
Group Master Net Change |
The net change in group master deposits on the current day, considering deposits and withdrawals |
|
Group Master Closing Balance |
The closing balance of group master deposits at the end of the specified period |