Import Mollie transactions into e-Boekhouden

For many webshops, freelancers, and associations, Mollie is the payment service provider for iDEAL, credit card, Bancontact, and PayPal. The payments run smoothly; the bottleneck is in the bookkeeping. Mollie pays out your balance in a single bundled amount to your business account, while e-Boekhouden wants to see every transaction separately to correctly post receivables, revenue, and transaction costs. In this guide you will learn how to import Mollie transactions cleanly into e-Boekhouden.

Why Mollie needs special attention

A Mollie payment goes through two steps before it appears on your bank statement:

1. The customer pays — the amount is added to your Mollie balance, less transaction costs.
2. Mollie pays out — Mollie periodically transfers the balance (daily, weekly, or on request) as a single amount to your business bank account.

On your bank statement you only see that payout: one line with, for example, Mollie payout 16062026 of € 2,945.80. If you only post that line, outstanding invoices in e-Boekhouden wrongly stay open and you lose insight into transaction costs and chargebacks. The solution is to import a statement that contains the underlying transactions — not just the payout.

Which export should you choose from Mollie?

The Mollie Dashboard offers several exports. Two are relevant for e-Boekhouden:

• Settlement export — a specification per payout of all payments, refunds, and chargebacks contained in that payout. Available as CSV.
• Transaction export — all payments in a period, regardless of the payout.

For e-Boekhouden, the settlement export works best: the sum of the transactions matches exactly the bank line you receive on your business account. The difference between total payments and the payout — namely the transaction costs — you post to a separate ledger account (for example Payment service costs).

Which format does e-Boekhouden process?

e-Boekhouden reads MT940 by default, as well as its own CSV format. For a clean import with individual transactions, MT940 is the most reliable choice: the file contains a separate line per transaction with date, amount, and description. e-Boekhouden does not always accept CAMT.053 directly; in that case convert your file with Convert CSV to MT940.

The approach at a high level

1. Create a separate bank account with a suspense account for Mollie in e-Boekhouden.
2. Download the settlement CSV per payout from the Mollie Dashboard.
3. Convert the CSV to MT940 with StatementBridge.
4. Import the file under the Mollie bank account.
5. Post the payout as an internal transfer between the Mollie suspense account and your bank account.
6. Post transaction costs to the correct ledger account.

Step 1 — Create a Mollie bank account in e-Boekhouden

1. In e-Boekhouden, go to Beheer > Instellingen > Bankrekeningen.
2. Add a new bank account.
3. Give it a recognizable description, for example Mollie suspense account.
4. Link the account to a ledger account in the cash and cash equivalents class, for example 1080 Mollie suspense account.
5. Enter a fictitious IBAN — a recognizable sequence that no real bank issues, such as NL00MOLL0000000000.
6. Save the bank account.

This account becomes the ‘waystation’ where Mollie transactions arrive before the payout is booked to your real bank.

Step 2 — Download the settlement CSV from Mollie

1. Log in to the Mollie Dashboard (my.mollie.com).
2. Go to Revenue → Payouts.
3. Click on the payout you want to process.
4. Open the Transactions tab and click Export at the top right.
5. Choose CSV as the format and save the file in a fixed location (for example \Mollie\Settlements\2026\).

Step 3 — Convert the CSV to MT940

e-Boekhouden processes MT940 by default, but no Mollie CSV. With StatementBridge you convert the file in a few seconds:

1. Open the conversion app.
2. Upload the Mollie settlement CSV.
3. Select Mollie as the source and choose MT940 as the target.
4. Enter the fictitious IBAN that you linked to the Mollie bank account in step 1.
5. Download the converted file.

You will find more background in Convert CSV to MT940.

Step 4 — Import into e-Boekhouden

1. In e-Boekhouden, go to Boekhouden > Invoeren > Importeren.
2. You arrive at the “Upload digital statement” screen.
3. Click Choose file and select the MT940 file (extensions .sta, .940, or .mt940).
4. Check that the IBAN in the file matches the IBAN of the Mollie bank account.
5. Click Next and confirm the import.

For the general import procedure, see Import bank statements into e-Boekhouden. The approach with payment service providers such as Mollie, Stripe, and PayPal is identical; see also Import AMEX, PayPal, Stripe into e-Boekhouden.

Step 5 — Post the payout and transaction costs correctly

Under the Mollie bank account there are now all the individual transactions. On your business bank account there is one line: the Mollie payout. Process it as follows:

• Payout line on the business bank → post it as an internal transfer between 1080 Mollie suspense account and your bank account.
• Transaction costs → post them to a ledger account Payment service costs or Bank charges.
• Refunds and chargebacks → reverse them against the original receivable or a separate ledger account Chargebacks.

At the end of each period, the balance on 1080 Mollie suspense account is zero, apart from any payout still outstanding. An unexplained balance points to a missing or duplicate imported settlement.

Common pitfalls

• Posting the bank line directly to receivables. First split payouts into individual transactions; only then do receivables stay correct.
• Two periods overlapping. Mollie can place a payment made just before midnight in a different settlement. Always follow the dates of the Mollie export, not those of your bank account.
• Leaving transaction costs in revenue. Post the costs to a separate ledger account; that keeps your revenue figure clean for VAT and reporting.
• Foreign currency. For multi-currency settlements, use a separate Mollie bank account with its own suspense account per currency.

File not accepted by e-Boekhouden?

Do you get an error such as Bank account not found or Unknown format? With StatementBridge you can still convert the Mollie export into an e-Boekhouden-friendly MT940 file with the correct IBAN.