The "Merchant Payment Advice" report shows the history of payments that have been funded to your business bank account and any upcoming payments that are due to be funded. It includes helpful information to determine the status of the payment, including the funding date and unique bank reference number.
Required user roles
Admin, Developer, TransactionUser, ViewFeesAndStatements, ViewTransactionsOnly
How to access
-
Select “Reporting” from the side-bar to open the Reporting page.
-
In the top left, select "MID" and then select a MID from the drop-down box.
-
From "Stored Searches", select "Merchant Payment Advice".
-
Fill out the rest of the form as necessary. Click here to learn more.
-
Click "Search".
To perform a more targeted search, you can apply additional filters by clicking the "Advanced" button, and then clicking "Filters" on the left. From here you can enable any of the following filters and click "Apply" to confirm your changes:
| Filter name | Description |
| Account Type Id | Filter batches by the TRU Acquiring account type (e.g. "Payment Account", "Acquiring Fee Account (Gross)"). |
| Account Currency | Filter batches by the currency of the TRU Acquiring account. |
| Settlement Period | Filter batches by settlement period (e.g. "Daily (Net)", "Weekly (Gross)"). |
| Payment Status | Filter for "Held", "Released" and "Deleted" batches. |
Searchable records are available up until the previous calendar day. Attempting to search the current day will yield no results.
A maximum of 1,000 records can be included in a report. You can generate larger reports by using the options provided to perform an "Export" rather than an "On screen" search. This will export a file for download.
Each row in the table represents a batch that comprises funds that will be transferred to your bank account. For each batch shown in the table, the following information is displayed:
| Column name | Description |
| Currency | The settlement currency. |
| Merchant No | The Merchant Id (MID). |
| Merchant Name | The merchant's name. |
| Account Name | The name on the account associated with the Merchant Id (MID). |
| Bank No | The bank sort code. |
| BIC/Swift Code | The bank Swift code. |
| Account | The bank account number. |
| IBAN | The International Bank Account Number. |
| Net Amount | The net amount to be transferred. If you click the net amount value for a given batch, a pop-up is displayed breaking down how the net amount was calculated. The information displayed here is the same information shown when viewing Payment Summary reports. Click here to learn more. |
| Local Amount GBP | The net amount in GBP. |
| Work of Date | The date that the settlement was batched. |
| Value date | The date that the settlement was batched. |
| Funding Date |
The date that funds are released by the acquirer. While we aim to have funds arrive in your business bank account within 1 day after the funding date, funding can sometimes be delayed by your bank (e.g. due to a bank holiday). |
| Payment Status | The different payment statuses are as follows:
|
| Settlement Period |
The settlement period represents when billing is to be processed for the given batch. This can be:
|
| Account Type | The type of account from which the payment is being funded (e.g. "Payment Account", "Acquiring Fee Account (Gross)"). |
| Bank Reference | The unique 16-character reference assigned on payment generation. |
