Payments reconciliation report (FRR)
The Payments Reconciliation report provides GuestPay customers with the benefit of being able to access this reconciliation report, directly from Rezlynx. The data export will show users the details of their GuestPay bank transfers for each MID, reported by day of funding.
⚠️Important: Data is ingested into Guestlines' data store at around 09:30 (UK time) each funding day. Ensure you wait for this process to complete before running this report.
To access the Payment Reconciliation report, follow the steps below:
Navigate to Payment Reconciliation, in either of the ways outlined below:
In Rezlynx select Home, then under GuestPay Hub select Payments Reconciliation.
In Rezlynx select Guest Journey, then under Billing select Payments Reconciliation.
Set the report filters as required, the filters include:
Date the transaction was processed, rather than the day it was paid into the site's bank account.
Descriptors are the card statement descriptor or property name.
Type that can be selected, including:
Reconciliation - A full report of the chargebacks, fees and adjustments as well as full payments made.
Chargebacks - The sum of charges that are returned to a payment card after a customer successfully disputes an item.
Adjustments - Any adjustments that have been applied to the account
Click Export to download the report.
⚠️Important: The data extracted will sometimes include each of the MIDs for a group of associated hotels and not just the site the user is logged into. This depends on the business entity configuration within Trust Payments.
The output is a CSV extract and can be filtered for a single date or by a Date Range.
An example of the exported report can be seen below:
A number of data points are included in the extract, and are shown below:
Column | Description |
MID | A merchant ID (or MID) is a unique identification number attached to a business that tells the payment processing systems involved in a transaction where to send which funds. |
TradingDate | The Date the transaction was processed. |
Gross | The total value of the payments. |
DCCComm | Dynamic Currency Conversion Commission. |
Chargeback | The sum of charges that are returned to a payment card after a customer successfully disputes an item. |
Fees | The cost of processing the card payments. |
Adjustments | Any adjustments that have been applied to the account. |
Nett | The Gross value, less Chargebacks and Fees. |
Payments | The value deposited in the Merchants Bank Account. |
PaymentId | The reference that will appear in the Merchants Bank Account for the given transaction. |
Funding Date | The date the monies were deposited in the Merchants Bank Account. |
Frequently asked question's
Why are dates missing in the exported data?
There were no transactions on that MID on that date.
Will I see all transactions that have gone through GuestPay in this data?
No. Alternative Payment Methods (APMs) and American Express (AMEX) transactions will NOT appear in this data.
I attempted to export data for the previous day, but nothing exports. Why?
Data is ingested into Guestlines data store at around 09:30 (UK time) each funding day. Please ensure you wait for this process to complete.
In addition, Funding does not take place at weekends.
Some rows are missing a Payment Value, Payment Id & Funding date. Why?
There could be a number of reasons for this. For example:
The value of the payment was less than the threshold of 25.00 and therefore is rolled over to the next day, or until the value is greater than the cut-off threshold.
A ‘Pay Hold’ has been put in place by the Gateway.