Advance Deposit Activity Report

This report lists advance deposit activity for a specified date range. This report is the industry standard deposit activity report used in the EMEA region where VAT taxes are levied and tax invoice functionality is used. The report includes the opening deposit ledger balance and then lists the account, activity date, confirmation number, guest name, organization, contact, booking agency, arrival and departure dates, payment transaction, net amount, VAT%, tax amount, fee amount, and total amount for each advance deposit. The report is grouped by deposit activity type and then by reservation type. The report includes summary totals for each reservation type within each activity type, and for each activity type. The report then includes a summary total of all deposits included in the report along with the closing deposit ledger balance.

You can filter the report by specifying property. You can optionally include deposits paid, deposits transferred to the guest ledger, refunds, and forfeits. You can sort the report by activity date, activity type, or transaction.

The following are some of the important points to be noted:

  • When an advance deposit takes place on an account other than a guest account, the report will separate out these deposits and group them under the Account reservation type.
  • If Organization exists without Booking Agency then contact name comes from the organization profile. If Booking Agency exists without Organization then contact name comes from the booking agency profile. If both exist then contact name comes from the booking agency profile.

These calculations are performed:

  • Net Amount = Total Amount - Tax - Fee
  • Total Amount = Amount + Fee
  • Closing Balance = Opening Balance + Total Amount of Total Deposit