Chase Amazon Download Error

[Chad Carlson]

I've been downloading my Visa Chase Amazon transactions into Microsoft Money for years. As of October 5th, I can't and get this error message:

"The file you attempted to import appears to be invalid or contains corrupt data. Please download the file again. If this problem continues, contact your financial institution."

I've tried multiple things to fix it, including:

• Starting a new file and dowloading the transactions
• Downloading a completely new version of the sunset download
• Archiving a portion of the file so it's not as large. (never able to fully accomplish this as it would time out.)

Is anyone else seeing this or can offer some help?

Thank you,

Chad

[Tom Roberts]

One option is to check if you can download in csv format. If you can, you can use something like xl2qif to convert it. See my earlier post today on xl2qif. It uses office 365 to convert the csv file.

--
You received this message because you are subscribed to the Google Groups "Microsoft Money" group.
To unsubscribe from this group and stop receiving emails from it, send an email to microsoft-mon...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/microsoft-money/7be3fd16-5c4b-4d70-8593-d3ffdfa2ea93n%40googlegroups.com.

[joe dempsey]

You need to look into the file you downloaded to see what is the problem

What format is the file you have downloaded -qif, ofx, csv,... other?

[Robert Jacobson (bobjbkln)]

I am having the same problem.  The file is a qfx file which used to import fine.  I don't have time tonight  but tomorrow I will run it through OFXanalyzer and report the error it shows.

[Chad Carlson]

I'm downloading the .QFX file. Have been for years. I've tried to compare files of old and new and don't see a difference.

Chad

--
You received this message because you are subscribed to a topic in the Google Groups "Microsoft Money" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/microsoft-money/9go1SooRJpE/unsubscribe.
To unsubscribe from this group and all its topics, send an email to microsoft-mon...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/microsoft-money/85878eab-e5f6-42a4-9a50-88f125231243n%40googlegroups.com.

[Chad Carlson]

I was hoping to find the problem so we wouldn't have to go through this conversion all the time. I typically download the file daily during the work week.

I called Chase Amazon online customer support and they were of no help.

[Chad Carlson]

I've also tried downloading the .QIF file from Chase and it doesn't work.

[Matt Petersen]

For whatever reason, it's missing the account id.

If you add the line:

<ACCTID>1234567890123456

with your 16 digit credit card number between the two red lines, it will work.

I bet you Chase fixes it before too long.

OFXHEADER:100
DATA:OFXSGML
VERSION:102
SECURITY:NONE
ENCODING:USASCII
CHARSET:1252
COMPRESSION:NONE
OLDFILEUID:NONE
NEWFILEUID:NONE
<OFX>
<SIGNONMSGSRSV1>
<SONRS>
<STATUS>
<CODE>0
<SEVERITY>INFO
</STATUS>
<DTSERVER>20231012120000[0:GMT]
<LANGUAGE>ENG
<FI>
<ORG>B1
<FID>10898
</FI>
<INTU.BID>10898
</SONRS>
</SIGNONMSGSRSV1>
<CREDITCARDMSGSRSV1>
<CCSTMTTRNRS>
<TRNUID>1
<STATUS>
<CODE>0
<SEVERITY>INFO
<MESSAGE>Success
</STATUS>
<CCSTMTRS>
<CURDEF>USD
<CCACCTFROM>
</CCACCTFROM>
<BANKTRANLIST>
<DTSTART>20231012120000[0:GMT]
<DTEND>20231012120000[0:GMT]
<STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20231011120000[0:GMT]

[Tom Roberts]

good detective work

To view this discussion on the web visit https://groups.google.com/d/msgid/microsoft-money/0865b2f4-8f04-4173-9678-f5a18a4b3d63n%40googlegroups.com.

[Chad Carlson]

GENIUS!!!

It worked! Thank you very much!!!!!!

Hopefully, they get it fixed on their end. I have a scheduled call with them tomorrow so will tell them what is wrong and hopefully the fix will get implemented.

This forum has been helpful. I would interested to know how many people are still using MS Money. It's been 'dead' for a long time now, but we live by it for our finances.

Chad

You received this message because you are subscribed to a topic in the Google Groups "Microsoft Money" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/microsoft-money/9go1SooRJpE/unsubscribe.
To unsubscribe from this group and all its topics, send an email to microsoft-mon...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/microsoft-money/CAEDzrA9o_HX%3Dtr1DffbydThf%3DwoaMkLNN%2B4zjdH3-ShbsqGzDg%40mail.gmail.com.

[Robert Jacobson (bobjbkln)]

I just tried the fix with my bank based Chase Credit Card and it worked.  Thank you matt_p...

If I remember correctly the account number used to be included in the name of the .QFX filename.  But now it's not there anymore.  Let's hope they fix it soon. If the acc't number reappears back in the filename, it will most likely be fixed.

[Chad Carlson]

I confirmed with an old download file (2 weeks ago) and the current download file that the credit card number used to be there.

I have a scheduled call with them at 2 p.m. today, and I'll share what we found. Hopefully, they take action on it.

Great work on the find Matt!

Chad

To view this discussion on the web visit https://groups.google.com/d/msgid/microsoft-money/faa6ffab-ca78-4ab6-bfed-e1c2d990e2c2n%40googlegroups.com.

[Matt Petersen]

As predicted, it looks like Chase has now fixed the problem.

[Robert Jacobson (bobjbkln)]

So far my CC account with Chase Bank (not through Amazon) is still missing the account number in QFX file although the last 4 digits of my CC account number has reappeared in the filename.  I'll see if it's fixed over the weekend.

[Chad Carlson]

Still not working for me either. I had a 30 minute call with Chase yesterday and pointed out the problem. A case was created and they were going to look into it.

To view this discussion on the web visit https://groups.google.com/d/msgid/microsoft-money/d31abca8-de22-4201-868b-889e82aa52a1n%40googlegroups.com.

[First Name Last Name]

Just came back from vacation and I am seeing the same kind of error for my Chase CC (missing ACCTID value).

Here is a python script to fix the Chase bad *.qfx file by inserting the missing line 

Save the attached fixChase.py file into a directory of your choice.

-----

Install and setup

Make sure you have Python installed. If you are using Python 2.x, please make sure you have the latest 2.x series at version 2.7.18

https://www.python.org/ftp/python/2.7.18/python-2.7.18.amd64.msi

If you already has Python3 installed, that will work fine

Now you need to set the value fo ACCTID that is valid for your account. You can either

• Edit file fixChase.py, change value of 

DEFAULT_ACCTID = "1234567890"

• OR you can create file  fixChase.json (keep it in same folder/directory as  fixChase.py) with the following content

{
    "ACCTID": "0987654321"
}

Set 0987654321 to the account id value

---

Usage

• Download your Chase *.QFX file
• Save it into the same folder as  fixChase.py
• Then drag-and-drop your *.QFX file onto the icon of  fixChase.py

That will generate a new *.ofx file (with the word "fixed"). Now you can choose to import the "fixed" OFX file into money (such as just double-click it)

[First Name Last Name]

Tips: if you have multiple accounts with Chase. 

* You can re-name, make a copy of fixChase.py to something like fixChase-1234.py, fixChase-5678.py

* so that each of those scripts is specific to each account: edit DEFAULT_ACCTID appropriately.

Then you can just drag and drop the QFX per account to each of the python scripts.

[Robert Jacobson (bobjbkln)]

Thanks hleofx. As far as I can tell the problem exists with the credit card only.  The checking and savings work as expected.

[Chad Carlson]

Chase finally fixed the problem. I've spent a few hours on the phone with them multiple different times and they finally fixed the issue of the missing account number in the exported file.

[Chad Carlson]

This is the case number with Chase: #20231024COTS0050

[Matt Petersen]

Looks like Chase now has both QFX and QIF as download options as of a few days ago.

[Robert Jacobson (bobjbkln)]

Chase does have both choices but when the QFX file was broken, the QIF also did not work.  Both give the correct output now.