[GNC] aqbanking import mapping to GnuCash

Jan Vlug jan.public at famvlug.nl
Wed Jul 10 09:49:39 EDT 2024


Hello,

I want to import bank statements via the AqBanking import menu in GnuCash.

However, I do not get a description in GnuCash for the imported statements.

Here is a redacted and shortened example of the output of AqBanking:

accountInfoList {
   accountInfo {
     char accountNumber="NL98ASNB1111111111"
     char iban="NL98ASNB1111111111"
     char currency="EUR"
     int  accountType="0"
     int  accountId="0"

     balanceList {
       balance {
         char date="20240401"
         char value="<redacted>"
         char type="unknown"
       } #balance

       balance {
         char date="20240630"
         char value="<redacted>"
         char type="booked"
       } #balance
     } #balanceList

     transactionList {
       transaction {
         char type="statement"
         char subType="none"
         char command="none"
         char status="unknown"
         int  uniqueAccountId="0"
         char acknowledge="never"
         int  uniqueId="0"
         int  refUniqueId="0"
         int  idForApplication="0"
         int  sessionId="0"
         int  groupId="0"
         char localIban="NL98ASNB1111111111"
         char date="20240402"
         char valutaDate="20240402"
         char value="-238%2F100%3AEUR"
         int  transactionCode="0"
         char transactionKey="PMNT-CCRD-POSD"
         int  textKey="0"
         char purpose="R BEATRIXPARK 3312 %3E%27S-GRAVEN 2.04.2024 9U58 
KV006 CD21T2 MCC%3A5811 Contactloze betaling NLNEDERLAND"
         char sequence="unknown"
         char charge="unknown"
         char period="unknown"
         int  cycle="0"
         int  executionDay="0"
         int  estatementNumber="0"
         int  estatementMaxEntries="0"
       } #transaction
     } #transactionList

     eStatementList {
     } #eStatementList
   } #accountInfo
} #accountInfoList

securityList {
} #securityList

messageList {
} #messageList


I would expect that the AqBanking purpose would be used as the 
description in GnuCash, but this seems not to happen.

Where is the mapping from AqBanking to GnuCash done? Is there a mapping 
table or something like that?

Should I create a bug in the Bugzilla of GnuCash with the request to fix 
this, or is the current behavior wanted?

If wanted, I can provide example exports files of the bank statements.

I'm using: camt.053.001.02

Kind regards,

Jan Vlug.


More information about the gnucash-user mailing list