Convert camt.053 XML to Excel

What camt.053 is

camt.053 is the ISO 20022 bank-to-customer statement message, the XML successor to MT940 that banks increasingly offer for business accounts. A file contains a BkToCstmrStmt element with one or more Stmt blocks. Each has an account identifier, balance elements (Bal, with codes such as OPBD for opening booked and CLBD for closing booked) and a list of Ntry entries. Each entry carries an amount with a currency, a credit or debit indicator, booking and value dates, and remittance information.

The format is rich and verbose, which is its weakness for humans: a single payment can span dozens of lines of XML. Opening one in a text editor is a poor way to see what happened in an account.

What you get

Add one or more camt.053 files. Tallyscope reads each statement, its account, currency and the opening and closing booked balances, and turns each entry into a row with date, description (assembled from the remittance and counterparty text), signed amount and currency. The opening and closing balances are used for the arithmetic check: the entries should take the opening balance to the closing one, and the statement's status says whether they do. Details of the statuses are on how verification works.

Nothing about this needs OCR or layout guessing, so camt.053 files normally convert cleanly. We still show the status rather than assume it.

Excel output

The Excel workbook has three sheets. Transactions lists every row with Date, Statement, Account, Description, Category, Currency, Debit, Credit, Amount, Balance, the amount in your reporting currency, whether it counts in totals, and flags. Statements has one line per statement with opening, credits, debits, closing and reconciliation status. Summary gives combined totals. Excel, PDF and JSON export are included in the Day pass and Pro plans; CSV is free for the first 25 rows. See pricing.

Combining with other sources

Real accounting work mixes sources: a camt.053 file from one bank, an OFX download from another, a PDF for an account that offers nothing structured. All of them can be loaded together into one table, overlapping periods are checked for duplicates, and transfers between your own accounts can be excluded from totals. See merging bank statements.

Privacy and handling

camt.053 contains account identifiers and counterparty names. The XML is parsed in your browser and not uploaded. XML is parsed as data, not executed. Read more at converting without uploading.

Limits

If a camt.053 file has no balance elements, there is nothing to check the entries against and the statement will not show as verified. Other camt message types (such as camt.052 intraday reports or camt.054 notifications) are not statements and are outside what Tallyscope is built for; use the camt.053 statement where a choice exists.

Open Tallyscope to load a camt.053 file, or see MT940 to CSV if your bank still uses the older format.