Income/Spending distributions can be done three different ways in Fundriver. You can automate the spending process (Automated Method) or you can enter the income/spending distributions manually either transaction by transaction (Manual Method) or by using the “Copy from Excel” feature (Flexible Method). The first step in any of the methods is to verify that your spending rule is set up and is correct. Please review the article "How do I set up a spending rule?" for guidance on creating a new rule. To check your existing rule(s), go to “Organize” then select “Spending Rules."
Manual Method: To enter spending/income distributions manually, go to ACTIVITY > TRANSACTION ENTRY.
Choose the TRANSACTION TYPE of DISTRIBUTION and enter amount and any other information you would like available on the transaction record.
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.
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.
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.