Citi Credit Card OFX Import Nightmare

[Brendan Coupe]

I do not get a choice for matching when I open the OFX file directly
from Firefox. This combined with KMM not remembering which method I'm
using for each account means I have to save the file when open it from
KMM and remember to switch to the hash option. Not as easy as when
direct connect worked:-(

If there was a way to set the matching method for each account even
when they are not mapped to an online account it would help. Since
this setting is on the Online Settings tab which is not visible when
the account is not mapped it would have to be handled differently for
unmapped accounts.

Maybe show the Online settings tab with the three tabs for all
accounts and disable everything but the bottom half of the Import
Details sub tab when it's not mapped. All three "Import options" are
useful for manual imports.

----
Brendan Coupe

On Mon, Apr 8, 2019 at 10:18 AM Brendan Coupe <brendan at coupeware.com> wrote:
>
> I'm close to the end of the statement period which means by default I
> get a lot of transactions that I'd have to rematch. Instead I
> simulated the different FITID numbers for a few recent transactions in
> 2 different QFX files and it worked fine.
>
> My concern is remembering which method is used on each account.
> Setting the default for accounts with direct connect would not help
> with the accounts that I have to import manually so I'm not sure how
> to do this. Is there any way to autodetect transactions that used the
> hash in an account? I don't see anything in the kmy file that makes it
> obvious how the hash works.
>
> I will test this in more detail once the new statement period starts
> in the coming week.
>
> Changing the matching to the hash option on my investment account does
> not help. Thomas, please remind me how to keep the direct connect OFX
> file around so I can try to figure out what is going wrong there. This
> is a new issue so the bank probably changed something.
>
> I've noticed something odd while constantly matching transactions. If
> I match 2 transactions that have nothing set for the reconcile state
> (neither has been marked cleared) the resulting transaction is marked
> cleared. Not sure if this is intended or if there is a setting I'm
> missing to stop this from happening. I don't think this was the
> behavior in KMM 4.8.
>
> ----
> Brendan Coupe
>
>
> On Sun, Apr 7, 2019 at 1:25 AM Thomas Baumgart <thb at net-bembel.de> wrote:
> >
> > On Sonntag, 31. März 2019 20:08:41 CEST Brendan Coupe wrote:
> >
> >
> >
> > > Running this command on the QFX (probably OFX) file zeros out the last
> >
> > > 4 digits of the FITID value.
> >
> > >
> >
> > > sed -ri 's/(\<FITID\>.*)[0-9][0-9][0-9][0-9]/\10000/' CitiVisa.qfx
> >
> > >
> >
> > > When importing nothing matches so I deleted the old transactions in
> >
> > > KMM and hopefully this will prevent future duplication. Not sure if
> >
> > > duplicate FITID numbers will cause any other issues since all
> >
> > > transactions that happen on the same date now have the same FITID
> >
> > > number.
> >
> > >
> >
> > > I have always had a similar problem with one of my investment banks
> >
> > > and now it's happening with the other one. Since they use direct
> >
> > > connect it's not as easy to fix. Shortening the download period to 3
> >
> > > days helps but it also means I can easily miss transactions.
> >
> > >
> >
> > > Thomas, please remind my how to save the ofx file that is downloaded
> >
> > > with direct connect in KMM 5. I want to compare the files to see if
> >
> > > it's the same issue.
> >
> >
> >
> > I just added a new method which replaces the usage of the FITID for those banks that screw up on its generation. It is available in both, the master and the 5.0 branch. Would be cool if you can give it a try and report back.
> >
> >
> >
> > Hopefully, this helps to solve your serious problems.
> >
> >
> >
> > --
> >
> >
> >
> > Regards
> >
> >
> >
> > Thomas Baumgart
> >
> >
> >
> > https://www.signal.org/ Signal, the better WhatsApp
> >
> > -------------------------------------------------------------
> >
> > In a world without walls and fences,
> >
> > who needs windows and gates?
> >
> > -------------------------------------------------------------
> >
> >