Re: [GNC] AqBanking Online Set Up

2022-01-04 Thread 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

Re: [GNC] AqBanking Online Set Up

2022-01-04 Thread 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 > w

Re: [GNC] AqBanking Online Set Up

2022-01-04 Thread 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 u

Re: [GNC] AqBanking Online Set Up

2022-01-04 Thread 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.

Re: [GNC] AqBanking Online Set Up

2022-01-04 Thread 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 thi

Re: [GNC] AqBanking Online Set Up

2022-01-04 Thread 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

Re: [GNC] AqBanking Online Set Up

2022-01-03 Thread 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

Re: [GNC] AqBanking Online Set Up

2022-01-03 Thread 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 download

Re: [GNC] AqBanking Online Set Up

2022-01-03 Thread 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

Re: [GNC] AqBanking Online Set Up

2022-01-03 Thread 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

Re: [GNC] AqBanking Online Set Up

2022-01-03 Thread 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/accountingsoftw

Re: [GNC] AqBanking Online Set Up

2022-01-03 Thread 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

Re: [GNC] AqBanking Online Set Up

2022-01-03 Thread 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 Aq

[GNC] AqBanking Online Set Up

2022-01-03 Thread 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 cons