Use this template to provide your initial data to Fundriver, as well as to add data to your file on an ongoing basis. 


Instructions for filling out the template are below as well as attached below. Please contact support@fundriver.com if you have any questions.


Instructions can be found here.

Template can be found here.

Sample can be found here.


Important:  If you need to make additions to your data after your initial file is loaded, please make sure to request the most recent version of your Data Load Template from Fundriver.


Here's a short video showing how to populate this template: Data Load Template Video


Data Load Template Instructions


Funds Tab:

Complete each column as required and as appropriate to your set up specifications.


Optional fields can be populated/changed later in the implementation process if determined to be needed during review of the data base.


There is a color key for columns in the upper left corner to help identify which columns in the Funds Tab are required fields, related to Spending accounts, fields which can be renamed and fields which can be used as group by for reporting purposes. Note that some columns have multiple color codes associated with them. 


Yellow – Required Field 

Gray - Spending Accounts

Blue – Re-nameable Field

Green - Reporting/Group by Field

 

Note: General instructions for column entry, e.g. suggested purpose, text limit, required decimal places, etc. can also be accessed by hovering over the header of each column to view comments.


The sum of the market values should match the total value of the investment pool as reported on the investment statement(s) for the same time period (Fundriver start date).


Each fund entry must have a unique GLID number (Does not have to be a general ledger number just a unique account number (two funds cannot have duplicate GLID numbers in Fundriver).


The table below details the columns listed on the funds tab.

Column



Description



GLID Number (Required)



Typically this is the principal account number in the general ledger, but it does not have to be. It must be a unique number as you cannot have two named funds with the same GLID numbers. This number can be alpha/numeric and we would suggest not using spaces.



Auxiliary I.D.



An additional account number such as a donor I.D. number. This number does not have to be unique and can be alpha/numeric.



Fund Name

(Required)



The name of the fund as it will appear in Fundriver and on reports.



Spending Account



The spending account number for the distributed income (you can also include fund, program, project and dept. identifiers). If you have more than one “spending account” number for a fund please use the “Spending Exceptions” tab.



Investment Pool Name (Required)



Name given to the Investment pool the fund is participating in. This name will appear in the application.



Historical Gift (Required for PR funds)



Principal, Corpus, or total accumulated historical gifts as of the same date as the market value provided.



Market Value (Required)


Provide the market value for each fund as of the start date in Fundriver.

Inception Date



Date fund was established (mm/dd/yyyy).



Authorized Date



This is used to limit spending from a fund until a future date in time (mm/dd/yyyy). 


Reinvest Threshold

This is used to limit spending from a fund until a fund’s market value or corpus reaches a certain value.



Units 

(Required if Fundriver is taking over existing unit balances)



If Fundriver is taking over your existing units, provide the units for each fund as of the start date in Fundriver. If you are providing units, enter the unit price in the investment pools tab as of the start date in Fundriver.



Book Value



Represents gifts, plus income, plus realized gains, minus distributions. Not used by all organizations.



Non-unitized assets



Assets that belong to a specific fund but are not part of the investment pool. For example: real estate gifted to a specific fund.



Net Asset Classification (Required)



The corpus restriction of the fund. For example: Permanently Restricted, Temporarily Restricted, Unrestricted or Board Designated. This is a "group by" field on standard reports. 



Description



Use to provide a general description for the fund.



Campuses



Use this to designate different campuses. This is a “group by” field on standard reports and can be renamed.



Department



The designated department of the fund. This can also be used to identify organization codes. This is a “group by” field on standard reports and can be renamed.



Purpose/Use



Short description (250 character limit) of Purpose category of the fund. For example: scholarship, professorship or maintenance. This is a “group by” field on standard reports and can be renamed.



Spending Rule



Use this field to differentiate between distribution methods. For example, use this column to mark the funds that require a “manual” distribution calculation.  If all funds participate in the same spending rule then enter “standard spending rule.” Any funds that do not participate in spending, enter “none.” This is a “group by” field on standard reports.



Secondary Category 



Generic field. This is a “group by” field on standard reports and can be renamed.



Purpose Description



This field is used for Stewardship reporting purposes and should define the purpose of the fund in detail. This information will be placed on a standard Donor Report. Unlimited text field. 



Secondary Description



Generic text field. This field can be renamed.



Business Office Notes



Text field. This field can be renamed.



User Category 2



Generic field. This is a “group by” field on standard reports and can be renamed.



Note: The Fund, Project, Program, Dept, Campuses, Department, Purpose/Use, Secondary Category, Secondary Description, Business Office Notes and User Category 2 column headings can be renamed in Fundriver. If you want to rename these fields be sure to let your Implementation Specialist know.


Investment Pools Tab:

You only need to fill in this tab if you will be loading multiple investment pools, or have provided units in the Funds tab. The investment pool name in this tab should match the investment pool name given in the Funds tab.


If you provided units on the Funds tab, you will enter the unit price, or unit value, in column C for the same time period of the data being provided in the Funds tab.


Historical Data Tab:

Use this optional worksheet to load historical data for individual named funds into Fundriver. If your spending rule looks at individual fund values over a set time period then we would recommend that you provide enough historical data so Fundriver will be able to calculate the spending from the start date. Make a copy of each tab for each period you want to enter historical data. Enter the post date (end of month or quarter) of the information in cell B1 of each sheet.


If you are providing units, enter the unit price in cell D1. The cost column is optional.


To make a copy of the sheet in excel:

  1. Right click the mouse on the tab labeled “Historical Data”
  2. Select "Move or Copy" from the shortcut menu
  3. Check the box next to create a copy, click OK


Transaction History Tab

Use this optional worksheet to build transaction history for funds. Multiple dates/types can be loaded on one tab. Please make sure that your transaction history dates (Date column) coincides with your posting frequency in Fundriver - for example, if you will be posting quarterly in Fundriver, then "Date" should be populated with quarter-end dates.


Select from the listed transaction types when populating this tab. If you have a transaction which isn't covered by the transaction types listed in this tab, please reach out to our team for assistance. Entries which do not match the transaction types listed will not import properly. For more information about transaction types, see: Transaction Type Guide.


Pledge Balance Tab

Use this optional worksheet to track Pledge Balances as of the start date in Fundriver for applicable funds.  Fundriver has standard transaction types that record additional pledges, pledge payments, and write-offs. 


Spending Exceptions Tab

Use this optional worksheet to assign multiple spending (distributed income) account numbers to a single principal account (GLID number) in Fundriver. This tab is also used to set up fund specific reinvestments (either a fixed amount or %) of the spending amounts. Please note, if you have a one to one relationship between the principal account (GLID number) in Fundriver and spending (distributed income) account you would not use this tab and instead would put that information in the main “Funds” tab.


Reinvest Type Tab

Use this optional worksheet to differentiate funds that have a reinvest threshold based on Historical Gift vs. Market Value. Typically, most institutions have this determined based on Historical Gift and it’s determined at the organization level rather than fund by fund. 


Investment Pool History Tab

Use this optional worksheet to build investment pool history.  The investment pool name in this tab should match the investment pool name in the funds tab.


Additional Notes: The table below details the character length of the columns listed on the funds tab.


GLID



255



Aux ID



200



Fund Name



200



Spending Account



250



Fund



50



Program



50



Project



50



Dept.



50



Investment Pool Name



75



Cost



Two decimal places



Market Value



Two decimal places



Inception Date



01/01/2000 format



Authorized Date



01/01/2000 format



Reinvest Threshold



Two decimal places



Units



Four decimal places



Book Value



Two decimal places



Non-Unitized Assets



Two decimal places



Net Asset Classification



100



Description



250



Campuses



100



Department



100



Purpose/Use



250



Spending rule



255



Secondary Category



200



Purpose Description



No Limit



Secondary Description



No Limit



Business Office Notes



No Limit



User Category 2



No Limit




Confidential

Copyright © 2014 Fundriver, Inc.
US Patent No. 7,849,108
These materials constitute Fundriver confidential proprietary information.