Declined Payments .ng
Report Description: The Declined Payments report is used to track, monitor, and follow up on failed payment attempts for both individual reservations and group accounts. It helps ensure outstanding balances are identified early and resolved to prevent revenue loss, check-in delays, or billing disputes.
Date Range: Current day and up to 365 days in the past
Available Report Columns for Following Sections:
Reservations Section:
This section captures declined payment attempts tied to individual guest reservations. It allows staff to quickly identify which reservations have payment issues and take corrective action before arrival or checkout.
Column Name | Column Description | Amount Includes Taxes and Fees | Calculation |
Date | Indicates the calendar date when the payment was declined | Not Applicable | Not Applicable |
Time | Shows the exact time the declined payment attempt occurred | Not Applicable | Not Applicable |
Confirmation Number | Uniquely identifies the reservation in the system | Not Applicable | Not Applicable |
External Confirmation Number | References the reservation ID from an external booking source or channel | Not Applicable | Not Applicable |
Guest Name | Identifies the guest associated with the declined payment | Not Applicable | Not Applicable |
Payment Type | Specifies the method of payment used (e.g., credit card, direct bill) | Not Applicable | Not Applicable |
Masked Card Number | Displays a secure, partial card number for payment identification | Not Applicable | Not Applicable |
Company Name | Identifies the associated company if the reservation is billed corporately | Not Applicable | Not Applicable |
Room Number | Indicates the room assigned to the reservation | Not Applicable | Not Applicable |
Reservation Status | Shows the current state of the reservation (e.g., booked, checked in, checked out) | Not Applicable | Not Applicable |
User Name | Identifies the user who attempted the payment transaction | Not Applicable | Not Applicable |
Declined Amount | Shows the amount that failed to process | Yes | Not Applicable |
Reservation Balance | Displays the remaining unpaid balance on the reservation | Yes | Not Applicable |
Group Section:
This section captures declined payment attempts tied to Group reservations. It allows staff to quickly identify which reservations have payment issues and take corrective action before arrival or checkout.
Column Name | Column Description | Amount Includes Taxes and Fees | Calculation |
Date | Indicates the calendar date when the payment was declined | Not Applicable | Not Applicable |
Time | Shows the exact time the declined payment attempt occurred | Not Applicable | Not Applicable |
Group Number | Uniquely identifies the group or master account in the system | Not Applicable | Not Applicable |
External Confirmation Number | References the reservation ID from an external booking source or channel | Not Applicable | Not Applicable |
Group Name | Identifies the name of the group | Not Applicable | Not Applicable |
Masked Card Number | Displays a secure, partial card number for payment identification | Not Applicable | Not Applicable |
Company Name | Identifies the associated company if the reservation is billed corporately | Not Applicable | Not Applicable |
User Name | Identifies the user who attempted the payment transaction | Not Applicable | Not Applicable |
Declined Amount | Shows the amount that failed to process | Yes | Not Applicable |
Reservation Status | Indicates the current status of the group reservation or account | Not Applicable | Not Applicable |
Group Balance | Displays the remaining unpaid balance for the group account | Yes | 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 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