Re: Reconcile & cash account

[ Message Board ] [ Archives ] [ Search ]

Posted by Tom on January 10, 2007 at 09:04:10:

In Reply to: Re: Reconcile & cash account posted by Mark on January 09, 2007 at 11:23:03:

: : I have been using the reconcile wizard and like it - after I learned how to handle a few quirks for various online statements. However I have a problem with the settlement MMF (FDRXX) in 2 Fidelity accounts. During the reconcile process FM displays the value of FDRXX as in the FM subportfolio but nothing under the retrieved statement. All other investments are listed.

: : I tried to study the OFX files (ofxretr and ofxdump). The needed data is contained in the file, though maybe not under the right XML labels. FDRXX is listed like other securities under SECLISTMSGRSV1 ...SECLIST...MFINFO. The correct value is listed under the tag INVBAL. There is no entry under INVPOSLIST...POSMF...SECID

: : I can of course check the cash accounts manually, but then the reconciliation is not recorded in FM as having been done successfully.

: : I do not have the problem above with Vanguard or Merrill Lynch accounts.

: : Thanks for any ideas.

: : Tom

: Hi Tom,

: In the other thread below Mark_M had sent me one of his log files from Fidelity. It appears Fidelity is not listing FDRXX as a position, like all the other securities. Instead, they put it under "Available Cash", not specifically saying which investment this belongs to. This is unfortunate, as this will result in the issue you're experiencing. I believe the correct fix is for Fidelity to report this position, along with all the other ones. You might want to call up Fidelity and voice your opinion.

: Thanks,
: Mark

Hi Mark,

I can see your point. I found a document that discusses how Microsoft Money interprets OFX - download.microsoft.com/download/a/3/d/a3da081d-333e-4c5b-8029-815a932e5b19/OFX_Message_Support.doc

In the document it says that "Money only has one associated cash account per investment account." p69 section 13.9.2.7 See also the discussion of INVBAL and INVPOSLIST. Even after all that, it is not crystal clear to me whether Money expects an entry in INVPOSLIST for the cash account or not. I can only assume it does not - otherwise all Money users would complain given the popularity of Fidelity accounts. But how does it associate the cash balance with the entry in SECLIST?

I see that Fidelity sends OFX version 2 format. I did not have enough energy to dig into the OFX XML Schema or other definitions.

I don't hold much hope of reaching someone at Fidelity who is knowledgable at this level.

Thanks,

Tom

Replies:

• Re: Reconcile & cash account Mark 09:56:50 01/10/07 (0)