Import camt.053 / camt.054 into YNAB

Turn your camt.053 / camt.054 export into a file YNAB imports without a fuss. It takes a minute, and your file never leaves your device.

  1. Download your camt.053 / camt.054 export

    1. In your e-banking, open the account's transactions or statements and look for an export.
    2. Choose camt.053, also called ISO 20022, XML or camt; camt.054 and camt.052 work too.
    3. Pick the period and download the .xml file; unzip it first if it comes as a .zip.
    4. Export each account to its own file, to import it into the matching YNAB account.

  2. Drop it here and hit YNAB it!

    You can add several files at once, also from other banks. Each one becomes its own …_ynab.csv.

  3. Import it into YNAB

    In YNAB on the web, open the matching account, click Import and drop the file in. The columns match by themselves.

camt.053 / camt.054 to YNAB: questions

Is my camt.053 / camt.054 file uploaded anywhere?

No. ynabit converts it with JavaScript in your browser. There is no server that could receive it, and nothing is kept once you close the page.

What does the converted file look like?

A CSV with one row per transaction and the columns Date, Payee, Memo, Outflow and Inflow: dates as YYYY-MM-DD, a dot for decimals, and each amount in Outflow or Inflow, so YNAB maps the columns by itself.

My camt.053 / camt.054 file isn't recognised. What now?

Check that you downloaded the export described above, not a PDF or Excel file. Then pick camt.053 / camt.054 in the list next to the file: the error tells you what the converter expected. If it still fails, report it on GitHub with a few anonymised lines.

Can I convert several camt.053 / camt.054 files at once?

Yes. Drop several months, or files from other banks and cards, together. Each one becomes its own …_ynab.csv to import into the matching YNAB account.

Other banks and formats