Convert MT940 or camt.053 to Excel
convert_mt940_statementUse 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.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| file | No | The bank statement file: MT940 (.sta, .mt940, .940, .txt) or camt.053 / camt.052 / camt.054 XML, e.g. statement.sta or camt053.xml. | |
| statement_text | No | The MT940 or camt XML text when it was pasted instead of attached, e.g. ":20:STMT1\n:25:NL91ABNA0417164300\n:28C:1/1\n:60F:C261001EUR1000,00\n:61:2610021002D25,50NTRFNONREF\n:86:Coffee\n:62F:C261002EUR974,50". |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| notes | Yes | ||
| format | Yes | ||
| issues | Yes | ||
| preview | Yes | ||
| downloads | Yes | ||
| file_name | Yes | ||
| mismatches | Yes | ||
| statements | Yes | ||
| not_checked | Yes | ||
| transactions | Yes | ||
| balance_check | Yes | ||
| preview_count | No | ||
| statements_count | No | ||
| flagged_transactions | Yes | ||
| links_expire_minutes | Yes |