OFX Import Bug

Brendan Coupe brendan at coupeware.com
Tue Jan 10 20:18:32 UTC 2017


Your suggestion is fine for testing but a non-starter for day to day use of
KMM. I can live with bogus warnings about my account balance not matching
the download balance.

I downloaded both the OFX and QFX files from both banks. I diff'ed them and
they are pretty similar (OFX vs QFX).

The formats are completely different from the files that are saved in the
/home/thb folder which have the extension "txt" so they may not be copies
of the downloaded OFX files.

Is there an easy way to find the OFX files downloaded when they are
downloaded from KMM?

There is possible good news and bad news. The bank that shows 1969-12-31
has the correct date in the manually downloaded OFX & QFX files.


The bank that appears to use the date prior to the last transaction date
(based on 2 recent downloads) shows an end date in 2014.


Very strange.

I have tried several options for "Identify as" and "Header Version" and the
txt file that appears in the /home/thb folder is the same.


On Tue, Jan 10, 2017 at 7:38 AM, Jack <ostroffjh at users.sourceforge.net>

> On 2017.01.09 23:24, Brendan Coupe wrote:
>> I'm having a problem with 2 accounts when I import the OFX using online
>> banking.
>> One account shows the Online Statement Balance on 12/31/1969.
>> Another account shows the Online Statement Balance on 1/3/2017 while the
>> most recent transaction is on 1/4/2017 and I just downloaded it today
>> (1/9/2017).
>> Not surprisingly when I checked the OXF files for the respective accounts
>> I
>> found the following (/home/thb comes to the rescue again):
>> ...begindate="2016-10-11" enddate="1969-12-31"...
>> ...begindate="2016-12-09" enddate="2017-01-03"...
>> I'm almost certain I will not have much luck getting the banks to fix
>> this.
>> Is it possible to have KMM use the current download date when the date in
>> the OFX file does not make sense? KMM could also use the latest date of a
>> transaction in the OFX file when it's later then the "enddate".
>> At the very least it should recognize a problem since the enddate is
>> before
>> the begindate at the first bank.
>> I did check a different bank at it uses today's date as the enddate.
>> *----Brendan*
> One thing you might try is to manually download an OFX file.  I have oddly
> found that it can differ from what gets downloaded by direct connect.  Even
> if it doesn't, you can manuallyl correct the end date if it's still wrong.
> Not a good long term solution, but a temporary workaround.
> Jack
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/kmymoney-devel/attachments/20170110/3f4f3497/attachment.html>

More information about the KMyMoney-devel mailing list