Zovo MT940 Converter

Description

From the marketplace listing

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.