Payment Link Details .ng

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β”‚
β””β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”΄β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”΄β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”˜

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.

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.

Image 9-30-26 at 1.24β€―PM.png
Payment Link Details Report

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.

Reservation / Profile > Description

N/A

First Name

Primary guest or payer first name associated with the transaction.

Guest Profile > First Name

N/A

Last Name

Primary guest or payer last name associated with the transaction.

Guest Profile > Last Name

N/A

Transaction Number

Unique reference identifier assigned to the reservation, group block, or house account (e.g., DEMO4005505, SNS).

System Master ID

N/A

Start Date

Scheduled arrival date, event start date, or payment link activation date.

Reservation / Event > Start Date

N/A

End Date

Scheduled departure date, event end date, or payment link expiration deadline.

Reservation / Event > End Date

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 (EXECUTED, PENDING, EXPIRED).

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

Image 9-29-26 at 1.04β€―PM.png

Knowledge Article

Opens the knowledge base article to learn how to interpret this report.

Image 9-29-26 at 12.37β€―PM.png

Saved Views

Saves your column filtering, sorting, and highlight preferences so you can easily reload your custom view later without reconfiguring the report.

Image 9-29-26 at 12.39β€―PM.png

Filter

Opens filter controls to isolate specific data within a column based on your selected criteria.

Image 9-29-26 at 12.40β€―PM.png

Highlight

Highlights column values in a designated color based on selected conditions.

Image 9-29-26 at 12.42β€―PM.png

Export

Exports and downloads the report in various formats (Excel, PDF, CSV) for offline analysis or printing.

Image 9-29-26 at 12.43β€―PM.png

Configure

Opens column selection controls to toggle visibility, reorder columns, or hide rows with all zeros.

Image 9-29-26 at 12.44β€―PM.png

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.

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.