Re: [GNC] Import csv, ofx

[Gyle McCollam]

Thank you for the prompt response.  A clarification please, what does "AFAIK" 
stand for and I also use Libre Office these days, after using Open Office and 
Quattro Pro for years, never did use Excel.


Thank You,
Gyle McCollam

Gyle McCollam

609.680.2326 Mobile

gmccol...@live.com   email


From: gnucash-user  on 
behalf of davidcousen...@gmail.com 
Sent: Tuesday, January 4, 2022 8:53 PM
To: gnucash-user@gnucash.org 
Subject: Re: [GNC] Import csv, ofx

Gyle,
Export it as Excel, load it up in Excel and export it from there as CSV. GnuCash
has always read Excel's CSV exports AFAIK (I use Libre Ofiice these days and it
certainly works with LO).

You should also be able to set the date format in the CSV import dialog. It will
likely default to the format specified for your locale but you can override that
and store the format settings for future use.

David Cousens

On Wed, 2022-01-05 at 01:01 +, Gyle McCollam wrote:
> I have been having a great experience importing ofx files for my bank accounts
> and credit cards.  However, when I tried to export from Discover Card, the
> only options were Excel or csv.  I didn't see that Gnucash imported Excel so I
> used csv.  I had absolutely no luck importing the csv file into Gnucash.  I
> kept getting an error message that the date was out of range (1-31).  The date
> format used by Discover is MM/DD/.  Is the date range the import function
> uses in a different format, therefore causing my issue?
>
>
> Thank You,
> Gyle McCollam
>
> Gyle McCollam
>
> 609.680.2326 Mobile
>
> gmccol...@live.com   email
> ___
> 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.
___
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

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

Re: [GNC] Trial Balance Report Settings

[D. via gnucash-user]

I think the OP is looking to save the settings from one iteration to the next, 
which I'd achieve by saving the settings as "My Trial Balance" and then calling 
that report whenever I needed it. 


 Original Message 
From: Jesse MacDougall 
Sent: Tue Jan 04 20:19:08 EST 2022
To: Benjamin Soffer 
Cc: gnucash-user@gnucash.org
Subject: Re: [GNC] Trial Balance Report Settings

Yes i saw a setting for this somewhere dont recall exactly

On Tue., Jan. 4, 2022, 16:41 Benjamin Soffer, 
wrote:

> Hello,
>
> Is it possible to configure the trial balance report so that hidden
> accounts or zero-balance accounts would be excluded from the report?
>
> Ben Soffer
> ___
> 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.
___
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] Import csv, ofx

[davidcousens49]

Gyle,
Export it as Excel, load it up in Excel and export it from there as CSV. GnuCash
has always read Excel's CSV exports AFAIK (I use Libre Ofiice these days and it
certainly works with LO).

You should also be able to set the date format in the CSV import dialog. It will
likely default to the format specified for your locale but you can override that
and store the format settings for future use.

David Cousens

On Wed, 2022-01-05 at 01:01 +, Gyle McCollam wrote:
> I have been having a great experience importing ofx files for my bank accounts
> and credit cards.  However, when I tried to export from Discover Card, the
> only options were Excel or csv.  I didn't see that Gnucash imported Excel so I
> used csv.  I had absolutely no luck importing the csv file into Gnucash.  I
> kept getting an error message that the date was out of range (1-31).  The date
> format used by Discover is MM/DD/.  Is the date range the import function
> uses in a different format, therefore causing my issue?
> 
> 
> Thank You,
> Gyle McCollam
> 
> Gyle McCollam
> 
> 609.680.2326 Mobile
> 
> gmccol...@live.com   email
> ___
> 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] Trial Balance Report Settings

[Jesse MacDougall]

Yes i saw a setting for this somewhere dont recall exactly

On Tue., Jan. 4, 2022, 16:41 Benjamin Soffer, 
wrote:

> Hello,
>
> Is it possible to configure the trial balance report so that hidden
> accounts or zero-balance accounts would be excluded from the report?
>
> Ben Soffer
> ___
> 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.

[GNC] Import csv, ofx

[Gyle McCollam]

I have been having a great experience importing ofx files for my bank accounts 
and credit cards.  However, when I tried to export from Discover Card, the only 
options were Excel or csv.  I didn't see that Gnucash imported Excel so I used 
csv.  I had absolutely no luck importing the csv file into Gnucash.  I kept 
getting an error message that the date was out of range (1-31).  The date 
format used by Discover is MM/DD/.  Is the date range the import function 
uses in a different format, therefore causing my issue?


Thank You,
Gyle McCollam

Gyle McCollam

609.680.2326 Mobile

gmccol...@live.com   email
___
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] Trial Balance Report Settings

[Benjamin Soffer]

Hello,

Is it possible to configure the trial balance report so that hidden accounts or 
zero-balance accounts would be excluded from the report?

Ben Soffer
___
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] Tax question - gross income for the year

[Daffy Duck]

Hello,

I'm having an issue in transaction report in easily seeing gross income
for the year.

Specifically:

1. I have Income:Sales and when I do an invoice, I direct income to go
there.

2. Sometimes clients reimburse me for postage charges, so that does not
go to income:sales but is in expenses:reimbursed expenses

3. Many times at the end and the beginning of the year, an invoice is
not closed, so an invoice I opened 11/20 may still be being paid
throughout early 2021.


What is the best way to do this in order to be able to see gross sales
for the year, as in, how much income was actually received for
sales(not expenses), etc.

I have near the correct amount with the transaction report showing
income:sales and limiting it to 2021, but it:

a. Does not capture money from previous years' invoices that is still
being paid and
b. Assumes invoices that are created in 2021 are fully paid off.

Thank you,
___
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] Cash Basis Accounting

[Rich Shepard]

On Tue, 4 Jan 2022, Don Gray wrote:


The problem stems from the report being off by several thousand dollars as
I’ve posted invoices but not received the payments.


Don,

What I do, on the advice of my previous accountant who's now retired, is not
to enter an A/P or A/R invoice until payment is made or received,
respectively. That way what you see is what you have.

In your case, I'd delete the accrual transactions until you receive the
payments.

HTH,

Rich
___
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] Cash Basis Accounting

[R. Victor Klassen]

I normally re-post invoices to the 1st of the year if not paid before, and any 
bills that are due and paid after the year end I also post to the 1st.  
Rarely do I find something that needs to be moved the other direction (although 
it is possible, I just can’t think of an instance off hand).

The date opened and the dates on the entries of the invoices/bills can still 
remain attached to reality, only the posting dates need to be fiddled with.

The method in the wiki works if you are really good at keeping A/P and A/R 
correct and up to date.  i.e. never receive payment without assigning it to an 
invoice
or properly categorizing the split, and never pay a bill without linking the 
payment to the bill.  In an ideal world that works all the time. Just not in my 
experience.

> On Jan 4, 2022, at 5:23 PM, Don Gray  wrote:
> 
> For 2021 year end account I need to generate a profit/loss report. No problem 
> as a standard report exists.
> 
> The problem stems from the report being off by several thousand dollars as 
> I’ve posted invoices but not received the payments.
> 
> Searching the internet I found 
> https://wiki.gnucash.org/wiki/Cash_Based_Accounting 
> . Is this still the 
> current way of handling Cash basis accounting?
> 
> Don
> ___
> 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.

[GNC] Cash Basis Accounting

[Don Gray]

For 2021 year end account I need to generate a profit/loss report. No problem 
as a standard report exists.

The problem stems from the report being off by several thousand dollars as I’ve 
posted invoices but not received the payments.

Searching the internet I found 
https://wiki.gnucash.org/wiki/Cash_Based_Accounting 
. Is this still the 
current way of handling Cash basis accounting?

Don
___
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] GNUCash 4.9

[Adrien Monteleone]

Glad to hear you resolved it, thanks for reporting back what worked.

Regards,
Adrien

On 1/4/22 10:53 AM, Steve Mortimer wrote:
What I did to correct my problem was to take the last backup file and 
remove all of the dates in the file name and made that my main 
(orginial) transaction file.  I opened that file as the data file and 
used it.  This corrected the issue with I was having.


___
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] A repository for user-contributed files

[Adrien Monteleone]

I'd say more like 'ask' or 'request' or 'inform' people about that 
method in the Wiki.


And while it has been some time, I think that method does work. I used 
to use it for a spell and I don't recall un-threading issues. But 
further confirmation would be needed.


Regards,
Adrien

On 1/4/22 3:48 AM, Dr. David Kirkby wrote:

b) Insisting that if people want to reply to something that they see in the
digest, they reply to the archive - assuming that maintains the thread.


___
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] show unposted invoices in customer report?

[Adrien Monteleone]

On 1/4/22 12:24 PM, Derek Atkins wrote:

Feel free to write a new report and submit it to the team for inclusion.
In 20 years, you're the first person to ask for this.


Maybe not to this level of detail, or with this specific 
solution/suggestion, but the basic question I've seen several times, 
because the UI does not make it obvious.


I'd really like this feature too, but not in a report so much. I'd just 
like to not have to go the long way 'round to find un-posted invoices. 
But my idea involves an entire re-write of how the Business Features 
works at present. That's beyond my time or talent for now, and I respect 
that devs do things for their own needs, on their own volunteer time, 
and try to be as responsive as possible, but can't please everyone. 
which is why I haven't mentioned it. I'd bet there are other users 
silent on such issues for similar reasons.



How many unposted invoices do you have at a time?
If not many, why not just leave your unposted invoices open until you post
them?
Still, it shouldn't be something that you need to do often.


This would have been my suggestion but you beat me to it.

Another would be to use a 'work completed' account. (I do this for some 
customers/projects) This is where I record work as it is done, then when 
I am ready to invoice *and post*, I book it against this 'work 
completed' account. If there is any balance in that account, it means 
there is work not yet invoiced. I still need to figure out a good way to 
rapidly identify *which* transactions in the account haven't been invoiced.


The only time I don't use this account is when I'm ready to post when 
I'm writing an invoice with little or no delay after the work is completed.


Regards,
Adrien

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

Re: [GNC] A good tutorial on connecting online to my bank accounts?

[Adrien Monteleone]

GnuCash cannot initiate transactions. You are limited to syncing 
previous transactions from the institution to GnuCash.


Regards,
Adrien

On 1/4/22 2:27 PM, John Smith wrote:

Is there a way to use GnuCash to connect to my credit union’s bank account and 
then move those funds from one account to another? Is there a good YouTube that 
explains this or a tutorial of some sort?


___
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] A good tutorial on connecting online to my bank accounts?

[Jesse MacDougall]

You connect to your bank account and download those transactions into your
Chart Of Accounts.

"move those funds" - Are you talking about cash? or creating Adjusting
Journal Entries?

I haven't found any videos but I am on this process as well.

Check for bank on here https://www.ofxhome.com/index.php/auth/ def want to
get involved here.  Know your bank or whatever

On Tue, Jan 4, 2022 at 12:28 PM John Smith 
wrote:

> Is there a way to use GnuCash to connect to my credit union’s bank account
> and then move those funds from one account to another? Is there a good
> YouTube that explains this or a tutorial of some sort?
>
> Sent from my iPhone
> ___
> 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.

[GNC] A good tutorial on connecting online to my bank accounts?

[John Smith]

Is there a way to use GnuCash to connect to my credit union’s bank account and 
then move those funds from one account to another? Is there a good YouTube that 
explains this or a tutorial of some sort?

Sent from my iPhone
___
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

[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 

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

Re: [GNC] show unposted invoices in customer report?

[Derek Atkins]

On Tue, January 4, 2022 1:14 pm, Mattia Rizzolo wrote:
> On Tue, Jan 04, 2022 at 12:46:33PM -0500, Derek Atkins wrote:
>> The Customer Report is designed to be an "account status" for you to
>> send
>> to the Customer.  Unposted Invoices effectively "do not exist" as far as
>> the customer is concerned, so should not be in that report.
>
> Right, but what about something for *me* to see as well?  :D

Feel free to write a new report and submit it to the team for inclusion. 
In 20 years, you're the first person to ask for this.

>> Having said that, you can do a search for invoice "is not" "posted" and
>> it
>> will bring a list of all unposted invoices for you.
>
> Right, which is similar to what I do, except that it takes 6 clicks to
> bring up a list, then a double click to open up the search result, then
> another click to close the search window.  And most of those clicks
> require focus as I need to click the right label in a list, plus the
> small checkbox to disable the "is posted" selection.

I count 5 clicks, but I guess it depends if you hover over Customer or
click on it to get to Find Invoice.

> I mean, I totally see there is a way, but I'm arguing it's so much
> harder than it needs be, IMHO.

How many unposted invoices do you have at a time?
If not many, why not just leave your unposted invoices open until you post
them?
Still, it shouldn't be something that you need to do often.

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant

___
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] show unposted invoices in customer report?

[Mattia Rizzolo]

On Tue, Jan 04, 2022 at 12:46:33PM -0500, Derek Atkins wrote:
> The Customer Report is designed to be an "account status" for you to send
> to the Customer.  Unposted Invoices effectively "do not exist" as far as
> the customer is concerned, so should not be in that report.

Right, but what about something for *me* to see as well?  :D

> Having said that, you can do a search for invoice "is not" "posted" and it
> will bring a list of all unposted invoices for you.

Right, which is similar to what I do, except that it takes 6 clicks to
bring up a list, then a double click to open up the search result, then
another click to close the search window.  And most of those clicks
require focus as I need to click the right label in a list, plus the
small checkbox to disable the "is posted" selection.

I mean, I totally see there is a way, but I'm arguing it's so much
harder than it needs be, IMHO.

-- 
regards,
Mattia Rizzolo

GPG Key: 66AE 2B4A FCCF 3F52 DA18  4D18 4B04 3FCD B944 4540  .''`.
More about me:  https://mapreri.org : :'  :
Launchpad user: https://launchpad.net/~mapreri  `. `'`
Debian QA page: https://qa.debian.org/developer.php?login=mattia  `-


signature.asc
Description: PGP signature
___
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]

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] Closing Books - Pros & Cons

[Fred Bone]

On 04 January 2022 at 17:17, Mattia Rizzolo said:

> On Mon, Jan 03, 2022 at 08:39:26PM -0600, Adrien Monteleone wrote:
> > You're welcome, and you did right by changing the subject.
> > Unfortunately, replying to a digest doesn't thread to your original
> > post. (as discussed in another thread) No way around that of which I am
> > aware, but at least the subject is the same so we know what you are
> > discussing!
> 
> Technically, the threading is implemented by following headers such as
> "References" and "In-Reply-To", which points to all the relevant
> Message-IDs.  One could add those headers manually, but that's clearly
> behind what's to be expected of anybody who doesn't actually work on IT
> (and even then, it's too bothersome).

And, as already said, doesn't work when replying to a plaintext Digest, 
which doesn't include the Message-ID (of an individual message) in the 
first place.

___
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] show unposted invoices in customer report?

[Derek Atkins]

Hi,

On Tue, January 4, 2022 12:38 pm, Mattia Rizzolo wrote:
> Hi!
>
> I like that I'm able to draft an invoice and then keep it open until I'm
> ready to post it.  It makes trivial to me to take note in a place I'm
> sure I won't forget (because I won't right?) of jobs I completed for a
> customer, before it comes the time to invoice them for it.
>
> However, finding those invoices later on is quite hard.  Currently, the
> only way I found is:
>  business > find invoice > start some search that hopefully will
>  return the unposted invoice I need
> that (especially the last step) is very bothersome.
>
> I'd love to see those invoices in the "customer report" that I get, for
> example, by double-clicking on a line in the "customers overview" page,
> then it would be trivial to spot.
>
> Such invoices could easily be sorted in an "unposted invoices" section
> under (or over?) the current table.
> That feels like the optimal spot for such data, instead of burying them
> into the deep crevices of the "find invoice" gorge.
>
>
> Am I the only one that feels bothered by the current state of this
> feature?  Anybody has a suggestion on how to improve this?
> Should I turn my suggestion in a bug report to improve the current
> "customer report" report?

The Customer Report is designed to be an "account status" for you to send
to the Customer.  Unposted Invoices effectively "do not exist" as far as
the customer is concerned, so should not be in that report.

Having said that, you can do a search for invoice "is not" "posted" and it
will bring a list of all unposted invoices for you.

>
> --
> regards,
> Mattia Rizzolo

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant

___
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] show unposted invoices in customer report?

[Mattia Rizzolo]

Hi!

I like that I'm able to draft an invoice and then keep it open until I'm
ready to post it.  It makes trivial to me to take note in a place I'm
sure I won't forget (because I won't right?) of jobs I completed for a
customer, before it comes the time to invoice them for it.

However, finding those invoices later on is quite hard.  Currently, the
only way I found is:
 business > find invoice > start some search that hopefully will
 return the unposted invoice I need
that (especially the last step) is very bothersome.

I'd love to see those invoices in the "customer report" that I get, for
example, by double-clicking on a line in the "customers overview" page,
then it would be trivial to spot.

Such invoices could easily be sorted in an "unposted invoices" section
under (or over?) the current table.
That feels like the optimal spot for such data, instead of burying them
into the deep crevices of the "find invoice" gorge.


Am I the only one that feels bothered by the current state of this
feature?  Anybody has a suggestion on how to improve this?
Should I turn my suggestion in a bug report to improve the current
"customer report" report?

-- 
regards,
Mattia Rizzolo

GPG Key: 66AE 2B4A FCCF 3F52 DA18  4D18 4B04 3FCD B944 4540  .''`.
More about me:  https://mapreri.org : :'  :
Launchpad user: https://launchpad.net/~mapreri  `. `'`
Debian QA page: https://qa.debian.org/developer.php?login=mattia  `-


signature.asc
Description: PGP signature
___
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] A repository for user-contributed files

[Frank H. Ellenberger]

Hello David,

Am 04.01.22 um 10:48 schrieb Dr. David Kirkby:
> On Mon, 3 Jan 2022 at 22:08, Adrien Monteleone <
> adrien.montele...@lusfiber.net> wrote:
> 
>> But I
>> guess if they are replying to the digest and they copy-paste the
>> subject, as they should, then it will appear un-threaded.
> 
> 
> I think there’s a good argument for either
> a) Stopping the digest mode OR
> b) Insisting that if people want to reply to something that they see in the
> digest, they reply to the archive - assuming that maintains the thread.
> …
Can you extend the point in
https://wiki.gnucash.org/wiki/Mailing_Lists#Netiquette

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] GNUCash 4.9

[Steve Mortimer]

What I did to correct my problem was to take the last backup file and 
remove all of the dates in the file name and made that my main 
(orginial) transaction file.  I opened that file as the data file and 
used it.  This corrected the issue with I was having.


Thanks everyone for your responses.
Steve


Adrien Monteleone 
Monday, January 3, 2022 8:30 PM
Your original file never changes names, unless you do a File > Save 
As, or change it via your OS file manager.


If you ever see a file with a date stamp, it is a backup. Do not try 
to open it in order to work in your main file. If you do, you are 
instead working in a backup copy and the main file never gets changed.


This new backup then becomes your current 'working copy'.

If those truncated file names contain several (not just two) time 
stamps, this means you've done this repeatedly and have now seriously 
branched your file.


If you know for certain you never worked in any previous original or 
backup file after opening a later one, just do a File > Save As on the 
currently open file with a simpler name. Then only open that file to 
start GnuCash in the future. Or better yet, if you are only using a 
single file, just open GnuCash itself. It always defaults to the last 
open file.


If you want a desktop shortcut, make it to the GnuCash app itself, not 
your file. Store that in your Documents as already suggested. 
(backups, logs, and lck files will be stored with it)


Regards,
Adrien



___
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.
Steve Mortimer 
Monday, January 3, 2022 6:27 PM
Adrien,

Here is what I have found out.  Each time the program is closed it 
adds that date and time to the name of the file.  How can this be 
stopped?


I can change the name of the file so that there is only one date for 
the file name and bring it up with all of the transactions in the 
file.  I close the program and the file now has two dates showing on it.


Guess there is no original file on the computer.
Steve




--
Steve Mortimer

2 Timothy 3:16-17 (ESV)
All Scripture is breathed out by God and profitable for teaching, for 
reproof, for correction, and for training in righteousness that the man 
of God may be complete, equipped for every good work

___
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] Closing Books - Pros & Cons

[Mattia Rizzolo]

On Mon, Jan 03, 2022 at 08:39:26PM -0600, Adrien Monteleone wrote:
> You're welcome, and you did right by changing the subject. Unfortunately,
> replying to a digest doesn't thread to your original post. (as discussed in
> another thread) No way around that of which I am aware, but at least the
> subject is the same so we know what you are discussing!

Technically, the threading is implemented by following headers such as
"References" and "In-Reply-To", which points to all the relevant
Message-IDs.  One could add those headers manually, but that's clearly
behind what's to be expected of anybody who doesn't actually work on IT
(and even then, it's too bothersome).

-- 
regards,
Mattia Rizzolo

GPG Key: 66AE 2B4A FCCF 3F52 DA18  4D18 4B04 3FCD B944 4540  .''`.
More about me:  https://mapreri.org : :'  :
Launchpad user: https://launchpad.net/~mapreri  `. `'`
Debian QA page: https://qa.debian.org/developer.php?login=mattia  `-


signature.asc
Description: PGP signature
___
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] Idiots guide to building GNC 4.9 on Ubuntu 20.04LTS

[davidcousens49]

Jeff,

If you are having difficulty Jeff you will have to tell us exactly what you have
done and which commands you have entered into the terminal and exactly what the
terminal output is to each command. We are not mind readers and we are not on
your system so unless you tell us we do not know what is happening, we don't
know. 

We need information to diagnose problems. Even worse a lot of us will not be on
Ubuntu but on other Linux distributions. There are sometimes subtle and
sometimes not so subtle differences to Ubuntu. The build instructions do assume
some general familiarity with building software on Linux and Linux terminal
operation.

If you go to your Ubuntu menu, you should find a heading called something like
Administration and it will have an entry with a name like Software Sources. If
you click on that you will get a dialogue up. It should have a tab on the LH
side with a name like Official Repositories and if you click on that there
should be an entry Optional Sources.  If there is a switch, checkbox or other
control labelled "Software code repositories" or similar make sure it is
selected/checked etc.


I have found for example that the apt -y switch does not work on Linux Mint. I
am not sure about Ubuntu as Linux Mint uses a modified apt command. David
Whiting's script was for Ubuntu 20.04 so it should have worked to install the
dependencies. 

One thing you will have to do is find the script file in the file manager and
check that it is marked for execution. If not the script won't run. You may have
to alter the file manager options to display the file permissions. They should
be "-rwxrwxr-x". The "x" in the last position has to be present.

If not, if you open a terminal in the directory containing the copy of the
script file, then the command

chmod +x 

Re: [GNC] Closing Books - Pros & Cons

[Fred Bone]

On 03 January 2022 at 18:34, Ryan Carver said:

[...]
> PS - Am I correctly replying to the List Serve in regards to "editing the
> subject line" and "replying all" so the thread is documented correctly? As
> mentioned, I am knew to all this.

You are replying to a plaintext Digest. Threading only works if you are 
replying to a single message.


___
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] A repository for user-contributed files

[Liz]

On Tue, 4 Jan 2022 09:48:52 +
"Dr. David Kirkby"  wrote:

> I think there’s a good argument for either
> a) Stopping the digest mode OR
> b) Insisting that if people want to reply to something that they see
> in the digest, they reply to the archive - assuming that maintains
> the thread.
> 
> In this day and age, people the bandwidth used by emails is a small
> fraction of the overall bandwidth people have. People can set up
> filters so that GnuCash emails go there. Then they scan the titles
> and see if things interest them.


Of the 2186 email accounts subscribed to Gnucash-user, 198 use the
digest mode.
It will continue to be available

Liz, with moderator hat.
___
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] A repository for user-contributed files

[Dr. David Kirkby]

On Mon, 3 Jan 2022 at 22:08, Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> But I
> guess if they are replying to the digest and they copy-paste the
> subject, as they should, then it will appear un-threaded.


I think there’s a good argument for either
a) Stopping the digest mode OR
b) Insisting that if people want to reply to something that they see in the
digest, they reply to the archive - assuming that maintains the thread.

In this day and age, people the bandwidth used by emails is a small
fraction of the overall bandwidth people have. People can set up filters so
that GnuCash emails go there. Then they scan the titles and see if things
interest them.

You may recall me asking why people started new threads a couple of weeks
back. Not only did my thread on bitcoin got broken at least once, a new
thread made an error in copying the title .

Dave.
-- 
Dr. David Kirkby,
Kirkby Microwave Ltd,
drkir...@kirkbymicrowave.co.uk
https://www.kirkbymicrowave.co.uk/
Telephone 01621-680100./ +44 1621 680100

Registered in England & Wales, company number 08914892.
Registered office:
Stokes Hall Lodge, Burnham Rd, Althorne, Chelmsford, Essex, CM3 6DT, United
Kingdom
___
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] Idiots guide to building GNC 4.9 on Ubuntu 20.04LTS

[Adrien Monteleone]

*Caveat, I haven't tried building 4.9 yet, or used the referenced 
script, but the below should still apply generally:


You're not dealing with a PPA.

The script is getting the source from Github and then building.

A PPA contains already built packages.

The wiki shows how to get info from the tracefile and how to run from 
the terminal to get error output.


Reporting back that info, might enable someone here to help you figure 
out why the app built successfully, but doesn't run properly.


You are (allegedly) beyond the build stage. Now you have run-time 
problems. (which could be due to a faulty build, but without precise 
error info, there is no way to know)


Regards,
Adrien

On 1/4/22 12:49 AM, Jeff wrote:
I executed the above script but it did not build an executable version 
of GNC.  Correction, it built an executable program, that immediately 
started spouting error messages then even faster closed its terminal 
window.


A couple of posts remind to remember to "tick Source Code in the 
Software And Updates dialogue" or the script would not work.  They fail 
to mention for what PPA.


What PPA's do I need for GNC?  (on Ubuntu 20.04LTS)

The desktop icon file was also a complete gremlin. That issue may 
resolve itself once I can successfully build a live, healthy, vivacious, 
running version of 4.9 from source.


As of now I am renaming the thread from "how to remove both GNC 4.2 and 
Flathub version 4.8 so can upgrade to 4.9 on Ubuntu 20.04LTS" to "Idiots 
guide to building GNC 4.9 on Ubuntu 20.04LTS" as we have moved way past 
removing 4.2 and Flathub 4.8.  Right now I feel like a CSC 101 student 
in a CSC 401 class, even though I went to CSC 640 in college and 880 in 
the real world, yet I cannot successfully build GNC.  Both irritating 
and humiliating.


Somewhere I am overlooking that one simple first year programmers error.



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