Revised Date:
Report Description: The Payment Activity Report provides a comprehensive list of payment activities conducted on a defined date, categorized into different sections including reservations, groups, house accounts, miscellaneous revenue, and company account settlements. The report includes transaction details such as date, time, confirmation number, guest or company name, room number (if applicable), payment type, last four digits of the payment card, amount, entry mode, username of the user who completed the transaction, and any remarks.
Date Range: This report can render the data for up to 94 days in the past
Reservations Section : A comprehensive list of payment activities at the reservation level.
Available Report Columns for Following Sections:
|
Column Name |
Column Description |
Amount Includes Taxes and Fees |
Calculation |
|
Date |
Transaction date |
Not Applicable |
Not Applicable |
|
Time |
Transaction time |
Not Applicable |
Not Applicable |
|
Confirmation Number |
Unique identifier for the reservation confirmation |
Not Applicable |
Not Applicable |
|
Folio Number |
A unique, system-generated identification number assigned to a specific financial account or bill (folio) within a reservation. |
Not Applicable |
Not Applicable |
|
Guest Name |
Name of the primary guest associated with the reservation |
Not Applicable |
Not Applicable |
|
First Name |
Given first name of the Guest . Split of the Guest Name. |
Not Applicable |
Not Applicable |
|
Last Name |
Given last name of the Guest . Split of the Guest Name. |
Not Applicable |
Not Applicable |
|
Company Name |
Name of the company associated with the reservation, if applicable |
Not Applicable |
Not Applicable |
|
Room Number |
Room number associated with the transaction, if applicable |
Not Applicable |
Not Applicable |
|
Payment Type |
Type of payment made |
Not Applicable |
Not Applicable |
|
Last 4 Digits |
Last four digits of the payment card |
Not Applicable |
Not Applicable |
|
Amount |
Transaction amount |
Not Applicable |
Not Applicable |
|
Entry Mode |
Mode of entry for the payment |
Not Applicable |
Not Applicable |
|
Username |
Username of the user who completed the transaction |
Not Applicable |
Not Applicable |
|
Remarks |
Any additional remarks or notes related to the transaction |
Not Applicable |
Not Applicable |
|
Check Number |
The unique tracking number assigned to a specific food, beverage, or retail bill within the property's point-of-sale system. |
Not Applicable |
Not Applicable |
|
Tax Invoice |
The official, legally compliant receipt issued to a guest that details the breakdown of charges, taxable amounts, and applicable government taxes for their stay or purchase. |
Not Applicable |
Not Applicable |
|
POS Check Number |
The direct reference identifier generated by an external Point of Sale outlet (like a restaurant or spa) used to sync and track charges transferred to a guest's room folio. |
Not Applicable |
Not Applicable |
|
Approval Code |
The numeric or alphanumeric authorization code issued by a bank or credit card processor confirming that funds have been successfully held or approved for a transaction. |
Not Applicable |
Not Applicable |
|
Transaction Reference Number |
A unique master identification sequence generated by the system to track, audit, and trace a specific financial posting or payment entry on a ledger. |
Not Applicable |
Not Applicable |
Group Section : A comprehensive list of payment activities at the Group Master level.
Available Report Columns for Following Sections:
|
Column Name |
Column Description |
Amount Includes Taxes and Fees |
Calculation |
|
Date |
Transaction date |
Not Applicable |
Not Applicable |
|
Time |
Transaction time |
Not Applicable |
Not Applicable |
|
Group Code |
Unique identification number associated with the Group Master |
Not Applicable |
Not Applicable |
|
Group Name |
Name of the Group Master |
Not Applicable |
Not Applicable |
|
Folio Number |
A unique, system-generated identification number assigned to a specific financial account or bill (folio) within a reservation. |
Not Applicable |
Not Applicable |
|
Company Name |
Name of the company associated with the reservation, if applicable |
Not Applicable |
Not Applicable |
|
Payment Type |
Type of payment made |
Not Applicable |
Not Applicable |
|
Last 4 Digits |
Last four digits of the payment card |
Not Applicable |
Not Applicable |
|
Amount |
Transaction amount |
Not Applicable |
Not Applicable |
|
Entry Mode |
Mode of entry for the payment |
Not Applicable |
Not Applicable |
|
Username |
Username of the user who completed the transaction |
Not Applicable |
Not Applicable |
|
Remarks |
Any additional remarks or notes related to the transaction |
Not Applicable |
Not Applicable |
|
Check Number |
The unique tracking number assigned to a specific charge , food, beverage, or bill within the property's point-of-sale system. |
Not Applicable |
Not Applicable |
|
Tax Invoice |
The official, legally compliant receipt issued to a guest that details the breakdown of charges, taxable amounts, and applicable government taxes for their stay or purchase. |
Not Applicable |
Not Applicable |
|
POS Check Number |
The direct reference identifier generated by an external Point of Sale used to sync and track charges transferred to a guest's room folio. |
Not Applicable |
Not Applicable |
|
Approval Code |
The numeric or alphanumeric authorization code issued by a bank or payment processor confirming that funds have been successfully held or approved for a transaction. |
Not Applicable |
Not Applicable |
|
Transaction Reference Number |
A unique master identification sequence generated by the system to track, audit, and trace a specific financial posting or payment entry on a ledger. |
Not Applicable |
Not Applicable |
House Account Section: A comprehensive list of payment activities at the House Account level.
Available Report Columns for Following Sections:
|
Column Name |
Column Description |
Amount Includes Taxes and Fees |
Calculation |
|
Date |
Transaction date |
Not Applicable |
Not Applicable |
|
Time |
Transaction time |
Not Applicable |
Not Applicable |
|
House Account Name |
Name of the House Account |
Not Applicable |
Not Applicable |
|
House Account Code |
Unique identifier associated with the House Account |
Not Applicable |
Not Applicable |
|
Folio Number |
A unique, system-generated identification number assigned to a specific financial account or bill (folio) within a reservation. |
Not Applicable |
Not Applicable |
|
Company Name |
Name of the company associated with the reservation, if applicable |
Not Applicable |
Not Applicable |
|
Payment Type |
Type of payment made |
Not Applicable |
Not Applicable |
|
Last 4 Digits |
Last four digits of the payment card |
Not Applicable |
Not Applicable |
|
Amount |
Transaction amount |
Not Applicable |
Not Applicable |
|
Entry Mode |
Mode of entry for the payment |
Not Applicable |
Not Applicable |
|
Username |
Username of the user who completed the transaction |
Not Applicable |
Not Applicable |
|
Remarks |
Any additional remarks or notes related to the transaction |
Not Applicable |
Not Applicable |
|
Check Number |
The unique tracking number assigned to a specific charge , food, beverage, or bill within the property's point-of-sale system. |
Not Applicable |
Not Applicable |
|
Tax Invoice |
The official, legally compliant receipt issued to a guest that details the breakdown of charges, taxable amounts, and applicable government taxes for their stay or purchase. |
Not Applicable |
Not Applicable |
|
POS Check Number |
The direct reference identifier generated by an external Point of Sale used to sync and track charges transferred to a guest's room folio. |
Not Applicable |
Not Applicable |
|
Approval Code |
The numeric or alphanumeric authorization code issued by a bank or payment processor confirming that funds have been successfully held or approved for a transaction. |
Not Applicable |
Not Applicable |
|
Transaction Reference Number |
A unique master identification sequence generated by the system to track, audit, and trace a specific financial posting or payment entry on a ledger. |
Not Applicable |
Not Applicable |
Company Account Settlements Section : A comprehensive list of payment activities at the account receivable level.
Available Report Columns for Following Sections:
|
Column Name |
Column Description |
Amount Includes Taxes and Fees |
Calculation |
|
Date |
Transaction date |
Not Applicable |
Not Applicable |
|
Time |
Transaction time |
Not Applicable |
Not Applicable |
|
Company Name |
Name of the company associated with the reservation, if applicable |
Not Applicable |
Not Applicable |
|
Payment Type |
Type of payment made |
Not Applicable |
Not Applicable |
|
Last 4 Digits |
Last four digits of the payment card |
Not Applicable |
Not Applicable |
|
Amount |
Transaction amount |
Not Applicable |
Not Applicable |
|
Entry Mode |
Mode of entry for the payment |
Not Applicable |
Not Applicable |
|
Username |
Username of the user who completed the transaction |
Not Applicable |
Not Applicable |
|
Remarks |
Any additional remarks or notes related to the transaction |
Not Applicable |
Not Applicable |
|
Check Number |
The unique tracking number assigned to a specific charge , food, beverage, or bill within the property's point-of-sale system. |
Not Applicable |
Not Applicable |
|
Tax Invoice |
The official, legally compliant receipt issued to a guest that details the breakdown of charges, taxable amounts, and applicable government taxes for their stay or purchase. |
Not Applicable |
Not Applicable |
|
POS Check Number |
The direct reference identifier generated by an external Point of Sale used to sync and track charges transferred to a guest's room folio. |
Not Applicable |
Not Applicable |
|
Approval Code |
The numeric or alphanumeric authorization code issued by a bank or payment processor confirming that funds have been successfully held or approved for a transaction. |
Not Applicable |
Not Applicable |
|
Transaction Reference Number |
A unique master identification sequence generated by the system to track, audit, and trace a specific financial posting or payment entry on a ledger. |
Not Applicable |
Not Applicable |
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.
-
Bar Chart: ability to display amount data in a bar chart view.
-
Group By: ability to group data All, Payment Type, and Username
-
Pie Chart: ability to view grouped data in a Pie Chart view.
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
-
-