How to interpret a Fund Activity report

Follow

Parameters

Parameter Name
Description
Example
Notes
 
Report Begin Date The first date used to return results. 12/01/2014 The date must be the first of the month. If it is not, the parameters are built to automatically change the date to the first.  
Report End Date The last date used to return results. 12/31/2014 This can be any day of the month. If the total date range is less than 365 days, the report will generate on the page. If it is longer than 365 days, the report will be emailed to the user.  

 

Report Details

Field Name
Description
Example
Notes
 
Fund # 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    
Division The Development Director who raises money for the Unit and Department associated with the fund. John Doe This field is based on Report Code 1 on the Fund's Purpose  
Account Category This differentiates the accounting dollars within the fund. Spendable Cash, Book Value

Callable funds will never have values in the Book Value, Cash to Endow, Spendable Endowment Income, Endowment Book Value or Accumulated Market Apprec/Dep

Endowment funds may have activity in all account types included in the fund.

Only accounts in the 1,000's are included on the report.

 
Journal Type The values describe the type of transaction the report line is. EM See a full list of Journal Type Codes.  
Transaction Description This relates to the entry in FE associated with the transaction in the fund. SpendPlan Allocation, Endowment Market Value Adjustment There are some standard entries for these descriptions. To get a full list, contact Sally Erdmann.  
Transaction Date The date the transaction occurred in FE. 01/12/2014    
Transaction Amount The amount of the transaction.

$1,290.00

($250.00)

This can be a positive or negative number.  
Ending Balance The amount remaining in the Account Category based on the date range selected.   The beginning balance is based on the first day of the month. Ending balance = Beginning Balance - (Sum of all transactions)  

Excel File 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    
Account Number The account used by finance for accounting purposes 10-1000, 20-1100, etc See "Living on the Financial Edge" Connect Posts for more detail  
Account Code Description This differentiates the accounting dollars within the fund. Spendable Cash, Book Value

Callable funds will never have values in the Book Value, Cash to Endow, Spendable Endowment Income, Endowment Book Value or Accumulated Market Apprec/Dep

Endowment funds may have activity in all account types included in the fund.

Only accounts in the 1,000's are included on the report.

*Same as the "Account Category" on the UI Details. May need to change one so they are consistent.

 
Journal Type The values describe the type of transaction the report line is. EM See a full list of Journal Type Codes.  
Transaction Description This relates to the entry in FE associated with the transaction in the fund. SpendPlan Allocation, Endowment Market Value Adjustment There are some standard entries for these descriptions. To get a full list, contact Sally Erdmann.  
Transaction Date The date the transaction occurred in FE. 01/12/2015    
Transaction Amount The amount of the transaction.

$1,290.00

($250.00)

This can be a positive or negative number.  
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Powered by Zendesk