Fund 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.


This report replaces a number of Web and Crystal Report templates. For further details, please click on the Description below.

Multi Period Fund Report

(Click on the title above to run the Web Report)

Description

Replaces the following reports under:

Miscellaneous:

  • Capture Fund Details
  • Multi Period Fund Details
  • Multi Period Fund Details by Activity
  • Monthly Fund Details by Account Type
  • Monthly Fund Details by Activity 
  • Monthly Fund Details by All Activity 

Month End Reports:

  • Monthly Fund Details

Summary Reports:

  • Monthly Fund Summary
  • Monthly Fund Summary by Account Type
  • Monthly Fund Details by Activity 
  • Monthly Fund Details by All Activity 

To run the report, the following must be selected/entered

Prompting Query Fields Possible Values
Fiscal Year Valid 2 digit fiscal year.
Starting Fiscal Period (Optional) Valid 2 digit fiscal period. This value is only required for the Multi-Period Fund Details report.
Ending Fiscal Period Valid 2 digit fiscal period.
Fund Code Valid 6 digit fund code.
Report Type

Select from the drop-down list of 3 report types:

  • Multi-Period Fund Details
  • Periodic Fund Details
  • Periodic Fund Summary
Grouping Type

Select from the drop-down list of 2 groupings:

  • Account Code
  • Activity Code
Excel Friendly

Choose one from the drop-down list:

  • Yes
  • No

Need HELP?

  • You will only be able to run these reports once you have FIS access and Data Warehouse Access (DWH). (If you received DWH access today, you will only be able to run the reports tomorrow.)
  • The data warehouse is Fund/Org secure. You will only see data (transactions) for the funds to which you have query access.
  • For help running the reports, contact the Finance Help Desk: 514-398-3463 | fishelp.acct [at] mcgill.ca (Email)

 

Back to top