Why are some entries missing from the result?

Entries with status PDNG (pending) or INFO are not booked yet, so they are left out, and a booked entry whose amount or date cannot be read is left out too. A booking is also left out when it is identical in every field, with a real bank reference (AcctSvcrRef), to one in an earlier report of the same file. Each of these gets a warning above the result with the amounts, so you can check them. Bookings that only look like repeats are kept, with a warning.

Can I import this into QuickBooks or Xero?

Not from this page. The bookings in a camt.052 report come again in the end-of-day camt.053 statement, so importing both would count them twice, and pending entries can still change. Only the spreadsheet CSV is offered. Convert the camt.053 statement for your books.

Was my report checked against its balances?

Only when it has a booked opening and a booked closing balance and no pending entries. The result says for each file whether every report was checked, and gives a loud warning when a checked report does not add up.

How are rows counted for the free limit?

Each entry in the file counts as a row, across all reports and accounts, including pending ones. Files up to 50 rows are free.

camt.052 to CSV converter

A camt.052 file is the ISO 20022 XML account report a bank sends during the day or between statements. It has the same entries as a camt.053 statement, but entries can be pending, and the balances are interim ones.

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

Convert a camt.052 account report

camt.052 to Excel (CSV)

Choose file

An .xml file from your bank's camt.052 (intraday or interim account report) 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.052 file?

camt.052 is the bank-to-customer account report of the ISO 20022 standard. Banks send it during the day, for example every hour, or on request. It replaces the SWIFT MT942 and MT941 messages. Each report (Rpt) names the account and lists entries (Ntry) like a camt.053 statement does.

Entries carry a status. BOOK means booked. PDNG means pending: the bank expects the booking but it can still change or be cancelled. INFO is for information only. The converter turns booked entries into rows and leaves the others out, with a warning that counts them and shows their amounts.

Balances in a report are interim. The converter checks a report only when it has a booked opening balance (OPBD, PRCD, or the earlier of two interim booked balances, ITBD) and a booked closing balance (CLBD or the later ITBD), and no pending entries. Swiss banks count pending entries inside the interim balance, other banks may not, so a report with pending entries is not checked rather than checked against a guess. Available balances (ITAV, CLAV) are never used.

Banks often repeat every booking since the last statement in each new report. A booking is left out as a repeat only when an earlier report of the same file holds a booking that is identical in every field and it has a real bank reference (AcctSvcrRef). Placeholders such as NONREF do not count as a reference, and neither does the entry number NtryRef, which banks often restart in each report. Each repeat left out is listed in a warning with its date and amount. Identical bookings without a real reference are all kept, with a warning, because two equal payments cannot be told apart. A booking with the same bank reference, date and amount as one in an earlier report but a difference in any other field is also kept, with a warning, so you can delete copies by hand.

What was tested: An independent reviewer ran it on 20 published camt.052 sample files (bank and standards-body examples and open-source test files from Switzerland, Germany, Sweden, Finland and Estonia; one of them is the 2006 version, which is refused by name) and compared every row with the file. It has not been tested by importing into any accounting program, and no bank has confirmed it.

Choose where it is going

Excel (CSV)Convert a camt.052 report to Excel

How to export from your bank

In your online banking or banking software look for the intraday report, account report or camt.052 download.
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.052 files

Versions camt.052.001.02 to .001.08 are read.
Only booked entries (status BOOK) are converted. Pending (PDNG) and information (INFO) entries are left out, counted and named in a warning.
A report is balance-checked only when it carries a booked opening balance (OPBD, PRCD or an earlier ITBD) and a booked closing balance (CLBD or a later ITBD) and has no pending entries. Otherwise the result says it was not checked.
A booking identical in every field, with a real bank reference (AcctSvcrRef), to one in an earlier report of the same file is left out as a repeat, with a warning listing its date and amount. Without a real reference (AcctSvcrRef empty, NONREF or NOTPROVIDED; NtryRef does not count) both are kept, with a warning. A booking with the same reference, date and amount but other fields different is kept, with a warning.
The same bookings come again in the end-of-day camt.053 statement. Do not import both.
Only the spreadsheet CSV is offered.

Questions

Why are some entries missing from the result?: Entries with status PDNG (pending) or INFO are not booked yet, so they are left out, and a booked entry whose amount or date cannot be read is left out too. A booking is also left out when it is identical in every field, with a real bank reference (AcctSvcrRef), to one in an earlier report of the same file. Each of these gets a warning above the result with the amounts, so you can check them. Bookings that only look like repeats are kept, with a warning.
Can I import this into QuickBooks or Xero?: Not from this page. The bookings in a camt.052 report come again in the end-of-day camt.053 statement, so importing both would count them twice, and pending entries can still change. Only the spreadsheet CSV is offered. Convert the camt.053 statement for your books.
Was my report checked against its balances?: Only when it has a booked opening and a booked closing balance and no pending entries. The result says for each file whether every report was checked, and gives a loud warning when a checked report does not add up.
How are rows counted for the free limit?: Each entry in the file counts as a row, across all reports and accounts, including pending ones. Files up to 50 rows are free.