Re: [GNC] Report Question

2023-03-26 Thread 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

Re: [GNC] Report Question

2023-03-26 Thread 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

Re: [GNC] Report Question

2023-03-25 Thread 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

[GNC] Report Question

2023-03-24 Thread 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

Re: [GNC] Report question

2023-02-10 Thread 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

Re: [GNC] Report question

2023-02-10 Thread 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

Re: [GNC] Report question

2023-02-10 Thread 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

Re: [GNC] Report question

2023-02-09 Thread 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 <

Re: [GNC] Report question

2023-02-09 Thread 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

[GNC] Report question

2023-02-09 Thread 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

Re: [GNC] Report question

2022-03-03 Thread 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

Re: [GNC] Report question

2022-02-26 Thread 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

Re: [GNC] Report question

2022-02-26 Thread Paul Kinzelman
:* 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

Re: [GNC] Report question

2022-02-26 Thread D. via gnucash-user
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

Re: [GNC] Report question

2022-02-26 Thread 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

Re: [GNC] Report question

2022-02-26 Thread 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

Re: [GNC] Report question

2022-02-26 Thread 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

Re: [GNC] Report question

2022-02-25 Thread 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

Re: [GNC] Report question

2022-02-25 Thread 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

Re: [GNC] Report question

2022-02-24 Thread 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

Re: [GNC] Report question

2022-02-24 Thread 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

[GNC] Report question

2022-02-24 Thread 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

Re: [GNC] Report Question

2021-09-22 Thread 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

Re: [GNC] Report Question

2021-09-22 Thread 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

[GNC] Report Question

2021-09-22 Thread 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

Re: [GNC] Report Question

2019-12-01 Thread 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

[GNC] Report Question

2019-12-01 Thread 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