[GNC] Report Question

[Jack Frillman via gnucash-user]

Using GNUC 4.4

I setup a Income Statement report from the Reports-->Experimental report 
options.
I have the Start Date set to "Start of this Year" and the End Date to 
"End of this Year".


Will the date range of the report automatically switch to Jan 1 2022 to 
Dec 31 2022 when the new year actually arrives?



Are these Experimental reports stable?

--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Report question

[Paul Kinzelman]

If I do a Search for the transactions I want, and then Export
Active Register, I can look at the CSV in a spreadsheet, but
both accounts of the transaction appear in the same column
so the sum of the amount column is always zero.

How do I export just one account's amount of each transaction
without the other side of the transaction being there so that
the sum of the column actually represents the sum of the
expenses of that Search?

TIA!




___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Report question

[Eric Coates via gnucash-user]

Good afternoon

I've decided to do some exploration of the Reports option in GnuCash, 
specifically the Reports/Income & Expense/Profit & loss.


The default settings give me much of what I want but ...

I have two classes of Expenses, "Ordinary" and "Exceptional"; I want the 
full breakdown of the Exceptional expenses (which is provided) but I 
only need the total for the Ordinary expenses. After a few hours of 
clicking check boxes I've not been able to get what I want - is it possible?


I'm old enough it's not always possible to have what I want (and frankly 
I can live with what is provided) but it would be nice!


Thanks for any guidance

Eric

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

[GNC] Report Question

[Joseph Hesse]

I want to generate a report of:

All the expenses for 2 subaccounts and their subaccounts of Expenses.  I 
want the report for all of 2019 and I don't want the matching transfer 
accounts.


What Report type do you suggest I use?  There are too many to try them all.

Thank you,

Joe

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Report Question

[Christopher Lam]

Yes it will use 2022 year if the report is launched in 2022.

This report is stable and will not be removed from gnucash. The only known
blocker against it moving out of experimental is that the valuation into
target currency is known to be slightly* flawed when multiple columns are
involved. To fix it would cause the report to be much slower. If the book
is single currency only then there are no known bugs on this report.

* Consider a book with multiple foreign or stock transactions at various
dates; the weighted average / average cost pricing will attempt to value
the conversion at a "reasonable" average price into the report currency.
The mechanism to obtain price at multiple dates in this report will
slightly differ from the single-date balance sheet or income statement
report.

On Thu, 23 Sep 2021, 5:25 am Jack Frillman via gnucash-user, <
gnucash-user@gnucash.org> wrote:

>
> Using GNUC 4.4
>
> I setup a Income Statement report from the Reports-->Experimental report
> options.
> I have the Start Date set to "Start of this Year" and the End Date to
> "End of this Year".
>
> Will the date range of the report automatically switch to Jan 1 2022 to
> Dec 31 2022 when the new year actually arrives?
>
>
> Are these Experimental reports stable?
>
> --
> Old Unix programmers never die, they just mv to /dev/null
> - Anonymous
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Report Question

[Jack Frillman via gnucash-user]

Understand.
I only use a single currency so I should be fine then

Thanks.

On 9/22/21 8:31 PM, Christopher Lam wrote:

Yes it will use 2022 year if the report is launched in 2022.

This report is stable and will not be removed from gnucash. The only 
known blocker against it moving out of experimental is that the 
valuation into target currency is known to be slightly* flawed when 
multiple columns are involved. To fix it would cause the report to be 
much slower. If the book is single currency only then there are no 
known bugs on this report.


* Consider a book with multiple foreign or stock transactions at 
various dates; the weighted average / average cost pricing will 
attempt to value the conversion at a "reasonable" average price into 
the report currency. The mechanism to obtain price at multiple dates 
in this report will slightly differ from the single-date balance sheet 
or income statement report.


On Thu, 23 Sep 2021, 5:25 am Jack Frillman via gnucash-user, 
mailto:gnucash-user@gnucash.org>> wrote:



Using GNUC 4.4

I setup a Income Statement report from the Reports-->Experimental
report
options.
I have the Start Date set to "Start of this Year" and the End Date to
"End of this Year".

Will the date range of the report automatically switch to Jan 1
2022 to
Dec 31 2022 when the new year actually arrives?


Are these Experimental reports stable?

-- 
Old Unix programmers never die, they just mv to /dev/null

- Anonymous

___
gnucash-user mailing list
gnucash-user@gnucash.org 
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user

If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists
 for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.



--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Report question

[David Carlson]

That procedure generates a mess, in my opinion.  Wouldn't it be simpler to
just run a register report?

On Thu, Feb 24, 2022 at 12:57 PM Paul Kinzelman  wrote:

> If I do a Search for the transactions I want, and then Export
> Active Register, I can look at the CSV in a spreadsheet, but
> both accounts of the transaction appear in the same column
> so the sum of the amount column is always zero.
>
> How do I export just one account's amount of each transaction
> without the other side of the transaction being there so that
> the sum of the column actually represents the sum of the
> expenses of that Search?
>
> TIA!
>
>
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


-- 
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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Report question

[William Prescott]

In the csv file created by exporting transactions, sort on the date field 
before doing anything. That will bring together all of the transactions on one 
line each without the other side of them.

Will

On 2022 Feb 24, at 02-24 12:56:15, Paul Kinzelman  wrote:

If I do a Search for the transactions I want, and then Export
Active Register, I can look at the CSV in a spreadsheet, but
both accounts of the transaction appear in the same column
so the sum of the amount column is always zero.

How do I export just one account's amount of each transaction
without the other side of the transaction being there so that
the sum of the column actually represents the sum of the
expenses of that Search?

TIA!




___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Report question

[Paul Kinzelman]

Do you mean Account Report? But when I go to File | Export, it asks
me which accounts again, it doesn't export the actual report.

When I export the transactions I want, it exports both sides of the
transaction, so the column sum is always zero whereas I want the
sum of the transactions.

In other words, each transaction takes two lines, the line I want
(the expense of what I bought), and the next line which is the
account that paid it (like a charge card).

How do I get rid of the double-lines on the export?

Here's one line example:
02/23/2022  ff8275d221f24ecfa82aaf8f6e4c9852
Home Depot  weed block  CURRENCY::USD   


Expenses:House:Garden   Garden  $102.11 102.11  n   
1









Liabilities:Credit Card:DCUvisa
DCUvisa joint
$(102.11)   (102.11)n   
1



On 2/24/2022 1:09 PM, David Carlson wrote:
That procedure generates a mess, in my opinion. Wouldn't it be simpler 
to just run a register report?


On Thu, Feb 24, 2022 at 12:57 PM Paul Kinzelman  
wrote:


If I do a Search for the transactions I want, and then Export
Active Register, I can look at the CSV in a spreadsheet, but
both accounts of the transaction appear in the same column
so the sum of the amount column is always zero.

How do I export just one account's amount of each transaction
without the other side of the transaction being there so that
the sum of the column actually represents the sum of the
expenses of that Search?

TIA!




___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.



--
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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Report question

[Tommy Trussell]

On Fri, Feb 25, 2022 at 9:27 AM Paul Kinzelman  wrote:

> Do you mean Account Report? But when I go to File | Export, it asks
> me which accounts again, it doesn't export the actual report.
>
> When I export the transactions I want, it exports both sides of the
> transaction, so the column sum is always zero whereas I want the
> sum of the transactions.
>
> In other words, each transaction takes two lines, the line I want
> (the expense of what I bought), and the next line which is the
> account that paid it (like a charge card).
>
> How do I get rid of the double-lines on the export?
>

We're apparently not seeing the same thing you are.

Here's a way to get an Account Report for your credit card transactions.
(This is using GnuCash 4.9.)

1) Open the account
   Accounts tab --> open Liabilities : Credit Cards : BigBankTwo VISA
(yours will differ)

2) Use Filter By to select the transactions you want [while the register is
active]
   View --> Filter By (choose parameters such as date, number of days,
reconciled, etc.)

3) Open Account Report [while the filtered register is active]
Reports --> Account Report

4) Adjust the options on the report
   Edit --> Report Options
   (here you can adjust specific columns, single or double amount columns,
totals or running total, style, report name, etc.)

5) Export the report
You can copy what's on your screen and paste it into a word processor
or spreadsheet
OR
File --> Export --> Export Report  (give it a name -- it will save an
.html file you can open with a web browser or a spreadsheet program)



> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Report question

[Paul Kinzelman]

Thank you for the detailed instructions.
I found that 'Transaction Report' will do what I want, but then
I can't export to CSV.

I can export to HTML by Export Report
I can 'Export as PDF' but not CSV. That's what I'm missing.
This would be really nice to add.

I can Export Transactions, but that does not export the transactions
of the transaction report which is what I wanted to do.

On 2/25/2022 6:08 PM, Tommy Trussell wrote:

On Fri, Feb 25, 2022 at 9:27 AM Paul Kinzelman  wrote:

Do you mean Account Report? But when I go to File | Export, it asks
me which accounts again, it doesn't export the actual report.

When I export the transactions I want, it exports both sides of the
transaction, so the column sum is always zero whereas I want the
sum of the transactions.

In other words, each transaction takes two lines, the line I want
(the expense of what I bought), and the next line which is the
account that paid it (like a charge card).

How do I get rid of the double-lines on the export?


We're apparently not seeing the same thing you are.

Here's a way to get an Account Report for your credit card 
transactions. (This is using GnuCash 4.9.)


1) Open the account
   Accounts tab --> open Liabilities : Credit Cards : BigBankTwo VISA  
(yours will differ)


2) Use Filter By to select the transactions you want [while the 
register is active]
   View --> Filter By (choose parameters such as date, number of days, 
reconciled, etc.)


3) Open Account Report [while the filtered register is active]
    Reports --> Account Report

4) Adjust the options on the report
   Edit --> Report Options
   (here you can adjust specific columns, single or double amount 
columns, totals or running total, style, report name, etc.)


5) Export the report
    You can copy what's on your screen and paste it into a word 
processor or spreadsheet

    OR
    File --> Export --> Export Report  (give it a name -- it will save 
an .html file you can open with a web browser or a spreadsheet program)


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


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Report question

[William Prescott]

I found the same thing recently. I also would find it helpful to be able to 
export a transaction report as csv. If I had some free time, I would consider 
looking into adding that, but right now, I don't have the time.

Will

On 2022 Feb 26, at 02-26 10:56:27, Paul Kinzelman  wrote:

Thank you for the detailed instructions.
I found that 'Transaction Report' will do what I want, but then
I can't export to CSV.

I can export to HTML by Export Report
I can 'Export as PDF' but not CSV. That's what I'm missing.
This would be really nice to add.

I can Export Transactions, but that does not export the transactions
of the transaction report which is what I wanted to do.

On 2/25/2022 6:08 PM, Tommy Trussell wrote:
> On Fri, Feb 25, 2022 at 9:27 AM Paul Kinzelman  wrote:
> 
>Do you mean Account Report? But when I go to File | Export, it asks
>me which accounts again, it doesn't export the actual report.
> 
>When I export the transactions I want, it exports both sides of the
>transaction, so the column sum is always zero whereas I want the
>sum of the transactions.
> 
>In other words, each transaction takes two lines, the line I want
>(the expense of what I bought), and the next line which is the
>account that paid it (like a charge card).
> 
>How do I get rid of the double-lines on the export?
> 
> 
> We're apparently not seeing the same thing you are.
> 
> Here's a way to get an Account Report for your credit card transactions. 
> (This is using GnuCash 4.9.)
> 
> 1) Open the account
>Accounts tab --> open Liabilities : Credit Cards : BigBankTwo VISA  (yours 
> will differ)
> 
> 2) Use Filter By to select the transactions you want [while the register is 
> active]
>View --> Filter By (choose parameters such as date, number of days, 
> reconciled, etc.)
> 
> 3) Open Account Report [while the filtered register is active]
> Reports --> Account Report
> 
> 4) Adjust the options on the report
>Edit --> Report Options
>(here you can adjust specific columns, single or double amount columns, 
> totals or running total, style, report name, etc.)
> 
> 5) Export the report
> You can copy what's on your screen and paste it into a word processor or 
> spreadsheet
> OR
> File --> Export --> Export Report  (give it a name -- it will save an 
> .html file you can open with a web browser or a spreadsheet program)
> 
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
> 
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Report question

[William Prescott]

I just looked at the html code for the transaction reports exported in html 
format. It would be trivial to write a converter to convert them to csv. And 
they are simple enough that probably all the existing html-to-csv converters 
would do a good job on them.

Will


On 2022 Feb 26, at 02-26 11:00:54, William Prescott  
wrote:

I found the same thing recently. I also would find it helpful to be able to 
export a transaction report as csv. If I had some free time, I would consider 
looking into adding that, but right now, I don't have the time.

Will

On 2022 Feb 26, at 02-26 10:56:27, Paul Kinzelman  wrote:

Thank you for the detailed instructions.
I found that 'Transaction Report' will do what I want, but then
I can't export to CSV.

I can export to HTML by Export Report
I can 'Export as PDF' but not CSV. That's what I'm missing.
This would be really nice to add.

I can Export Transactions, but that does not export the transactions
of the transaction report which is what I wanted to do.

On 2/25/2022 6:08 PM, Tommy Trussell wrote:
> On Fri, Feb 25, 2022 at 9:27 AM Paul Kinzelman  wrote:
> 
>   Do you mean Account Report? But when I go to File | Export, it asks
>   me which accounts again, it doesn't export the actual report.
> 
>   When I export the transactions I want, it exports both sides of the
>   transaction, so the column sum is always zero whereas I want the
>   sum of the transactions.
> 
>   In other words, each transaction takes two lines, the line I want
>   (the expense of what I bought), and the next line which is the
>   account that paid it (like a charge card).
> 
>   How do I get rid of the double-lines on the export?
> 
> 
> We're apparently not seeing the same thing you are.
> 
> Here's a way to get an Account Report for your credit card transactions. 
> (This is using GnuCash 4.9.)
> 
> 1) Open the account
>   Accounts tab --> open Liabilities : Credit Cards : BigBankTwo VISA  (yours 
> will differ)
> 
> 2) Use Filter By to select the transactions you want [while the register is 
> active]
>   View --> Filter By (choose parameters such as date, number of days, 
> reconciled, etc.)
> 
> 3) Open Account Report [while the filtered register is active]
>Reports --> Account Report
> 
> 4) Adjust the options on the report
>   Edit --> Report Options
>   (here you can adjust specific columns, single or double amount columns, 
> totals or running total, style, report name, etc.)
> 
> 5) Export the report
>You can copy what's on your screen and paste it into a word processor or 
> spreadsheet
>OR
>File --> Export --> Export Report  (give it a name -- it will save an 
> .html file you can open with a web browser or a spreadsheet program)
> 
>   -
>   Please remember to CC this list on all your replies.
>   You can do this by using Reply-To-List or Reply-All.
> 
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Report question

[D. via gnucash-user]

If you took the report data and pasted it directly into your favorite 
spreadsheet, you could save the result as CSV, no problem. 

At this point, it might be more useful if you explained more completely what it 
is you're trying to accomplish. Then people on the list could help you solve 
the problem, rather than half answer your half-stated question. 

David


 Original Message 
From: Paul Kinzelman 
Sent: Sat Feb 26 11:56:27 EST 2022
To: Tommy Trussell 
Cc: Gnucash Elist 
Subject: Re: [GNC] Report question

Thank you for the detailed instructions.
I found that 'Transaction Report' will do what I want, but then
I can't export to CSV.

I can export to HTML by Export Report
I can 'Export as PDF' but not CSV. That's what I'm missing.
This would be really nice to add.

I can Export Transactions, but that does not export the transactions
of the transaction report which is what I wanted to do.

On 2/25/2022 6:08 PM, Tommy Trussell wrote:
> On Fri, Feb 25, 2022 at 9:27 AM Paul Kinzelman  wrote:
>
> Do you mean Account Report? But when I go to File | Export, it asks
> me which accounts again, it doesn't export the actual report.
>
> When I export the transactions I want, it exports both sides of the
> transaction, so the column sum is always zero whereas I want the
> sum of the transactions.
>
> In other words, each transaction takes two lines, the line I want
> (the expense of what I bought), and the next line which is the
> account that paid it (like a charge card).
>
> How do I get rid of the double-lines on the export?
>
>
> We're apparently not seeing the same thing you are.
>
> Here's a way to get an Account Report for your credit card 
> transactions. (This is using GnuCash 4.9.)
>
> 1) Open the account
>    Accounts tab --> open Liabilities : Credit Cards : BigBankTwo VISA  
> (yours will differ)
>
> 2) Use Filter By to select the transactions you want [while the 
> register is active]
>    View --> Filter By (choose parameters such as date, number of days, 
> reconciled, etc.)
>
> 3) Open Account Report [while the filtered register is active]
>     Reports --> Account Report
>
> 4) Adjust the options on the report
>    Edit --> Report Options
>    (here you can adjust specific columns, single or double amount 
> columns, totals or running total, style, report name, etc.)
>
> 5) Export the report
>     You can copy what's on your screen and paste it into a word 
> processor or spreadsheet
>     OR
>     File --> Export --> Export Report  (give it a name -- it will save 
> an .html file you can open with a web browser or a spreadsheet program)
>
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Report question

[Paul Kinzelman]

Thanks for the suggestion, but I'm not trying anything huge.
I just tried to get a quick spreadsheet out of it and stumbled.
I thought there would be some easy way to get quick reports
like there was in Quicken, but GC requires more user assembly.
It's the Ikea of financial software. :-)

The suggestions you made helped.
Thanks very much!

On 2/26/2022 1:30 PM, D. wrote:
If you took the report data and pasted it directly into your favorite 
spreadsheet, you could save the result as CSV, no problem.


At this point, it might be more useful if you explained more 
completely what it is you're trying to accomplish. Then people on the 
list could help you solve the problem, rather than half answer your 
half-stated question.


David

*From:* Paul Kinzelman
*Sent:* Sat Feb 26 11:56:27 EST 2022
*To:* Tommy Trussell
*Cc:* Gnucash Elist
*Subject:* Re: [GNC] Report question

Thank you for the detailed instructions.
I found that 'Transaction Report' will do what I want, but then
I can't export to CSV.

I can export to HTML by Export Report
I can 'Export as PDF' but not CSV. That's what I'm missing.
This would be really nice to add.

I can Export Transactions, but that does not export the transactions
of the transaction report which is what I wanted to do.

On 2/25/2022 6:08 PM, Tommy Trussell wrote:

On Fri, Feb 25, 2022 at 9:27 AM Paul Kinzelman
 wrote: Do you mean Account Report? But when I
go to File | Export, it asks me which accounts again, it doesn't
export the actual report. When I export the transactions I want,
it exports both sides of the transaction, so the column sum is
always zero whereas I want the sum of the transactions. In other
words, each transaction takes two lines, the line I want (the
expense of what I bought), and the next line which is the account
that paid it (like a charge card). How do I get rid of the
double-lines on the export? We're apparently not seeing the same
thing you are. Here's a way to get an Account Report for your
credit card transactions. (This is using GnuCash 4.9.) 1) Open the
account    Accounts tab --> open Liabilities : Credit Cards :
BigBankTwo VISA (yours will differ) 2) Use Filter By to select the
transactions you want [while the register is active]    View -->
Filter By (choose parameters such as date, number of days,
reconciled, etc.) 3) Open Account Report [while the filtered
register is active]     Reports --> Account Report 4) Adjust the
options on the report    Edit --> Report Options    (here you can
adjust specific columns, single or double amount columns, totals
or running total, style, report name, etc.) 5) Export the report  
  You can copy what's on your screen and paste it into a word
processor or spreadsheet     OR     File --> Export --> Export
Report  (give it a name -- it will save an .html file you can open
with a web browser or a spreadsheet program) - Please remember
to CC this list on all your replies. You can do this by using
Reply-To-List or Reply-All.




gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please 
seehttps://wiki.gnucash.org/wiki/Mailing_Lists  for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Report question

[davidcousens49]

Paul

You can copy the report to a spreadsheet by selecting the report tab, selecting
all the content using Ctrl-A, copy it with Ctrl-C and paste it into your
favourite spreadsheet. Works into LibreOffice Calc and should work equally with
Excel. You can then save it either as CSV or in the spreadsheet format.

Works for GnuCash 4.9 on Linux Mint 20.2 

Alternatively the menu item File->Export->Export Report will export the report
as HTML and you can open it in a browser, Ctrl-A, Ctrl_C and then paste to a
spreadsheet. Save in desired format

These are fairly simple to do and avoid having to write a lot of code.

David Cousens

On Sat, 2022-02-26 at 09:56 -0700, Paul Kinzelman wrote:
> Thank you for the detailed instructions.
> I found that 'Transaction Report' will do what I want, but then
> I can't export to CSV.
> 
> I can export to HTML by Export Report
> I can 'Export as PDF' but not CSV. That's what I'm missing.
> This would be really nice to add.
> 
> I can Export Transactions, but that does not export the transactions
> of the transaction report which is what I wanted to do.
> 
> On 2/25/2022 6:08 PM, Tommy Trussell wrote:
> > On Fri, Feb 25, 2022 at 9:27 AM Paul Kinzelman  wrote:
> > 
> > Do you mean Account Report? But when I go to File | Export, it asks
> > me which accounts again, it doesn't export the actual report.
> > 
> > When I export the transactions I want, it exports both sides of the
> > transaction, so the column sum is always zero whereas I want the
> > sum of the transactions.
> > 
> > In other words, each transaction takes two lines, the line I want
> > (the expense of what I bought), and the next line which is the
> > account that paid it (like a charge card).
> > 
> > How do I get rid of the double-lines on the export?
> > 
> > 
> > We're apparently not seeing the same thing you are.
> > 
> > Here's a way to get an Account Report for your credit card 
> > transactions. (This is using GnuCash 4.9.)
> > 
> > 1) Open the account
> >Accounts tab --> open Liabilities : Credit Cards : BigBankTwo VISA  
> > (yours will differ)
> > 
> > 2) Use Filter By to select the transactions you want [while the 
> > register is active]
> >View --> Filter By (choose parameters such as date, number of days, 
> > reconciled, etc.)
> > 
> > 3) Open Account Report [while the filtered register is active]
> > Reports --> Account Report
> > 
> > 4) Adjust the options on the report
> >Edit --> Report Options
> >(here you can adjust specific columns, single or double amount 
> > columns, totals or running total, style, report name, etc.)
> > 
> > 5) Export the report
> > You can copy what's on your screen and paste it into a word 
> > processor or spreadsheet
> > OR
> > File --> Export --> Export Report  (give it a name -- it will save 
> > an .html file you can open with a web browser or a spreadsheet program)
> > 
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> > 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Report question

[Adrien Monteleone]

No need to open in a browser first. LibreOffice Calc can open/import an 
HTML table just fine, though you may want to play with formatting after.


Regards,
Adrien

On 2/26/22 3:24 PM, davidcousen...@gmail.com wrote:

Alternatively the menu item File->Export->Export Report will export the report
as HTML and you can open it in a browser, Ctrl-A, Ctrl_C and then paste to a
spreadsheet. Save in desired format


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Report question

[Adrien Monteleone]

Eric,

When starting a new topic, rather than replying to an existing one, 
simply send a new message to the list address. Otherwise, it might not 
get noticed.


--

As to your specific question, I'm not sure how you're dividing up your 
Ordinary & Exceptional expenses. GnuCash doesn't have a means (as of 
now) to divide Expense or Income reporting on a P&L/Income Statement 
into any sort of categories or classifications. (commonly used in 
Managerial Accounting)


Option 1


Create an intermediary placeholder account for Ordinary & Exceptional 
under the main Expenses account:


Expenses:Ordinary
Expenses:Exceptional

and then place your various expense accounts under these.

Use the Multi-Column Report, place a P&L in each column, set one for 
Ordinary and only 1 level so you'll get just the total, set the other 
for Exceptional and set it for ALL levels. (or however many desired) 
Only include the relevant accounts in each. The technically don't have 
to be in separate side-by-side columns. Think of them more as 'sections' 
or 'frames'. The Dashboard is an example of this.


If you mostly have a case where set accounts don't fall under either 
classification on an exclusive and regular basis (that is, sometimes 
they are Ordinary, sometimes not) then your best bet would be:


Option 2


'Tag' your Memo or Action fields with 'Ordinary' or 'Exceptional' as needed.

Then run a Transaction Report using the preferred tag as a filter.

Unfortunately, you'd have to do this separately for each tag, as even 
though you could write a REGEX to cover both, it would not separate them.


Option 3

Run a regular P&L, export or copy/paste to a spreadsheet app and 
manipulate further as desired.


Regards,
Adrien

On 2/9/23 7:48 AM, Eric Coates via gnucash-user wrote:

Good afternoon

I've decided to do some exploration of the Reports option in GnuCash, 
specifically the Reports/Income & Expense/Profit & loss.


The default settings give me much of what I want but ...

I have two classes of Expenses, "Ordinary" and "Exceptional"; I want the 
full breakdown of the Exceptional expenses (which is provided) but I 
only need the total for the Ordinary expenses. After a few hours of 
clicking check boxes I've not been able to get what I want - is it 
possible?


I'm old enough it's not always possible to have what I want (and frankly 
I can live with what is provided) but it would be nice!


___
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] Report question

[R Losey]

This may be simple-minded, but why not have two reports; one with Ordinary
Expense accounts selected, and the other with the Exceptional account
selected. For the latter, you can have it show the full breakdown.

On Thu, Feb 9, 2023 at 7:50 AM Eric Coates via gnucash-user <
gnucash-user@gnucash.org> wrote:

> Good afternoon
>
> I've decided to do some exploration of the Reports option in GnuCash,
> specifically the Reports/Income & Expense/Profit & loss.
>
> The default settings give me much of what I want but ...
>
> I have two classes of Expenses, "Ordinary" and "Exceptional"; I want the
> full breakdown of the Exceptional expenses (which is provided) but I
> only need the total for the Ordinary expenses. After a few hours of
> clicking check boxes I've not been able to get what I want - is it
> possible?
>
> I'm old enough it's not always possible to have what I want (and frankly
> I can live with what is provided) but it would be nice!
>
> Thanks for any guidance
>
> Eric
>
> ___
> 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] Report question

[Eric Coates via gnucash-user]

Adrien wrote:

"When starting a new topic, rather than replying to an existing one, 
simply send a new message to the list address. Otherwise, it might not 
get noticed


Sorry. Although I did start with an existing post I changed the Subject 
and I thought that would have removed the antecedents of the original 
message. I live and learn!


Richard asked:

"... why not have two reports; one with Ordinary Expense accounts 
selected, and the other with the Exceptional account selected. For the 
latter, you can have it show the full breakdown"


Indeed that would be simple but as I said I'm exploring the reports ie 
pushing the limits of my knowledge. It has the disadvantage that I would 
need multiple reports to get what I want which basically boils down to 
"everything on one sheet of paper". Yes I'm aware of the spreadsheet 
work around but "why do it easy when you can do it Eric" as a friend of 
mine often asked!




Adrien suggested using the multi column report. I have tried this but, 
having got a Profit & Loss report in each of the two columns I cannot 
see any way of trimming them down. There is no information as how to do 
this in the manual (9.3.5.2). Suggestions would be welcomed. (I'm using 
GnuCash 4.8 on Ubuntu Mate 22.04, is the full functionality only 
available in a later version/elsewhere?)


For completeness: My account structure structure is not the one Adrien 
suggested; our expenses are separated into ""Ordinary" and "Exceptional" 
according to our requirements (to other people it probably looks 
arbitrary!) and both classes are top level accounts of Type Expense.


Thank you for your patience

Eric

___
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] Report question

[R Losey]

Noted; however, there comes a time for everyone when the work involved in
the more complex solution is not worth just adopting the simple solution.
If you did get it to work as a single report, it is likely to be multi-page
anyway... I think you've probably hit the limit of the reports; I'm not
aware of any way to have one report in which some accounts are just
summarized and others have detailed information, unless you change how the
data is entered somehow. But best wishes with your project.

On Fri, Feb 10, 2023 at 12:23 PM Eric Coates via gnucash-user <
gnucash-user@gnucash.org> wrote:

> Adrien wrote:
>
> "When starting a new topic, rather than replying to an existing one,
> simply send a new message to the list address. Otherwise, it might not
> get noticed
>
> Sorry. Although I did start with an existing post I changed the Subject
> and I thought that would have removed the antecedents of the original
> message. I live and learn!
>
> Richard asked:
>
> "... why not have two reports; one with Ordinary Expense accounts
> selected, and the other with the Exceptional account selected. For the
> latter, you can have it show the full breakdown"
>
> Indeed that would be simple but as I said I'm exploring the reports ie
> pushing the limits of my knowledge. It has the disadvantage that I would
> need multiple reports to get what I want which basically boils down to
> "everything on one sheet of paper". Yes I'm aware of the spreadsheet
> work around but "why do it easy when you can do it Eric" as a friend of
> mine often asked!
>
> 
>
> Adrien suggested using the multi column report. I have tried this but,
> having got a Profit & Loss report in each of the two columns I cannot
> see any way of trimming them down. There is no information as how to do
> this in the manual (9.3.5.2). Suggestions would be welcomed. (I'm using
> GnuCash 4.8 on Ubuntu Mate 22.04, is the full functionality only
> available in a later version/elsewhere?)
>
> For completeness: My account structure structure is not the one Adrien
> suggested; our expenses are separated into ""Ordinary" and "Exceptional"
> according to our requirements (to other people it probably looks
> arbitrary!) and both classes are top level accounts of Type Expense.
>
> Thank you for your patience
>
> Eric
>
> ___
> 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] Report question

[Michael or Penny Novack]

I have two classes of Expenses, "Ordinary" and "Exceptional"; I want the
full breakdown of the Exceptional expenses (which is provided) but I
only need the total for the Ordinary expenses. After a few hours of
clicking check boxes I've not been able to get what I want - is it
possible?

You have given a perfect example why it can be better to run the report 
(in Gnucash) and then export the raw re[port to a document you can edit 
as needed. I used to vary detail by area all the time, but I didn't ask 
gnucash to do that for me.


Thus as treasurer, needed full breakdowns, how much went to each intern, 
how much was time and how much mileage reimbursement << for tax filing 
>> but on their copy of the quarterly report the board of directors 
just care about the total spent on interns . Or for an event, the 
postage and mailing expense separate (line item on 990/990-EZ) but for 
the BoD just expense total for the event.


Note that even if you HAD "boxes to click on and off" this would be 
slower than editing out unwanted detail using a full capability editor.


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] Report Question

[R Losey]

Hi.

I don't consider myself accomplished regarding GnuCash Reports, but for
what you are wanting, it sounds like a spreadsheet is the perfect way to
go.  Maybe get the data into a spreadsheet, and then you can adjust it /
report it to your heart's content. If you find a good way to get a report
on just those accounts, it seems that (based on other emails here) you can
cut and paste the report data into a spreadsheet.


On Fri, Mar 24, 2023 at 9:11 PM Matthew Clay  wrote:

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


-- 
_
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] Report Question

[Guille Lopez]

Hello,

For this purpose, one could also use a portfolio tracking specific tool 
such as https://www.portfolio-performance.info/en/.


Using export function from GnuCash or the banks, it is not be too 
cumbersome to synchronize both software, remaining GnuCash in charge of 
the accounting part of the story and Portfolio Performance in charge of 
the portfolio analysis.


Portfolio Performance offers the feature "Taxonomies" , which address 
your particular request.


BR,

Guillermo

On 26/03/2023 03:10, R Losey wrote:

Hi.

I don't consider myself accomplished regarding GnuCash Reports, but for
what you are wanting, it sounds like a spreadsheet is the perfect way to
go.  Maybe get the data into a spreadsheet, and then you can adjust it /
report it to your heart's content. If you find a good way to get a report
on just those accounts, it seems that (based on other emails here) you can
cut and paste the report data into a spreadsheet.


On Fri, Mar 24, 2023 at 9:11 PM Matthew Clay  wrote:


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.




___
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] Report Question

[Matthew Clay]

Hey Richard and Guillermo,

Thanks for your suggestions. I will try exporting the data and using
another tool.

Sincerely,
Matthew

On Sun, Mar 26, 2023, 04:20 Guille Lopez  wrote:

> Hello,
>
> For this purpose, one could also use a portfolio tracking specific tool
> such as https://www.portfolio-performance.info/en/.
>
> Using export function from GnuCash or the banks, it is not be too
> cumbersome to synchronize both software, remaining GnuCash in charge of
> the accounting part of the story and Portfolio Performance in charge of
> the portfolio analysis.
>
> Portfolio Performance offers the feature "Taxonomies" , which address
> your particular request.
>
> BR,
>
> Guillermo
>
> On 26/03/2023 03:10, R Losey wrote:
> > Hi.
> >
> > I don't consider myself accomplished regarding GnuCash Reports, but for
> > what you are wanting, it sounds like a spreadsheet is the perfect way to
> > go.  Maybe get the data into a spreadsheet, and then you can adjust it /
> > report it to your heart's content. If you find a good way to get a report
> > on just those accounts, it seems that (based on other emails here) you
> can
> > cut and paste the report data into a spreadsheet.
> >
> >
> > On Fri, Mar 24, 2023 at 9:11 PM Matthew Clay  wrote:
> >
> >> 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.
> >>
> >
>
___
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] Report Question

[Stephen M. Butler via gnucash-user]

On 12/1/19 12:20 PM, Joseph Hesse wrote:
> I want to generate a report of:
>
> All the expenses for 2 subaccounts and their subaccounts of Expenses. 
> I want the report for all of 2019 and I don't want the matching
> transfer accounts.
>
> What Report type do you suggest I use?  There are too many to try them
> all.
>
> Thank you,
>
> Joe 

Transactions.  You can select which accounts on which you want to report
by appropriate selections on the options menu.  You can pick how you
want to sort them, group them, with/without totals and with/without
their other splits.

--Steve

-- 
Stephen M Butler, PMP, PSM
stephen.m.butle...@gmail.com
kg...@arrl.net
253-350-0166
---
GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.