How to Import Bank Statements in Yuki

Importing bank statements in Yuki

Yuki is an online accounting platform widely used by accounting firms and SMEs in the Netherlands. Yuki offers extensive options for importing bank statements, including MT940, CAMT.053 and its own document recognition via scan and upload. In this article we explain how to import bank statements in Yuki.

Supported formats in Yuki

• MT940 (SWIFT): The standard format offered by all major Dutch banks. Yuki processes MT940 files automatically after upload.
• CAMT.053 (ISO 20022): The newer XML format. Yuki supports CAMT.053 for all major banks.
• Yuki bank format: A custom Excel-based import format for historical transactions or banks that don't offer MT940/CAMT.053.
• Bank connection (Ponto): Automatic synchronisation via PSD2 bank connections for ABN AMRO, Rabobank, ING, Knab and more. Transactions are synchronised every 6 hours.

Per-bank recommendations: ABN AMRO and ING: use MT940 or CAMT.053. Rabobank: use MT940 Structured or CAMT.053. Only use CSV if MT940 or CAMT.053 is not available.

Uploading bank statements in Yuki

Yuki works differently from most accounting packages: files are delivered via the PO Box or by email, not via a traditional import menu. There are two ways to deliver bank files:

Option 1: Via the PO Box

1. Log in to Yuki and go to the PO Box.
2. Upload your MT940 or CAMT.053 file via the upload function.
3. Yuki automatically recognises the file as a bank statement and processes it in your administration.

Option 2: Via email

1. Send the bank file as an attachment by email to yourdomain@yukiworks.nl.
2. Yuki automatically processes the attached bank statement in your administration.

Important: Do not open the bank file before uploading it to Yuki. The checkdigit in the file allows Yuki to verify the file has not been modified.

Converting CSV or Excel for Yuki

If you have transaction data in CSV or Excel that you want to import in Yuki:

1. Upload your CSV or Excel file in StatementBridge.
2. Map the columns (date, amount, description) to the correct fields.
3. Enter the bank account IBAN.
4. Export as MT940.
5. Upload the MT940 file via the Yuki PO Box or send it by email to yourdomain@yukiworks.nl.

Alternatively, you can use the Yuki bank format: a special Excel template you can fill in yourself and upload for historical transactions.

Common problems and solutions

Problem	Cause	Solution
"Bank account not recognised"	The IBAN in the file does not match an account in Yuki	Add the bank account in Yuki or adjust the IBAN in the file
"Invalid file format"	The file is not in a supported format	Convert to MT940 or CAMT.053 with StatementBridge
Duplicate entries	The same transactions were already imported	Yuki checks for duplicates; verify the date range

Converting bank statements for Yuki

With StatementBridge you can convert any bank statement to the format Yuki expects. From CSV, Excel, PDF or other formats to MT940 or CAMT.053 — ready to import in Yuki in just a few clicks.