The import went smooth. Alot eaier then a .csv and other softwares I've used in my career. QFX is what I got but Royal Bank only included December transactions in the file when I chose the entire year.
So this is great. Can download one file a month and post each transaction to proper account usually expense. So now I have to get other information so that gnucash will automate the downloading and importing process? Is this possible? I dunno, I think so...Sometimes I think technology is supposed to do something but it doesn't 😂🍁🐯🎩🐧 On Tue, Jan 4, 2022 at 10:13 AM john <jra...@ceridwen.us> wrote: > > 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> 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. > > > > > > > > > > -- * 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.
