Import Mollie transactions into Yuki

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 Yuki wants to see every transaction separately to correctly post receivables, revenue, and transaction costs. In this guide you will learn how to deliver Mollie transactions cleanly into Yuki.

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 Yuki wrongly stay open and you lose insight into transaction costs and chargebacks. The solution is to deliver 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 Yuki:

• 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 Yuki, 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 Yuki process?

Yuki processes MT940 and CAMT.053 by default. For a clean import with individual transactions, both formats are suitable: the file contains a separate line per transaction with date, amount, and description. Unsure about the format? Then read Convert CSV to MT940 and Convert CSV to CAMT.053.

The approach at a high level

1. Create a separate bank account with a suspense account for Mollie in Yuki.
2. Download the settlement CSV per payout from the Mollie Dashboard.
3. Convert the CSV to MT940 or CAMT.053 with StatementBridge.
4. Deliver the file via the Yuki inbox (Postbus) or by email.
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 suspense account in Yuki

1. Add a new bank account in your administration in Yuki.
2. Give it a recognizable description, for example Mollie suspense account.
3. Link the account to a ledger account in the cash and cash equivalents class, for example 1080 Mollie suspense account.
4. Enter a fictitious IBAN — a recognizable sequence that no real bank issues, such as NL00MOLL0000000000.
5. 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 or CAMT.053

Yuki processes MT940 and CAMT.053 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 or CAMT.053 as the target.
4. Enter the fictitious IBAN that you linked to the Mollie suspense account in step 1.
5. Download the converted file.

Important: do not open the converted file before you deliver it. The check digit in the file allows Yuki to verify that the file has not been modified.

Step 4 — Deliver into Yuki via the inbox or email

Yuki works differently from most accounting packages: you deliver bank files via the inbox (Postbus) or by email, not via a traditional import menu.

1. Log in to Yuki and go to the inbox (Postbus).
2. Upload the converted MT940 or CAMT.053 file via the upload function.
3. Yuki automatically recognizes the file as a bank statement and processes it in your administration.
4. Alternatively: send the file as an attachment by email to yourdomainname@yukiworks.nl.

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

Step 5 — Post the payout and transaction costs correctly

Under the Mollie suspense 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.
• Opening the file before uploading. Do not open the bank file; Yuki uses the check digit to verify that the file is unchanged.
• 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 suspense account per currency.

File not recognized by Yuki?

Do you get a message such as Bank account not recognized or Invalid file format? With StatementBridge you can still convert the Mollie export into a Yuki-friendly MT940 or CAMT.053 file with the correct IBAN.