Realized Gains on Sales of Money Market Positions?

isonclubikin

I just ran an Investment Income (Reports > Investing > Investment Income) report and was surprised when it showed me large realized gains (_RlzdGain) for last year (I hadn't sold any stocks). Drilling down into those, I get another report showing that they were all from the sale of Money Market Mutual Fund (MMF) positions. I don't understand how that is. I've recorded a $1 price for every MMF purchase I've ever made. The sales have also been at $1. AFAIK, that's a 0 realized gain. Can anyone explain this and come up with some way to fix it?

isonclubikin

EDIT: Solved. As noted, below, all the bad transactions had Bought dates of 10/30/2012. I checked that date, and luckily, it was all one transaction. I copied all the information, deleted the transaction and manually re-entered it. All the realized gains went away. The Bought dates on the sales still don't look to be First In. But, I can live with that. Thanks for the pointers to help me track this down.

OP: Looking at the Capital Gains report, that makes even less sense than before. All those capital gains that I was seeing before are present. They're totaling tens of thousands of dollars per year (basically, much of a large subset of all the MMF sales are just showing up as realized gains). Once again, checking the transactions that show realized gains, they all look fine: $1 price and selling First Shares In.

The "less sense than before" part relates to the selling of First Shares In. Every sale of every security I've ever sold has been First Shares In (even the MMF). Yet, I look at the Bought date of the Capital Gains report, and that's not what it's showing. Sorting all the MMF Capital Gains transactions in that account by date sold, I'd expect the date bought entries to be in increasing order. They're not. They waver all over the place.

But, I exported just the Sold, Bought, and Gain/Loss% to a spreadsheet and filtered out all the correct transactions (the ones with 0 realized gains). That left me with just the bad transactions. They all show the Bought date being on 08/30/2012 (which, given the amounts, seems highly unlikely). The trouble is, there are 639 (out of 755) of those transactions ranging from 2013 to 2023. I guess I'll take a look at some of them. But, I have no idea how I'm going to look at them all.

Jim_Harman

Do you have any Added transactions for your MMFs? They might have a zero cost basis.

Also in an affected account, click on Holdings then click on the + sign next to the MMF. This will show all the tax lots you currently hold. Do any have a cost basis that is not $1.00/share? If so, investigate.

If this all looks good, set the As of date at the top right to before the date when you see a gain. Are there any bad lots shown now?

Please let us know what you find.

isonclubikin

From the Investing tab, clicking on the + next to the MMF shows this year's positions. All at $1.

I right-clicked on the MMF name there and chose Security Report. Reporting across all dates for the one account I'm currently working in, the only transactions for the MMF are Bought, Sold and IntInc. If I remove the Sold and _IntInc categories, all the Bought transactions are at $1. All the IntInc transactions have no price attached (as expected), but when those interest payments get swept into the MMF, they're recorded at $1.

The MMF transactions in this account go back to 2001. Everything looks fine until I get to 2013, when _RlzdGains start appearing in the report. It looks like the _RlzdGains stop in 2023. I don't see anything wrong with any of the transactions.

EDIT: If I change the As Of date on the Investment tab and run through every year, all the lots come back at $1. And, just on a wild hair, I ran a report on the account for ReinvInt actions on the MMF. It came back with about 140 such transactions way in the past (as opposed to my current Inc plus Buy. But, spot checking them, they all look fine: each ReinvInt has the Amount and Shares boxes the same (i.e., share price was $1).

Validating, Rebuilding Invesment Lots and Repair Price History on the file all come back clean. I'm at a loss for what to do:

QDF:
Validating your data.
No errors.

QEL:
No read errors.

QEL:
All internal consistency checks passed.

[Mon Dec 16 16:39:15 2024]
Maximum security reference: 248, number of securities: 248.
All security references are within the normal range.

Validation has completed.

[Mon Dec 16 16:43:06 2024]
Rebuilt investing lots.
All security references are within the normal range.

Repair price history: 0 price(s) repaired.
[Mon Dec 16 16:45:07 2024]

Price history updated from transactions
All security references are within the normal range.

isonclubikin

Let me break this question out of the wall of text, above: is anyone else showing realized gains on money market sales for 2023 in the Investment Income report.

q_lurker

R56.9 — No, not for 2023. FYI: I have a security type == Money Market and filtered the report to that set of securities.

If I include all dates, for some reason I choose not to chase, I show a $0.16 gain back in 1993, and a few other gains/losses at $0.01 to 0.03.

What does your Capital Gains report show for those transactions? Should identify cost basis, sale date and acquisition dates.

isonclubikin

EDIT: Solved. As noted, below, all the bad transactions had Bought dates of 10/30/2012. I checked that date, and luckily, it was all one transaction. I copied all the information, deleted the transaction and manually re-entered it. All the realized gains went away. The Bought dates on the sales still don't look to be First In. But, I can live with that. Thanks for the pointers to help me track this down.

OP: Looking at the Capital Gains report, that makes even less sense than before. All those capital gains that I was seeing before are present. They're totaling tens of thousands of dollars per year (basically, much of a large subset of all the MMF sales are just showing up as realized gains). Once again, checking the transactions that show realized gains, they all look fine: $1 price and selling First Shares In.

The "less sense than before" part relates to the selling of First Shares In. Every sale of every security I've ever sold has been First Shares In (even the MMF). Yet, I look at the Bought date of the Capital Gains report, and that's not what it's showing. Sorting all the MMF Capital Gains transactions in that account by date sold, I'd expect the date bought entries to be in increasing order. They're not. They waver all over the place.

But, I exported just the Sold, Bought, and Gain/Loss% to a spreadsheet and filtered out all the correct transactions (the ones with 0 realized gains). That left me with just the bad transactions. They all show the Bought date being on 08/30/2012 (which, given the amounts, seems highly unlikely). The trouble is, there are 639 (out of 755) of those transactions ranging from 2013 to 2023. I guess I'll take a look at some of them. But, I have no idea how I'm going to look at them all.