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 specify a MID to search.
- From "Stored Searches", select "Merchant Payment Advice".
- Now use the other drop-downs to filter the report:
- "Account Type" - Select the acquiring account type (e.g. "Payment Account").
- "Settlement Currency" - Select the currency of the acquiring account.
- "Payment Status" - Choose between "Held", "Released" and "Deleted" batches.
- "Date (UTC)" - Select the date range of the report.
- After you've selected your filters, select "Search".
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 select 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. Learn more about the Fee Summary report. |
| 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. |
