MCP App Store
by KeenEthics
Zovo MT940 Converter icon

Zovo MT940 Converter MCP Server for ChatGPT

By Zovo

Overview

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.

How to connect

  1. ChatGPT: Open the Zovo MT940 Converter listing in the ChatGPT app directory and choose Connect. ChatGPT listing Zovo MT940 Converter exposes 1 tool here.

Tools

convert_mt940_statement

ChatGPT
Use this when the user wants to convert an MT940 file to Excel or CSV ("mt940 to excel", "mt940 converter", "convert mt940 to csv", "camt 053 to excel", "camt.053 converter") or check that a bank statement file adds up. Reads SWIFT MT940 (.sta, .mt940, .txt) or ISO 20022 camt.053 / camt.052 / camt.054 XML from the attached file or pasted text, and returns an Excel workbook (Transactions sheet with booking date, value date, signed amount, debit, credit, running balance, counterparty, description, references; Balance check sheet) and a CSV. Checks opening + credits - debits = closing for each statement to the cent and shows any difference. Does not read PDF or CSV statements, does not categorize transactions, and does not send data to a bank.

Capabilities

Interactive

Example Prompts

Click any prompt to copy it.

Similar Apps

Listed on MCP App Store

Listed on MCP App Store

Add this badge to your site or README. It links to this page.

HTML

<a href="https://mcp-app-store.keenethics-labs.com/app/zovo-mt940-converter"><img src="https://mcp-app-store.keenethics-labs.com/badges/listed-on-mcp-app-store.svg" alt="Listed on MCP App Store" width="220" height="44"></a>

Markdown

[![Listed on MCP App Store](https://mcp-app-store.keenethics-labs.com/badges/listed-on-mcp-app-store.svg)](https://mcp-app-store.keenethics-labs.com/app/zovo-mt940-converter)