Error reconciling

[paulk]

In attempting to reconcile client accounts I am running up against a problem relating to the cash accounts. In fund manager I have the ticker for the default cash account as "cash1". TD ameritrade's POS files have it listed as "cash". My total amount reconciles however I can't mark the items as reconciled since the tickers are different. Will there be any ramifications in FM to simply changing the ticker to "cash"?

Thanks.
Paul Kutz

[Mark]

Hi Paul,

That should be perfectly fine to do.

[paulk]

Thanks Mark. That worked for those particular investments. I'm also having issues with CDs. Specifically I set those up (per the FM forum) as cash type investments with a fixed $1 price and unchecked the "retrieve price" option. When manually entering transactions this worked fine. Unfortunately it seems that TD Ameritade lists cds on a per $100 basis (similar to bonds I think). Therefore a $20,000 cd in FM becomes 200 per TD's POS file. Also FM seems to be updating the prices of my cds (based on 100 of course) so the above $20,000 cd becomes a 2,000,000 cd forcing me to go through client accounts to delete the price history manually.

Is there any way to bypass unmatched items in the reconciliation operation and still mark the account as reconciled? I see there is an option to "ignore while reconciling" but that seems to only apply to the item in FM and not the dowloaded position from TD.

Any help you can give me will be greatly appreciated. Like I said once I'm through this once it will be a piece of cake for me (and a lot less support from you ).

Thanks.
Paul

[Mark]

Hi Paul,

Since you are getting data from TD Ameritrade, I would record your CDs like they are reporting them. Keep the price at $100, and the shares at 1/100th the value. (Just like bonds).

You can bypass the reconciliation, but it would be better to not. Otherwise you won't be reconciling your CD balances. If you choose to do this though, just mark the CD as "Ignore while reconciling". As long as it matches the investment in TD's position file, it will consider it skipped, which allows you to complete the reconciliation.

No problem asking questions, that is perfectly fine.