Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #6  
Old 07-27-2006, 09:30 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Money 2007 CombineWith Operation for Investments (Fidelity NetBenefits inspired)

In microsoft.public.money, Tom B. wrote:

- quote -

> Yes, your assumption is correct. Only dividend xations are shown.
> I would be happy to try the special OFX file. Can you post it here?




Disassociate Mutual Fund or Money Market 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
OLDFILEUID:NONE
NEWFILEUID:NONE
CHARSET:1252
VERSION:102
COMPRESSION:NONE
ENCODING:USASCII
SECURITY: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 ========================

  #5  
Old 07-27-2006, 09:21 PM
Tom B.
Guest
 
Posts: n/a
Default Re: Money 2007 CombineWith Operation for Investments (Fidelity NetBenefitsinspired)

Cal Learner-- MVP wrote:
- quote -

> In microsoft.public.money, Tom B. wrote:
> > Cal Learner-- MVP wrote:
> > > In microsoft.public.money, Tom B. wrote:

> <snip> > > I note they send out Dividend transactions instead of
> > > ReinvestDividend transactions for the sweep fund. You would think
> > > that it would be something that a company as big as Fidelity
> > > Investments could get right.

> > My sweep account is FDRXX and the most recent dividend created the FDRXX
> > entry in the account summary. What's odd is that the Quantity and Costs
> > Basis of FDRXX are blank. The FDRXX only has the gain enumerated.
> > Furthermore, the Account Summary Cash$ agrees with the Cash Transaction
> > register. So I am starting to think it might be good enough for me. Is
> > anyone else seeing the same thing?

> So I infer that the only transactions that you see for FDRXX are
> dividend transactions.


> I can
> post such an OFX file.

Cal, Yes, your assumption is correct. Only dividend xations are shown.
I would be happy to try the special OFX file. Can you post it here?
Otherwise, send to tbloomq at comcast dot net

Thanks, Tom
  #4  
Old 07-27-2006, 07:38 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Money 2007 CombineWith Operation for Investments (Fidelity NetBenefits inspired)

In microsoft.public.money, Tom B. wrote:

- quote -

> Cal Learner-- MVP wrote:
> > In microsoft.public.money, Tom B. wrote:

<snip> > I note they send out Dividend transactions instead of
> > ReinvestDividend transactions for the sweep fund. You would think
> > that it would be something that a company as big as Fidelity
> > Investments could get right.

> My sweep account is FDRXX and the most recent dividend created the FDRXX
> entry in the account summary. What's odd is that the Quantity and Costs
> Basis of FDRXX are blank. The FDRXX only has the gain enumerated.
> Furthermore, the Account Summary Cash$ agrees with the Cash Transaction
> register. So I am starting to think it might be good enough for me. Is
> anyone else seeing the same thing?




So I infer that the only transactions that you see for FDRXX are
dividend transactions.

Here is the workaround I am thinking of:

Keep an extra copy/backup of your Money file, in case you want to
undo something. This is experimental and untested.

A. Change FDRXX from a Money Market Fund to a Mutual fund. This is
because a MMF has a fixed $1 share price.
1. Rename FIDELITY CASH RESERVES to "Old FDRXX" or some such
2. Remove the symbol for "Old FDRXX"
3. Disassociate the hidden CUSIP for the "Old FDRXX" MMF from the
real CUSIP by File-> Import of a specially prepared OFX file, and
saying that the new security in it is the same as "Old FDRXX". I can
post such an OFX file.

B.. Create a new mutual fund called "FDRXX Workaround" or some
such.

C. Give that mutual fund a symbol of XFDRXX or some other bogus
symbol. A blank symbol might work, but I would use the bogus symbol
for now.

D. Import from Fidelity. When Money says it found a new investment
called FIDELITY CASH RESERVES, tell Money that the investment is
already in your account as "FDRXX Workaround". If it asks if it
should use the symbol FDRXX for that investment, say that you want
to stick with the existing symbol.

E. Enter a price of $0 for "FDRXX Workaround". If that price somehow
gets overridden, we will try to deal with that.

F. Deal with any existing "Old FDRXX" balance with a compensating
RemoveShares transaction. This should bring that balance to 0, if it
is not already 0.

If things work as envisioned, only dividends will come for "FDRXX
Workaround". The Cash Transaction cash balance will represent your
cash swept funds. If Money wants to update your balance for "FDRXX
Workaround" you could say "Do not update...". The big mystery is,
what if you let Money update your "FDRXX Workaround" position. Will
that change the $0 price? I hope not.

OK. The non-ugly way is to enter the Buys and Sells of FDRXX by
hand, or to let Money generate AddShares/RemoveShares and you change
each to Buy/Sell respectively. This obtuse procedure is intended to
run without attention once you have made it thru the obscure steps.
A less-ugly procedure that lets the Fidelity sweep account work well
with *downloads* would be nice. Does somebody know one?










Disassociate FDRXX
<very tricky procedure to follow
Cause the


  #3  
Old 07-27-2006, 06:50 PM
Tom B.
Guest
 
Posts: n/a
Default Re: Money 2007 CombineWith Operation for Investments (Fidelity NetBenefitsinspired)

Cal Learner-- MVP wrote:
- quote -

> In microsoft.public.money, Tom B. wrote:

> I doubt it, but I am not sure. By "cash" I think you mean the
> balance in the Cash Transactions register.


Yes, I do mean the Cash$ in the register.

- quote -

> Now if there was a transaction for a buy of a fund called "cash" and
> position data on FCASH (or is it FDRXX in your case?), I would
> expect the new [workaround] feature to be the cure.
> I note they send out Dividend transactions instead of
> ReinvestDividend transactions for the sweep fund. You would think
> that it would be something that a company as big as Fidelity
> Investments could get right.


My sweep account is FDRXX and the most recent dividend created the FDRXX
entry in the account summary. What's odd is that the Quantity and Costs
Basis of FDRXX are blank. The FDRXX only has the gain enumerated.
Furthermore, the Account Summary Cash$ agrees with the Cash Transaction
register. So I am starting to think it might be good enough for me. Is
anyone else seeing the same thing?

Thanks, Tom
  #2  
Old 07-27-2006, 06:49 PM
Tom B.
Guest
 
Posts: n/a
Default Re: Money 2007 CombineWith Operation for Investments (Fidelity NetBenefitsinspired)

Cal Learner-- MVP wrote:
- quote -

> In microsoft.public.money, Tom B. wrote:

> I doubt it, but I am not sure. By "cash" I think you mean the
> balance in the Cash Transactions register.


Yes, I do mean the Cash$ in the register.

- quote -

> Now if there was a transaction for a buy of a fund called "cash" and
> position data on FCASH (or is it FDRXX in your case?), I would
> expect the new [workaround] feature to be the cure.
> I note they send out Dividend transactions instead of
> ReinvestDividend transactions for the sweep fund. You would think
> that it would be something that a company as big as Fidelity
> Investments could get right.


My sweep account is FDRXX and the most recent dividend created the FDRXX
entry in the account summary. What's odd is that the Quantity and Costs
Basis of FDRXX are blank. The FDRXX only has the gain enumerated.
Furthermore, the Account Summary Cash$ agrees with the Cash Transaction
register. So I am starting to think it might be good enough for me. Is
anyone else seeing the same thing?

Thanks, Tom
  #1  
Old 07-27-2006, 06:32 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Money 2007 CombineWith Operation for Investments (Fidelity NetBenefits inspired)

In microsoft.public.money, Tom B. wrote:

- quote -

> Has Money 2007 solved the "cash" verses "sweep
> account" issue with Fidelity? Let me elaborate, I've just downloaded
> the trial version of Money 2007. In my brokerage account, I write
> checks, have stocks, and receive dividends -- typical stuff. However, I
> don't want to have both "cash" and "Fidelity Cash Reserves" entries.


I doubt it, but I am not sure. By "cash" I think you mean the
balance in the Cash Transactions register. Unless somebody generates
Buys of something, I expect the cash balance to keep going, and
duplicating swept funds.

Now if there was a transaction for a buy of a fund called "cash" and
position data on FCASH (or is it FDRXX in your case?), I would
expect the new [workaround] feature to be the cure.

I note they send out Dividend transactions instead of
ReinvestDividend transactions for the sweep fund. You would think
that it would be something that a company as big as Fidelity
Investments could get right.

- quote -

> They are one in the same. Can this CombineWith operation help solve
> that? In quicken, I solved it by using the linked account features.
> Seems to work fine but I really like Money's interface better.


Now tell me again. Are you dealing with FCASH, and does any
transaction data get downloaded for the sweep fund in your case? I
am wondering if some kind of workaround could not be developed where
FCASH was aliased with a $0.00 security. Then the balance in the
Cash Transactions register would represent your cash including swept
funds. The FCASH info would be treated as having $0 value, so that
would be ignored in totals within Money. So perhaps there is
something new that could work as a workaround...



 
Old 07-27-2006, 05:48 PM
Tom B.
Guest
 
Posts: n/a
Default Re: Money 2007 CombineWith Operation for Investments (Fidelity NetBenefitsinspired)

Cal Learner-- MVP wrote:
- quote -

> Two new capabilities of Money 2007 are operated from the
> investment details. They are the ability to change the
> InvestmentType, and the CombineWith operation. This will discuss
> the investment CombineWith operation.


Cal and/or others, Has Money 2007 solved the "cash" verses "sweep
account" issue with Fidelity? Let me elaborate, I've just downloaded
the trial version of Money 2007. In my brokerage account, I write
checks, have stocks, and receive dividends -- typical stuff. However, I
don't want to have both "cash" and "Fidelity Cash Reserves" entries.
They are one in the same. Can this CombineWith operation help solve
that? In quicken, I solved it by using the linked account features.
Seems to work fine but I really like Money's interface better.

Please let me know. Thanks, Tom
  #-1  
Old 07-20-2006, 07:18 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Money 2007 CombineWith Operation for Investments (Fidelity NetBenefits inspired)

Two new capabilities of Money 2007 are operated from the
investment details. They are the ability to change the
InvestmentType, and the CombineWith operation. This will discuss
the investment CombineWith operation.

The CombineWith operation was motivated largely by the Fidelity Net
Benefits quirk of having a wrong "CUSIP" ID in their download. So
downloading data from a source with a correct CUSIP and from them
did not allow Money to understand they were the same stock, and
could share the same symbol and quotes.

This feature should be of use in more cases too. The way it works
is that there is a CombineWith button on the Details page. You can
select a security of the SAME Investment Type. When you go to
FundA details and click CombineWith, a list of mutual funds already
defined comes up. A pop-up tells you that all of this investment
will be renamed as the other selected investment. If you combine
with FundB, in the register, All FundA transactions will now appear
as FundB. I suspect that there is a hidden table that will now say
that both CUSIPs will henceforth refer to FundB.

One case where this should be useful is in a fund rename downloaded
from the broker. If the OFX has a RemoveShares of Acme and an
AddShares of AcmeNew, you can work around that endless circle of
saying they are the same shares. Just accept the new one, and then
do a CombineWith. The history an basis data will be intact. At
least, that's what I hope will happen in that case. I have not
tested that.

This feature has a restriction: the combined investments must be of
the same type. This will not allow for the case if that some ETFs,
REITs and MLPs might be called a mutual fund from one broker's
downloads, and as a stock in others. The implementation as it sits
will be very useful, and will handle many of the situations that
stymie people.
 

Tags
2007, combinewith, fidelity, inspired, investments, money, netbenefits, operation
Similar Threads
Thread Forum Replies Last Post
Money 2006: Setting up fidelity netbenefits w/ 401(k) and ESPP acc
Rodney: Hi - I purchased Money2006 last week and set it up with my credit and bank accounts. I added Fidelity Netbenefits - where I have a 401(k) and a ESPP...
Microsoft Money 1 12-29-2005 05:54 AM
Money 2004 - Fidelity NetBenefits acct
Derek: I am trying to setup my 401k account, however Fidelity NetBenefits is not listed as a choice inside the software. However, if I look at the listing...
Microsoft Money 1 04-02-2005 02:49 AM
Fidelity Netbenefits / Money 2004
Jeff M: Has anyone had success with downloading transactions from a Fidelity 401(k) using Netbenefits in Money 2004? I am currently using Money 2005...
Microsoft Money 8 11-02-2004 02:31 AM
Fidelity Netbenefits
Leo: Fidelity Netbenefits is listed for Direct Services on the MS Website, but does not show up on the financial instituion menu in Money 2004. Is there...
Microsoft Money 1 01-20-2004 10:56 PM
Fidelity Investments & NetBenefits - multiple account setup
Hitesh Patel: we have regular joint brokerage account with linked to my netbenefits account. my wife's netbenefits cannot be linked to this brokerage account (do...
Microsoft Money 1 10-18-2003 10:10 PM



Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

All times are GMT. The time now is 04:11 PM.