I was able to download in QFX format. I did the import. How do I assign the transactions to the accounts now? I see some of the transactions are posted in GL but I do not see the entire year of transactions. Just December.
On Mon, Jan 3, 2022 at 9:28 PM john <jra...@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.je...@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 <jra...@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 <c...@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@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@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@macdougall.ninja to your address book. > This will be my new address. This gmail address is being retired. > > > > > > > > > > -- * Please consider adding jesse@macdougall.ninja to your address book. This will be my new address. This gmail address is being retired. _______________________________________________ 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.
