Import Adyen transactions into Visma eAccounting

Adyen processes payments for many Dutch webshops, platforms and retailers. The payments almost always go through fine; the bottleneck is in the bookkeeping. Adyen pays out your balance to your bank account in bundled form, while Visma eAccounting wants to see every transaction separately in order to book debtors, revenue, fees and chargebacks correctly. In this guide you will read how to import Adyen transactions cleanly into Visma eAccounting.

Why Adyen needs special attention

An Adyen payment goes through several steps before it appears on your bank statement:

1. Customer pays — the amount is added to a settlement batch on your Adyen account.
2. Adyen settles — fees, refunds, chargebacks and reserves are netted within the batch.
3. Adyen pays out — the net balance of the batch is booked as a single amount to your business bank account.

On your bank statement you only see that payout: a single line with, for example, Adyen settlement batch 142 of € 12,480.33. If you only book that line, outstanding invoices in Visma eAccounting remain wrongly open and you lose insight into fees and chargebacks. The solution is to import a statement with the underlying transactions — not just the batch payout.

Which Adyen report should you choose?

Adyen does not provide a ready-made bank file for your bookkeeping. In the Adyen Customer Area, under Reports, you will find the source files you need:

• Settlement detail report — per settlement batch, a breakdown of all payments, fees, refunds and chargebacks. Available as CSV. This is the report you use for your bookkeeping.
• Payment accounting report — all payments in a period, regardless of the payout. Suitable for analysis, less so for reconciliation.

For Visma eAccounting the settlement detail report works best: the sum of the transactions minus the fees matches the batch payout on your bank account. You book the difference to a separate general ledger account, for example Payment service costs.

Which format does Visma eAccounting process?

Visma eAccounting supports CAMT.053 (the preferred format) and MT940. For a clean import with individual transactions, both are suitable: the file contains, per transaction, its own line with date, amount and description. CAMT.053 is preferred because of its richer transaction data. Do you choose MT940? Then note that the file must have the .txt extension. Unsure? Read MT940 vs CAMT.053: what is the difference?

Approach in outline

1. Create a separate bank account with a clearing/intermediate account for Adyen in Visma eAccounting.
2. Download the settlement detail report per batch from the Adyen Customer Area.
3. Convert the CSV to CAMT.053 or MT940 with StatementBridge.
4. Import the file under the Adyen bank account.
5. Book the batch payout as an internal transfer between the Adyen clearing/intermediate account and your bank account.
6. Book fees, refunds and chargebacks to the correct general ledger accounts.

Step 1 — Create an Adyen bank account in Visma eAccounting

1. In Visma eAccounting, go to Settings > Bank accounts and add a new account.
2. Give it a recognisable description, for example Adyen clearing account.
3. Link the account to a general ledger account in the liquid assets class, for example 1085 Adyen clearing account.
4. Enter a fictitious IBAN — a recognisable sequence that no real bank issues, such as NL00ADYE0000000000.
5. Save the bank account. Do not activate a bank link (Autopay) for this account; otherwise you cannot import files manually.

This account becomes the ‘intermediate station’ where Adyen transactions arrive before the batch payout is booked to your real bank. Do you process multiple merchant accounts? Then use a separate bank account with a fictitious IBAN per account.

Step 2 — Download the settlement detail report from Adyen

1. Log in to the Adyen Customer Area.
2. Go to Reports and select the correct merchant account.
3. Open the Settlement detail report for the batch you want to process.
4. Download the report as CSV and save it in a fixed location (for example \Adyen\Settlements\2026\).
5. Note the batch number; you will use it later to reconcile the bank line.

The report specifies, per line, the settled payments, refunds, chargebacks and the fees (Markup, Scheme Fees, Interchange). You reconcile the lines against your invoices via the Psp Reference or Merchant Reference from the report.

Step 3 — Convert the CSV to CAMT.053 or MT940

Visma eAccounting reads CAMT.053 and MT940 by default, but not an Adyen CSV. With StatementBridge you convert the file in a few seconds:

1. Open the conversion app.
2. Upload the Adyen settlement detail report (CSV).
3. Select Adyen as the source and choose CAMT.053 (preferred) or MT940 as the target.
4. Enter the fictitious IBAN that you linked to the Adyen bank account in step 1.
5. Download the converted file. If you choose MT940, give the file the .txt extension.

Read more about the procedure in Convert CSV to CAMT.053 and Convert CSV to MT940.

Step 4 — Import into Visma eAccounting

1. Log in to Visma eAccounting and go to Cash and bank transactions.
2. Click the arrow next to New bank transaction and select Read in bank file.
3. Click Select bank file or drag the CAMT.053 or MT940 file into the window.
4. Check that Visma recognises the Adyen bank account based on the fictitious IBAN.
5. Review the transactions and click Import.

For the general import procedure, see Importing bank statements into Visma eAccounting. The procedure with payment service providers is identical; see also AMEX, PayPal, Stripe import into Visma.

Step 5 — Book the batch payout, fees and chargebacks

Under the Adyen bank account there are now all the individual transactions. In your business bank ledger there is a single line: the batch payout from Adyen. Process this as follows:

• Batch payout on the business bank → book it as an internal transfer between 1085 Adyen clearing account and your bank account.
• Fees (transaction costs) → book to a general ledger account Payment service costs or Bank charges.
• Refunds → book against the original debtor.
• Chargebacks → book to a separate general ledger account Chargebacks so they remain visible in your reporting.

At the end of each period, the balance on 1085 Adyen clearing account is zero, apart from any batch that is still outstanding. An unexplained balance points to a missing or duplicated settlement detail report.

Common pitfalls

• Booking the bank line directly to debtors. First split the batch into individual transactions; only then do debtors stay correct.
• MT940 without the .txt extension. Visma only reads in MT940 if the file has the .txt extension; rename the file if necessary.
• Leaving fees in revenue. Book fees to a separate general ledger account; that keeps your revenue figure clean for VAT and reporting.
• Mixing multiple merchant accounts. Use a separate bank account with a clearing/intermediate account and fictitious IBAN per account.

File not accepted by Visma?

Do you get an error message such as File not recognised or Bank account not found? Check that MT940 files have the .txt extension. With StatementBridge you can still convert the Adyen report to a Visma-friendly CAMT.053 or MT940 file with the correct IBAN.