Use the Standard Manager Investment Activity Import Template (attached below) to record investment activity by individual managers in each period. The template allows a bulk upload of manager activity instead of keying in entries one manager at a time. For instructions on how to load the file in Fundriver view the “How do I Upload the Investment Manager Template?” article.
Populate the template as shown below. Manager GLID and Ending Market Value are required fields for every manager, regardless if activity occurred within the period.
Please Note: All numerical data must be hard coded in cells, no formulas.
Below is an example of a completed file ready for import:
Attached hereare common scenarios that clients encounter; these scenarios demonstrate how to enter the transactions as positive or negative values on the manager investment activity template shown above. These scenarios are also attached at the bottom of this article.
Once you have successfully imported your investment activity template, it is helpful to view the Manager Reconciliation Report to check the accuracy of the activity imported. This report will show any variances in ending balance by investment manager and will also help reconcile the net cash flow activity between managers and pool activity. To view the Manager Reconciliation Report, go to Report> Portfolio Level Reports> Manager Reconciliation Report> and enter the dates for your current open period and click ‘Run Report.’