https://www.gnucash.org/docs/v4/C/gnucash-guide/importing-from-files.html#importing-ofx <https://www.gnucash.org/docs/v4/C/gnucash-guide/importing-from-files.html#importing-ofx>
At the end of the QFX import you were presented with a window listing all of the imported new transactions. Since this is a first import they should all have had a yellow background. You can either double-click each one or select one or more and right click then select "assign account" from the context menu. That will bring up a window with your account tree from which you can select the "other" account for the selected transactions. When you do this GnuCash records information from the transaction's description and will use it to suggest an account for future transactions with similar descriptions; those will have a green background as will transactions after you've assigned an account to them. If you skipped that step you'll find al of your transactions assigned to Imbalance-CAD and you'll need to re-assign them in the register. That doesn't train the import matcher. The General Ledger by default filters to the last 30 days. You can change that with View>Filter By. Regards, John Ralls > On Jan 3, 2022, at 11:38 PM, Jesse MacDougall <macdougall.je...@gmail.com> > wrote: > > 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 > <mailto: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 >> <mailto: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 >> <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 <jra...@ceridwen.us >> <mailto: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> >> >> <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 <c...@ellisonet.ca >> > <mailto: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 <mailto:gnucash-user@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@gnucash.org <mailto:gnucash-user@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@macdougall.ninja >> <mailto: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.
