Importing positions refers to the process of importing share balances from a file into Fund Manager sub-portfolios/investments. Importing positions can be useful when first setting up your Fund Manager data files, or for reconciliation purposes:
Setting Up New Fund Manager Data:
When establishing new Fund Manager data files, you can import your positions as of a certain date, and then import or retrieve transactions going forward. If you have all of your historical transaction data, it is not necessary to import positions, instead import your transactions. Importing the complete transaction history has the advantage of providing accurate historical returns and cost basis. There is no cost basis data available when importing positions, therefore all positions will be created with a cost basis of zero. To adjust the cost basis, use the Data Register and edit the initial purchase price and value.
Reconciliation:
When importing positions for reconciliation purposes, import positions into a new sub-portfolio. You can then compare the share balances in this imported position sub-portfolio against the share balances in your actual sub-portfolios. After reconciliation, you can delete the imported position sub-portfolio (see the Portfolio Editor).
Video Tutorial: See the Tutorial on Importing Institutional Position/Transaction Files (Advisor Version).
There are many sources of files that Fund Manager can import from, and they are listed below.
Source |
Format |
Comments |
*.OFX or *.QFX |
||
*.POS |
Advisor Version | |
*.TXT |
Advisor Version | |
*.TXT |
Advisor Version | |
*.POS |
Advisor Version | |
*.POS |
Advisor Version | |
*Position*.csv |
Advisor Version | |
*.POS |
Advisor Version | |
*.GCUS or *.FUND |
Advisor Version | |
*.POS |
Advisor Version | |
*.RPS |
Advisor Version | |
*SC.SE1 |
Advisor Version | |
BPS_POS_xx_mmyy.rpt |
Advisor Version | |
*.POS |
Advisor Version | |
*.POS |
Advisor Version |
Tutorial on Importing Position/Transaction Files (Advisor Version)