All Payments Report .ng
Report Description: Provides a comprehensive breakdown of all payment transactions processed at the property within a selected date range. This report is essential for finance teams and night auditors to reconcile PMS activity with external payment processors. By utilising the "Group By Payment Type" feature, users can instantly see subtotals for different payment methods (e.g., Cash, Visa, Mastercard, AMEX), eliminating manual calculations and reducing the risk of errors during bank reconciliation.
Date Range: This report can render data for up to 365 days in the past.
Available Report Columns for Following Sections:
Column Name | Column Description | Amount Includes Taxes and Fees | Calculation |
Date | The date the payment transaction was processed | Not Applicable | Not Applicable |
Time | The specific timestamp of the transaction | Not Applicable | Not Applicable |
Type | Indicates the category of the entity (e.g., Reservation, Company, House Account) | Not Applicable | Not Applicable |
Code | Unique identifier or Confirmation Number associated with the transaction | Not Applicable | Not Applicable |
Name | Name of the guest or entity associated with the payment | Not Applicable | Not Applicable |
External Confirmation Number | The confirmation number provided by an external booking source | Not Applicable | Not Applicable |
Company Name | Name of the company associated with the transaction (if applicable) | Not Applicable | Not Applicable |
Payment Type | The method used for payment (e.g., Cash, Visa, Mastercard, AMEX) | Not Applicable | Not Applicable |
Payment Type Code | The short-hand code for the specific payment method | Not Applicable | Not Applicable |
Cost Centre | Financial department code assigned to the transaction | Not Applicable | Not Applicable |
GL Account Code | General Ledger account mapping for the transaction | Not Applicable | Not Applicable |
Last 4 Digits | Shows only the last four digits of the credit card used for security | Not Applicable | Not Applicable |
Amount | The specific monetary value of the individual transaction | YES | =sum(amount) |
External Invoice Number | The invoice number generated by an external system | Not Applicable | Not Applicable |
Invoice Date | The date the associated invoice was generated | Not Applicable | Not Applicable |
Invoice Number | Unique identifier for the specific PMS invoice | Not Applicable | Not Applicable |
Entry Mode | Indicates how the payment was entered (e.g., Manual, Swiped, Electronic) | Not Applicable | Not Applicable |
Username | The name of the user who processed the payment | Not Applicable | Not Applicable |
Remarks | Contextual notes or justifications added to the payment entry | Not Applicable | Not Applicable |
Approval Code | The authorisation code received from the payment processor | Not Applicable | Not Applicable |
Transaction Reference Number | A unique reference ID for the specific financial transaction | Not Applicable | Not Applicable |
POS Check Number | The identifier for a related Point of Sale transaction check | Not Applicable | Not Applicable |
External Transaction Number | The transaction ID provided by the external payment gateway | Not Applicable | Not Applicable |
Misc Report Information:
Available Features:
Export: Ability to download and save the report into alternate formats. Grouping and totals are preserved in supported grouped layouts.
Filter: Ability to narrow down results based on specific dates, users, or payment codes.
Highlight: Conditional formatting to identify high-value transactions or specific entry modes.
Grouping: Ability to view the data grouped by: Payment Type, Date, or Entry Mode.
Note: Selecting "Payment Type" organises transactions under each type header with automatic subtotals.
Subtotals: Automatic calculation of the sum of the "Amount" column for each specific payment group.
Grand Total: A final cumulative total for the "Amount" column is displayed at the end of the report output.
Available Configuration:
User Preferences: Allows users to reposition or hide columns to focus on specific reconciliation data.
Property Preferences: Allows the property to standardise the report view for all audit staff.
Baseline Configuration:
Property Preferences Settings:
Following columns to be disabled for initial deployment: None.