Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Can't import QIF file from Chase Bank to Money Plus RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    2
    Sign in to vote

    I have used Money since the mid 1990s and had it running successfully on an XP desktop until 3 years ago. At that time, I bought a laptop running Windows 8.1 and downloaded Money Plus from Microsoft and again had it running successfully, even after updating to Windows 10.

    Each month when I pay my Chase credit card bill, I download the activity and import it into Money. This has been working fine until this month. Now, when I download the file (in QIF format) and attempt to import it into Money, I get an error message telling me that the file is either invalid or corrupt and to contact my financial institution. Thinking that it was just a glitch, I tried it several times over the course of a week, but I still get the error message. I called Chase and they tell me that everything is fine on their end and that I should contact Microsoft. But since this is no longer supported, I'm stuck.

    Any ideas on what I need to do? They also support the OFX format or CSV and Excel. If there's a way to import those formats, I'll give it a try if I have instructions.

    Thanks!

    Marie

    Thursday, April 6, 2017 3:11 AM

Answers

  • Question
    Sign in to vote
    8
    Sign in to vote
    Don't use the QIF file.  Instead download the QFX file to your desktop.  Change the extension from qfx to ofx.  Then double click on the ofx file.  It will import correctly into Money.
    Thursday, April 6, 2017 4:26 AM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    There was  a problem awhile back with the way that Chase formated downloads but it went away.  Maybe it's back?  Have a look at:

    https://social.microsoft.com/Forums/en-US/a480a127-b9da-4f79-b150-83af1b8256ea/manual-download-from-chase-cc-error-importing-possible-solution?forum=money

    Bill Becker

    Thursday, April 6, 2017 3:40 AM
  • Question
    Sign in to vote
    8
    Sign in to vote
    Don't use the QIF file.  Instead download the QFX file to your desktop.  Change the extension from qfx to ofx.  Then double click on the ofx file.  It will import correctly into Money.
    Thursday, April 6, 2017 4:26 AM
  • Question
    Sign in to vote
    1
    Sign in to vote
    Don't use the QIF file.  Instead download the QFX file to your desktop.  Change the extension from qfx to ofx.  Then double click on the ofx file.  It will import correctly into Money.

    Thank you! That is so much better.  A few months back when they changed their website, I started getting all sorts of strange things, like the NUM field in Money had N/A in it, and if I asked for just the last statement, I'd be missing some of the transactions. In the past, I just always asked for all transactions and didn't have to worry about duplicates. I also had to tell Money every single time which account to import to.

    With the ofx file, it automatically imported to the correct account with no problems.

    I'm beginning to wonder if I shouldn't consider switching to something that's still being supported. I've been using Money for so long that I dread the thought of learning something new, but since I rely on it for tracking our finances, especially at tax time, I'll truly up the creek if things stop working - like reports, etc.

    Thursday, April 6, 2017 7:34 PM
  • Question
    Sign in to vote
    1
    Sign in to vote
    You could try calling Chase customer service and asking them to restore their old website for you.  They still have it available on their server.  They did it for me a few months ago,  so I have the old format and continue to import the data as always.  However,  I heard they have refused to do it for others more recently, but you should still try.  Also, as far as I know almost all the other banks except Chase, will still create OFX files for download, so you could just as easily change banks as change financial programs to get what you want. 

    • Edited by bobjbkln Thursday, April 6, 2017 8:00 PM
    Thursday, April 6, 2017 7:59 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    @Bill Becker

    The previous problem with the qfx file has been and remains fixed.  The OP was using the QIF format because that is the one Chase tells MS Money users to select.  The OP's problem was with the QIF file.  As you can see below using the QFX file (renamed to OFX) solved the problem.

    Thursday, April 6, 2017 8:07 PM
  • Question
    Sign in to vote
    1
    Sign in to vote

    Thanks for this input!!!

    I've been working with Chase IT Technical Support about fixing the QIF issue, starting in mid-March. When I called last month, the IT Supervisor said she saw multiple instances of the issue coming in and thought a QIF fix would be available within a few days and suggested re-trying it then. When I tried my next DL using QIF today (4/7), I got the same INOP issue with the same error msg. So called Chase back and they are "chasing" it down as I enter this.

    In the mean time, my own search brought me here, thanks to you guys. Yes, the QFX DL, renamed to OFX works great! Thank you!!!!

    When Chase calls me back with what they find, I will suggest they can help their customers by offering a MS Money OFX format selection once again.  They can easily create it using the QFX format, changing only the file extension to OFX as part of the download function. Creating a QFX file but calling it OFX is all we need at this point.  This would be the proper solution, valuable to us as customers of Chase and VERY low cost to them.  Win/Win.

    What the future brings is anyone's guess, but I'm hanging with MS Money, the best of the personal accounting tools.  Works great in Win10, too.

    Thanks again for your efforts!




    • Edited by RonS77 Friday, April 7, 2017 3:27 PM
    Friday, April 7, 2017 3:24 PM
  • Question
    Sign in to vote
    2
    Sign in to vote

    If you want to associate the .qfx extension to OFX files so that
    Money can import it directly, you can create a .reg file named
    qfx2ofx.reg.  Then web access to .qfx files would work the same as
    for .ofx files.  That .reg file would contain the 15 lines that are
    between the two demarcation lines:

    ==========begin qfx2ofx.reg===============================
    REGEDIT4

    [HKEY_CLASSES_ROOT\.qfx]
    "Content Type"="text/qfx"
    @="ofx.Document"

    [HKEY_CLASSES_ROOT\.qfx\ofx.Document]

    [HKEY_CLASSES_ROOT\.qfx\ofx.Document\ShellNew]

    [HKEY_CLASSES_ROOT\MIME\Database\Content Type\application/x-qfx]
    "Extension"=".qfx"

    [HKEY_CLASSES_ROOT\MIME\Database\Content Type\text/qfx]
    "Extension"=".qfx"
    ==========end qfx2ofx.reg===============================

    Just run that file after you create it.  So thereafter, if you use
    the web etc to bring in a .qfx file, it is treated as if it were
    named *.ofx.  The Money install associated .ofx with itself.

    If you are also using Quicken, this would probably not be a good
    thing to do.




    Friday, April 7, 2017 4:51 PM
    Moderator
  • Question
    Sign in to vote
    1
    Sign in to vote

    I have used "Microsoft Money 2005" and there is no simpler and better program than Money.  Several years ago i heard Microsoft offers free upgrade to "Microsoft Money Deluxe" (which i use now).  I can't find to Deluxe download link, but Microsoft now offers you to download "Money Plus Sunset Deluxe" ... it said "is designed to be a replacement for expired versions of Money Plus Essentials, Money Plus Deluxe, and Money Plus Premium versions. Note: The Money Plus Sunset versions come with online self-help only."

    https://www.microsoft.com/en-ca/download/details.aspx?id=20738

    you could give your program an update (please have a backup of your your Money program and a backup of your data file before doing any update).

    My solution and just noticed others have already solved, is choose to download your transaction in Quicken file in *.qfx format rename to *.ofx and the data are imported just like before.  

    My bank stopped supporting Money last week, I complaint and hope they restore Money support.  Money is so easy, flexible to use and free - no need to buy other complicate and expensive "new" accounting software.

    Monday, April 10, 2017 9:23 PM
  • Question
    Sign in to vote
    1
    Sign in to vote

    Thank you Bobjbkin!

    This solution took a lot less time then my dead ended discussions with Chase's customer service representatives.

    When I called them about problems downloading files into MS Money, they said they only assist with Quicken software. 

    I said that the download options on the website indicate it provides OFX files, those used by MS Money.  They said sorry we can only help you with Quicken. 

    I have had this credit card since 1985 and am a devoted user of MS Money since 2000. 

    I would give up this cc way before giving up MS Money.

    But now I do not have to!

    Thanks again!

    Sunday, April 16, 2017 10:39 PM
  • Question
    Sign in to vote
    1
    Sign in to vote
    Thank you so much for this fix.  Works like a charm!  I'm running Money 2000 and will as long as I can.  I had Money 95 before that so 22+ years of financial data.  Just as a backup I have exported the entire ledger to Excel periodically.
    Tuesday, April 18, 2017 7:50 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    I totally agree with you! I would sooner give up my Chase credit card than have to stop using Money. It works perfectly with my Capital One and Target accounts. Their tech help was useless. Thank goodness for bobjbkin!!
    Tuesday, April 18, 2017 7:51 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Thank you so very much bobjbkln!! Like Marie I have used Money for years and it totally suits me. I spent hours trying to get my April Chase bill entered into Money. I uninstalled and reinstalled the program, tried it on my other computers, and downloaded it many many times to no avail. Then I tried Chase tech help which was no help at all. I set up an Excel spreadsheet which did not do what Money could do. All in all I spent hours trying to do what I took for granted before. I had decided to stop using my Chase card since I could still use Money with Capital One and Target. But something made me search again today and I found your solution which works PERFECTLY!! I have no idea why Chase couldn't tell me that! Thank you so much for sharing this solution!!!
    Tuesday, April 18, 2017 7:58 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    THANK YOU! Is this a MicroSoft issue or CHASE?
    Monday, April 24, 2017 12:34 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    It's Chase's fault.  They no longer offer the choice of an OFX file for download like they used to do; and as all other banks that provide downloads still do.
    Monday, April 24, 2017 3:33 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    When I try to save the QFX file, it by default only gives me the option to save as a PDF.  Not sure what is happening, I select QFX from the dropdown, and when the "Save as" option comes up, the only choice is to save as PDF file.

    The QIF file does not work still and I get the same error message about file being corrupt or something from Money.  I have two months worth of data that is pending import, this is ridiculous from Chase.  Have not called them yet, but will have to now.

    Any other ideas?

    Tuesday, April 25, 2017 1:31 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Yes, not clear what is happening.  It sounds like you are on the statements page and Chase is offering to download a pdf of your statement.  But if you are on a transactions page, selecting QFX from a dropdown of file types and selecting QFX, should download a QFX file.  As noted above, if you succeed in downloading the QFX file, changing the file to OFX will allow Money to import it.

    BTW, quite a few credit card (AMEX and Discover are two) no longer offer an OFX download from their web sites but they still offer QFX.

    Bill Becker

    Tuesday, April 25, 2017 1:49 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    There are several threads on the Internet about the problem with Chase.com credit card activity downloads in the QIF format. I suspect that for every Chase customer who complains on the Internet about it, there are many others, perhaps thousands, that also have the problem.

    Continue Reading at https://sleibowitz.neocities.org/ChaseQIF.html

    Stephen Leibowitz

    Tuesday, April 25, 2017 8:54 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    I've tried this as well as doing it manually (Control Panel > Default programs > Associate a file type or protocol with a program >.qfx > Microsoft Money Import Handler) in both cases the downloaded QFX file does not automatically load into money as the OFX file from Chase did.  Nor does double clicking on the file enter it into Money.  What does work however is right clicking on the downloaded file and selecting Open With and then choosing Microsoft Money Import Handler.  That's a bit easier than changing the filename, but it's not at all like it used to work with the OFX file from Chase.


    Thursday, April 27, 2017 3:02 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    I have the same experience with both my Windows 10 and Windows 7 machines.  I tried the registry changes that Cal Learner detailed above, but that did not work.  In addition, I am unable to associate the qfx file type with mnyimprt.exe using the Control Panel on Windows 10.  I get the message that I can't associate that file type with that program.  It would be nice to be able to right-click and import, but so far I've had to change the file name.

    Any thoughts on how to set up this association?  

    Bill Becker

    Thursday, April 27, 2017 3:46 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    I have the same experience with both my Windows 10 and Windows 7 machines.  I tried the registry changes that Cal Learner detailed above, but that did not work.  In addition, I am unable to associate the qfx file type with mnyimprt.exe using the Control Panel on Windows 10.  I get the message that I can't associate that file type with that program.  It would be nice to be able to right-click and import, but so far I've had to change the file name.

    Any thoughts on how to set up this association?  

    Bill Becker

    I just tried it, and it worked for me. I ran QFX2OFX.REG and then downloaded a QFX file from my bank. It went into Money just fine.

    QFX2OFX.REG is 345 bytes. Should I put that file in a place you can download it from, or is yours the same?

    Thursday, April 27, 2017 4:12 AM
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote

    I just ran your registry script again and finally had some success.  When I double-click on a QFX file. Windows 10 asks which program to use.  If I select Money, it changes focus to Money but nothing happens.  If, instead, I choose the Money import handler, the focus changes to Money and I receive the error that there is an online activity already in progress and to try again later.  Fortunately, repeated attempts choosing the Money import handler finally succeed in importing the data from the qfx file.

    I will see how it goes when I have additional transactions to download.

    Bill Becker

    Thursday, April 27, 2017 3:08 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Make sure that when you double-click on an OFX file, it launches Money. I expect that works fine, since you are able to send the files to Money after you rename.

    It's my understanding that the QFX2OFX.REG  file has Windows treat the QFX as an OFX file.

    For testing, you could rename a little text file to be *.ofx or *.qfx. You will get an error when you launch, but that error comes from Money  when I try that.

    I just went into regedit, and selected HKEY_CLASSES_ROOT\.qfx . I then did File_>Export. The exported file contained this info:

    ===========================

    Windows Registry Editor Version 5.00

    [HKEY_CLASSES_ROOT\.qfx]
    "Content Type"="text/qfx"
    @="ofx.Document"

    [HKEY_CLASSES_ROOT\.qfx\ofx.Document]

    [HKEY_CLASSES_ROOT\.qfx\ofx.Document\ShellNew]

    ==========================================

    I just offer that for comparison if you want to try it.

    Thursday, April 27, 2017 6:40 PM
    Moderator
  • Question
    Sign in to vote
    1
    Sign in to vote

    Success! The details:


    Investigation:

      - Money did, indeed,properly import ofx files.

      - After the registry change, my HKEY_CLASSES_ROOT\.qfx matches what you posted

      - A double-click on a valid qfx file still didn't work. Focus shifts to Money but nothing happens.

      - Same thing happens with a contrived test.qfx file. Focus shifts but no error message.

      - A right-click on a test.qfx file or valid qfx file and selecting Money Import Handler does give the appropriate error message or import..


    Then I went into Control panel and checked the program associated with qfx files. It was Money, not the Money Import Handler. Previously I was unable to change this, but now, apparently thanks to the registry change, I could go to "Control Panel>Programs>Make a file type always open in a specific program" and change the qfx file extension to associate it with the Money Import Handler. This did the trick. Now, a double-click on a qfx file gives either a Money error message (on the test file) or a successful import of a properly formatted qfx file.


    Many thanks!

    Bill Becker



    • Edited by Bill Becker Friday, April 28, 2017 12:28 AM
    Friday, April 28, 2017 12:27 AM
  • Question
    Sign in to vote
    1
    Sign in to vote

    I have ben fighting the same problem since my Feb download. Talked to Chase many time and got the same answer "Chase does not support MSMoney"

    Asked them since when and got the same answer again. their support is useless!! Your Fix works great and I will try the REG program when I can.

    Thanks for solving a problem for so many people who still use a great program.  I wonder why Microsoft does not support it any more.

    Wednesday, May 10, 2017 7:45 PM
  • Question
    Sign in to vote
    1
    Sign in to vote
    The “IF” in QIF stands for Interchange Format. It allows a “separation of concerns.” So long as Chase and the customer agree to use the QIF format, the bank does not need to be concerned with what financial software the customer uses. Chase’s only concern would be to provide valid QIF files: accurate, complete, and conforming to the QIF standard. The processing of valid QIF files by financial software is a matter between the vendor of that software and its customers. This is why the answer “we [Chase] do not support MSMoney” is irrelevant.

    In my opinion, this has the look and feel of a decision by Chase to withdraw support for QIF, initially for credit card accounts. They continue to list it as a download option. But the files are now missing the required ending symbol for each transaction, something customers have been complaining about for at least two months. Fixing the error would be easy for Chase. If stopping QIF support is Chase’s intention, the lack of advance notice and clarity about the matter from Chase is a heavy-handed way to treat its customers. If Chase is truly committed to good customer service, it should simply fix its software and let the customers choose whether to use QIF or another format.

    Stephen Leibowitz


    Thursday, May 11, 2017 3:44 PM
  • Question
    Sign in to vote
    1
    Sign in to vote

    @Stephen Leibowitz.  I strongly agree with you about Chase's  lack of customer support on IT issues.  They are totally arrogant.  For a while after I complained they switched me back to their old format website, where the downloads worked fine; but after a while they decided to refuse to make that change.  There was no explanation other than "we were told not to do this anymore".   I've been with Chase for 55 years and have multiple accounts with them, otherwise I would switch banks over this.

    BUT, ON THE OTHER HAND, I do not understand why you would want to use QIF with MSMoney as the OFX format is Money's native import filetype.   While Chase does not offer OFX any more with their new website format, Quicken's QFX file will work fine if the extension is changed to OFX (or, in most cases, if the registry changes suggested by Cal Learner are made).


    • Edited by bobjbkln Thursday, May 11, 2017 6:03 PM
    Thursday, May 11, 2017 6:01 PM
  • Question
    Sign in to vote
    1
    Sign in to vote
    OFX is a good format. Chase used to provide OFX and QFX, along with other options for downloads, but has dropped OFX. Wikipedia says, “A QFX file is a standard OFX file with additional fields to support a licensing fee paid by institutions to Intuit [probably now H.I.G. Capital, which acquired Quicken from Intuit].” Fortunately, many financial software tools will import QFX files and ignore the extra fields. MS Money is a bit of an exception. It can ignore the extra fields. But, as explained by the other posts in this thread, to import a QFX file the user must first either change the file extension from qfx to ofx, or resort to the Windows registry hack.

    Chase should fix the QIF error in its software, restore the OFX format, and let customers choose among these and the other format options they support.

    Stephen Leibowitz

    Sunday, May 14, 2017 7:09 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    https://microsoftmoneyoffline.wordpress.com/reg-file-to-import-quicken-qfx-files-automatically-into-money/

    Seems to work a charm....

    however I see renaming QFX files to OFX here....I cannot seem to find a way to do that in windows 10.  Normally the prefix to the file is present and you can just "rename" it....but that does not seem to work or appear as an option in Windows 10.  In fact even when about to save file and looking at the option to name it as another type of file is not even present. 

    I did an experiment before the above REG file solution, and simply downloading the QFX file from CHase to the desktop.....then choosing import from Money "download statements" appears to work as well....without having to rename anything.  Chae should just place the option of OFX back its site but it wont.  Either of the above solutions work.....

    Monday, May 15, 2017 4:44 PM
  • Question
    Sign in to vote
    1
    Sign in to vote

    I have a workaround for those who are sticking with Chase and want an easy way to correct their Chase QIF file downloads so they are to specification. As discussed in the thread above, these QIF files are not being created correctly by Chase since sometime beginning in March, 2017. Specifically, the Chase QIF files are writing a carriage return line feed twice without placing a ^ symbol between them to mark the end of the transaction. These improperly written QIF files fail when you attempt to import them into financial software using QIF files. The best way to correct them is to use a hex editor and I've found an excellent hex editor named HXD which can be downloaded for free here:

    https://mh-nexus.de/en/downloads.php?product=HxD

    You can read about it at the Gizmo's free software site here:

    http://www.techsupportalert.com/content/hxd.htm-0

    With HXD, open the bad Chase QIF file. The default presentation of that file will show both hex and text on the screen. From the Search menu, select Replace. In the dialog box which opens, select hex values in the data type drop-down box. In the search for box, type 0D 0A 0D 0A as these are the hex values of the carriage return line feed values Chase is writing twice. In the Replace with box, type 0D 0A5E 0D 0A which are the hex values of carriage return line feed ^ carriage return line fee. As you've no doubt figured out, the hex value of the carat & symbol is 5E. Select All for the search direction and execute the Replace all button at the bottom. Be sure to save this edited file when exiting the QIF file you've just edited in the HXD hex editor. The nice thing about HXD is that the next time you open it, it will remember the default e search and replace values so editing the bad Chase QIF files will be very easy going forward for as long as they continue to produce these failed QIF files. I'm going to send one more secure message to Chase Online and explain yet again what they need to do to correct their errant QIF files and hoe that they will indeed correct their process.

    Thanks for bearing with my posts and I hope this one is helpful.

    Alan Lemly

    Tuesday, May 23, 2017 3:27 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Hi all. I have read all the responses and have been experiencing the same issues since march of this year. Tried the fix as suggested and it worked for me. My question is this. My chase account consists of 4 accounts: one checking, two savings and one credit card (Chase visa) I down all four of the accounts.into ms money using the same procedure "QIF format" three of the accounts download fine into ms money (checking and two savings) with not issues at anytime. However I one have an downloading issue in ms money with the chase visa credit card acct. why is that?
    Tuesday, May 30, 2017 6:50 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    You might get a better response if you tell us what the one issue is.
    Tuesday, May 30, 2017 7:15 PM
  • Question
    Sign in to vote
    1
    Sign in to vote

    HenTon14:

    It appears that only the Chase credit card account downloads have malformed QIF files.  Only Chase knows why, and they are not responsive to this issue.

    Bill Becker

    Tuesday, May 30, 2017 10:22 PM
  • Question
    Sign in to vote
    1
    Sign in to vote

    I have also been having the same problem with Chase Visa downloads since March 2017.  (The Chase checking account download still works fine.)

    As a work-around,  I have been downloading the QFX file with Chase Visa.

    Then from within Money, select File / Import / Downloaded Statement

    Then change the "File of Type" drop-down to "All Files".  Select the QFX file and Import.

    Sunday, July 2, 2017 9:56 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    To make it a lot simpler, just create and run the reg file suggested by Cal Learner earlier in this thread on a post dated April 7, 2017 4:56 PM.  Then MS Money will treat your QFX file as if it were an OFX.
    Monday, July 3, 2017 3:41 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    I am on the [Chase Bank] download account activity page, where there is a dropdown to select the file format.  However, when I select the time period and click on download activity, the resulting file is always a PDF file.  I don't see any other page where I can download transactions, or the transaction page you are mentioning.  The link from the main accounts page takes you to the "Download Account Activity", where the QFX format when I do "Save as", turns in to a PDF file.  

    I would rather do the registry edit solution now, but I have no idea how to get started.  Where to create the new reg entry, under which folder etc?  If someone can provide some steps before the stage where we are inserting values that Cal listed above, that would help me to get to that stage.  I open regedit in windows, but then don't know where to start.  

    Amazing how much time I have spent on this BS now.  I am almost ready to leave Money or chase, because of this mess.  6 months of transactions still pending import!

    I am failing on both changing the file extension and the new registry option, so more frustrated. 

    Appreciate any help you can provide. 


    • Edited by Cal LearnerModerator Saturday, August 5, 2017 2:30 AM clarifying it was the bank website being described.
    Thursday, August 3, 2017 10:10 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    That was awesome.  Worked like a charm.  THANK YOU!

    Friday, August 4, 2017 3:55 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    F'N Brilliant.  The best solution, ever!  Thanks so very much!

    Tony C.

    Saturday, September 23, 2017 8:39 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    How do I convert from QFX to OFX?
    Monday, November 6, 2017 5:11 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    How do I convert from QFX to OFX?
    I think you are asking how to convert a QFX file that you have to an OFX file that Money can import? You are not asking how to get transactions from Chase. Right?
    Monday, November 6, 2017 5:16 PM
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote

    This worked like a champ for me! THANK YOU! I set MyMoney up on my parents computer about a year and a half ago and know I imported everything back then. But hadn't remembered since so long ago. Again, Thanks!!!!!

    Tuesday, January 9, 2018 6:37 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    I tried this and it still does not work. My problem started only in recent months. I suspect that .qfx format has been changed and as each bank starts using the latest format, it stops working. Any other idea?
    Wednesday, January 23, 2019 6:21 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    I tried this and it still does not work. My problem started only in recent months. I suspect that .qfx format has been changed and as each bank starts using the latest format, it stops working. Any other idea?

    I think you are saying that you are getting a Chase *.qfx file via the web rather than using Pocketsense. When you attempt the import to Money, do you get an error message?

    You could make a copy of the problem *.qfx file and change the <ACCTID> to something like 1234567 in Notepad. Then upload the modified copy to tinyupload.com. Post the URL here.

    Somebody can look at it and probably tell you what it would take to make Money accept it.

    Wednesday, January 23, 2019 6:36 PM
    Moderator
  • Question
    Sign in to vote
    1
    Sign in to vote

    Chase has messed up a date value in export QFX when manually download. For example

    <DTPOSTED>02/15/2018

    That is not a valid timedate format in OFX

    Should be something like this

    <DTEND>20180216120000[0:GMT]

    Direct download seems to be OK.

    Customer should complain to Chase support.

    Wednesday, January 23, 2019 10:13 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    I have absolutely no problem using Chase credit card QFX file downloaded manually.  Been doing it since Chase abandoned the OFX format.  The checking and savings is a different story as the download includes too much old data to work with Money.  The solution is to choose to download custom dates and select the last 30 days or so (depend on when you last downloaded).  Then it works fine.
    Thursday, January 24, 2019 4:27 AM
  • Question
    Sign in to vote
    1
    Sign in to vote

    So, I was having the same problem. I went into the code and the issue is this... 

    <FITID>NONE

    It needs to have a number of this length in it... 

    <FITID>2019011074692169009100801503715

    Because they now have that set to none, the transactions won't import. I had to go in and manually put a random number in to get them to import. It was a PIMA. Especially for 25 transactions. 

    Do note that it has to have the date in front and then random numbers...  2019011074692169009100801503715 = 20190110 (date) + 74692169009100801503715 (FITID)

    Don't ask me what FITID stands for. It has to be some kind of transaction ID?!?

    • Proposed as answer by jxmot1959 Friday, February 1, 2019 8:50 PM
    Friday, February 1, 2019 6:04 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    So, I was having the same problem. I went into the code and the issue is this... 

    <FITID>NONE

    It needs to have a number of this length in it... 

    <FITID>2019011074692169009100801503715

    Because they now have that set to none, the transactions won't import. I had to go in and manually put a random number in to get them to import. It was a PIMA. Especially for 25 transactions. 

    Do note that it has to have the date in front and then random numbers...  2019011074692169009100801503715 = 20190110 (date) + 74692169009100801503715 (FITID)

    Don't ask me what FITID stands for. It has to be some kind of transaction ID?!?

    FITID is the Financial Institution Transaction ID. It needs to be unique for each transaction, but also needs to be the same if the same transaction is processed again. That lets money not duplicate the transaction.

    The specification on the  FITID says "Note: Although the specification allows FITIDs of up to 255 characters, client performance may significantly improve if servers use fewer characters. It is recommended that servers use 32 characters or fewer."

    The FITID is very basic in OFX/QFX. If this continues, somebody could make a Python program to fix the problem OFX files. The fix-up program would probably make an FITID based on the date and amount and any other transaction difference. If there are two transactions that have the same date, amount, and whatever in the same OFX file, then the program should make a different FITID for the second, third, etc. So if you bought a coffee at the same place for the same amount twice in a day, they should be treated as 2 separate transactions.

    Friday, February 1, 2019 1:36 PM
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote

    So, I was having the same problem. I went into the code and the issue is this... 

    <FITID>NONE

    It needs to have a number of this length in it... 

    <FITID>2019011074692169009100801503715

    Because they now have that set to none, the transactions won't import. I had to go in and manually put a random number in to get them to import. It was a PIMA. Especially for 25 transactions. 

    Do note that it has to have the date in front and then random numbers...  2019011074692169009100801503715 = 20190110 (date) + 74692169009100801503715 (FITID)

    Don't ask me what FITID stands for. It has to be some kind of transaction ID?!?

    That solution has worked! Thank you VERY much! It was the key to fixing the stupid Chase issue. I have tried everything else including changing the EOLs, and looking for anything that seemed out of place.

    I used a random 31 digit generator at - http://numbergenerator.org/random-31-digit-number-generator

    I had spent almost 2 hours on the phone with Chase, and escalated the call 3 times trying find someone who could tell me what Chase had changed since about a month ago. Didn't happen, instead they were rude and stupid. The moment they found out I was using Money(really tried to hide that fact) the washed their hands of the issue and blamed me.

    I'll end up creating some sort of "fix" program for this issue. I haven't decided what to use yet, but doing this manually isn't too bad as long as there aren't a lot of transactions to fix. If/When I come up with something I will post it here.



    Friday, February 1, 2019 8:50 PM
  • Question
    Sign in to vote
    2
    Sign in to vote

    I am having the same issue and called Chase to report it. They said that they are working on a system issue right now and that it should be resolved later today or tomorrow.

    I regularly download my transactions from Chase to Microsoft Money. This will cripple my workflow... :-(

    Friday, February 1, 2019 8:59 PM
  • Question
    Sign in to vote
    1
    Sign in to vote
    I spoke to soon.  The last working download was on Jan 23 (my message was sent on the 24th).  Since then the download of the Chase Credit Card no longer works, although the checking and savings still do.  On the Credit card, the FITID says NONE.   I assume this problem affects Quicken Users as well.  I'll call them next week and see if they intend to solve the problem.  Don't understand why the change was made.  I'll report back as to what their response, if any, is. 
    Saturday, February 2, 2019 2:23 AM
  • Question
    Sign in to vote
    1
    Sign in to vote

    I am going to call them next week since we now know what the problem is.  I assume that this problem affects Quicken users as well, so unless they plan to stop all downloads, they should have to fix it.  There really is no fix that one can do at our end as the FITID has to be be assigned to as specific transaction at their end, not after the download, otherwise we will be giving different numbers to the same transaction with each download and therefore getting repeats. 

    @Cal: Do you think that these 2019 Chase FITID message be broken off into a separate thread?

    • Edited by bobjbkln Saturday, February 2, 2019 2:34 AM
    Saturday, February 2, 2019 2:31 AM
  • Question
    Sign in to vote
    1
    Sign in to vote
    Good luck with Chase. I e-mailed and was told to call. The agent said there hadn't been any changes to the functionality and so wouldn't even acknowledge there was a problem. I then saw this thread and told them about the <FITID>NONE issue via secure message and was told to call in again. I replied saying I had called and that the agent didn't even think there was an issue so I didn't want to call in again, and then yet another rep wrote back to say, yes, there had been an issue with Quicken downloads being "unavailable" but that it was fixed now and there hadn't been any changes to how the system outputted data into QFX files. Yet another reply back with exactly what the issue was - including the text from a downloaded file with the <FITID>NONE field pointed out - garnered...a message saying I needed to call them. Working up the patience to do that again today.
    Tuesday, February 5, 2019 3:02 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    See also: https://social.microsoft.com/Forums/mvpforum/en-US/f9a4fa77-fe71-4eed-a66e-c828572ab911/fixchasefitidnonepy-python-script-to-fix-up-chase-ltfitidgtnone?forum=money

    Until Chase sorts it out. A work-around: a python program to fix up the <FITID>NONE issue

    Download from https://bitbucket.org/hleofxquotesteam/hleofxquotes/downloads/

    To run

    $ python fixChaseFitidNone.py -i Chase1234_Activity20190205.QFX -o out.qfx
> Reading from Chase1234_Activity20190205.QFX
< Writing to out.qfx

    Import to Money using the fix-up file out.qfx

    What fixChaseFitidNone.py does? it replace <FITID>NONE with a hash value which is based on the all the lines representing the transaction. The advantage of using this is that if you happens to download the same set of transactions, after fix up, you will  get the exact same FITID.

    IMPORTANT: Once Chase fix up their ends, if you download transactions that already been "fixed up", Money will show duplicate because the FTID from Chase is NOT going to be the same that of the hash value I calculated.

    Best,


    Tuesday, February 5, 2019 8:17 PM
  • Question
    Sign in to vote
    1
    Sign in to vote

    I couldn't get this process to work, but I was able to make this work from Community Quicken

    I can't add a link in this post so look for "Cannot Download Transactions from Chase Bank"

    From Aquila2001 Member from February 5.

    Opening in Word Pad and manually find and replace with a number value for the FTID worked!!

    Good Luck!

    I too use My Money and need to find a replacement process, but it works so well!


    Thursday, February 7, 2019 2:29 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    For manual inserting number method, one thing to watch out for:

    • Next time, if you download a *.QFX file that has transactions that you already manually set the FITID, you will need to make sure to assign the same/matching FITID value or you will see duplicates.
    • On the flip side, if you re-use the FITID for new transactions, you then will not see the new transactions.

    Another words, Money use the FITID as a unique ID to identify a transaction.

    Thursday, February 7, 2019 3:29 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Looks like the FITD issue is resolved. I just downloaded QFX files for two Chase card accounts and after saving with a .OFX extension both of them loaded the transactions in with no problem.


    • Edited by jmartinks Tuesday, February 12, 2019 6:10 PM
    Tuesday, February 12, 2019 6:10 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    I confirmed your finding.  Just remember that if you used hleofxquotes2's temporary Python fix you will get duplicates when you do your first Chase download.  Just accepts the new entries and delete the old duplicates.  This should not happen again.

    --

    Peace,

    BobJ

    Tuesday, February 12, 2019 7:47 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    hleofxquotes2,

    Thank you so much for generating this python program.  It's the first time I've used anything python, but it worked splendidly!  It saved my personal finance management vis-à-vis Chase imports.  Having used MS Money since the early 90s, I depend on this app exclusively for my personal finance.  Thanks again for your work on an interim solution.


    Sunday, February 17, 2019 2:21 PM
  • Question
    Sign in to vote
    1
    Sign in to vote

    I know this an old response now but it is an important finding.  I have used Money 2001 since probably 2001.  Just recently I too have received this message when importing into Money2001.  I have found it is down to a specific transaction type (<TRNTYP>) in the OFX data file.  This used the type REFUND.  When I took this transaction segment out of the file (using NOTEPAD) it imported just fine.

    It would seem that the OFX protocol may have changed over the years to allow the REFUND <TRNTYP> and this is unacceptable in Money2001 that no longer has support.

    Naturally it is important to remove the whole transaction from <STMTTRN> to </STMTTRN>.

    Hope this helps someone.

    Since found out you can change the transaction type to OTHER:  thus:

    <STMTTRN>
                <TRNTYPE>OTHER
                <DTPOSTED>20200204000000[-5:EST]
                <TRNAMT>2.10
                <FITID>+202002040000004
                
                <NAME>COSTA COFFEE ON 03 FEB CLR
              </STMTTRN>

    and it will import fine.


    • Edited by Bazzage Tuesday, February 18, 2020 2:45 PM
    Tuesday, February 18, 2020 2:40 PM