[GNC] report of investment income and capital gains (realized and unrealized) for the previous year

[Kalpesh Patel]

If needing CSV format, you can export html format, open html in Excel and then save as CSV format ... no? You can change the bulk column format in Excel before saving as CSV.

I normally highlight it in the displayed report, paste it in Excel, and save as CSV.

-----Original Message-----
From: rsbrux <rsbrux at yahoo.com> 
Sent: Sunday, January 11, 2026 11:40 AM
To: David T. <sunfish62 at yahoo.com>; rsbrux via gnucash-user <gnucash-user at gnucash.org>
Subject: Re: [GNC] report of investment income and capital gains (realized and unrealized) for the previous year

Thanks, this would solve the problem for tax reporting, but I am most interested in unrealized gains.
One workaround would be to  import the Advanced Portfolio reports from the ends of two successive years into spreadsheets and calculate the differences in a third sheet.
Unfortunately, neither Excel nor LibreOffice Calc can properly recognize the amounts in the HTML files.  Any amounts preceded by currency symbols (I have several different currencies in GnuCash) or containing thousands separators are treated as text instead of numbers.
A further minor annoyance is the failure to correctly interpret accented characters (Umlauts).
I  used to be able to export reports as CSV but no longer find a way to do this in GC 5.14.
I only find ways to export HTML or PDF. Am I missing something obvious?
Any workaround suggestions?

On Sat, 2026-01-10 at 23:41 +0530, David T. wrote:
> I never open the Advanced Portfolio report. 
> 
> For tax purposes, I set up my accounts to have individual income 
> accounts for each brokerage (dividends, LT capital gains, and ST 
> capital gains, typically) and then assigned each of these to the 
> appropriate tax line in tax options. Then, the TXF report (changed to 
> hide zero balance accounts and transaction detail) summarizes 
> everything nicely.
> 
> Income
> - Dividends
> - - Broker A [assigned to Taxable dividend income]
> - - Broker B [assigned to Taxable dividend income]
> - Realized Gains
> - - Broker A
> - - - LT Capital Gains [assigned to Taxable LT gains]
> - - - ST Capital Gains [assigned to Taxable ST gains]
> - - Broker B
> - - - LT Capital Gains [assigned to Taxable LT gains]
> - - - ST Capital Gains [assigned to Taxable ST gains]
> 
> David T.
> 
> 
> 
> On January 10, 2026 11:05:04 PM GMT+05:30, rsbrux via gnucash-user 
> <gnucash-user at gnucash.org> wrote:
> > The Advanced Portfolio is close to what I want, but gives me the 
> > numbers over the entire time I have owned the securities.
> > Is there some way I can modify the report to show the *difference* 
> > between the end of year results for two consecutive years?
> > If this requires learning scheme, I would appreciate being referred  
> > to a good tutorial (preferably a document, not a video).
> > I found some useful info here:
> > https://gnucash.org/docs/v5/C/gnucash-manual/report-create.html
> > but am surprised that no one else has addressed this, as I imagine 
> > it would be needed for tax reporting.
> > gnucash-user mailing list
> > gnucash-user at 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.