OFX Direct Connect Bank Settings

Here are some settings for banks and credit cards. Follow this link for instructions on setting up OFXDirectConnect in GnuCash 2.

"Bank Name" may not be significant. "ORG" may be case sensitive. "Bank Code" is probably not used for credit cards, but may be critical for bank accounts. It is usually the same as the bank's ABA routing number. You can find routing numbers here: [1]. Userid and Username are usually the same.

If your bank does not appear on the list, you can attempt to contact your bank (usually does not work). Or you can check out http://www.ofxhome.com/ which has a searchable database of OFX information. When you do find the right settings, please add them to this page! Intuit lists banks' OFX support at [2]. There are different icons for Direct Connect and Web Connect.

American Express (credit card)

	ORG	FID	FIPID	Bank Code	OFX Version
Codes	AMEX	3101
URL	https://www99.americanexpress.com/myca/ofxdl/us/download?request_type=nl_desktopdownload
Notes	"ORG" must be AMEX (case sensitive).

Bank of America, California (bank and credit card)

	ORG	FID	FIPID	Bank Code	OFX Version
Codes	HAN	6805		121000358
URL	https://ofx.bankofamerica.com/cgi-forte/ofx?servicename=ofx_2-3&pagename=bofa
Notes	The information listed here was verified to work for BofA California. It will most likely work with BoA accounts in other States. You need to call 1-800-792-0808 and ask the CSR to "enable transaction downloading in Quicken". There may be a $9.95 monthly charge for this convenience for consumer customers. But the fee is waived for me because I have monthly direct deposit. Once enabled, you can download transactions for all the accounts that are linked in your online banking. Other information you may need to set up the OFX Direct Connect is BankID = "121000358". --DS 14:08, 5 December 2006 (EST) As of 2007-10-29 direct connect is not available in WA and ID, it should function in all other states. Additional settings: Open the AqBanking wizard, and edit or create a new user on the Users tab. Select the OFX tab and make sure the "Expert Settings" section includes: APPID: QWIN APPVER: 1800 Without these, GnuCash could not connect. After setting these values, success. Last checked 2009-10-22. HTH, Eiríkr 06:10, 23 October 2009 (UTC)

Bank	Server URL	FID	ORG	FIPID	bankCode
American Express (credit card)	https://www99.americanexpress.com/myca/ofxdl/us/download?request_type=nl_desktopdownload	3101	AMEX
Bank of America, California (bank and credit card), see note below	https://ofx.bankofamerica.com/cgi-forte/ofx?servicename=ofx_2-3&pagename=bofa	6805	HAN		121000358
Bank of America, New York(credit card), see note below	https://ofx.bankofamerica.com/cgi-forte/ofx?servicename=ofx_2-3&pagename=bofa	6805	HAN		051000017
Bank of the West	https://olbp.bankofthewest.com/ofx0002/ofx_isapi.dll	5809	BankWest Corp		121100782
BECU (bank)	https://www.becuonlinebanking.org/scripts/serverext.dll	1001	becu		325081403
CapitalOne (Banking)	https://onlinebanking.capitalone.com/ofx/process.ofx	1001	Hibernia		065002030
Charles Schwab Bank (bank) see note below	https://ofx.schwab.com/bankcgi_dev/ofx_server	101	ISC	7263	121202211
Chase (credit card)	https://ofx.chase.com	10898	B1
Citi Bank (credit card)	https://secureofx2.bankhost.com/citi/cgi-forte/ofx_rt?servicename=ofx_rt&pagename=ofx	24909	Citigroup
Citi Bank (Banking)		2102	Citibank
Discover Card (credit card)	https://ofx.discovercard.com/	7101	Discover Financial Services		031100649
E*Trade Bank	https://ofx.etrade.com/cgi-ofx/etradeofx	9989	ETRADE BANK		256072691
Fidelity Investments	https://ofx.fidelity.com/ftgw/OFX/clients/download	7776	fidelity.com
First IB (Banking)	https://ofxdi.diginsite.com/cmr/cmr.ofx	074014187	DI		074014187
First Tech CU (bank and credit card)	https://ofx.firsttechcu.com/	2243	First Tech Credit Union		323274160
First Tennessee (Banking)	https://ofx.firsttennessee.com/ofx/ofx_isapi.dll	2250	Online Financial Services
Golden1 Credit Union	https://homebanking.golden1.com/scripts/serverext.dll	1001	Golden1		321175261
International Bank of Commerce (bank)	https://ibcbankonline2.ibc.com/scripts/serverext.dll	1001	IBC	6127	114902528
LaSalle Bank	https://www.oasis.cfree.com/1101.ofxgp	1101	LaSalleBankMidwest		071004239
National City (bank and credit card)	https://ofx.nationalcity.com/ofx/OFXConsumer.aspx	5860	NATIONAL CITY
NetBank (from MoneyDance Archive)	https://netbankofx.com/ofx_security/ofx_security_server.dll	988	988
North Carolina State Employees' Credit Union	https://onlineaccess.ncsecu.org/secuofx/secu.ofx	1001	SECU	102	253177049
OptionsXpress, Inc	https://ofx.optionsxpress.com/cgi-bin/ox.exe	10876	10876
Patelco Credit Union	https://ofx.patelco.org	2000	Patelco Credit Union	5412	321076470
PNC Bank (bank - Wash DC area)	https://www.oasis.cfree.com/test.ofxgp	4501	ISC
TDAmeritrade (Investment)	https://ofxs.ameritrade.com/cgi-bin/apps/OFX	5024	Ameritrade
Scottrade (Investment)	https://ofxstl.scottsave.com	777	Scottrade
USAA (Banking)	https://service2.usaa.com/ofx/OFXServlet	24591	USAA	5874
Vanguard (Investment)	https://vesnc.vanguard.com/us/OfxDirectConnectServlet	1358	The Vanguard Group
Wachovia (Information)	https://pfmpw.wachovia.com/cgi-forte/fortecgi?servicename=ofx&pagename=PFM	4309	Wachovia
Wells Fargo Bank	https://www.oasis.cfree.com/3001.ofxgp	3001	Wells Fargo
Zions Bank (Instructions)	https://quicken.metavante.com/ofx/OFXServlet	1115	244-3		124000054
La Banque Postale	https://ofx.videoposte.com Il suffit de paramétrer l'url du serveur OFX et de renseigner son n° de compte et son mot de passe. Les autres paramètres (FID, code Bank ne sont pas nécessaires

Note on BofA, CA: The information listed here was verified to work for BofA California. It will most likely work with BoA accounts in other States. You need to call 1-800-792-0808 and ask the CSR to "enable transaction downloading in Quicken". There may be a $9.95 monthly charge for this convenience for consumer customers. But the fee is waived for me because I have monthly direct deposit. Once enabled, you can download transactions for all the accounts that are linked in your online banking. Other information you may need to set up the OFX Direct Connect is BankID = "121000358". --DS 14:08, 5 December 2006 (EST) As of 2007-10-29 direct connect is not available in WA and ID, it should function in all other states.

Note on BofA, NY: As of 2009-04-06: Shown here are the 'settings.conf' entries which allow download for BofA credit card accounts out of New York. A call was required to enable Quicken download--there was initial resistance to attempting to enable this for a credit card only account. They didn't balk at the mention of GnuCash, but mentioned they didn't have instructions to assist in setup. There was no mention of any monthly fee associated with having the service enabled. This may work for accounts outside of NY (YMMV). After entering the bankName as the bankCode (051000017) the account download feature works. Once the accounts are downloaded and assigned then the transactions can be downloaded. (This is all from GnuCash 2.2.8. after following the instructions for setting up OFXDirectConnect in GnuCash 2 with respect to correcting OFX download failures on Windows.)

  users {
    user {
      int  uniqueId="335"
      char backendName="aqofxconnect"
      char userName="<your name>"
      char userId="<your id>"
      char customerId="<your id>"
      char country="US"
      char bankCode="051000017"
      int  lastSessionId="0"
      data {
        backend {
          char fid="6805"
          char org="HAN"
          char serverType="https"
          char serverAddr="https%3A%2F%2Fofx.bankofamerica.com%2Fcgi%2Dforte%2Fofx?servicename%3Dofx%5F2%2D3%26pagename%3Dbofa "
          char flags="account%5Flist", "statements"
        } # backend
      } # data
    } # user
  } #users
  accounts {
    account {
      int  uniqueId="336"
      char country="US"
      char bankCode="051000017"
      char accountNumber="<cc number>"
      int  user="335"
      char bankName="051000017"
      int  accountType="2"
      char accountName="Credit card <cc number>"
      char provider="aqofxconnect"
      provider {
      } # provider
    } # account
  } # accounts

Note on American Express: "ORG" must be AMEX (case sensitive).

Note on Charles Schwab Bank: Does not work with brokerage accounts at Charles Schwab. Chad.burrus 11:07, 12 January 2008 (EST)

Note on Capital One - credit card: Customer service states that Capital One does not support Direct Connect services for credit card accounts (as of 6/15/09). However, a manual download of transactions from the web browser online access in ofx format, and subsequent import into GnuCash, is possible and works well.

Further note on Charles Schwab: I have been able to access a Schwab Brokerage account with the following settings: FID: 5104; ORG: ISC; Broker ID: Schwab.com; Server URL: [https://ofx.scbwab.com/cgi_dev/ofx_server] (Some of this info came from: [3]) Using this connection setup I can connect and download the correct account numbers in aqbanking druid. However when I try to download balance or transaction info from the Gnucash account register, the download appears to run, logs "success," but then Gnucash crashes. --Jdbosmaus 01:38, 21 February 2008 (EST)

[https://ofx.scbwab.com/cgi_dev/ofx_server] is phishing site, they are stealing passwords. It's not a schwab website. --Kazia 17:34, 15 November 2008 (EST)

Note on Chase: OFX access may need to be enabled by visiting https://resources.chase.com/secure/CustomerCenter.aspx Customer Center / Reference Center / Tools / Activate Money, Quicken, etc.

Note on E*Trade: Only seems to work with brokerage accounts. E*Trade has another ABA number you might try as the bankCode 056073573, this Server URL is also mentioned https://64.14.19.49/DataFeedAPI/ , also you could try a brokerId of "etrade.com". This link says that E*Trade bank only supports Web Connect not OFX http://web.intuit.com/personal/quicken/details.cfm?type=basic&fidetails=E%2ATrade%20Bank&qwid=qw1600&qmid=qm1600&qbid=qb1700&qbmid=qbm1700&country=

Note on U.S. Bank: Fee $3.95/month for home user, $9.95-12.95/month for business.

Note on Vanguard: Set HTTP Version to 1.1 (1.0 will not work)

Note on Wells Fargo: You must enable (and pay for) OFX access to your account. Instructions here. If you have a PMA relationship contact your Wells banker, they may waive the OFX access fees.

OFX DirectConnect information download

Extensive (and probably near-complete) OFX DirectConnect information can also be auto-downloaded to your computer from a major accounting software provider's web archives by using the script found at http://www.jongsma.org/gc/. This script uses the programs curl and tidy (on debian/ubuntu apt-get install curl tidy). If you don't have these programs installed, the error messages are cryptic, so if it is not working first verify you have curl and tidy installed.

Use the commands:

   wget http://www.jongsma.org/gc/bankinfo/getfidata.sh.gz

then

   gzip -d getfidata.sh.gz

• open up getfidata.sh in your favorite editor

• find and replace "2006" with "2008" to retrieve more updated xml files

• replace VER=6 with VER=9

then

   bash getfidata.sh

This will download, according to the above webpages, "thousands of XML files," however finding this information on the web is difficult at best.

Once the files are downloaded, you will have a "fidata" zip file. Unpack it, and inside you will find three xml files (if you have all three dependant programs, as listed on the jongsma.org webpage), bank.xml, brokerage.xml and creditcard.xml. Open the one you want to search an institution for (such as in Firefox), search for your bank's name. Within that xml listing, you will find it's "<guid>," which corresponds to the xml file number under the "fi" directory you will see alongside these three main xml files.

Open the number listed as the "<guid>" for your bank: "<guid>6756</guid>" corresponds to 6756.xml in the fi folder.

This file will contain the information needed to get GNUCash's OFX DirectConnect working with your bank's OFX DirectConnect feature.