This template is used to provide your initial data to Fundriver. Please be aware that Fundriver currently has an old and a new version of these templates; feel free to reach out to your Client Onboarding Advisor at [email protected] to confirm which version you're using. These directions apply to the version of the Data Load Template used in 2020 and prior.
If you are currently in implementation and you do not yet have access to the Fundriver system, then the template can be found HERE; if you already have access to Fundriver, then instead of using this template, you will need to log in to Fundriver and go to "Organize" then "Bulk Import", then click "Download Template".
The table below details the columns within the template.
| Column | Description |
| GLID | This must be a unique number for each fund (these cannot exactly match the GLIDs used for the Endowed funds; it must be unique among all funds). This number can be alpha/numeric; we advise against using spaces. This field is required. |
| Name | The name of the fund as it will appear in Fundriver and on reports. This field is required. |
| Net Asset Classification | This can be populated with any restriction classification (for example, Temporarily Restricted or With Donor Restriction) that applies to the fund; however, it cannot be an exact duplicate of the Net Asset Classifications used for the Endowed Funds. We recommend listing, for example, "Expendable Unrestricted" to differentiate. This field is required. |
| Campuses | This is a "group by" field on standard reports and can be renamed. This field is required, but can be populated with "None". These can be the same as the Campuses used for the Endowed funds. |
| Department | This is a "group by" field on standard reports and can be renamed. This field is required, but can be populated with "None". These can be the same as the Departments used for the Endowed funds. |
| Purpose/Use | This is a "group by" field on standard reports and can be renamed. This field is required, but can be populated with "None". These can be the same as the Purpose/Use listings used for the Endowed funds. |
| Secondary Category | This is a "group by" field on standard reports and can be renamed. These can be the same as the Secondary Categories used for the Endowed funds. |
| User Category 2 | This is a "group by" field on standard reports and can be renamed. These can be the same as the User Category 2's used for the Endowed funds. |
| Auxiliary ID | An additional account number such as a donor I.D. number. This number does not have to be unique and can be alpha/numeric. These can be the same as the Auxiliary IDs used for the Endowed funds. |
| Inception Date | Date fund was established (mm/dd/yyyy). |
| Description | Use to provide a general description for the fund. |
| 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. |
After the fund information is set up using the template above, the beginning balances are established using the Expendable Fund Transaction Template available HERE. To complete this template for beginning balances:
In Column A, select "Expendable Fund Beginning Balance"
In Column B, enter the GLIDs as populated in the fund information template
In Column C, enter the Beginning Balance
The remaining fields are optional.