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 <[email protected]> > 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 <[email protected] > <mailto:[email protected]>> 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 <[email protected] >> <mailto:[email protected]>> 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 <[email protected] >> <mailto:[email protected]>> 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 <[email protected] >> > <mailto:[email protected]>> 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 >> > [email protected] <mailto:[email protected]> >> > 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 >> [email protected] <mailto:[email protected]> >> 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 [email protected] >> <mailto:[email protected]> to your address book. This will be my new >> address. This gmail address is being retired. >> >> >> >> >> >> >> > > > > -- > * Please consider adding [email protected] to your address book. This > will be my new address. This gmail address is being retired. > > > > > > > > <downloadtransactions.png><ofxhome.png> _______________________________________________ gnucash-user mailing list [email protected] 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.
