[GNC] AqBanking Online Set Up

Tue Jan 4 13:51:17 EST 2022

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.