Re: [GNC] Almost ready to give up

[xngin]

I too am having trouble getting AqBanking to pull data for a number of
accounts. In the process of researching this I discovered that there is a
tool which works better for me:  ofxtools
  . 

Long story short, it knows more about the quirks of various FI OFX servers,
and for Chase in particular reliably pulls data that AqBanking cannot.

Basically, my suggestion to the original poster is to use "ofxget" to
download the data, and then import it into GC. In fact, I am thinking of
writing a script that will do that for all my institutions at once, and
store the files conveniently in a folder ready for GC import.

I highly recommend a read of the  ofxget manual
  .



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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] Almost ready to give up

[WestTown55]

Hi,

I'm having the exact same issue trying to connect GnuCash with Chase. From
what I gather from this post, it's no longer possible to connect Chase with
GnuCash to automatically download the transactions. Is that correct?

Is the auto-download online banking setup easier with other banks? I have
Chase as my primary, but have been considering switching from Chase for a
while. 

Thanks



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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] Almost ready to give up

[Michael Mantei]

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.

Re: [GNC] Almost ready to give up

[Dennis Powless]

Personally, I gave up on it a long time ago and either download the ofx, or 
manually enter the transactions.  This can all be done via simple key commands, 
and surprisingly quick.


D

Sent from my iPhone

> On Jan 23, 2019, at 11:14 PM, Ronal B Morse  wrote:
> 
> Michael, I feel your pain.  I miss Quicken's "one click
> import" feature, too. I blame Intuit...they kept getting the
> banks to mess around with the authentication process and data
> formats, plus their lack of documentation and pointed desire
> to not help developers of other applications made things
> worse then they had to be. 
> 
> That said, if you don't mind a few extra steps and a (very)
> few minutes of clicking around the screen, here's the method
> I use to download and enter transactions from my Chase credit
> cards and checking account to Gnucash. 
> 
> 1. Open the Chase web site, log in with your usual user
> credentials and navigate to the activity page of the account
> you want to process.  About halfway down the page there will
> be a menu bar with some icons...the "download activity" icon
> (looks like a down arrow pointing at an in basket) will be
> near the far right. Clicking on the icon will open a dialog
> where you specify the date range and file type.  I always use
> the ofx/qfx format because it seems most reliable. Click
> download to save your transactions and note the file name and
> location where it is saved.  
> 
> Repeat as desired for other Chase accounts, making sure you
> have a unique name for each transaction download. Chase does
> this automagically now, but that wasn't always the case. 
> Some institutions just give you a "transaction.ofx" file name
> for every account.  
> 
> When finished, log out of the Chase web site and close the
> browser for security's sake. 
> 
> Start GnuCash, open the account register for the first
> account you want to process.  Click on  then .
> Select the file type (in my case it's ofx/Qfx) then select
> the file you downloaded for that account from the navigator.
> Click "import".
> 
> That opens the transaction matching window. The options are
> described in detail in the GnuCash documentation. For me, the
> automatcher gets most of the transactions correct and I just
> have to check the appropriate box for the ones it does not
> match. 
> 
> Repeat for other accounts as appropriate. Done. 
> 
> This method is certainly not as convenient as a one click
> download like Quicken does, but at least it works and is
> reliable and consistent.  I use it with Chase, Bank of
> America (checking and credit card), wife's Target Bank Credit
> Card, USAA (checking, credit card) and my Charles Schawb cash
> sweep checking account.   
> 
> I don't use Gnucash to track investment portfolio activity,
> so I can't help with that. Every time I get interested in
> sciencing out a solution for the potfolio I decide Chuck's
> Schawb's web portal already tells me more than I want to know
> (lately, anyway) and it is their problem to maintain it. 
> 
> Ron Morse 
> 
>> On Wed, 2019-01-23 at 18:10 -0800, 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
>> 

Re: [GNC] Almost ready to give up

[Ronal B Morse]

Michael, I feel your pain.  I miss Quicken's "one click
import" feature, too. I blame Intuit...they kept getting the
banks to mess around with the authentication process and data
formats, plus their lack of documentation and pointed desire
to not help developers of other applications made things
worse then they had to be. 

That said, if you don't mind a few extra steps and a (very)
few minutes of clicking around the screen, here's the method
I use to download and enter transactions from my Chase credit
cards and checking account to Gnucash. 

1. Open the Chase web site, log in with your usual user
credentials and navigate to the activity page of the account
you want to process.  About halfway down the page there will
be a menu bar with some icons...the "download activity" icon
(looks like a down arrow pointing at an in basket) will be
near the far right. Clicking on the icon will open a dialog
where you specify the date range and file type.  I always use
the ofx/qfx format because it seems most reliable. Click
download to save your transactions and note the file name and
location where it is saved.  

Repeat as desired for other Chase accounts, making sure you
have a unique name for each transaction download. Chase does
this automagically now, but that wasn't always the case. 
Some institutions just give you a "transaction.ofx" file name
for every account.  

When finished, log out of the Chase web site and close the
browser for security's sake. 

Start GnuCash, open the account register for the first
account you want to process.  Click on  then .
Select the file type (in my case it's ofx/Qfx) then select
the file you downloaded for that account from the navigator.
Click "import".

That opens the transaction matching window. The options are
described in detail in the GnuCash documentation. For me, the
automatcher gets most of the transactions correct and I just
have to check the appropriate box for the ones it does not
match. 

Repeat for other accounts as appropriate. Done. 

This method is certainly not as convenient as a one click
download like Quicken does, but at least it works and is
reliable and consistent.  I use it with Chase, Bank of
America (checking and credit card), wife's Target Bank Credit
Card, USAA (checking, credit card) and my Charles Schawb cash
sweep checking account.   

I don't use Gnucash to track investment portfolio activity,
so I can't help with that. Every time I get interested in
sciencing out a solution for the potfolio I decide Chuck's
Schawb's web portal already tells me more than I want to know
(lately, anyway) and it is their problem to maintain it. 

Ron Morse 

On Wed, 2019-01-23 at 18:10 -0800, 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.000<
> USERID>MYUSERID
>  MYPASSWORD
>  ENGChase 
> Bank1601QWIN27001df5920
> 7be3d4a6aa416de9233639b2d GSRQV1>20190122215110.000
> 119691231 >
> 
>  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 

[GNC] Almost ready to give up

[Michael Mantei]

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.