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.
The filters you can select in this view are dependent on the selected MID (e.g. if the MID only has a settlement currency of EUR, you will only be able to select "EUR" from the "Settlement Currency" drop-down).When selecting multiple MIDs, these need to be comma-separated:
e.g. "000104912345678,000104908642024"
- From "Stored Searches", select "Merchant Payment Advice".
- Now use the other drop-downs to filter the report:
- "Account types" - Select the account type:
- Payment Account - The main account where settlement funds are displayed.
- Acquiring Fee Account (Gross) - For accounts using the gross settlement model, this will only display fees.
- DCC Commission Account - For accounts with DCC enabled, this will display DCC commissions paid to you.
- Rolling Reserve Account - This account displays rolling reserve payments to be paid to you. Learn more about rolling reserve.
- Fixed Reserve Account - This account displays fixed reserve payments to be paid to you. Learn more about fixed reserve.
- "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.
- "Account types" - Select the account type:
- 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 final amount to be transferred after all fees and adjustments. Select the Net Amount hyperlink for a given batch to open the Fee Summary View in a new tab, showing a detailed breakdown of how this amount was calculated. 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. |
