Endowment Reports

Running WEB Reports

If you cannot scroll through pages/down the page of a WEB report, you may need to run the report in a different browser. IT Services recommends using Chrome. More information about supported browsers is available in the IT Knowledge Base.

Instructions for logging in to reports and exporting data is available on the Running Web & Crystal Reports page.
Crystal Reports software is not required to run the web report templates.


Endowment Report Templates

Endowment Fund Information WEB Report

File Endowment Fund Summary CRYSTAL Report

Description, Prompting Query Fields, Help Documentation

Last modified:
2007-01-31

Description:
Displays all non financial information associated to an Endowment Fund and its related Spendable Income Fund.

Report Help:
PDF icon Endowment Fund Information [.pdf]

Prompting Query Fields:
- Fund code starting with '6'

View Information [for Crystal Report]:
View: FE.Endow.Profile

Endowment Monitoring WEB Report

File Endowment Monitoring CRYSTAL Report

Description, Prompting Query Fields, Help Documentation

Last modified:
2016-03-15

Description:
Displays spendable income funds falling within a given Organization Code's jurisdiction (departmental or faculty). Intended to assist in the monitoring and budgeting of endowment income.

Since capitalization and decapitalization impacts endowment holdings, budgets will only be updated once the budget adjustments and retro income distributions feeds are posted to spendable income funds. This occurs as soon as the unitization and income distribution processes are run at the end of the fiscal period in which the request was processed. If requests for capitalization and decapitalization have been processed in the current open fiscal period, it will not be reflected in this report ‐ the Total Current Year Budget will reflect these transactions the following fiscal period once the feeds are posted.

Report Help:
PDF icon Endowment Monitoring [.pdf]
PDF icon Forecasting Budget for Endowment Spendable Income Funds [.pdf]

Prompting Query Fields:
- Fiscal Year
- Organization Code
- Organization Level
- Report Type
Note: If you are unsure which Organizational Level to choose, look up the Org Code you wish to query in Banner. Instructions are available in our Knowledge Base.

View Information [for Crystal Report]:
View: FG.Statement.Heading
View Help: PDF icon FG.Statement.Heading [.pdf]
View: FG.Fund.Profile
View Help: PDF icon FG.Fund.Profile [.pdf]
View: FG.Transaction.Det.Operating
View Help: PDF icon FG.Transaction.Det.Operating [.pdf]

Endowment Planning WEB Report

File Endowment Planning CRYSTAL Report

Description, Prompting Query Fields, Help Documentation

Last modified:
2011-03-28

Description:
Displays spendable income funds falling within a given Organization Code's jurisdiction (departmental or faculty) and project income based on an expected MIP (McGill Investment Pool) income distribution rate. Intended to assist in the monitoring and budgeting of endowment income.

The number of MIP Units indicated in this report reflects data from the Banner form FNIEBAL. If new gifts are received or income is capitalized or decapitalized in the current open fiscal period, it will not be reflected in this report ‐ the Number of (MIP) Units Owned is only updated in the following fiscal period once the unitization process is run for the closed period.

Report Help:
PDF icon Endowment Planning [.pdf]
PDF icon Forecasting Budget for Endowment Spendable Income Funds [.pdf]

Prompting Query Fields:
- Fiscal Year
- Fiscal Period
- Organization Code
- Organization Level
- Report Type
- Expected MIP Income Distribution Rate
Note: If you are unsure which Organizational Level to choose, look up the Org Code you wish to query in Banner. Instructions are available in our Knowledge Base.

View Information [for Crystal Report]:
View: FE.Endow.Profile
View: FG.Fund.Profile
View Help: PDF icon FG.Fund.Profile [.pdf]
View: FG.Transaction.Det.Operating
View Help: PDF icon FG.Transaction.Det.Operating [.pdf]

Multi Period Endowment Details WEB Report

File Multi Period Endowment Details CRYSTAL Report

Description, Prompting Query Fields, Help Documentation

Last modified:
2007-01-31

Description:
Displays all transaction details in an Endowment fund (Fund starting with '6') from the beginning of a queried fiscal year to the end of a queried fiscal period. Does not contain previous month balance forwards.
Note: Use "Multi Period Fund details" for transaction details in the Spendable Income Fund.

Report Help:
Prompting Query Fields:
- Fiscal Year
- Ending fiscal period
- Fund code

View Information [for Crystal Report]:
View: FE.Endow.Transactions.Det

Faculty Consolidated Endowment Statement WEB Report

File Faculty Consolidated Endowment Statement CRYSTAL report

Description, Prompting Query Fields, Help Documentation

Last modified:
2007-01-31

Description:
Displays a summary of activity by Fiscal Period for all Endowment Funds under a Faculty ORG code. Information includes investment book value, MIP Units held and market value.

Report Help:

Prompting Query Fields:
- Fiscal Year
- Ending fiscal period
- Fund code

View Information [for Crystal Report]:
View: FE.Endow.Periodic.Statement
View Help: PDF icon FG.PERIODIC ENDOWMENT STATEMENT [.pdf]

Department Consolidated Endowment Statement WEB Report

File Department Consolidated Endowment Statement CRYSTAL Report

Description, Prompting Query Fields, Help Documentation

Last modified:
2007-01-31

Description:
Displays a summary of activity by Fiscal Period for all Endowment Funds under a Department ORG code. Information includes investment book value, MIP Units held and market value.

Report Help:

Prompting Query Fields:
- Fiscal Year
- Ending fiscal period
- Fund code

View Information [for Crystal Report]:
View: FE.Endow.Periodic.Statement
View Help: PDF icon FG.PERIODIC ENDOWMENT STATEMENT [.pdf]