Fundriver has developed DTDF Reconciliation Templates to help you calculate what your DTDF entry should be. Below are instructions for using the templates.  Choose which template to use based on whether you are using: 


DTDF Fund

DTDF Manager- those who subscribe to the Investment Portfolio Module


DTDF Fund


1. In the column for the month you are closing, enter the Fundriver Activity totals for each category listed below.  If you are a client who has customized other activity types, please feel free to add a column to the template to accommodate those activities.


DTDF Reconciliation Template- Fund Level can be found here


1.png


1.1. Enter any cash flow to/from the investment pool.
2.png


1.2. Your DTDF calculation will be figure for you.  Negative amounts are due from Operating; positive amounts are due to operating.

3.png


1.3. Enter the AMOUNT for the period as a transaction in ACTIVITY TRANSACTION entry. See additional Due To/Due From training for step-by-step instructions for entering DTDF transactions and reconciling the pool.

4.png


Click SAVE.


DTDF Manager


2. The Manager Template is used in the same way the Fund Template is used.  Enter your activity for the posting period to each category.


DTDF Reconciliation Template- Manager Level can be found here
5.png


2.1. Enter the cash that was transferred to/from the pool that period.
6.png


3. Your NET CASH FLOW and ENDING MARKET VALUES are calculated for you to enter into your DTDF Investment Manager.

7.png


4. Navigate to ACTIVITY > INVESTMENT ACTIVITY and click on the MANAGER DATA ENTRY tab. Choose your DTDF Manager and enter the numbers from the reconciliation template.

8.png


Click SAVE VALUES.


5. Run the MANAGER RECONCILIATION REPORT under REPORT INVESTMENT PORTFOLIO REPORTS to verify you reconcile.