Reply to topic

Banque Balance / Ledger Balance Amount

johnguicar
Registered Member
Posts
33
Karma
0
Hello,

I'm also using Skrooge for market share, life insurance or Sicav. With such account it's sometime difficult to manage records provided by banks like financial costs taken by banks for example. This costs are not signed negatively so the balance in Skrooge is not as same as the bank one (ie: Frais financiers = 1000 € instead of -1000 €).
Some other operation like "arbitrage" should be be taken as information even it is a positive amount.
I'm using Weboob in order to retrieve accounts and bank ledger balance amount is recorded in the ofx file.

So my wishes would be to import this bank balance amount in Skrooge for two purpose:
1/ To check the Skrooge computed balance amount with the one provided by the bank to be sure there is no mistake somewhere
2/ To choose the value to be displayed in summary account (s) or detailed operations

Any input is most welcome, and thank's again for this powerful tool,
Regards,
User avatar smankowski
Moderator
Posts
872
Karma
7
OS
johnguicar wrote:Hello,

I'm also using Skrooge for market share, life insurance or Sicav. With such account it's sometime difficult to manage records provided by banks like financial costs taken by banks for example. This costs are not signed negatively so the balance in Skrooge is not as same as the bank one (ie: Frais financiers = 1000 € instead of -1000 €).
Some other operation like "arbitrage" should be be taken as information even it is a positive amount.
I'm using Weboob in order to retrieve accounts and bank ledger balance amount is recorded in the ofx file.

I don't understand.
Do you let Skrooge use Weboob to download operations?
Or do you download ofx file with Weboob and import them in Skrooge?
If you do the second option, I recommend you the first one.
johnguicar wrote:
So my wishes would be to import this bank balance amount in Skrooge for two purpose:
1/ To check the Skrooge computed balance amount with the one provided by the bank to be sure there is no mistake somewhere
2/ To choose the value to be displayed in summary account (s) or detailed operations

Any input is most welcome, and thank's again for this powerful tool,
Regards,

Of course, this should be imported correctly.
Could you provide me a sample of csv file obtained with boobank for test with the current result if imported and the expected one?

If you speak french, we can exchange in french by mail. You can find my email in the "About" of Skrooge.
Regards.


Skrooge, a personal finances manager powered by KDE
Image
johnguicar
Registered Member
Posts
33
Karma
0
Reponse pas mail envoyée le 28/08

Bonjour Stéphane,

Désolé de ne pas avoir été très clair en Anglais... Essayons de voir ce que cela donne en Français.

Je récupère mes comptes bancaires avec Weboob que j'importe ensuite dans skrooge. Le fichier Ofx contient tous les enregistrements ainsi que le solde du compte.Je n'utilise pas l'import direct, en fait je ne sais plus comment faire mais je me souviens avoir eu des problèmes de doublon avec certaines banques. L'import " à la main" mes permet de sélectionner des dates, le nombre d'enregistrement et d’être sur de l'unicité via mes tags ofx.

Mon souci:

Dans l'exemple ci dessous on distingue des FRAIS MENSUELS DE GESTION ou des ARBITRAGES.

Les frais sont prélevés par la banques mais le nombre n'est pas signé négativement. L'arbitrage est en fait un changement de support d'investissement pour un montant donné (ici 5000.00 €).

La valeur du portefeuille n'est pas arithmétiquement liée aux opérations mais plutôt au cours de des sicav,fcp.. qui le compose.

Skrooge fait la somme arithmétique des opérations pour calculer le solde du compte.

Mon souhait serait de pouvoir afficher dans skrooge le solde bancaire présent dans le fichier ofx

<DTASOF>20180827
</LEDGERBAL>
<AVAILBAL><BALAMT>12345.67
<DTASOF>20180827</AVAILBAL>
</STMTRS></STMTTRNRS></BANKMSGSRSV1></OFX

Cela permettrait aussi de savoir en comparant le solde bancaire et le solde Skrooge si des erreurs se sont glissées quelque part.

Extrait:

<NAME>FRAIS MENSUELS DE GESTION
</STMTTRN>
<STMTTRN>
<TRNTYPE>FEE
<DTPOSTED>20180630
<DTUSER>20180630
<TRNAMT>12.86
<FITID>c5b12622
<NAME>FRAIS MENSUELS DE GESTION
</STMTTRN>
<STMTTRN>
<TRNTYPE>FEE
<DTPOSTED>20180531
<DTUSER>20180531
<TRNAMT>13.25
<FITID>281ae97d
<NAME>FRAIS MENSUELS DE GESTION
</STMTTRN>
<STMTTRN>
<TRNTYPE>FEE
<DTPOSTED>20180430
<DTUSER>20180430
<TRNAMT>12.66
<FITID>f26e0f03
<NAME>FRAIS MENSUELS DE GESTION
</STMTTRN>
<STMTTRN>
<TRNTYPE>FEE
<DTPOSTED>20180331
<DTUSER>20180331
<TRNAMT>12.67
<FITID>e41bf6c7
<NAME>FRAIS MENSUELS DE GESTION
</STMTTRN>
<STMTTRN>
<TRNTYPE>FEE
<DTPOSTED>20180228
<DTUSER>20180228
<TRNAMT>4.48
<FITID>3569bae0
<NAME>FRAIS MENSUELS DE GESTION
</STMTTRN>
<STMTTRN>
<TRNTYPE>FEE
<DTPOSTED>20180226
<DTUSER>20180226
<TRNAMT>5000.00
<FITID>00c37e50
<NAME>ARBITRAGE
</STMTTRN>
<STMTTRN>
<TRNTYPE>FEE
<DTPOSTED>20180219
<DTUSER>20180219
<TRNAMT>5000.00
<FITID>2cc790e7
<NAME>ARBITRAGE
</STMTTRN>
<STMTTRN>
<TRNTYPE>FEE
<DTPOSTED>20180212

J’espère que cela explicite un peu mieux mon propos.

Grand merci,

Jean-Pierre.
User avatar smankowski
Moderator
Posts
872
Karma
7
OS
I did a correction.
You can test it if you know how to build Skrooge from GIT.
Regards.


Skrooge, a personal finances manager powered by KDE
Image

 
Reply to topic

Bookmarks



Who is online

Registered users: avidscavenger, Baidu [Spider], Bing [Bot], cylverbak, Exabot [Bot], glenl, Google [Bot], thunder422, weegie, Yahoo [Bot]