Costs of securities

[wally2020]

Once you have imported securities from financial institution, how do you enter the original costs of each security?

[Mark]

Hi wally2020,

If available when you retrieved/imported, it will already be recorded. You can view/edit any of your transactions though in the Data Register. Just double click on any investment, and you will see all your transactions. To edit a transaction, double click on the transaction, or select it, and press "Edit...".

[wally2020]

Mark,

Thanks. I also noticed that once you do that you have to go into Federated Prime obligations and delete the transaction. I thought maybe there was another way. I have imported 3 different accounts and none of the costs were imported, I am not sure why, everything else balanced?

Wally2020

[Mark]

Hi Wally2020,

It sounds like that "Federated Prime obligations" is set to be your default cash account. You can verify by looking at the properties of the sub-portfolio. When you add/edit/delete any transaction the assigned corresponding default cash account will also be updated.

I'm guessing you had some adjustment entry to somehow set the balance of your cash to be correct, and then when you go edit a transaction in some other investment, this affects the cash balance. You can either change that adjustment entry by the same amount, or delete the cash side of the transaction.

What is your data source? How are you getting it, and how are you importing? Are you using the New Portfolio Wizard?

[wally2020]

Hi Mark,

I used the wizard all times. The information is coming from mystreetscape. It's surprising that original costs are included in the import. I even deleted the first import and tried again, same results. No big deal, I just will manual do it. But if you figure out why, let me know.

thanks,

wally2020

[wally2020]

Mark,

correction in my replay, I meant to say aren't included instead of are included!

wally2020

[Mark]

Hi wally2020,

If original cost isn't included, then the broker didn't provide it. If available, FM will use it. Many brokers only keep transactions for a fixed amount of time on their OFX server, which is the server making your transactions/positions available to Fund Manager. When you retrieve with the New Portfolio Wizard, FM attempts to get all available transactions (which include the costs) from the broker, plus it also obtains the current position balances. If all the transactions available do not add up to the current balances, it records an "adjustment" entry to make the current balance correct. This adjustment entry is recorded at a cost of 0 since FM doesn't know the cost. This is what you would want to go back and edit manually.