[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

CAMT053 - One bank statement import format for SEPA



Hi,


Looking to improve my bank statement import and reconciliation process, I found that my bank offers the option to download CAMT053 format files. I then noted that many banks offer this type of download which is an XML format download as it seems to be part of the SEPA specification.

Looking at my own transaction logs in this format (admittedly in my personal account, I haven't looked in my business account yet), I see many variations of combinations of fields having been used. So, I'm now wondering about the best strategy to

1. Extract info from the XML; and
2. To match extracted info from the XML in the reconciliation

Some banks send very nice descriptive info in the payments, like bank account, postal address and name of the transaction counter party *and* the other bank involved in the transaction. However, some banks send nothing but a blurb of payment data which doesn't have any semantical markup. Take this example (the text comes all in one line): """11.58.56.730 ZIGGO B.V. BETALINGSKENM. ARNL55636877895 KLANTNR* 11136210 ABON T/M OKT, FACT.NR* 395630014FACT. OP WWW.ZIGGO.NL/MIJNZIGGO"""

Without the quotes. How do I assign meaning to that blurb and blurbs like it when feeding data to my reconciliation routine?

I'd like to tackle this format in a way that others benefit as well, so I'm looking forward to read your comments!


--
Bye,

Erik.

http://efficito.com -- Hosted accounting and ERP.
Robust and Flexible. No vendor lock-in.