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

NOTE: Banner Student Aid (BSA) report templates are available on the Student Funding website.

Title Report Links Documentation
Summary of Funds WEB Report |

File Summary of Funds CRYSTAL Report

Documentation
Fund FST Affiliation by Organization Code WEB Report | CRYSTAL Report Documentation
Advances & Expense Reimbursements by FST WEB Report | CRYSTAL Report Documentation
Procurement Card Transactions & Procurement Card Usage PCard Reports page
Consolidated Fund Statement Operating by FST WEB Report | CRYSTAL Report Documentation
Consolidated Fund Statement Non-Operating by FST WEB Report | CRYSTAL Report Documentation
Endowment Fund Information by FST WEB Report | CRYSTAL Report Documentation
List of Fund Delegates by FFM (Approval delegation records and Temporary Signing Authority delegation records) WEB Report |

File List of Fund Delegates by FFM CRYSTAL Report

Documentation
Future Dated Terminating Delegations (Approval delegation records and Temporary Signing Authority delegation records) WEB Report |

File Future Dated Terminating Delegations CRYSTAL Report

Documentation
List of Delegates for Organization Code and Delegation Status (Approval Delegation Records) WEB Report |

File List of Delegates for Organization Code and Delegation Status CRYSTAL Report

Documentation
Internal Services – Expenditures Report WEB Report | CRYSTAL Report Documentation
Payroll Details by FFM WEB Report |

File Payroll Details by FFM Crystal Report

Documentation

Outstanding Accountable Advances

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

Description

This report is designed to display all Outstanding Accountable Advances depending on the search criteria. The outstanding advances can be searched by FST Code, Organization Code or Responsible McGill ID. An outstanding advance is an advance that has not been accounted for with a paid expense reimbursement. Overdue refers to an accountable advance that is 30 days past the travel end date of the trip.

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

  1. Search criteria - enter a value for one of the three search criteria:
    • FST Code
    • Organization Code (any level of organization code)
    • Responsible McGill ID
  2. Excel Friendly - choose one of the following from the drop-down menu:
    • Yes
    • No
  3. Your Data Warehouse Access - choose one of the following from the drop-down menu:
    • FIS User
    • Financial Services Staff/Central User

 

Summary of Funds

Description, Prompting Query Fields, Help Documentation

Last modified:
2014-06-09

Description:
Generates a comprehensive listing of funds and grants with their own one-line financial statement summary.

Report Help:
Summary of Funds [flash file .swf]

Prompting Query Fields:
- Fiscal/Calendar year
- Fiscal Period/Calendar Month
- FST code/Organization Code/Fund Adminstrator Code/FFM McGill ID
- Revenue Accounts Only
- Excel Friendly

View Information [for Crystal Report]:
- FG.Fund.Profile
- FP.MOPS.CARDHOLDER.PROFILE
- FP.MOPS.TRANSACTION.DETAILS
- FG.PERIOD.OPERATING.STATEMENT
- FG.GRANT.SUMMARY.STATEMENT
- FG.FISCAL.YEARS
- FG.FISCAL.PERIODS
- FG.ORGN.HIER

Fund FST Affiliation by Organization Code

Description, Prompting Query Fields, Help Documentation

Last modified:
2010-03-12

Description:
Displays funds within an organization code and groups them according to the FST they belong to. Shows all unaffiliated funds under the heading NOFST. Also has an option to show only those funds without an FST (NOFST).

Report Help:
Fund FST Affiliation by Organization Code [.pdf]

Prompting Query Fields:
- Organization Level
- Organization Code
- Option for all funds or non-affiliated only

View Information [for Crystal Report]:
View: FG.Fund.Profile

Advances & Expense Reimbursements by FST

Description, Prompting Query Fields, Help Documentation

Last modified:
2009-02-17

Description:
Displays all Accountable Advances and Expense Reimbursements charged to funds that fall within a given FST jurisdiction, Fiscal Year and Fiscal Period. Contains posted transactions only.

Report Help:
Advances and Expense Reimbursement by FST [.pdf]

Prompting Query Fields:
- Fiscal year
- Fiscal period
- FST code

Consolidated Fund Statement Operating by FST

Description, Prompting Query Fields, Help Documentation

Last modified:
2012-02-01

Prompting Query Fields:
- Fiscal year
- Fiscal period
- FST code

View Information [for Crystal Report]:
View: FG.Period.Operating.Statement

Consolidated Fund Statement Non-Operating by FST

Description, Prompting Query Fields, Help Documentation

Last modified:
2012-02-01

Prompting Query Fields:
- Fiscal year
- Fiscal period
- FST code

View Information [for Crystal Report]:
View: FG.Period.Operating.Statement

Endowment Fund Information by FST

Description, Prompting Query Fields, Help Documentation

Last modified:
2009-01-16

Description:
Displays all non financial information associated to an Endowment Fund and its related Spendable Income Fund grouped by FST (Financial Services Team).

Report Help:
Endowment Fund Information[.pdf]

Prompting Query Fields:
- FST code

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

List of Fund Delegates by FFM

Description, Prompting Query Fields, Help Documentation

Last modified:
2015-12-04

Description:
Displays active and pending (waiting for approval) delegation records (Approval delegation records and Temporary Signing Authority delegation records) associated with the entered search criteria, grouped by FFM/PI name.

Prompting Query Fields:
- FST Code or the McGill ID of an Approval Delegate

View Information [for Crystal Report]:
View: FG.Fund.Delegation
View: FG.Fund.Profile

Future Dated Terminating Delegations

Description, Prompting Query Fields, Help Documentation

Last modified:
2011-12-04

Description:
Displays all delegation records (Approval delegation records and Temporary Signing Authority delegation records) with a termination date on or after the entered end date, sorted by FFM/PI name and fund code. If the end date criteria is left blank, the report will list only delegation records with no termination date.

Prompting Query Fields:
-5-digit Organization Code (any level)
-End date

View Information [for Crystal Report]:
View: FG.Fund.Delegation
View: FG.Fund.Profile

List of Delegates for Organization Code and Delegation Status

Description, Prompting Query Fields, Help Documentation

Last modified:
2011-12-07

Description:
Displays all delegation records for the entered Org meeting the selected criteria of funds with active delegations, or funds with pending delegations waiting for approval, or funds with terminated delegations, or funds with no delegations, sorted by FFM/PI ID and fund code.

Prompting Query Fields:
-5-digit Organization Code (any level)
-Document status (fund/delegation record status)

View Information [for Crystal Report]:
View: FG.Fund.Delegation
View: FG.Fund.Profile

Internal Services – Expenditures Report

Description, Prompting Query Fields, Help Documentation

Last modified:
2016-01-07

Description:
Lists internal services transactions processed via feeds. Feeds are typically used by Service Centers with large transaction volumes every month and by their very nature do not allow for approvals to be recorded prior to their posting. In keeping with Tri‐Agency requirements, this report lists these transactions so PI authorization may be obtained ‐ this authorization may not be delegated.

Report Help:
PDF icon Internal Services – Expenditures Report [.pdf]

Prompting Query Fields:
-FST Code or FFM/PI McGill ID
- Starting date
- Ending date

Payroll Details by FFM

Description

Last modified:
2016-07-18

Description:

This report generates a summary of salaries and benefits paid to the employee(s) by fund number for a specified fund holder, transaction start and end dates.  The data is grouped by fund number, and then by the individuals who were paid off that fund.

To run the report, refresh and enter the following parameters:

  • Fund Holder’s McGill ID
  • Transaction start date
  • Transaction end date

To view further details of the transactions for a particular employee, double-click on any data field for that person and the following will be displayed: position number, suffix, pay year, pay frequency, pay number, sequence number, transactions date, document number, amount, and FOAPAL string.

Notes:

  1. If no data is displayed after the report is run, it is possible that there were no salaries/benefits incurred for the transactions dates specified.
  2. When comparing the payroll details from the attached report with the payroll details run from the Multi Period Grant Details, the total payroll amount may differ.  This could be due to:
    • a. Non-Insured Benefits Pool (NIBP) credits processed through finance on account code 600071; and/or
    • b. Work Study credits processed through the Student Aid Office on a “6” account code; and/or
    • c. Any journal processed through finance affecting the salary account codes.

3. This report does not include Banner Student Aid (BSA) payments to students.