How to interpret a Fund Balance report

Follow

Parameters

 

Parameter Name
Description
Example
Notes
 
Current Balances Runs the report based on the Fund's previous day's balance   There is no option to select a date other than the current date.  
Month-End Balances The last date of a previous month 12/31/2014 Any month/year can be selected, but it must be the last day of the month. If no date is selected or today's date, the report parameter will adjust to the most recent month end.  

 

Report Details

Field Name
Description
Example
Notes
 
Fund Number Unique numeric identifier for the fund. 112003456    
Fund Name Full name of the fund associated with the Fund Number. Department of Chemical Engineering Chair's Fund    
Unit The School or College associated with the fund. College of Engineering    
Department The Department within the School or College. Chemical Engineering    
Use The use identifies what the gift funds can be used for or how the money can be spent. J, B, etc The UI only shows the code, not the full use description. See more: KB Fund Use Codes  
Spendable Cash Account used to hold donations and money that can be spent down to zero according to the donor's wishes $23,000 This account is used to hold all donations intended to be spent and not invested. See Connect posts named, "Living on the Financial Edge"  
Spendable Endowment Income Account used to hold money transfered from the endowment to a spendable account. The money transfered is determined by the Estimated Annual Income. $1,305 See Connect posts named, "Living on the Financial Edge"  
Cash to be Endowed Account used to hold donations intended for the Endowment fund to grow the Endowment and Estimated Annual Income for future use. $12,500 The amount in the Cash to be Endowed fund will be transfered to the Endowment Book Value account at the end of each quarter. See Connect posts named, "Living on the Financial Edge"  
Estimated Annual Income Calculated amount based on the SpendPlan Allocation x 4 to provide an estimate on the amount of income the fund will realize. $2,345.97 Amount is recalculated every quarter. See Connect posts named, "Living on the Financial Edge"  
Endowment Book Value Account used to hold the investment made by the Unit/Department or donor. The balance is based on the donations and accounting transfers made to the fund throughout the life of the fund. $500,500 See Connect posts named, "Living on the Financial Edge"  
Accumulated Market Appreciation/Depreciation Account showing the interest earned or lost in the investment of the Endowment Book Value.

$23,900

($12,800)

Can be positive or negative. See Connect posts named, "Living on the Financial Edge"  
Total Endowment Market Value The full value of the fund. The amount is calculated by adding the Endowment Book Value and the Accumulated Market Appreciation/Depreciation, i.e. 500,500+23,900 or 500,500 + (12,800)

$524,400

$487,700

See Connect posts named, "Living on the Financial Edge"  

 

Excel File

 
    
Field Name
Description
Example
Notes
 
Fund Number Unique numeric identifier for the fund. 112003456    
Fund Name Full name of the fund associated with the Fund Number. Department of Chemical Engineering Chair's Fund    
Unit The School or College associated with the fund. College of Engineering    
Department The Department within the School or College. Chemical Engineering    
Use  The use identifies what the gift funds can be used for or how the money can be spent.  Discretionary, Research and Programs, etc.  See more: KB Fund Use Codes   
Fund Class   Endowment-PERM, Callable-TEMP    
Spendable Cash Account used to hold donations and money that can be spent down to zero according to the donor's wishes $23,000 This account is used to hold all donations intended to be spent and not invested. See Connect posts named, "Living on the Financial Edge"  
Spendable Endowment Income Account used to hold money transfered from the endowment to a spendable account. The money transfered is determined by the Estimated Annual Income. $1,305 See Connect posts named, "Living on the Financial Edge"  
Cash to be Endowed Account used to hold donations intended for the Endowment fund to grow the Endowment and Estimated Annual Income for future use. $12,500 The amount in the Cash to be Endowed fund will be transfered to the Endowment Book Value account at the end of each quarter. See Connect posts named, "Living on the Financial Edge"  
Estimated Annual Income Calculated amount based on the SpendPlan Allocation x 4 to provide an estimate on the amount of income the fund will realize. $2,345.97 Amount is recalculated every quarter. See Connect posts named, "Living on the Financial Edge"  
Endowment Book Value Account used to hold the investment made by the Unit/Department or donor. The balance is based on the donations and accounting transfers made to the fund throughout the life of the fund. $500,500 See Connect posts named, "Living on the Financial Edge"  
Accumulated Market Appreciation/Depreciation Account showing the interest earned or lost in the investment of the Endowment Book Value.

$23,900

($12,800)

Can be positive or negative. See Connect posts named, "Living on the Financial Edge"  
Total Endowment Market Value The full value of the fund. The amount is calculated by adding the Endowment Book Value and the Accumulated Market Appreciation/Depreciation, i.e. 500,500+23,900 or 500,500 + (12,800)

$524,400

$487,700

See Connect posts named, "Living on the Financial Edge"
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Powered by Zendesk