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
<OFX><SIGNONMSGSRQV1><SONRQ><DTCLIENT>20190122215110.000<USERID>MYUSERID
<USERPASS>MYPASSWORD
<LANGUAGE>ENG<FI><ORG>Chase
Bank<FID>1601</FI><APPID>QWIN<APPVER>2700<CLIENTUID>1df59207be3d4a6aa416de9233639b2d</SONRQ></SIGNONMSGSRQV1><SIGNUPMSGSRQV1><ACCTINFOTRNRQ><TRNUID>20190122215110.000<CLTCOOKIE>1<ACCTINFORQ><DTACCTUP>19691231</ACCTINFORQ></ACCTINFOTRNRQ></SIGNUPMSGSRQV1></OFX>
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.
