Difference between revisions of "OFX Direct Connect Bank Settings"

From GnuCash
Jump to: navigation, search
(ORG, Bank Code, etc)
(added quicker wget way to get getfidata.sh script)
Line 57: Line 57:
  
 
Use the commands:
 
Use the commands:
 +
 +
    wget http://www.jongsma.org/gc/bankinfo/getfidata.sh.gz
 +
 +
then
  
 
     gzip -d getfidata.sh.gz
 
     gzip -d getfidata.sh.gz

Revision as of 22:06, 7 December 2006

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. 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
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
Chase (credit card) https://onlineofx.chase.com/chase.ofx 10898
Citi Bank (credit card) https://secureofx2.bankhost.com/citi/cgi-forte/ofx_rt?servicename=ofx_rt&pagename=ofx 24909 Citigroup
Discover Card (credit card) https://ofx.discovercard.com/ 7101 Discover Financial Services
PNC Bank (bank - Wash DC area) https://www.oasis.cfree.com/test.ofxgp 4501

Note on BofA: The information listed here are verified to work for BofA California. 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)

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

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.

Auto-Download everything:

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/.

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.