Problem importing Payee transactions with same 3 char names

When I do an Import from my Chase bank to get my bill paid transactions, I've discovered an anomoly with respect to the names of the payees, which in turn, become part of the budget and Categories.

It appears - from viewing my Quicken program file information - that Chase Bank is sending the transactions, but with only the FIRST THREE CHARS of the Payee name, and the rest of the name is contained in the "Memo" field. 

This is also what I am seeing in my YNAB imported data.  The problem arises when two (or more) Payees have the same beginning 3 chars.  It looks like the 1st alpha sorted entry gets the "COM" transaction category.

I then have to look at the "Memo" field to tell which Payee it is, and manually Edit the transaction and type in the correct Category.

- COM-CAST CABLE
- COM-MONWEALTH EDISON (ComEd)

Below is copied from my Quicken program download -

<STMTTRN>
<TRNTYPE>PAYMENT
<DTPOSTED>20180924120000[0:GMT]<TRNAMT>-135.97<FITID>20180924
<NAME>Online Payment 7777177777 To COM<MEMO>CAST CABLE - XFINITY
</STMTTRN>

1reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Hi ps56k !

    Sorry for the trouble - that's definitely odd! If you're noticing this issue on the file provided by your bank, this is a change caused by Chase directly. Since our Direct Import partner pulls the information from the file they provide, Chase would need to correct this issue or the file would need to be edited before being imported. Did Chase offer any information on the recent file format change?

    Like
Like Follow
  • 2 yrs agoLast active
  • 1Replies
  • 164Views
  • 2 Following