Import AMEX, PayPal, Stripe and Mollie into Yuki

Importing payment providers into Yuki

Yuki is an online accounting platform widely used by accounting firms and SMEs. In addition to regular bank statements, you also want to process transactions from payment providers such as AMEX, PayPal, Stripe and Mollie. Yuki accepts MT940 and CAMT.053 for bank statement import via Bank > Afschriften importeren.

A major advantage of Yuki is that the platform automatically matches transactions with outstanding invoices. This also works for imported payment provider transactions, provided the description or amount matches.

Importing American Express (AMEX) into Yuki

American Express provides transaction statements as CSV or Excel. Yuki cannot read these directly, but via conversion to MT940 or CAMT.053 you can import them easily.

1. Download your AMEX transaction statement via americanexpress.com as CSV.
2. Upload the file in StatementBridge.
3. Map the columns: Date → Date, Amount → Amount, Description → Description.
4. Enter the account number of your separate credit card account (a fictitious number generated in step 4 of StatementBridge, or the account code your package prescribes) — not the IBAN of the bank account on your card statement.
5. Export as MT940 or CAMT.053.
6. Upload the file via the Yuki Postbus or send it by email to yourdomainname@yukiworks.nl.

Tip: Yuki automatically recognises the file as a bank statement and matches transactions with outstanding invoices based on amount and description.

Importing ICS (Visa/Mastercard) into Yuki

ICS provides credit card statements for Visa and Mastercard as PDF or CSV. For import into Yuki:

1. Download your ICS transaction statement as CSV via icscards.nl.
2. Upload the CSV file in StatementBridge.
3. Map the columns for date, amount and description.
4. Enter an IBAN for your credit card account.
5. Export as MT940 or CAMT.053.
6. Upload via the Yuki Postbus or by email.

Note: use the transaction date (not the processing date) for correct matching in Yuki.

Importing PayPal into Yuki

PayPal provides transaction statements as CSV with columns such as Gross, Fee and Net. Yuki cannot process PayPal files directly.

1. Download your PayPal transactions via Activity > Download Reports as CSV.
2. Upload the file in StatementBridge.
3. Map the columns: Date → Date, Net → Amount, Name → Counterparty name, Subject → Description.
4. A bank account linked to PayPal is different from your PayPal balance. Use a separate PayPal ledger and the account identifier supported by your accounting package, for example a fictitious account number generated in StatementBridge. Never use the IBAN of a real bank account. If the package requires a real IBAN, use its PayPal connection or another supported import format.
5. Export as MT940.
6. Upload the MT940 file via the Yuki Postbus.

Tip: Yuki automatically matches PayPal transactions with sales invoices when the amount matches. Gross only matches the invoice amount when every PayPal fee is also imported as a separate line. Use the net movement (Net) to reconcile opening and closing balances; for a PayPal export StatementBridge selects the Net column by default. Gross is appropriate only when every fee is included as a separate movement. Never count both Gross and Net as transactions. Keep Fee for checking costs.

Importing Stripe into Yuki

Stripe offers payout reports and transaction overviews as CSV via the dashboard.

1. Go to the Stripe Dashboard and navigate to Payments > All transactions.
2. Click Export and download as CSV.
3. Upload the CSV file in StatementBridge.
4. Map the columns: Created (UTC) → Date, Amount → Amount, Description → Description.
5. Enter a fictitious account number for your Stripe journal (generate one in step 4 of StatementBridge; it is not issued by a bank and strict packages may reject it).
6. Export as MT940 or CAMT.053.
7. Upload via the Yuki Postbus or by email.

Note: Stripe amounts are often in cents (e.g. 1000 = €10.00). Check in the StatementBridge preview whether the amounts have been converted correctly.

Importing Mollie into Yuki

Mollie is a widely used payment provider for Dutch webshops and provides payout reports as CSV.

1. Log in to the Mollie Dashboard and go to Finances > Exports.
2. Select the desired period and download the report as CSV.
3. Upload the CSV file in StatementBridge.
4. Map the columns: date, amount, description and optionally the Mollie reference.
5. Enter the IBAN of your Mollie account.
6. Export as MT940 or CAMT.053.
7. Upload the file via the Yuki Postbus.

Tip: Mollie sometimes groups multiple payments into a single payout. Use the detailed transaction report for a complete overview per payment, so that Yuki can match each transaction individually with invoices.

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 payment provider account in Yuki or adjust the IBAN in StatementBridge
Transactions are not matched	Amount or description does not match outstanding invoices	Add invoice numbers to the description. Use Gross only when every fee is imported as a separate line; otherwise use Net.
Duplicate bookings	PayPal shows multiple rows per transaction (payment + fee)	Filter by transaction type or import only main transactions
Amounts in cents	Stripe reports amounts in cents instead of euros	Check the preview in StatementBridge and adjust the decimal setting
Currency issues	Transactions in foreign currencies (USD, GBP)	Filter by currency or process each currency separately

Convert payment providers for Yuki

With StatementBridge you convert transaction statements from AMEX, PayPal, Stripe, Mollie and other payment providers to MT940 or CAMT.053. Upload your file, map the columns and download the result — for import in Yuki via the Postbus.