My statement shows one line for many QR-bill payments. Can I see each payment?

Yes. Ask your bank for the camt.054 for that booking. The converter splits the batch into one row per payer, with the amount and the QR or creditor reference, as long as the payments add up exactly to the booked amount.

Can I import this into QuickBooks or Xero?

Not from this page. The same money is on your account statement, often as one batch line, so importing both into one account would count it twice. Only the spreadsheet CSV is offered. Use it to match payments to invoices.

Why is there no balance check?

A camt.054 notification carries no balances, only the bookings. There is nothing in the file to check the entries against, and the result says so.

How are rows counted for the free limit?

Each entry in the file counts as a row, including pending ones; a batch entry counts once even when it becomes several rows. Files up to 50 rows are free.

camt.054 to CSV converter

A camt.054 file is the ISO 20022 XML debit or credit notification. Banks use it to tell you about single bookings, and to list each payment inside a batch booking, such as Swiss QR-bill credits that show as one line on the statement.

$9 per file, pay once. Files up to 50 rows are free. Bigger files from this source need a pass. Pricing.

Convert a camt.054 notification

camt.054 to Excel (CSV)

Choose file

An .xml file from your bank's camt.054 (debit and credit notification, QR-bill or batch detail) download

Your file stays on this device

It is read and converted by this page, inside your browser. Nothing from the file is uploaded, and the converter keeps working offline once the page has loaded.

No file handy? or download the sample to look at it first.

The data in the sample is invented. It is converted on this device, the same way your own file would be.

What is a camt.054 file?

camt.054 is the bank-to-customer debit and credit notification of the ISO 20022 standard. It replaces the SWIFT MT900 and MT910 confirmations. The Swiss guidelines give it two jobs: notice of single debits and credits, and the details of batch bookings.

The common case is incoming payments in a batch. Your account statement shows one credit, for example for all QR-bill payments of a day, and the camt.054 lists each payer, amount and reference. The converter splits such a batch into one row per payment when the payments add up exactly to the booked amount, and keeps it as one line otherwise.

The structured creditor reference (the QR reference QRR, the ISO creditor reference SCOR starting with RF, or an ISR reference) goes into the Reference column, so you can match each payment to its invoice.

A camt.054 has no balances, so the file cannot be checked; every result says so. Only booked entries become rows; pending ones are left out with a warning. The same bookings are on your account statement, so the converter offers only the spreadsheet CSV: importing both into one bank account would count them twice.

What was tested: An independent reviewer ran it on 18 published camt.054 sample files (bank and standards-body examples and open-source test files from Switzerland, Germany, Sweden and Norway) and compared every row with the file. It has not been tested by importing into any accounting program, and no bank has confirmed it. Nothing is left out as a repeat in a camt.054: notifications do not repeat bookings by design, so identical bookings are all kept, with a warning.

Choose where it is going

Excel (CSV)Convert a camt.054 notification to Excel

How to export from your bank

In your online banking or banking software look for camt.054, credit notifications, QR-bill or ISR credits, or batch booking details.
Download the .xml file. If it comes as a .zip, unzip it and upload one .xml at a time.
Upload the .xml file here exactly as downloaded.

What to know about camt.054 files

Versions camt.054.001.02 to .001.08 are read.
A notification has no balances, so it is never balance-checked; the result says so.
A batch booking is split into its payments when they add up exactly to the booked amount. The creditor reference (QR reference, ISO creditor reference SCOR or ISR reference) goes into the reference column.
Only booked entries are converted; pending entries are left out with a warning.
The same bookings are on your account statement. Do not import both into one account.
Only the spreadsheet CSV is offered.

Questions

My statement shows one line for many QR-bill payments. Can I see each payment?: Yes. Ask your bank for the camt.054 for that booking. The converter splits the batch into one row per payer, with the amount and the QR or creditor reference, as long as the payments add up exactly to the booked amount.
Can I import this into QuickBooks or Xero?: Not from this page. The same money is on your account statement, often as one batch line, so importing both into one account would count it twice. Only the spreadsheet CSV is offered. Use it to match payments to invoices.
Why is there no balance check?: A camt.054 notification carries no balances, only the bookings. There is nothing in the file to check the entries against, and the result says so.
How are rows counted for the free limit?: Each entry in the file counts as a row, including pending ones; a batch entry counts once even when it becomes several rows. Files up to 50 rows are free.