Import Adyen transactions into Moneybird

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 Moneybird needs every underlying transaction separately for a clean accounts receivable administration. In this guide you will read how to import Adyen transactions neatly into Moneybird.

Why Adyen needs special attention in Moneybird

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 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 Moneybird remain wrongly open, you lose insight into fees and chargebacks, and your VAT return does not reconcile cleanly with your revenue. 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 MT940 or CAMT.053 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 Moneybird the settlement detail report works best: the sum of the transactions minus the fees matches the batch payout on your bank account. You process the difference on a separate general ledger account Payment service costs.

Note: Moneybird is a strict importer

Moneybird only accepts officially formatted MT940 and CAMT.053 files and rejects an Adyen CSV or a deviating file. Because CAMT.053 is a richer and more strictly validated format, we recommend CAMT.053 for Moneybird: the booking lines, counter-accounts and references come through most completely. Use a fictitious IBAN for the Adyen clearing/intermediate account.

Approach in outline

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

Step 1 — Create an Adyen account in Moneybird

1. In Moneybird, go to Administration → Financial accounts.
2. Click Add new account and choose Manual account.
3. Give the account a recognisable name, for example Adyen clearing account.
4. Choose Bank account as the type.
5. Enter a fictitious IBAN. Use a recognisable sequence that no real bank issues, such as NL00ADYE0000000000.
6. Select the correct currency (in most cases EUR).
7. Save the account.

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

Moneybird processes CAMT.053 and MT940 by default, but not an Adyen CSV with the original column structure. 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 as the target (recommended for Moneybird).
4. Enter the fictitious IBAN that you linked to the Adyen account in step 1.
5. Download the converted file.

Read more about the procedure in Convert CSV to CAMT.053 and Convert CSV to MT940. Unsure about the format? MT940 vs CAMT.053: what is the difference? helps you choose.

Step 4 — Import into Moneybird

1. In Moneybird, go to Administration → Financial accounts.
2. Open the Adyen clearing account you created in step 1.
3. Click Import bank statement and upload the CAMT.053 or MT940 file.
4. Check that the IBAN in the file matches the IBAN of the account.
5. Confirm the import and open the statement to process it.

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

Step 5 — Book the batch payout, fees and chargebacks

Your Adyen account now contains all the individual transactions. On your business bank account 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 (manual entry) between Adyen clearing account and your bank account.
• Fees (transaction costs) → book to a general ledger account Payment service costs (or another expense account you use in Moneybird).
• Refunds → book against the original invoice.
• 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 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 outstanding invoices in Moneybird clear automatically.
• Overlooking reserves. Adyen can temporarily withhold part of the revenue as a reserve. That line belongs on the clearing account, not on revenue.
• 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 account with a clearing/intermediate account and fictitious IBAN per account.

File not accepted by Moneybird?

Do you get an error message such as File format not recognised or IBAN unknown? Because Moneybird is a strict importer, convert the Adyen report with StatementBridge to a Moneybird-friendly CAMT.053 or MT940 file with the correct IBAN.