Running WEB Reports
If you are having issues running WEB reports using IE, please try Chrome or Firefox.
Â鶹AV
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 BUD 314 or BUD 320. If you are unsure whether you have budget access, and receive an error message when running these reports, submit a ticket via the or by 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.
Financial Statement Report Templates
Financial Statements – Overview 1.0 CRYSTAL Report
Description and 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.)
Prompting Query Fields:
- Fiscal year
- Fiscal period
- ORG code
- ORG level
Financial Statements – Schedule 1.1 – Unrestricted Fund Summary CRYSTAL Report
Description and 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 CRYSTAL Report
Description and 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 CRYSTAL Report
Description and 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 CRYSTAL Report
Description and 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 CRYSTAL Report
Description and 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 the How To Use Banner page (FTMORGN).Â
For enquiries about all Organizational Levels submit a ticket via the or by phone at 514-398-3463.