Quick Links

Endowment Reports

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.

Submit a Report Request Form to modify an existing report or to request the creation of a new report.


Endowment Report Templates

Endowment Fund Information WEB Report

Endowment Fund Information 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:
Endowment Fund Information[.pdf]

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

View Information [for Crystal Report]:
View: FE.Endow.Profile
View Help:Endowment Fund Profile[.pdf]

Endowment Monitoring WEB Report

Endowment Monitoring 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). Intended to assist in the monitoring and budgeting of endowment income.

Report Help:
Endowment Monitoring[.pdf]

Prompting Query Fields:
- Fiscal Year
- Organization Code
- Organization Level
- Report Type

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

Endowment Planning WEB Report

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.

Report Help:
Endowment Planning[.pdf]

Prompting Query Fields:
- Fiscal Year
- Fiscal Period
- Organization Code
- Organization Level
- Report Type
- Expected MIP Income Distribution Rate

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

Multi Period Endowment Details WEB Report

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:
Multi Period Endowment Details[.pdf]

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

View Information [for Crystal Report]:
View: FE.Endow.Transactions.Det
View Help:Endowment Transaction Details[.pdf]

Faculty Consolidated Endowment Statement WEB Report

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:
Faculty Level Consolidated Endowment Statement[.pdf]

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

View Information [for Crystal Report]:
View: FE.Endow.Periodic.Statement
View Help:Endowment Periodic Statement[.pdf]

Department Consolidated Endowment Statement WEB Report

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:
Deprtment Level Consolidated Endowment Statement[.pdf]

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

View Information [for Crystal Report]:
View: FE.Endow.Periodic.Statement
View Help:Endowment Periodic Statement[.pdf]