This training addresses how to use the Due To/Due From (DTDF) if you do not have the Manager module. DTDF is helpful and necessary when an institution deposits gifts in an investment account or operating account that is commingled with non endowment funds, takes withdrawals for spending at fund level without drawing from investments, or other related endowment cash flow that needs to be tracked within a commingled investment or operating account. The due to/from allows users to manage this type of cash flow and should allow you to reconcile back to an operating account the cash balance that is purely Endowment. In the example below, a $15,000 gift was entered in the 7/31/2014 period but the cash was not transferred to the investment manager. The following steps will show how to use a DTDF fund to track activity that has not yet been reflected on investment statements.
You can find the template and more information on how to use the template, here!
TO SET UP THE DUE TO/DUE FROM (DTDF) FUND
The first thing that needs to be done is to check FUND CATEGORIES to see if a Due To/Due From (DTDF) NET ASSET CLASSIFICATION has been set up in your database.
This is usually done during the implementation process, but if you weren't using Due To/Due From when your organization implemented Fundriver, one may not have been established.
1. Click on the ORGANIZE tab, choose NET ASSET CLASSIFICATION from the CATEGORY drop down.
If you do not have a DTDF NET ASSET CLASSIFICATION, click the green ADD ITEM button to add one.
1.1. Enter a name for your DTDF classification and give it the code DT. Click SAVE.
The DTDF fund when set up with a DT net asset class code will not have any units assigned to it. Units assigned is what drives the investment allocations to each fund. The DTDF fund is set up as a holding fund until cash is transferred. Therefore, if you take the Pool Unit Price * Units, this will be equal to the value of the MV of the Pool less the market value of the DTDF Fund, since this fund doesn’t own units.
2. Click on FUNDS > ADD FUND > A blank Fund Profile will be generated.
3. Fill out the Fund Profile out as shown below. The NAME and GLID should be descriptive, but can be of your choosing. Make sure the SPENDING RULE is BLANK RULE and the NET ASSET CLASSIFICATION is your DTDF classification.
Once the Fund Profile is complete, click SAVE.
You do not need to populate anything under DISTRIBUTION ACCOUNT or DOCUMENTS for the DTDF fund.