Re: [GNC] Almost ready to give up
Thanks for the responses. Unfortunately, I really need this to work. I've got numerous accounts with multiple banks and several different credit card companies. I have the same problem with all of them. I have been doing this for 2 months now and the reconciliation process takes 5-10 times longer now than it did with Quicken. As much as I hate Quicken, if I can't get aqbanking working properly, I will have to go back to Quicken because I'm running out of time and patience with this setup. As far as I can tell, I'm not even pulling a certificate and the process isn't even going out to the net. Unfortunately the lack of support and out of date documentation makes this nearly impossible to use as a viable solution. I would much rather pay for something that works and has support, than use something that is free, but doesn't work. AQbanking is the software that is supposed to connect the bank to the software. If it can't, they only have half a solution and I'll have to try to find something else. Thanks, Mike On 1/23/2019 6:10 PM, Michael Mantei wrote: I really want to get away from Quicken. I've been trying gnucash for a little over 2 months now, but I can't get the bank transfers to work. I'm no closer now than I was 2 months ago. This is where I am at... 0. I'm using gnuCash versioin 3.4 and the bundled aqbanking on a Windows 10 PC 1. I generated a version 4 UUID at https://www.uuidgenerator.net/version4 2. I entered my bank account username in both the User Name and User ID fields 3. I entered the generated UUID in the user setting ClientUId field in the aqbanking wizard, without any dashes 4. On the Bank Settings tab, I searched for JPMorgan Chase Bank and let it fill the fields. 5. On the Application Settings tab I have the Application ID set to QWIN, the Application Version set to 2700 and the Header Version set to 103. 6. I save this info then exit out. After re-entering gnucash and restarting the aqbanking wizard, I go to the Bank Settings tab and click on Retrieve Account List. 7. I am prompted for my password end enter it. I then see the following: 21:51:30 Saving communication log to /tmp/ofx.log 21:51:30 Sending request... 21:51:30 Using GnuTLS default ciphers. 21:51:30 TLS: SSL-Ciphers negotiated: TLS1.2:ECDHE-RSA-AES-256-GCM:AEAD 21:51:30 Signer not found 21:51:30 Certificate is not trusted 21:51:30 Waiting for response... 21:51:30 Operation finished, you can now close this window. The OFX.LOG file contains the following: Sending: - OFXHEADER:100 DATA:OFXSGML VERSION:103 SECURITY:NONE ENCODING:USASCII CHARSET:1252 COMPRESSION:NONE OLDFILEUID:NONE NEWFILEUID:20190122215110.000 20190122215110.000MYUSERID MYPASSWORD ENGChase Bank1601QWIN27001df59207be3d4a6aa416de9233639b2d20190122215110.000119691231 8. This is all I ever see, regardless of how often I do it. There are no messages available on the Chase website. Quicken works fine, but AQBanking gives me nothing. 9. I've tried everything I can think of for 2 months, but my knowledge of the products is very limited and I've figured nothing out other than it won't work. 10. I've tried posting to what appear to be aqbanking message lists, but have no luck getting my posts to take. Any help would be appreciated. Thanks, Mike ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Almost ready to give up
I really want to get away from Quicken. I've been trying gnucash for a little over 2 months now, but I can't get the bank transfers to work. I'm no closer now than I was 2 months ago. This is where I am at... 0. I'm using gnuCash versioin 3.4 and the bundled aqbanking on a Windows 10 PC 1. I generated a version 4 UUID at https://www.uuidgenerator.net/version4 2. I entered my bank account username in both the User Name and User ID fields 3. I entered the generated UUID in the user setting ClientUId field in the aqbanking wizard, without any dashes 4. On the Bank Settings tab, I searched for JPMorgan Chase Bank and let it fill the fields. 5. On the Application Settings tab I have the Application ID set to QWIN, the Application Version set to 2700 and the Header Version set to 103. 6. I save this info then exit out. After re-entering gnucash and restarting the aqbanking wizard, I go to the Bank Settings tab and click on Retrieve Account List. 7. I am prompted for my password end enter it. I then see the following: 21:51:30 Saving communication log to /tmp/ofx.log 21:51:30 Sending request... 21:51:30 Using GnuTLS default ciphers. 21:51:30 TLS: SSL-Ciphers negotiated: TLS1.2:ECDHE-RSA-AES-256-GCM:AEAD 21:51:30 Signer not found 21:51:30 Certificate is not trusted 21:51:30 Waiting for response... 21:51:30 Operation finished, you can now close this window. The OFX.LOG file contains the following: Sending: - OFXHEADER:100 DATA:OFXSGML VERSION:103 SECURITY:NONE ENCODING:USASCII CHARSET:1252 COMPRESSION:NONE OLDFILEUID:NONE NEWFILEUID:20190122215110.000 20190122215110.000MYUSERID MYPASSWORD ENGChase Bank1601QWIN27001df59207be3d4a6aa416de9233639b2d20190122215110.000119691231 8. This is all I ever see, regardless of how often I do it. There are no messages available on the Chase website. Quicken works fine, but AQBanking gives me nothing. 9. I've tried everything I can think of for 2 months, but my knowledge of the products is very limited and I've figured nothing out other than it won't work. 10. I've tried posting to what appear to be aqbanking message lists, but have no luck getting my posts to take. Any help would be appreciated. Thanks, Mike ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] New User-Chase Bank Problems
That's what I've done. No luck. I'm not getting any messages on the Chase site so I don't know if they are seeing anything or not. I just keep seeing the same thing over and over. I'm on my 27 user attempt and nothing has changed. I was hoping it was the fact that I hadn't removed the hyphens from the CLUID, but even removing them doesn't fix it. SciFiGeek On 12/15/2018 6:14 PM, Fross, Michael wrote: Hello, I remember spending a lot of time to get it to work with my Chase Freedom card. There were 2 things that needed be done. #1, create a UUID and #2, go onto the website after you try it and give access. Summary: 1. Generated a Version 4 UUID here: a. https://www.uuidgenerator.net/version4 2. Entered it in my user settings ClientUID field in the aqbanking wizard - without the dashes 3. Changed the Header version to 103 (was 102) 4. Connect and instant success! Transactions and balance downloaded with no error messages in log. Go to your Chase Secure message box and allow the connection Thanks to Dave Reiser for figuring it out...I basically followed his instructions. If you'd like me to paste the entire email let me know. I saved it along with my summary above. Michael On Sat, Dec 15, 2018 at 7:32 PM David Reiser via gnucash-user mailto:gnucash-user@gnucash.org>> wrote: > On Dec 15, 2018, at 8:10 PM, Michael Mantei mailto:mante...@gmail.com>> wrote: > > I was a user of Quicken for as long as I can remember. I'm now trying to get serious about my finances and recently installed GNUCash on my Windows 10 system. I simply installed the software, and built my entire account structure manually, to match exactly what I wanted it to be. Now I need to connect to my bank (Chase) and can't do it. > > I'm using the AQBanking Wizard and have setup a user account and it won't connect. I started reading lots of messages here then created a new user. This one has the User Name and User Id set to the same name I used with Quicken. I used an online app to generate a Client UID. I've selected JPMorqan Chase Bank as my bank and took the defaults on the Bank Settings page. For the Application Settings, I have an Application ID of "QWIN". The application version is set to 2700 and the header version is set to 103. When I try to retrieve the account list, this is what I get: > > > 14:06:57 Retrieving SSL certificate > 14:06:57 Connecting to server... > 14:06:57 Using GnuTLS default ciphers. > 14:06:57 TLS: SSL-Ciphers negotiated: TLS1.2:ECDHE-RSA-AES-256-GCM:AEAD > 14:06:57 Signer not found > 14:06:57 Certificate is not trusted > 14:06:57 Connected. > 14:06:57 Disconnected. > 14:06:57 Connection ok, certificate probably received > 14:06:57 Operation finished, you can now close this window. > > The OFX.log file shows this: > > Sending: > - > OFXHEADER:100 > DATA:OFXSGML > VERSION:103 > SECURITY:NONE > ENCODING:USASCII > CHARSET:1252 > COMPRESSION:NONE > OLDFILEUID:NONE > NEWFILEUID:20181214144405.000 > > 20181214144405.000#NAME REMOVED# > #PASSWORD REMOVED# > ENGChase Bank1601QWIN22004f67a05f-bb69-45a7-ab66-d1f52dc4ef7120181214144405.000119691231 > > - > > Anyone have any ideas what I am doing wrong? Your help would be greatly appreciated. > > SciFiGeek > The ofx log says you set the APPVER to 2200 instead of 2700. That probably matters. Another thing is that you’re likely to have to do is log into the Chase web site, and check your secure messages for one that asks you if you were the one trying to sign in with a previously unknown app (as identified by the new unique CLIENTUID). Once you’ve followed the steps in the Chase message, you’ll be in better shape. If you have no message yet, there’s a possibility that the Chase system doesn’t think your software is capable anyway (APPVER too low). Change the APPVER, try Aqbanking again, and then check your account messages online again. I only have Chase credit cards. I don’t know if the procedure is different for checking and savings accounts. Chase does by default charge a fee for checking/savings access via OFXDirectConnect. But since you’ve connected before, I’m assuming that isn’t causing you problems. I also don’t know if Chase has changed the out-of-band verification steps since the first round two years ago. Good luck. -- Dave Reiser dbrei...@icloud.com <mailto:dbrei...@icloud.com> ___ gnucash-user mailing list gnucash-user@gnucash.org <mailto:gnucash-user@gnucas
Re: [GNC] New User-Chase Bank Problems
I copied an old entry from the OFX LOG. I am using APPVER 2700 and have the exact same issue. I've check my messages with Chase, and there aren't any. I don't know that anything is actually being sent to them. I've been with Chase for 4 years and have used Quicken with them the whole time. I've never been charged to connect, that I can recall. It's always just worked. Thanks for the feedback anyways. Mike On 12/15/2018 5:30 PM, David Reiser wrote: On Dec 15, 2018, at 8:10 PM, Michael Mantei wrote: I was a user of Quicken for as long as I can remember. I'm now trying to get serious about my finances and recently installed GNUCash on my Windows 10 system. I simply installed the software, and built my entire account structure manually, to match exactly what I wanted it to be. Now I need to connect to my bank (Chase) and can't do it. I'm using the AQBanking Wizard and have setup a user account and it won't connect. I started reading lots of messages here then created a new user. This one has the User Name and User Id set to the same name I used with Quicken. I used an online app to generate a Client UID. I've selected JPMorqan Chase Bank as my bank and took the defaults on the Bank Settings page. For the Application Settings, I have an Application ID of "QWIN". The application version is set to 2700 and the header version is set to 103. When I try to retrieve the account list, this is what I get: 14:06:57 Retrieving SSL certificate 14:06:57 Connecting to server... 14:06:57 Using GnuTLS default ciphers. 14:06:57 TLS: SSL-Ciphers negotiated: TLS1.2:ECDHE-RSA-AES-256-GCM:AEAD 14:06:57 Signer not found 14:06:57 Certificate is not trusted 14:06:57 Connected. 14:06:57 Disconnected. 14:06:57 Connection ok, certificate probably received 14:06:57 Operation finished, you can now close this window. The OFX.log file shows this: Sending: - OFXHEADER:100 DATA:OFXSGML VERSION:103 SECURITY:NONE ENCODING:USASCII CHARSET:1252 COMPRESSION:NONE OLDFILEUID:NONE NEWFILEUID:20181214144405.000 20181214144405.000#NAME REMOVED# #PASSWORD REMOVED# ENGChase Bank1601QWIN22004f67a05f-bb69-45a7-ab66-d1f52dc4ef7120181214144405.000119691231 - Anyone have any ideas what I am doing wrong? Your help would be greatly appreciated. SciFiGeek The ofx log says you set the APPVER to 2200 instead of 2700. That probably matters. Another thing is that you’re likely to have to do is log into the Chase web site, and check your secure messages for one that asks you if you were the one trying to sign in with a previously unknown app (as identified by the new unique CLIENTUID). Once you’ve followed the steps in the Chase message, you’ll be in better shape. If you have no message yet, there’s a possibility that the Chase system doesn’t think your software is capable anyway (APPVER too low). Change the APPVER, try Aqbanking again, and then check your account messages online again. I only have Chase credit cards. I don’t know if the procedure is different for checking and savings accounts. Chase does by default charge a fee for checking/savings access via OFXDirectConnect. But since you’ve connected before, I’m assuming that isn’t causing you problems. I also don’t know if Chase has changed the out-of-band verification steps since the first round two years ago. Good luck. -- Dave Reiser dbrei...@icloud.com ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] New User-Chase Bank Problems
I was a user of Quicken for as long as I can remember. I'm now trying to get serious about my finances and recently installed GNUCash on my Windows 10 system. I simply installed the software, and built my entire account structure manually, to match exactly what I wanted it to be. Now I need to connect to my bank (Chase) and can't do it. I'm using the AQBanking Wizard and have setup a user account and it won't connect. I started reading lots of messages here then created a new user. This one has the User Name and User Id set to the same name I used with Quicken. I used an online app to generate a Client UID. I've selected JPMorqan Chase Bank as my bank and took the defaults on the Bank Settings page. For the Application Settings, I have an Application ID of "QWIN". The application version is set to 2700 and the header version is set to 103. When I try to retrieve the account list, this is what I get: 14:06:57 Retrieving SSL certificate 14:06:57 Connecting to server... 14:06:57 Using GnuTLS default ciphers. 14:06:57 TLS: SSL-Ciphers negotiated: TLS1.2:ECDHE-RSA-AES-256-GCM:AEAD 14:06:57 Signer not found 14:06:57 Certificate is not trusted 14:06:57 Connected. 14:06:57 Disconnected. 14:06:57 Connection ok, certificate probably received 14:06:57 Operation finished, you can now close this window. The OFX.log file shows this: Sending: - OFXHEADER:100 DATA:OFXSGML VERSION:103 SECURITY:NONE ENCODING:USASCII CHARSET:1252 COMPRESSION:NONE OLDFILEUID:NONE NEWFILEUID:20181214144405.000 20181214144405.000#NAME REMOVED# #PASSWORD REMOVED# ENGChase Bank1601QWIN22004f67a05f-bb69-45a7-ab66-d1f52dc4ef7120181214144405.000119691231 - Anyone have any ideas what I am doing wrong? Your help would be greatly appreciated. SciFiGeek ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.