Bug 429431 - Wrong ofx bank imported balance
Summary: Wrong ofx bank imported balance
Status: RESOLVED NOT A BUG
Alias: None
Product: skrooge
Classification: Applications
Component: general (show other bugs)
Version: 2.21.0
Platform: Other Linux
: NOR normal
Target Milestone: 25.1.0
Assignee: Guillaume DE BURE
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-11-21 08:55 UTC by forum@guicar.fr
Modified: 2020-11-29 12:22 UTC (History)
1 user (show)

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


Attachments
ImportMessage ScreenShot (36.00 KB, image/png)
2020-11-25 06:17 UTC, forum@guicar.fr
Details

Note You need to log in before you can comment on or make changes to this bug.
Description forum@guicar.fr 2020-11-21 08:55:47 UTC
Hello,

I'm importing several bank account using ofx format but with Fortuneo, Skrooge interface show me a wrong number in "Balance Importation" column for this account.It's ok for all other banks ofx imported balances.

Here an extract of ofx file:

<LEDGERBAL><BALAMT>7657.25
<DTASOF>20201121
</LEDGERBAL>
<AVAILBAL><BALAMT>1234.56
<DTASOF>20201121</AVAILBAL>
</STMTRS></STMTTRNRS></BANKMSGSRSV1></OFX>

Everything seems to be ok comparing to others bank ofx import files.

Thank you,

STEPS TO REPRODUCE
1. 
2. 
3. 

OBSERVED RESULT


EXPECTED RESULT


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

ADDITIONAL INFORMATION
Comment 1 Stephane MANKOWSKI 2020-11-24 21:02:10 UTC
Could you provide me a sample file to reproduce the error?
Comment 2 forum@guicar.fr 2020-11-25 06:17:10 UTC
Created attachment 133625 [details]
ImportMessage ScreenShot
Comment 3 Stephane MANKOWSKI 2020-11-25 19:31:08 UTC
Hi,

I need an ofx sample file. Not a screenshot.

But, in you screenshot, I can see that:
- Skrooge doesn't set the initial balance of the account because the target account is not empty. This is normal.
- After importing the operation the final balances (the oxf file one and the skrooge one) are not aligned.

This can occurs if:
1- Some operations are missing in your ofx file
2- You removed some operation in skrooge

Regards.
Comment 4 forum@guicar.fr 2020-11-25 21:27:08 UTC
It's seem that my previous message wasn't fully sent, sorry for that.

I have noticed if I import twice the same Ofx file then the second import give me the right number in "balance d'importation". Same issue/fix for all accounts.
I'm quite reluctant to send my ofx file ... but seems not be related as the second import is good.
I'm using boobank history 123456789@fortuneo -f ofx --count=1000 > /home/jpm/Téléchargements/Banks/fortuneo.ofx in order to download bank accounts.

Thank you very much for your kind help.
Regards,
Comment 5 Stephane MANKOWSKI 2020-11-27 13:51:41 UTC
Hi,

Happy to see that you find a fix.
But, if you ara weboob user, why you don't use the "Import by backend"?
Indeed "Import by backend" is able to call boobank direcly and to import all needed operations in one click.

In you case, this seems to be the best solution even if you can have some duplicated operations at the first import due to changing IDs.
Comment 6 forum@guicar.fr 2020-11-28 14:43:38 UTC
Hello Stephane,

Thank for your comment regarding import. I've tried this feature long time ago but wasn't working...and the good new is it's now works! So I'll use it. Is there a Skrooge log file when things goes wrong with boobank import because this happen quite often as banks change web site content or after 90 days when two factor authentication is over.

Regards,
Comment 7 forum@guicar.fr 2020-11-29 09:36:50 UTC
Update...
I downloaded operation using Skrooge external import but I'm facing with a lot of duplicate operations depending how long banks store information (up to 1 year).
Skrooge have a nice tool to find duplicate but you can make a lot of errors when you have hundred reconciliations. I have operations dates are sometime not the same even there is no day off like saturday or sunday enclosing an operation.Operation description can slightly vary also.
So nice to now if there is a way to limit number of downloaded operations in order to "time limit" this number. Boobank use --count to do this. May be Skrooge import is using a Python or other file I can modify.

Thank you
Comment 8 forum@guicar.fr 2020-11-29 12:22:15 UTC
Update 2

Found it ... need to use weboob(,2020-11-01)in import/export setup parameters.Pay attention to not put space between weboob and parenthesis.So I got operations from only November 1.
Great feature, Skrooge is very well designed !