Importing transactions from broker

[jnewton]

I am in the process of transfering to fund manager from MS Money. Currently using the Professional Version on trial. In the past, I have entered all transactions manually and not downloaded from broker. For several reasons, (primarialy for accounting control) I want to continue entering purchase and sale activity manually, or from excel through a generic import. I would like to have a mechanism for recording dividends, and other transactions. Can you specify the types of transactions you want downloaded from the broker? Thanks, I'm sure I'll have many more questions about setting up and balancing accounts as I go.

[Mark]

Hi jnewton,

Thanks for trying out Fund Manager.

When you retrieve transactions from your broker, you generally get all your transactions, including buys, sells, dividends, etc. You could just give it a try, and see everything that downloads. If you decide you don't want to use that retrieved data, just cancel at the Preview stage, or close the sub-portfolio after retrieving. In general, retrieving Transactions & Positions using the New Portfolio Wizard is much easier than manually entering.

To see tutorials on using the different methods (retrieving / manual entry), please watch these videos:

http://www.fundmanagersoftware.com/tutor.html

[jnewton]

Mark:
Thanks for reply. I'm importing historical transactions directly from Money using QIF or CSV formats (have done both successfully). I've started with test accounts and watch lists and am moving up to larger accounts. I'm really asking about on an ongoing basis. When I record a purchase/sale, I copy it to Excel, summerize it and then import it to the portfolio program. That way the portfolio program shows a single line item instead of multiple trades from the broker (ie 1 1000 share trade instead of 10 100 share trades). Easier to follow and track lots and also is an additional account control. I think I'd like to continue this proceedure, but want to download divideds etc. about once/week directly from the broker. Is this possible or is it an all or nothing process? Thanks

[Mark]

Hi jnewton,

I understand, makes sense. You can download only the transactions you want. You do not have to download everything. When you do the transaction retrieve, you will be presented with a "Preview Importing Transactions" dialog after your data is retrieved, and before it is recorded. That dialog lists all the importing transactions. You can un-check any that you don't want to import. You can sort the list by any displayed column, including transaction type, so you could bunch all your distributions together, so that you can easily select all of those only, and only check those for import.

[jnewton]

Thanks again