[GNC] AqBanking Online Set Up

Tue Jan 4 22:52:14 EST 2022

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 <jralls at 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.jesse at 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.jesse at 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 <jralls at 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.jesse at 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 <jralls at 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.jesse at 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 <jralls at 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 <cam at 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 at 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 at 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 at macdougall.ninja to your address
> book.  This will be my new address.  This gmail address is being retired.
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>
> >>
> >>
> >> --
> >> * Please consider adding jesse at macdougall.ninja to your address book.
> This will be my new address.  This gmail address is being retired.
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >
> >
> >
> > --
> > * Please consider adding jesse at macdougall.ninja to your address book.
> This will be my new address.  This gmail address is being retired.
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > --
> > * Please consider adding jesse at 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 at macdougall.ninja to your address book.  This
will be my new address.  This gmail address is being retired.