Re: Cash and Money Market Woes

[ Message Board ] [ Archives ] [ Search ]

Posted by Mark on August 29, 2006 at 10:05:55:

In Reply to: Re: Cash and Money Market Woes posted by Steve on August 29, 2006 at 00:52:40:

: Sorry for the delayed attempt to follow your instructions.

: As you advise, the entries for the default cash account do appear to be double-accounted in the money market OFX entries (e.g. my manually entered "Sell Cash Account -20,659.99" is noted on the same date as the OFX-entered "Sell ZZZ00 -20,659.99").

: Unfortunately, however, not all of these double-entries carry the same dates. So, this issue is still causing a lot of unresolved problems for me. Here is the quandary:

: Without creating a cash account in July 2004 with a manually entered initial deposit that same month, the transaction log with retrived OFX data is wildly inaccurate because money market data is not retrievable until September 2004. Perhaps as a consequence of there being both a manually entered cash account and an OFX defined money market account, a negative balance is displayed at the end of Spetember 2004 portfolio activity in the money market account. However, if I download the OFX money market data, with the manual cash account input kept in place, there is a surplus balance. Do you see the problem? It is not obvious when, in the transaction log, the default cash account status should be changed away from the manually entered account (to acknowledge the cash deposit) and towards the OFX-recorded money market account, and I am still unclear how to make the alteration.

Hi Steve,

I didn't exactly follow all of this. A phone call might be more efficient for us to resolve this one...

How about not having a manually created cash account at all? Do the OFX retrieve, and then afterwards add a purchase for your cash balance as of July 2004, since you aren't getting these transactions until September?

You can create the money market investment that is downloaded by OFX ahead of time, or you can do the 2-retrieve trick we discussed previously. The important thing to enter is the CUSIP, so that OFX downloaded transaction go into the correct investment.

Thanks,
Mark
--
Fund Manager - Portfolio Management Software

Replies:

• Re: Cash and Money Market Woes Steve 14:35:42 08/29/06 (1)
  • Re: Cash and Money Market Woes Mark 14:46:58 08/29/06 (0)