Convert CAMT to TSV

Turn CAMT files into TSV. Every entry of the camt.053 statements, camt.052 reports and camt.054 notifications gives a row with the account's IBAN, the booking date, the signed amount, its currency, the other party's name, the remittance text, the end-to-end reference, the bank transaction code as the type and the bank's reference as the id.

Converted in an isolated sandbox on our serversDeleted after 24 hours

Drop CAMT files on the dialor turn it to pick what to do

One row per entry in your bank statement.Each camt entry becomes a tab-separated row with its IBAN, date, signed amount and payee.

  1. What you get

    One TSV file for the whole input. Every entry of camt.053 statements, camt.052 reports and camt.054 notifications gives one row. The header reads account, date, amount, currency, payee, memo, reference, balance, type, category and id, separated by tabs.

    The row holds the account's IBAN, the booking date, the amount, its currency, the other party's name, the remittance text and the end-to-end reference. The bank transaction code goes in type, and the bank's reference goes in id.

  2. How values are written

    Dates are written as YYYY-MM-DD. Amounts are signed, negative for money out, and keep the digits the file wrote.

    An entry that books several payments at once stays one row, with their names joined in payee.

  3. Balances

    Each balance is counted from the opening balance. It is filled in when the count meets the closing balance. A balance the file does not give stays empty.

    To combine the output with other tables, try merge TSV.

CAMT and TSV.What each format is.

The formats

From · CAMT

ISO 20022 camt Statement

The XML bank statements of ISO 20022 that SEPA banks deliver: camt.053 statements, camt.052 intraday reports and camt.054 notifications.

Extensions
.camt
MIME type
application/x-camt+xml
Kind
Text and data
To · TSV

Tab-Separated Values

Tab-separated values.

Extensions
.tsv .tab
MIME type
text/tab-separated-values
Kind
Text and data

In your code.The same CAMT to TSV conversion through the API, for your app or your agent.

terminal
$ cv convert report.camt report.tsv
$ cv convert report.camt report.tsv

Questions.What people ask about CAMT to TSV.

01OF 04

camt.053 statements, camt.052 intraday reports and camt.054 notifications. Each entry in them gives a row.

Yes. Amounts are signed, and money out is negative. The digits are the ones the file wrote.

It stays one row. The names of the payments are joined in the payee column.

The file does not give that balance, so it stays empty.

More conversions.Other ways in and out of CAMT and TSV.