Convert CAMT to JSON

Turn CAMT files into JSON. 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

Bank statement entries as JSON rows.Each entry in a camt file becomes one object with the account, date, amount and payee.

  1. What you get

    A single JSON file holding an array. Every entry of the camt.053 statements, camt.052 reports and camt.054 notifications gives one object in it.

    Each object has the keys account, date, amount, currency, payee, memo, reference, balance, type, category and id. The account is the IBAN. The payee is the other party's name, the memo is the remittance text, and the reference is the end-to-end reference. The type is the bank transaction code, and the id is the bank's reference.

  2. How values are written

    Dates are written as YYYY-MM-DD. Amount and balance are numbers with the digits the file wrote, and money out is negative.

    Each balance is counted from the opening balance when the count meets the closing balance. When the file does not give a balance, the value is null.

  3. Entries with several payments

    An entry that books several payments at once stays one row. The names of the parties are joined in the payee value, so the row count matches the entries in the file.

CAMT and JSON.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 · JSON

JSON

JSON, the data format of every API.

Extensions
.json
MIME type
application/json
Kind
Text and data

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

terminal
$ cv convert report.camt report.json
$ cv convert report.camt report.json

Questions.What people ask about CAMT to JSON.

01OF 04

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

Yes. Amount is negative for money out.

It is null. A balance is filled in only when the count from the opening balance meets the closing balance.

Yes. Use merge JSON to join the output with other JSON files.

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