Re: [GNC] How to run Year End Procedures for the Tax Year (UK end 5 April 2023), and start new Data set for the New Tax Year starting 6 April 2023

[G R Hewitt]

*'When I was a systems designer for corporate accounting systems in the
80s, it was entirely anathema for anything to be modified, EVER. The only
way to fix an error, even one made seconds ago, was to add a reversing
entry*
* and then re-add (the correct version of) the original.'*

I was/am a fan of that, especially in a multi-user environment.
Correcting the original entry, especially when you don't know what you are
doing is fraught with problems later on;
especially susceptible to this was Sage Line 50, particularly when people
who shouldn't have but did have 'Manager'
level access.

On Sat, 8 Apr 2023 at 01:36,  wrote:

> Hi,
>
> I'm sure many here will consider the following to be a less "legit"
> approach, but I just wanted to chime in to say that I use a very different
> way of dealing with year-ends closings.
>
> Firstly, you should know three things:
>
> 1. All the Close Book function really does is create two split transactions
> on the specified closing date: one that zeroes out all the Income Accounts,
> and another that zeroes the Cost (Expense) Accounts. This allows you to
> start the next fiscal year with zero balances in income and expense
> accounts. The other side of each transaction is booked to whatever Equity
> account you specify when closing.
>
> 2. You can easily reverse the effect of the effect of closing by simply
> deleting the two closing transactions, and you can redo the closing again
> at
> any time too. In fact, if you must "fix" a closed prior year (see note
> below), it's easier to delete the closing entries, make the fix, and rerun
> the closing than it is to manually tweak the closing entries.
>
> 3. I have found some reports do allow stripping out the closing entries --
> and avoiding a nonsensical report -- but others don't have this feature.
> There's a post of mine here a few weeks ago about a five-year history
> report
> that always shows zeros for the first four years, because the report
> includes the closing entries for each year, which (by design) reverses the
> effect of all other transactions in the year. One (messy) approach to
> solving this involves making a temporary copy of the data file, deleting
> the
> closing transactions for all prior years, running the historical reports,
> and finally deleting the temporary copy (note that the approach described
> by
> others here doesn't work when trying to get a five-year cost history).
>
> That being said, there are comments in various Gnucash places
> (Documentation, Wiki, Mailing List histories) to the effect that closing
> books is considered a slightly old-fashioned way of doing things, and
> although perhaps not discouraged, isn't strictly necessary. My own
> preference is to do annual closings on all five sets of books I track. It
> makes some reporting a little trickier to obtain, but on balance I like it
> better.
>
> The other point relates to what I said before about "fixing" a closed prior
> year. When I was a systems designer for corporate accounting systems in the
> 80s, it was entirely anathema for anything to be modified, EVER. The only
> way to fix an error, even one made seconds ago, was to add a reversing
> entry
> and then re-add (the correct version of) the original. Later systems became
> more and more liberal about this -- there are still always audit trails if
> one really must dig into things in cases like fraud -- and now we have
> reached a point where nothing is really locked in stone forever.
>
> Everyone here will have their own policies / morals about what is allowed
> to
> be modified later. In my case, I'm retired and the books I track aren't for
> legal / tax reporting, so I can change prior years and rerun things when
> appropriate. I'm sure many others here have much stricter requirements!
>
> Paul
>
> -Original Message-
> From: gnucash-user  On
> Behalf Of CJN ...
> Sent: Friday, April 7, 2023 7:37 PM
> To: Stan Brown ; GnuCash User List
> 
> Subject: Re: [GNC] How to run Year End Procedures for the Tax Year (UK end
> 5
> April 2023), and start new Data set for the New Tax Year starting 6 April
> 2023
>
> 8 April 2023
>
> WOW - Thanks to all of you who have sent me advice of setting up GNU-Cash
> for a new Financial Year.
>
> Read all your messages - all very helpful.
> Looked at the Help-Contents on Closing (after Year End 5 April) Closed
> Accounts. And started new set of data.
> And entered data for the Transactions of the last few days from New Year
> Start 6 April.
>
> And as far as I can see from Trial Balance, and Income/Expenses Reports,
> all
> data is as it should be!
>
> It's been a long Good Friday for this accounting novice. But I think I got
> there.
> Just hope I remember it all for the next Year End :) - Or I might be back
> for more Help!
>
> Chris
> London
> cjn-internatio...@hotmail.com
>
>
> -Original Message-
> From: gnucash-user
> [mailto:gnucash-user-bounces+cjn_international=hotmail@gnucash.org] On
> Behalf Of Stan Brown
> Sent:

[GNC] Mea Culpa

[G R Hewitt]

Concerning the year end discussion, which I have been following,
my input was to mention that the manual stated that if you close the books
the report totals may be different, and I postulated that this was so as I
had
tested it and indeed they were different QED.
However, as the discussion progressed, I began to doubt my conclusions and
went to
investigate further, and found that after 'Closing' the books, then opening
each report and running a 'Clear All' accounts and then 'Select All'
accounts then 'Apply', the reports- P&L, TB and BS all reported correctly.
This is most pleasing, as I am definitely a 'Close the books and draw a
line under them' person, and it was a 'mind splinter' not to have
everything zeroed at start of year.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Mea Culpa

[Stan Brown]

On 2023-04-08 02:48, G R Hewitt wrote:
> Concerning the year end discussion, which I have been following,
> my input was to mention that the manual stated that if you close the books
> the report totals may be different, and I postulated that this was so as I
> had
> tested it and indeed they were different QED.
> However, as the discussion progressed, I began to doubt my conclusions and
> went to
> investigate further, and found that after 'Closing' the books, then opening
> each report and running a 'Clear All' accounts and then 'Select All'
> accounts then 'Apply', the reports- P&L, TB and BS all reported correctly.
> This is most pleasing, as I am definitely a 'Close the books and draw a
> line under them' person, and it was a 'mind splinter' not to have
> everything zeroed at start of year.

Thanks for letting us know!


Stan Brown
Tehachapi, CA, USA
https://BrownMath.com
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] How to run Year End Procedures for the Tax Year (UK end 5 April 2023), and start new Data set for the New Tax Year starting 6 April 2023

[G R Hewitt]

Mea Culpa
Concerning the year end discussion, which I have been following,
my input was to mention that the manual stated that if you close the books
the report totals may be different, and I postulated that this was so as I
had
tested it and indeed they were different QED.
However, as the discussion progressed, I began to doubt my conclusions and
went to
investigate further, and found that after 'Closing' the books, then opening
each report and running a 'Clear All' accounts and then 'Select All'
accounts then 'Apply', the reports- P&L, TB and BS all reported correctly.
This is most pleasing, as I am definitely a 'Close the books and draw a
line under them' person, and it was a 'mind splinter' not to have
everything zeroed at start of year.

On Sat, 8 Apr 2023 at 09:12, G R Hewitt  wrote:

>
>
>
> *'When I was a systems designer for corporate accounting systems in the
> 80s, it was entirely anathema for anything to be modified, EVER. The only
> way to fix an error, even one made seconds ago, was to add a reversing
> entry*
> * and then re-add (the correct version of) the original.'*
>
> I was/am a fan of that, especially in a multi-user environment.
> Correcting the original entry, especially when you don't know what you are
> doing is fraught with problems later on;
> especially susceptible to this was Sage Line 50, particularly when people
> who shouldn't have but did have 'Manager'
> level access.
>
> On Sat, 8 Apr 2023 at 01:36,  wrote:
>
>> Hi,
>>
>> I'm sure many here will consider the following to be a less "legit"
>> approach, but I just wanted to chime in to say that I use a very different
>> way of dealing with year-ends closings.
>>
>> Firstly, you should know three things:
>>
>> 1. All the Close Book function really does is create two split
>> transactions
>> on the specified closing date: one that zeroes out all the Income
>> Accounts,
>> and another that zeroes the Cost (Expense) Accounts. This allows you to
>> start the next fiscal year with zero balances in income and expense
>> accounts. The other side of each transaction is booked to whatever Equity
>> account you specify when closing.
>>
>> 2. You can easily reverse the effect of the effect of closing by simply
>> deleting the two closing transactions, and you can redo the closing again
>> at
>> any time too. In fact, if you must "fix" a closed prior year (see note
>> below), it's easier to delete the closing entries, make the fix, and rerun
>> the closing than it is to manually tweak the closing entries.
>>
>> 3. I have found some reports do allow stripping out the closing entries --
>> and avoiding a nonsensical report -- but others don't have this feature.
>> There's a post of mine here a few weeks ago about a five-year history
>> report
>> that always shows zeros for the first four years, because the report
>> includes the closing entries for each year, which (by design) reverses the
>> effect of all other transactions in the year. One (messy) approach to
>> solving this involves making a temporary copy of the data file, deleting
>> the
>> closing transactions for all prior years, running the historical reports,
>> and finally deleting the temporary copy (note that the approach described
>> by
>> others here doesn't work when trying to get a five-year cost history).
>>
>> That being said, there are comments in various Gnucash places
>> (Documentation, Wiki, Mailing List histories) to the effect that closing
>> books is considered a slightly old-fashioned way of doing things, and
>> although perhaps not discouraged, isn't strictly necessary. My own
>> preference is to do annual closings on all five sets of books I track. It
>> makes some reporting a little trickier to obtain, but on balance I like it
>> better.
>>
>> The other point relates to what I said before about "fixing" a closed
>> prior
>> year. When I was a systems designer for corporate accounting systems in
>> the
>> 80s, it was entirely anathema for anything to be modified, EVER. The only
>> way to fix an error, even one made seconds ago, was to add a reversing
>> entry
>> and then re-add (the correct version of) the original. Later systems
>> became
>> more and more liberal about this -- there are still always audit trails if
>> one really must dig into things in cases like fraud -- and now we have
>> reached a point where nothing is really locked in stone forever.
>>
>> Everyone here will have their own policies / morals about what is allowed
>> to
>> be modified later. In my case, I'm retired and the books I track aren't
>> for
>> legal / tax reporting, so I can change prior years and rerun things when
>> appropriate. I'm sure many others here have much stricter requirements!
>>
>> Paul
>>
>> -Original Message-
>> From: gnucash-user  On
>> Behalf Of CJN ...
>> Sent: Friday, April 7, 2023 7:37 PM
>> To: Stan Brown ; GnuCash User List
>> 
>> Subject: Re: [GNC] How to run Year End Procedures for the Tax Year (UK
>> end 5
>> April 2023), and start new Data set 

Re: [GNC] Command line quotes still not fixed

[Murugan Muruganandam]

Alphavantage is required for currency rates




Saludos Cordiales


Murugan


From: gnucash-user 
 on behalf of 
David G. Pickett via gnucash-user 
Sent: Thursday, April 6, 2023 4:41 PM
To: hell...@gmail.com 
Cc: gnucash-user@gnucash.org 
Subject: Re: [GNC] Command line quotes still not fixed

As I do not use Alphavantage, just 'Yahoo as json', why is it looking for an 
api key?


-Original Message-
From: David H 
To: David G. Pickett 
Cc: geert.gnuc...@kobaltwit.be ; 
gnucash-user@gnucash.org ; jra...@ceridwen.us 

Sent: Thu, Apr 6, 2023 4:21 pm
Subject: Re: [GNC] Command line quotes still not fixed

I don't think the version difference is a mystery - remember that Flatpak is a 
sandbox so presumably brings along whatever perl version it was built/packaged 
with.  If you set your Alphavantage api key in the Gnucash application itself 
you'll probably also also get rid of the other error message. The following is 
all I get displayed using Geert's command format:
flatpak run --command=gnucash-cli org.gnucash.GnuCash --quotes get -- 
'/home/h/Documents/GnuCash/Data Files/h.gnucash'
Found Finance::Quote version 1.5301.

Cheers David H.

On Fri, 7 Apr 2023 at 05:08, David G. Pickett  wrote:

I don't understand why, but "--" does also work, like "--namespace='.*'".

I still get a lot of errors that do not affect my quote fetch.
It finds 1.5301 even though I installed 1.5401, a different mystery!

dgp@dgp-p6803w:~$ flatpak run --command=gnucash-cli org.gnucash.GnuCash 
--quotes get -- /home/dgp/GnuCash/ubuntu-DGPickett.gnucash* 15:05:17  WARN 
 [GncFQQuoteSource::GncFQQuoteSource()] No Alpha Vantage API 
key set, currency quotes and other AlphaVantage based quotes won't work.Found 
Finance::Quote version 1.5301.dgp@dgp-p6803w:~$ flatpak run 
--command=gnucash-cli org.gnucash.GnuCash --quotes get --namespace='.*' 
/home/dgp/GnuCash/ubuntu-DGPickett.gnucash* 15:05:57  WARN  
[GncFQQuoteSource::GncFQQuoteSource()] No Alpha Vantage API key set, currency 
quotes and other AlphaVantage based quotes won't work.Found Finance::Quote 
version 1.5301.dgp@dgp-p6803w:~$
-Original Message-
From: Geert Janssens 
To: David H ; gnucash-user@gnucash.org 

Cc: David G. Pickett ; john 
Sent: Thu, Apr 6, 2023 3:47 am
Subject: Re: [GNC] Command line quotes still not fixed

Actually instead of adding a --namespace parameter, you can just use '--' to 
separate the named parameters from the positional parameters like so:flatpak 
run --command=gnucash-cli org.gnucash.GnuCash --quotes get -- 
/home/dgp/GnuCash/ubuntu-DGPickett.gnucash
That's a common unix way to solve such ambiquities.
Regards,
Geert
Op donderdag 6 april 2023 05:04:02 CEST schreef john:> The namespace parameter 
is a regular expression, so .* will get the quotes> from all of your 
namespaces.> > Regards,> John Ralls> > > On Apr 5, 2023, at 3:46 PM, David H 
 wrote:> > > > What default namespace, look in YOUR security 
editor - as far as> > I know it's whatever you set up.  I have a vague 
recollection that it> > doesn't really care and will be happy with just a 
single character> > i.e. --namespace=x> > but don't quote me on that.> > > > By 
the way your original email could do with some halfway decent> > formatting> > 
- see what the mailing list received at> > 
https://lists.gnucash.org/pipermail/gnucash-user/2023-April/106230.html> > you> 
> might like to tweak that to make it readable in future.> > > > Cheers David 
H.> > > > On Thu, 6 Apr 2023 at 07:46, David G. Pickett  
wrote:> >> I saw that later.  What's the default namespace?> >> > >> > >> 
-Original Message-> >> From: D
 avid H > >> To: David G. Pickett > >> 
Cc: gnucash-user@gnucash.org > >> Sent: Wed, Apr 5, 
2023 3:45 pm> >> Subject: Re: [GNC] Command line quotes still not fixed> >> > 
>> And you'll see there's a whole other thread on this -> >> 
https://lists.gnucash.org/pipermail/gnucash-user/2023-April/106181.html.> >> 
Bug report at https://bugs.gnucash.org/show_bug.cgi?id=798815> >> > >> If you 
include a namespace parameter for now it will work.> >> > >> Cheers David H.> 
>> > >> On Wed, 5 Apr 2023 at 23:00, David G. Pickett via gnucash-user <> >> 
gnucash-user@gnucash.org> wrote:> >> > >> I can still only update quotes with 
the interactive button, the flatpak> >> run gnucash command that ran in 4.* is 
still broken:> >> dgp@dgp-p6803w:~$ flatpak run --command=gnucash-cli 
org.gnucash.GnuCash> >> --quotes get 
/home/dgp/GnuCash/ubuntu-DGPickett.gnucashMissing data file> >> parameter> >> 
gnucash-cli [options] [datafile] - GnuCash, accounti
 ng for personal and> >> small business finance:> >> Common Options:  -h [ 
--help ]  Show this help message  -v [> >> --version ]   Show 
GnuCash version  --debugEnable> >> debugging mode: provide deep 
detail in the  logs.> >> > >>   
This is equivalent to: --log "=info" --log> >> > >> "qof=info"  
--log "gnc=info

Re: [GNC] Printing bug in GnuCash 5

[Murugan Muruganandam]

In File Page Setup reduce the Bottom Margin to 7 (or any lower number than the 
default) and try it out




Saludos Cordiales


Murugan


From: gnucash-user 
 on behalf of 
Tommy Trussell 
Sent: Thursday, April 6, 2023 6:14 PM
To: GNU Cash User 
Subject: [GNC] Printing bug in GnuCash 5

I'm running the Flathub 5.0-1 build on Ubuntu 22.04 and 22.10 (different
machines). I'm finding that on the SECOND page of Transaction reports,
there's often a line at the top that overprints the second line at the top
of the report. I don't see a problem on page 4, 5, etc., just page 2.

So far I've been able to work around it, but I'm mentioning it here, and I
filed bug # 798833

P.S.:
Overall I have been very happy with GnuCash 5.  I find that it loads the
data file noticeably faster.

I do find that the autocomplete has changed since 4.13 and I find that if I
click out of the field too soon the application is not so "aggressive"
about autocompleting as it used to be. I actually think this is a good
thing because previously it was very hard to override autocompletions that
start similarly, but I have to get used to it, and if I move too fast I
find I've entered strange partial strings in the Description fields.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Calculating IRR of an investment account

[Graham]

I have tried the manual without much success, and tried two different 
AIs [ChatGPT and Nova] but both give me instructions that don't seem to 
exist, such as :


1. Click on the "Reports" menu and select "New Report".
2. In the "Report Type" dropdown, select "Transaction".
3. Click on the "Add Column" button to add the columns you want to
   include in your report. For example, you could add "Date",
   "Description", "Amount", and "Memo" columns.
4. Click on the "Grouping" dropdown and select "Date".
5. In the "Filter" section, set the date range for the period you want
   to calculate the IRR for.
6. Click on the "Customize Report" button to open the report
   customization panel.
7. In the "Computation" section, click on the "Add" button to add a new
   computation to your report.
8. In the "Computation" dropdown, select "Internal Rate of Return (IRR)".

New report I take to be a new transaction report, but I can't see any 
add column button, customize report or computation options.


Am I missing something, or is AI as stupid as me? (Win 10, Gnucash 5.0)


--
--
Cheerio,

Graham
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Calculating IRR of an investment account

[Graham]

I have tried the manual without much success, and tried two different 
AIs [ChatGPT and Nova] but both give me instructions that don't seem to 
exist, such as :


1. Click on the "Reports" menu and select "New Report".
2. In the "Report Type" dropdown, select "Transaction".
3. Click on the "Add Column" button to add the columns you want to
   include in your report. For example, you could add "Date",
   "Description", "Amount", and "Memo" columns.
4. Click on the "Grouping" dropdown and select "Date".
5. In the "Filter" section, set the date range for the period you want
   to calculate the IRR for.
6. Click on the "Customize Report" button to open the report
   customization panel.
7. In the "Computation" section, click on the "Add" button to add a new
   computation to your report.
8. In the "Computation" dropdown, select "Internal Rate of Return (IRR)".

New report I take to be a new transaction report, but I can't see any 
add column button, customize report or computation options.


Am I missing something, or is AI as stupid as me? (Win 10, Gnucash 5.0)


--
--
Cheerio,

Graham
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Calculating IRR of an investment account

[G R Hewitt]

The clue is in the name - Artificial Intelligence (AI)

adjective: artificial:
made or produced by human beings rather than occurring naturally,
especially as a copy of something natural.

Fear not, AI is much stupider.


On Sat, 8 Apr 2023 at 13:01, Graham  wrote:

> I have tried the manual without much success, and tried two different
> AIs [ChatGPT and Nova] but both give me instructions that don't seem to
> exist, such as :
>
>  1. Click on the "Reports" menu and select "New Report".
>  2. In the "Report Type" dropdown, select "Transaction".
>  3. Click on the "Add Column" button to add the columns you want to
> include in your report. For example, you could add "Date",
> "Description", "Amount", and "Memo" columns.
>  4. Click on the "Grouping" dropdown and select "Date".
>  5. In the "Filter" section, set the date range for the period you want
> to calculate the IRR for.
>  6. Click on the "Customize Report" button to open the report
> customization panel.
>  7. In the "Computation" section, click on the "Add" button to add a new
> computation to your report.
>  8. In the "Computation" dropdown, select "Internal Rate of Return (IRR)".
>
> New report I take to be a new transaction report, but I can't see any
> add column button, customize report or computation options.
>
> Am I missing something, or is AI as stupid as me? (Win 10, Gnucash 5.0)
>
>
> --
> --
> Cheerio,
>
> Graham
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> 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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Calculating IRR of an investment account

[Stan Brown]

On 2023-04-08 05:02, Graham wrote:
> I have tried the manual without much success, and tried two different
> AIs [ChatGPT and Nova] but both give me instructions that don't seem to
> exist, such as :
> 
> 1. Click on the "Reports" menu and select "New Report".
> 2. In the "Report Type" dropdown, select "Transaction".
> 3. Click on the "Add Column" button to add the columns you want to
>    include in your report. For example, you could add "Date",
>    "Description", "Amount", and "Memo" columns.
> 4. Click on the "Grouping" dropdown and select "Date".
> 5. In the "Filter" section, set the date range for the period you want
>    to calculate the IRR for.
> 6. Click on the "Customize Report" button to open the report
>    customization panel.
> 7. In the "Computation" section, click on the "Add" button to add a new
>    computation to your report.
> 8. In the "Computation" dropdown, select "Internal Rate of Return (IRR)".
> 
> New report I take to be a new transaction report, but I can't see any
> add column button, customize report or computation options.
> 
> Am I missing something, or is AI as stupid as me? (Win 10, Gnucash 5.0)

AI lives up to its adjective, but not so well to its noun. A recent
story detailed "hallucinations" in AI -- for instance, you could ask it
for the record holder in walking across the English Channel and get an
answer that seemed authoritative, except obviously it wasn't.


Stan Brown
Tehachapi, CA, USA
https://BrownMath.com
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Assign as payment does nothing

[Tom Weichmann]

Note: after having this issue I decided to go to GNUCash 4.14, however I
noticed 4.14 has the same issue.  So then I went back to 4.13 and the issue
was fixed.  So there is something that was added to both 4.14 as well as
5.0 which has created a regression,

On Fri, Apr 7, 2023 at 6:12 PM Tom Weichmann  wrote:

> GNUCash 5.0
> Ubuntu 22.04
> Compiled from source
>
> Right click on item in regester, click assign as payment, choose
> customer from dialog -> choose open invoice from dialog (highlighting open
> invoice).  Click OK.  The items transfer account should change to Accounts
> receivable and mark the invoice as paid, but neither of these happen.
>
> Wanted to check if anyone else has seen this behaviour or if I need to
> file a bug report.
>
> Thanks,
>
> Tom
>
>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] New feature suggestion

[S]

Using GnuCash

Version: 4.8
Build ID: 4.8a+(2021-09-28)
Finance::Quote: 1.51

on Ubuntu Linux

---

A) Since there is a an account tree export/import tool, it would be 
useful & time saving to have the following features:


1- An option for  "New account wizard" to directly import a tree 
structure rather than going through the current set of options.


2- To have an export / import tool for scheduled transactions, with a 
sub option of extending limited end dates by a year.


Usage: These options can have different uses, but basically it is to 
replicate a file without its entries, keeping scheduled transactions.


For example if someone wants to use separate files for each accounting 
year, this facilitates replicating the file with all the accounts 
without any entries.


--

B) An option for Scheduled transactions to have a different first value 
and different last value


Usage: many repeating transactions can often start with a different 
first value and then a constant value repeating periodically. (sometimes 
one might get it the other way round where the last value is different).


 At the moment this different value needs to be entered separately.

Sha


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Calculating IRR of an investment account

[Graham]

I have tried the manual without much success, and tried two different 
AIs [ChatGPT and Nova] but both give me instructions that don't seem to 
exist, such as :


1. Click on the "Reports" menu and select "New Report".
2. In the "Report Type" dropdown, select "Transaction".
3. Click on the "Add Column" button to add the columns you want to
   include in your report. For example, you could add "Date",
   "Description", "Amount", and "Memo" columns.
4. Click on the "Grouping" dropdown and select "Date".
5. In the "Filter" section, set the date range for the period you want
   to calculate the IRR for.
6. Click on the "Customize Report" button to open the report
   customization panel.
7. In the "Computation" section, click on the "Add" button to add a new
   computation to your report.
8. In the "Computation" dropdown, select "Internal Rate of Return (IRR)".

New report I take to be a new transaction report, but I can't see any 
add column button, customize report or computation options.


Am I missing something, or is AI as stupid as me? (Win 10, Gnucash 5.0)


--
--
Cheerio,

Graham
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Calculating IRR of an investment account

[Stan Brown]

Thunderbird autosaves drafts, and they do not disappear automatically
from the Drafts folder after you send the message. You have to delete
them manually.

(It's bad design, I agree, because it leads to confusion. But there it
is: we get what we pay for.)

Stan Brown
Tehachapi, CA, USA
https://BrownMath.com

On 2023-04-08 07:16, Graham wrote:
> On 08/04/2023 13:24, Stan Brown wrote:
>> Please don't post the same thing twice. This seems to be happening more
>> and more often in the last few weeks.
>>
>> (And if you didn't post it twice, but it's a glitch in the mailing-list
>> software, my apologies.)
> 
> I apologise. Maybe it is a Thunderbird glitch. The 'draft'was still
> active in the draft folder so I assumed it had not been sent.
> 
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Calculating IRR of an investment account

[Michael or Penny Novack]

On 4/8/2023 10:27 AM, Stan Brown wrote:

Thunderbird autosaves drafts, and they do not disappear automatically
from the Drafts folder after you send the message. You have to delete
them manually.

(It's bad design, I agree, because it leads to confusion. But there it
is: we get what we pay for.)


Arguable --- I can see the case for both behaviors (delete draft after 
sending edited draft OR leave until explicit delete). The first, if not 
the action, can cause accidental resending (thinking not done yet) but 
the second can save a great deal of work when you are wanting to send 
multiple very slightly different versions of an email << eg: 
personalized for each recipient >>. Yes, there are other ways to do that 
(copy/paste from elsewhere the constant, pre edited text).


Michael D Novack

PS -- What makes you think commercial software is better in that regard? 
It will be designed according to how the designers think the majority of 
their customers would want. Choice of behavior MIGHT be provided if they 
think the minority also a significant number. But often is not.


  For example, I live where there is no cell service. Do you know 
what percentage of websites requiring account creation REQUIRE a mobile 
number (verification by text) vs how many provide an alternative (email 
of land line number sent an automated call). I do. I can even recognize 
one situation where I can tell more than one designer involved in the 
design (early in the process allows use of the alternative "verify via 
code sent by automated voice to a land line or by email" but at the 
completion of the process "must enter mobile number for verification 
sent by text" - insanely this is a process for setting up "paperless 
billing" FOR A LAND LINE). The point is maybe 97% of people here in the 
US live where can have a mobile, only 3% live where no service, so 
forget about them.




___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Importing QFX

[Alan Schold via gnucash-user]

I just upgraded to 5.0 and now can no longer find the QFX choice under 
Import. Where did it go?


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Calculating IRR of an investment account

[William Prescott]

Or, as another example: sites that require a phone number (maybe for 2FA 
[second factor authentification]), but only accept US phone numbers. It is a 
major pain for those of us that don't live in the US, but have extensive 
dealings with US companies.

Will

On Apr 8, 2023, at 09:18, Michael or Penny Novack  
wrote:

PS -- What makes you think commercial software is better in that regard? It 
will be designed according to how the designers think the majority of their 
customers would want. Choice of behavior MIGHT be provided if they think the 
minority also a significant number. But often is not.

  For example, I live where there is no cell service. Do you know what 
percentage of websites requiring account creation REQUIRE a mobile number 
(verification by text) vs how many provide an alternative (email of land line 
number sent an automated call). I do. I can even recognize one situation where 
I can tell more than one designer involved in the design (early in the process 
allows use of the alternative "verify via code sent by automated voice to a 
land line or by email" but at the completion of the process "must enter mobile 
number for verification sent by text" - insanely this is a process for 
setting up "paperless billing" FOR A LAND LINE). The point is maybe 97% of 
people here in the US live where can have a mobile, only 3% live where no 
service, so forget about them.



___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Importing QFX

[Gyle McCollam]

There is a bug filed, but the fix is promised for 5.1.  I reverted back to 4.13 
until then.


Thank You,

Gyle McCollam

Gyle McCollam

gmccol...@live.com   email


From: gnucash-user  on 
behalf of Alan Schold via gnucash-user 
Sent: Saturday, April 8, 2023 11:30 AM
To: GNU Cash User 
Subject: [GNC] Importing QFX

I just upgraded to 5.0 and now can no longer find the QFX choice under
Import. Where did it go?

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Calculating IRR of an investment account

[David Carlson]

This thread has been hijacked and no longer ir relating to the original
request about creating a report for Internal Rate of Return (IRR).
I would like to see an answer to that question.

On Sat, Apr 8, 2023 at 10:33 AM William Prescott 
wrote:

> Or, as another example: sites that require a phone number (maybe for 2FA
> [second factor authentification]), but only accept US phone numbers. It is
> a major pain for those of us that don't live in the US, but have extensive
> dealings with US companies.
>
> Will
>
> On Apr 8, 2023, at 09:18, Michael or Penny Novack <
> stepbystepf...@comcast.net> wrote:
>
> PS -- What makes you think commercial software is better in that regard?
> It will be designed according to how the designers think the majority of
> their customers would want. Choice of behavior MIGHT be provided if they
> think the minority also a significant number. But often is not.
>
>   For example, I live where there is no cell service. Do you know what
> percentage of websites requiring account creation REQUIRE a mobile number
> (verification by text) vs how many provide an alternative (email of land
> line number sent an automated call). I do. I can even recognize one
> situation where I can tell more than one designer involved in the design
> (early in the process allows use of the alternative "verify via code sent
> by automated voice to a land line or by email" but at the completion of the
> process "must enter mobile number for verification sent by text" -
> insanely this is a process for setting up "paperless billing" FOR A LAND
> LINE). The point is maybe 97% of people here in the US live where can have
> a mobile, only 3% live where no service, so forget about them.
>
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> 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
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


-- 
David Carlson
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Reports don't open after some activity in 5.0

[paul]

Using 5.0 I have at least thrice encountered an issue in which some (perhaps 
many) reports don't operate. The menu and submenus open, but selecting an 
actual report is essentially a no-op: nothing happens. Not all reports fail to 
open, but the one I've been using as a test case is the Transaction Report due 
to its simplicity.

This only seems to happen after some fairly complex interactions in the file, 
such as downloading OFX files, reconciling, opening other reports, and 
navigating within / editing registers. Simply closing Gnucash and reopening 
resolves the issue. I haven't yet been able to identify which specific prior 
action is "breaking" the report open logic, but it's happened in at least two 
sets of books here, so it doesn't seem to be a data file issue.

There's not enough info yet to make a bug report, but I will do so as soon as I 
can nail down more specific "steps to recreate".

I'm on windows 10, fully updated, running Gnucash 5.0. Perhaps others have 
encountered this? Is there a log anywhere that might show how far into the 
report creation sequence it's getting before it dies?

Paul

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] How to run Year End Procedures for the Tax Year (UK end 5 April 2023), and start new Data set for the New Tax Year starting 6 April 2023

[Adrien Monteleone]

Stan,

I'm certainly not trying to convince anyone of any procedure, but for 
those interested, what you describe about the Accounts page without 
running a report is achievable without closing the books.


Adding the column 'Total (period)' to the Accounts page will show only 
the current accounting period (by default 'this year') totals for 
Expenses & Income.


Of course, the balance in the account register is still from the 
beginning of the book in that case. (as is the default 'Total' column on 
the Accounts tab)



Regards,
Adrien

On 4/7/23 9:21 PM, Stan Brown wrote:

I close my books each year so that the balances in my income and expense
accounts will be totals for the current year only. If I had to redo
prior-year reports or some reason it would be slightly awkward; but
that's minor against the convenience (for me) of being able to see
year-to-date income in the Accounts page and in the registers of the
individual accounts. That's faster than pulling a report, at least for me.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Mea Culpa

[Adrien Monteleone]

G R,

Could you perhaps add that info to the bug report on the documentation 
change?


https://bugs.gnucash.org/show_bug.cgi?id=798798

If this is verified as in some cases being needed to get those reports 
to behave with closing entries, that info can be included and/or it 
might expose a subsequent bug that someone might fix.


Regards,
Adrien

On 4/8/23 4:48 AM, G R Hewitt wrote:

Concerning the year end discussion, which I have been following,
my input was to mention that the manual stated that if you close the books
the report totals may be different, and I postulated that this was so as I
had
tested it and indeed they were different QED.
However, as the discussion progressed, I began to doubt my conclusions and
went to
investigate further, and found that after 'Closing' the books, then opening
each report and running a 'Clear All' accounts and then 'Select All'
accounts then 'Apply', the reports- P&L, TB and BS all reported correctly.
This is most pleasing, as I am definitely a 'Close the books and draw a
line under them' person, and it was a 'mind splinter' not to have
everything zeroed at start of year.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Calculating IRR of an investment account

[Adrien Monteleone]

ChatGPT and other 'AI' bots are merely really fancy auto-complete. They 
produce 'plausible' text, but they have no concept of accuracy or any 
understanding of the meanings of any of the words used.


I have no fear of them because I understand that is what they are.

My fear is that others think those bots are more capable than they are, 
and thus ascribe any degree of reliance upon them.


If you have a really large data set of strings, and want various types 
of averages - they are a good use case. Everything else?—no.


Regards,
Adrien

On 4/8/23 7:00 AM, Graham wrote:
I have tried the manual without much success, and tried two different 
AIs [ChatGPT and Nova] but both give me instructions that don't seem to 
exist, such as :


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Calculating IRR of an investment account

[Adrien Monteleone]

I long ago turned off auto-saving drafts for that very reason. Mail.app 
on MacOS does the same. It will auto-save while you are typing at 
various stages and you'll end up with multiple drafts of the same 
in-progress message.


I consider that a bug for both apps. I see neither has been addressed in 
many, many, years.


If I need to put a message 'down' for later completion before sending, 
it costs me nothing to click the 'save draft' button compared to 
cleaning up the app's mess.


Regards,
Adrien

On 4/8/23 9:27 AM, Stan Brown wrote:

Thunderbird autosaves drafts, and they do not disappear automatically
from the Drafts folder after you send the message. You have to delete
them manually.

(It's bad design, I agree, because it leads to confusion. But there it
is: we get what we pay for.)


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] How to run Year End Procedures for the Tax Year (UK end 5 April 2023), and start new Data set for the New Tax Year starting 6 April 2023

[Stan Brown]

> On 4/7/23 9:21 PM, Stan Brown wrote:
>> I close my books each year so that the balances in my income and
>> expense accounts will be totals for the current year only. If I had
>> to redo prior-year reports or some reason it would be slightly
>> awkward; but that's minor against the convenience (for me) of being
>> able to see year-to-date income in the Accounts page and in the
>> registers of the individual accounts. That's faster than pulling a
>> report, at least for me.
On 2023-04-08 10:12, Adrien Monteleone wrote:
> I'm certainly not trying to convince anyone of any procedure, but for
> those interested, what you describe about the Accounts page without
> running a report is achievable without closing the books.
> 
> Adding the column 'Total (period)' to the Accounts page will show only
> the current accounting period (by default 'this year') totals for
> Expenses & Income.
> 
> Of course, the balance in the account register is still from the
> beginning of the book in that case. (as is the default 'Total' column on
> the Accounts tab)

Interesting. The only customization of the Accounts page I'd ever done,
till reading your note, was adding to Account Code column.

Out of curiosity I tried Total (period) as you mentioned. Of course in
my case, since I closed the books at the end of 2022, the total (period)
and total columns are the same for income and expenses. But they are
_not_ the same for assets, liabilities, and equity. This is a nice way
to make the current year's change in those accounts visible.

Stan Brown
Tehachapi, CA, USA
https://BrownMath.com
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Importing QFX

[R Losey]

It's on holiday.  :)

It will be back.

On Sat, Apr 8, 2023 at 10:31 AM Alan Schold via gnucash-user <
gnucash-user@gnucash.org> wrote:

> I just upgraded to 5.0 and now can no longer find the QFX choice under
> Import. Where did it go?
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


-- 
_
Richard Losey
rlo...@gmail.com
Micah 6:8
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Calculating IRR of an investment account

[R Losey]

Personally, I don't necessarily trust what some program may call the IRR...
if I wanted to calculate it, I would export the necessary data to a
spreadsheet and then use the spreadsheet's power to calculate it.

On Sat, Apr 8, 2023 at 11:41 AM David Carlson 
wrote:

> This thread has been hijacked and no longer ir relating to the original
> request about creating a report for Internal Rate of Return (IRR).
> I would like to see an answer to that question.
>
> On Sat, Apr 8, 2023 at 10:33 AM William Prescott 
> wrote:
>
> > Or, as another example: sites that require a phone number (maybe for 2FA
> > [second factor authentification]), but only accept US phone numbers. It
> is
> > a major pain for those of us that don't live in the US, but have
> extensive
> > dealings with US companies.
> >
> > Will
> >
> > On Apr 8, 2023, at 09:18, Michael or Penny Novack <
> > stepbystepf...@comcast.net> wrote:
> >
> > PS -- What makes you think commercial software is better in that regard?
> > It will be designed according to how the designers think the majority of
> > their customers would want. Choice of behavior MIGHT be provided if they
> > think the minority also a significant number. But often is not.
> >
> >   For example, I live where there is no cell service. Do you know
> what
> > percentage of websites requiring account creation REQUIRE a mobile number
> > (verification by text) vs how many provide an alternative (email of land
> > line number sent an automated call). I do. I can even recognize one
> > situation where I can tell more than one designer involved in the design
> > (early in the process allows use of the alternative "verify via code sent
> > by automated voice to a land line or by email" but at the completion of
> the
> > process "must enter mobile number for verification sent by text" -
> > insanely this is a process for setting up "paperless billing" FOR A LAND
> > LINE). The point is maybe 97% of people here in the US live where can
> have
> > a mobile, only 3% live where no service, so forget about them.
> >
> >
> >
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > -
> > 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
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> >
>
>
> --
> David Carlson
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


-- 
_
Richard Losey
rlo...@gmail.com
Micah 6:8
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Calculating IRR of an investment account

[edodd]

On Sat, 8 Apr 2023 13:00:43 +0100
Graham  wrote:

> I have tried the manual without much success, and tried two different 
> AIs [ChatGPT and Nova] but both give me instructions that don't seem
> to exist, such as :

I was wondering if the AI was capable of answering questions as well as
the users.
Thanks for trying it out!

Liz
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Reports don't open after some activity in 5.0

[John Ralls]

We've fixed several reports issues already so you might try the latest nightly 
build from https://code.gnucash.org/builds/win32/stable/

Regards,
John Ralls


> On Apr 8, 2023, at 10:02 AM,   wrote:
> 
> Using 5.0 I have at least thrice encountered an issue in which some (perhaps 
> many) reports don't operate. The menu and submenus open, but selecting an 
> actual report is essentially a no-op: nothing happens. Not all reports fail 
> to open, but the one I've been using as a test case is the Transaction Report 
> due to its simplicity.
> 
> This only seems to happen after some fairly complex interactions in the file, 
> such as downloading OFX files, reconciling, opening other reports, and 
> navigating within / editing registers. Simply closing Gnucash and reopening 
> resolves the issue. I haven't yet been able to identify which specific prior 
> action is "breaking" the report open logic, but it's happened in at least two 
> sets of books here, so it doesn't seem to be a data file issue.
> 
> There's not enough info yet to make a bug report, but I will do so as soon as 
> I can nail down more specific "steps to recreate".
> 
> I'm on windows 10, fully updated, running Gnucash 5.0. Perhaps others have 
> encountered this? Is there a log anywhere that might show how far into the 
> report creation sequence it's getting before it dies?
> 
> Paul
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> 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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Calculating IRR of an investment account

[John Ralls]

GnuCash doesn't even claim to have an IRR calculation, so exporting to a 
spreadsheet is the only option.

The advanced portfolio report does have "rate of gain" and "rate of return" 
columns but they're really just percent return, independent of holding period 
or timing of cash flows.

Regards,
John Ralls

> On Apr 8, 2023, at 3:03 PM, R Losey  wrote:
> 
> Personally, I don't necessarily trust what some program may call the IRR...
> if I wanted to calculate it, I would export the necessary data to a
> spreadsheet and then use the spreadsheet's power to calculate it.
> 
> On Sat, Apr 8, 2023 at 11:41 AM David Carlson 
> wrote:
> 
>> This thread has been hijacked and no longer ir relating to the original
>> request about creating a report for Internal Rate of Return (IRR).
>> I would like to see an answer to that question.
>> 
>> On Sat, Apr 8, 2023 at 10:33 AM William Prescott 
>> wrote:
>> 
>>> Or, as another example: sites that require a phone number (maybe for 2FA
>>> [second factor authentification]), but only accept US phone numbers. It
>> is
>>> a major pain for those of us that don't live in the US, but have
>> extensive
>>> dealings with US companies.
>>> 
>>> Will
>>> 
>>> On Apr 8, 2023, at 09:18, Michael or Penny Novack <
>>> stepbystepf...@comcast.net> wrote:
>>> 
>>> PS -- What makes you think commercial software is better in that regard?
>>> It will be designed according to how the designers think the majority of
>>> their customers would want. Choice of behavior MIGHT be provided if they
>>> think the minority also a significant number. But often is not.
>>> 
>>>  For example, I live where there is no cell service. Do you know
>> what
>>> percentage of websites requiring account creation REQUIRE a mobile number
>>> (verification by text) vs how many provide an alternative (email of land
>>> line number sent an automated call). I do. I can even recognize one
>>> situation where I can tell more than one designer involved in the design
>>> (early in the process allows use of the alternative "verify via code sent
>>> by automated voice to a land line or by email" but at the completion of
>> the
>>> process "must enter mobile number for verification sent by text" -
>>> insanely this is a process for setting up "paperless billing" FOR A LAND
>>> LINE). The point is maybe 97% of people here in the US live where can
>> have
>>> a mobile, only 3% live where no service, so forget about them.
>>> 
>>> 
>>> 
>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@gnucash.org
>>> To update your subscription preferences or to unsubscribe:
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>> -
>>> 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
>>> -
>>> Please remember to CC this list on all your replies.
>>> You can do this by using Reply-To-List or Reply-All.
>>> 
>> 
>> 
>> --
>> David Carlson
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>> 
> 
> 
> -- 
> _
> Richard Losey
> rlo...@gmail.com
> Micah 6:8
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> 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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Command line quotes still not fixed

[David G. Pickett via gnucash-user]

I have no currency rate quotes, just US stocks in US dollars.


-Original Message-
From: Murugan Muruganandam 
To: hell...@gmail.com ; David G. Pickett 
Cc: gnucash-user@gnucash.org 
Sent: Thu, Apr 6, 2023 5:08 pm
Subject: Re: [GNC] Command line quotes still not fixed

#yiv0949692185 P {margin-top:0;margin-bottom:0;}Alphavantage is required for 
currency rates


Saludos Cordiales
Murugan
From: gnucash-user 
 on behalf of 
David G. Pickett via gnucash-user 
Sent: Thursday, April 6, 2023 4:41 PM
To: hell...@gmail.com 
Cc: gnucash-user@gnucash.org 
Subject: Re: [GNC] Command line quotes still not fixed As I do not use 
Alphavantage, just 'Yahoo as json', why is it looking for an api key?


-Original Message-
From: David H 
To: David G. Pickett 
Cc: geert.gnuc...@kobaltwit.be ; 
gnucash-user@gnucash.org ; jra...@ceridwen.us 

Sent: Thu, Apr 6, 2023 4:21 pm
Subject: Re: [GNC] Command line quotes still not fixed

I don't think the version difference is a mystery - remember that Flatpak is a 
sandbox so presumably brings along whatever perl version it was built/packaged 
with.  If you set your Alphavantage api key in the Gnucash application itself 
you'll probably also also get rid of the other error message. The following is 
all I get displayed using Geert's command format:
flatpak run --command=gnucash-cli org.gnucash.GnuCash --quotes get -- 
'/home/h/Documents/GnuCash/Data Files/h.gnucash'
Found Finance::Quote version 1.5301.

Cheers David H.

On Fri, 7 Apr 2023 at 05:08, David G. Pickett  wrote:

I don't understand why, but "--" does also work, like "--namespace='.*'".

I still get a lot of errors that do not affect my quote fetch.
It finds 1.5301 even though I installed 1.5401, a different mystery!

dgp@dgp-p6803w:~$ flatpak run --command=gnucash-cli org.gnucash.GnuCash 
--quotes get -- /home/dgp/GnuCash/ubuntu-DGPickett.gnucash* 15:05:17  WARN 
 [GncFQQuoteSource::GncFQQuoteSource()] No Alpha Vantage API 
key set, currency quotes and other AlphaVantage based quotes won't work.Found 
Finance::Quote version 1.5301.dgp@dgp-p6803w:~$ flatpak run 
--command=gnucash-cli org.gnucash.GnuCash --quotes get --namespace='.*' 
/home/dgp/GnuCash/ubuntu-DGPickett.gnucash* 15:05:57  WARN  
[GncFQQuoteSource::GncFQQuoteSource()] No Alpha Vantage API key set, currency 
quotes and other AlphaVantage based quotes won't work.Found Finance::Quote 
version 1.5301.dgp@dgp-p6803w:~$ 
-Original Message-
From: Geert Janssens 
To: David H ; gnucash-user@gnucash.org 

Cc: David G. Pickett ; john 
Sent: Thu, Apr 6, 2023 3:47 am
Subject: Re: [GNC] Command line quotes still not fixed

Actually instead of adding a --namespace parameter, you can just use '--' to 
separate the named parameters from the positional parameters like so:flatpak 
run --command=gnucash-cli org.gnucash.GnuCash --quotes get -- 
/home/dgp/GnuCash/ubuntu-DGPickett.gnucash
That's a common unix way to solve such ambiquities.
Regards,
Geert
Op donderdag 6 april 2023 05:04:02 CEST schreef john:> The namespace parameter 
is a regular expression, so .* will get the quotes> from all of your 
namespaces.> > Regards,> John Ralls> > > On Apr 5, 2023, at 3:46 PM, David H 
 wrote:> > > > What default namespace, look in YOUR security 
editor - as far as> > I know it's whatever you set up.  I have a vague 
recollection that it> > doesn't really care and will be happy with just a 
single character> > i.e. --namespace=x> > but don't quote me on that.> > > > By 
the way your original email could do with some halfway decent> > formatting> > 
- see what the mailing list received at> 
>https://lists.gnucash.org/pipermail/gnucash-user/2023-April/106230.html> > 
you> > might like to tweak that to make it readable in future.> > > > Cheers 
David H.> > > > On Thu, 6 Apr 2023 at 07:46, David G. Pickett 
 wrote:> >> I saw that later.  What's the default 
namespace?> >> > >> > >> -Original Message-> >> From: David H 
> >> To: David G. Pickett > >> Cc: 
gnucash-user@gnucash.org > >> Sent: Wed, Apr 5, 2023 
3:45 pm> >> Subject: Re: [GNC] Command line quotes still not fixed> >> > >> And 
you'll see there's a whole other thread on this -> 
>>https://lists.gnucash.org/pipermail/gnucash-user/2023-April/106181.html.> >> 
Bug report athttps://bugs.gnucash.org/show_bug.cgi?id=798815> >> > >> If you 
include a namespace parameter for now it will work.> >> > >> Cheers David H.> 
>> > >> On Wed, 5 Apr 2023 at 23:00, David G. Pickett via gnucash-user <> >> 
gnucash-user@gnucash.org> wrote:> >> > >> I can still only update quotes with 
the interactive button, the flatpak> >> run gnucash command that ran in 4.* is 
still broken:> >> dgp@dgp-p6803w:~$ flatpak run --command=gnucash-cli 
org.gnucash.GnuCash> >> --quotes get 
/home/dgp/GnuCash/ubuntu-DGPickett.gnucashMissing data file> >> parameter> >> 
gnucash-cli [options] [datafile] - GnuCash, accounting for personal and> >> 
small business finance:> >> Common Options:  -h [ --help ]  Show this 
help message  -v [> >> --

Re: [GNC] Calculating IRR of an investment account

[Vincent Dawans]

As for exporting the correct data for the XIRR function in OpenOffice Calc
or Excel, the trick is to use the account filtering feature of the
transaction report to exclude any internal transactions within the
investment account (such as reinvested dividends, etc); only external
transactions (money in money out) need to be included for the XIRR
calculation, along with (separately) adding the current value of the
account at the bottom. Which accounts need to be included or excluded
depends on your account structure and how investment contributions, income,
expenses and distributions are recorded, so it's not easy to give specific
advice without knowing that. Also worth noting that typically you have to
reverse signs on the numbers because the XIRR function expects negative
numbers for money in but positive for money out. You can just multiply by
-1 in your spreadsheet to easily do that.

Sincerely,

Vincent Dawans

On Sat, Apr 8, 2023 at 4:36 PM John Ralls  wrote:

> GnuCash doesn't even claim to have an IRR calculation, so exporting to a
> spreadsheet is the only option.
>
> The advanced portfolio report does have "rate of gain" and "rate of
> return" columns but they're really just percent return, independent of
> holding period or timing of cash flows.
>
> Regards,
> John Ralls
>
> > On Apr 8, 2023, at 3:03 PM, R Losey  wrote:
> >
> > Personally, I don't necessarily trust what some program may call the
> IRR...
> > if I wanted to calculate it, I would export the necessary data to a
> > spreadsheet and then use the spreadsheet's power to calculate it.
> >
> > On Sat, Apr 8, 2023 at 11:41 AM David Carlson <
> david.carlson@gmail.com>
> > wrote:
> >
> >> This thread has been hijacked and no longer ir relating to the original
> >> request about creating a report for Internal Rate of Return (IRR).
> >> I would like to see an answer to that question.
> >>
> >> On Sat, Apr 8, 2023 at 10:33 AM William Prescott  >
> >> wrote:
> >>
> >>> Or, as another example: sites that require a phone number (maybe for
> 2FA
> >>> [second factor authentification]), but only accept US phone numbers. It
> >> is
> >>> a major pain for those of us that don't live in the US, but have
> >> extensive
> >>> dealings with US companies.
> >>>
> >>> Will
> >>>
> >>> On Apr 8, 2023, at 09:18, Michael or Penny Novack <
> >>> stepbystepf...@comcast.net> wrote:
> >>>
> >>> PS -- What makes you think commercial software is better in that
> regard?
> >>> It will be designed according to how the designers think the majority
> of
> >>> their customers would want. Choice of behavior MIGHT be provided if
> they
> >>> think the minority also a significant number. But often is not.
> >>>
> >>>  For example, I live where there is no cell service. Do you know
> >> what
> >>> percentage of websites requiring account creation REQUIRE a mobile
> number
> >>> (verification by text) vs how many provide an alternative (email of
> land
> >>> line number sent an automated call). I do. I can even recognize one
> >>> situation where I can tell more than one designer involved in the
> design
> >>> (early in the process allows use of the alternative "verify via code
> sent
> >>> by automated voice to a land line or by email" but at the completion of
> >> the
> >>> process "must enter mobile number for verification sent by text" -
> >>> insanely this is a process for setting up "paperless billing" FOR A
> LAND
> >>> LINE). The point is maybe 97% of people here in the US live where can
> >> have
> >>> a mobile, only 3% live where no service, so forget about them.
> >>>
> >>>
> >>>
> >>> ___
> >>> gnucash-user mailing list
> >>> gnucash-user@gnucash.org
> >>> To update your subscription preferences or to unsubscribe:
> >>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >>> -
> >>> 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
> >>> -
> >>> Please remember to CC this list on all your replies.
> >>> You can do this by using Reply-To-List or Reply-All.
> >>>
> >>
> >>
> >> --
> >> David Carlson
> >> ___
> >> gnucash-user mailing list
> >> gnucash-user@gnucash.org
> >> To update your subscription preferences or to unsubscribe:
> >> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >> -
> >> Please remember to CC this list on all your replies.
> >> You can do this by using Reply-To-List or Reply-All.
> >>
> >
> >
> > --
> > _
> > Richard Losey
> > rlo...@gmail.com
> > Micah 6:8
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update yo