Overview
The RMS Pay Settlement Report allows RMS Pay customers to view transaction details, fees, and payout amounts for any RMS Pay transactions, organised by accounting date, settlement date, or batch ID. Transactions may take up to 3 business days to clear, and only those that have been processed will appear on the report.
The RMS Pay Settlement Report can be generated based on accounting date, settlement date, or batch ID. The batch ID can be matched with the deposit transaction on the bank statement when a payout is made.
Fees, Taxes, and Deductions
The RMS Pay Settlement Report provides a detailed breakdown of any fees and taxes associated with RMS Pay transactions. Only the fee columns relevant to your RMS Pay account will be displayed on the report. The fee schedule for your account is outlined in the sales contract.
The Tax column shows any GST applied to the listed fees, while the Total Fee column represents the cumulative total of all fees, including applicable GST.
By combining the individual fee amounts with the amount shown in the Tax column, you can verify the Total Fee displayed. This Total Fee is then deducted from the reported Receipt Amount to calculate the Payout Amount for that transaction.
Trust Accounting
Specialised Trust Accounting properties with gross billing will receive the full value of the shown receipt amount and will be invoiced post-payout for any applicable charges.
Payouts and Settlement
Transactions processed through RMS Pay will appear on the RMS Pay Settlement Report only after they have cleared processing. Processing may take up to three business days from the transaction date in RMS, with payments issued to the nominated bank account one business day after the transaction clears.
RMS Pay Settlement Time Zones
RMS Pay uses a designated settlement time zone for each supported currency. Settlement dates on the RMS Pay Settlement Report are based on these time zones, not necessarily on the property's local date and time.
Use the table below to see which time zone is used for RMS Pay settlement in each region.
| Region/Currency | RMS Pay Settlement Time Zone |
|---|---|
| Australia (AUD) | Australian Eastern Time - Sydney Local Time (AEST/AEDT)* |
| North America (USD, CAD) | Eastern Time (ET)* |
| United Kingdom (GBP) | UK Local Time (GMT/BST)* |
| Euro (EUR) | Central European Time (CET/CEST)* |
| Singapore (SGD) | Singapore Time (SGT) |
| Hong Kong (HKD) | Hong Kong Time (HKT) |
| Other RMS Pay currencies | RMS Pay uses a specific time zone per currency |
* These time zones observe daylight savings. RMS Pay settlement uses the local time in that region, including any daylight savings changes.
The settlement date on the RMS Pay Settlement Report is based on the time zone shown above and may differ from the calendar date at the property if the property is in a different time zone.
For further information on cut‑off times and payout timing by region, see the Payout Schedule article.
Settlement Date vs Accounting Date
The RMS Pay Settlement Report can be generated based on settlement date, accounting date, or batch ID.
Settlement Date corresponds to the RMS Pay settlement day and includes all RMS Pay transactions processed between 12:00 AM and 11:59 PM in the applicable RMS Pay settlement time zone (for example, Sydney time for AUD, Eastern Time (ET) for USD/CAD).
-
Accounting Date refers to the date when the transaction is created and will display all RMS Pay transactions for the selected accounting date, grouped by settlement date.
- For properties using manual end-of-day processing, RMS Pay transactions that occur after midnight but before the accounting date and are rolled forward will show multiple settlement dates on the Accounting Date version of the report.
- For properties with automatic end-of-day processing and a time set after midnight, RMS Pay transactions occurring between midnight and the selected end-of-day time will show multiple settlement dates on the Accounting Date version.
- For properties that use automatic end-of-day processing with a midnight time setting, only one accounting date will appear on the report.
Generating the report by Batch ID will include all RMS Pay transactions within the reported batch, grouped by settlement date.
Payout Amount
The RMS Pay Settlement Report provides a breakdown of the payout amount for each cleared RMS Pay transaction, organised by accounting date, settlement date, or batch ID. The payout amount for each transaction is calculated as the Receipt Amount minus the Total Fee for that transaction.
A negative payout may occur if the total fee exceeds the receipt amount, if a refund is issued, if a receipt is reversed, or in the event of a chargeback.
Chargebacks
A chargeback will be reported on the settlement date it is issued, not retrospectively on the original transaction's settlement date. When a chargeback occurs, it will appear as a negative value in the payout amount and will reduce the Total Payout Amount for that settlement date.
During the chargeback defence process, certain card types may require multiple steps to freeze or deduct the previously taken payment. Each action by the card type will be reflected on the settlement date it occurs, which may result in the chargeback appearing with a negative payout amount on multiple settlement dates.
Once the chargeback defence is finalised, the funds transition can be tracked across multiple RMS Pay settlement dates, including the original payment transaction date, the chargeback issued date, the date the chargeback funds were deducted (if applicable), and the date the chargeback payment was returned (if applicable).
Total Payout Amount
The Total Payout Amount for a settlement date on the RMS Pay Settlement Report represents the cumulative payout balance for all transactions processed on that date, minus any negative balance carried forward from a previous settlement date.
When generating the report by accounting date or across multiple settlement dates, the report will include multiple batch IDs and cannot be directly compared to a single deposit value on the bank statement.
The transaction description on the bank statement will display the settlement date in the format:
- [CLIENTID] RMSPAY [Accounting Date: YYMMDD]
- Sample: 00000RMSPAY250131
If the total payout amount for a single settlement date is negative, the balance will be carried forward to a future settlement date and deducted from subsequent payouts until the account returns to a positive balance.
The total payout amount will be negative if refunds exceed payments, chargebacks surpass payments, more receipts are reversed than payments taken, fees for reported transactions exceed the payment amount, or if a carried-forward negative balance exceeds the total payments made on that date.
Generate the RMS Pay Settlement Report
The RMS Pay Settlement Report displays all cleared RMS Pay transactions based on your selected criteria. It can be generated by accounting date, settlement date, or batch ID, and is available in both summary and detailed formats. The information provided will vary depending on the chosen report type.
In the side menu of RMS, go to Reports > Management > Financial > RMS Pay Settlement Report.
- Select a Report Option of 'By Settlement Date', 'By Accounting Date', or 'Batch ID'.
- Choose a Date Range or enter the Batch ID.
- Select a Report Type.
- Select Build.
Detailed Report
The detailed report provides comprehensive transaction information for each individual transaction.
The detailed report includes the following information:
| Report Column | Description |
| RMS Client ID | The unique identifying number for the Property in RMS. |
| Property Name | The name of the property. |
| PSP Reference | A unique identifying payment reference for the transaction that can be used when submitting a ticket or enquiry about the RMS Pay transaction. |
| Transaction Type | The type of transaction processed through RMS Pay including: Authorised, Chargeback, Chargeback Reversed, Refunded, Refused (Declined), Second Chargeback, and Settled. |
| Card Type | The card scheme used for the transaction. |
| Card Type Variant | The type of card as provided by the card issuer. |
| Accounting Date | The accounting date when the transaction was created. |
| Reservation Number | A unique identifying number for the reservation associated to the account where the transaction was created. |
| Account Number | A unique identifying number for the account where the transaction was created. |
| Currency | The currency used for the transaction. |
| Receipt Amount | The value entered as the 'Receipt Amount'. |
| Platform Fee | A variable percentage fee determined by the type of card used for the transaction as outlined in the sales agreement. |
| Scheme Fee * | A fixed fee for the transaction as outlined in the sales agreement. |
| Interchange Fee * | The value of the interchange fee applied to the transaction. |
| Transaction Fee | A fixed fee for the transaction as outlined in the sales agreement. |
| Tax | The sum of GST applied to all applicable fees for Australian properties. |
| Total Fee | The sum of fees including any GST applied to the transaction. |
| Payout Amount | The sum of the 'Receipt Amount' less 'Total Fee' included in the payout for that settlement date. |
| Batch ID | The unique identifying number for the 'Payout Batch' the transaction is included in. |
Summary Report
The summary report displays the total values for each settlement date within the selected date range. By selecting a specific batch date, the report expands to provide a detailed view, showing all transactions within that batch along with their individual totals.
The summary report includes the following information:
| Report Column | Description |
| Batch ID | The unique identifying number to identify the 'Payout Batch' that transactions is included in. |
| Accounting Date | The accounting date when the transaction was created. |
| Currency | The currency used for the transaction. |
| Receipt Amount | The total value entered as the 'Receipt Amount'. |
| Platform Fee | The value of the platform fee applied to the transaction. |
| Scheme Fee * | The value of the scheme fee applied to the transaction. |
| Interchange Fee * | The value of the interchange fee applied to the transaction. |
| Transaction Fee | The value of the transaction fee applied to the transaction. |
| Tax | The sum of any taxes applied to the fees applied to the transaction. |
| Total Fee | The sum of all listed fees and any applicable taxes applied to the transaction. |
| Payout Amount | The sum of the 'Receipt Amount' less 'Total Fee' included in the payout for that settlement date. |
Comments
0 comments
Please sign in to leave a comment.