Read a camt.053 file without uploading it

What camt.053 is

An account statement in ISO 20022, the international standard for payment messages. Swiss banks have handed it out since their move to ISO 20022, and in Germany and Austria it is replacing the older MT940. The name says what it does: camt stands for cash management, and 053 is the statement for a closed period.

Technically it is XML, which means text with labels. A rough map of what sits inside:

Stmt is the statement itself, one per account and period
Acct/Id/IBAN names the account it belongs to
Bal carries the balances at the start and the end
Ntry is one booked movement, with date, amount and direction
RmtInf holds the remittance information for that movement

These names have stayed the same across versions. Depending on the vintage, the same bank sends a camt.053.001.02 or a camt.053.001.08. Learn the structure once and you can read either.

Why a spreadsheet chokes on it

A CSV is a table: one row, one transaction. A camt.053 is a tree. A single movement can sit several levels down, and a batch booking, a payroll run or a series of direct debits, carries its individual items as child nodes.

Open the file in Excel and you get either an error or a sheet with a hundred columns and the amounts scattered across several of them. In a browser or a text editor you see the XML as it is: correct, complete and unreadable.

What the file does that a CSV cannot

There is a reason for the effort. A camt.053 holds more, and the extra is useful:

The balances. Opening and closing balance are in the file. That gives it its own proof: opening balance plus every movement has to equal the closing balance. If a transaction is missing, it shows.
Direction as a field. Whether money came in or went out sits in CdtDbtInd, not in a minus sign. No guessing whether your bank writes expenses as negatives.
The account. The IBAN is in the file. With a CSV it is in the filename at best.
Structured references. The payment reference is a field of its own rather than a leftover inside the booking text.
Foreign currency. The amount is in account currency with the original beside it. A CSV likes to mix both into one column.

Then there is what the file leaves out: a header row that differs per bank. A CSV has to be mapped every time, telling the software which column is the date and which is the amount. A camt.053 says so itself.

052, 053, 054: the common mix-up

Online banking often lists several of them side by side, and they are not interchangeable.

camt.052 is an interim report during the day. What it contains is not finally booked.
camt.053 is the statement for a closed period. This is the one you want.
camt.054 reports individual credits or debits, usually for matching open invoices.

Pour all three into the same report and you count the same payment more than once: 052 and 054 describe movements that appear in the 053 again.

The options you have

For a private household there are essentially three.

Online viewers and converters

Several free sites take a camt.053 and turn it into a table. They work, and if you want to look inside a file once, they are the fastest route.

The price sits in the small print, and the providers know it: they advertise deletion policies, servers in your own country, conversion inside the browser. You upload a file that holds every payment of a month, with your IBAN, the names of everyone you paid and your balance. For a single look that may be fine. As a monthly habit it is a lot of trust for a table.

Accounting software

Every serious accounting package reads camt.053, because that is what the format was built for. The catch is the purpose: these programs want to reconcile accounts, match documents and produce a balance sheet. To find out how much you spent on groceries in June, you first set up a chart of accounts.

A program on your own machine

The third option is to read the file where it already is. Technically that is the simplest of the three: camt.053 is a standardised file, and a program on your Mac can take it apart with no network connection. What comes out depends on what the program does with the transactions afterwards.

How Parendi does it

Parendi is a personal finance app for the Mac and reads camt.053 directly. You drag the file into the window, and because the account and the structure are in the file, the column mapping a CSV demands falls away. The transactions are then sorted into categories, and the reports follow: spending per category, fixed costs, savings rate.

Two things from the file work for you. The balance proof runs along: if opening balance, movements and closing balance disagree, the app tells you instead of quietly taking the numbers. And a partial statement, one page of a longer one, is recognised as such. camt.052 and camt.054 are rejected with that reason rather than booked as a statement.

The file stays on your Mac throughout. Parendi has no bank connection, never sees your credentials and talks to no server. More about the app, or the supported formats in detail.

A statement written for machines