Citi Credit Card OFX Import Nightmare

[Brendan Coupe]

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?
>
> -------------------------------------------------------------
>
>