Follow

Data Load Template and Instructions

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

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

Instructions for filling out the template are below as well as attached as a document at the end of the instructions.  Please contact Support if you have any questions.

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

Data Load Template Instructions

Version 3.4

 

Funds Tab:

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).

 

Required fields are color coded (yellow) on the Data Load Template.

 

Column

Description

GLID Number (Required)

Typically the principal account number in the general ledger but does not have to be, just needs to be unique.   You cannot have two named funds with the same GLID numbers. This number can be alpha/numeric, 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/year).

Authorized Date

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

 

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)

Provide the units for each fund as of the start date in Fundriver If Fundriver is taking over your existing units. 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-pooled 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)

Example: Permanently Restricted, Temporarily Restricted, Unrestricted or Board Designated. This is the corpus restriction of the fund.

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 org. codes. This is a “group by” field on standard reports and can be renamed.

Purpose/Use

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 identify what spending rule/distribution method the fund participates in.  For example:

If all (or most) funds participate in the same spending rule then put “Standard Spending Rule” in this field.

If a fund participates in a non-Standard Spending Rule, put a generic description of rule.

If a fund does not participate in any spending rules put “none”.

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.

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.

 

Notes: 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.

 

Historical Data:

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

  1. Right mouse click 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

 

Investment Pools Tab

You only need to fill in information in this table 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.

 

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.

 

Gift History Tab

Use this optional worksheet to build gift history for funds. Please make sure that your gift history date (Post Date) coincides with your posting frequency in Fundriver.

 

Distribution History Tab

Use this optional worksheet to build distribution history for funds. Please make sure that your distribution history date (Post Date) coincides with your posting frequency in Fundriver.

 

Transfer History Tab

Use this optional worksheet to build transfer history between funds. Please make sure that your transfer history date (Post Date) coincides with your posting frequency in Fundriver.

 

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

250

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

Ten decimal places

Book Value

Two decimal places

Non-Pooled Assets

Two decimal places

Net Asset Classification

100

Description

250

Campuses

100

Department

100

Purpose/Use

250

Spending rule

255

Secondary Category

100

Purpose Description

No Limit

Secondary Description

No Limit

Business Office Notes

No Limit

User Category 2

100

 

Confidential

Copyright © 2014 Fundriver, Inc.

US Patent No. 7,849,108

These materials constitute Fundriver confidential proprietary information.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.