Bug 456792 - Adding support for new banking format CAMT.053
Summary: Adding support for new banking format CAMT.053
Status: RESOLVED UPSTREAM
Alias: None
Product: kmymoney
Classification: Applications
Component: importer (show other bugs)
Version: 5.1.2
Platform: Microsoft Windows Microsoft Windows
: NOR normal
Target Milestone: ---
Assignee: KMyMoney Devel Mailing List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2022-07-16 10:31 UTC by Arnold Huzen
Modified: 2022-07-21 16:53 UTC (History)
1 user (show)

See Also:
Latest Commit:
Version Fixed In:
Sentry Crash Report:


Attachments
Format specification in Dutch (395.51 KB, application/pdf)
2022-07-16 10:31 UTC, Arnold Huzen
Details
attachment-26240-0.html (3.64 KB, text/html)
2022-07-21 14:42 UTC, Arnold Huzen
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Arnold Huzen 2022-07-16 10:31:57 UTC
Created attachment 150669 [details]
Format specification in Dutch

SUMMARY
Today I noticed in my banking application that a new format has been introduced for importing transactions into financial applications. The format is called CAMT.053 and I'm not sure if it is just for The Netherlands or also internationaly.

Will this format be supported bij KMyMoney in the (near) future?


EXPECTED RESULT
I hope to see the format available in the importer as supported format.

SOFTWARE/OS VERSIONS
Windows: 10, 11
macOS: 
Linux/KDE Plasma: 
(available in About System)
KDE Plasma Version: 
KDE Frameworks Version: 
Qt Version: 

ADDITIONAL INFORMATION
I'll add the specification document as an attachment. It is only available in Dutch.
Comment 1 Thomas Baumgart 2022-07-16 12:57:30 UTC
Thanks for the information. CAMT.053 itself is not that new. I found traces dating back into 2018 (https://www.sepaforcorporates.com/swift-for-corporates/a-practical-guide-to-the-bank-statement-camt-053-format/). Since it is a SEPA thing, it is used throughout Europe.

KMyMoney relies on the software provided by the (also open source) AqBanking project for this kind of interface. Scanning AqBanking, I found traces of camt.053.001.04 in its sources. So it could well be, that KMyMoney already supports that format through AqBanking. To gain more information, I added the AqBanking maintainer to this request.
Comment 2 martin 2022-07-17 18:09:22 UTC
Hi,

Am 16.07.22 um 14:57 schrieb Thomas Baumgart:
[...]
> --- Comment #1 from Thomas Baumgart <tbaumgart@kde.org> ---
> Thanks for the information. CAMT.053 itself is not that new. I found traces
> dating back into 2018
> (https://www.sepaforcorporates.com/swift-for-corporates/a-practical-guide-to-the-bank-statement-camt-053-format/).
> Since it is a SEPA thing, it is used throughout Europe.
> 
> KMyMoney relies on the software provided by the (also open source) AqBanking
> project for this kind of interface. Scanning AqBanking, I found traces of
> camt.053.001.04 in its sources. So it could well be, that KMyMoney already
> supports that format through AqBanking. To gain more information, I added the
> AqBanking maintainer to this request.
[...]

AqBanking does support import of CAMT 053.001.04 and 052.001.02 documents. At least the latter is well tested, because it is heavily used when requesting tranaction statements from banks in CAMT format via HBCI/FinTS.

CAMT 053.* should work also but is much less tested. Providing a test file might help improving the importer, if necessary.

You can test importing such a file on command line via "aqbanking-cli". The command should be something like:

-------------------------------------------------------------------------------------------X8
aqbanking-cli import -c output.ctx -f inputfile --importer=xml --profile="camt_053_001_04"
-------------------------------------------------------------------------------------------X8

Other CAMT profiles can easily be added to AqBanking's XML importer.


Regards
Martin
Comment 3 Thomas Baumgart 2022-07-18 05:40:55 UTC
I close this off here, as it is an upstream (AqBanking) issue (if any at all).
Comment 4 Arnold Huzen 2022-07-21 14:42:28 UTC
Created attachment 150793 [details]
attachment-26240-0.html

Hello and thank you for replying to my issue.

In your reply you suggest importing the bankstatement through the commandline tool, but that was not what I want. I am looking for a way to import my bankstatement through the importer function of KMyMoney. 

When i choose File > Import... I only get 3 options: CSV, OFX and QIF. At this point I would like to see the option for CAMT.053.

By the way, the executable for aqbanking-cli is not by default installed in the PATH of my Windows 11 computer. The commandline example doesn't work for that reason. Any ideas where to find it, if it was installed together with KMyMoney?
Regards, Arnold Huzen
Comment 5 martin 2022-07-21 15:33:40 UTC
Hi,

Am 21.07.22 um 16:42 schrieb Arnold Huzen:
[...]
> In your reply you suggest importing the bankstatement through the commandline
> tool, but that was not what I want. I am looking for a way to import my
> bankstatement through the importer function of KMyMoney.
[...]

That is just to verify whether your file can already be handled by AqBanking's importer.

[...]
> When i choose File > Import... I only get 3 options: CSV, OFX and QIF. At this
> point I would like to see the option for CAMT.053.
[...]

AqBanking provides some generic GUI dialogs (hint for developers: AB_Banking_CreateImporterDialog and recently AB_Banking_CreateImporterDialogWithPresets) which allow for import of any file type which is supported by AqBanking by letting the user select file, importer and import profile. In case of CSV files import profiles can also be added and edited.

But I don't know whether KMyMoney makes that importer available to the user.

[...]
> By the way, the executable for aqbanking-cli is not by default installed in the
> PATH of my Windows 11 computer. The commandline example doesn't work for that
> reason. Any ideas where to find it, if it was installed together with KMyMoney?
[...]

I don't know KMMs packaging, but if those binaries are provided in the package at all I would expect them in the same folder as the main executable...



Regards
Martin (AqBanking)
Comment 6 Thomas Baumgart 2022-07-21 16:53:47 UTC
Could be, that your version of KMyMoney did not get build with AqBanking support. If built in, you should see "File/Import/AqBanking Importer" and "Settings/Configure AqBanking". If both of them are missing, it was not build with AqBanking support. 

There is an external source provided by one of the devs that builds KMyMoney with AqBanking support for Windows. You may try it out. See https://kmymoney.org/snapshots.php

To answer Martin's question: no, we don't package the binaries, only the libs.