Accountant export


The accountant export lists all successful incoming and outgoing transactions, including the:

Supported formats

  • CAMT053
  • CODA
  • CSV
  • MT940
  • XLS
  • XLSX

Exclusions

 
MultiSafepay does not collect funds for PayPal. Therefore, PayPal transactions don’t automatically appear in the accountant export.

To include them, in your dashboard or backend, set the transaction status to Completed.

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 website name
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

To filter transactions in the accountant export (e.g. by payment method), see N-codes for identifying payment methods.

Generating accountant exports

To generate an accountant export, follow these steps:

  1. Sign in to your live or test dashboard.
  2. Go to Reports > Accountant export.
  3. From the Date selection dropdown, select the relevant timeframe (last 2 years only), and then click Apply.
  4. From the Currency dropdown, select the relevant currency.
  5. From the Report type dropdown, select the relevant export format.
  6. Group costs in 1 record toggle:
    • 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.

Automating accountant 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
  • File format: CAMT053, CODA, CSV, MT940, XLS, or XLSX
  • Desired time: Based on Central European (Summer) Time (CET/CEST)
  • MultiSafepay transaction fees: Total or listed separately
View 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 protocol on your SFTP server:

    sh-ed25519, rsa-sha2-512, rsa-sha2-256, ecdsa-sha2-nistp521, ecdsa-sha2-nistp384, ecdsa-sha2-nistp256, ssh-rsa

To view the autogenerated reports in your MultiSafepay dashboard, click the Messages icon in the top-right corner.

For support, email [email protected]

See also

Feedback

Propose a change on GitHubexternal-link-icon or
send an email to [email protected]

Other languages

For an explanation in another language, contact your account manager.