FST Reports

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

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

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

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.acct [at] mcgill.ca) and we will verify if the Advance is truly outstanding.

Report Help:
Outstanding Advances by FST [.pdf]

Prompting Query Fields:
- FST code

Last modified:
2012-02-01

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

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

Last modified:
2012-02-01

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

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

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]

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

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

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

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:
Internal Services – Expenditures Report [.pdf]

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

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.