How do I perform reconciliation on my TRU Acquiring account?

ā€‹  Last updated: 

 

If you are using both our TRU Connect gateway and TRU Acquiring services, you can follow the steps below to reconcile payments between MyST and RAM Tool.


  1. To begin the reconciliation process, first sign in to MyST.

      MyST houses information on all the transactions processed through the TRU Connect payment gateway, including declines, pre-authorisations and suspended payments.


  2. From the left side-bar, click "Transactions" then "Transaction search".


  3. Select the site reference(s) and date range for your search. By using the "Output" drop-down, you can also choose between displaying the search results on screen and exporting a spreadsheet of this data. Click "Search" when you are ready.


  4. The output of this search can be used to determine whether the transactions have been batched to be settled with the acquirer. The easiest way to do this is to look at the "Status" column:

    • Transactions with the "Decline" or "Error" status will not be sent for funding. You can determine the cause of a decline by clicking the transaction reference and then clicking "More details".
    • "Suspended" transactions will hold the funds against a customer's account for up to 7 days for a standard authorisation (this increases to 30 days for pre-authorisations) or until the payment has been actioned.
    • "Pending" transactions are awaiting settlement. If the settlement hasn't been deferred, the status will change to "Settled" the following day.
    • "Settled" transactions have been batched and sent to the acquirer. These transactions will be viewable in the RAM Tool.

      All reports generated by MyST display the total gross value irrespective of whether your MID is net settlement.


  5. Using the RAM Tool you can identify the breakdown of your accrued fees. For this, you need to look at the "Daily Funding" and "Merchant Payment Advice" reports. Let's begin with the "Daily Funding" report.

      The "Daily Funding" report centres around the Payment Account Retail (PAR). The PAR account captures all incoming transactions and then debits refunds, rolling reserves, chargebacks and fees to produce the net value for the account. This net value is then sent to you via your account settlement method (e.g. daily, weekly, monthly).


  6. Sign in to RAM Tool and from the navigation at the top of the screen, click "Reports" > "Funding" > "Daily Funding".


  7. From the drop-downs along the top of the screen, ensure you have selected the "Payment Acct Retail" for your respective currency. Adjust the date range using the "Date From" fields. The range you select here will depend on your account settlement method. For example, for a weekly settlement, you could select a date range of Tuesday to the following Monday. Click "Search" when you are ready.

    ram-reconciliation1.png

  8. The total amount of accepted transactions for the time period specified in the search terms can be seen in the top line of the results table displayed, under the "CR" (credit) column. For net accounts, the fees are visible under the "DR" (debit) column. The fees correspond to the agreed fees per the merchant agreement.


  9. At the bottom of the report, you'll see the "Actual Payment", which is the amount that will be sent to your business bank account. You can validate and check on the status of payments due to be sent to your bank account by clicking "Actual Payment" in the table, which will take you directly to the "Merchant Payment Advice" report with the relevant date range pre-selected.

      To navigate to the "Merchant Payment Advice" report from elsewhere on RAM Tool, use the navigation at the top of the screen: Click "Reports" > "Funding" > "Merchant Payment Advice".

    ram-reconciliation2.png


  10.   The "Merchant Payment Advice" report has a date range limit of one month.

    On the "Merchant Payment Advice" page, each row provides information on funds to be settled and details for where the funds will be sent. Of particular interest, you will need to check:

    • The "Net Amount" is the amount to be settled.

    • The "Funding Date" is the date that the payment is to be released by Trust Payments for settlement. This is not the date on which the funds will reach your bank account; we aim to have the funds arrive in your bank one business day after the funding date.

    • The "Payment Status" is updated once every 24 hours. There are three possible values:

      • "Held" - The payment has been batched and the status will remain as "Held" until the funding date has been reached.

      • "Released" - The payments have been released for settlement with your bank.

      • "Deleted" - This is assigned when funds are due to be released but are then later held (e.g. because the account has incurred a negative balance). The funds are not lost; they are distributed back to the respective payment retail accounts.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request