Quick Links

Consolidated Faculty/Unit Financial Reports

Running these reports:

This series of reports are intended for users with unit-level financial responsibilities, and therefore having query access to all funds within a given Organization code. These complex reports draw from many data sources including the "Budget" view for operating fund budget details. You must therefore also have Budget module access to run this report – this is granted once FIS Users have completed course FIS 314 or FIS 320. If you are unsure whether you have budget access, and receive an error message when running these reports, contact the Finance Help Desk by fishelp [dot] acct [at] mcgill [dot] ca (email) or phone at 514-398-3463 to verify your FIS profile.

If you are unable to run these reports you may choose to contact someone in your Unit (with budget access) who can run the report for you. If you feel that access to these reports is integral to performing your job duties, contact your Faculty/Unit Financial Officer to discuss gaining access to Budget information.


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.


 

Financial Statement Report Templates

Financial Statements – Overview 1.0 WEB Report

Financial Statements – Overview 1.0 CRYSTAL Report

Description, Prompting Query Fields

Last modified:
2011-11-11

Description:
Displays summaries for all Fund Types under a Faculty/Unit/Department ORG code (excluding Trust funds). Information is grouped by Org code, Fund code & Account code and columns are grouped by Fund type code level 1 (Unrestricted, Restricted, Plant, etc.) & Fund type code level 2 (1A, 2C, 9X, etc)

Report Help:
Consolidated Faculty Unit Financial Reports [.pdf]

Prompting Query Fields:
- Fiscal year
- Fiscal period
- ORG code
- ORG level

Financial Statements – Schedule 1.1 – Unrestricted Fund Summary WEB Report

Financial Statements – Schedule 1.1 – Unrestricted Fund Summary CRYSTAL Report

Description, Prompting Query Fields

Last modified:
2010-03-22

Description:
Displays summaries for Fund Types 1A, 1B, 1C, 1D, 1E & 1F under a Faculty/Unit/Department ORG code.  Information is grouped by Org code, Fund code & Account code and columns are grouped by Fund type code level 1 (Unrestricted, Restricted, Plant, etc.)  & Fund type code level 2 (1A, 2C, 9X, etc)

Prompting Query Fields:
- Fiscal year
- Fiscal period
- ORG code
- ORG level

Financial Statements – Schedule 1.2 – Restricted Fund Summary WEB Report

Financial Statements – Schedule 1.2 – Restricted Fund Summary CRYSTAL Report

Description, Prompting Query Fields

Last modified:
2010-03-22

Description:
Displays summaries for Fund Types 2A – 2k & 2M under a Faculty/Unit/Department ORG code.  Information is grouped by Org code, Fund code & Account code and columns are grouped by Fund type code level 1 (Unrestricted, Restricted, Plant, etc.)  & Fund type code level 2 (1A, 2C, 9X, etc)

Prompting Query Fields:
- Fiscal year
- Fiscal period
- ORG code
- ORG level

Financial Statements – Schedule 1.3 – Plant Fund Summary WEB Report

Financial Statements – Schedule 1.3 – Plant Fund Summary CRYSTAL Report

Description, Prompting Query Fields

Last modified:
2010-03-22

Description:
Displays summaries for Fund Types 9A – 9J under a Faculty/Unit/Department ORG code.  Information is grouped by Org code, Fund code & Account code and columns are grouped by Fund type code level 1 (Unrestricted, Restricted, Plant, etc.)  & Fund type code level 2 (1A, 2C, 9X, etc)

Prompting Query Fields:
- Fiscal year
- Fiscal period
- ORG code
- ORG level

Financial Statements – Schedule 1.4 – Endowment Fund Summary WEB Report

Financial Statements – Schedule 1.4 – Endowment Fund Summary CRYSTAL Report

Description, Prompting Query Fields

Last modified:
2010-03-22

Description:
Displays summaries for Fund Types 6A, 6B & 6C under a Faculty/Unit/Department ORG code.  Information is grouped by Org code, Fund code & Account code and columns are grouped by Fund type code level 1 (Unrestricted, Restricted, Plant, etc.)  & Fund type code level 2 (1A, 2C, 9X, etc)

Prompting Query Fields:
- Fiscal year
- Fiscal period
- ORG code
- ORG level

Financial Statements – Schedule 1.5 – Spendable Income Fund Summary WEB Report

Financial Statements – Schedule 1.5 – Spendable Income Fund Summary CRYSTAL Report

Description, Prompting Query Fields

Last modified:
2013-03-20

Description:
Displays summaries for Spendable Income Funds under a Faculty/Unit/Department ORG code.  Information is grouped by Org code, Fund Type code Fund code & Account code and columns in a budget & actuals breakdown to reach spending power.  

Prompting Query Fields:
- Fiscal year
- Fiscal period
- ORG code
- ORG level


Prompting query field Organizational Level

If you are unsure which Organizational Level to choose, and have Banner access, look up the Org Code you wish to query in Banner. Instructions are available in our Knowledge Base article How To query Organization Code information (FTMORGN - Org Level & KFC).

All enquiries about Organizational Levels may be directed to the Finance Help Desk by fishelp [dot] acct [at] mcgill [dot] ca (email) or by phone at 514-398-3463.