OFX download settings for Fidelity Investments, Fidelity Net Benefits, Janus, Bank of America, PNC Bank, ING Direct Bank, TD Ameritrade, USAA, Chase Bank, Schwab, Discover Card, Citi Card, CitiBusiness Card, American Express, Capital One, Sears Card, OptionsXpress, VALIC, Vanguard, Scottrade, Chase card and Wells Fargo Advisors


[EDIT – Ressom provided additional input for American Express and Fidelity Net Benefits which I’ve also included below] [EDIT – ameridan added settings for VALIC on 12/25/2010]
[EDIT – ameridan added settings for Capital One & CitiBusiness Card on 1/16/2011 – thanks Ken!]
[EDIT – ameridan merged previously published settings for Chase Bank, Discover Card & Schwab on 1/16/2011] [EDIT – PHWhite provided additional input for TD Ameritrade on 1/19/2011]
[EDIT – Stephen provided additional input for ING Direct Bank on 1/20/2011]
[EDIT – ameridan merged previously published settings for PNC Bank on 1/28/2011]
[EDIT – hung le provided additional input for Sears Card on 1/29/2011]
[EDIT – ameridan added settings for OptionsXpress on 3/26/2011]
[EDIT – ameridan provided link to additional input for USAA on 4/19/2011]
[EDIT – Cal added settings for Wells Fargo Advisors on 10/6/2011]
[EDIT – Marc discovered new ofxVer setting for Capital One on 2/27/2013]
[EDIT – ameridan updated the URL for Citi credit cards on 3/15/2013]
[EDIT – ameridan added updated settings for Bank of America credit cards on 12/12/2013]
[EDIT – Ken added settings for Scottrade on 3/31/2014]
[EDIT – Robert updated settings for Vanguard on 9/24/2014]
[EDIT – Ken
added settings for Scottrade on 3/12/2015]
[EDIT – Ken added settings for Capital One Investing Sharebuilder on 12/5/2015]
[EDIT – Humble Pie added settings for Chase credit card on 12/6/2015]
[EDIT – hung le provided additional input for Chase credit card on 10/21/2016]

Thank you Cal for the nice review of both my OFFLINE Blog and Bobby’s PocketSense site.   I am going to quote it here as it might provide assistance setting up FIDELITY Investments, Citi Card, and Vanguard accounts.  Regarding your Janus account, my experience is that without the FID number, you won’t get an error, but you won’t get data either – instead you probably get a list of your account numbers. I think this is how Money Online established the setup link of all accounts at any financial institution you engaged Online services for.     If you’ve  ever turned on logging in Money, you would note that you got 4 files for each set of transactions being downloaded (if you have multiple accounts, otherwise you only get 2).  The first  ***RQ.txt  file was the initial OFX file being sent by Microsoft Money.    The first  ***RS.txt  file was the response from the financial institution listing all of your account numbers.   Then the program proceeded to add the FID and the ACCOUNT NUMBERS for each account resulting in the second  ***RQ.txt  file that serves to reveal all of the OFX parameters that you need to get the PocketSense scripts to work.   It’s this second ***RQ.txt file that requests the OFX downloads for all of your accounts at that institution (***RS.txt).

If you don’t see what you are looking for below, make sure you check out the  Look Up Your OFX Settings  Blogpage with links to all of the other sources of OFX settings that I am aware of.

PHWhite also offered this tidbit regarding Ameritrade, but probably true in many other instances:

I had to call TD Ameritrade because transaction downloads for my accounts had been locked out because of my failed attempts, so even if you are using the right parameters it may not work until you call to get your accounts enabled for transaction downloads. I also needed to have TD Ameritrade reset the passwords.

OFX settings for various other  financial institutions (in no particular order yet) that can be copied directly into PocketSense’s sites.dat file


     SiteName : DISCOVER
     AcctType : CCSTMT    #credit card
     fiorg : Discover Financial Services
     fid  : 7101
     url  : https://ofx.discovercard.com 
     bankid : 
     brokerid :
     appid : 
     appver : 
     mininterval : 

 
     SiteName : Bank of America 
     AcctType : CCSTMT    #credit card 
     fiorg : HAN 
     fid  : 5959 
     url  : https://eftx.bankofamerica.com/eftxweb/access.ofx 
     bankid : 
     brokerid :
     appid : 
     appver : 
     mininterval : 

 
     SiteName : PNC   #(see note) 
     AcctType : BASTMT 
     fiorg : ISC 
     fid  : 4501 
     url  : https://www.oasis.cfree.com/4501.ofxgp 
     bankid : 041000124
     brokerid :
     appid : 
     appver : 
     mininterval : 


     SiteName : CHASE 
     AcctType : BASTMT 
      fiorg : B1 
      url : https://ofx.chase.com 
      fid : 10898 
      bankid : (use appropriate routing #) 
     brokerid : 
      appid : 
      appver : 
     mininterval : 
 
 
     SiteName : SCHWAB 
     AcctType : INVSTMT 
     fiorg : ISC 
     url  : https://ofx.schwab.com/cgi_dev/ofx_server 
     fid  : 
     bankid : 
     brokerid : 
     appid : 
     appver : 
     mininterval : 
 
 
     SiteName : TD AMERITRADE   #(see note1 and NEW note2) 
     AcctType : INVSTMT 
     fiorg : Ameritrade 
     fid  : 
     url  : https://ofxs.ameritrade.com/cgi-bin/apps/OFX 
     bankid : 
     brokerid : ameritrade.com 
        appid : 
       appver : 
     mininterval : 
 
 
     SiteName : AmEx 
     AcctType : CCSTMT     #credit card 
     fiorg    : AMEX 
     fid      : 3101 
     url      : https://online.americanexpress.com/myca/ofxdl/desktop/desktopDownload.do?request_type=nl_ofxdownload 
     bankid   : 
     brokerid : 
     appid    : 
     appver   : 
     mininterval: 
 
 
     SiteName : VALIC 
     AcctType : INVSTMT 
      fiorg : valic.com 
      url  : https://ofx.valic.com/eftxweb/access.ofx 
      fid  : 77019 
      bankid : 
     brokerid : 
     appid : 
     appver : 
    mininterval : 
 
 
     SiteName : CITICARD 
     AcctType : CCSTMT     #credit card 
     fiorg    : Citigroup 
     fid      : 24909 
     url      : https://www.accountonline.com/cards/svc/CitiOfxManager.do 
     bankid   : 
     brokerid : 
     appid    : 
     appver   : 
     mininterval: 
 
 
     SiteName : CITI BUSINESS CARD 
     AcctType : CCSTMT     #credit card 
     fiorg    : Citigroup 
     fid      : 26389 
     url      : https://www.accountonline.com/cards/svc/CitiOfxManager.do 
     bankid   : 
     brokerid : 
     appid    : 
     appver   : 
     mininterval: 
 
 
     SiteName : CAPITAL ONE   #(see comment) 
     AcctType : BASTMT     #bank accounts 
     fiorg    : Hibernia 
     fid      : 1001 
     url      : https://onlinebanking.capitalone.com/ofx/process.ofx 
     bankid   : 051405515 
     brokerid : 
     appid    : 
     appver   :
     ofxVer  :  103 
     mininterval: 
 
 
     SiteName : ING DIRECT BANK   #(see comment) 
     AcctType : BASTMT 
     fiorg    : ING DIRECT 
     fid      : 031176110 
     url      : https://ofx.ingdirect.com/OFX/ofx.html 
     bankid   : 031176110 
     brokerid : 
     appid    : 
     appver   : 
     mininterval: 
 
 
     SiteName : Wells Fargo Advisors 
     AcctType : INVSTMT 
     fiorg    : WF 
     url      : https://ofxdc.wellsfargo.com/ofxbrokerage/process.ofx 
     fid      : 12748 
     bankid   : 
     brokerid : Wells Fargo Advisors 
     appid    : 
     appver   : 
     mininterval: 


     SiteName : FIDELITY 
     AcctType : INVSTMT 
     fiorg    : fidelity.com 
     url      :  https://ofx.fidelity.com/ftgw/OFX/clients/download 
     fid      : 7776 
     bankid   : 
     brokerid : fidelity.com 
     appid    : 
     appver   : 
     mininterval: 
 

     SiteName : Janus Investments #(see comment)
     AcctType : INVSTMT 
     fiorg    : 
     fid      : 
     url      : https://ofx3.financialtrans.com/tf/OFXServer?tx=OFXController&cz=702110804131918&cl=50900132018  
     bankid   : 
     brokerid : dstsystems.com 
     appid    : Money 
     appver   : 1900 
     mininterval: 
 
 
     SiteName : FIDELITY NET BENEFITS 
     AcctType : INVSTMT 
     fiorg    : nbofx.fidelity.com 
     BrokerID : nbofx.fidelity.com  
     fid      : 8288 
     url      : https://nbofx.fidelity.com/netbenefits/ofx/download 
     appid    : 
     appver   : 
     minInterval: 30 
 
 
     SiteName : VANGUARD 
     AcctType : INVSTMT    #investment 
     fiorg    : Vanguard 
     fid      : 1358
     url      : https://vesnc.vanguard.com/us/OfxDirectConnectServlet 
     bankid   : 
     brokerid : vanguard.com 
     appid    : 
     appver   : 2300
     ofxver   : 103
mininterval: 30     #may be optional now - Vanguard used to not like short intervals. 
 
 
     SiteName : SEARS CARD 
     AcctType : CCSTMT     #credit card 
     fiorg    : Citigroup 
     fid      : 26810 
     url      : https://secureofx.bankhost.com/tuxofx/cgi-bin/cgi_chip 
     bankid   : 
     brokerid : 
     appid    : 
     appver   : 
     mininterval: 30 
 
 
     SiteName : USAA 
     AcctType : BASTMT     #bank 
     fiorg    : USAA  
     fid      : 24591 
     url      : https://service2.usaa.com/ofx/OFXServlet 
     bankid   : 314074269 
     brokerid : 
     appid    : QWIN 
     appver   : 1900 
     mininterval: 

 
     SiteName : OPTIONSXPRESS 
     AcctType : INVSTMT    #investment  
     fiorg    : optionxpress.com 
     url      : https://ofx.optionsxpress.com/cgi-bin/ox.exe 
     fid      : 
     bankid   : 
     brokerid : 
     appid    : 
     appver   : 
     mininterval: 

 
     SiteName : SCOTTRADE 
     AcctType : INVSTMT    #investment  
     fiorg    : Scottrade 
     url      : https://ofx.scottrade.com/  
     fid      : 777
     bankid   : 
     brokerid : 
     appid    : 
     appver   : 
     mininterval: 

  
     SiteName : CAPITAL ONE INVESTING SHAREBUILDER 
     AcctType : INVSTMT    #investment  
     fiorg    : Sharebuilder 
     url      : https://ofx.sharebuilder.com  
     fid      : 5575
     bankid   : 
     brokerid : sharebuilder.com
     appid    : 
     appver   : 2300
     mininterval: 

  
     SiteName : CHASE CREDIT CARD  (see comment for more)
     AcctType : CCSTMT     #credit card  
     fiorg    : B1 
     url      : https://ofx.chase.com  
     fid      : 10898
     bankid   : 
     brokerid : 
     appid    : QWIN
     appver   : 2400
     ofxver   : 103
     mininterval: 

 


-ameridan


Regarding my addon package to PocketSense, version 1 is a simple webpage that you can access via Money’s favorite tab.  The version 2 has been ready for a while based on an upcoming release of PocketSense that the author states will not only generate ofx files, but an html page that lists all of your investments with hyperlinks to the Yahoo detail webpage for those investments.  My webpage addon will simply include that as a “frame” and the page itself is somewhat more visually appealing.  It has changed somewhat from the example shown, but I can’t release it until Bobby completes the new version of his script, for obvious reasons. 🙂 click for larger image

Version 2 of ameridan’s OFFLINE webpage addon to Money

78 Comments »

  1. Ken H said

    Is anyone successfully downloading transaction data for Merrill Lynch (Merrill Edge)? I’ve used the available resources to come up with the following parameters but they don’t work:

    SiteName : MERRILL LYNCH
    AcctType : INVSTMT #brokerage account
    fiorg : Merrill Lynch & Co., Inc.
    fid : 5550
    url : https://taxcert.mlol.ml.com/eftxweb/access.ofx
    bankid :
    brokerid : http://www.mldirect.ml.com
    appid :
    appver :
    mininterval:

    Thanks for any help

  2. ameridan said

    Those match the latest Moneydance parameters other than appver = 2400. I don’t have Merrill Lynch accounts so, I can’t help much more, but also try ofxver = 103 and brokerid = mldirect.ml.com

  3. Ken H said

    Thanks. I tried your suggestions as well as several other minor tweaks with no success. The error msg that comes back is always: Your request cannot be completed at this time, for assistance please contact us at 1.800.MERRILL (637.7455).

  4. ameridan said

    Hung Le has noticed a few days ago that Chase has added a tag in the ofx/qfx credit card download that can’t be processed within Money. If you see ❮category❯ tags in the download, it is very simple to add to the bottom section of your scrubber.py file so that they will be removed.

RSS feed for comments on this post

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: