Import AMEX, PayPal, Stripe and Mollie into AFAS

Importing payment providers into AFAS

AFAS Software is a widely used ERP and accounting package in the Netherlands. AFAS accepts bank statements in MT940 and CAMT.053 format via Financiëel > Bankafschriften > Importeren. CSV and Excel files from payment providers are not directly supported for bank statement import.

Note: AFAS can be strict about the formatting of MT940 files. It is important that the file meets the MT940 specifications that AFAS expects. StatementBridge generates MT940 files that are compatible with AFAS.

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. AFAS 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 AFAS.

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 AFAS via Financiëel > Bankafschriften > Importeren.

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 AFAS.

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 AFAS.

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 of the bank account in AFAS.
4. Export as MT940 or CAMT.053: choose the desired output format and click Convert.
5. Import into AFAS: go to Financiëel > Bankafschriften > Importeren and select the converted file.

Common problems and solutions

Problem	Cause	Solution
"Bank account not found"	The IBAN in the MT940 file does not match a bank account in AFAS	Create the bank account in AFAS with the correct IBAN, or adjust the IBAN during conversion in StatementBridge
"Invalid MT940 format"	AFAS expects a specific MT940 format that does not match	Use StatementBridge for the conversion — the generated files are compatible with AFAS
"Invalid file format"	The CSV file was uploaded directly into AFAS	AFAS 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. AFAS typically blocks duplicates based on the statement number
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
Balance error during import	Opening or closing balance in the file differs from the records in AFAS	Check the previous statement and import statements in order. Adjust the opening balance if needed