Payment Link Details Report Overview
Parent Hub: π° Finance & Accounting Reports
Category: π³ Payments & Transactions
Target Roles: Directors of Finance & Controllers, Night Auditors, Front Office Managers, E-Commerce & Reservation Staff, Cashiers
Key Value: Maintain complete oversight of digital remote payment requests, tracking payment link issuance, customer settlement statuses, expired link tracking, and staff sender attributions.
Executive Summary
The Payment Link Details Report is a key digital payment governance and remote settlement audit tool within the π³ Payments & Transactions category of the π° Finance & Accounting Reports suite. Designed for contactless revenue collection, pre-arrival deposit enforcement, and remote guest folio settlements, it provides a comprehensive transaction log of all digital payment links generated and dispatched to guests and clients.
By capturing transaction metadata (Transaction Description, Transaction Number, First Name, Last Name), stay/event timelines (Start Date, End Date), payment parameters (Payer Name, PAYMENT AMOUNT), link processing states (Status), and staff sender attributions (Payment Link Senders User Name), this report enables controllers, front office managers, and reservation teams to monitor remote revenue pipelines, audit completed digital payments, track uncollected expired links, and ensure staff accountability in link generation.
Key Capabilities
-
Digital Settlement Lifecycle Tracking: Monitors remote payment link progress across all active processing states (EXECUTED, PENDING, EXPIRED).
-
Remote Revenue Pipeline Oversight: Tracks pending pre-arrival deposits and event prepayments prior to guest arrival.
-
Staff Issuance & Audit Attribution: Identifies the exact staff member or email address (Payment Link Senders User Name) that generated and sent each payment link.
Report Views & Functional Breakdown
The Payment Link Details Report presents digital payment link activity in a unified single-table ledger that supports three distinct analytical perspectives:
ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ
β PAYMENT LINK DETAILS REPORT β
ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ€
β Unified Transaction Ledger β
ββββββββββββββββββββββββββββ¬βββββββββββββββββββββββββββ¬βββββββββββββββββββ€
β 1. Active & Pending Link β 2. Executed Settlement β 3. Expired Link β
β Pipeline β & Revenue Audit β & Sender β
β β β Accountabilityβ
ββββββββββββββββββββββββββββ΄βββββββββββββββββββββββββββ΄βββββββββββββββββββ
1. Active & Pending Link Pipeline
Monitors outstanding payment links dispatched to guests or clients that are currently awaiting completion.
-
Primary Use: Tracking uncollected pre-arrival deposits, following up with guests on outstanding payment links, and preventing unpaid check-ins.
-
Key Metrics: Transaction Number, Transaction Description, Payer Name, PAYMENT AMOUNT, Start Date, End Date, Status (
PENDING), Payment Link Senders User Name.
2. Executed Settlement & Revenue Audit
Itemizes completed digital payment transactions processed successfully through guest payment links.
-
Primary Use: Reconciling remote payment collections against general ledger accounts, verifying prepayment captures, and auditing completed digital transactions.
-
Key Metrics: Transaction Number, Transaction Description, Payer Name, PAYMENT AMOUNT, Status (
EXECUTED), Payment Link Senders User Name.
3. Expired Link & Sender Accountability
Identifies payment links that timed out prior to payment execution and attributes link issuance to specific employees.
-
Primary Use: Evaluating uncollected link revenue, re-issuing expired payment links to guests, and auditing staff adoption and usage of digital payment features.
-
Key Metrics: Transaction Number, Transaction Description, Payer Name, PAYMENT AMOUNT, Status (
EXPIRED), Payment Link Senders User Name.
Data Dictionary (Dynamic View Columns)
Customize your default view using the Configure (βοΈ) icon on the report page. Below is the full data dictionary representing every column available in this report:
π‘ Monetary Treatment Note: PAYMENT AMOUNT represents Gross Monetary Values (Includes Taxes & Fees) requested or processed via the remote payment link.
|
Column Name |
Description |
Data Source / System Mapping |
Includes Taxes & Fees? |
|
Transaction Description |
Full guest name, group event title, or descriptive summary assigned to the payment link request. |
|
N/A |
|
First Name |
Primary guest or payer first name associated with the transaction. |
|
N/A |
|
Last Name |
Primary guest or payer last name associated with the transaction. |
|
N/A |
|
Transaction Number |
Unique reference identifier assigned to the reservation, group block, or house account (e.g., |
System Master ID |
N/A |
|
Start Date |
Scheduled arrival date, event start date, or payment link activation date. |
|
N/A |
|
End Date |
Scheduled departure date, event end date, or payment link expiration deadline. |
|
N/A |
|
Payer Name |
Name of the person or corporate representative who executed or is requested to execute the payment. |
Payment Gateway / Link Entry |
N/A |
|
PAYMENT AMOUNT |
Gross monetary amount requested, pending, or collected via the payment link. |
Payment Link Engine |
π’ Yes |
|
Status |
Processing state of the payment link ( |
Payment Link Engine |
N/A |
|
Payment Link Senders User Name |
Staff user ID or email address of the employee who generated and dispatched the payment link. |
System Audit Log |
N/A |
Customization & Platform Features
User & Property Preferences
-
Personal Preference: Tailor your individual view by hiding or dragging columns. Your preferences save automatically for future sessions.
-
Property Defaults: System Admins can configure standard default layouts across all property users to streamline operational reporting. To maximize audit efficiency, group the columns into the below logical blocks:
-
Transaction & Account Anchors (Cols 1β4):
Transaction Number|Transaction Description|First Name|Last Name -
Link Window & Status Control (Cols 5β7):
Status|Start Date|End Date -
Payer & Sender Metadata (Cols 8β9):
Payer Name|Payment Link Senders User Name -
Financial Settlement (Col 10):
Payment Amount
-
Report Toolbar & Quick Actions
Use the top-right toolbar icons on the report page to manage and export your data view:
|
Icon |
Action / Feature |
Description |
|
Knowledge Article |
Opens the knowledge base article to learn how to interpret this report. |
|
Saved Views |
Saves your column filtering, sorting, and highlight preferences so you can easily reload your custom view later without reconfiguring the report. |
|
Filter |
Opens filter controls to isolate specific data within a column based on your selected criteria. |
|
Highlight |
Highlights column values in a designated color based on selected conditions. |
|
Export |
Exports and downloads the report in various formats (Excel, PDF, CSV) for offline analysis or printing. |
|
Configure |
Opens column selection controls to toggle visibility, reorder columns, or hide rows with all zeros. |
|
Additional Configuration |
Provides advanced report configuration and display formatting options to customize data presentation. |
Advanced Controls
-
Exporting & Gateway Reconciliation: Download in Excel or PDF format to support digital payment auditing, pre-arrival deposit tracking, and merchant gateway reconciliations.
-
Filtering: Filter data by specific Status (
EXECUTED,PENDING,EXPIRED), Payment Link Senders User Name, or date ranges. -
Highlighting (Conditional Formatting): Apply custom rules to automatically highlight high-value pending payment links (
PAYMENT AMOUNT > $1,000.00) or expired requests.
π Related Reports & Next Steps
Within π³ Payments & Transactions & βοΈ Ledgers & Trial Balance:
-
Authorized Payments β Audit credit card authorization holds, capture approvals, and card refund processing.
-
All Payments β Complete transaction ledger logging all cash, check, credit card, and direct-bill payment receipts.
-
Payment Activity β Technical transaction log focusing specifically on card pre-authorizations and settlement tokens.
-
Adjustments & Refunds Activity β Track rate write-offs, charge adjustments, and cash/card refund transactions.
-
Day End Summary β Review consolidated daily revenue, tax, payment, and deposit blueprints at business date close.
Cross-Pillar Deep Dives:
-
π₯ Group Blocks: To inspect group master prepayments and group payment links, review Group Reservations.
-
π¬ Billing & Receivables (AR): To inspect corporate accounts receivable remote payment links, review Direct Bill Ledger Details.