Import AMEX, PayPal, Stripe and Mollie into Twinfield

Importing payment providers into Twinfield

Twinfield (Wolters Kluwer) is a popular accounting package for accountants and SMEs in the Netherlands. Twinfield accepts bank statements in MT940 and CAMT.053 format via Boekhouding > Bank/Kas > Import. CSV and Excel files from payment providers are not directly supported.

Important: before importing a file, the bank journal in Twinfield must be created with the correct IBAN. Go to Instellingen > Boekhouding > Dagboeken and create a journal of type Bank/Kas with the IBAN that matches the converted file.

AMEX (American Express)

American Express provides transaction statements as a CSV file. You download this via your AMEX account under Statements > Download. The CSV file contains columns such as date, description, amount and reference number. Twinfield cannot import this CSV file directly — conversion to MT940 or CAMT.053 is required.

ICS (Visa/Mastercard)

ICS processes credit card transactions for Visa and Mastercard in the Netherlands. ICS offers statements as PDF or CSV. You can download the CSV export via Mijn ICS. PDF statements can be processed with the AI extraction feature of StatementBridge (Pro). After conversion to MT940, you import the file into Twinfield.

PayPal

PayPal provides transaction statements as a CSV file. You download this via Activity > Download Reports on paypal.com. Note: PayPal exports contain columns such as Gross, Fee and Net. Use the Gross column as the amount for the full transaction value. After conversion to MT940, you import the file into Twinfield via Boekhouding > Bank/Kas > Import.

Stripe

Stripe offers payout reports and transaction data as a CSV file via the Stripe Dashboard under Payments > All transactions > Export, or via Balance > Payouts. Stripe CSV files contain columns such as Created, Amount, Fee and Description. After conversion to MT940 or CAMT.053, you can import the Stripe transactions into Twinfield.

Mollie

Mollie offers settlements and payment overviews as a CSV file via the Mollie Dashboard under Finances > Exports. Mollie exports contain columns such as Created at, Amount, Method and Description. After conversion to MT940, you can import the Mollie transactions into Twinfield.

Conversion in 5 steps

1. Export from the payment provider: download the CSV or Excel file from your AMEX, ICS, PayPal, Stripe or Mollie account.
2. Upload to StatementBridge: go to StatementBridge and upload the file.
3. Map the columns: assign the columns to the correct fields (date, amount, description, reference). Enter the IBAN that matches the journal in Twinfield.
4. Export as MT940 or CAMT.053: choose the desired output format and click Convert.
5. Import into Twinfield: go to Boekhouding > Bank/Kas > Import, select the journal and upload the converted file.

Common problems and solutions

Problem	Cause	Solution
"Journal not found"	The IBAN in the MT940 file does not match a journal in Twinfield	Create a journal of type Bank/Kas with the correct IBAN under Instellingen > Boekhouding > Dagboeken
"Invalid file format"	The CSV file was uploaded directly into Twinfield	Twinfield does not accept CSV. Convert to MT940 or CAMT.053 first via StatementBridge
Duplicate transactions	The same period was imported multiple times	Check the statement numbers. Twinfield warns about duplicates — do not confirm without checking
Amounts are incorrect (PayPal)	The Net column was used instead of Gross	Use the Gross column for the full transaction amount. Book PayPal fees separately
Currency issues	The export contains multiple currencies (e.g. USD and EUR)	Filter the export by a single currency or process each currency separately with its own journal
IBAN does not match	The IBAN used during conversion differs from the journal in Twinfield	Use the same IBAN during conversion in StatementBridge as in the Twinfield journal