Zovo MT940 Converter
ChatGPT pluginMT940 and camt.053 to XLSX
Convert MT940 to Excel and CSV, and check that each bank statement adds up. Attach the MT940 file (.sta, .mt940, .940 or .txt) or the camt.053 XML statement your bank or accounting system gave you, and get an Excel workbook and a CSV you can open, filter and import.
What you get
- A Transactions sheet with booking date, value date, signed amount, separate debit and credit columns, currency, running balance, counterparty name and account, description, bank transaction code and references; dates are real dates and amounts are numbers
- A Balance check sheet: for each statement, opening balance + credits - debits is compared with the closing balance in the file, to the cent, and any difference is shown
- A warning when a statement's opening balance does not equal the previous statement's closing balance, which usually means a statement is missing
- The same transactions as CSV
Formats
- SWIFT MT940, with or without the {1:}{2:}{4:} envelope, several statements and accounts per file, reversal entries (RC, RD)
- German :86: subfields (?00 posting text, ?20 to ?29 purpose, ?32 and ?33 name) and Dutch /NAME/ /REMI/ /IBAN/ fields read into counterparty and description
- ISO 20022 camt.053, camt.052 and camt.054 XML: booked, pending and batch entries, counterparty names and IBANs, remittance text
- Amounts in the currency's minor units (2 decimals for EUR and USD, 0 for JPY, 3 for KWD)
Pending entries and lines that could not be read are kept in the files and flagged, not dropped.
This plugin reads MT940 and camt files. It does not read PDF or CSV statements, categorize spending, or send anything to a bank or accounting system.
Known limits. Up to 50,000 transactions and 15 MB per file. A batch entry in camt.053 is one line with all its payment details joined.
Zovo MT940 Converter is #13,523 of 13,972 ChatGPT plugins by placement.
- Featured
- No
not on the featured shelf
Movement
From our daily snapshots over the last 30 days.
Rank by placement
Not enough data points to chart.
Rank in Finance
Not enough data points to chart.
In its category
How this plugin ranks within each of its categories.
Finance1,111th of 1,136 by placement
| # | Plugin | Position | 7d |
|---|---|---|---|
| 1109 | #13472 | — | |
| 1110 | #13519 | — | |
| 1111 | #13523 | — | |
| 1112 | #13529 | — | |
| 1113 | #13533 | — |
Also on other marketplaces
More from Zovo
All listings by ZovoTallyproof Statement Converter#5986 of 13,972 by placement
InviteKit Calendar Files#6099 of 13,972 by placement
GridSmith Puzzle Maker#6541 of 13,972 by placement
Moon & Star Map#6544 of 13,972 by placement
Sheetwise Label Maker#6640 of 13,972 by placement
Zovo Word Counter#6709 of 13,972 by placement
95 more on the publisher’s page.
Example prompts
- “Convert this MT940 file to Excel”
- “Turn my camt.053 statement into a CSV and check the balances”
- “Convert this MT940: :20:S1 :25:NL91ABNA0417164300 :60F:C261001EUR1000,00 :61:2610021002D25,50NTRFNONREF :62F:C261002EUR974,50”
Skills
mt940-converter
Convert SWIFT MT940 and ISO 20022 camt.053 bank statement files to Excel and CSV, and check that each statement's opening balance plus credits minus debits equals its closing balance.
- Categories
- Sign-in
- On Install
- Capabilities
- Interactive, Read
- Availability
- Available
- Version
- 1.0.0
- Keywords
- mt940 to excel, mt940 converter, convert mt940 to excel, mt940 to csv, camt 053 to excel, camt.053 converter, bank statement converter, swift mt940, sta file to excel, camt 053 to csv
- Created
- October 30, 2026
- More info
- Sponsorship
- Promote this plugin