Summary
GuestPay customers will now benefit from being able to access a new Funding report directly from Rezlynx. This data export will show users with details of their GuestPay bank transfers for each of the MIDs, reported by day of the funding.
Report Location
In Rezlynx, any user who is part of the ‘Admins’ user group will be able to access this new
‘Guest Journey > Billing > Payments Reconciliation’.
What will the report include?
The output is a CSV extract and can be filtered for a single date or by a Date Range. A number of data points are included in the extract.
| 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 |
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.
Example export:
FAQs
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 Guestline’s 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.
Comments
0 comments
Article is closed for comments.