Expired Payment Source .ng
Report Description: The Expired Payment Source Report provides a comprehensive list of Expired payment activities conducted on a defined date. The report includes transaction details such as confirmation number, reservation status, guest name, loyalty tier, room type and rate plan, source of the payment, booking date, arrival and departure date, number of nights, guarantee type, last 4 digits of the the credit card, indication of virtual card and if the credit card is expired.
Date Range: This report can render the data for up to 366 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 |
Confirmation Number | Unique identifier for the reservation confirmation | Not Applicable | Not Applicable |
Status | Status of the Reservation | Not Applicable | Not Applicable |
Guest Name | Name of the primary guest associated with the reservation | Not Applicable | Not Applicable |
Loyalty Tier | Loyalty tier name on the reservation, if applicable | Not Applicable | Not Applicable |
Room Type | Room type code of the reservation (example - KNGN) | Not Applicable | Not Applicable |
Rate Plan | Rate plan code on the reservation | Not Applicable | Not Applicable |
Source | Information on the source of the reservation | Not Applicable | Not Applicable |
Booking Date | Date of the booking | Not Applicable | Not Applicable |
Arrival Date | Date the guest is scheduled to arrive | Not Applicable | Not Applicable |
Departure Date | Date the guest is scheduled to depart | Not Applicable | Not Applicable |
Nights | Number of nights on the reservation | Not Applicable | Not Applicable |
Guarantee Type | Guarantee type on the reservation (example - Property Guarantee, Credit Card) | Not Applicable | Not Applicable |
Last 4 Digits | Last four digits of the payment card | Not Applicable | Not Applicable |
Virtual CC | Indicates if the reservation has a virtual credit card as a guarantee type. | Not Applicable | Not Applicable |
Expired CC | Indicates if the credit card on the reservation is expired. | 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 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