[GNC] AqBanking Online Set Up

Tue Jan 4 15:54:02 EST 2022

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.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: OFX-OPEX-2021-03-01--2021-12-31.qfx
Type: application/vnd.intu.qfx
Size: 225122 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20220104/afcd5192/attachment-0001.qfx>