Follow

Using Due To/Due From (DTDF) without the Manager Module.

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: https://fundriver.zendesk.com/hc/en-us/articles/208012726-Using-the-Due-to-Due-from-Reconciliation-Template

TO SET UP THE DUE TO/DUE FROM (DTDF) FUND

1. Click on the ORGANIZE tab.

First, you will need to verify that you already have a Due To/Due From fund set up in the system.  Click on ORGANIZE.

2. 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.

3. 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.

3.1. Enter a name for your DTDF classification and give it the code DT. Click SAVE.

4. Click on FUNDS.

5. Click ADD FUND.

6. A blank Fund Profile will be generated.

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

8. Once the Fund Profile is complete, click SAVE.

9. You do not need to populate anything under DISTRIBUTION ACCOUNT or DOCUMENTS for the DTDF fund.

TO USE THE DUE TO/DUE FROM (DTDF) FUND

1. Click on ACTIVITY > INVESTMENT ACTIVITY.

Click on ACTIVITY > INVESTMENT ACTIVITY.

2. Choose your endowment pool.  Enter your investment data from your manager statement.

3. Once investment information is loaded, click RECONCILE.

Once investment information is loaded, click RECONCILE.

4. The $15,000 gift that was added but hasn't yet been transferred to the manager is creating a DIFFERENCE of $15,000.  A transaction for this $15,000 will need to be entered to the DTDF Fund to show that this money is due to the investment manager. Once this is added, we will reconcile.

The $15,000 gift that was added but hasn't yet been transferred to the manager is creating a DIFFERENCE of $15,000.  A transaction for this $15,000 will need to be entered to the DTDF Fund to show that this money is due to the investment manager. Once this is added, we will reconcile.

5. This worksheet illustrates how the DTDF should be impacted by this $15,000 gift. The Cash Flow shown below will need to be entered as the July DTDF NET CASH FLOW amount.

6. To add the DTDF transaction, click on ACTIVITY > TRANSACTION ENTRY.

To add the DTDF transaction, click on ACTIVITY > TRANSACTION ENTRY.

7. Add a TRANSACTION TYPE of DUE TO/DUE FROM TRANSFER.

Add a TRANSACTION TYPE of DUE TO/DUE FROM TRANSFER.

8. Select your DTDF fund in the ENDOWMENT drop down and enter the amount you need to apply to the DTDF fund.  You can copy this directly from the DIFFERENCE line on the RECONCILIATION screen. Click SAVE.

Select your DTDF fund in the ENDOWMENT drop down and enter the amount you need to apply to the DTDF fund.  You can copy this directly from the DIFFERENCE line on the RECONCILIATION screen.Click SAVE.

9. Once save is complete, go back to ACTIVITY > INVESTMENT ACTIVITY.

Once save is complete, go back to ACTIVITY > INVESTMENT ACTIVITY.

10. Choose your endowment pool and post date and click RECONCILE again.

Choose your endowment pool and post date and click RECONCILE again.

11. Your reconciliation should show a DIFFERENCE of 0.00.

Your reconciliation should show a DIFFERENCE of 0.00.

11.1 Your CHANGE IN DUE-TO DUE-FROM should be reflected as part of the reconciliation.  

Your CHANGE IN DUE-TO DUE-FROM should be reflected as part of the reconciliation.  

12. When there is a Negative Balance in the Due To/Due From Endowment fund, this represents cash owed to the endowment investments. When there is a Positive Balance in the Due To/Due From Endowment, this represents cash that is Owed To Operating (needs to be drawn down from the Endowment Investments).

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.