Follow

How do I enter Manager Investment Activity on the Import Template?

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 here are 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.

Transactions affecting cash flow by managers: Capital Calls, Returned Capital and Net Cash Flow, must agree to the cash flow of the pool activity as well. For example, if you have $60,000 of capital calls, ($34,936.86) of returned capital and ($4,578.14) of other cash flow items your total cashflow by managers equals $20,485.00. Your activity at the pool level that affects the individual named funds (ie. gifts, distributions, transfers) also needs to agree to the net cashflow by manager, see illustration below. Often a due to/due from entry is required to reconcile the pool. For more information on due to/due from see the Using Due To/Due From (DTDF) with the Manager Module 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.’

2018-07-26_9-21-32.png
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.