MT940 Converter  Univik MT940 File Converter

Excellent  4.8 TrustRating (189 Verified Reviews)

Convert MT940 Bank Statements to Excel, CSV, PDF and More

Univik MT940 Converter reads SWIFT MT940 electronic bank statement files and converts every transaction, balance and reference field to Excel, CSV, PDF, OFX, QIF and more. 100% offline. No data leaves your computer.

Free Download
Windows 7 / 8 / 10 / 11

See Output Formats

*Free trial converts the first 10 transactions per file. No registration required.

  • All SWIFT MT940 Tags: Reads :20:, :25:, :28C:, :60F:, :61:, :62F:, :86: and all standard transaction fields without data loss.
  • 7 Output Formats: Export to Excel, CSV, PDF, OFX, QIF, QBO and plain text. Each format is optimized for accounting software import.
  • Batch Conversion: Convert entire folders of MT940 files in one run. Handles files from any bank worldwide.

Univik MT940 File Converter Box

CIO CHOICE AWARD ★ 2019 ★

Trusted by Finance Teams

Used by accountants, ERP admins and treasury teams across 100+ countries to process SWIFT bank statements.

 MT940 SWIFT Fields Supported

 About the Format

What is an MT940 File?

The SWIFT standard that banks worldwide use to deliver structured electronic account statements.

MT940 Explained

MT940 stands for Message Type 940, a SWIFT financial messaging standard. Banks use it to transmit electronic account statements in a structured, machine-readable format.

The format organizes each bank statement into tagged fields. Every transaction carries a booking date, value date, credit or debit indicator, amount, currency and a freeform reference field that describes the payment.

MT940 files typically carry extensions .mt940, .sta or .940 and are generated by banks, ERP middleware and treasury management systems.

SWIFT Tag Reference

:20:Transaction ReferenceUnique statement identifier
:25:Account IdentificationIBAN or account number
:28C:Statement / Sequence No.Statement number and page
:60F:Opening BalanceBalance at period start
:61:Statement LineIndividual transaction record
:86:Information to Account OwnerPayment reference and description
:62F:Closing BalanceBalance at period end
:64:Closing Available BalanceAvailable funds at close

MT940 Sample Structure

:20:STMTREF-0001         ← Transaction Reference
:25:DE89370400440532013000/EUR  ← Account (IBAN/Currency)
:28C:00001/001           ← Statement No. / Sequence
:60F:C250101EUR10000,00  ← Opening Balance (Credit)
:61:2501020102CR500,00NTRFPAYREF001  ← Transaction Line
:86:CUSTOMER PAYMENT INV-2025-001    ← Reference/Description
:62F:C250102EUR10500,00  ← Closing Balance

 Output Formats

Convert MT940 to 7 Formats

Every output format is purpose-built. Pick the one that matches your accounting system, analysis tool or compliance need.

📊
Excel (XLSX)
Pivot tables, analysis, budget reporting. Each transaction row is fully formatted with date, debit/credit columns.
📋
CSV
Import into SAP, Oracle ERP, MySQL, or any spreadsheet. Delimiter configurable: comma, semicolon or tab.
📄
PDF
Formatted bank statement for archiving, audits and sharing with accountants or compliance teams.
🏦
OFX
Open Financial Exchange format. Direct import into QuickBooks, Microsoft Money and Sage accounting.
💰
QIF
Quicken Interchange Format. Compatible with Quicken, YNAB and older personal finance applications.
🔗
QBO
QuickBooks Online Web Connect format. Upload directly into your QBO company file without manual entry.
📝
Plain Text
Readable TXT output with clean line-by-line formatting. Useful for log processing and custom scripts.

 Key Features

Why Choose Univik MT940 Converter

Built for finance professionals, accountants and ERP administrators who need accurate, repeatable MT940 processing.

All SWIFT Tags

All SWIFT Tags Parsed

Every standard MT940 field is read and exported: transaction reference (:20:), account identification (:25:), opening balance (:60F:), each transaction line (:61:), narrative (:86:) and closing balance (:62F:). Nothing is dropped or truncated.

Batch Conversion

Batch Folder Conversion

Point the converter at a folder and convert every MT940 file inside it in one run. Each statement outputs to its own file, named automatically. Essential for monthly reconciliation across multiple accounts or entities.

Offline Processing

100% Offline Processing

Bank statement data is among the most sensitive financial information in any organization. Univik MT940 Converter runs entirely on your Windows machine. No files are uploaded, no API calls are made and no data leaves your network perimeter.

All Banks

All Banks Worldwide

MT940 is a universal SWIFT standard. The converter handles statements from HSBC, Deutsche Bank, ING, ABN AMRO, Barclays, UBS, BNP Paribas, Raiffeisen and thousands of other institutions without bank-specific configuration.

Data Integrity

Transaction Integrity Verified

The converter validates opening balance, transaction totals and closing balance after every conversion. If the arithmetic does not reconcile, the software flags the discrepancy before you export so you always deliver clean data.

Filter Transactions

Date Range and Amount Filters

Export only the transactions you need. Filter by booking date range, value date, debit or credit, amount threshold or reference keyword before exporting. Useful for isolating specific payment runs or investigation periods.

 How It Works

Convert MT940 in 3 Steps

From raw SWIFT file to clean spreadsheet in under a minute.

1

Load Your MT940 File

Click "Open File" or drag and drop your .mt940, .sta or .940 file into the converter. Load a single statement or an entire folder. The software instantly parses all SWIFT tags and shows a live transaction preview.

2

Choose Output Format

Select your target format: Excel for analysis, CSV for ERP import, OFX or QBO for QuickBooks, QIF for Quicken, or PDF for archiving. Apply date range or amount filters to narrow the transaction set if needed.

3

Export and Import

Click "Convert" and your output file is ready in seconds. Every transaction field maps cleanly to a column or field in the target format. Import directly into QuickBooks, SAP or open in Excel for reconciliation.

 Compatibility

Works With Every System

MT940 output formats are accepted by every major accounting, ERP and treasury platform.

SAP

SAP ERP

Via CSV / MT940 direct import. Maps to BSEG and BKPF tables.

QuickBooks

QuickBooks

QBO Web Connect and OFX direct upload. Desktop and Online.

Oracle

Oracle Financials

CSV import for Oracle Cash Management and GL reconciliation.

Sage

Sage Accounting

OFX and CSV import for Sage 50, Sage 200 and Sage Business Cloud.

Excel

Microsoft Excel

XLSX output with pivot-ready columns for instant analysis and reporting.

Xero

Xero

OFX and CSV compatible with Xero bank statement import.

Dynamics

Microsoft Dynamics

CSV import for Dynamics 365 Finance bank reconciliation module.

Quicken

Quicken / YNAB

QIF import for personal finance and treasury management.

 Use Cases

Who Uses MT940 Converter

Finance professionals across sectors rely on MT940 conversion daily.

Bank Reconciliation

Bank Reconciliation

Convert MT940 statements to CSV or Excel and import into your GL system. Match transactions against invoices and payments automatically. Reduce month-end closing time from days to hours.

ERP Integration

ERP / Accounting Integration

Treasury and ERP administrators convert MT940 files daily for automated posting into SAP, Oracle and Dynamics. CSV output maps directly to bank statement import templates without manual reformatting.

Audit and Compliance

Audit and Compliance

Auditors and compliance teams convert MT940 to PDF for immutable statement archives, and to Excel for transaction sampling, anomaly detection and regulatory reporting across multiple accounts and periods.

Cash Flow Analysis

Cash Flow Analysis

Finance managers pull MT940 statements from multiple bank accounts and consolidate them in Excel for cash flow modelling, liquidity forecasting and working capital analysis across currencies and entities.

Fraud Investigation

Fraud Investigation

Forensic accountants and investigators load MT940 statements and filter by amount, date and reference keyword to identify suspicious patterns, duplicated payments and unauthorized transactions efficiently.

Univik MT940 Converter Features

 Why Univik

Why Finance Teams Choose Univik

Univik has built precision data conversion tools since 2013. The MT940 Converter brings the same accuracy and reliability to financial data processing.

  • Full SWIFT MT940 specification compliance. No proprietary guesswork.
  • Balance validation catches discrepancies before you export.
  • 100% offline. Bank data never leaves your environment.
  • Batch processing handles month-end volumes without manual intervention.
  • 7 output formats cover every accounting and ERP system in use today.
  • Works with MT940 files from any bank in any country.
  • No subscription. No cloud dependency. One-time licence.
  • 24/7 technical support from the Univik engineering team.
Learn About Univik Our Compliance Standards Email Migration Service

 FAQs

Common Questions

Answers to the most common questions about MT940 conversion.

MT940 is a SWIFT bank statement format used by banks to deliver electronic account statements. Your bank generates it via their online banking portal or treasury service. Files carry extensions .mt940, .sta or .940. They contain all transactions for a given account and period, structured with standard SWIFT field tags.

MT940 is a universal SWIFT standard used by thousands of banks globally. Notable examples include HSBC, Deutsche Bank, ING Group, ABN AMRO, Barclays, UBS, Credit Suisse, BNP Paribas, Raiffeisen Bank, Commerzbank and most major European, Asian and US banks. If your bank supports SWIFT messaging, they almost certainly offer MT940 downloads.

Yes. Currency is embedded in the MT940 account identification field (:25:) and each balance field (:60F:, :62F:). The converter reads and preserves the currency code for every transaction and balance. When converting multiple files covering different currencies, each output file retains its source currency information.

The :61: field (Statement Line) is the machine-readable transaction record containing booking date, value date, credit/debit indicator, amount, transaction type code and a bank reference. The :86: field (Information to Account Owner) is the freeform narrative field added by the bank or originating party, typically containing payment descriptions, invoice numbers, counterparty names and remittance information. The converter exports both fields into separate columns.

The CSV output is structured for direct SAP upload via the bank statement import transactions (FF.5, FEBAN). The column mapping matches SAP's standard bank statement format. For SAP S/4HANA, the CSV can be used with the Multi-Bank Connectivity import process. The Excel output is useful for pre-import validation and manual journal preparation.

Start Converting MT940 Files Today

Free trial available. No registration. Your bank data stays on your machine.

Free Download Talk to Expert

Windows 7, 8, 10, 11  |  100% offline  |  No subscription

Written by Univik Research Team

The Univik Research Team has been building data conversion software since 2013. Our engineers specialize in financial data formats including SWIFT MT940, MT942, OFX, QIF and QBO. This page is reviewed quarterly against the latest SWIFT Standards and bank implementation guides. Read more on the Univik blog.