nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Quicken spending reports, unrealized gains and losses appear in both Income/Expenses

RKazar

In my Quicken spending reports, unrealized gains and losses appear in both the income and expense sections. The total is correct, but I'm not sure why the amount is split between income and expense. There does not seem to be a pattern to why some unrealized gains show in the expense section vs. the income section.

Find more posts tagged with

Accepted answers

L. Mitchell Wein

Mr. RKazar,

I noticed the same bug in the report:

Income/Expense by Category Including Unrealized Gains - Year to Date from the Investment Screen / Reports / All Reports / Comparison. That bug makes that report worthless.

On the other hand the same report from the Reports Menus at the top bar gets it right but one can only compare one period to another period. I can't get a series of months there.

It's too bad Quicken has not fixed that bug yest. I am using Quicken 2019.

All comments

Ps56k2

updated your posting title to include a basic question

Sherlock

If you haven’t already, I suggest you examine the type of the categories used in the transactions. Entries using categories with a type of Income should appear in the Income section of the report where as entries using categories with a type of Expense should appear in the Expense section of the report. Transfers from accounts should be Income and transfers to accounts should be Expense.

RKazar

The categories used on the spending report for unrealized gains / losses are not user created - Quicken creates them when the reports are run. The amounts are based on the differences between cost and fair market value of securities in investment accounts.

Ps56k2

Which specific report & customization ---> Reports --> Spending ?? ---> ???

RKazar

income/Expense By Category with the advanced option set to include unrealized gain/loss

Ps56k2

Hmmm.... just looked at mine, and I have no UN-realized gain/loss anywhere.

Even though Quicken has the checkbox for it - how do you have a unrealized gain/loss in a "spending" report - when is usually associated with an "investment" account.
In the spending scenario - you either received actual income, or paid out actual dollars, there is (in my mind) no accrued value/loss - how would that happen ??

RKazar

Try including all accounts - including investment accounts. The report is under Spending, but the report I'm using is called Income and Expense by category which in my mind includes income and expense from investments and would include income from unrealized gains and losses on investments.

Ultimately, I think Quicken gets the right answer, but why are investment gains and losses shown in two accounts - an income account and an expense account.

Ps56k2

- Interesting.... so I basically clicked on one of our "Schwab stock investment" accounts to add to this "Spending" report - the result that I am seeing....

A DAILY listing of the value of each stock, and it is listed with the unrealized gain/loss and duplicated in both the Income and the Expense sections of the report.

So yes, we see the same thing, but not sure why I would ever want to mix investment info with banking/spending info.

Sherlock

In my case, the _UnrlzdGain entry as an Expense appears to be associated with the sale and transfer (SoldX) of holdings on the same date.

RKazar

Thanks for the comments, but I'm trying to run an Income and Expense report. It's related to, but not the same as a spending report, and I'm my opinion with the recent market volatility an important report. My unrealized gain/loss appears to be arbitrarily split between the income and expense sections of the P&L. Quicken gets the correct answer in total, but I don't want to add two numbers to get what I think should be shown as one number. Additionally, sometimes the unrealized gain/loss in the expense section is negative (red), so I have to remember to add that number to unrealized gain/loss in the income section.

It's confusing and I still don't know why it's happening.

L. Mitchell Wein

It appears the Comparison report of Income / Expense gets Unrealized Gain right all under Income but the report showing all the months without selecting a Comparison gets it wrong bu distributing Unrealized Gain between Income and Expense.

L. Mitchell Wein

Hopefully, Quicken will see all these comments and fix the bug in the next update.