This template is used to provide Fundriver with your initial data to get your new database set up. Please note that Fundriver currently has two versions of our Data Load Template, an old and a new. Feel free to reach out to your Client Onboarding Advisor at support@fundriver.com to confirm which version you're using. These directions apply to the "new" version of the Data Load Template, 2021 version. 


Click HERE to download the blank template! 


TABLE OF CONTENTS

 

Investment Pools Tab (Required)

Provide the name and total market value of each Investment Pool. The investment pool names in this tab should match identically to the investment pool names given in the Fund Profile tab (column C) . You can have more than one pool, as long as funds are not co-mingled within separate investments. Read this article for more information on the relationship between funds, managers, pools, and endowments.  


Your Fundriver inception date, also known as the Load Date, should be the "as of" date that you are loading your data into Fundriver. We recommend this date being the date of your last audited financial statements.


If you provided units on the Fund Profile tab, enter the unit price, or unit value, in column C for the same time period of the data being provided in the Funds tab. If you are not currently unitized, we will populate your starting unit price as $100.

 

The Total Pool Market Value should tie to the sum of the market values of those funds with each pool, listed on the Fund Profile tab.



 

Funds Tab (Required)

Complete all required columns. Fields highlighted in yellow (columns A through G) are required. All other optional fields can be populated and/or changed later via your database in the event it is determined something is needed later, or after the implementation process. 

 

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. 


Helpful hints:

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


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




The table below details the columns found on the funds tab:


*The ability to "group" the field by different categories for reporting purposes

ColumnDescriptionData LimitsGrouping?*
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.Max length: 255
Data type: Any
No
Fund Name
(Required)
The name of the fund as it will appear in Fundriver and on reports.Max length: 200
Data type: Any
No
Investment Pool Name (Required)Name given to the Investment Pool the fund is participating in. This name will appear in the application.Max length: 75
Data type: Any
Yes
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. Max length: 100
Data type: Any
Yes
Spending RuleUse 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.Max length: 255
Data type: Any
Yes
Historical Gift (Required for PR funds)Principal, Corpus, or total accumulated historical gifts as of the same date as of the start date in Fundriver.Max length: N/A
Data type: Dollar amount with 2 decimal places (amounts past 2 decimal places will be rounded)
No
Market Value (Required)Full market value for each fund as of the start date in Fundriver (note this is the full market value, so includes gift value, and is usually greater than historical gift)Max length: N/A
Data type: Dollar amount with 2 decimal places (amounts past 2 decimal places will be rounded)
No
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.Max length: N/A
Data type: Number (floating)
No
Book ValueRepresents gifts, plus income, plus realized gains, minus distributions. Not used by all organizations.Max length: N/A
Data type: Dollar amount with 2 decimal places (amounts past 2 decimal places will be rounded)
No
Pledge BalancePledge balance for the fund as of the start date in Fundriver. Note that Fundriver does not include this balance for earnings or spending allocations, or for endowment footnote reporting.Max length: N/A
Data type: Dollar amount with 2 decimal places (amounts past 2 decimal places will be rounded)
No
Spending Bucket BalancePledge balance for the fund as of the start date in Fundriver. This field does not apply to all clients, check with your Onboarding Advisor if you are unsure what data to provide.Max length: N/A
Data type: Dollar amount with 2 decimal places (amounts past 2 decimal places will be rounded)
No
Non-unitized assetsAssets that belong to a specific fund but are not part of the investment pool. For example, real estate gifted to a specific fund.Max length: N/A
Data type: Dollar amount with 2 decimal places (amounts past 2 decimal places will be rounded)
No
DescriptionUse to provide a general description for the fund.Max length: 250
Data type: Any
No
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.Max length: 200
Data type: Any
No
Inception DateDate fund was established (mm/dd/yyyy).Max length: N/A
Data type: Date (mm/dd/yyyy)
No
CampusesUse this to designate different campuses. This is a “group by” field on standard reports and can be renamed.Max length: 100
Data type: Any
Yes
Purpose/UseShort 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.Max length: 250
Data type: Any
Yes
Secondary Category Generic field. This is a “group by” field on standard reports and can be renamed.Max length: 200
Data type: Any
Yes
DepartmentThe 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.Max length: 100
Data type: Any
Yes
User Category 2Generic field. This is a “group by” field on standard reports and can be renamed.Max length: Unlimited
Data type: Any
Yes
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. Max length: Unlimited
Data type: Any
No
Business Office NotesText field. This field can be renamed.Max length: Unlimited
Data type: Any
No
Secondary DescriptionGeneric text field. This field can be renamed.Max length: Unlimited
Data type: Any
No
Fee ScheduleUse this field to differentiate between fee calculation methods. For example, if some funds are subject to a 1% of market value fee and others are subject to 0.5%, this field could be filled in with "1% Admin Fee" and "0.5% Admin Fee" respectively.Max length: 255
Data type: Any
No
Distribution Reinvest Threshold - HGThis is used to limit spending from a fund until a fund’s historic gift or corpus reaches a certain value. For each fund, fill in only this field or the next field.Max length: N/A
Data type: Dollar amount with 2 decimal places (amounts past 2 decimal places will be rounded)
No
Distribution Reinvest Threshold - MVThis is used to limit spending from a fund until a fund’s market value reaches a certain value. For each fund, fill in only this field or the prior field.Max length: N/A
Data type: Dollar amount with 2 decimal places (amounts past 2 decimal places will be rounded)
No
Authorized DateThis is used to limit spending from a fund until a future date in time (mm/dd/yyyy). Max length: N/A
Data type: Date (mm/dd/yyyy)
No
Distribution Destination IDThe primary spending account number for the distributed spending. If you have more than one “spending account” number for a fund please use the “Spending Exceptions” tab.Max length: 25500
Data type: Any
No
Distribution FundThis is used for additional components of the spending account number's account coding for the distributed spending. If you have more than one “spending account” number for a fund please use the “Spending Exceptions” tab.Max length: Unlimited
Data type: Any
No
Distribution ProjectThis is used for additional components of the spending account number's account coding for the distributed spending. If you have more than one “spending account” number for a fund please use the “Spending Exceptions” tab.Max length: Unlimited
Data type: Any
No
Distribution ProgramThis is used for additional components of the spending account number's account coding for the distributed spending. If you have more than one “spending account” number for a fund please use the “Spending Exceptions” tab.Max length: Unlimited
Data type: Any
No
Distribution DeptThis is used for additional components of the spending account number's account coding for the distributed spending. If you have more than one “spending account” number for a fund please use the “Spending Exceptions” tab.Max length: Unlimited
Data type: Any
No
Income Acct (for GL Exports)If the income account numbers used vary between different funds, this field can be used to specify the account code to be used for income.Max length: 50
Data type: Any
No
Gain Acct (for GL Exports)If the gains account numbers used vary between different funds, this field can be used to specify the account code to be used for gains.Max length: 50
Data type: Any
No
Invest Acct (for GL Exports)If the investment account numbers used vary between different funds, this field can be used to specify the account code to be used for investments.Max length: 50
Data type: Any
No

 

 

Distribution Rules 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 the spending (distributed income) account you would not use this tab and instead would put that information in the main “Funds” tab (Columns AB-AF).


 

 

Fund History 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.  

 

If you are providing units, enter the unit price in column G.

 



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) coincide 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 that isn't covered by the transaction types listed in this tab, please reach out to our team for assistance. Entries that do not match the transaction types listed will not import properly.



 

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 and investment pools tabs.




Investment Portfolio Tab

To use if you purchased the Investment Portfolio module

 



The table below details the columns listed on the investment portfolio tab. 

 

Column

Description

Investment Pool Name (required

Name given to the Investment pool the Manager is participating in.  This name should match the Investment Pool name on the Investment Pools tab and the Fund profile tab.

Manager Name (required)

 

Name of Investment Manager.

MGLID (required)

This must be the unique identifier of the Manager in Fundriver.  This can be a random number assigned (alpha/numeric) or it can be the GL Account Number for interfacing GL activity in/out of Fundriver. 

Book Value

Provide the Investment manager book value (cost) as of the start date in Fundriver

Investment Type

Select the appropriate Investment type from the drop-down for each manager.

Custody Account Number

The account number on the custody statement.

Custodian Name

Name of custody account. 

FASB Level

In the drop-down list select Level 1, 2, or 3 for the Manager.  Per FASB 157, level 1 assets are the easiest to value accurately based on standard market-based prices and level 3 assets are the most difficult.

Asset Class

In the drop-down list select the Asset Class that would apply to the specific Manager.    If you don’t see an option that applies write in your own or leave blank.

Target Weight

Provide the Manager’s target weight in the Investment Pool.

Initial Capital Commitment

Provide the initial capital commitment of the Manager.   

Capital Commitment

Remaining

Provide the initial capital commitment of the Manager.   

Liquidity

In the drop-down, select the liquidity of each manager (per the ASU 2016-14 Standards).

 

 

Notes:  Please make sure that the total of the investment manager market values in column “D” is equal (to the penny) to the total market value of the Pools on the Investment Pools tab and the Funds on the Fund Profile tab for the investment pool(s) that will be tracked at the Manager level.

 

The Manager Profile information can be edited within the user interface after it’s been loaded.  Any changes to the Market values will need to be corrected in the template and sent to Fundriver for uploading.     

 

Make sure the market values provided for each Manager in column “D” are for the same start date as the market values provided for each Fund in the Fund Profile tab. 

 

If you need to account for a timing issue with cash flow (Due to/from) set up a Manager for this specific purpose and include the due to/from value as of your start date (or posting date).


 

Expendable Fund Profile Tab

To use if you purchased the Expendable Funds module

 

Use this optional worksheet to list out your organization’s expendable funds.  Fields highlighted in yellow (columns A through D) are required.

 

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

 



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

 

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.

 

 

 

Expendable Transaction History Tab

Use this optional worksheet to provide beginning balances or historical transaction history for your expendable funds.

 

Multiple dates/types can be loaded on one tab. Please make sure that your transaction history dates (Date column) coincide 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 that isn't covered by the transaction types listed in this tab, please reach out to our team for assistance. Entries that do not match the transaction types listed will not import properly.

 

 

Comparison of Data Fields: Endowed vs. Expendable vs. Investment Managers

For organizations that have purchased the Expendable Funds Module and/or the Investment Portfolio Module, the below table is a useful comparison of fields that are found in each of these modules vs. the fields available for tracking endowments in Fundriver. Endowed and Expendable funds share the majority of their data fields; Investment Managers, however, shared very few fields, and have several unique fields.


 

Data Field
Description
Endowed
Funds?

Expendable
Funds?

Investment
Managers?

Investment Pool NameName given to the Investment pool which contains fund(s) and manager(s)YesNoYes
GLID/MGLID NumberUnique identifier of a specific fund (endowed or expendable), or specific managerYesYesYes
NameThe name of the fund or manager as it will appear in Fundriver and on reports.YesYesYes
Market ValueFull market value for each fund or manager as of the start date in Fundriver (note this is the full market value, so includes gift value, net earnings, etc., and is usually greater than historical gift)YesNoYes
Book ValueRepresents gifts, plus income, plus realized gains, minus distributions. Also may be called "tax cost". Not used by all organizations.YesNoYes
Investment TypeInvestment Type for each investmentNoNoYes
Custody Account NumberAccount number on the custody statementNoNoYes
Custodian NameName of custody accountNoNoYes
FASB LevelFASB 157 valuation level of investment managers; Level 1, 2 or 3.  Per FASB 157, level 1 assets are the easiest to value accurately based on standard market-based prices and level 3 are the most difficult.NoNoYes
Asset ClassAsset Class that applies to each manager. NoNoYes
Target WeightManager’s target weight in the Investment PoolNoNoYes
Initial Capital CommitmentInitial capital commitment of the ManagerNoNoYes
Capital Commitment RemainingCurrent capital commitment of the ManagerNoNoYes
LiquidityLiquidity of each manager (per the ASU 2016-14 guidance)NoNoYes
Net Asset ClassificationThe corpus restriction of the fund. For example: Permanently Restricted, Temporarily Restricted, Unrestricted or Board Designated.YesYesNo
DescriptionUse to provide a general description for the fund.YesYesNo
Auxiliary I.D.An additional account number such as a donor I.D. number. This number does not have to be unique.YesYesNo
Inception DateDate fund was established (mm/dd/yyyy).YesYesNo
CampusesUse this to designate different campuses.YesYesNo
Purpose/UseShort description (250 character limit) of Purpose category of the fund. For example: scholarship, professorship or maintenance.YesYesNo
Secondary Category Additional grouping field; use varies by organizationYesYesNo
DepartmentThe designated department of the fund. This can also be used to identify organization codes.YesYesNo
User Category 2Additional grouping field; use varies by organizationYesYesNo
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 the standard Donor Report.YesYesNo
Business Office NotesText field often used for notes from the Business Office relating to a specific fundYesYesNo
Secondary DescriptionAdditional text field; use varies by organizationYesYesNo
Spending RuleUsed to differentiate between multiple spending calculationsYesNoNo
Historical Gift (Required for PR funds)Principal, Corpus, or total accumulated historical gifts as of the same date as of the start date in Fundriver.YesNoNo
UnitsUnits owned by a specific fundYesNoNo
Pledge BalanceOutstanding pledge receivableYesNoNo
Spending Bucket BalanceSpending calculated but not yet removed from the endowment balance (this doesn't apply for all clients)YesNoNo
Non-unitized assetsAssets that belong to one specific fund, and not to the rest of the poolYesNoNo
Fee ScheduleUsed to differentiate between multiple fee calculationsYesNoNo
Distribution Reinvest Threshold - HGThis is used to limit spending from a fund until a fund’s historic gift or corpus reaches a certain value.YesNoNo
Distribution Reinvest Threshold - MVThis is used to limit spending from a fund until a fund’s market value reaches a certain value.YesNoNo
Authorized DateThis is used to limit spending from a fund until a future date in time (mm/dd/yyyy). YesNoNo
Distribution Destination IDThe primary spending account number for the distributed spending.YesNoNo
Distribution FundThis is used for additional components of the spending account number's account coding for the distributed spending.YesNoNo
Distribution ProjectThis is used for additional components of the spending account number's account coding for the distributed spending.YesNoNo
Distribution ProgramThis is used for additional components of the spending account number's account coding for the distributed spending.YesNoNo
Distribution DeptThis is used for additional components of the spending account number's account coding for the distributed spending.YesNoNo
Income Acct (for GL Exports)If the income account numbers used vary between different funds, this field can be used to specify the account code to be used for income.YesNoNo
Gain Acct (for GL Exports)If the gains account numbers used vary between different funds, this field can be used to specify the account code to be used for gains.YesNoNo
Invest Acct (for GL Exports)If the investment account numbers used vary between different funds, this field can be used to specify the account code to be used for investments.YesNoNo

 

Confidential

Copyright © 2014 Fundriver, Inc.

US Patent No. 7,849,108

These materials constitute Fundriver confidential proprietary information.