[GNC] Report Question

[Matthew Clay]

I have used gnucash for a few years, and have all of my investments sorted
by account. To understand how my investments are distributed, it would be
very convenient for me to have a report that computes the percentage of
certain investments in the whole, e.g., the percent that is bonds. Is it
possible for me to write a report in which I sort my investments and then
compute quantities like percentages, etc.?
___
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] Error in "Close Book" help text

[Stan Brown]

Thanks, Adrien.

I started at  then followed "Q: I
think I found a bug. How do I report it?" to
. From there I searched the bug
database as described under "Triage". Not finding my issue already
reported, I continued to "Commenting on existing bugs or entering new
ones" and to "Open a new GnuCash bug", at
.

I attach a screen shot of what I got. I just proceeded to fill in the
blanks, since the status of NEW (red ellipse) was already filled in. I
didn't try any of the menu selections (green ellipse), since I was
apparently already on the screen I needed. Now, following your email, I
see that I would have got the screen you showed if I had clicked that
apparently-redundant New, but in fairness I don't think there was any
way for me to know that up front.

All of that said, I got a notice that John Ralls had changed the bug
from General to Documentation. And he also emailed me to say that he was
going to fix up the Wiki page to avoid this problem for the future.

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

On 2023-03-24 14:48, Adrien Monteleone wrote:
> When you first click 'New' or 'File a Bug', you get the option to select
> Documentation. (see screenshot) I'm not sure if you can move it after
> filing, but if not, one of the devs can do that for you.
> 
> Regards,
> Adrien
> 
> On 3/24/23 4:05 PM, Stan Brown wrote:
>> "Documentation" doesn't seem to be an option, so I used "General" -- as
>> others have done, apparently.
>>
>> Bug report  now entered.
> 
> ___
> 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] Error in "Close Book" help text

[Michael or Penny Novack]

On 3/24/2023 5:48 PM, Adrien Monteleone wrote:
When you first click 'New' or 'File a Bug', you get the option to 
select Documentation. (see screenshot) I'm not sure if you can move it 
after filing, but if not, one of the devs can do that for you. 


Care should be used in defining this bug. The documentation change 
should make it clear that this refers to closing the books using the 
built in clod=se the books tool.


As opposed to the logical/bookkeeping process "close the books" itself 
(possibly done without the tool, in other words, "manually". THOSE 
transactions would probably not be recognized as special. In which case 
would still need to be careful to run the Income Statement/P&L/Statement 
of Revenues and Expenses (the different names refer to how different 
types of entities know this report) BEFORE closing the books.


If LITERALLY modelling the old way, would have closed to a special 
account with a name like P&L and then THAT closed to equity by the net 
profit of loss that brings it to zero.



Michael D Novack


___
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] GnuCash Bug report 798798

[jralls]

Stan,

Please don't write directly to anyone on the GnuCash team unless expressly 
asked to. Always use the mailing lists or IRC.

You sort of went to the wrong place, but it's not really your fault. The link 
that you followed is to open a new *GnuCash* bug, but you wanted to open a 
*Documentation* bug. The direct link for that is 
https://bugs.gnucash.org/enter_bug.cgi?product=Documentation . It's not on the 
wiki page, but I'll fix that.

Regards,
John Ralls

> On Mar 24, 2023, at 2:43 PM, Stan Brown  wrote:
> 
> Thanks, John.
> 
> I would have used "Documentation" if it had been an option in the bug
> reporter. Did I go to the wrong place?
> 
> I started at  then followed "Q: I
> think I found a bug. How do I report it?" to
> . From there I searched the bug
> database as described under "Triage". Not finding my issue already
> reported, I continued to "Commenting on existing bugs or entering new
> ones" and to "Open a new GnuCash bug", at
> .
> "Documentation" was not listed among the Components, so following the
> instructions at 
> I selected "General".
> 
> -- 
> 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] Error in "Close Book" help text

[Adrien Monteleone]

When you first click 'New' or 'File a Bug', you get the option to select 
Documentation. (see screenshot) I'm not sure if you can move it after 
filing, but if not, one of the devs can do that for you.


Regards,
Adrien

On 3/24/23 4:05 PM, Stan Brown wrote:

"Documentation" doesn't seem to be an option, so I used "General" -- as
others have done, apparently.

Bug report  now entered.___
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] Error in "Close Book" help text

[Stan Brown]

"Documentation" doesn't seem to be an option, so I used "General" -- as
others have done, apparently.

Bug report  now entered.

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


On 2023-03-24 12:46, Adrien Monteleone wrote:
> Maybe file a documentation bug for tracking?
>
> Regards,
> Adrien
>
> On 3/23/23 6:06 PM, Stan Brown wrote:
>> In 4.13, the Close Book help text, which is the Close Book section of
>> the installed manual, includes the following text under "How It Works",
>> as the second paragraph under "Necessity":
>>
(etc.)
___
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] GNC 4.904 Online price source pick list greyed

[Murugan Muruganandam]

thanks Karel

i am seeing the same behavior.  i will request Bruce and John to help


  *   installer is still searching for gnc-fq-check and gnc-fq-helper ,when i 
copied these files into the bin folder, it successfully completed installation 
(this did not alter the issue detailed)
  *   The picklist for the source is greyed out
  *   Currency rates are working as it is going through Alphavantage
  *   Stock prices are not getting updated
  *   In windows when i click get quote, the perl window launches two times in 
quick succession




Saludos Cordiales


Murugan


From: Karel Kadlubiec 
Sent: Friday, March 24, 2023 5:04 PM
To: Murugan Muruganandam 
Cc: gnucash-user@gnucash.org 
Subject: Re: [GNC] GNC 4.904 Online price source pick list greyed

Hi Murugan, I tried to install 4.904 on Windows 11 in VirtualBox.

During installation I was asked twice two following questions:
USE_UNALIGNED not set in env. Use unaligned loads and stores? yes/no [no]
neither NO_ASM nor ZSTD_DISABLE_ASM set in env. Use assembly in ZSTD? yes/no 
[yes]

Because I had no idea what that was I pressed enter. Installation ended with:
* Run gnc-fq-check
Can't open perl script "gnc-fq-check": No such file or directory

There is no gnc-fq-check in C:\Program Files (x86)\gnucash\bin

If I open Gnucash and click Help -> About I see F::Q is installed in version 
1.54
(In version 4.903 installation of F::Q failed completely)

When I run Get quotes I'll get correct FX rates for EUR and USD. I will not get 
prices update for securities (european and american stocks) as I have provider 
Yahoo as JSON and not Alphavantage.
I cannot chose Alphavatage provider because all providers are grey.

Karel



čt 23. 3. 2023 v 20:37 odesílatel Murugan Muruganandam 
mailto:m.muruganan...@hotmail.com>> napsal:
I am testing GNC 4.904 and FC 1.54 on Windows 10.0.19

When i edit and check security editor and check the sources, all of them are 
greyed out. i checked the price install which looks fine and all the folders 
and files are available under C:\Strawberry\perl\site\lib\Finance

not sure it is only for me.




Saludos Cordiales


Murugan
___
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] Error in "Close Book" help text

[Stan Brown]

Sigh. You're right, of course. I've never filed a bug report before, so
I was hoping someone else would do it for me. But I'll figure it out --
it's the least I can do in return for all the benefits I receive from
using GnuCash.

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

On 2023-03-24 12:46, Adrien Monteleone wrote:
> Maybe file a documentation bug for tracking?
> 
> Regards,
> Adrien
> 
> On 3/23/23 6:06 PM, Stan Brown wrote:
>> In 4.13, the Close Book help text, which is the Close Book section of
>> the installed manual, includes the following text under "How It Works",
>> as the second paragraph under "Necessity":
>>
>> "In fact, closing the books reduces the usefulness of the standard
>> reports because the reports don’t currently understand closing
>> transactions. So from their point of view it simply looks like the net
>> income or expense in each account for a given period was simply zero. "
>>
>> That paragraph doesn't seem to be accurate any more. I closed the books
>> in 4.13 and the ran an income statement for the full year. The account
>> totals were given just as they were before I closed the book.
>>
>> Can whoever is maintaining the book look at deleting that paragraph,
>> please? (And please note: This is the installed manual, not the one on
>> the website. I have GnuCash running in a virtual machine with no
>> Internet.)
>>
> 
> ___
> 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] Reporting Woes - Newbie incompetence

[Stan Brown]

On 2023-03-24 12:57, Adrien Monteleone wrote:
> I haven't tested other apps, but both LibreOffice Calc & Apple Numbers
> can either open the exported file directly as it is just an HTML table,
> and both accept copy/pasted reports though either or both methods may
> pop up a dialog for handling column widths, delimiters, special
> characters, etc.
> 
> I'm pretty certain folks have reported that Excel and Google Sheets also
> handle this just fine.

Others reported in this thread that Copy/Paste into Excel works. I
reported that File » Open allows opening the HTML file directly in Excel.

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] Reporting Woes - Newbie incompetence

[p.f.cuthb...@btinternet.com p.f.cuthbert--- via gnucash-user]

Hi Everybody


Thanks Murugan.  Glad to know it works in Excel. For those of us on 
pensions who may be using LibreOffice Calc your exported report will 
work fine with no error messages,  If you save it, you can then have it 
in one of the spreadsheet formats.


Regards

Pete


-- Original Message --
From: "Murugan Muruganandam" 
To: "Brook Milligan" ; "R. Victor Klassen" 


Cc: "gnucash-user@gnucash.org" 
Sent: Friday, 24 Mar, 2023 At 18:25
Subject: Re: [GNC] Reporting Woes - Newbie incompetence
when you export give a .xls
you can then open it in excel, it will give an alert but you can 
override it



Saludos Cordiales

Murugan

From: gnucash-user 
 on behalf 
of Brook Milligan 

Sent: Friday, March 24, 2023 1:41 PM
To: R. Victor Klassen 
Cc: gnucash-user@gnucash.org 
Subject: Re: [GNC] Reporting Woes - Newbie incompetence

On Mar 24, 2023, at 10:35 AM, R. Victor Klassen  
wrote:
I use a transaction report for what you seek.  With the right options I 
get the account, date, description and amount.  Copy paste the result 
into a spreadsheet
Perhaps I am doing something wrong, but how do you copy/paste the result 
into a spreadsheet.
My understanding is that the reports are HTML documents.  Perhaps there 
is some magic I am not aware of?

Cheers,
Brook
___
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.

Dr Peter Cuthbert
Creuddyn
Coedlan Y Plas

Llangawsai
Aberystwyth
Ceredigion
SY23 1HJ
01970 623 447
___
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] Reporting Woes - Newbie incompetence - SOLVED!

[p.f.cuthb...@btinternet.com p.f.cuthbert--- via gnucash-user]

Hi Maf (and everybody who has taken the trouble to respond to this 
query)



Thank you all for your thoughts.  I am amazed to have an inbox full 
already.


I have investigated Maf's suggestion of using the Transaction Report and 
have managed to get out something like what I was seeking.  I was amused 
that my first attempt was all for 2019 transactions despite getting the 
date limits set correctly to 2023.  Attempt two was much closer and 
included 2019 transactions forward to my set closing date.  Clearly this 
is going to work, but only once I find all the correct settings!


Thanks too for colleagues in the US, some of whom have made clear 
instructions for how to use the system for submitting a US Tax return. 
I am sorry that I failed to mention where I was located.  However, there 
may be Newbies in the US who will benefit from your suggestions.  Here 
in the UK the tax authorities have moved to simpler and more simple 
accounts.  I have to certify that my return is based on cash in and cash 
out and contains no accruals or prepayments.


Picking up on Brook's point about getting the data out of the Report and 
into a spreadsheet, that is quite straight forward. Simply place the 
cursor in the top left hand corner then click, hold down the left button 
and drag down to the right hand corner. When you release the mouse 
button the whole page should be high lighted.  Control and C will copy 
that page and then in your spreadsheet you can do a Control V or or use 
Edit Paste Special.  You may be asked about the format of the paste.  It 
is Tab deliminated so if you choose Tab and nothing else (ignore, comma, 
space, etc) your data will layout in the spreadsheet as on screen.


Thank you again.  I will now get down to playing with the parameters 
until it gives what I thought I had asked it to supply.


Best wishes

Pete


-- Original Message --
From: "Maf. King" 
To: gnucash-user@gnucash.org
Sent: Friday, 24 Mar, 2023 At 16:02
Subject: Re: [GNC] Reporting Woes - Newbie incompetence
On Friday, 24 March 2023 12:54:19 GMT p.f.cuthb...@btinternet.com
p.f.cuthbert--- via gnucash-user wrote:
Hi Folks
The end of the UK Tax Year approaches and I am thinking about my tax
return. When I used Quicken there was a report that listed every
transcation in particular accounts which was useful since not all my
accounts are related to the Return.  I had been hoping to do the same in
GNU but I don't seem to be able to find a way to do something so simple.
(Yes I have read all about Reporting but am not a lot the wiser)
Opening a relevant account, choosing Select All, Copy and Paste into a
spreadsheet does not seem to be possible either.
I am sure that somebody has worked out how to do this hence my request.

I think the transaction report will do what you want, with a bit of 
careful

options settings.
I'm in the UK, I run one transaction report for relevant income and one 
for

expenses each year as the basis for my tax return numbers.
HTH,
Maf.


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

Dr Peter Cuthbert
Creuddyn
Coedlan Y Plas

Llangawsai
Aberystwyth
Ceredigion
SY23 1HJ
01970 623 447
___
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] GNC 4.904 Online price source pick list greyed

[Karel Kadlubiec]

Hi Murugan, I tried to install 4.904 on Windows 11 in VirtualBox.

During installation I was asked twice two following questions:
USE_UNALIGNED not set in env. Use unaligned loads and stores? yes/no [no]
neither NO_ASM nor ZSTD_DISABLE_ASM set in env. Use assembly in ZSTD?
yes/no [yes]

Because I had no idea what that was I pressed enter. Installation ended
with:
* Run gnc-fq-check
Can't open perl script "gnc-fq-check": No such file or directory

There is no gnc-fq-check in C:\Program Files (x86)\gnucash\bin

If I open Gnucash and click Help -> About I see F::Q is installed in
version 1.54
(In version 4.903 installation of F::Q failed completely)

When I run Get quotes I'll get correct FX rates for EUR and USD. I will not
get prices update for securities (european and american stocks) as I have
provider Yahoo as JSON and not Alphavantage.
I cannot chose Alphavatage provider because all providers are grey.

Karel



čt 23. 3. 2023 v 20:37 odesílatel Murugan Muruganandam <
m.muruganan...@hotmail.com> napsal:

> I am testing GNC 4.904 and FC 1.54 on Windows 10.0.19
>
> When i edit and check security editor and check the sources, all of them
> are greyed out. i checked the price install which looks fine and all the
> folders and files are available under C:\Strawberry\perl\site\lib\Finance
>
> not sure it is only for me.
>
>
>
>
> Saludos Cordiales
>
>
> Murugan
> ___
> 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] Reporting Woes - Newbie incompetence

[Adrien Monteleone]

If the Transaction Report can't get you what you want, consider an 
Account Report.


You could filter any register to show just the transactions you are 
concerned with.


If the filters are not quite nuanced enough for you, or if you want 
multiple accounts in one report, then craft a Find set of criteria to 
get you exactly the transactions you want which will appear in a single 
search result tab in register form. Then simply run an Account Report 
while viewing those results.


Regards,
Adrien

On 3/24/23 7:54 AM, p.f.cuthb...@btinternet.com p.f.cuthbert--- via 
gnucash-user wrote:


Hi Folks

The end of the UK Tax Year approaches and I am thinking about my tax 
return. When I used Quicken there was a report that listed every 
transcation in particular accounts which was useful since not all my 
accounts are related to the Return.  I had been hoping to do the same in 
GNU but I don't seem to be able to find a way to do something so simple. 
(Yes I have read all about Reporting but am not a lot the wiser)


Opening a relevant account, choosing Select All, Copy and Paste into a 
spreadsheet does not seem to be possible either.


I am sure that somebody has worked out how to do this hence my request.


___
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] Reporting Woes - Newbie incompetence

[Adrien Monteleone]

I haven't tested other apps, but both LibreOffice Calc & Apple Numbers 
can either open the exported file directly as it is just an HTML table, 
and both accept copy/pasted reports though either or both methods may 
pop up a dialog for handling column widths, delimiters, special 
characters, etc.


I'm pretty certain folks have reported that Excel and Google Sheets also 
handle this just fine.


Regards,
Adrien

On 3/24/23 11:41 AM, Brook Milligan wrote:



On Mar 24, 2023, at 10:35 AM, R. Victor Klassen  wrote:

I use a transaction report for what you seek.  With the right options I get the 
account, date, description and amount.  Copy paste the result into a spreadsheet


Perhaps I am doing something wrong, but how do you copy/paste the result into a 
spreadsheet.

My understanding is that the reports are HTML documents.  Perhaps there is some 
magic I am not aware of?


___
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] Modify Balance Sheet report in 4.13?

[Adrien Monteleone]

I don't see that you can as an option, but you can remove the Equity total.

Fortunately those cells have classes, so you can hide them with CSS 
using the CSS stylesheet:


.total-label-cell, .total-number-cell {
display: none;
}



Regards,
Adrien

On 3/23/23 6:01 PM, Stan Brown wrote:

I'm setting up a local nonprofit with GnuCash books. It's a bare-bones
organization, with no liabilities.

When I run a Balance Sheet report in 4.13, there's a final line, "Total
for Liability and Equity". Of course that's appropriate in most cases,
but in this case it's redundant with the "Total for Equity" line.

I've tried the Display options that seem appropriate, but haven't found
any that suppress that line. Is there any way I can modify the report to
suppress the "Total for Liability and Equity" line?



___
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] Error in "Close Book" help text

[Adrien Monteleone]

Maybe file a documentation bug for tracking?

Regards,
Adrien

On 3/23/23 6:06 PM, Stan Brown wrote:

In 4.13, the Close Book help text, which is the Close Book section of
the installed manual, includes the following text under "How It Works",
as the second paragraph under "Necessity":

"In fact, closing the books reduces the usefulness of the standard
reports because the reports don’t currently understand closing
transactions. So from their point of view it simply looks like the net
income or expense in each account for a given period was simply zero. "

That paragraph doesn't seem to be accurate any more. I closed the books
in 4.13 and the ran an income statement for the full year. The account
totals were given just as they were before I closed the book.

Can whoever is maintaining the book look at deleting that paragraph,
please? (And please note: This is the installed manual, not the one on
the website. I have GnuCash running in a virtual machine with no Internet.)



___
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] Site certificate expiry warning

[Simon Roberts]

I agree--the reality of any risk is small enough to normal people to be
irrelevant, but the damage to credibility among those who might want to use
GNC but are not familiar with the significance of public key asymmetric
cryptography, is not at all trivial.

Meanwhile, thank you Dr. Kirbly, your note on letsencrypt was spectacularly
timely, I was literally just in the process of trying to work out how to
get a certificate for a "scratch domain" I'd set up in AWS, and this has
worked a treat :)

Cheers,
Simon


On Fri, Mar 24, 2023 at 11:53 AM Dr. David Kirkby <
drkir...@kirkbymicrowave.co.uk> wrote:

> On Fri, 24 Mar 2023 at 15:22,  wrote:
>
> > On Fri, Mar 24, 2023 at 11:16:09AM +, Michael Hendry wrote:
> > > I’ve been promoting GnuCash to incoming Rotary Club Treasurers, and
> I’ve
> > > just been informed that www.gnucash.org is being flagged up as
> dangerous
> > > because its site certificate expired recently.
> > >
> > How does that make the site 'dangerous'?  All it means is that
> > communication between you (i.e. the user) and the site isn't
> > encrypted. As you don't need to send or receive any confidential
> > information the lack of encryption is wholly irrelevant!
> >
> > --
> > Chris Green
>
>
> Whilst I don’t disagree with you on a technical level, you need to bear in
> mind that browsers are going to warn people, and that will put people off.
>
> There’s a body of opinion that this will impact Google ranking.
>
> I have in the past paid for a fairly expensive EV SSL  certificate, but now
> I use
>
> https://letsencrypt.org/
>
> on Debian Linux. The certificates are valid for 90 days, but renewed after
> 60 days.
>
> 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
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


-- 
Simon Roberts
(303) 249 3613
___
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] Reporting Woes - Newbie incompetence

[Murugan Muruganandam]

when you export give a .xls
you can then open it in excel, it will give an alert but you can override it




Saludos Cordiales


Murugan


From: gnucash-user 
 on behalf of 
Brook Milligan 
Sent: Friday, March 24, 2023 1:41 PM
To: R. Victor Klassen 
Cc: gnucash-user@gnucash.org 
Subject: Re: [GNC] Reporting Woes - Newbie incompetence


> On Mar 24, 2023, at 10:35 AM, R. Victor Klassen  wrote:
>
> I use a transaction report for what you seek.  With the right options I get 
> the account, date, description and amount.  Copy paste the result into a 
> spreadsheet

Perhaps I am doing something wrong, but how do you copy/paste the result into a 
spreadsheet.

My understanding is that the reports are HTML documents.  Perhaps there is some 
magic I am not aware of?

Cheers,
Brook

___
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] Reporting Woes - Newbie incompetence

[Stan Brown]

>>> On Mar 24, 2023, at 10:35 AM, R. Victor Klassen
>>>  wrote:
>>>
>>> I use a transaction report for what you seek.  With the right
>>> options I get the account, date, description and amount.  Copy
>>> paste the result into a spreadsheet

>> On Mar 24, 2023, at 12:41 PM, Brook Milligan  wrote:
>> Perhaps I am doing something wrong, but how do you copy/paste the
>> result into a spreadsheet.
>> 
>> My understanding is that the reports are HTML documents.  Perhaps
>> there is some magic I am not aware of?

On 2023-03-24 09:50, R. Victor Klassen wrote:
> What works for me is just selecting the contents of the report and
> doing copy.  Then opening a spreadsheet and doing paste

Excel will also open an HTML file directly, in the File » Open dialog.
(That's Excel 2010 in Windows 10. I can't imagine later versions would
have lost that capability, but I don't know about Excel in other OSes.)

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] Site certificate expiry warning

[Dr. David Kirkby]

On Fri, 24 Mar 2023 at 15:22,  wrote:

> On Fri, Mar 24, 2023 at 11:16:09AM +, Michael Hendry wrote:
> > I’ve been promoting GnuCash to incoming Rotary Club Treasurers, and I’ve
> > just been informed that www.gnucash.org is being flagged up as dangerous
> > because its site certificate expired recently.
> >
> How does that make the site 'dangerous'?  All it means is that
> communication between you (i.e. the user) and the site isn't
> encrypted. As you don't need to send or receive any confidential
> information the lack of encryption is wholly irrelevant!
>
> --
> Chris Green


Whilst I don’t disagree with you on a technical level, you need to bear in
mind that browsers are going to warn people, and that will put people off.

There’s a body of opinion that this will impact Google ranking.

I have in the past paid for a fairly expensive EV SSL  certificate, but now
I use

https://letsencrypt.org/

on Debian Linux. The certificates are valid for 90 days, but renewed after
60 days.

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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Reporting Woes - Newbie incompetence

[R. Victor Klassen]

What works for me is just selecting the contents of the report and doing copy.  
Then opening a spreadsheet and doing paste 

Sent from my iPhone

> On Mar 24, 2023, at 12:41 PM, Brook Milligan  wrote:
> 
> 
>> On Mar 24, 2023, at 10:35 AM, R. Victor Klassen  wrote:
>> 
>> I use a transaction report for what you seek.  With the right options I get 
>> the account, date, description and amount.  Copy paste the result into a 
>> spreadsheet 
> 
> Perhaps I am doing something wrong, but how do you copy/paste the result into 
> a spreadsheet.  
> 
> My understanding is that the reports are HTML documents.  Perhaps there is 
> some magic I am not aware of?
> 
> Cheers,
> Brook
> 
___
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] Reporting Woes - Newbie incompetence

[Brook Milligan]

> On Mar 24, 2023, at 10:35 AM, R. Victor Klassen  wrote:
> 
> I use a transaction report for what you seek.  With the right options I get 
> the account, date, description and amount.  Copy paste the result into a 
> spreadsheet 

Perhaps I am doing something wrong, but how do you copy/paste the result into a 
spreadsheet.  

My understanding is that the reports are HTML documents.  Perhaps there is some 
magic I am not aware of?

Cheers,
Brook

___
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] Reporting Woes - Newbie incompetence

[R. Victor Klassen]

I use a transaction report for what you seek.  With the right options I get the 
account, date, description and amount.  Copy paste the result into a 
spreadsheet 

Sent from my iPhone

> On Mar 24, 2023, at 12:30 PM, Michael or Penny Novack 
>  wrote:
> 
> 
>>> The end of the UK Tax Year approaches and I am thinking about my tax
>>> return. When I used Quicken there was a report that listed every
>>> transcation in particular accounts which was useful since not all my
>>> accounts are related to the Return.  I had been hoping to do the same in
>>> GNU but I don't seem to be able to find a way to do something so simple.
>>> (Yes I have read all about Reporting but am not a lot the wiser)
>>> 
>>> Opening a relevant account, choosing Select All, Copy and Paste into a
>>> spreadsheet does not seem to be possible either.
>>> 
>>> I am sure that somebody has worked out how to do this hence my request.
> 
> Keep in mind jurisdictions differ, so what I am about to describe would be US 
> (and 501(c)3 non-profits)
> 
> Gnucash is a basic accounting system, keeps standard double entry books. You 
> need to set up your CaO so that the data will be usefully grouped for tax and 
> other reporting purposes. BUT  also keep in mind that you might have to 
> do some work outside of gnucash because you might need to be reporting to 
> different entities (the state might require different from the feds) and you 
> can have only one hierarchy of accounts.
> 
> For example, "printing and postage" is a line item on the 990/990-EZ 
> *Federal" so each expense parent that has those as a component of that 
> parent's total* should have a separate "printing and postage" child. If what 
> you "pay" and intern is partly PAY and partly Mileage Reimbursement you'd 
> want those as separate children under that intern (because the pay part might 
> mean a 1099-MISC)
> 
> In other words, it is going to be up to YOU to create a suitable CoA so it 
> will make it easy to get the data you need for the reports you must fill out.
> 
> Michael D Novack
> 
> 
> ___
> 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] Reporting Woes - Newbie incompetence

[Michael or Penny Novack]

The end of the UK Tax Year approaches and I am thinking about my tax
return. When I used Quicken there was a report that listed every
transcation in particular accounts which was useful since not all my
accounts are related to the Return.  I had been hoping to do the same in
GNU but I don't seem to be able to find a way to do something so simple.
(Yes I have read all about Reporting but am not a lot the wiser)

Opening a relevant account, choosing Select All, Copy and Paste into a
spreadsheet does not seem to be possible either.

I am sure that somebody has worked out how to do this hence my request.


Keep in mind jurisdictions differ, so what I am about to describe would 
be US (and 501(c)3 non-profits)


Gnucash is a basic accounting system, keeps standard double entry books. 
You need to set up your CaO so that the data will be usefully grouped 
for tax and other reporting purposes. BUT  also keep in mind that 
you might have to do some work outside of gnucash because you might need 
to be reporting to different entities (the state might require different 
from the feds) and you can have only one hierarchy of accounts.


For example, "printing and postage" is a line item on the 990/990-EZ 
*Federal" so each expense parent that has those as a component of that 
parent's total* should have a separate "printing and postage" child. If 
what you "pay" and intern is partly PAY and partly Mileage Reimbursement 
you'd want those as separate children under that intern (because the pay 
part might mean a 1099-MISC)


In other words, it is going to be up to YOU to create a suitable CoA so 
it will make it easy to get the data you need for the reports you must 
fill out.


Michael D Novack


___
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] Reporting Woes - Newbie incompetence

[Maf. King]

On Friday, 24 March 2023 12:54:19 GMT p.f.cuthb...@btinternet.com 
p.f.cuthbert--- via gnucash-user wrote:
> Hi Folks
> 
> The end of the UK Tax Year approaches and I am thinking about my tax
> return. When I used Quicken there was a report that listed every
> transcation in particular accounts which was useful since not all my
> accounts are related to the Return.  I had been hoping to do the same in
> GNU but I don't seem to be able to find a way to do something so simple.
> (Yes I have read all about Reporting but am not a lot the wiser)
> 
> Opening a relevant account, choosing Select All, Copy and Paste into a
> spreadsheet does not seem to be possible either.
> 
> I am sure that somebody has worked out how to do this hence my request.
> 

I think the transaction report will do what you want, with a bit of careful 
options settings.

I'm in the UK, I run one transaction report for relevant income and one for 
expenses each year as the basis for my tax return numbers.  

HTH,
Maf.




___
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] Reporting Woes - Newbie incompetence

[David Carlson]

I live in the U. S., and here the tax report is tied to the IRS form 1040.
That would be worse than useless in the U. K.  I am not sure what might be
available there.

On Fri, Mar 24, 2023, 8:11 AM Fred Tydeman  wrote:

> Try:
>   Edit:
> Tax Report Options
> to set up which (Income & Expense) accounts matter.
>
> Then, run:
>   Reports:
> Tax Schedule Report & TFX Export
>
> This is mentioned in the Tutorial and Concepts Guide (search for Tax
> Report)
>
>
> On Fri, Mar 24, 2023 at 2:54 PM p.f.cuthb...@btinternet.com
> p.f.cuthbert---
> via gnucash-user  wrote:
>
> >
> > Hi Folks
> >
> > The end of the UK Tax Year approaches and I am thinking about my tax
> > return. When I used Quicken there was a report that listed every
> > transcation in particular accounts which was useful since not all my
> > accounts are related to the Return.  I had been hoping to do the same in
> > GNU but I don't seem to be able to find a way to do something so simple.
> > (Yes I have read all about Reporting but am not a lot the wiser)
> >
> > Opening a relevant account, choosing Select All, Copy and Paste into a
> > spreadsheet does not seem to be possible either.
> >
> > I am sure that somebody has worked out how to do this hence my request.
> >
> > Many thanks
> >
> > Pete
> >
> > Dr Peter Cuthbert
> > Creuddyn
> > Coedlan Y Plas
> >
> > Llangawsai
> > Aberystwyth
> > Ceredigion
> > SY23 1HJ
> > 01970 623 447
> > ___
> > 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.
>
___
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] Site certificate expiry warning

[cl]

On Fri, Mar 24, 2023 at 11:16:09AM +, Michael Hendry wrote:
> I’ve been promoting GnuCash to incoming Rotary Club Treasurers, and I’ve
> just been informed that www.gnucash.org is being flagged up as dangerous
> because its site certificate expired recently.
>
How does that make the site 'dangerous'?  All it means is that
communication between you (i.e. the user) and the site isn't
encrypted. As you don't need to send or receive any confidential
information the lack of encryption is wholly irrelevant!


-- 
Chris Green
___
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] Site certificate expiry warning

[Michael or Penny Novack]

On 3/24/2023 9:30 AM, Simon Roberts wrote:
On this, I would disagree. The certificate verifies that the 
*connection* has not been usurped by a "man in the middle" attack, and 
thereby that the target site is the one you believe it to be. The 
certificate says absolutely nothing about the quality or reliab\ility 
of the content of the site. So, if you are concerned about the 
(extremely small, to be fair) risk that there's a pirate version of a 
site being fed to you, you need to ensure the certificate is validated.


Sorry, I was really being unclear.

I did NOT mean "without first checking with the site owners" and that 
using an address from them from before (in other words, I would not 
trust a "contact address" not obtained until the site had an expired 
warning.


I did NOT mean for any and all purposes. It would depend very much on 
what I was doing at the site, how I was going to be interacting with it. 
Until the problem fixed, would not download software, would not log in 
for any financial activities, etc. LOOK at the site, yes. Thus I might 
look at a vendor site while doing comparison shopping, checking for 
product availability, etc.  but not place an order.



Michael D Novack


___
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] Reporting Woes - Newbie incompetence

[Alex Aycinena]

Bear in mind that that option is designed for US Income Taxes only. I
believe someone did a version for Germany but am not sure if it is
up-to-date.

You can, of course, try to use it anyway.

Perhaps a response from a gnucash user in the UK might be helpful?

Alex



> -- Forwarded message --
> From: Fred Tydeman 
> To: "p.f.cuthb...@btinternet.com p.f.cuthb...@btinternet.com" <
> p.f.cuthb...@btinternet.com>
> Cc: gnucash-user@gnucash.org
> Bcc:
> Date: Fri, 24 Mar 2023 15:10:37 +0200
> Subject: Re: [GNC] Reporting Woes - Newbie incompetence
> Try:
>   Edit:
> Tax Report Options
> to set up which (Income & Expense) accounts matter.
>
> Then, run:
>   Reports:
> Tax Schedule Report & TFX Export
>
> This is mentioned in the Tutorial and Concepts Guide (search for Tax
> Report)
>
>
> On Fri, Mar 24, 2023 at 2:54 PM p.f.cuthb...@btinternet.com
> p.f.cuthbert---
> via gnucash-user  wrote:
>
> >
> > Hi Folks
> >
> > The end of the UK Tax Year approaches and I am thinking about my tax
> > return. When I used Quicken there was a report that listed every
> > transcation in particular accounts which was useful since not all my
> > accounts are related to the Return.  I had been hoping to do the same in
> > GNU but I don't seem to be able to find a way to do something so simple.
> > (Yes I have read all about Reporting but am not a lot the wiser)
> >
> > Opening a relevant account, choosing Select All, Copy and Paste into a
> > spreadsheet does not seem to be possible either.
> >
> > I am sure that somebody has worked out how to do this hence my request.
> >
> > Many thanks
> >
> > Pete
> >
> > Dr Peter Cuthbert
> > Creuddyn
> > Coedlan Y Plas
> >
> > Llangawsai
> > Aberystwyth
> > Ceredigion
> > SY23 1HJ
> > 01970 623 447
> > ___
> > 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] Site certificate expiry warning

[Dr. David Kirkby]

On Fri, 24 Mar 2023 at 11:16, Michael Hendry 
wrote:

> I’ve been promoting GnuCash to incoming Rotary Club Treasurers, and I’ve
> just been informed that www.gnucash.org is being flagged up as dangerous
> because its site certificate expired recently.
>
> I can get through by overriding the warnings, but I don’t think I should
> be advising others to do so.
>
> Regards,
>
> Michael
>

I find

https://www.downnotifier.com/?ref=700351

really good for monitoring a website. The basic service is free, and it
will send an email if a certificate is soon to expire. It also gives you
the uptime percentage over various periods of time. I pay about $15/year
for the premium monitoring, which sends me text alerts if the website goes
down. The nice thing about that site is it looks for specific text on a
webpage (in my case I set it to be "attenuator"). That means it reports an
error, even if the server responded with a missing page, internal error or
similar

Dave
___
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] Modify Balance Sheet report in 4.13?

[Michael or Penny Novack]

On 3/23/2023 7:01 PM, Stan Brown wrote:

I'm setting up a local nonprofit with GnuCash books. It's a bare-bones
organization, with no liabilities.

When I run a Balance Sheet report in 4.13, there's a final line, "Total
for Liability and Equity". Of course that's appropriate in most cases,
but in this case it's redundant with the "Total for Equity" line.

I've tried the Display options that seem appropriate, but haven't found
any that suppress that line. Is there any way I can modify the report to
suppress the "Total for Liability and Equity" line?

Stan, let me ask you a question. How do you know you will never be 
needing to enter one side of a transactions as a liability?


When you say "no liabilities" I imagine that is because there is no 
intention of this organization taking out loans, having organizational 
credit cards, etc. (even ones NOT used for credit but as "30 day net" 
accounts). But obvious things like those cases are not the only things 
that result in transactions affecting an account under liabilities. I 
will give you a couple examples to think about:


1) The organization is having an "event" for which various supplies will 
be needed. As a resident of the town, Tom can rent the town hall at a 
lower rate than somebody outside the town can. So he is detailed to do 
that. Dick and Harry will be purchasing various supplies needed for the 
event, At the event, Tom, Dick, and Harry turn the receipts over to the 
Treasurer who writes then checks to pay them back. How would you be 
entering all the transactions?


2) The organization is planning a trip and will be collecting from each 
person going for their share of the bus/driver rental. The amount needed 
for the bus rental deposit is far more than in the organizational 
treasury. Mary says, I'll got to the transit company and pay them the 
deposit. How did you handle that transaction?


a) Mary says "I will donate the money needed for the bus deposit, but 
just fir that purpose, and does that" leaving to you as treasurer to go 
to the transit company. How did you handle those transactions?


b) Begins as "a", but the trip ends up being called off and the deposit 
is returned. How did you handle that?



Michael D Novack


___
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] Reporting Woes - Newbie incompetence

[Fred Tydeman]

Try:
  Edit:
Tax Report Options
to set up which (Income & Expense) accounts matter.

Then, run:
  Reports:
Tax Schedule Report & TFX Export

This is mentioned in the Tutorial and Concepts Guide (search for Tax Report)


On Fri, Mar 24, 2023 at 2:54 PM p.f.cuthb...@btinternet.com p.f.cuthbert---
via gnucash-user  wrote:

>
> Hi Folks
>
> The end of the UK Tax Year approaches and I am thinking about my tax
> return. When I used Quicken there was a report that listed every
> transcation in particular accounts which was useful since not all my
> accounts are related to the Return.  I had been hoping to do the same in
> GNU but I don't seem to be able to find a way to do something so simple.
> (Yes I have read all about Reporting but am not a lot the wiser)
>
> Opening a relevant account, choosing Select All, Copy and Paste into a
> spreadsheet does not seem to be possible either.
>
> I am sure that somebody has worked out how to do this hence my request.
>
> Many thanks
>
> Pete
>
> Dr Peter Cuthbert
> Creuddyn
> Coedlan Y Plas
>
> Llangawsai
> Aberystwyth
> Ceredigion
> SY23 1HJ
> 01970 623 447
> ___
> 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] Site certificate expiry warning

[Michael or Penny Novack]

On 3/24/2023 7:16 AM, Michael Hendry wrote:

I’ve been promoting GnuCash to incoming Rotary Club Treasurers, and I’ve just 
been informed that www.gnucash.org is being flagged up as dangerous because its 
site certificate expired recently.

I can get through by overriding the warnings, but I don’t think I should be 
advising others to do so.

Regards,


Site certificate warnings are most important when it is a site unknown 
to you.


When it is trusted site, one that you have been visiting for years, the 
more usual assumption should be that there has been some delay in 
arranging for certificate renewal. Especially make this assumption for 
"small" sites. The IT department of a major corporation would have a 
tech team to make sure things like that don't happen. That is not true 
when would be just one person.


Michael D Novack


___
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] Reporting Woes - Newbie incompetence

[p.f.cuthb...@btinternet.com p.f.cuthbert--- via gnucash-user]

Hi Folks

The end of the UK Tax Year approaches and I am thinking about my tax 
return. When I used Quicken there was a report that listed every 
transcation in particular accounts which was useful since not all my 
accounts are related to the Return.  I had been hoping to do the same in 
GNU but I don't seem to be able to find a way to do something so simple. 
(Yes I have read all about Reporting but am not a lot the wiser)


Opening a relevant account, choosing Select All, Copy and Paste into a 
spreadsheet does not seem to be possible either.


I am sure that somebody has worked out how to do this hence my request.

Many thanks

Pete

Dr Peter Cuthbert
Creuddyn
Coedlan Y Plas

Llangawsai
Aberystwyth
Ceredigion
SY23 1HJ
01970 623 447
___
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] Site certificate expiry warning

[Derek Atkins]

Point them to https://code.gnucash.org/website/

The maintainer of www.gnucash.org has been having issues since a major
power outage in February and has been fighting with his system ever since.

-derek

On Fri, March 24, 2023 7:16 am, Michael Hendry wrote:
> I’ve been promoting GnuCash to incoming Rotary Club Treasurers, and I’ve
> just been informed that www.gnucash.org is being flagged up as dangerous
> because its site certificate expired recently.
>
> I can get through by overriding the warnings, but I don’t think I should
> be advising others to do so.
>
> Regards,
>
> Michael
> ___
> 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.
>


-- 
   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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Site certificate expiry warning

[Michael Hendry]

I’ve been promoting GnuCash to incoming Rotary Club Treasurers, and I’ve just 
been informed that www.gnucash.org is being flagged up as dangerous because its 
site certificate expired recently.

I can get through by overriding the warnings, but I don’t think I should be 
advising others to do so.

Regards,

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