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