Difference between revisions of "OFX Direct Connect Bank Settings"

From GnuCash
Jump to: navigation, search
m (Adding settings for International Bank of Commerce)
Line 208: Line 208:
  
 
'''Note on Charles Schwab Bank:''' Does not work with brokerage accounts at Charles Schwab.  [[User:Chad.burrus|Chad.burrus]] 11:07, 12 January 2008 (EST)
 
'''Note on Charles Schwab Bank:''' Does not work with brokerage accounts at Charles Schwab.  [[User:Chad.burrus|Chad.burrus]] 11:07, 12 January 2008 (EST)
 +
 +
'''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: <nowiki>[https://ofx.scbwab.com/cgi_dev/ofx_server]</nowiki>
 +
(Some of this info came from: [http://www.jongsma.org/gc/bankinfo/fidata.utf-16.tgz])
 +
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. --[[User:Jdbosmaus|Jdbosmaus]] 01:38, 21 February 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 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.

Revision as of 06:38, 21 February 2008

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 try google. When you do find the right settings, please add them to this page!

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 Bank of America
BECU (bank) https://www.becuonlinebanking.org/scripts/serverext.dll 1001 becu 325081403
CapitalOne (Banking) https://onlinebanking.capitalone.com/scripts/serverext.dll 1001 Hibernia
Charles Schwab Bank (bank) see note below https://ofx.schwab.com/bankcgi_dev/ofx_server 101 ISC 7263 121202211


Chase (credit card) https://onlineofx.chase.com/chase.ofx 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
E*Trade Bank https://ofx.etrade.com/cgi-ofx/etradeofx 9989 ETRADE BANK 256072691
First IB (Banking) https://ofxcore.digitalinsight.com/servlet/OFXCoreServlet 074014187 DI
First Tech CU (bank and credit card) https://ofx.firsttechcu.com/ 2243 First Tech Credit Union 323274160
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


NetBank (from MoneyDance Archive) https://netbankofx.com/ofx_security/ofx_security_server.dll 988 988
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

Note on BofA: 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 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)

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: [2]) 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)

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

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.