Convert MT940 to QuickBooks
Desktop IIF

Understanding MT940 and Why Convert to IIF for QuickBooks Desktop

MT940 is the SWIFT standard for electronic bank account statements, formally known as “Customer Statement Message.” Used by the vast majority of European banks and many international financial institutions, MT940 provides a structured, machine-readable representation of bank account activity. However, QuickBooks Desktop cannot import MT940 files directly. The IIF (Intuit Interchange Format) is QuickBooks Desktop's native bulk import format, offering full double-entry bookkeeping with balanced TRNS/SPL journal entries. The MT940 to IIF Converter bridges the gap between European banking standards and QuickBooks Desktop accounting.

IIF vs. QBO: Why Choose IIF for QuickBooks Desktop?

When converting MT940 files for QuickBooks, you have two output format options:

• QBO (Web Connect) — Imports transactions as bank feeds. They appear in QuickBooks' “For Review” tab and require manual categorization. Works with both QuickBooks Online and Desktop.
• IIF (Intuit Interchange Format) — Imports as fully balanced double-entry journal entries. Each transaction is already categorized with proper TRNS/SPL pairs. Works exclusively with QuickBooks Desktop (Pro, Premier, Enterprise).

Choose IIF when you're using QuickBooks Desktop and want transactions immediately categorized as proper journal entries. The double-entry structure means your books are balanced from the moment of import — no need to manually categorize each transaction through the bank feed workflow.

How the MT940 Format Works

An MT940 file is organized into statement blocks, each beginning with a :20: tag (transaction reference number) and containing tagged fields that describe the account's activity for a given period:

• :25: — Account Identification — Contains the bank code and account number, often in IBAN format. Identifies which bank account the statement belongs to.
• :60F: — Opening Balance — The account balance at the start of the statement period, including credit/debit indicator, date, currency code, and amount with comma decimal.
• :61: — Statement Line — Each individual transaction with value date (YYMMDD), credit/debit indicator (C, D, RC, RD), amount, SWIFT transaction type code, and customer reference.
• :86: — Information to Account Owner — The narrative description following each :61: line, containing counterparty name, payment reference, or remittance information.
• :62F: — Closing Balance — The account balance at the end of the statement period.

How the Converter Handles European Formats

The MT940 to IIF converter addresses every format difference between European banking and QuickBooks Desktop:

• Comma decimal separators — European convention uses commas for decimal points (1.234,56 instead of 1,234.56). The parser converts all amounts to period-decimal format for the IIF output.
• Two-digit year dates — MT940 uses YYMMDD format (260115 for January 15, 2026). The converter expands to full 4-digit years and reformats to MM/DD/YYYY as required by QuickBooks Desktop IIF.
• Credit/debit mapping — MT940 uses C (credit), D (debit), RC (reversal credit), and RD (reversal debit) indicators. The converter maps C and RC to income entries and D and RD to expense entries with proper double-entry bookkeeping.
• SWIFT envelope stripping — Some MT940 files arrive wrapped in SWIFT message envelopes. The parser automatically detects and strips these to access the statement content.
• BOM handling — European banking systems frequently export files with a UTF-8 byte order mark (BOM) prefix. The parser strips this automatically.

Double-Entry Bookkeeping in the IIF Output

The IIF output follows proper double-entry accounting principles. Each MT940 transaction is converted into a balanced TRNS/SPL pair:

• Credits (C/RC) — Incoming payments create a TRNS line debiting your bank account (increasing the asset) and a SPL line crediting an income account (recognizing revenue).
• Debits (D/RD) — Outgoing payments create a TRNS line crediting your bank account (decreasing the asset) and a SPL line debiting an expense account (recognizing the expenditure).

This structure ensures that every import maintains the fundamental accounting equation and your trial balance remains in balance. The account names used for the bank account and offset accounts are configurable in the tool's settings step.

Importing IIF Files into QuickBooks Desktop

After converting your MT940 file to IIF format, follow these steps to import into QuickBooks Desktop (Pro, Premier, or Enterprise):

1. Open QuickBooks Desktop and go to File → Utilities → Import → IIF Files.
2. Browse to and select your converted .iif file.
3. QuickBooks will validate the file and display a confirmation dialog.
4. Click OK to import. Transactions are created as journal entries in the specified accounts.
5. Open the bank register for your imported account to verify all transactions appear correctly.

Important: Ensure that the account names in the IIF file match accounts in your QuickBooks chart of accounts. If they don't exist, QuickBooks will create them automatically. Consider setting up a dedicated account for your European bank (e.g., “Deutsche Bank EUR”) before importing.

Multi-Currency Considerations

MT940 files from European banks typically contain transactions in EUR, GBP, CHF, SEK, NOK, DKK, or other currencies. The converter preserves all amounts exactly as they appear in the source file. For QuickBooks Desktop with multi-currency enabled, you can create bank accounts denominated in foreign currencies and import the IIF transactions into the matching currency account. Exchange rate differences are handled during reconciliation in QuickBooks.

Related Free Accounting Tools

The MT940 to IIF Converter is part of our complete suite of free QuickBooks conversion tools:

• MT940 to QBO Converter — Convert SWIFT MT940 statements to QBO Web Connect format.
• MT940 to CSV Converter — Convert SWIFT MT940 statements to CSV spreadsheets.
• CAMT.053 to IIF Converter — Convert ISO 20022 CAMT.053 statements to IIF.
• CAMT.053 to QBO Converter — Convert ISO 20022 CAMT.053 statements to QBO.
• CSV to IIF Converter — Convert bank CSV files to QuickBooks Desktop IIF format.
• CSV to QBO Converter — Convert bank CSV files to QBO Web Connect format.
• QBO to IIF Converter — Convert QBO/OFX files to QuickBooks Desktop IIF.
• XLSX to IIF Converter — Convert Excel spreadsheets to QuickBooks Desktop IIF.
• XLSX to QBO Converter — Convert Excel spreadsheets to QBO Web Connect format.
• OFX to IIF Converter — Convert OFX files to QuickBooks Desktop IIF.
• IIF to QBO Converter — Upgrade legacy IIF files to QBO/OFX format.
• PDF to QBO Converter — Convert PDF bank statements to QBO, CSV, or IIF.
• IIF Viewer — Preview and validate IIF files before QuickBooks import.
• QBO Viewer — Preview and inspect QBO files before importing.
• OFX Viewer — Preview and inspect OFX bank statement files.
• Bank CSV Cleaner — Clean messy bank CSV exports.
• Chart of Accounts Generator — Generate industry-specific chart of accounts.
• Duplicate Detector — Find and remove duplicate transactions.
• Import Troubleshooter — Diagnose and fix QuickBooks import errors.
• File Format Detector — Identify unknown financial file formats.
• Stripe to QuickBooks Converter — Convert Stripe payment exports to QuickBooks CSV.
• PayPal to QuickBooks Converter — Convert PayPal activity exports to QuickBooks CSV.
• Shopify to QuickBooks Converter — Convert Shopify payout exports to QuickBooks CSV.
• Etsy to QuickBooks Converter — Convert Etsy shop exports to QuickBooks CSV.