Topic: Wells Fargo Bank

As of 1 December 2011, Wells Fargo Bank made some changes.  I found that in addition to changing the URL, which is correct now in the database, I also had to specify APPID=QWIN and APPVER=1900 before I could download transactions.  Thanks to Martin Preuss and the gnucash-user mailing list, these values for different versions of Intuit software are offered.

- Intuit Quicken Windows 2011 (APPID=QWIN, APPVER=2000, Header Ver=102)
- Intuit Quicken Windows 2010 (APPID=QWIN, APPVER=1900, Header Ver=102)
- Intuit QuickBooks Windows 2008 (APPID=QBW, APPVER=1800, Header Ver=102)
- Intuit Quicken Mac 2008 (APPID=QMOFX, APPVER=1700, Header Ver=102)

Re: Wells Fargo Bank

I can't connect to Wells Fargo Bank. It keeps giving me "unable to log into bank with those credentials". I'm able to use that same login info with another program and it connects just fine. Any ideas I can try?

Re: Wells Fargo Bank

At some point I had to set up an account name instead of using my account number as the User Id.  Here are the settings I am using right now, which work.  I am running gnucash 2.4.10 (r21973) on Debian GNU/Linux 7.0 (testing).  Any fields I have omitted are left blank.

User Setup
  User Settings
    User Name: (My name - I don't think it matters what you put here)
    User Id: The same ID I user on the web site
  Bank Settings
    Bank Name: Wells Fargo Bank
    FID: 3000
    ORG: WF
    Server URL: https://ofxdc.wellsfargo.com/ofx/process.ofx
  Application Settings
    Application ID: QWIN
    Application Version: 2000
    Header Version: 102
Account
  Account Number: (my account number)
  Currency: (I can set USD, but this always says EUR)
  Account Type: Checking Account
  Country: United States of America (US)
  Bank Code: 111900659
  Bank Name: 111900659 (I don't know whether this is needed or not)
  Selected User: (select the correct user set up above)

Other settings may work, but this is what works for me.  I know it seems to be saying your password is wrong, but it may just give that message if anything goes wrong with logging in.  If you are copying and pasting your password, you might try carefully typing it in.  Sometimes applications use different characters instead of what you might expect.  Also try those credentials on the web site and see if they work.  Maybe it will give you another error.  It may also be possible that your password is too long or too short and they have changed the requirements.  Right now the web site says the password "Must be 6-14 characters and contain at least one letter and one number. It cannot contain nine or more numbers."

Good luck.

Re: Wells Fargo Bank

Hello,

I keep getting Bad Request when I try to connect to Wells Fargo. I have tried various appIDs, appVer, ORG and FIDs I could find, but keep getting the same response.

My Quicken connects and downloads just fine though. So I must be missing something! My calls to Wells Fargo customer support were to no avail. They are not equipped to give any technical support, except for setting up quicken.

Following is the request I'm sending. I will be very greateful if any one can look at it:

OFXHEADER:100
DATA:OFXSGML
VERSION:102
SECURITY:NONE
ENCODING:USASCII
CHARSET:1252
COMPRESSION:NONE
OLDFILEUID:NONE
NEWFILEUID:NONE

<OFX>
    <SIGNONMSGSRQV1>
        <SONRQ>
            <DTCLIENT>20130618154823[West Asia Standard Time:West Asia Standard Time]
            <USERID>*******
            <USERPASS>********
            <LANGUAGE>ENG
            <FI>
                <ORG>WF
                <FID>12721
            </FI>
            <APPID>QBW
            <APPVER>2100
        </SONRQ>
    </SIGNONMSGSRQV1>
    <SIGNUPMSGSRQV1>
        <ACCTINFOTRNRQ>
            <TRNUID>685641C1-6BFB-1014-A19B-C749A5E791D5
            <ACCTINFORQ>
                <DTACCTUP>19700101
            </ACCTINFORQ>
        </ACCTINFOTRNRQ>
    </SIGNUPMSGSRQV1>
</OFX>

Re: Wells Fargo Bank

Am using PocketSense scripts with MS-Money sunset edition.  All has been well for a couple of years until recently. I've been struggling of late to make a successful connection to Wells Fargo. I received a message indicating "software version is not supported."  It may not be obvious to everyone, but download support for Quicken versions are phased out after 2 years. Therefore, it would seem we have to keep updating the APPVER field about once every 2 years, since we are "tricking" Wells Fargo into thinking we are downloading data for Quicken.  As of tonight, I guessed at the following and now I am able to connect/download my accounts.  (Next year or the year after I will change 2200 to something like 2400.)
    appid      : QWIN
    appver     : 2200

I'm not certain whether it is necessary or not, but I went ahead and ran through the PocketSense setup.py script and re-entered each account at Wells Fargo before testing.  Hope this helps anyone else out there with similar troubles.

Re: Wells Fargo Bank

I just had to change my appver to 2300 to keep it working with Wells Fargo Bank (fid 3000).  I am using gnucash 2.6.12 on Debian GNU/Linux testing.

7 (edited by mdegive 2017-03-04 10:22:27)

Re: Wells Fargo Bank

Does anybody know what account type is for an investment account?
for example SAVINGS, CHECKING, ???

I am wondering also if the OFX is different since it is an investment account? something like this maybe?

    <INVSTMTMSGSRQV1>
        <INVSTMTTRNRQ>
            <TRNUID>${TRANS_ID}
            <INVSTMTRQ>
                <INVACCTFROM>
                    <BROKERID>wellsfargo.com
                    <ACCTID>${ACCT_ID}
                </INVACCTFROM>
                <INCTRAN>
                    <DTSTART>${START_DATE}</DTSTART>
                    <DTEND>${END_DATE}</DTEND>
                    <INCLUDE>Y
                </INCTRAN>
                <INCOO>N
                <INCPOS>N
                <INCBAL>Y
            </INVSTMTRQ>
        </INVSTMTTRNRQ>
    </INVSTMTMSGSRQV1>

8 (edited by humblepie 2017-06-20 14:47:39)

Re: Wells Fargo Bank

In case anyone else has suddenly started having issues with Wells Fargo about mid-June 2017, here is what I did:
Changed appver from 2400 to 2600 (though this by itself did not do the trick), then I added:
    ofxver     : 103

These changes I made to PocketSense scripts....Sites.dat file to all entries for banking, credit, and brokerage entries for Wells Fargo.
Good luck out there. Long live Microsoft Money!

Re: Wells Fargo Bank

Yes, also having problems with Wells Fargo starting in June 2017.  I am using GnuCash v2.6.14 on Mac (Intel).  I was getting Generic Error 2000 no matter what settings I used in aqbanking setup.  I tried deleting and recreating the account but that also failed. 

I called Wells Fargo and they said Quicken 2014 is no longer supported and it was officially tuned off in June.  You have to use Quicken 2015, 2016, or 2017. 

So, The OnLine Banking Settings for GnuCash for Wells Fargo have changed as follows:

User Settings tab - you must have a Client UID so if this field was blank before you now need a value

Bank Settings tab - no changes required
Bank Name=Wells Fargo Bank
Broker Id=<leave it blank>
FID=3000
ORG=WF
Server URL=https://ofxdc.wellsfargo.com/ofx/process.ofx

User Settings tab - must change Application Version and Header version
Application Id=QWIN
Application Version=2600 (Represents Quicken 2017)  (previous setting was 2300 which Represents Quicken 2014)
Header Version=103 (previous settings was 102)
Special Settings are all blank (or not changed from default)



humblepie wrote:

In case anyone else has suddenly started having issues with Wells Fargo about mid-June 2017, here is what I did:
Changed appver from 2400 to 2600 (though this by itself did not do the trick), then I added:
    ofxver     : 103

These changes I made to PocketSense scripts....Sites.dat file to all entries for banking, credit, and brokerage entries for Wells Fargo.
Good luck out there. Long live Microsoft Money!

Re: Wells Fargo Bank

Re "Client UID" where is this obtained? is it just the username or some number assigned by Wells-Fargo?

Re: Wells Fargo Bank

I got my Client UID from here:  https://www.uuidgenerator.net

Re: Wells Fargo Bank

I too am having problem using OFX and WF since mid-June, I tried changing APPVER:2600 and VERSION:103, didn't help, I then added OFXVER:103, did not work either, I then got a Client UID and added CLIENTUID:..., didn't work either.

When I make the call to https://ofxdc.wellsfargo.com/ofx/process.ofx, I get nothing back!

I also downloaded transactions from WF online website in quicken format and when I look at the qfx file, it still has Version: 102

Any Ideas?

13 (edited by shawn 2017-07-01 00:07:50)

Re: Wells Fargo Bank

Did you try deleting and re-creating the account with the new settings?  You can try it with 102 but then remove the ClientID.  102 does not require it and 103 does.   However, with AppVersion 2600 (Quicken 2017) I think it now requires a ClientID to work.  Did you also try older versions of Quicken?  Maybe try APPVER:2400 (Quicken 2015) or APPVER:2500 (Quicken 2016) and APPVER:102

mdegive wrote:

I too am having problem using OFX and WF since mid-June, I tried changing APPVER:2600 and VERSION:103, didn't help, I then added OFXVER:103, did not work either, I then got a Client UID and added CLIENTUID:..., didn't work either.

When I make the call to https://ofxdc.wellsfargo.com/ofx/process.ofx, I get nothing back!

I also downloaded transactions from WF online website in quicken format and when I look at the qfx file, it still has Version: 102

Any Ideas?

Re: Wells Fargo Bank

I tried 102 & 2500, 2600, not working
I created a new user-id and that did not work either
The strange thing is that when I make the OFX call I get nothing back, and this used to work just fine until mid-june

Re: Wells Fargo Bank

I discovered that the problem was I was not using TLS 1.2 which is now required by WF. so if you use CURl, use this:     curl_setopt($curl, CURLOPT_SSLVERSION, 6); //CURL_SSLVERSION_TLSv1_2

Now I get an error back 2000 ERROR We are unable to process your request at this time.

I tried changing the APPVER to 2400, 2500, 2600, but no luck.

Something else must have changed.