[GNC] AqBanking Online Set Up

[Jesse MacDougall]

I can see Royal Bank connects with quicken because when I go to download my
transactions from Royal Bank there is a Quicken option.    So now I have
determined Quicken integrates with Royal Bank I need to obtain the
connection parameters.  Are these the parameters?

I downloaded the annual transactions in .csv.  Now to import.... *challenge*
🍁🐯





On Mon, Jan 3, 2022 at 9:28 PM john <jralls at ceridwen.us> wrote:

> Not necessarily. You just need to see if Quicken knows how to connect to
> RBC and if so whether they authenticate with DirectConnect (which AQBanking
> can handle), Express WebConect, or WebConnect (both of which it can't).
>
> It just as possible that what that page is really talking about is
> downloading files; you can figure that out by logging in to your RBC web
> account and looking for a download link. GnuCash can handle OFX, QFX, and
> QIF but not QBO. It's also able to handle CSV though that may take a bit of
> tweaking and in some cases some preprocessing of the CSV.
>
> Regards,
> John Ralls
>
>
>
>
> On Jan 3, 2022, at 9:17 PM, Jesse MacDougall <macdougall.jesse at gmail.com>
> wrote:
>
> Merci, that eliminates two of the options.  I see a forum to a missing
> institution and connections
> http://www.ofxhome.com/ofxforum//viewforum.php?id=3.  I see someone two
> years ask about Canadian Banks.  No response
> http://www.ofxhome.com/ofxforum//viewtopic.php?id=49825
>
> Here someone says TD Bank Canada is not listed but USA is =(
> http://www.ofxhome.com/ofxforum//viewtopic.php?id=49482
>
> A Quicken friend who uses Royal Bank as well?
>
>
>
> On Mon, Jan 3, 2022 at 8:26 PM john <jralls at ceridwen.us> wrote:
>
>> Nope. HBCI (now called FinTS) works *only* with *German* Banks. The Royal
>> Bank of *Canada* is absolutely not a German bank and isn't likely to
>> support HBCI.
>> EBICS is also German only.
>>
>>
>> https://www.rbcroyalbank.com/onlinebanking/bankingusertips/accountingsoftware/index.html
>> <
>> https://www.rbcroyalbank.com/onlinebanking/bankingusertips/accountingsoftware/index.html>
>> suggests that RBC might support OFX Direct Connect based on the list of
>> software they claim to support, but they're not listed in
>> https://www.ofxhome.com/ <https://www.ofxhome.com/> so you'd have to
>> find the connection parameters some other way. The simplest would be to
>> find a friend who has Quicken and see if it knows how to connect.
>>
>> Regards,
>> John Ralls
>>
>>
>> > On Jan 3, 2022, at 7:00 PM, Cam Ellison <cam at ellisonet.ca> wrote:
>> >
>> > On 2022-01-03 5:39 p.m., Jesse MacDougall wrote:
>> >> Guy's, I'm stumped here.  My Bank is Royal Bank in Canada.  I have no
>> idea
>> >> where to get this information from.  When I call the bank they talk to
>> me
>> >> like I am a terrorist due to Iddiocracy.
>> >>
>> >> Never seen this side of technology before.  I read the AqBanking wiki
>> but
>> >> didn't advance.
>> >>
>> > Try selecting a range of transactions by date, and then downloading it.
>> See what formats are available for download. The format of each line should
>> tell you - or someone on this list with more knowledge than I - which of
>> those options to use.  Most likely it's HBCI, but that's a wild guess on my
>> part.
>> >
>> > There is likely at least one member of this list with an RBC account,
>> besides yourself. I have only a credit card with them, and that format is
>> different.
>> >
>> > Good luck with this
>> >
>> > Cam
>> >
>> >
>> >
>> > _______________________________________________
>> > gnucash-user mailing list
>> > gnucash-user at 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.
>>
>> _______________________________________________
>> gnucash-user mailing list
>> gnucash-user at 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.
>>
>
>
> --
> * Please consider adding jesse at macdougall.ninja to your address book.
> This will be my new address.  This gmail address is being retired.
>
>
>
>
>
>
>
>
>
>

-- 
* Please consider adding jesse at macdougall.ninja to your address book.  This
will be my new address.  This gmail address is being retired.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: downloadtransactions.png
Type: image/png
Size: 90918 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20220103/e245c71d/attachment-0002.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: ofxhome.png
Type: image/png
Size: 54366 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20220103/e245c71d/attachment-0003.png>