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 > <[email protected]> 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 > > [email protected] > > 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 [email protected] 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.
