Income/Spending distributions can be done three different ways in Fundriver. 1) You can automate the spending process (Automated Method), or 2) You can enter the income/spending distributions manually either transaction by transaction (Manual Method) or, 3) By using the “Copy from Excel” feature (Flexible Method).
The first step in any of these methods is to verify that your spending rule is set up and is correct. To check your existing rule(s), go to ORGANIZE > SPENDING RULES. Please review the article "How do I set up a spending rule?" for guidance on creating a new rule.
Distributions using the Automated Method
First, verify your spending rule is set up correctly by navigating to ORGANIZE
> SPENDING RULES
Once you have verified that the spending rule parameters are set correctly, you can have Fundriver debit each individual fund for its spending amount. If you want to debit funds monthly or quarterly for their calculated spending amounts you can still use this automated method (just make sure the parameters you set were monthly or quarterly.) For example, if the annual payout rate is 5% and you want to debit funds quarterly using this AUTOMATED METHOD, you would change the payout rate to a 1.25% then run the distributions on a quarterly basis. See above for example spending rule.
After you've verified that your Spending Rules are set up correctly, go to REPORT
Click on one of your ESTIMATED SPENDING REPORTS
and RUN REPORT.
These reports will calculate the spending amount available based on the spending rule parameters that are set. Once you've verified that the Estimated Spending amounts are accurate, proceed to next step.
Next, go to ACTIVITY
When the CREATE DISTRIBUTIONS window appears, click OK.
Your distributions will be created based on the spending parameters you have set up. See the end of this document for how to review your distributions posted.
If you need to delete the distribution, click DELETE DISTRIBUTIONS
. Please note; this will only delete distributions for the current period.
Distributions using the Manual Method
To enter spending/income distributions manually, go to ACTIVITY > TRANSACTION ENTRY.
Choose the TRANSACTION TYPE
and enter amount and any other information you would like available on the transaction record.
Repeat for as many distributions as you would like to process for a given period. This method is best for when only a few distributions are needed.
Distributions using the Flexible Method
The Flexible Method uses the COPY FROM EXCEL
feature in Fundriver. This allows you to post distributions in bulk to funds based on your desired amounts.
Once you have your desired distributions amounts for each GLID formatted in excel you can bring in the data in bulk. Click on ACTIVITY > TRANSACTION ENTRY.
Click on the COPY FROM EXCEL
tab and choose the DISTRIBUTION
transaction type.Your excel file should contain only GLID and GROSS DISTRIBUTION. You can add two additional columns for NOTES and SPENDING/INCOME ACCOUNT NUMBER (Destination). Populate these columns if you would like the information to reflect in the transaction record. They can also be left blank.
Note: If you have funds that are scheduled to reinvest either to market value or principal, you must take the additional step of adding in these transactions manually or using Copy from Excel. Funds that are reinvesting to market value should have a TRANSACTION TYPE of EXTERNAL TRANSFER IN and funds reinvesting to principal should have an INCOME TO PRINCIPAL type.
Select your data and copy the four columns by right clicking and selecting COPY or using Ctrl + C.
Navigate back to the COPY FROM EXCEL
tab in the Fundriver interface and click the PASTE
You will see the message below. Click Ctrl + V to paste.
Your data will populate the table on the IMPORT TRANSACTIONS FROM EXCEL
screen. Edit or delete any distributions you notice are incorrect.
Once all data is correct, click the PROCESS
Exceptions that cannot be processed will remain in the table with a corresponding ERROR MESSAGE
. A blank table means all records were properly processed.
Review any unprocessed records for errors and correct using the EDIT COMMAND
. Once corrections are made, click on PROCESS
Your distribution records have now been committed to the database.
Once all distribution transactions have been added to Fundriver, navigate to REPORT
to run a report to review your distributions.
Click on DISTRIBUTION REPORT
and enter your REPORT PARAMETERS
. Click RUN REPORT
The DISTRIBUTION REPORT will list all distributions made during the chosen period and provide a total distribution amount. This report can then be exported to PDF, Excel or Word.