MT940 to CSV
Convert SWIFT MT940 bank statements to CSV format
MT940 input
Paste data, upload a file or load the sample, then click Convert. Your data is not uploaded or stored.
CSV output
Details
Transaction preview
About MT940 to CSV Converter
Our free MT940 to CSV converter transforms SWIFT MT940 bank statement files into clean, structured CSV data in seconds. The MT940 format is a global standard used by banks worldwide for electronic bank statement delivery, and converting it to CSV makes the data accessible for spreadsheets, accounting software, and custom analysis workflows.
This tool features an advanced format detection that shows whether the :86: details of your file are SEPA structured (EREF+, SVWZ+), ?-subfield structured or free text, whichever bank produced it. A confidence scoring system rates the accuracy of each extracted field so you can trust the output quality.
Your statement is not uploaded or stored, ensuring complete data privacy and security for sensitive financial information. Accountants reconcile the CSV against the ledger in Excel, and finance teams load it into tools that cannot read MT940 directly.
Key Features
- SWIFT MT940 Parsing: Full support for standard MT940 tags including :20:, :25:, :28C:, :60F:, :61:, :86:, :62F:, and :64:
- Format Detection: Shows the :86: style, the tags used and the statement currency
- Confidence Scoring: Per-field and overall confidence ratings for dates, amounts, descriptions, and references
- Tag 86 Format Support: Keeps SEPA structured, ?-subfield structured and free-text :86: details, including multi-line ones
- Multi-Statement Processing: Parses multiple bank statements within a single MT940 file
- Transaction Preview Table: Preview of the first 20 transactions with color-coded amounts; Show selects a transaction's lines in the input
- Opening & Closing Balances: Extracts and displays balance information with currency and date details
- Line-Level Warnings: Names each transaction with a missing or impossible date or a missing amount
- File Upload Support: Upload .mt940, .txt, or .mth files up to 25 MiB
- One-Click Export: Download the converted CSV file or copy the output to your clipboard instantly
How to Convert MT940 to CSV
- Upload or paste your MT940 data: Click the Upload File button to select an MT940 file from your computer, or paste the raw MT940 text directly into the input area.
- Review the input: Verify your MT940 data appears correctly. Use the Sample button to load example data if you want to test the tool first.
- Click Convert to CSV: Press the conversion button to parse the MT940 data and generate a structured CSV output with all transaction details.
- Review confidence scores: Check the detected :86: format and the overall parse confidence percentage.
- Inspect the transaction preview: Browse the interactive table to verify dates, amounts, references, and descriptions before exporting.
- Download or copy the result: Use the Download button to save the CSV file or the Copy button to transfer the data to your clipboard.
Use Cases
- Accounting Reconciliation: Import MT940 bank statements into Excel or Google Sheets for account reconciliation and bookkeeping.
- Financial Audit Preparation: Convert bank data to CSV for auditors who need structured, analyzable transaction records.
- ERP System Integration: Transform MT940 files into CSV for importing into SAP, Oracle, or other enterprise resource planning systems.
- Banking Data Migration: Move transaction history from one banking platform to another by converting to an intermediate CSV format.
- Tax Preparation: Extract and categorize bank transactions for annual tax filing and expense tracking.
- FinTech Development: Test and validate MT940 parsing logic using the tool's sample data and confidence scoring features.
- Cash Flow Analysis: Convert bank statements to CSV for custom financial modeling and cash flow forecasting.
- Multi-Bank Consolidation: Standardize statements from different banks into a single CSV format for unified reporting.
Frequently Asked Questions
What is an MT940 file?
MT940 is a SWIFT (Society for Worldwide Interbank Financial Telecommunication) standard message type used for electronic delivery of bank account statements. It contains structured transaction data including dates, amounts, references, balances, and counterparty information in a standardized text format.
Which banks' MT940 formats are supported?
Any MT940 that follows the SWIFT tag layout, including exports from Deutsche Bank, ING, Rabobank, Sparkasse and ABN AMRO. The tool reads the standard tags the same way for every bank and shows how the :86: details are structured.
What does the confidence score mean?
The confidence score indicates how reliably each field was extracted from the MT940 data. A score of 90% or higher means high-quality extraction, 70-89% indicates potential minor issues, and below 70% suggests checking those transactions against the original file.
Can I convert multiple MT940 statements at once?
Yes, the converter handles MT940 files containing multiple statements. Each statement with its own reference, account, and transactions is processed and included in the combined CSV output.
Tips & Best Practices
- Verify the source file: Ensure your MT940 file is complete and not truncated, as partial files may produce warnings or missing transactions.
- Check the confidence scores: After conversion, review the overall and per-field confidence ratings to ensure the extraction quality meets your requirements.
- Use Show in the preview: Show selects a transaction's :61: and :86: lines in the input so you can compare them with its CSV row.
- Try the sample data first: Load the built-in sample to familiarize yourself with the tool's output format before converting your own MT940 files.
- Review the transaction preview: Always check the interactive preview table to spot any parsing anomalies before downloading the final CSV.
- Keep your original file: Always maintain a backup of the original MT940 file, as the CSV conversion is a one-way transformation that may simplify some structured data.