Expendable funds are created in Fundriver using the Expendable Fund Data Load Template.


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
GLIDThis 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.
NameThe name of the fund as it will appear in Fundriver and on reports. This field is required.
Net Asset ClassificationThis 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.
CampusesThis 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.
DepartmentThis is a "group by" field on standard reports and can be renamed. This field is requiredbut can be populated with "None". These can be the same as the Departments used for the Endowed funds.
Purpose/UseThis is a "group by" field on standard reports and can be renamed. This field is requiredbut can be populated with "None". These can be the same as the Purpose/Use listings used for the Endowed funds.
Secondary CategoryThis 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 2This 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 IDAn 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 DateDate fund was established (mm/dd/yyyy).
DescriptionUse to provide a general description for the fund.
Purpose DescriptionThis 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 DescriptionGeneric text field. This field can be renamed.
Business Office NotesText 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.