YAS! General Journal Register ftw! woot! Even imported five bank accounts. Okay so now I manually click the amounts to correct account. Sweet! Wish I was using GNU Cash Years ago.
On Tue, Jan 4, 2022 at 1:28 PM John Ralls <jra...@ceridwen.us> wrote: > Yup, 10 months: > <DTSTART>20210301120000[-8] > <DTEND>20211231120000[-8] > > Are you sure that GnuCash imported only December's transactions? Did you > change the filter on the General Journal register or look in the account's > register? > > Regards, > John Ralls > > > On Jan 4, 2022, at 12:54 PM, Jesse MacDougall < > macdougall.je...@gmail.com> wrote: > > > > Okay found out Royal Bank only saves transactions upto 120 days for > OFX. Nnesense. 365 days is what an Auditor wants. The file I downloaded > only had one month once I imported the OFX. This conflicts with what Royal > Bank has said so far. So I called Royal Bank back and everything is fine > on their end. > > > > I then looked at the OFX file in text editor and saw it has > March-December so the problem is with the format of the OFX file relative > to GnuCash. Headers... > > > > I've attached the transactions for the Use Case in the email. > > > > Any ideas on next steps? > > > > > > > > On Tue, Jan 4, 2022 at 10:51 AM Jesse MacDougall < > macdougall.je...@gmail.com> wrote: > > 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. > > > > > > > > > > > > > > > > > > > > -- > > * Please consider adding jesse@macdougall.ninja to your address book. > This will be my new address. This gmail address is being retired. > > > > > > > > > > > > > > > > <OFX-OPEX-2021-03-01--2021-12-31.qfx> > > -- * 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.
