Which information should i ask to my bank to synchronize bank account and KMyMoney?

Hello,

I know this list of banks https://www.aquamaniac.de/rdm/projects/aqbanking/wiki/AqBanking6_Bankentabelle which shows the technical connection details to enter into AqBanking plugin of KMymoney

Unfortunately i am looking for the French bank Boursorama, which is not on the list.

From the online bank i can download the transactions in these formats:

  • Microsoft Money
  • Quicken
  • Quicken 2000
  • Microsoft Excel

Which information should i ask to my bank to synchronize my bank account and KMyMoney?
For example i see in the official help :

OFX Direct Connect is now supported in KMyMoney. This gives KMyMoney the ability to contact your bank directly to obtain transaction

That is great. However i miss here the list of details which i must get from my bank, when i write to the customer support.

EDIT: i have read the help more in details and found this: w w w. ofxhome. com /index.php/home/add (i had to broke the URL string since i am allowed to maximal two web links for each post…)
Does it mean i should ask this to the bank?

  • Insitution Name *
  • FI Id *
  • FI Org *
  • FI URL *
  • FI Broker Id
  • FI Bank Id

(* = required)

And if yes, how should the bank understand what FI means?

Many thanks for your help in advance.

FI is financial institution. Someone at the bank understands that, but not likely first tier customer support.
When mapping a KMM account to an online institution using OFX, KMM downloads a list of institutions with known capability to do so. Boursarama is not on that list, so it is unlikely they support what is called OFX Direct Connect. Your best bet is most likely to be to download the transactions for Quicken, and configure your browser to open KMyMoney for files of that type. (That file is likely to end in .qfx rather than .ofx, but that is just Quicken’s version, and it can be processed in the same way. Otherwise, you can just download that file and then open it with the File/Import/OFX menu item.
You can ask the bank if they do support OFX direct connect, but they are extremely unlikely to have even heard of it. In the past, if they supported downloading transactions to Quicken, it was sometimes possible to find the right data to configure OFX, but the bank would rarely provide that information, and tell you to get support from Intuit. Making things worse for us, Quicken now uses a different method, with all the data actually going from the bank first to a third party aggregator, and then to you. KMM does not deal with that data flow.

Looking for “boursorama ofx” on the intrawebs, I found this forum page. My french is a bit rusty these days (even though I try hard to keep it in shape), but to me the statment

Aucune banque ne propose plus le téléchargement direct OFX en France donc il faut passer par le navigateur intégré ou Linxo.

sounds that banks don’t provide OFX access anymore but want you to use a browser or the 3rd party provider Linxo. (My interpretation without asking e.g. deepl :smiley:)

The mentioned AqBanking page only shows banks providing HBCI (Home Banking Computer Interface) which is a specific online protocol and to my knowledge used in Germany only. So you won’t be able to find any French banks on this page.

Please also be ware of the fact, that OFX support in KMyMoney can be accomplished in two different ways:

  1. Using KMyMoney’s OFX download implementation (does not support issuing transfers) and
  2. AqBanking’s OFX implementation available through the KBanking plugin (the same that you can use for HBCI). I have no idea if issuing transfers is support that way. Something that can be answered by their developers. AqBanking is also using in GnuCash.

@ostroffjh was referring to 1. when he was describing the mapping of a KMyMoney account in the previous post. Just want to make sure that you are not confused when looking at the instructions above for 1. and seeing the AqBanking dialog 2. in front of you.

I understand.
Thank you for the advices regarding downloading from the bank online account into Quicken format.

The banks currently offering an OFX direct connection had also their “first day” offering it, and before this day they were not offering it. I know i may be naive, but what about asking banks to join this OFX stuff? If i don’t ask because i suppose they will say no, the banks will for sure never say yes :slight_smile:
Or how did the current banks offering OFX direct connect took their decision? Do they have maybe an own interest to offer it? Do they come from a specific interest group or geographical unit?

I doubt many (if any) banks (especially in the United States) ever really offered OFX direct connect on their own. The had Intuit provide the service for them, and as long as that software followed the OFX standard, other software could also use it. However, if you ever called the bank for assistance, they would usually tell you to call Intuit. If you admitted you were using software other than Quicken, they would tell you is is not supported. The recent change to using aggregators is being done in the name of improved security. (The skeptical among us might say it’s for Intuit’s financial security.) That works fine if you are already paying for Quicken and have already accepted that Intuit has access to your financial records. The banks will not change until there are a LOT more people insisting they support Free/Libre Open Source Software, which doesn’t seem highly likely.

It certainly won’t hurt for you to ask your bank, but I strongly suspect it will be a frustrating experience.

1 Like

Hi

There are no more french bank supporting ofx Direct link.
I think last one providing this service was LaBanque Postale, and they stopped 10 years ago.

For Boursorama, you should perform this in 2 manual steps

  • Log in your Boursorama online account, then export transactions in Quicken (QIF) format
  • Perform import of QIF file in KMymoney (Menu File/import/QIF …)

Yes this is manual, but takes only a few clics, not a big story if you do it once per week or per month.

If you really want automated & real time import, you will have to implement & configure WooB plugin in KMM. You will need also to install WooB in windows. This is not straigthforward, but was working for me

Woob has recently been discussed at 473522 – Description of woob import. It turns out woob is not enabled in the Windows release version of KMyMoney, but it is enabled in the dailly builds at Artifacts of KMyMoney_Release_win64 #1875 : / [Jenkins]. @gnull if you can document the process you took to get woob working with KMyMoney on Windows, I’ll be happy to include that information in the handbook for future reference.
Using downloaded files, you can eliminate the second step gnull lists by configuring your browser to open the downloaded file in KMyMoney. The process is called Web Connect, and while it will work with qif files, ofx (or qfx) are preferred if they are available.

thank you @ostroffjh and @gnull for your answers.

So regarding Boursorama, i will have to stick to asynchronous download of transactions into KMyMoney using the .QIF file format. It is desappointing since this format only provide three columns for each transaction:

  • date
  • Amount
  • Text

This is quite poor… although the bank should now the payee of each transaction, it is not able to put it in a clean column :grimacing: I know KMyMoney is able to “wrangle” through the text field to get some kind of payee information, but it is still disappointing compared to a clean dedicated column…

Regarding the option to use woob, i saw this from @gnull on the old forum: Woob plugin not able to interact with KMM for online account • KDE Community Forums

on a more general perspective, if most of banks are not interested in letting us making “direct connect” and download (through protocols or format like OFX, HBCI etc.) of transactions, why do a few big German banks do it for HBCI protocol (according to this list)?
to compare FR and DE for example, does anyone know why the FR side seems to have nothing in comparison to the DE side?
I am curious to know the reasons behind these different approaches.

@ostroffjh
Unfortunately, I will not be able to document right now how I succeeded to have Woob working with KMM.
I had managed to do this Q1 2023, but since that moment I moved to another PC, doing scratch installation of W10 and of course KMM.
In my new KMM setup, WooB is working in cli , but not working under KMM.
To be noted that I am currently using KMM downloaded from [CI build pipeline], version 5.1.3-33a66be8a, and despite I see WooB in list of enabled plugins, I do not see anymore “Woob” option while trying to map an account with Online Account.
Could be maybe a regression vs version I was using in Q1 2023, and sorry I can not be more precise about version I was using.
Anyway, I will keep fighting to have WooB working under KMM, and of course if I can manage to have it working again I will indicate how I did.

@surcouf
The limitations you mentioned "It is desappointing since this format only provide three columns for each transaction "are not related to KMM.
They are related to banks who are not providing OFX exports or are providing limited QIF exports. So here as we are in a KMM forum, you will have no answer on this point.

“does anyone know why the FR side seems to have nothing in comparison to the DE side”
My idea is that legacy french banks do not want to ease competition from new fintech’s, then they do not facilitate exports outside of their systems. The client financial data is “gold”, legacy banks do not want to share this gold.

As an example if you want to use the internal aggregator “Wicount” system from Boursorama you will see how easy it is to connect to other banks, Boursorama purpose being to know which financial assets you have anywhere else …

But allowing you to export your data, there are no reason to make it too easy :wink:

I know. I was not complaining about KMM.
I totally agree with you, Boursorama makes a fool of us. They let very poor data export options for the person who creates the data (the customer) :person_facepalming: but on the other hand offers a very handy interface for the customer to connect his non-boursorama bank accounts to his boursorama bank account, so that he can make 360° analysis on all his accounts :clap: :

To synchronize your bank account with KMyMoney, you should ask your bank for the following information:
  1. Online Banking Protocol Support: Confirm if your bank supports protocols like OFX (Open Financial Exchange) or HBCI (Home Banking Computer Interface), which are compatible with KMyMoney.
  2. Server Details: Request the server address, port number, and institution ID required to set up the connection within KMyMoney.
  3. Login Credentials: Ensure you have the necessary online banking credentials, such as user IDs, passwords, or any unique tokens needed for secure access.
  4. Security Certificates: Ask if you need specific SSL certificates or encryption methods for a secure connection.
    Gathering this information will help you seamlessly integrate your bank account with KMyMoney. Just like i saved on travel insurance while planning my German adventure, having the correct details ahead of time can make the process smoother and more cost-effective.