Import Bank Statements in Twinfield

Importing bank statements in Twinfield

Twinfield (Wolters Kluwer) is a popular accounting package with accounting firms and SMEs in the Netherlands and Belgium. Twinfield has two interfaces: the new Twinfield environment and Twinfield Classic. Both support importing bank statements via MT940 and CAMT.053.

Supported formats in Twinfield

• MT940 (SWIFT): The standard format for bank statements. Supported by both interfaces.
• CAMT.053 (ISO 20022): The newer XML format. Supported in the new interface and recent versions of Classic.
• Bank connection: Direct connections with banks via Twinfield (depending on your subscription).

Import in Twinfield (new interface)

1. Log in to Twinfield.
2. Drag the MT940 or CAMT.053 file onto the Cash & Banks tile at the top of the page.
3. Twinfield automatically recognises it as an electronic bank statement.
4. The transactions are imported and available under Accounting > E-bank statements.

Import in Twinfield Classic

1. Go to General > File management.
2. Upload the MT940 or CAMT.053 file.
3. Click the action menu (blue icon to the left of the file).
4. Choose Import and select “Via electronic bank statement”.
5. Follow the processing wizard to import the transactions.

Convert CSV or Excel for Twinfield

Twinfield does not accept CSV or Excel files for bank statements. If you have transaction data in CSV or Excel, convert it to MT940 first:

1. Upload your CSV or Excel file in StatementBridge.
2. Map the columns (date, amount, description).
3. Enter the IBAN of the account.
4. Export as MT940 and import the result in Twinfield.

Common problems and solutions

Problem	Cause	Solution
“Journal not found”	The IBAN in the file doesn't match a journal in Twinfield	Update the IBAN in the journal or use the correct IBAN during conversion
“File not recognised”	The format is not supported	Convert to MT940 with StatementBridge
Duplicate entries	The statement was already imported	Check the statement number and avoid overlapping periods
Balance mismatch	Opening or closing balance is incorrect	Import statements in chronological order

Convert bank statement for Twinfield

StatementBridge converts any bank statement to the MT940 or CAMT.053 format that Twinfield expects. Whether it's a CSV from your credit card company, an Excel export from a foreign bank, or another format — StatementBridge makes it compatible with Twinfield.