Reports


Automated Accountant Export

The Automated Accountant Export via SFTP is currently in Beta and is available for testing via MultiSafepay Test Control.

Accountant Export

An Accountant Export containing all successful incoming and outgoing transactions, as well as corresponding costs (where applicable), can be generated to serve your bookkeeping needs.

Sending an Automated Accountant Export

As a MultiSafepay client, you can benefit from three ways of accessing/receiving the automated accountant export:

  1. Via email
  2. Via SFTP - Pull request (With this method you will receive access to an SFTP server from MultiSafepay)
  3. Via SFTP - Push request (With this method MultiSafepay would like to receive access to an SFTP server from you).

We support SFTP by username/password and username/SSH keys.

We only support port 22 & 2222 for SFTP connections

Frequency

MultiSafepay can send the Automated Accountant Export daily, weekly or monthly. You have the option of choosing the frequency and time. Our reference time is Central Eastern Summer Time (CEST).

Accountant Export format

The following formats are available for automatically generating an export:

  1. CAMT053
  2. CODA
  3. CSV
  4. MT940
  5. XLS
  6. XLSX

For information regarding the different exports, check out our exports page.

How to request an Automated Accountant Export

Automated Accountant Export activation checklist:

  • Choice of email, SFTP push or SFTP pull
  • Frequency - daily, weekly or monthly
  • Desired file format: CAMT053, CODA, CSV, MT940, XLS or XLSX
  • Desired time (Please note our reference time is CEST).
  • Costs breakdown per transaction OR total costs

Send the requested to our Integration Team via [email protected]

Don’t forget to add your MultiSafepay Control number.

Whitelisting

If your method of choice is via SFTP, please make sure our IP is whitelisted. For more information, please refer to our IP ranges documentation.

How to generate a report

You can generate a MT940 report within your MultiSafepay Control, by following these steps:

  1. Login into your MultiSafepay Control
  2. Go to Reports and select Accountant export
  3. Fill in the date selection
  4. Choose the report format
  5. Generate report.

In the report, all (processed) incoming and outgoing completed transactions are displayed in the specified period in which you generate the report, providing you insights on an individual level, as well as of all the associated costs.

N-Codes and description

In the accountant export you can use filters to select a specific payment method or period. This allows you to quickly get the data you need. To filter your transactions you can use the N-codes filter in the accountant export.

Below you can find an overview of the N-Codes and their meaning.

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
N087 CARTASI
N088 PAYAFTER
N089 SANTANDER
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 AFTERPAY
N106 INGHOME
N107 FERBUY
N108 TRUSTLY
N109 KBC
N913 FEE

Other languages

Liever uitleg in het Nederlands? Neem contact op met uw accountmanager.

Vuoi ricevere informazioni in italiano? Contatta il tuo account manager.

Prefieres tener la explicación en Español? Contacta con tu gerente de cuentas.

Vous préférez une explication en français? Contactez votre gestionnaire de compte.