Re: [GNC] AqBanking Online Set Up

[Jesse MacDougall]

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  wrote:

> Yup, 10 months:
>  2021030112[-8]
>  2021123112[-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  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  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  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/on

Re: [GNC] AqBanking Online Set Up

[John Ralls]

Yup, 10 months:
 2021030112[-8]
 2021123112[-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  
> 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  
> 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  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  
>> 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  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  
>>> 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  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
>>>  
>>> 
>>>  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/  so you'd have to find 
>>> the co

Re: [GNC] AqBanking Online Set Up

[Jesse MacDougall]

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  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 
> 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  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 
>> 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  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/  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  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 credi

Re: [GNC] AqBanking Online Set Up

[Jesse MacDougall]

You are right. I agree with you.  I noticed this last night.

On Tue, Jan 4, 2022 at 10:02 AM john  wrote:

> No, those are file download types, not connection options. Money means
> OFX, Quicken probably means QFX but might mean QIF, QuickBooks probably
> means QBO but might also mean QFX or QIF. I don't know what Makisoft is nor
> what file type Sage likes. GnuCash can handle the Money or Quicken
> selections. Since Money is certainly OFX pick that and use
> File>Import>import OFX/QFX to import the data. It's both more reliable and
> less effort than importing CSV.
>
> Regards,
> John Ralls
>
>
> On Jan 3, 2022, at 11:12 PM, Jesse MacDougall 
> wrote:
>
> I can see Royal Bank connects with quicken because when I go to download
> my transactions from Royal Bank there is a Quicken option.So now I have
> determined Quicken integrates with Royal Bank I need to obtain the
> connection parameters.  Are these the parameters?
>
> I downloaded the annual transactions in .csv.  Now to import
> *challenge*
> 🍁🐯
>
>
>
>
>
> On Mon, Jan 3, 2022 at 9:28 PM john  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 
>> 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  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/  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  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

Re: [GNC] AqBanking Online Set Up

[john]

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  
> 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  > 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 > > 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 > > 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
>>  
>> 
>>  
>> >  
>> >
>>  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/  
>> > 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 > > > 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. 

Re: [GNC] AqBanking Online Set Up

[john]

No, those are file download types, not connection options. Money means OFX, 
Quicken probably means QFX but might mean QIF, QuickBooks probably means QBO 
but might also mean QFX or QIF. I don't know what Makisoft is nor what file 
type Sage likes. GnuCash can handle the Money or Quicken selections. Since 
Money is certainly OFX pick that and use File>Import>import OFX/QFX to import 
the data. It's both more reliable and less effort than importing CSV.

Regards,
John Ralls


> On Jan 3, 2022, at 11:12 PM, Jesse MacDougall  
> wrote:
> 
> I can see Royal Bank connects with quicken because when I go to download my 
> transactions from Royal Bank there is a Quicken option.So now I have 
> determined Quicken integrates with Royal Bank I need to obtain the connection 
> parameters.  Are these the parameters?
> 
> I downloaded the annual transactions in .csv.  Now to import *challenge*
> 🍁🐯
> 
> 
> 
> 
> 
> On Mon, Jan 3, 2022 at 9:28 PM john  > 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 > > 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 > > 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
>>  
>> 
>>  
>> >  
>> >
>>  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/  
>> > 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 > > > 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 
>> 

Re: [GNC] AqBanking Online Set Up

[Jesse MacDougall]

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  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 
> 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  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/  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  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.
___
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.

Re: [GNC] AqBanking Online Set Up

[john]

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  
> 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  > 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
>  
> 
>  
>   
> >
>  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/   > 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  > > 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.
> 
> 
>  
> 
>  
> 
>  

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https

Re: [GNC] AqBanking Online Set Up

[Jesse MacDougall]

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  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/  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  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.
___
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.

Re: [GNC] AqBanking Online Set Up

[Frank H. Ellenberger]

Am 04.01.22 um 05:22 schrieb john:
> EBICS is also German only.

No, European: AT, CH, DE, FR.
But at least in DE only offered for the (more expensive) business accounts.

Regards
Frank
___
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.

Re: [GNC] AqBanking Online Set Up

[Cam Ellison]

On 2022-01-03 8:22 p.m., john 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 

 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/ 
 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.


Thanks, John - I stand corrected.

I've not had to do this for probably a decade, but seem to recall being 
able to make it work with a CSV file (from a credit union) - but that 
was a few versions of GnuCash ago. The CSV option is still in GnuCash - 
that might work well enough. I recall having to hand-bomb some of the 
entries to make it come out correctly.


Cheers

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.

Re: [GNC] AqBanking Online Set Up

[john]

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
 

 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/  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  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.

Re: [GNC] AqBanking Online Set Up

[Cam Ellison]

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.

[GNC] AqBanking Online Set Up

[Jesse MacDougall]

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.

-- 
* 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.