Convert credit card statements to MT940 — Amex, Visa, Mastercard

Convert credit card CSVs and PDF statements from Amex, Visa and Mastercard to MT940, CAMT.053, Excel or any other import format.

The problem with credit card statements

Credit card companies provide statements in proprietary formats that are incompatible with your accounting software. Common issues include:

  • CSV files with non-standard column layouts and date formats
  • Amounts shown as negative (debit) where your software expects positive
  • Missing fields such as IBAN, BIC or balance
  • Only a PDF statement available, no digital file
  • Foreign currencies and exchange rates in the file

The solution: StatementBridge

StatementBridge provides tools to correctly process credit card CSVs: map columns, reverse amounts (debit/credit) and fill in account details.

  1. 1
    Upload

    Upload your credit card CSV or PDF statement

  2. 2
    Map columns

    Map date, amount and description to the correct columns. Use the "Reverse amounts" option for credit card transactions

  3. 3
    Review transactions

    Review the recognised transactions, add account details (IBAN, BIC, balance)

  4. 4
    Export

    Download as MT940, CAMT.053, Excel or another format for your accounting software

Supported credit card formats

American Express

CSV exports from the Amex portal with transaction date, amount, description and reference.

Visa & Mastercard

CSV statements from banks issuing Visa/Mastercard, including ICS and other providers.

PDF statements

Credit card statements in PDF format? With AI PDF extraction (credit or Pro with your own key), transactions are recognised automatically.

Comparison: credit card formats by issuer

Each credit card company delivers data in its own format. Here are the key differences:

FeatureAmerican ExpressVisa / Mastercard (ICS)Bunq / Revolut
File typeCSV (comma-separated)CSV (semicolon-separated)CSV or Excel
Date formatDD/MM/YYYYDD-MM-YYYYYYYY-MM-DD
Amount signNegative = chargesPositive = chargesVaries
Currency columnYes (separate)No (EUR only)Yes (ISO code)
CounterpartyIn descriptionSeparate fieldSeparate field

StatementBridge recognises all these formats automatically and provides the option to manually map columns when the format deviates from the standard.

Tips for credit card import

  • Reverse amounts: With some credit card companies, charges appear as negative amounts. Use the “Reverse amounts” option in step 2 to correct this.
  • Account number: A credit card account has no IBAN. The IBAN on your card statement is usually the bank account the balance is debited from — do not use it for the card transactions. Create a separate credit card account in your package and use a fictitious account number or the account code your package prescribes.
  • Enter balance manually: Since credit card files don't include opening and closing balances, you can set these manually for a correctly balanced MT940 file.
  • PDF statement: If you only have a PDF, use AI PDF extraction (credit or Pro with your own key) to automatically recognise transactions.

Compatible accounting software

Export your credit card transactions to the format your accounting software requires:

  • Exact Online, Twinfield, AFAS — via MT940 (.sta)
  • Visma eAccounting — via CAMT.053 (.xml)
  • SnelStart, e-Boekhouden, Yuki — via MT940 or CSV
  • Excel analysis — via .xlsx with full transaction details
Convert credit card statement

Frequently asked questions about credit card statements

Can I import a credit card statement into my accounting software?

Yes. Upload your credit card CSV or PDF in StatementBridge, map the columns and export to MT940, CAMT.053 or Excel. The converted file can be imported directly into your accounting software.

My credit card statement has no IBAN. What now?

Credit card statements indeed don't contain an IBAN. A credit card account has no IBAN. The IBAN on your card statement is usually the bank account the balance is debited from — do not use it for the card transactions. Create a separate credit card account in your package and use a fictitious account number or the account code your package prescribes.

Are foreign currencies handled correctly?

A statement has one currency. StatementBridge keeps the statement currency and does not convert amounts; a file with several currencies is refused. If your export contains several currencies, split them first and convert each currency separately, with its own account and the correct currency code. For a credit card, choose the column with the amount in the card's settlement currency (usually EUR).

Related conversions

Exact Online Import

Import credit card transactions into Exact Online in the correct format.

Twinfield Import

Load credit card statements into Twinfield Accounting without manual rework.

MT940 Converter

Convert MT940 SWIFT files to CSV, Excel or CAMT.053.

Bank Statement to Excel

Turn credit card or bank statements straight into a ready-to-use Excel spreadsheet.