Remap reconcilliation

[hipped1]

I have a security from E*TRADE which has a symbol of BF.B. The symbol used in fund manager is BF-B since that is what is required to match the quotes available in Yahoo.

I setup a txt file in Wordpad using the instructions in help:

BF.B BF-B

Note the spaces between the two symbols was created by pressing the tab key one time. I saved the file as Etrade.txt.

In the reconciliation wizard, I choose advanced options, click the box use security re-map file and browse for Etrade.txt. Hit Ok.

I run the reconciliation process and this security still comes up as an exception. There are shares in fund manager (BF-B) and no statement shares. There are statement shares but no fund manager shares (BF.B).

Is there something I am missing? Thanks in advance.

[Mark]

Hi hipped1,

What is your statement source? Are you retrieving the statement from E*Trade? If so, it is reconciling using CUSIP, and not Symbol.

[hipped1]

Statement source is ETrade. Not sure it is using CUSIP as this is not filled in for any of the investments in the portfolio. I did try adding BF.B as Cusip for this security in fund manager but still have a mismatch in reconciliation.

[Mark]

When retrieving from a broker, the CUSIP is the primary matching mechanism. If the CUSIP is empty, it will default to symbol. Did you use the new portfolio wizard to setup this account? If Fund Manager created the investments for you by retrieving transactions the CUSIP should be filled in.

You might just use the New Portfolio Wizard again to temporarily create a new sub-portfolio/account. You will then have all the investments, so you can see the CUSIP values. Copy these over to your original investments, and then close that temporary duplicate sub-portfolio.

[hipped1]

Thank you, that resolved the issue for this security.