Convert Excel to MT940

Convert your Excel transactions to MT940 or CAMT.053 for import into your accounting software.

Why convert Excel to MT940?

Many business owners track transactions in Excel — for example from a foreign bank, credit card, PayPal, or a personal account. Unfortunately, most accounting packages do not accept Excel files for bank import. The solution: convert Excel to MT940 or CAMT.053.

Why Excel cannot be imported directly

  • Accounting packages expect structured bank statement formats (MT940 or CAMT.053).
  • Excel does not contain metadata such as IBAN, opening/closing balance and statement number.
  • Column layouts vary per user and per source.
  • Conversion to MT940 adds the required structure and metadata.

Convert Excel to MT940 with StatementBridge

  1. Go to StatementBridge and upload your Excel file (.xlsx or .xls).
  2. StatementBridge shows a preview of your data.
  3. Map the columns: assign the columns for date, amount and description to the correct fields. Optionally: counterparty account, counterparty name.
  4. Enter the account details: IBAN of the bank account, currency (default EUR), start and end date.
  5. Choose the output format: MT940 (widely supported) or CAMT.053 (recommended for Exact Online, Visma).
  6. Click Convert and download the result.
  7. Import the file into your accounting software.

Tips for a successful conversion

  • Ensure the date column has a consistent format (DD-MM-YYYY or YYYY-MM-DD).
  • Use positive amounts for credits and negative for debits (or use separate columns for debit/credit).
  • Remove empty rows, subtotals and summary rows.
  • Check that the IBAN matches the bank account in your accounting software.

Which output format to choose?

FormatSuitable for
MT940 Widely supported by virtually all Dutch accounting packages. Good if you're unsure which format your software expects.
CAMT.053 Recommended for Exact Online, Visma eAccounting and other packages that support ISO 20022. Contains more detail.

Common use cases

  • Foreign bank account — your bank doesn't offer MT940.
  • PayPal transactions — import your PayPal overview into your accounting.
  • Credit card transactions — process credit card statements administratively.
  • Migration — import historical transactions when switching to a new accounting package.
  • Cash book or personal account — process manually tracked transactions.
Convert Excel to MT940

Frequently asked questions

Can I import an Excel file directly into my accounting software?

Most accounting packages do not accept Excel for bank import. Convert your Excel file to MT940 or CAMT.053 with StatementBridge, after which you can import it.

Which columns should my Excel file contain?

At minimum a column for date, amount and description. Optionally you can add columns for counterparty account, counterparty name and payment reference. StatementBridge lets you map columns to the correct fields.

Can I import PayPal transactions via Excel?

Yes. Download your PayPal transaction overview as Excel or CSV, upload it in StatementBridge, map the columns and export as MT940. Use your PayPal account IBAN as the account number.

Related articles

MT940 vs CAMT.053: What's the Difference?

Comparison of the two main bank statement formats in the Netherlands.

CSV Bank Statement Import

Guide for converting and importing CSV bank statements.

Credit Card Statement Converter

Convert credit card statements from Visa, Mastercard and Amex for your accounting.

Import Bank Statements in Exact Online

Step-by-step guide for importing bank statements in Exact Online.