Re: Cash Account / Retrival / Balance/FM 8.2

[ Message Board ] [ Archives ] [ Search ]

Posted by Mark on January 01, 2007 at 20:34:01:

In Reply to: Cash Account / Retrival / Balance/FM 8.2 posted by Glenn Hall on December 31, 2006 at 11:36:57:

: Personal Version 8.2 / Quote Module 373 / Transaction Module 117

: I am having a problem with setting up portfolios/retrieving transactions from Ameritrade (Legacy) that involve the cash movements related to buy/sell/dividend posting.

: A Portfolio Value Report along with Reconciliation Report shows that there is a large balance error. As I look at the Data Register for the ZZZ00 account that was imported I find a lot of entries that have a Price value of “0” which results in a Total of “0”.

: I have changed the properties of the ZZZ00 account to Cash and then re-imported the account, which resulted in no changes. I am missing an important element that is required to make this work properly. The problem appears to be associated with a Purchase and Memo “MONEY MARKET MOVEMENT”.

: Date Price Shares Total Fee Type Memo
: 09/13/06 0.00 15.39 0.00 0.00 Purchase MONEY MARKET MOVE

: I do not have a account set up in the portfolio for MONEY MARKET MOVEMENT.

Hi Glenn,

Do you know what this ZZZ00 account is? Sometimes brokers have a special "sweep" account, that temporarily gets money, and then later the balance gets swept into the money market. It sounds like that is what this investment may be. If this is a sweep account, I would suggest not tracking it. Just track your investments that you own shares in, and your cash (money market) investment. If the retrieve shows transactions in a sweep account, just un-check them during the retrieve, so they aren't updated. To make sure all the money goes into your cash account, just make sure you have the option "Automatically record corresponding entry in default cash account" checked at the bottom of the transaction preview screen during a retrieve.

Thanks,
Mark
--
Fund Manager - Portfolio Management Software

Replies: