Quick Links

FST Reports

Running WEB Reports

If you cannot scroll through pages/down the page of a WEB report, you may need to run the report in a different browser. IT Services recommends using Chrome. More information about supported browsers is available in the IT Knowledge Base.

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
Outstanding Accountable Advances by FST WEB Report | CRYSTAL Report Documentation
PCard Transactions by FST WEB Report | CRYSTAL Report Documentation
Posted PCard Transactions by FST WEB Report | CRYSTAL Report Documentation
PCard Summary by FST WEB Report | CRYSTAL Report Documentation
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

 

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

Outstanding Accountable Advances by FST

Description, Prompting Query Fields, Help Documentation

Last modified:
2009-02-17

Description:
Displays ALL Outstanding Accountable Advances charged to funds that fall within a given FST jurisdiction.

PLEASE NOTE: Since these Reports are Fund/Org secure, you will only be able to view documents posted to Funds to which you have access. If an Advance was reconciled on an Expense Report to a different fund, and you do not have access to query that Fund, it is possible that it appears in the Outstanding Accountable Advances reports even though it is NOT outstanding. In such cases, email the Finance Help Desk (fishelp [dot] acct [at] mcgill [dot] ca) and we will verify if the Advance is truly outstanding.

Report Help:
Outstanding Advances by FST [.pdf]

Prompting Query Fields:
- FST code

PCard Transactions by FST

Prompting Query Fields

Last modified:
2009-08-19

Prompting Query Fields:
- FST code
- Starting transaction date
- Ending transaction date
- Status code

Posted PCard Transactions by FST

Description, Prompting Query Fields, Help Documentation

Last modified:
2009-09-19

Description:

Report Help:
Posted PCard Transactions by FST [.pdf]

Prompting Query Fields:
- Fiscal year
- Starting fiscal period
- Ending fiscal period
- FST code

PCard Summary by FST

Prompting Query Fields

Last modified:
2009-01-16

Prompting Query Fields:
- Start date
- End date
- 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
View Help:Endowment Fund Profile[.pdf]

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.