Need Help?

Endowment Reports

Running WEB Reports

If you are having issues running WEB reports using IE, please try Chrome or Firefox.

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 Details WEB Report

File Endowment Fund Details CRYSTAL Report

Description and Prompting Query Fields

Last modified:
2007-01-31

Description:
Contains the Endowment Fund transaction details for a given fiscal year It includes account code beginning with 3 and 4. The current fund balance is calculated.

Prompting Query Fields:
- Fiscal year
- Fund code

View Information [for Crystal Report]:
View: FG.Transaction.Det.Incl.Genl

Endowment Fund Information WEB Report

File Endowment Fund Summary CRYSTAL Report

Description and Prompting Query Fields

Last modified:
2007-01-31

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

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

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

Endowment Monitoring WEB Report

Description and Prompting Query Fields

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.

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 on our Financial Services website on How to use Banner (FTMORGN) page.

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

Endowment Planning WEB Report

Description and Prompting Query Fields

Last modified:
2022-03-21

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 Endowment Market Value and 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 Endowment Market Value and Number of (MIP) Units Owned are only updated in the following fiscal period once the unitization process is run for the closed period.

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 on our Financial Service website on How to use Banner (FTMORGN) page.

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

Multi Period Endowment Details WEB Report

File Multi Period Endowment Details CRYSTAL Report

Description and Prompting Query Fields

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 and Prompting Query Fields

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

Department Consolidated Endowment Statement WEB Report

File Department Consolidated Endowment Statement CRYSTAL Report

Description and Prompting Query Fields

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

Back to top