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 <[email protected]>
> 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 <[email protected]>
> 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 <[email protected]> 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 <[email protected]>
>> 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 <[email protected]> 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 <[email protected]>
>>> 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 <[email protected]> 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 <[email protected]> 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
>>> > [email protected]
>>> > 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
>>> [email protected]
>>> 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 [email protected] to your address book. This
>>> will be my new address. This gmail address is being retired.
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>
>>
>>
>> --
>> * Please consider adding [email protected] to your address book. This
>> will be my new address. This gmail address is being retired.
>>
>>
>>
>>
>>
>>
>>
>
>
>
> --
> * Please consider adding [email protected] to your address book. This
> will be my new address. This gmail address is being retired.
>
>
>
>
>
>
>
>
>
> --
> * Please consider adding [email protected] 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>
_______________________________________________
gnucash-user mailing list
[email protected]
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.
