|
#16
| |||
| |||
| Just tried Level1 repair: Log shows: " No broken records in the original file." "- Bobb -" <bobb[at]noemail.123> wrote in message news:%23kDTXOH6IHA.4596[at]TK2MSFTNGP03.phx.gbl... - quote - > "Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in message > news:5pqv741a8rqsku89g69lhfi2hi0rcp7ptd[at]4ax.com... > > In microsoft.public.money, - Bobb - wrote: > > > > > > > ... using a differently-named copy of your file, I assume. > > > Also, have you done a > > File-> RepairMoneyFile-> StandardFileRepair level 1 lately? > > It will remove saved favorite reports tho. > Not only haven't I done it lately, I've never done it at all. > re previous ... > You asked: > > When you right-click a reference to the fund > > in the CG report and GoToInvestment-> Details what does it show as > > the InvestmentType? > > It shows as ** Money Market ** |
|
#15
| |||
| |||
| In microsoft.public.money, - Bobb - wrote: - quote - > Not only haven't I done it lately, I've never done it at all.
I suggest you try the level 1.- quote - > re previous ...
OK... Thanks.> You asked: > > When you right-click a reference to the fund > > in the CG report and GoToInvestment-> Details what does it show as > > the InvestmentType? > > It shows as ** Money Market ** |
|
#14
| |||
| |||
| "Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in message news:5pqv741a8rqsku89g69lhfi2hi0rcp7ptd[at]4ax.com... - quote - > In microsoft.public.money, - Bobb - wrote:
Not only haven't I done it lately, I've never done it at all.> > > > ... using a differently-named copy of your file, I assume. > Also, have you done a > File-> RepairMoneyFile-> StandardFileRepair level 1 lately? > It will remove saved favorite reports tho. re previous ... You asked: - quote - > When you right-click a reference to the fund
It shows as ** Money Market **> in the CG report and GoToInvestment-> Details what does it show as > the InvestmentType? |
|
#13
| |||
| |||
| In microsoft.public.money, - Bobb - wrote: - quote - > > ... using a differently-named copy of your file, I assume.
Also, have you done aFile-> RepairMoneyFile-> StandardFileRepair level 1 lately? It will remove saved favorite reports tho. |
|
#12
| |||
| |||
| "Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in message news:admu749cur2mlj8s7ihcabqsuf89a3dui4[at]4ax.com... - quote - > In microsoft.public.money, - Bobb - wrote:
** Money Market **> > re: previous " sweep account comment"... > > Cash Reserves ( or FCASH or whatever it's called ) is my DEFAULT sweep > > account. > OK. > > BUT > > if you have no money in FCASH, and have money in another mmkt (Select > > Money Market), when you buy 'something' you need to have cash in FCASH. > > Their system realizes that I have no money in FCASH so their system > > automatically sells Select Money Market and sweeps that to my FCASH. > > Then > > the trade gets executed leaving FCASH empty again. > I didn't know that. I guess that the account is set up as a cash, > rather than margin, account. > <snip> > > How do you get to the report you are looking at? > > > Generate a YTD cap gains report > > Then click Customize > > Then - on Investment tab - click the dropdown from menu on right - the > > middle option " Select Investment Type ", then choose Money Market. > > That report then shows this fund as MMF - with LT Cap Gains only - > > listed > > in the report. > Ahh. I had missed that. Thanks. > > (even though when I display Portfolio, it shows as "Mutual Fund".) > Now that seems strange. When you right-click a reference to the fund > in the CG report and GoToInvestment-> Details what does it show as > the InvestmentType? - quote - > > > BTW, I was thinking - just change date/ go back a few years and play a > > bit: > > Sell all Select Money Market - move to FCASH until I identify when/ > > how/why Select Money Market shows "a gain". Then once narrowed down - > > undo > > hacks and maybe "fix it" by buying/selling/buying back - in the past - > > with comments in entry. > ... using a differently-named copy of your file, I assume. |
|
#11
| |||
| |||
| In microsoft.public.money, - Bobb - wrote: - quote - > re: previous " sweep account comment"...
OK.> Cash Reserves ( or FCASH or whatever it's called ) is my DEFAULT sweep > account. - quote - > BUT
I didn't know that. I guess that the account is set up as a cash,> if you have no money in FCASH, and have money in another mmkt (Select > Money Market), when you buy 'something' you need to have cash in FCASH. > Their system realizes that I have no money in FCASH so their system > automatically sells Select Money Market and sweeps that to my FCASH. Then > the trade gets executed leaving FCASH empty again. rather than margin, account. <snip - quote - > > How do you get to the report you are looking at?
Ahh. I had missed that. Thanks.> Generate a YTD cap gains report > Then click Customize > Then - on Investment tab - click the dropdown from menu on right - the > middle option " Select Investment Type ", then choose Money Market. > That report then shows this fund as MMF - with LT Cap Gains only - listed > in the report. - quote - > (even though when I display Portfolio, it shows as "Mutual Fund".)
Now that seems strange. When you right-click a reference to the fundin the CG report and GoToInvestment-> Details what does it show as the InvestmentType? - quote - > BTW, I was thinking - just change date/ go back a few years and play a
.... using a differently-named copy of your file, I assume.> bit: > Sell all Select Money Market - move to FCASH until I identify when/ > how/why Select Money Market shows "a gain". Then once narrowed down - undo > hacks and maybe "fix it" by buying/selling/buying back - in the past - > with comments in entry. |
|
#10
| |||
| |||
| re: previous " sweep account comment"... Cash Reserves ( or FCASH or whatever it's called ) is my DEFAULT sweep account. BUT if you have no money in FCASH, and have money in another mmkt (Select Money Market), when you buy 'something' you need to have cash in FCASH. Their system realizes that I have no money in FCASH so their system automatically sells Select Money Market and sweeps that to my FCASH. Then the trade gets executed leaving FCASH empty again. other info requested is inline - below: "Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in message news:68hq749nf8pr3p43j2mjbngdp288nkkk56[at]4ax.com... - quote - > In microsoft.public.money, - Bobb - wrote:
YES> > > I ran Cap Gains report - YTD and > > right-click on the report, then > > "Customize -Investments" > OK. I am trying to look at that report. Is that the "Capital Gains" > report under the heading Taxes in the Reports Home? - quote - > > Then
Generate a YTD cap gains report.> > "Select Investment Type" > > I selected 'Money Market' > > It shows 3 funds including the"bad one". > In customizing that report, I see no "Select Investment Type" > choice. There is an Investment tab that lets you select which > investments are included. > How do you get to the report you are looking at? Then click Customize Then - on Investment tab - click the dropdown from menu on right - the middle option " Select Investment Type ", then choose Money Market. That report then shows this fund as MMF - with LT Cap Gains only - listed in the report. (even though when I display Portfolio, it shows as "Mutual Fund".) BTW, I was thinking - just change date/ go back a few years and play a bit: Sell all Select Money Market - move to FCASH until I identify when/ how/why Select Money Market shows "a gain". Then once narrowed down - undo hacks and maybe "fix it" by buying/selling/buying back - in the past - with comments in entry. - quote - > > > Then I chose just my > > Fidelity Select Money Market. > > In that report it shows > > Cost - Sale price - Gain > > > Cost = 15050.35 > > Sales = 15050.35 > > So far so good ... > > Gain = 13747.19 ! > > > Whaaaat ???? > > SO Money "SEES" that fund AS a > > Money Market fund - Yet shows a GAIN ?? > > Of 91.3% WOW ! > > All buy dates in the report are the same date ( I bought a chunk then so > > probably right) and I bought that lot at $1 per share and sold for $1 > > per > > share. > > My register shows REINVESTED DIVIDEND for each month's interest in that > > fund. > > Fidelity downloads/sends statements as dividend/buy - I change to > > reinvest > > dividend to eliminate one transaction. > > Should I change that to INTEREST rather than DIVIDEND ? > > Does dividend mess with cost basis/report and interest doesn't ? > > ( I still didn't get $13,747 in interest ! In fact, if I just view > > "Portfolio Mgr - "gain" column it shows ~$7000 total , not $13,700 - > > where > > Is it getting this stuff ?) > > > If I open Portfolio Manager page and look at YTD return > > - it's 1.5% so far, 3 % annual - that's more like it for a money > > market. > > > FYI: This isn't a big deal - I just uncheck for REAL reports, > > but can't figure WHY it's messed up. |
|
#9
| |||
| |||
| In microsoft.public.money, - Bobb - wrote: - quote - > I ran Cap Gains report - YTD and
OK. I am trying to look at that report. Is that the "Capital Gains"> right-click on the report, then > "Customize -Investments" report under the heading Taxes in the Reports Home? - quote - > Then
In customizing that report, I see no "Select Investment Type"> "Select Investment Type" > I selected 'Money Market' > It shows 3 funds including the"bad one". choice. There is an Investment tab that lets you select which investments are included. How do you get to the report you are looking at? - quote - > Then I chose just my > Fidelity Select Money Market. > In that report it shows > Cost - Sale price - Gain > Cost = 15050.35 > Sales = 15050.35 > So far so good ... > Gain = 13747.19 ! > Whaaaat ???? > SO Money "SEES" that fund AS a > Money Market fund - Yet shows a GAIN ?? > Of 91.3% WOW ! > All buy dates in the report are the same date ( I bought a chunk then so > probably right) and I bought that lot at $1 per share and sold for $1 per > share. > My register shows REINVESTED DIVIDEND for each month's interest in that > fund. > Fidelity downloads/sends statements as dividend/buy - I change to reinvest > dividend to eliminate one transaction. > Should I change that to INTEREST rather than DIVIDEND ? > Does dividend mess with cost basis/report and interest doesn't ? > ( I still didn't get $13,747 in interest ! In fact, if I just view > "Portfolio Mgr - "gain" column it shows ~$7000 total , not $13,700 - where > Is it getting this stuff ?) > If I open Portfolio Manager page and look at YTD return > - it's 1.5% so far, 3 % annual - that's more like it for a money market. > FYI: This isn't a big deal - I just uncheck for REAL reports, > but can't figure WHY it's messed up. |
|
#8
| |||
| |||
| In microsoft.public.money, - Bobb - wrote: - quote - > > I suspect we are close to being on the same page now.
You were right about that.> ========= > :-> I don't think so. - quote - > 'Select Money Market ' is my issue -
I understood that. I made the references as related to your question> not " FCASH" or "Cash Reserves" as to whether you are the only one ..... - quote - > 1. In my IRA's I don't use "FCASH" or Cash Reserves -as far > as Money2006 is concerned, my money just sits in "Cash". > I buy/sell from Cash Account in Money, BUT ..... > 2.In my Brokerage account , I have Cash and "Select Money Market" (symbol > = FSLXX ) AND I do download a buy/sell of Select Money Market ( all the > gain/cost basis issues have to do with that one Money Market). So if I > have no cash in FCASH, I sell $20,000 of Sel Money Market on the 17th to > settle "your trade above", I SELL $20,000 of FSLXX and "CASH" increases by > $20,000. THAT money is "what settles" and is in register. That gets > pushed to me when I update online and entered into my register. So I DO > get the Select Money Market info. > I have downloaded/ entered every buy/sell for Select Money Market since I > started Money. So you are saying, I think, that FSLXX is your automated sweep account fund. I am surprised that given that the sweep account Buys and Sells download. That seems like that should a big plus for you as far as tracking performance. And maybe you are the only one. It kinda makes me think that changing that monthly Dividend and Buy into a single ReinvestDividend is going to have a miniscule effect on your number of transactions on a percentage basis. So, to reiterate what I now think you are saying: 1. In the Details for your FSLXX it is now shown as a MMF. 2. In the Analysis (click on left), the Quantity is what you expect. 3. In the InvestmentActivities, it seems that all of your Buys and 4, Sells are there, including the sweeps. 5. You don't have any recent activity in "Cash Reserves" and that is not your designated sweep account; FSLXX (Select Money Market) is. Assuming that all of these are true, I am going back to the post where you were discussing the report. In the mean time I would do a File-> RepairMoneyFile-> QuickFileRepair if you have not done one lately. |
|
#7
| |||
| |||
| "Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in message news:609q74pjmos13k7814cdmuu1ni6s50d93h[at]4ax.com... - quote - > In microsoft.public.money, - Bobb - wrote:
Agreed - I've seen that.> > > > Now if the Buys and Sells of the MM were downloaded, then Money > > > could compute an accurate yield. > > > All info from Fidelity WAS downloaded ( has always been). I connect > > monthly > > and that data goes into my register directly. ( Like I said - for the > > Dividend + buy, I change to Reinvest div just to not have 2 entries per > > month ). > OK. Regarding that, I think I might see just the Dividend and not > the Buy. More on that below. > Let's say you have not done transactions for a week. On Monday July > 14 you Buy 100 shares of WXYZ at $100. Lets say you have 20000 > shares of MM. Now what will happen as a consequence there will be > 14 July Buy 100 WXYZ for total $10000. > your unsettled account balance goes to -10000. > you still have 20000 MM shares. Especially if I move a LOT of cash , it looks WONDERFUL as my money doubles ( until settlement) - quote - > 17 July Sell 10000 MM shares > your unsettled account balance goes to 0. > you now have 10000 MM shares. > I expect that 17 July MM Sell is not downloaded into Money for you. > If you want to see the MM buys and sells in your register on the > Fidelity Investments web site, in the History, tick "Display > settlements in core account." Expect to then see " REDEMPTION > FROM CORE ACCOUNT" and "PURCHASE INTO CORE ACCOUNT " transactions. > Those really happen. But they are not put into the OFX downloads. > Those are what I was referring to when I wrote "if the Buys and > Sells of the MM were downloaded". > Now if you get a Dividend and a Buy of the MM once per month, I > would just be tempted to Void the Buy so that Money would actually > see the MM holding to be zero shares. That way the "(Core + > Unsettled)" amount of the balance would match the Cash Transactions > register. > > AND - I'm the only [one] here that this happens to ? > > ( that's really the part that I don't understand) > Most with Fidelity Investment retirement accounts would probably > have the same sort of thing with the MM sweep accounts. Most with > non-retirement accounts have the sweep handled differently. You > don't want to know ;-) -- but if you can't help yourself, search on > "FCASH". > I suspect we are close to being on the same page now. ========= :-> I don't think so. 'Select Money Market ' is my issue - not " FCASH" or "Cash Reserves" 1. In my IRA's I don't use "FCASH" or Cash Reserves -as far as Money2006 is concerned, my money just sits in "Cash". I buy/sell from Cash Account in Money, BUT ..... 2.In my Brokerage account , I have Cash and "Select Money Market" (symbol = FSLXX ) AND I do download a buy/sell of Select Money Market ( all the gain/cost basis issues have to do with that one Money Market). So if I have no cash in FCASH, I sell $20,000 of Sel Money Market on the 17th to settle "your trade above", I SELL $20,000 of FSLXX and "CASH" increases by $20,000. THAT money is "what settles" and is in register. That gets pushed to me when I update online and entered into my register. So I DO get the Select Money Market info. I have downloaded/ entered every buy/sell for Select Money Market since I started Money. BTW: FSLXX earned more - AND it used to be that there was a 3% fee on any Select Funds , so all the money I had ever paid a 3% load on I left in there - to keep it straight and avoid paying another load: but I digress .....AND, since I'm digressing .... cleaning attic this weekend- I had a "Quicken V2.0 for DOS" upgrade coupon as a bookmark in an old paperback ! Yikes . All-Star game starting ... good night. |
|
#6
| |||
| |||
| In microsoft.public.money, - Bobb - wrote: - quote - > > Now if the Buys and Sells of the MM were downloaded, then Money
OK. Regarding that, I think I might see just the Dividend and not> > could compute an accurate yield. > All info from Fidelity WAS downloaded ( has always been). I connect monthly > and that data goes into my register directly. ( Like I said - for the > Dividend + buy, I change to Reinvest div just to not have 2 entries per > month ). the Buy. More on that below. Let's say you have not done transactions for a week. On Monday July 14 you Buy 100 shares of WXYZ at $100. Lets say you have 20000 shares of MM. Now what will happen as a consequence there will be 14 July Buy 100 WXYZ for total $10000. your unsettled account balance goes to -10000. you still have 20000 MM shares. 17 July Sell 10000 MM shares your unsettled account balance goes to 0. you now have 10000 MM shares. I expect that 17 July MM Sell is not downloaded into Money for you. If you want to see the MM buys and sells in your register on the Fidelity Investments web site, in the History, tick "Display settlements in core account." Expect to then see " REDEMPTION FROM CORE ACCOUNT" and "PURCHASE INTO CORE ACCOUNT " transactions. Those really happen. But they are not put into the OFX downloads. Those are what I was referring to when I wrote "if the Buys and Sells of the MM were downloaded". Now if you get a Dividend and a Buy of the MM once per month, I would just be tempted to Void the Buy so that Money would actually see the MM holding to be zero shares. That way the "(Core + Unsettled)" amount of the balance would match the Cash Transactions register. - quote - > AND - I'm the only [one] here that this happens to ?
Most with Fidelity Investment retirement accounts would probably> ( that's really the part that I don't understand) have the same sort of thing with the MM sweep accounts. Most with non-retirement accounts have the sweep handled differently. You don't want to know ;-) -- but if you can't help yourself, search on "FCASH". I suspect we are close to being on the same page now. |
|
#5
| |||
| |||
| "Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in message news:7tgp74p69qifcmdc50811ml2necptcos8c[at]4ax.com... - quote - > In microsoft.public.money, - Bobb - wrote:
All info from Fidelity WAS downloaded ( has always been). I connect monthly> > UPDATE: > > > I ran Cap Gains report - YTD and > > right-click on the report, then > > "Customize -Investments" > > Then > > "Select Investment Type" > > I selected 'Money Market' > > It shows 3 funds including the"bad one". > > > Then I chose just my > > Fidelity Select Money Market. > > In that report it shows > > Cost - Sale price - Gain > > > Cost = 15050.35 > > Sales = 15050.35 > > So far so good ... > > Gain = 13747.19 ! > > > Whaaaat ???? > > SO Money "SEES" that fund AS a > > Money Market fund - Yet shows a GAIN ?? > > Of 91.3% WOW ! > > All buy dates in the report are the same date ( I bought a chunk then so > > probably right) and I bought that lot at $1 per share and sold for $1 per > > share. > > My register shows REINVESTED DIVIDEND for each month's interest in that > > fund. > > Fidelity downloads/sends statements as dividend/buy - I change to reinvest > > dividend to eliminate one transaction. > > Should I change that to INTEREST rather than DIVIDEND ? > No, not by just changing the transaction type in the Investment > Transactions register. Because the Interest transaction would still > be computed as gain for that MM. If you wanted to avoid having the > outlandish gain transactions, and you were willing to do the extra > work, you could Void the Dividend in the Investment Transactions > register and enter a Deposit into the Cash Transactions register. > You could use a Payee related to the MM so you could still generate > a report. > > Does dividend mess with cost basis/report and interest doesn't ? > Yes. With the Fido method of letting the cash balance represent the > (cash+MM) total, the MM holdings appear to be zero. Yet the holding > still get somehow gets dividends. The gain on your past holdings > comes out to these fantastic numbers. > Now if the Buys and Sells of the MM were downloaded, then Money > could compute an accurate yield. and that data goes into my register directly. ( Like I said - for the Dividend + buy, I change to Reinvest div just to not have 2 entries per month ). AND - I'm the only you here that this happens to ? ( that's really the part that I don't understand) OK: I'll go back to just ignoring it. Thanks Cal. - quote - > > ( I still didn't get $13,747 in interest ! In fact, if I just view > > "Portfolio Mgr - "gain" column it shows ~$7000 total , not $13,700 - where > > Is it getting this stuff ?) > > > If I open Portfolio Manager page and look at YTD return > > - it's 1.5% so far, 3 % annual - that's more like it for a money market. > > > FYI: This isn't a big deal - I just uncheck for REAL reports, > > but can't figure WHY it's messed up. > So you have accurately stated the problem. Your better choices are > to go with what is downloaded and ignore the huge percentage gains > on the MM, or to delete/void the Dividend and enter a Deposit in the > Cash Transactions register. > Now if the (possibly daily) Buys and Sells of the MM were entered in > addition to the ReinvestDividends, then Money could compute the > yield (tho the number of decimal places is too small to display gain > percent for a month in a MM). That would be way too much work when > it is not automated into the download process. |
|
#4
| |||
| |||
| In microsoft.public.money, - Bobb - wrote: - quote - > UPDATE:
No, not by just changing the transaction type in the Investment> I ran Cap Gains report - YTD and > right-click on the report, then > "Customize -Investments" > Then > "Select Investment Type" > I selected 'Money Market' > It shows 3 funds including the"bad one". > Then I chose just my > Fidelity Select Money Market. > In that report it shows > Cost - Sale price - Gain > Cost = 15050.35 > Sales = 15050.35 > So far so good ... > Gain = 13747.19 ! > Whaaaat ???? > SO Money "SEES" that fund AS a > Money Market fund - Yet shows a GAIN ?? > Of 91.3% WOW ! > All buy dates in the report are the same date ( I bought a chunk then so > probably right) and I bought that lot at $1 per share and sold for $1 per > share. > My register shows REINVESTED DIVIDEND for each month's interest in that > fund. > Fidelity downloads/sends statements as dividend/buy - I change to reinvest > dividend to eliminate one transaction. > Should I change that to INTEREST rather than DIVIDEND ? Transactions register. Because the Interest transaction would still be computed as gain for that MM. If you wanted to avoid having the outlandish gain transactions, and you were willing to do the extra work, you could Void the Dividend in the Investment Transactions register and enter a Deposit into the Cash Transactions register. You could use a Payee related to the MM so you could still generate a report. - quote - > Does dividend mess with cost basis/report and interest doesn't ?
Yes. With the Fido method of letting the cash balance represent the(cash+MM) total, the MM holdings appear to be zero. Yet the holding still get somehow gets dividends. The gain on your past holdings comes out to these fantastic numbers. Now if the Buys and Sells of the MM were downloaded, then Money could compute an accurate yield. - quote - > ( I still didn't get $13,747 in interest ! In fact, if I just view
So you have accurately stated the problem. Your better choices are> "Portfolio Mgr - "gain" column it shows ~$7000 total , not $13,700 - where > Is it getting this stuff ?) > If I open Portfolio Manager page and look at YTD return > - it's 1.5% so far, 3 % annual - that's more like it for a money market. > FYI: This isn't a big deal - I just uncheck for REAL reports, > but can't figure WHY it's messed up. to go with what is downloaded and ignore the huge percentage gains on the MM, or to delete/void the Dividend and enter a Deposit in the Cash Transactions register. Now if the (possibly daily) Buys and Sells of the MM were entered in addition to the ReinvestDividends, then Money could compute the yield (tho the number of decimal places is too small to display gain percent for a month in a MM). That would be way too much work when it is not automated into the download process. |
|
#3
| |||
| |||
| Sorry, I forgot to post this, new comments at end : "Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in message news:lpi0741t1o282voqgh5no504cbad5q9otr[at]4ax.com... - quote - > In microsoft.public.money, - Bobb - wrote: > > comments inline - thanks > > > "Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in message > > news:rorv645t3746r7gan9lg1ci0ppl2cedjnb[at]4ax.com... > > > In microsoft.public.money, - Bobb - wrote: > <snip> > > You probably have your "Fidelity Select Money Market" set up as a > > > Mutual Fund rather than a Money Market Fund. > > > I do - but *I* didn't choose that. Originally when I set up money I > > connected to my broker and was presented with my positions.They had > > entered the symbol for it and I merely named it. MONEY then called it a > > "Mutual Fund". ( I can't have two CASH accounts in one brokerage account > > ??) I noticed it at setup time ( X years ago) and I've checked on > > newer > > versions - it's still a mutual fund. It IS a money market fund (FSLXX) > > but > > apparently Money could never handle that. > In retrospect, the best way is to define your MMF as an MMF before > you first download. That way there is no problem. In OFX, the > references to MF and MMF are the same. So ideally Money would ask > initially. I am not sure if it does or does not, but if it does I am > confident the default is MF. > See below: > > > > > > Now it would be nice if you could just change it. But you can't > > > change a MF to a MMF directly. > > > > > 1. Easy less good way that does not avoid the schedule D problem: > > > > > a. Remove the symbol from the security as a sure fire way to get > > > Money to never download the price from its quote server. > > > I download register info so want it linked with right symbol so I get > > transfers. Let's say I sell 10,000 of FSLXX to buy Select Energy - > > without > > symbol I don't get that - it's an unmatched transaction. My statement > > shows sale of FSLXX. > > ( BTW I use FSLXX as my main 'holding area for cash' on which I've > > already > > paid sales load --- and it pays more interest than daily money market - > > although probably not much these days). > > > > > > b. Delete all of the non $ 1 prices. Let it stay a mutual fund. > > > I checked price history All prices are $1. > > > > > > The main downside of this is that if you download Buys and Sells, > > > they will get put on your schedule D if you let Money prepare your > > > schedule D with TaxCut or TurboTax. > > > > > 2. Harder better way: > > > > > Make an extra copy/backup in case you want to undo something. > > > > > 2a. Assuming you download transactions from your broker, > > > disassociate the existing mutual fund from your downloads. I have > > > a procedure for doing that below using Money 2007 or later. > > > Currently using M2006, but I'll check options. > > > > It may look complex, but it is a > > > lot easier than it is for earlier versions. > > > Please make notes of any discrepancies in the procedures > > > I am describing. I have not tested this live. Remember you are > > > prepared to restore a backup if you don't like the results. > > > > > 2b. Pre-create a Money Market Fund called RealMMF or whatever is > > > appropriate. One way is with > > > Portfolio-> WorkWithInvestments-> SetUpANewInvestment. Leave the > > > symbol blank. > > > > > 2c.Download from your broker. Expect Money to say it found a new > > > investment -- your Money Market. I think Money will let you choose > > > the type at, but if you want to be sure, you could pre-create a > > > Money Market Fund called RealMMF or whatever is appropriate. Tell > > > Money that this investment that it just found is the same as > > > RealMMF. Expect Money to say that the statement says you currently > > > have Y shares of RealMMF, but your statement says you have X (maybe > > > zero if there was no activity). Let Money create the AddShares to > > > bring the balance to the right amount. I would then modify that to > > > a Buy in the register(s), and I would modify the Memo. > > > > > I believe that's how I set them up originally. > > I connected to broker - it found funds > > I assigned names to the symbols. > > It was then that I realized that Select Money Mkt is not listed as money > > fund - just a mutual fund. > > > > > 2d. Now you need to zero out your holding of HistoricMF. I would > > > create a Sell of the same number of shares that you have the Buy of > > > for RealMMF. The pair will have no net effect on your cash > > > balance. Inspect your register to see if any other adjustments are > > > needed. > > > I did that after my bank statements were stolen - to get into new > > account > > numbers > > > > > > > > So what did this do for you? The biggie for me is that the MMF > > > transactions don't get put on the schedule D. Having a bunch of > > > Buy and Sell for the same amount don't affect your taxes, but it's > > > messy. Plus now Money expects the price to stay at $1 (which we > > > hope is a justified expectation.) > > > > > If something is confusing, check back. In any case, let us know > > > how it came out. Also post what is lacking in the procedure. > > > I agree with you the whole way but with NO symbol, Money won't interact > > correctly with fund. WITH symbol, it is a MUTUAL fund not a Money > > Market. > ===================== UPDATE: I ran Cap Gains report - YTD and right-click on the report, then "Customize -Investments" Then "Select Investment Type" I selected 'Money Market' It shows 3 funds including the"bad one". Then I chose just my Fidelity Select Money Market. In that report it shows Cost - Sale price - Gain Cost = 15050.35 Sales = 15050.35 So far so good ... Gain = 13747.19 ! Whaaaat ???? SO Money "SEES" that fund AS a Money Market fund - Yet shows a GAIN ?? Of 91.3% WOW ! All buy dates in the report are the same date ( I bought a chunk then so probably right) and I bought that lot at $1 per share and sold for $1 per share. My register shows REINVESTED DIVIDEND for each month's interest in that fund. Fidelity downloads/sends statements as dividend/buy - I change to reinvest dividend to eliminate one transaction. Should I change that to INTEREST rather than DIVIDEND ? Does dividend mess with cost basis/report and interest doesn't ? ( I still didn't get $13,747 in interest ! In fact, if I just view "Portfolio Mgr - "gain" column it shows ~$7000 total , not $13,700 - where Is it getting this stuff ?) If I open Portfolio Manager page and look at YTD return - it's 1.5% so far, 3 % annual - that's more like it for a money market. FYI: This isn't a big deal - I just uncheck for REAL reports, but can't figure WHY it's messed up. Thanks for any ideas/guesses on this one. Bobb ========== since Money saw as MMkt fund I skipped this: <snipped..... Cal's procedure to reclassify fund. |
|
#2
| |||
| |||
| In microsoft.public.money, - Bobb - wrote: - quote - > comments inline - thanks
In retrospect, the best way is to define your MMF as an MMF before> "Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in message > news:rorv645t3746r7gan9lg1ci0ppl2cedjnb[at]4ax.com... > > In microsoft.public.money, - Bobb - wrote: <snip> > You probably have your "Fidelity Select Money Market" set up as a > > Mutual Fund rather than a Money Market Fund. > I do - but *I* didn't choose that. Originally when I set up money I > connected to my broker and was presented with my positions.They had > entered the symbol for it and I merely named it. MONEY then called it a > "Mutual Fund". ( I can't have two CASH accounts in one brokerage account > ??) I noticed it at setup time ( X years ago) and I've checked on newer > versions - it's still a mutual fund. It IS a money market fund (FSLXX) but > apparently Money could never handle that. you first download. That way there is no problem. In OFX, the references to MF and MMF are the same. So ideally Money would ask initially. I am not sure if it does or does not, but if it does I am confident the default is MF. See below: - quote - > > > Now it would be nice if you could just change it. But you can't
I am pretty sure it is not. There is a way that will do that will do> > change a MF to a MMF directly. > > > 1. Easy less good way that does not avoid the schedule D problem: > > > a. Remove the symbol from the security as a sure fire way to get > > Money to never download the price from its quote server. > I download register info so want it linked with right symbol so I get > transfers. Let's say I sell 10,000 of FSLXX to buy Select Energy - without > symbol I don't get that - it's an unmatched transaction. My statement > shows sale of FSLXX. > ( BTW I use FSLXX as my main 'holding area for cash' on which I've already > paid sales load --- and it pays more interest than daily money market - > although probably not much these days). > > > b. Delete all of the non $ 1 prices. Let it stay a mutual fund. > I checked price history All prices are $1. > > > The main downside of this is that if you download Buys and Sells, > > they will get put on your schedule D if you let Money prepare your > > schedule D with TaxCut or TurboTax. > > > 2. Harder better way: > > > Make an extra copy/backup in case you want to undo something. > > > 2a. Assuming you download transactions from your broker, > > disassociate the existing mutual fund from your downloads. I have > > a procedure for doing that below using Money 2007 or later. > Currently using M2006, but I'll check options. > > It may look complex, but it is a > > lot easier than it is for earlier versions. > > Please make notes of any discrepancies in the procedures > > I am describing. I have not tested this live. Remember you are > > prepared to restore a backup if you don't like the results. > > > 2b. Pre-create a Money Market Fund called RealMMF or whatever is > > appropriate. One way is with > > Portfolio-> WorkWithInvestments-> SetUpANewInvestment. Leave the > > symbol blank. > > > 2c.Download from your broker. Expect Money to say it found a new > > investment -- your Money Market. I think Money will let you choose > > the type at, but if you want to be sure, you could pre-create a > > Money Market Fund called RealMMF or whatever is appropriate. Tell > > Money that this investment that it just found is the same as > > RealMMF. Expect Money to say that the statement says you currently > > have Y shares of RealMMF, but your statement says you have X (maybe > > zero if there was no activity). Let Money create the AddShares to > > bring the balance to the right amount. I would then modify that to > > a Buy in the register(s), and I would modify the Memo. > > I believe that's how I set them up originally. > I connected to broker - it found funds > I assigned names to the symbols. > It was then that I realized that Select Money Mkt is not listed as money > fund - just a mutual fund. > > 2d. Now you need to zero out your holding of HistoricMF. I would > > create a Sell of the same number of shares that you have the Buy of > > for RealMMF. The pair will have no net effect on your cash > > balance. Inspect your register to see if any other adjustments are > > needed. > I did that after my bank statements were stolen - to get into new account > numbers > > > > So what did this do for you? The biggie for me is that the MMF > > transactions don't get put on the schedule D. Having a bunch of > > Buy and Sell for the same amount don't affect your taxes, but it's > > messy. Plus now Money expects the price to stay at $1 (which we > > hope is a justified expectation.) > > > If something is confusing, check back. In any case, let us know > > how it came out. Also post what is lacking in the procedure. > > > I agree with you the whole way but with NO symbol, Money won't interact > correctly with fund. WITH symbol, it is a MUTUAL fund not a Money Market. > > ================================================== === > I'll see if this is an option for me - thanks that disassociation for you with Money 2006: Disassociate Mutual Fund The purpose of this procedure is disassociate a security from the download process. The problem this cures is that Money associates downloaded fund by CUSIP. Renaming and/or changing the symbol is not sufficient to appear as a different security. Create dis_mf.ofx by cutting and pasting the portions between the Begin and End lines (below) into a file named dis_mf.ofx. I suggest making an extra copy of your Money file as a precaution. File-> Import dis_mf.ofx Select the appropriate Account from the list. Select the institution as the actual institution that holds the account. You should get the "You have n statements to read" screen. The account you just imported into should show the name account name followed by (1). Click that name. You should get the pop-up that says "Money found the following investment in your brokerage statement:". Select "This investment is already in my investment portfolio with a different name. I use the following investment in my investment portfolio to track this investment:". From the drop-down list, choose the mutual fund you are trying to get rid of. Click Next. When you get the "Are you sure xxxxx is the same investment as yyyy?", click Yes. If you get the screen that says "Do you want to change the ticker symbol for xxxx in Money from yyyy to zzzz to match the statement, I suggest you click Yes. Get the screen that says "The positions reported on nn/nn/nn statement don't match those in you Money account. Do you want to update your account to match the statement?". I would select No, but it is up to you. Click Finish. Now download from your broker for real. Feel free to suggest improvements to this procedure. ========================Begin dis_mf.ofx======================== OFXHEADER:100 DATA:OFXSGML VERSION:102 SECURITY:NONE ENCODING:USASCII CHARSET:1252 COMPRESSION:NONE OLDFILEUID:NONE NEWFILEUID:NONE <OFX<SIGNONMSGSRSV1 <SONRS<STATUS<CODE> 0 <SEVERITY> INFO <MESSAGE> SUCCESS </STATUS<DTSERVER> 20040302 <LANGUAGE> ENG <DTPROFUP> 20030403 <DTACCTUP> 20040201 </SONRS> </SIGNONMSGSRSV1<INVSTMTMSGSRSV1 <INVSTMTTRNRS<TRNUID> Zzzz1 <STATUS<CODE> 0 <SEVERITY> INFO <MESSAGE> Success so far with MF displacement </STATUS <INVSTMTRS<DTASOF> 20040302 <CURDEF> USD <INVACCTFROM<BROKERID> YourBrokerOrZzzz2 <ACCTID> YourAccountOrZzzz3 </INVACCTFROM<INVPOSLIST <POSMF<INVPOS<SECID<UNIQUEID> Zzzz4 <UNIQUEIDTYPE> CUSIP </SECID<HELDINACCT> CASH <POSTYPE> LONG <UNITS> 0.01 <UNITPRICE> 01.00 <MKTVAL> 0.010 <DTPRICEASOF> 20040302 </INVPOS</POSMF</INVPOSLIST </INVSTMTRS</INVSTMTTRNRS</INVSTMTMSGSRSV1 <SECLISTMSGSRSV1<SECLIST <MFINFO<SECINFO<SECID<UNIQUEID> Zzzz4 <UNIQUEIDTYPE> CUSIP </SECID<SECNAME> Zzzz5 <TICKER> Zzzz6 </SECINFO</MFINFO </SECLIST</SECLISTMSGSRSV1</OFX =========================END dis_mf.ofx ======================== |
|
#1
| |||
| |||
| In microsoft.public.money, - Bobb - wrote: - quote - > I just ran a cap gains report for 2008 to date ( to make sure no LT sales
You probably have your "Fidelity Select Money Market" set up as a> yet ). LT cap gain report for 2008 only shows my "Fidelity Select Money > Market" which isn't really a sale. I've moved money out 12 times so > shows 12 sales. > Sales Proceeds = Purchase Cost as I expect , BUT > GAIN/Loss column shows $13,707 gain . > Anyone been here/done that ? > A few years ago I closed/transferred one account into this account ( my > bank statements were stolen from mailbox so I closed accounts) and maybe > it considers that original money - zero cost ?? So as I sell it's a gain ? > If so, how to fix cost on a money market ? Mutual Fund rather than a Money Market Fund. Now it would be nice if you could just change it. But you can't change a MF to a MMF directly. 1. Easy less good way that does not avoid the schedule D problem: a. Remove the symbol from the security as a sure fire way to get Money to never download the price from its quote server. b. Delete all of the non $ 1 prices. Let it stay a mutual fund. The main downside of this is that if you download Buys and Sells, they will get put on your schedule D if you let Money prepare your schedule D with TaxCut or TurboTax. 2. Harder better way: Make an extra copy/backup in case you want to undo something. 2a. Assuming you download transactions from your broker, disassociate the existing mutual fund from your downloads. I have a procedure for doing that below using Money 2007 or later. It may look complex, but it is a lot easier than it is for earlier versions. Please make notes of any discrepancies in the procedures I am describing. I have not tested this live. Remember you are prepared to restore a backup if you don't like the results. 2b. Pre-create a Money Market Fund called RealMMF or whatever is appropriate. One way is with Portfolio-> WorkWithInvestments-> SetUpANewInvestment. Leave the symbol blank. 2c.Download from your broker. Expect Money to say it found a new investment -- your Money Market. I think Money will let you choose the type at, but if you want to be sure, you could pre-create a Money Market Fund called RealMMF or whatever is appropriate. Tell Money that this investment that it just found is the same as RealMMF. Expect Money to say that the statement says you currently have Y shares of RealMMF, but your statement says you have X (maybe zero if there was no activity). Let Money create the AddShares to bring the balance to the right amount. I would then modify that to a Buy in the register(s), and I would modify the Memo. 2d. Now you need to zero out your holding of HistoricMF. I would create a Sell of the same number of shares that you have the Buy of for RealMMF. The pair will have no net effect on your cash balance. Inspect your register to see if any other adjustments are needed. So what did this do for you? The biggie for me is that the MMF transactions don't get put on the schedule D. Having a bunch of Buy and Sell for the same amount don't affect your taxes, but it's messy. Plus now Money expects the price to stay at $1 (which we hope is a justified expectation.) If something is confusing, check back. In any case, let us know how it came out. Also post what is lacking in the procedure. ================================================== === How to disassociate Mutual Fund from downloads using CombineWith in Money 2007 or Money Plus: 1. Create a new mutual fund called "HistoricMF" or some such. This will be the name that your existing transactions will show up as. 2. Pretend that your present MMF name is "ExistingMF" Then go to the Details of ExistingMF and blank out the symbol. Then choose CombineWith (upper right) to combine with HistoricMF. All of your earlier transactions would now show up as HistoricMF transactions, as would new downloads if you stopped now. 3. But you want Money to ask about ExistingMF the next time it downloads. So you will next go to the settings for HistoricMF and click ManageCombinedInvestments (lower). Tick the box for ExistingMF and click Remove. Accept the warning. At this point, there are no transactions for ExistingMF and Money would ask about it upon next download. As far as I know, ExistingMF is gone. ================================================== === |
| | |||
| |||
| comments inline - thanks "Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in message news:rorv645t3746r7gan9lg1ci0ppl2cedjnb[at]4ax.com... - quote - > In microsoft.public.money, - Bobb - wrote:
I do - but *I* didn't choose that. Originally when I set up money I> > I just ran a cap gains report for 2008 to date ( to make sure no LT > > sales > > yet ). LT cap gain report for 2008 only shows my "Fidelity Select Money > > Market" which isn't really a sale. I've moved money out 12 times so > > shows 12 sales. > > Sales Proceeds = Purchase Cost as I expect , BUT > > GAIN/Loss column shows $13,707 gain . > > Anyone been here/done that ? > > > A few years ago I closed/transferred one account into this account ( my > > bank statements were stolen from mailbox so I closed accounts) and maybe > > it considers that original money - zero cost ?? So as I sell it's a gain > > ? > > If so, how to fix cost on a money market ? > You probably have your "Fidelity Select Money Market" set up as a > Mutual Fund rather than a Money Market Fund. connected to my broker and was presented with my positions.They had entered the symbol for it and I merely named it. MONEY then called it a "Mutual Fund". ( I can't have two CASH accounts in one brokerage account ??) I noticed it at setup time ( X years ago) and I've checked on newer versions - it's still a mutual fund. It IS a money market fund (FSLXX) but apparently Money could never handle that. - quote - > Now it would be nice if you could just change it. But you can't
I download register info so want it linked with right symbol so I get> change a MF to a MMF directly. > 1. Easy less good way that does not avoid the schedule D problem: > a. Remove the symbol from the security as a sure fire way to get > Money to never download the price from its quote server. transfers. Let's say I sell 10,000 of FSLXX to buy Select Energy - without symbol I don't get that - it's an unmatched transaction. My statement shows sale of FSLXX. ( BTW I use FSLXX as my main 'holding area for cash' on which I've already paid sales load --- and it pays more interest than daily money market - although probably not much these days). - quote - > b. Delete all of the non $ 1 prices. Let it stay a mutual fund.
I checked price history All prices are $1.- quote - > The main downside of this is that if you download Buys and Sells,
Currently using M2006, but I'll check options.> they will get put on your schedule D if you let Money prepare your > schedule D with TaxCut or TurboTax. > 2. Harder better way: > Make an extra copy/backup in case you want to undo something. > 2a. Assuming you download transactions from your broker, > disassociate the existing mutual fund from your downloads. I have > a procedure for doing that below using Money 2007 or later. - quote - > It may look complex, but it is a
I believe that's how I set them up originally.> lot easier than it is for earlier versions. > Please make notes of any discrepancies in the procedures > I am describing. I have not tested this live. Remember you are > prepared to restore a backup if you don't like the results. > 2b. Pre-create a Money Market Fund called RealMMF or whatever is > appropriate. One way is with > Portfolio-> WorkWithInvestments-> SetUpANewInvestment. Leave the > symbol blank. > 2c.Download from your broker. Expect Money to say it found a new > investment -- your Money Market. I think Money will let you choose > the type at, but if you want to be sure, you could pre-create a > Money Market Fund called RealMMF or whatever is appropriate. Tell > Money that this investment that it just found is the same as > RealMMF. Expect Money to say that the statement says you currently > have Y shares of RealMMF, but your statement says you have X (maybe > zero if there was no activity). Let Money create the AddShares to > bring the balance to the right amount. I would then modify that to > a Buy in the register(s), and I would modify the Memo. I connected to broker - it found funds I assigned names to the symbols. It was then that I realized that Select Money Mkt is not listed as money fund - just a mutual fund. - quote - > 2d. Now you need to zero out your holding of HistoricMF. I would
I did that after my bank statements were stolen - to get into new account> create a Sell of the same number of shares that you have the Buy of > for RealMMF. The pair will have no net effect on your cash > balance. Inspect your register to see if any other adjustments are > needed. numbers - quote - > So what did this do for you? The biggie for me is that the MMF
I agree with you the whole way but with NO symbol, Money won't interact> transactions don't get put on the schedule D. Having a bunch of > Buy and Sell for the same amount don't affect your taxes, but it's > messy. Plus now Money expects the price to stay at $1 (which we > hope is a justified expectation.) > If something is confusing, check back. In any case, let us know > how it came out. Also post what is lacking in the procedure. correctly with fund. WITH symbol, it is a MUTUAL fund not a Money Market. - quote - > ================================================== ===
I'll see if this is an option for me - thanks- quote - > How to disassociate Mutual Fund from downloads using CombineWith in > Money 2007 or Money Plus: > 1. Create a new mutual fund called "HistoricMF" or some such. > This will be the name that your existing transactions will show up > as. > 2. Pretend that your present MMF name is "ExistingMF" Then go to > the Details of ExistingMF and blank out the symbol. Then choose > CombineWith (upper right) to combine with HistoricMF. All of your > earlier transactions would now show up as HistoricMF transactions, > as would new downloads if you stopped now. > 3. But you want Money to ask about ExistingMF the next time it > downloads. So you will next go to the settings for HistoricMF and > click ManageCombinedInvestments (lower). Tick the box for > ExistingMF and click Remove. Accept the warning. At this point, > there are no transactions for ExistingMF and Money would ask about > it upon next download. As far as I know, ExistingMF is gone. > ================================================== === |
|
#-1
| |||
| |||
| I just ran a cap gains report for 2008 to date ( to make sure no LT sales yet ). LT cap gain report for 2008 only shows my "Fidelity Select Money Market" which isn't really a sale. I've moved money out 12 times so shows 12 sales. Sales Proceeds = Purchase Cost as I expect , BUT GAIN/Loss column shows $13,707 gain . Anyone been here/done that ? A few years ago I closed/transferred one account into this account ( my bank statements were stolen from mailbox so I closed accounts) and maybe it considers that original money - zero cost ?? So as I sell it's a gain ? If so, how to fix cost on a money market ? |
| Tags |
| basis, cost, market, money |
Similar Threads | ||||
| Thread | Forum | Replies | Last Post | |
| Re: Can't alter Cost Basis of investment in Microsoft Money 14.0.120.1 Cal Learner-- MVP: In microsoft.public.money, Alan Blandford wrote: >I have an investment in my Portfolio for which I paid £500. I understand >that this purchase... | Microsoft Money | 3 | 01-05-2007 08:09 PM | |
| cost basis/avg cost per share David: I've got 2 accounts (mutual funds) set up under a single financial institution. In Portfolio, using Valuations view, Money calculates the cost... | Microsoft Money | 2 | 03-03-2004 11:00 AM | |
| cost basis/avg cost per share David: I've got 2 accounts (mutual funds) set up under a single financial institution. In Portfolio, using Valuations view, Money calculates the cost... | Microsoft Money | 1 | 03-01-2004 11:26 AM | |
| Cost basis Money 2003 Grant Niccol: I want to not only record the cost value of shares and bonds in the "Portfolio" view of Money 2003 (which I am doing successfully), I also want the... | Microsoft Money | 1 | 10-13-2003 12:45 AM | |
| Thread Tools | |
| Display Modes | |
| |