All Payments Report .ng
Report Description: : The All Payments Report provides a comprehensive view of all payment transactions recorded in the system across reservations, group masters, and house accounts.
The All Payments Report acts as a single source of truth for all payment transactions, ensuring transparency, accuracy, and efficient financial control across the system.
Date Range: This report can render the data for up to 365 days
Details section: Provides a list of reservations with
Available Report Columns for Following Sections:
Column Name | Column Description | Amount Includes Taxes and Fees | Calculation |
Date | The business date on which the payment transaction was posted. | Not Applicable | Not Applicable |
Time | The exact time when the payment was recorded in the system. | Not Applicable | Not Applicable |
Type | Indicates the source of the payment (Reservation, Group Master, or House Account). | Not Applicable | Not Applicable |
Code | The unique system code identifying the reservation, group, or house account. | Not Applicable | Not Applicable |
Name | The guest name, group name, or house account name associated with the payment. | Not Applicable | Not Applicable |
External Confirmation Number | The confirmation or reference number provided by an external system or channel. | Not Applicable | Not Applicable |
Company Name | The company linked to the reservation or account. | Not Applicable | Not Applicable |
Payment Type | The method used to make the payment (e.g., Cash/Credit Card et) | Not Applicable | Not Applicable |
Payment Type Code | The system-defined code representing the payment method. | Not Applicable | Not Applicable |
Cost Centre | The accounting cost centre to which the payment is mapped. | Not Applicable | Not Applicable |
GL Account Code | The general ledger account code used for financial posting. | Not Applicable | Not Applicable |
Last 4 Digits | The last four digits of the card used. | Not Applicable | Not Applicable |
Amount | The payment amount posted in the transaction (positive or negative). | Yes | Not Applicable |
External Invoice Number | The invoice number generated or referenced by an external system. | Not Applicable | Not Applicable |
Invoice Date | The date on which the invoice was issued. | Not Applicable | Not Applicable |
Invoice Number | The internal invoice number generated by the PMS. | Not Applicable | Not Applicable |
Entry Mode | Indicates how the payment was entered (Manual, Auto-posted, POS, Integration). | Not Applicable | Not Applicable |
Username | The system user who processed or posted the payment. | Not Applicable | Not Applicable |
Remarks | Any notes or comments entered at the time of payment posting. | Not Applicable | Not Applicable |
Approval Code | The authorization code received from the payment processor or bank. | Not Applicable | Not Applicable |
Transaction Reference Number | The unique reference number returned by the payment gateway or bank. | Not Applicable | Not Applicable |
POS Check Number | The check or bill number generated by the POS system for the payment. | 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.
Available Configuration:
User Preferences: allows the user to customise their report view by repositioning or removing columns.
Property Preferences: allows the property to customise the report view for all users by repositioning or removing columns.
Baseline Configuration:
Property Preferences Settings:
Following columns to be disabled for initial deployment:
Digital Key
Digital Check In
Property Code