Reconciling Option Investments

[Homer]

Hi. I am trying to reconcile a Scottrade account that has some put options and some call options in it. Fund Manager imported the purchase of the option fine when I bought them. And all my other regular stocks reconcile just fine. I noticed that when I update prices, it was not updating the options and so I changed the option ticker to match what yahoo has and the price changes fine. But now when I try to reconcile, Fund Manager says I have 100 with the brokerage total 0 and I have a matching entry where the Fund Manager balance is 0 and the brokerage says I have 100.

Why don't they match up. What do I have to do to get it to finish reconcile? Is it related to my changing he ticker in the option properties? What do I do to get it to update both price and reconcile also? Or are they mutually exclusive unless I change the symbol back to Scottrade's version.

Thanks,

Homer

[Mark]

Hi Homer,

The reconcile works off of CUSIP by default, where the price updates work off Symbol. You should make sure your Fund Manager option investment has the CUSIP assigned the same as your broker is reporting. There are a few ways you can find how the broker is reporting the CUSIP:

1) Re-retrieve your account into a new/blank sub-portfolio, and let it create all the investments for you. Look at the CUSIP for the option, and record the same CUSIP in your real sub-portfolio for that option investment.

2) After you reconcile, look in the ofxretr.txt or xmldump.txt log files to figure out what the broker says the CUSIP should be. See the bottom of this page: http://www.fundmanagersoftware.com/tintrtv.html