[GNC] AqBanking Online Set Up

john jralls at ceridwen.us
Tue Jan 4 13:02:05 EST 2022


No, those are file download types, not connection options. Money means OFX, Quicken probably means QFX but might mean QIF, QuickBooks probably means QBO but might also mean QFX or QIF. I don't know what Makisoft is nor what file type Sage likes. GnuCash can handle the Money or Quicken selections. Since Money is certainly OFX pick that and use File>Import>import OFX/QFX to import the data. It's both more reliable and less effort than importing CSV.

Regards,
John Ralls


> On Jan 3, 2022, at 11:12 PM, Jesse MacDougall <macdougall.jesse at gmail.com> wrote:
> 
> 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 <mailto: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 <mailto: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 <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 <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 <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 <mailto: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> <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/> <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 <mailto: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 <mailto:gnucash-user at gnucash.org>
>> > To update your subscription preferences or to unsubscribe:
>> > https://lists.gnucash.org/mailman/listinfo/gnucash-user <https://lists.gnucash.org/mailman/listinfo/gnucash-user>
>> > If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists <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 <mailto:gnucash-user at gnucash.org>
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user <https://lists.gnucash.org/mailman/listinfo/gnucash-user>
>> If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists <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 <mailto: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.
> 
> 
>  
> 
>  
> 
>  
> <downloadtransactions.png><ofxhome.png>



More information about the gnucash-user mailing list