Convert CAMT to OFX
Turn CAMT files into OFX. 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
A bank statement your money app can import.Each camt entry becomes an OFX transaction, grouped by account and currency.
What you get
One OFX 2.1.1 file with a statement for each account and currency. Credit card accounts become credit card statements. The file is the kind that Quicken, GnuCash and most money apps import, and a QFX file is Quicken's flavor of the same format.
Every entry of a camt.053 statement, camt.052 report or camt.054 notification becomes one transaction. An entry that books several payments at once stays one transaction, with the names joined.
How transactions are filled
Each transaction keeps its posting date and its signed amount. The type is kept when it is an OFX type. Otherwise it is CREDIT or DEBIT, chosen by the sign of the amount.
The id becomes the FITID, or one made from the row when the bank gave none. The payee goes into NAME, cut to 32 characters, with up to 100 characters in EXTDNAME. The memo holds up to 255 characters of the remittance text. A numeric reference becomes CHECKNUM.
Balances and gaps
Each balance is counted from the opening balance when the count meets the closing balance. The ledger balance is the closing balance the source gives, or 0.00 when there is none.
A statement without a currency gets XXX. A statement without a bank number gets 000000000.
CAMT and OFX.What each format is.
The formats
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
OFX Bank Statement
Open Financial Exchange, the statement download of North American banks and card issuers that Quicken, GnuCash and most money apps import; QFX is Quicken's flavor of it.
- Extensions
- .ofx .qfx
- MIME type
- application
/x -ofx - Kind
- Text and data
In your code.The same CAMT to OFX conversion through the API, for your app or your agent.
$ cv convert report.camt report.ofx$ cv convert report.camt report.ofxQuestions.What people ask about CAMT to OFX.
camt.053 statements, camt.052 intraday reports and camt.054 notifications. All three become OFX transactions in the same way.
Up to 100 characters. NAME holds the first 32 characters, and EXTDNAME holds up to 100.
They become credit card statements in the OFX file. Other accounts become bank statements.
The ledger balance is set to 0.00.