Enterprise Report - Payment Details .ng
Enterprise Payment Details Report
Report Description: The Enterprise Payment Details Report offers a comprehensive list of rate payment transactions made within a specified period, showcasing transaction details such as date, time, type, number, amount, and property information, facilitating financial tracking and transaction reconciliation at the Enterprise level for Reservations, Groups, House Accounts, and Company Direct Bills.
Date Range: This report can render the data for up to 365 days in the past or future
Reservation section: The reservation section provides a detailed list of payments made on reservations.
Available Report Columns for Following Sections:
Column Name | Column Description | Amount Includes Taxes and Fees | Calculation |
Property Code | Identifies the hotel code | Not Applicable | Not Applicable |
Property Name | Identifies the name of the hotel | Not Applicable | Not Applicable |
Property City | Identifies the City the hotel is operating | Not Applicable | Not Applicable |
Property State | Identifies the State the hotel is operating | Not Applicable | Not Applicable |
Date | Date of the transaction (ex - March 25, 2024) | Not Applicable | Not Applicable |
Time | Time of the transaction (ex - 05:39:49 AM) | Not Applicable | Not Applicable |
Confirmation Number | Reservation confirmation number | Not Applicable | Not Applicable |
Guest Name | Primary guest name on the reservation | Not Applicable | Not Applicable |
Company Name | Local direct bill company code | Not Applicable | Not Applicable |
Room Number | Room number associated with the reservation | Not Applicable | Not Applicable |
Payment Type | Payment type on the reservation (example - Credit Card, Direct Bill, VCC) | Not Applicable | Not Applicable |
Last 4 Digits | Last 4 digits of the credit card on the reservation | Not Applicable | Not Applicable |
Amount | Total amount collected for the reservation details | Not Applicable | =sum(Adjusted Amount) |
Username | Username that processed that transaction | Not Applicable | Not Applicable |
Remarks | Additional remarks regarding the transaction | Not Applicable | Not Applicable |
Groups section: The groups section provides a detailed list of payments made on group masters.
Available Report Columns for Following Sections:
Column Name | Column Description | Amount Includes Taxes and Fees | Calculation |
Property Code | Identifies the hotel code | Not Applicable | Not Applicable |
Property Name | Identifies the name of the hotel | Not Applicable | Not Applicable |
Property City | Identifies the City the hotel is operating | Not Applicable | Not Applicable |
Property State | Identifies the State the hotel is operating | Not Applicable | Not Applicable |
Date | Date of the transaction (ex - March 25, 2024) | Not Applicable | Not Applicable |
Time | Time of the transaction (ex - 05:39:49 AM) | Not Applicable | Not Applicable |
Group Number | Group confirmation number | Not Applicable | Not Applicable |
Group Name | Name of the group | Not Applicable | Not Applicable |
Company Name | Local direct bill company name | Not Applicable | Not Applicable |
Payment Type | Payment type on the group master (example - Credit Card, Direct Bill, VCC) | Not Applicable | Not Applicable |
Last 4 Digits | Last 4 digits of the credit card on the reservation | Not Applicable | Not Applicable |
Amount | Total amount collected for the group master details | Not Applicable | =sum(Adjusted Amount) |
Username | Username that processed that transaction | Not Applicable | Not Applicable |
Remarks | Additional remarks regarding the transaction | Not Applicable | Not Applicable |
Currency | Local monetary value | Not Applicable | Not Applicable |
House Account section: The house account section provides a detailed list of payments made on group masters.
Available Report Columns for Following Sections:
Column Name | Column Description | Amount Includes Taxes and Fees | Calculation |
Property Code | Identifies the hotel code | Not Applicable | Not Applicable |
Property Name | Identifies the name of the hotel | Not Applicable | Not Applicable |
Property City | Identifies the City the hotel is operating | Not Applicable | Not Applicable |
Property State | Identifies the State the hotel is operating | Not Applicable | Not Applicable |
Date | Date of the transaction (ex - March 25, 2024) | Not Applicable | Not Applicable |
Time | Time of the transaction (ex - 05:39:49 AM) | Not Applicable | Not Applicable |
House Account Code | Unique identifier for the house account | Not Applicable | Not Applicable |
House Account Name | Name on the house account | Not Applicable | Not Applicable |
Company Name | Local direct bill company name | Not Applicable | Not Applicable |
Payment Type | Payment type on the house account (example - Credit Card, Direct Bill, VCC) | Not Applicable | Not Applicable |
Last 4 Digits | Last 4 digits of the credit card on the house account | Not Applicable | Not Applicable |
Amount | Total amount collected for the reservation details | Not Applicable | =sum(Adjusted Amount) |
Username | Username that processed that transaction | Not Applicable | Not Applicable |
Remarks | Additional remarks regarding the transaction | Not Applicable | Not Applicable |
Currency | Local monetary value | Not Applicable | Not Applicable |
Company Account Settlements section: The company account settlements section provides a detailed list of payments made on company direct bill accounts.
Available Report Columns for Following Sections:
Column Name | Column Description | Amount Includes Taxes and Fees | Calculation |
Property Code | Identifies the hotel code | Not Applicable | Not Applicable |
Property Name | Identifies the name of the hotel | Not Applicable | Not Applicable |
Property City | Identifies the City the hotel is operating | Not Applicable | Not Applicable |
Property State | Identifies the State the hotel is operating | Not Applicable | Not Applicable |
Date | Date of the transaction (ex - March 25, 2024) | Not Applicable | Not Applicable |
Time | Time of the transaction (ex - 05:39:49 AM) | Not Applicable | Not Applicable |
Company Name | Local direct bill company name | Not Applicable | Not Applicable |
Payment Type | Payment type on the house account (example - Credit Card, Direct Bill, VCC) | Not Applicable | Not Applicable |
Last 4 Digits | Last 4 digits of the credit card on the house account | Not Applicable | Not Applicable |
Amount | Total amount collected for the reservation details | Not Applicable | =sum(Adjusted Amount) |
Username | Username that processed that transaction | Not Applicable | Not Applicable |
Remarks | Additional remarks regarding the transaction | Not Applicable | Not Applicable |
Currency | Local monetary value | 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.
Group By: ability to group data All, Transaction Code, Transaction Description or Transaction Type
Available Configuration:
Enterprise Preferences: allows the property to customize the report view for all users by repositioning or removing columns.