Income by Security Report

GTmem
GTmem Quicken Windows Subscription Member ✭✭✭

please add Long Term Capital Gains distributions to the report.. I love the format of the report, but I cant find any way to replicate with other reports to have this distribution type shown as well, particularly for mutual fund accounts

image.png
1
1 votes

New · Last Updated

Comments

  • NotACPA
    NotACPA Quicken Windows Subscription SuperUser ✭✭✭✭✭
    edited December 10

    What Q product are you running … and what BUILD of that product?

    Because when I click REPORTS, Investing, Investing Income and customize it for last year, I'm seeing LTCGains and I'm NOT seeing the same headers as you're showing.

    My graphic is for 1 account only … but when I include multiple accounts I get a separate column for each.

    image.png

    Q user since February, 1990. DOS Version 4
    Now running Quicken Windows Subscription, Business & Personal
    Retired "Certified Information Systems Auditor" & Bank Audit VP

  • GTmem
    GTmem Quicken Windows Subscription Member ✭✭✭

    Its the Quicken Standard Report called Income by Security. I can create the report you showed, but then I have to run it by each security.. The report I showed pre-aggregated by account and by security in one nice report. I expanded the image to show the actual report columns. I thought _LT CapGnDst might be included in Other Income, but they are not, so its really missing if you want a full view, This could be a big timesaver.

    image.png image.png
  • maxwelwp
    maxwelwp Quicken Windows Subscription Member, Windows Beta Beta

    Two different reports - Income by Security Report and Investment Income. The latter shows the Capital Gains

    “Never stop dreaming,never stop believing,never give up,never stop trying, andnever stop learning.”
    Quicken user since 1993

  • GTmem
    GTmem Quicken Windows Subscription Member ✭✭✭

    Correct. The Investment Income report does not meet my need as you cant subtotal on both Account and Security. Plus, it puts securities in columns, which makes it harder to read.

  • Jim_Harman
    Jim_Harman Quicken Windows Subscription SuperUser ✭✭✭✭✭

    In the Income by Security report, both Long and Short Term capital gains distributions are included in the Realized Gains column.

    To see the breakdown of long vs short term gains and gains from sales vs CG distributions, you would have to look at the Tax reports.

    QWin Premier subscription
  • NotACPA
    NotACPA Quicken Windows Subscription SuperUser ✭✭✭✭✭

    OK, now that I know what report you're looking at, I did some exploring. For CG distributions to be displayed, you need to check the "Realized Gains" box.

    I have a security which has paid CGLong twice this year, but nothing else, and it didn't even show until I clicked that box.

    Q user since February, 1990. DOS Version 4
    Now running Quicken Windows Subscription, Business & Personal
    Retired "Certified Information Systems Auditor" & Bank Audit VP