Reports
Reports can be generated via your Merchant Dashboard, or received in a subscription.
Note: You can only retrieve data from approximately two years back.
Accountant export
The accountant export lists all successful incoming and outgoing transactions, including the:
- Amount
- Payment method
- Current transaction status
Supported formats
- CAMT053
- CODA
- CSV
- MT940
- XLS
- XLSX
Report contents
Headers | Description |
---|---|
Report created | The date the report was generated |
Merchant ID | Your MultiSafepay account number |
Date from | The start date of the reporting period |
Date till | The end date of the reporting period |
Currency | The currency of transactions |
Opening balance | The balance at the start date |
Total credit | The amount credited in the report period |
Total debit | The amount debited in the report period |
Closing balance | The balance at the end date |
Columns | Description |
Completed date/time | The date and time the transaction was completed |
Amount | The transaction amount |
Creditdebit | C means credit, D means debit |
Typetransaction | See N-codes for identifying payment methods |
Paymenttype | A MultiSafepay fee, or the payment method |
Description 2-4 | Descriptions of the order |
Tr status | The transaction status |
Ms description | The site name, or name of the terminal group |
Mt merchanttransactionid | Your unique identifier for the order |
Mt cust firstname | The customerās first name |
Mt cust lastname | The customerās last name |
Mt cust city | The customer's city |
Mt cust country | The customer's country |
Invoice ID | Your internal invoice ID |
PayPal transactions
MultiSafepay does not collect funds for PayPal, therefore these transactions don't appear in accountant exports.
You can view them in your dashboard under Transaction overview.
How to generate accountant exports
- Sign in to your live or test dashboard.
- Go to Reports > Accountant export.
- From the Date selection list, select the relevant timeframe (last 2 years only), and then click Apply.
- From the Currency list, select the relevant currency.
- From the Report type list, select the relevant export format.
- For the Group costs in 1 record toggle, set to:
- Yes: Show only the total of all MultiSafepay transaction fees for the selected timeframe.
- No: List each MultiSafepay fee below the matching transaction.
- Click Generate report.
You can import accountant exports into a range of third-party accounting platforms.
Financial report
This report provides an overview (in Excel or CSV format) of:
- Paid/unpaid transactions within a specific timeframe and transaction fees
- Refunds, chargebacks, reversals
- Payouts
- Currency conversions
Report contents
Columns | Description |
---|---|
ID | MultiSafepay's transaction reference number |
Merchant ref | Your transaction reference number |
Created | The date the transaction was initiated |
Completed | The date the funds were settled in your account balance |
Site | The site where the customer placed the order |
First name | The customer's first name |
Last name | The customer's last name |
Description | A description of the order |
Currency | The currency of the transaction |
Amount | The amount of the transaction |
Payment type | A MultiSafepay fee, or the payment method |
Payment status | The transaction status |
How to generate financial reports
- Sign in to your MultiSafepay dashboard .
- Go to Reports > Financial report.
- To specify the period you want the report to cover, click the date selector under Period.
- From the Cost grouping list, select:
- No grouping: Show only the total of all MultiSafepay transaction fees for the selected timeframe.
- Single entry for all costs: List each MultiSafepay fee below the matching transaction.
- Click Generate report.
Conversion reports
This report provides insight (in Excel format) into your conversion rate. You can filter by:
- Customer country and device
- Day
- Payment method
- Site
How to generate conversion reports
- Sign in to your MultiSafepay dashboard .
- Go to Reports > Advanced reporting.
- Under Date, select the date range you want the report to cover.
- Under Currency, select the relevant currency.
- Under Site and Site 2, specify one or two sites (if relevant).
- To download, click XLS or XLSX.
- Click Execute report.
Financial summary
This report provides an overview (in Excel or PDF format) of revenue and fees for:
- Payment methods
- Refunds, chargebacks, reversals
- Transactions
Report contents
Headers | Description |
---|---|
Report created | The date the report was generated |
Merchant ID | Your MultiSafepay account number and merchant name |
Currency | The currency of transactions |
Date from | The start date of the period the report covers |
Date till | The end date of the report period |
Group refunds | Whether you have grouped refunds together |
Columns | Description |
Description | Payment method/refunds/chargebacks/reversals/transaction fees, broken down by revenue and cost |
Column 1 | The transaction fee |
Number | The number of transactions |
Debit | The total amount debited |
Credit | The total amount credited |
Net income | The total revenue minus costs |
Exclusions
The report does not include:
- Payouts (see Payout report)
- Monthly transaction fees
- VAT (see VAT invoices)
How to generate financial summaries
- Sign in to your MultiSafepay dashboard .
- Go to Reports > Financial summary.
- Under Options, in the Date field, enter the start and end dates of the period you want the report to cover.
- From the Currency list, select the relevant currency.
- Click Generate report.
Payout report
This report provides an overview (in Excel format) of the specific transactions and fees per payout. It is helpful for matching payouts to specific orders or invoices for accounting purposes. See also Payouts.
Report contents
Headers | Description |
---|---|
Report created | The date the report was generated |
Merchant ID | Your MultiSafepay account number and merchant name |
Payout ID | The reference number for this payout |
Logic | What time the payout was made |
Date from | The start date of the reporting period |
Date till | The end date of the reporting period |
Payout currency | The currency the payout was paid in |
Columns | Description |
Created date | The date the transaction was initiated |
Completed date/time | The date and time the transaction was completed |
Mt status | The transaction status |
Mt order status | The order status |
PSP ID | MultiSafepay's transaction reference number |
Amount | The transaction amount in whole currency |
Amount cents | The transaction amount in cents |
Creditdebit | C means credit, D means debit |
N code | See N-codes for identifying payment methods |
Payment type | A MultiSafepay fee, or the payment method |
Mt description | A description of the transaction |
Sub description | A description of a component of the transaction, e.g. an issuer fee or currency conversion cost |
Sub status | The transaction status |
Sub ID | MultiSafepay's transaction reference number |
Ms description | The site name |
Order ID | Your unique identifier for the order |
Var1/Var2/Var3 | Additional information |
How to generate payout reports
- Sign in to your MultiSafepay dashboard .
- Go to Reports > Daily balance.
- Under Payout ID for the relevant date, click the green Export icon.
Ā š” Tip! You must have completed at least one payout to generate a payout report.
Sales report
This report provides an overview (in Excel format) of the total revenue and/or number of transactions per:
- Customer country and device
- Day
- Payment method
- Site
How to generate sales reports
- Sign in to your MultiSafepay dashboard .
- Go to Reports > Advanced reporting > Site.
- Under Date, select the date range you want the report to cover.
- If relevant, specify one or two sites under Site and Site 2.
- To download, click XLS or XLSX.
Second Chance report
This report provides an overview (in Excel format) of all transactions:
- By payment method or country
- Declined, retried and completed, retried and completed with a different payment method
- Completed with Second Chance
To request a Second Chance report, email [email protected]
Report contents
Column | Description |
---|---|
Report created | The date the report was generated |
Merchant ID | Your MultiSafepay account number |
Date from | The start date of the reporting period |
Date till | The end date of the reporting period |
By payment method or country | |
Paymentmethod | The payment method |
Country | The country where the transaction took place |
Completed | The number of completed transactions |
Declined | The number of declined transactions |
Retry completed | The number of transactions that were completed after retrying |
Retry completed diff paymentmethod | The number of transactions completed after retrying with a different payment method |
Perc completed | The percentage of all transactions that were successfully completed |
Other sections | |
Created | The time the transaction was created |
Maintransaction | MultiSafepay's transaction reference number |
Paymenttype | The payment method |
Country | The country where the transaction took place |
The customer's email address | |
Merchant ID | Your unique identifier for the order |
Declined: | |
Reason | Any reason why the transaction was declined |
Retried and completed: | |
Result | Any additional information about the transaction |
Different payment method: | |
Original | The original payment method |
Retry | The payment method used to retry |
Result | Any additional information about the transaction |
Completed with Second Chance: | |
Amount | The amount paid |
Totals | The total number of transactions, and total amount paid |
Transaction summary
This report provides an overview (in Excel or PDF format) of all transactions within a specific timeframe, including:
- Fees
- Amount and currency
- Sites
How to generate transaction summaries
- Sign in to your MultiSafepay dashboard .
- Go to Reports > Transaction summary.
- Under Report settings > in the From and To fields, enter the start and end dates of the period you want the report to cover.
- Under Extra, specify any other relevant parameters:
- Currency field: Select the relevant currency.
- Status field: Select the order status or transaction status, if relevant
- Payment method field: Select the relevant payment method.
- Site field: Select the relevant site.
- Grouping method field: Specify if you want to total fees together per Site, Payment method, or Country, or not at all.
- To group all transactions and only show the daily total, select the Show per day checkbox.
- Click Generate report.
Set up automated reports
You can automate generation of accountant exports and payout reports.
How to request automated exports
To request automated accountant exports, email the following information to [email protected]:
- Your account ID (top-right corner of your MultiSafepay dashboard)
- Method: SFTP Pull or Push request
- Frequency: Daily, weekly, or monthly
- Preferred time after 05:29 (based on Central European (Summer) Time (CET/CEST))
- Accountant export:
- File format: CAMT053, CODA, CSV, MT940, XLS, or XLSX
- MultiSafepay transaction fees: Total or listed separately
To view the autogenerated reports in your MultiSafepay dashboard , click the Messages icon in the top-right corner.
SFTP requests and requirements
-
SFTP:
- Pull request: We give you access to a MultiSafepay SFTP server.
- Push request: You give us access to your SFTP server.
-
We support SFTP with username/password and username/SSH keys.
-
For SFTP connections, we only support ports 22 and 2222.
-
Make sure our IP address is on your allow list. For a list of MultiSafepay IP addresses, email [email protected]
-
To deliver the report using SFTP Push requests, you must support the following protocols on your SFTP server:
sh-ed25519
,
rsa-sha2-512
,
rsa-sha2-256
,
ecdsa-sha2-nistp521
,
ecdsa-sha2-nistp384
,
ecdsa-sha2-nistp256
,
ssh-rsa
Filter by payment method
To identify transactions in reports by payment method, use the following N-codes.
N-Code | Transaction type |
---|---|
N001 | MASTERCARD |
N002 | VISA |
N003 | MAESTRO |
N004 | WALLET |
N006 | DANKORT |
N016 | ALIPAY |
N017 | DOTPAY |
N018 | POSTEPAY |
N021 | IDEAL |
N031 | GIROPAY |
N081 | BANKTRANS |
N085 | AMEX |
N086 | KLARNA |
N088 | PAYAFTER |
N089 | SANTANDER |
N090 | in3 |
N092 | DIRECTBANK |
N093 | CURRENCY CONVERSION |
N094 | MISTERCASH |
N095 | CHARGEBACK |
N096 | WITHDRAWAL |
N097 | Refund |
N098 | COUPON |
N101 | DIRDEB |
N102 | iDEAL QR |
N102 | BELFIUS |
N103 | EPS |
N104 | EINVOICE |
N105 | Riverty |
N107 | FERBUY |
N108 | TRUSTLY |
N109 | KBC |
N913 | FEE |
Troubleshooting
Data range not applied
In some cases, the custom range selected for your report is not applied immediately. This can usually be solved by either accessing from a different browser, or deleting your cookies / cache data.
Payout report not generated
Note: The payout report is only available for automated withdrawals.
Support
Email [email protected]
Updated about 1 month ago