Chase and CATEGORY in ofx

[Bob Ewart]

On 09/27/2016 01:07 PM, Jack wrote:
> On 2016.09.27 12:10, Thomas Baumgart wrote:
>> On Monday 26 September 2016 17:31:11 Bob Ewart wrote:
>>
>>> Interesting problem with Chase credit card downloads.  They now have 
>>> transactions looking like this:
>> >
>> > <STMTTRN>
>> > <TRNTYPE>DEBIT
>> > <DTPOSTED>201609...
>> > <TRNAMT>-nn.nn
>> > <FITID>201609...
>> > <NAME>AMAZON MKTPLACE PMTS
>> > <CATEGORY>
>> > <MEMO>null
>> > </STMTTRN>
>> >
>>> KMyMoney sets the payee to 'null' or whatever is in the <MEMO> field 
>>> instead of the <NAME> when you import a downloaded .ofx file.
> I also got bit by this a week or so ago.  It is not the main reason, 
> but does support my choice to dump the Chase card.  They have been 
> less than supportive of using anything except that commercial 
> product.  If anyone does know of any credit card which is supportive 
> of or at least not hostile to open source software, please speak up.
>>
>> Did you know, that KMyMoney allows you to select from which field of 
>> the OFX file to extract the name on a per account basis? It should be 
>> in the "Edit account/Online settings" tab IIRC. If you don't find it, 
>> I have to setup an OFX account here to see where it is.
> It seems this option is only present if you map to an online account 
> with KMM OFX (libofx) and it does not show up with 
> KBanking/aqbanking.  If the account is mapped, go to Edit/Account, 
> select the Online Settings tab and the Import Details subtab.  The 
> choices for "Payee's name is based on contents of the OFX tag" are 
> PAYEEID, NAME, and MEMO.
>
> I know this has come up before, but I'll have to check whether there 
> is already a wishlist filed to have this option available either as an 
> overall setting for OFX imports or for each account even if not mapped 
> online.
>
>> > Before they inserted the <CATEGORY> line, everything worked as it 
>> should
>> >
>> > I'm using 4.8.0 and downloading the .ofx files rather than trying 
>> to to
>> > an online update
>
> Jack
>
Thanks for addingit to the wish list,369438 
<https://bugs.kde.org/show_bug.cgi?id=369438>. I've wanted it for a long 
time.  Merrill Lynch has the name and memo fields reversed.

I wrote a little perl program to switch the name and memo fields and to 
rename the files into a yyyy-mm... format so they sort properly in 
Dolphin.  Later I added code to handle the dividendreinvestment problem 
which nobody seems to know how to handle.

So it was no problem to write one for Chase. I got a Chase card from 
Amazon which saves the points and subtracts the points from future 
Amazon purchases.  Chase reports the charges to 'Amazon.com' or 'AMAZON 
MKTPLACE PMTS' which is not very helpful when trying to match the 
payments against purchases.  Especially when one Amazon purchase number 
can contain a mixture of both of them.

I have a database program which tracks all of my online purchases, 
Amazonand others.  It shows when I ordered something, when it was 
shipped and by whom and when I received it.  It will also show the 
tracking information even those coming from China.  My Chase program 
matches the items ordered against the Chase charges and puts the item 
descriptions in the memo fieldof the ofx file. That allows me to assign 
the charge to the proper category in KMM.

I just added 36 <https://bugs.kde.org/show_bug.cgi?id=369449>9449 
<https://bugs.kde.org/show_bug.cgi?id=369449> to the bug liston payee 
switch caused by <CATEGORY>

Bob