Interest Gain Loss (QMac) [Edited]

William Day · April 22

Show an amount in the Gain/Loss Columns for interest generated by money market funds in Quicken Classic for Mac.

[Edited - Moved to QMac section]

NotACPA · April 22

Interest isn't a Gain or Loss. It's income, not a capital event as the price of the security didn't change.

Simple accounting should overrule this idea.

HOWEVER, if you're holding that MMF as a security, and not as Cash, there is an "Amount Income" column that can be displayed, at least in the Business & Personal product. Or several other income oriented columns that might work.

BUT, as stated, I'd vote against this on the grounds that it violates accounting practice.

William Day · April 23

It would be helpful to know how much 'interest (i.e. income)', was earned in the gain/loss columns, from an investment in a money market fund. While this might go against simple accounting rules it would be useful information to investors with positions in money market funds.

William Day · May 7

Irrespective of 'accounting rules', if one invested $100,000.00 in a money market fun that is now worth $110,000.00 one has received a $10,000.00 (10%) gain and that should be reflected somewhere within Quicken Classic for the Mac.

NotACPA · May 7

Your asking Q to ignore accounting rules??? NEVER GOING TO HAPPEN!

And, to repeat myself, you don't have a "gain", you have "interest income" and they're taxed entirely differently.

There are reports in both QWin and QMac that depict what you want to see … use them.

Boatnmaniac · May 7

I'm a bit confused. Is this request about cap gains/losses reports or is this about portfolio value gains/losses? They are 2 separate things.

If this is about portfolio value gains/losses and not about cap gains/losses: In QWin, on some of the views available in Portfolio on the Investing tab, the view can be customized to add a column for dividend income but there is no option to add a column for interest income. If this is what the request is for, then I think it is a reasonable request.

But if this is about cap gains/losses then I agree with @NotACPA that it would not be appropriate to add an interest column.

NotACPA · May 7

@Boatnmaniac

The specific wording of the OP is:

"Show an amount in the Gain/Loss Columns for interest generated by money market funds"

And CapGains are simply not interest.

Jim_Harman · May 7

Money market mutual funds pay dividends, so in QWin that is included in the Income column of the Performance views, the Investment Income report, or the Income by Security report.

The income is part of the fund's total return, which is shown as a percentage in the Avg Annual Return (%) columns in the Portfolio views and the Investment Performance Report.

q_lurker · May 7

@William Day Below is a screen snip of a portfolio view of one of my MM funds.

The Gain/Loss is 0.00 as it should be since the fund is a constant $1 value, and thus the cost basis and market value are equal. A separate column of Income shows 1,093.31 paid out by the fund over the time frame I have owned any shares of the MM fund. That is the 'Interest' paid out by the MM over that period. Interest, dividends, and similar distributions are not applicable in the gain/loss column.

Boatnmaniac · May 7

https://community.quicken.com/discussion/comment/20552892#Comment_20552892

Yes, the OP did said "gain/loss columns" but did not say "cap gain/loss columns."

Here is what I was talking about from the Portfolio Value view. And I stand corrected because there already is an income (i.e., interest) column available in the customization options.:

NotACPA · May 8

@Boatnmaniac I don't seem to have, in R67.7 an "Income" column. I DO have an "Amount Income" column, but it appears to include Cap Gains also for any security in which I've previously sold some of it.

Also, that Dividend column seems to be the current dividend paid per whatever period, not cumulative.

In your graphic, have you not held the CDs long enough for them to have paid anything .. since Income is $0?

Jim_Harman · May 8

If Multicurrency support is enabled, the Return XXX columns are re-named to Amount Return XXX and the Income column becomes Amount Income. The Amount names are actually a little more descriptive because they help to distinguish from the (%) columns.

I don't know of a logical explanation for this changes with multicurrency support.

NotACPA · May 8

@Jim_Harman I NEVER would have suspected that. And I do hold a few Euros, that weren't spent after a prior vacation.

Jim_Harman · May 8

It was a head-scratcher for me, too. When this first came up several years ago, @Rocket J Squirrel said,

I only have a guess. IIRC, in the past, the quantity today called "Amount Invested" used to be "Dollars Invested". It is possible that these multicurrency-related quantities formerly used "Dollars" which got bulk-edited into "Amount".

Boatnmaniac · May 8

I was certainly dumbfounded by the difference between @NotACPA's view and mine since we both are running R67.7. I doubt that I would have ever figured out that it is caused by the multi-currency setting.

jacobs · May 9

Unfortunately all of the Quicken Windows discussion above is not relevant to the original request, which is for Quicken Mac.

In Quicken Mac, there is no "Income" or "Interest" field in the Portfolio.

Interest amounts can be seen in an income report or tax report, but not in the Portfolio, where interest income adds to the Cash balance. There are ROI and IRR columns available in a Portfolio > Performance view, and these values reflect interest income, but there is no separate column for interest.

William Day · May 11

Intuit needs to take a page from the windows version of Quicken and add an INCOME column to the available columns in the Portfolio Value screen in Quicken for Mac Classic.

jacobs · May 11

@William Day Just FYI, Quicken hasn’t been part of Intuit for a decade. (Quicken still contracts with Intuit to provide connectivity services, because only a large company like Intuit or Plaid can works with thousands of financial institutions, but the Quicken company has been independent since 2016.)

William Day · May 12

Thanks for the update….

Interest Gain Loss (QMac) [Edited]

Reviewed · Last Updated May 8

Comments

Categories