[UPDATE 6/4/2020] Now that Discover downloads seem to have permanently been disabled, in case you missed it (April 13th Pocketsense forum comment), Robert has provided an alternate, which involves periodically grabbing the download from Discover’s website. I got a Citi DoubleCash card now (2% cashback vs Discover’s normal 1%) that gets most of my business now, as a form of boycotting Discover Card 🙂
OFX settings for various other financial institutions (in no particular order) that can be copied directly into PocketSense’s sites.dat file
Note [added 3/20/2019]: One observation that I’d like to share is that when setting up new accounts, just because all the accounts for a particular bank show up after entering your username and password, doesn’t mean they will actually function if the routing number differs on some of your accounts. If you have alternate routing numbers for some of your accounts for the same bank (CHASE and PNC in my case), set up CHASE ALT (as an example) in your sites.dat file with all the same info, but using the alternate routing number, and you should find that your downloads for those accounts will then start functioning.
SiteName : DISCOVERCARD #(see acct # article for more)
AcctType : CCSTMT #credit card
fiorg : Discover Financial Services
fid : 7101
url : https://ofx.discovercard.com:443
bankid :
brokerid :
appid :
appver :
mininterval :
SiteName : DISCOVERCARD_IMPORT #(see Pocketsense comment for more)
AcctType : CCSTMT #credit card
fiorg : Discover Financial Services
fid : 9625
url : https://ofx.discovercard.com
bankid :
brokerid :
appid :
appver :
mininterval :
SiteName : DISCOVER BANK #(see acct # article for more)
AcctType : BASTMT #bank accounts
fiorg : Discover Bank
fid : 12610
url : https://ofx.discovercard.com:443
bankid : 031100649
brokerid :
appid :
appver :
mininterval :
SiteName : Bank of America Card
AcctType : CCSTMT #credit card
fiorg : HAN
fid : 5959
url : https://eftx.bankofamerica.com/eftxweb/access.ofx
bankid :
brokerid :
appid :
appver : 2400
ofxver : 103
mininterval :
SiteName : Bank of America
AcctType : BASTMT #bank accounts
fiorg : HAN
fid : 5959
url : https://eftx.bankofamerica.com/eftxweb/access.ofx
bankid : 052001633 #use appropriate routing number
brokerid :
appid :
appver : 2400
ofxver : 103
mininterval :
SiteName : PNC
AcctType : BASTMT #bank accounts
fiorg : PNC
fid : 4501
url : https://www.oasis.cfree.com/4501.ofxgp
bankid : 041000124 #use appropriate routing number and use different login and PIN than web access
brokerid :
appid :
appver :
mininterval :
SiteName : CHASE
AcctType : BASTMT
fiorg : B1
url : https://ofx.chase.com
fid : 10898
bankid : #use appropriate routing number
brokerid :
appid : QWIN
appver : 2400
ofxVer : 103
mininterval :
SiteName : VOYA #user name must be your website login "username + @yourcompany
AcctType : INVSTMT
fiorg : ing-usa.com/
url : https://ofx.voyaplans.com/eofx/server
fid : 1289
bankid : #2543
brokerid :
appid :
appver :
ofxVer :
mininterval :
SiteName : SCHWAB
AcctType : INVSTMT
fiorg : ISC
url : https://ofx.schwab.com/cgi_dev/ofx_server
fid :
bankid :
brokerid :
appid : 2800
appver :
mininterval :
SiteName : PERSHING #untested
AcctType : INVSTMT
fiorg : IMS
url : https://ofx.netxclient.com/cgi/OFXNetx
fid :
bankid :
brokerid : pershing.com
appid :
appver :
mininterval :
SiteName : TD AMERITRADE #see Norm's notes
AcctType : INVSTMT
fiorg : Ameritrade
fid :
url : https://ofxs.ameritrade.com/cgi-bin/apps/OFX
bankid :
brokerid : ameritrade.com
appid :
appver :
mininterval :
SiteName : TD BANKING #see Michael's notes
AcctType : BASTMT #bank accounts
fiorg : CommerceBank
fid : 1002
url : https://ofx.tdbank.com/eftxweb/td.ofx
bankid : #use appropriate routing number and verify Quicken access on website
brokerid :
appid :
appver :
ofxVer : 103
mininterval :
SiteName : AMEX CHARGE CARD
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 : CITI CREDIT CARD
AcctType : CCSTMT # Profile > More Account setting > Manage Desktop Apps and authorize "Quicken Windows"
fiorg : Citigroup
fid : 24909
url : https://mobilesoa.citi.com/CitiOFXInterface
bankid :
brokerid :
appid :
appver :
ofxVer : 103
mininterval:
SiteName : CITI BUSINESS CREDIT CARD
AcctType : CCSTMT #credit card
fiorg : Citigroup
fid : 26389
url : https://mobilesoa.citi.com/CitiOFXInterface
bankid :
brokerid :
appid :
appver :
ofxVer : 103
mininterval:
SiteName : CAPITAL ONE
AcctType : BASTMT #bank accounts
fiorg : Hibernia
fid : 1001
url : https://onlinebanking.capitalone.com/ofx/process.ofx
bankid : 051405515 #use appropriate routing number
brokerid :
appid :
appver :
ofxVer : 103
mininterval:
SiteName : CAPITAL ONE 360
AcctType : BASTMT #bank accounts
fiorg : ING Direct
fid : 31176110
url : https://ofx.capitalone360.com/OFX/ofx.html
bankid : 031176110
brokerid :
appid :
appver :
ofxVer :
mininterval: 180
SiteName : T. ROWE PRICE
AcctType : INVSTMT
fiorg : T. Rowe Price
fid : 40109
url : https://api.public.troweprice.com/ffs-ofx-direct/service/ofx-requests
bankid :
brokerid : troweprice.com
appid :
appver :
ofxVer :
mininterval:
SiteName : REGIONS BANK
AcctType : BASTMT #bank accounts
fiorg : Identity-RFG
fid : 13131
url : https://onlinebanking.regions.com/Ofx/process.ofx
bankid : 261170740 #use appropriate routing number
brokerid :
appid :
appver :
ofxVer :
mininterval:
delay : 3
userAgent: none
SiteName : REGIONS CREDIT CARD
AcctType : CCSTMT #credit card
fiorg : Identity-RFG
url : https://onlinebanking.regions.com/Ofx/process.ofx
fid : 13131
bankid :
brokerid :
appid :
appver :
ofxver :
delay : 3
userAgent: none
SiteName : ING DIRECT BANK
AcctType : BASTMT
fiorg : ING DIRECT
fid : 031176110
url : https://ofx.ingdirect.com/OFX/ofx.html
bankid : 031176110 #use appropriate routing number
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 : ALRIGHT SYSTEMS # (was Hewitt Associates)
AcctType : INVSTMT
fiorg : hewitt.com
url : https://seven.was.alight.com/eftxweb/access.ofx
fid : 242
bankid :
brokerid : Alright
appid :
appver :
mininterval:
SiteName : FIDELITY
AcctType : INVSTMT
fiorg : fidelity.com
url : https://ofx.fidelity.com:443/ftgw/OFX/clients/download
fid : 7776
bankid :
brokerid : fidelity.com
appid :
appver :
mininterval :
timeOffset: # do not use with Cal's scrubber.
SiteName : JANUS INVESTMENTS # account number = the fund number, comma, the 9-digit account number (no spaces)
AcctType : INVSTMT
fiorg :
fid : 6115
url : https://ofx3.financialtrans.com/tf/OFXServer?tx=OFXController&cz=702110804131918&cl=50900132018
bankid :
brokerid : dstsystems.com
appid :
appver :
mininterval:
SiteName : FIDELITY NET BENEFITS
AcctType : INVSTMT
fiorg : nbofx.fidelity.com
BrokerID : nbofx.fidelity.com
fid : 8288
url : https://nbofx.fidelity.com:443/netbenefits/ofx/download
appid :
appver :
minInterval: 30
userAgent: none
SiteName : VANGUARD
AcctType : INVSTMT #investment
fiorg : Vanguard
fid : 15103 #1358 may still work?
url : https://vesnc.vanguard.com/us/OfxDirectConnectServlet
bankid :
brokerid : vanguard.com
appid :
appver :
ofxver : 103
mininterval: 365
SiteName : SEARS CREDIT 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 BANKING # use the access id and PIN provided on the signup page as your username and password; more info here
AcctType : BASTMT #bank
fiorg : USAA Federal Savings Bank
fid : 67811
url : https://df3cx-services.1fsapi.com/casm/usaa/access.ofx
bankid : 314074269
brokerid :
appid :
appver :
ofxVer: 103
dtacctup: 19900101
userAgent: InetClntApp/3.0
clientUID: Your_ClientId_From_The_Allow_Page
mininterval:
SiteName : USAA CREDIT CARD # use the access id and PIN provided on the signup page as your username and password; more info here
AcctType : CCSTMT #credit card
fiorg : USAA Federal Savings Bank
fid : 67811
url : https://df3cx-services.1fsapi.com/casm/usaa/access.ofx
bankid :
brokerid :
appid :
appver :
ofxVer: 103
dtacctup: 19900101
userAgent: InetClntApp/3.0
clientUID: Your_ClientId_From_The_Allow_Page
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 : E*TRADE
AcctType : INVSTMT #investment
fiorg : E*TRADE Financial #Try leaving this out if any problems
url : https://ofx.etrade.com/cgi-ofx/etradeofx
fid :
bankid :
brokerid : etrade.com
appid :
appver : 102
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 :
mininterval:
SiteName : CHASE CREDIT CARD
AcctType : CCSTMT #credit card
fiorg : B1
url : https://ofx.chase.com
fid : 10898
bankid :
brokerid :
appid : QWIN
appver : 2400
ofxver : 103
mininterval:
[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]
[EDIT – Kevin N added settings for Regions Bank on 12/30/2016]
[EDIT – Jon L. updated settings for Bank of America credit card on 10/4/2017]
[EDIT – ameridan added settings for Bank of America checking on 10/4/2017]
[EDIT – CL added settings for Capital One 360 on 12/29/2017]
[EDIT – CL added settings for Janus on 3/30/2018]
[EDIT – Norm Coltri added notes for TD Ameritrade on 4/6/2018]
[EDIT – David Casada added settings for T. Rowe Price on 7/27/2018]
[EDIT – ameridan added settings for Discover Bank on 11/29/2018]
[EDIT – ameridan updated the settings for Citi cards on 9/18/2019]
[EDIT – Ken added the settings for JPMorgan (Chase) You Invest on 10/27/2019]
[EDIT – Michael added the settings for TD Bank on 10/28/2019]
[EDIT – hung le added the port # to Discover url on 11/5/2019]
[EDIT – ameridan updated the url for AmEx credit card on 1/17/2020]
[EDIT – ameridan updated the url for Citicard on 2/27/2020; I commented-out the original url, rather than deleting it, as it hasn’t yet been confirmed that it is no longer functional; also added note: Profile > More Account setting > Manage Desktop Apps, which you need to do while setting up Pocketsense access]
[EDIT – ameridan added note to Schwab on 3/23/2020]
[EDIT – ameridan added settings regarding Discover Card imports on 6/4/2020]
[EDIT – Andrew Dingwall discovered that hung le’s port # trick works on Fidelity url – 6/13/2020]
[EDIT – ameridan updated settings for USAA Federal Savings Bank on 2/11/2021]
[EDIT – CL added account # criteria for Janus on 3/10/2021]
[EDIT – Harold discovered new url for Alright Systems (was Hewitt Associates), and I added all of the settings on 4/25/2021]
[EDIT – new settings for T Rowe Price were discovered today – 11/7/2021]
[EDIT – David Casada discovered settings for E*TRADE, and I added them on 3/5/2022]
[EDIT – Chase settings redacted to reflect removal of OFX server on 10/1/2022, by ameridan on 10/8/2022] – can still download ofx from web portal
[EDIT – Bank of America settings redacted to reflect removal of OFX server per Ken H on 11/6/2022] – can still download ofx from web portal
[EDIT – ameridan updated url for TD BANK on 2/14/2023]
[EDIT – ameridan updated Fidelity Net Benefits and Regions Bank per Ray & Kevin N. on 6/2/2023 (also added Regions Credit Card)]
[EDIT – Cal Learner suggested removing APPVER – 2300 from USAA Banking + USAA Credit Card on 6/22/2023. I also did so for Capital One Investing]
[EDIT – joryde provided VOYA settings on 7/2/2023]
[EDIT – kevin n. recommended changes to Regions Bank on 3/25/2024]
In case no one has posted this previously. I got Chase You Invest to download automatically. Here’s my sites.dat entry:
SiteName : Chase You Invest
AcctType : INVSTMT #brokerage account
fiorg : CWM
fid : 7784
url : https://ofx.chase.com
bankid :
brokerid : chase.com
ofxVer : 103
appid : QWIN
appver : 2400
mininterval:
timeOffset :
For this type of account Chase doesn’t require the same confirmation process as they do for credit cards. Just use the latest PocketSense, enter your Chase ID and password and it returns your account number.
LikeLike
Ken, I don’t know how this slipped past me, but thank you for posting! I don’t know where you found this, but I’ll add it in the article today.
I tried it out, and although it functions fine, I can’t stand how JPMorgan messes it all up, as compared to Schwab. They post interest from CDs into a different sweep account than the Sweep account interest, and none of it stays in the Cash side of the account. I reverted to a backup file and will continue to enter this account’s transactions manually instead. Perhaps if I hadn’t already entered everything manually, I would have accepted their process.
They did require me to verify my Quicken access, just like my bank accounts and credit cards, because it is a unique sites.dat entry. Perhaps you had edited an entry that had already been accepted.
LikeLike
I just void all the money fund transactions after I import them. This leaves the funds in cash and solves the problem you mention.
LikeLike
Ken, I use my X_TRANS function to remove Buys and Sells of my sweep fund. I call it from scrubber.py.
LikeLike
Ken + Cal, the real mess was matching up the sweep funds and investments for the initial download, before it would even begin importing the transactions. One of my investments didn’t even show up (a CD with interest paid at maturity next year). JPMorgan Chase, one of the biggest banking firms in the world, and they can’t follow the standards for ofx reporting.
After my CDs mature, I’m going to close out this account, which I opened on a trial basis anyways. Schwab has spoiled me 😉
LikeLike
hung le reported that by adding port # 443 to Discover’s url in sites.dat, ofx downloads should work once again. I confirmed this and reflected the change in my article.
LikeLike
If you have Apple Card, one option to “import the transactions”.
https://ac2ofx.github.io/ac2ofx/
LikeLike
Looks like some
millennialinexperienced programmer at Citicard is mucking about in the ofx server, as they are redacting the account number (XXXXXX789) in the file output, which naturally doesn’t match up with our account with a real account number (123456789). Fortunately, this particular change isn’t fatal, but they should quit making changes that don’t follow the industry standards.LikeLike
“Looks like some millennial inexperienced programmer at Citicard is mucking about in the ofx server, as they are redacting the account number (XXXXXX789) in the file output,”
Thanks.
That just bit me too in my Windows-scheduled early Tuesday PocketSense run. PocketSense did not automatically bring in the transactions as usual. I manually launched the combined file, and got the popups asking which account this was.
After, I modified the account names to put the last 4 digits at the end of the account name, for easier matching if things change again.
I had seen your post after my scheduled early Saturday PocketSense launch had not had the problem. So I was wondering if that was not going to apply to me.
LikeLike
On Citicard download wee hours today: download had full account number for ACCTID, rather than XXXXXXXXX1234. I wonder if it will stay this way. If I get a change again, I think I will make a scrubber to turn XXXXXXXXX1234 into the actual account number. Of course staying with the actual account number is best.
LikeLike
At 10 am, I was again prompted to match up my redacted Citicard file with my Money acct. (yesterday, the acct # was redacted differently). I knew right away what the issue was, but I don’t have a login on the Quicken Tech Support site, so I haven’t reported the solution, but regardless, I would have expected Quicken to be on top of this! It seems as if Quicken can’t figure it out, when reading comments in their Tech Support – they just say that CC-502 errors are Citi’s problem.
LikeLike
Cal,
Hopefully, Citi will eventually revert their server to use non-redacted credit card account numbers again, but until then, since you’ve had good luck with your standalone scrub routines, can you post one for this Citicard issue?
LikeLike
Since I have not had the problem the last 2 days, let me first show you my site descriptor, which may be the same as yours currently; It is not the same as the one above.
<site>
SiteName : CitiCard
AcctType : CCSTMT #credit card
fiorg : Citigroup
fid : 24909
url : https://mobilesoa.citi.com/CitiOFXInterface
bankid :
brokerid :
ofxVer : 103
appid :
appver :
mininterval:
timeOffset :
</site>
What should be <ACCTID>1234567890123456 is coming in sometimes as
<ACCTID>XXXXXXXXXXXX3456 and sometimes as <ACCTID>XXXXXXXXXXXXX456
What should I do then? Whichever it is, change it to XXXXXXXXXXXXX456 or change it to 1234567890123456 ? If the latter, the code would need to be modified to contain the 16-digit numbers. If just putting in Xs, then the code would not have to be modified.
I am thinking of a generic replacement with a table that has pairs of strings to be replaced with the replacement values.
LikeLike
Yes Cal, that is the same site descriptor as mine. I guess it was never determined for certain whether the original url was no longer working, but I’ll update it anyways.
I think I like the idea of changing either redacted ACCTID string to the actual account #.
LikeLike
OK, try this:
http://s000.tinyupload.com/?file_id=53546724146835642331
(file may disappear if not downloaded for a while) File can be run and does a little stand-alone test.
Replace the account number with your number 4 places. If you have two accounts, add a second pair of lines.
For normal implementation, add these 2 lines in the appropriate sections of scrubber.py:
from ps_subs import make_substitutions
if ‘CITI.COM’ in siteURL: ofx = make_substitutions(ofx)
LikeLike
It works perfectly Cal. I didn’t run it is a standalone, I just added it with the other scripts, and see that the CITI file now has the entire ACCTID once again. Thank you!!
LikeLike
Anyone else unable to download from Fidelity starting today? I even get an error message if I try to add an account. I sure hope they didn’t do anything permanent with their OFX server.
LikeLike
Yup, it is down for me as well. Worked just fine yesterday. Error message in the ofx file: “Access Denied</H1 You don't have permission to access" 😦
Hopefully it is just a maintenance issue…
LikeLike
Ken H.
Andrew Dingwall discovered that hung le’s port # trick works on Fidelity url as well, so I’ve added that addition in the article today. It only worked for Discover for about 6 months, before they changed their strategy again, so who knows how long this will work for Fidelity…
LikeLike
Yep, that did the trick. Whew! At least, for the time being, I’m back in business 🙂 Thanks!
LikeLike
If I delete and re-enter the fidelity account the first download works. But when I attempt a second download I get ACCESS DENIED in the ofx file. And for added fun fidelity immediately blocks my password. Anyone else run into this problem.
LikeLike
By any chance does someone have settings for BBVA USA bank? I recently opened a checking account there but have been unable to get downloads to work (and they only provide .csv and .pdf on their site). The ones I’ve been trying are the ones from Moneydance:
“id” = “md:2840”
“fi_name” = “BBVA USA”
“fi_org” = “BBVA USA”
“fi_id” = “2201”
“bootstrap_url” = “https://olb.bbvausa.com/ofx/api/request”
“uses_fi_tag” = “y”
“app_id” = “QMOFX”
“app_ver” = “2400”
“access_type” = “OFX”
“ofx_version” = “103”
LikeLike
This is all I could find for Quicken, so it doesn’t look hopeful…
18514 18514 18514 BBVA Asset Management https://www.bbvausa.com/ 866-788-4796 https://bbvausa.netxinvestor.com/web/bbvausa/login ACTIVE INVESTMENT,ACCOUNTINFO,401K&DIRECT ACCOUNTINFO,401K&EXP-WEB-CONNECT NOT_QBP NA
04258 04258 04258 BBVA Investments https://bbvausa.netxinvestor.com/web/bbvausa/login 800-239-1930 https://bbvausa.netxinvestor.com/web/bbvausa/login ACTIVE INVESTMENT,ACCOUNTINFO&DIRECT NOT_QBP NA
16489 16489 16489 BBVA Net Cash USA https://www.bbvacompass.com/ 1-800-239-4357 https://www.bbvacompassnetcash.com/local_pibee/KDPOSolicitarCredenciales_en.html ACTIVE BANKING&WEB-CONNECT BANKING,CREDIT,ACCOUNTINFO&EXP-WEB-CONNECT NOT_QBP NA
15829 15829 15829 BBVA USA https://www.bbvausa.com/ 1-800-239-4357 https://www.bbvausa.com/ ACTIVE BANKING,CREDIT,ACCOUNTINFO,PAYMENT&DIRECT NOT_QBP NA
LikeLike
Thanks. I had found those as well. I checked in the Quicken forum and they are able to download. There had been a problem last year, but it was resolved and there’ve been no additional complaints. Oh well, I guess this is one of those that I’ll have to do manually. I’m amazed that they provide Quicken support but don’t let you download a QFX file from their website. Guess I could get a CSV to OFX converter, but that’s more trouble than entering transactions manually.
LikeLike
Anyone else having problems with Schwab downloads? Starting about 4 days ago I can no longer update. Even tried the :443 trick without luck. I’m getting an “Access Denied, You don’t have permission to access” error message in the OFX file. If yours is still working, can you provide me with your sites.dat entry? Thanks.
LikeLike
I just got off the phone talking with Yamal in Schwab IT Tech Support for nearly an hour, and she stated that as of COB on October 16th, 3rd-party access to the ofx server was shutdown to everyone except Envestnet Yodlee, Intuit, and eMoney Advisor. Any other programs that are to be allowed access to the ofx server would need to be registered with Schwab. Since we access via scripts, rather than a program, it sounds like we’re SOL.
Although less convenient, I got her to submit a client request / suggestion that an ofx export option from the Schwab website be reinstated (currently, only CSV is offered), so that clients have some ability to gain access to their own ofx data. Others should do the same!
If, after reading the FAQs offered in the “Learn more” link in the right column of the “Security Center” screen (regarding external client data aggregation), anyone can think of a solution, I would like to hear it, but it does sound like Pocketsense may no longer work with Schwab.
————————————————-
Q: Has Schwab agreed to Data Access terms with any third parties?
A: In 2020, Schwab has communicated, via press release, the successful signing of Data Access Agreements (DAA) with 3 prominent financial technology companies: Envestnet Yodlee, Intuit, and eMoney Advisor. These three companies comprise approximately 70% of data aggregation services used by Schwab clients. Schwab has already provided testing-based access to its API to several data aggregators who have been actively engaged with us to enable adoption of our more secure access method.
We are also actively partnering with several additional leading financial technology companies who share the mutual goal of providing clients with access to their data in a more secure and transparent manner.
For more information please see Charles Schwab Reinforces Its Commitment to Customer Data Protection.
LikeLike
Well, that sucks. I had noticed that the only website based export they currently provide is CSV. I know there are some CSV to OFX conversion apps around. If they aren’t willing to provide an OFX download capability, is anyone familiar and happy with any of the conversion apps? I’m not a programmer, but since we already have old OFX downloads for Schwab, how difficult would it be to write a program that used the data in a CSV file to fill in the appropriate fields to create a usable OFX file? Alternatively, if someone had Quicken installed, is it possible to trap the QFX download and use it in Money?
LikeLike
If you want somebody to consider doing a Schwab CSV to OFX converter, you would want to make a sanitized CSV available. It should be as complete as possible, but have personally identifiable stuff changed. That would be mainly account numbers, you would hope. I don’t know if the CSV would contain transactions from more than one account. I don’t know if the CSV would contain position info or closing prices.
Now some things changed could make it not work, and would frustrate trying to make an OFX converter.
I don’t know who might work on it. Occasionally I feel inspired.
I was hoping that Schwab could be a fallback for using Pocketsense if Fidelity ever went to the third-party dark side. But instead, Fidelity could be an alternative. If they ask what attracted you, let them know that the ability to work with PocketSense and Microsoft Money was big.
Incidentally, many people avoid Mint and similar is to not share their finances with who knows…
LikeLike
I was going to sanitize an older Schwab OFX file, but only the most recent download is in the folder. That’s the one saying I don’t have authorization and, hence, useless. Anyone else out there with an old, good Schwab OFX they can clean up?
LikeLike
To work on a Schwab_CSV2OFX for Money, you would want to sanitize a *CSV*, which would be currently available.
tinyupload.com is a way to make a sanitized file available.
It could be totally synthetic, but depending on what the CSV has in it, synthetic might be really hard to get consistent. If the CSV is too simple, it would be missing a lot of the stuff that an OFX/QFX file has in it.
It may be too hard for me, but there may be somebody who could do it. Python would make people more comfortable, because more people know how to read the code.
LikeLike
Duh! Of course it’s the CSV file you’d need. And here it is: http://s000.tinyupload.com/index.php?file_id=92464166149760984208
LikeLike
Since Quicken is allowed access to Schwab’s ofx server, perhaps we need to do a better job of emulating Quicken (tweak the App and Version data?)
EDIT: I tried the current QWIN and 2900, but still got the Access Denied message.
LikeLike
My guess is it’s more complicated than that. Schwab is probably validating the server that’s making the OFX request. Nothing we’ll ever be able to fake.
LikeLike
Another thought: Since in addition to Quicken, Intuit now owns Mint, a “free, no-frills budgeting app”, would it be worth using that to get our ofx data? Does anyone have experience with Mint? Can you access the ofx data that Mint obtains, or does it remain on Intuit servers?
LikeLike
David Casada discovered settings for E*TRADE, and I added them on 3/5/2022.
LikeLike
I can report that Money Sunset Biz works fine offline in Windows11
LikeLiked by 1 person
Thank you. It is reassuring to know, as Microsoft could force that on us someday.
LikeLike
Has anyone else started experiencing issues with downloading from Chase (both banking and credit cards) using PocketSense? Starting a few days ago I’m getting the following error message:
CHASE : xxxxxxxxxxxxxx : Getting records since: 20220907
** An ERROR occurred sending POST request to ofx.chase.com
Exception type :
Exception val : [Errno 11001] getaddrinfo failed
I even tried deleting and re-adding the account and PocketSense closes as soon as I enter the account password.
LikeLike
Chase seems to have shutdown their OFX server. I addressed this in my Chase article https://microsoftmoneyoffline.wordpress.com/2018/01/07/chase-ofx-downloads/ 😦
LikeLike
Thanks! Don’t know why I didn’t see that yesterday.
LikeLike
Is anyone able to download transactions for US Bank credit card accounts? I recently opened a credit card account and can’t seem to find the OFX settings to add it to PocketSense. It looks like downloads are supported judging from the entry in the Quicken OFX settings list. I’ve gleaned all I could from an OFX download from their site, but can’t get it to work. I’m probably using the wrong URL as the one from OFX Home doesn’t work. In fact, my download shows the FID to be 1402 whereas the OFX Home shows it to be 1401. I’ve tried both without success.
As always, any help is appreciated. And Happy Holidays to all!
LikeLike
Ken, Here is what shows up in Moneydance. Hope it helps:
“ofx_version” = “102”
“uses_fi_tag” = “y”
“access_type” = “OFX”
“fi_name” = “US Bank (U.S. Bank – PFM Direct Connect)”
“bootstrap_url” = “https://www.oasis.cfree.com/fip/genesis/prod/01401.ofx”
“fi_id” = “1401”
“fi_org” = “ISC”
“app_id” = “QWIN”
“app_ver” = “2700”
“use_file_uids” = “n”
“use_bp_file_uids” = “n
LikeLike
Thanks, but I had tried that and several variations with no success. I think the only way I’m going to get this to work is from someone who is already successful.
On a somewhat related topic, has anyone posted Robert’s .csv to .ofx converter? Or are you aware of another one that works and can be linked to import into Money through PocketSense? The comments on the Pocketsense blog that use a Linux link to Mint are just too technical for me.
LikeLike
After reading https://community.quicken.com/discussion/7893743/downloading-transactions-from-us-bank , I think things may have changed in May. They charge $3.95 a month to access your data into Quicken?
LikeLike
I’m happy to report that Fidelity still works with Pocketsense, and not only is it a breeze to setup a new account, but it is easy to transfer investments (and cash) as well. So for those Schwab investments that produce monthly transactions that have to be manually entered (vs semi-annually), guess who’s getting my business now?
LikeLike
Keep your fingers crossed. I received an email from Fidelity a few weeks ago saying they’re upgrading their security in the near term. They didn’t give a timeframe for implementation so I don’t know if it’s already in place. If it is then we’re all good. If not then it remains to be seen if we’ll be able to use Pocketsense.
LikeLike
Ken: “upgrading their security” sounds scary to me.
I am afraid thay will come up with a system where they will not allow you to access your data, but have a list of third parties that you can allow to share your data, and who will then give your information to you.
Accounts_History.csv
LikeLike
I thought I’d post the email I received from Fidelity so that people can be aware. Fidelity doesn’t provide a means to directly download OFX files with transaction data. So, if the ability to use Pocketsense goes away then I’m probably going to be doing a whole lot less trading (which may be a good thing. 😉
LikeLike
replying to Cal’s comment 😉
…who will then SELL your information to you.
Ken, I think you may be right. If that happens, I’ll just switch everything back and delete my Fidelity account.
LikeLike
I just got a CitiBusiness credit card. I used to have one and just reused the existing sites.dat entry. Unfortunately, I’m getting the message: An error occurred requesting accounts from the site. Please check username and password. Here’s the entry I’m using (which is actually what I posted here back in 2019 🙂
SiteName : CITI BUSINESS CARD
AcctType : CCSTMT #credit card
fiorg : Citibank
fid : 26389
url : https://mobilesoa.citi.com/CitiOFXInterface
bankid :
brokerid :
appid :
appver :
ofxver : 103
mininterval:
Does anyone have a sites.dat entry for CitiBusiness credit cards that is currently working?
Thanks!
LikeLike
Logon to the website > Profile > More Account setting > Manage Desktop Apps
LikeLike
Thanks, I did that and it still doesn’t work. I also went through the various entries listed on your website for Money Dance, OFX home, etc. with no luck. If someone has a working sites.dat entry for Citibusiness credit cards can you post it? I’ll copy exactly what’s working and see if I can get it going for me.
LikeLike
Can you logon to their webpage and download qfx? If so, study the file for other clues. I don’t have a Citibusiness credit card, so not able to give an actual answer.
LikeLike
The only thing I found in the download was a bankID #. I added that to the sites.dat entry with no effect. It’s not the end of the world, but it’d be one more account I have to download manually (which you know is a pain). Do you see anything? (all left and right carat marks deleted)
OFX
SIGNONMSGSRSV1
SONRS
STATUS
CODE0
SEVERITYINFO
/STATUS
DTSERVER20230428011823
LANGUAGEENG
/SONRS
/SIGNONMSGSRSV1
BANKMSGSRSV1
STMTTRNRS
TRNUID0
STATUS
CODE0
SEVERITYINFO
/STATUS
STMTRS
CURDEFUSD
BANKACCTFROM
BANKID073456789
ACCTIDXXXXXXXXXXXX5141
ACCTTYPECREDITLINE
/BANKACCTFROM
BANKTRANLIST
DTSTART20230425000000
DTEND20230426235959
STMTTRN
TRNTYPEDEBIT
DTPOSTED20230425090000
TRNAMT-10.36
FITID20230425090001
NAMEWALGREENS #6700 VAN NUYS CA
/STMTTRN
LikeLike
That output seems more like an AmEx or Home Equity Line (ACCTTYPECREDITLINE)? rather than CCSTMT.
LikeLike
I wondered about that but it’s the same output as a personal card I have from Citi that does work. Maybe someone else will respond with a working sites.dat entry. Otherwise, I’ll just do manual downloads. As always, greatly appreciate your help.
LikeLike