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
HeadersDescription
Report createdThe date the report was generated
Merchant IDYour MultiSafepay account number
Date fromThe start date of the reporting period
Date tillThe end date of the reporting period
CurrencyThe currency of transactions
Opening balanceThe balance at the start date
Total creditThe amount credited in the report period
Total debitThe amount debited in the report period
Closing balanceThe balance at the end date
ColumnsDescription
Completed date/timeThe date and time the transaction was completed
AmountThe transaction amount
CreditdebitC means credit, D means debit
TypetransactionSee N-codes for identifying payment methods
PaymenttypeA MultiSafepay fee, or the payment method
Description 2-4Descriptions of the order
Tr statusThe transaction status
Ms descriptionThe site name
Mt merchanttransactionidYour unique identifier for the order
Mt cust firstnameThe customer’s first name
Mt cust lastnameThe customer’s last name
Mt cust cityThe customer's city
Mt cust countryThe customer's country
Invoice IDYour 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
  1. Sign in to your live or test dashboard.
  2. Go to Reports > Accountant export.
  3. From the Date selection list, select the relevant timeframe (last 2 years only), and then click Apply.
  4. From the Currency list, select the relevant currency.
  5. From the Report type list, select the relevant export format.
  6. 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.
  7. 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
ColumnsDescription
IDMultiSafepay's transaction reference number
Merchant refYour transaction reference number
CreatedThe date the transaction was initiated
CompletedThe date the funds were settled in your account balance
SiteThe site where the customer placed the order
First nameThe customer's first name
Last nameThe customer's last name
DescriptionA description of the order
CurrencyThe currency of the transaction
AmountThe amount of the transaction
Payment typeA MultiSafepay fee, or the payment method
Payment statusThe transaction status
How to generate financial reports
  1. Sign in to your MultiSafepay dashboard .
  2. Go to Reports > Financial report.
  3. To specify the period you want the report to cover, click the date selector under Period.
  4. 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.
  5. 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
  1. Sign in to your MultiSafepay dashboard .
  2. Go to Reports > Advanced reporting > Credit cards conversion.
    • 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).
  3. To download, click XLS or XLSX.
  4. 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
HeadersDescription
Report createdThe date the report was generated
Merchant IDYour MultiSafepay account number and merchant name
CurrencyThe currency of transactions
Date fromThe start date of the period the report covers
Date tillThe end date of the report period
Group refundsWhether you have grouped refunds together
ColumnsDescription
DescriptionPayment method/refunds/chargebacks/reversals/transaction fees, broken down by revenue and cost
Column 1The transaction fee
NumberThe number of transactions
DebitThe total amount debited
CreditThe total amount credited
Net incomeThe total revenue minus costs

Exclusions

The report does not include:

How to generate financial summaries
  1. Sign in to your MultiSafepay dashboard .
  2. Go to Reports > Financial summary.
  3. Under Options, in the Date field, enter the start and end dates of the period you want the report to cover.
  4. From the Currency list, select the relevant currency.
  5. 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
HeadersDescription
Report createdThe date the report was generated
Merchant IDYour MultiSafepay account number and merchant name
Payout IDThe reference number for this payout
LogicWhat time the payout was made
Date fromThe start date of the reporting period
Date tillThe end date of the reporting period
Payout currencyThe currency the payout was paid in
ColumnsDescription
Created dateThe date the transaction was initiated
Completed date/timeThe date and time the transaction was completed
Mt statusThe transaction status
Mt order statusThe order status
PSP IDMultiSafepay's transaction reference number
AmountThe transaction amount in whole currency
Amount centsThe transaction amount in cents
CreditdebitC means credit, D means debit
N codeSee N-codes for identifying payment methods
Payment typeA MultiSafepay fee, or the payment method
Mt descriptionA description of the transaction
Sub descriptionA description of a component of the transaction, e.g. an issuer fee or currency conversion cost
Sub statusThe transaction status
Sub IDMultiSafepay's transaction reference number
Ms descriptionThe site name
Order IDYour unique identifier for the order
Var1/Var2/Var3Additional information
How to generate payout reports
  1. Sign in to your MultiSafepay dashboard .
  2. Go to Reports > Daily balance.
  3. Under Payout ID for the relevant date, click the green Export icon.

Note: 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
  1. Sign in to your MultiSafepay dashboard .
  2. Go to Reports > Advanced reporting > Site.
  3. Under Date, select the date range you want the report to cover.
  4. If relevant, specify one or two sites under Site and Site 2.
  5. 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
ColumnDescription
Report createdThe date the report was generated
Merchant IDYour MultiSafepay account number
Date fromThe start date of the reporting period
Date tillThe end date of the reporting period
By payment method or country
PaymentmethodThe payment method
CountryThe country where the transaction took place
CompletedThe number of completed transactions
DeclinedThe number of declined transactions
Retry completedThe number of transactions that were completed after retrying
Retry completed diff paymentmethodThe number of transactions completed after retrying with a different payment method
Perc completedThe percentage of all transactions that were successfully completed
Other sections
CreatedThe time the transaction was created
MaintransactionMultiSafepay's transaction reference number
PaymenttypeThe payment method
CountryThe country where the transaction took place
EmailThe customer's email address
Merchant IDYour unique identifier for the order
Declined:
ReasonAny reason why the transaction was declined
Retried and completed:
ResultAny additional information about the transaction
Different payment method:
OriginalThe original payment method
RetryThe payment method used to retry
ResultAny additional information about the transaction
Completed with Second Chance:
AmountThe amount paid
TotalsThe 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
  1. Sign in to your MultiSafepay dashboard .
  2. Go to Reports > Transaction summary.
  3. Under Report settings > in the From and To fields, enter the start and end dates of the period you want the report to cover.
  4. 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.
  5. 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.

How to filter using N-Codes
N-CodeTransaction type
N001MASTERCARD
N002VISA
N003MAESTRO
N004WALLET
N006DANKORT
N016ALIPAY
N017DOTPAY
N018POSTEPAY
N021IDEAL
N031GIROPAY
N081BANKTRANS
N085AMEX
N086KLARNA
N088PAYAFTER
N089SANTANDER
N090in3
N092DIRECTBANK
N093CURRENCY CONVERSION
N094MISTERCASH
N095CHARGEBACK
N096WITHDRAWAL
N097Refund
N098COUPON
N101DIRDEB
N102iDEAL QR
N102BELFIUS
N103EPS
N104EINVOICE
N105AFTERPAY
N107FERBUY
N108TRUSTLY
N109KBC
N913FEE


💬

Support

Email [email protected]

Top of page


Did this page help you?