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.
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.
Advances and Expense Report Templates
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
- Search criteria - enter a value for one of the three search criteria:
- FST Code
- Organization Code (any level of organization code)
- Responsible McGill ID
- Excel Friendly - choose one of the following from the drop-down menu:
- Yes
- No
- Your Data Warehouse Access - choose one of the following from the drop-down menu:
- FIS User
- Financial Services Staff/Central User
Advances & Expense Reimbursements by Fund WEB Report
Advances & Expense Reimbursements by Fund CRYSTAL Report
Description and Prompting Query Fields
Last modified:
2009-02-17
Description:
Displays all Accountable Advances and Expense Reimbursements charged to a Fund by Fiscal Year and Fiscal Period. Includes posted transactions only.
Prompting Query Fields:
- Fiscal year
- Fiscal period
- Fund code
Advances & Expense Reimbursements by Responsible ID WEB Report
Advances & Expense Reimbursements by Responsible ID CRYSTAL Report
Description and Prompting Query Fields
Last modified:
2009-08-19
Description:
Displays all Accountable Advances and Expense Reimbursements belonging to a Responsible McGill ID.
Prompting Query Fields:
- Responsible McGill ID
Advances & Expense Reimbursements by Org Code WEB Report
Advances & Expense Reimbursements by Org Code CRYSTAL Report
Description and Prompting Query Fields
Last modified:
2009-02-17
Description:
Displays all Accountable Advances and Expense Reimbursements charged to Department ORG within the Fiscal Year.
Prompting Query Fields:
- Fiscal year
- Dept. ORG code
Advances Expenses by Reference Number Search WEB Report
Advances Expenses by Reference Number Search CRYSTAL Report
Description and Prompting Query Fields
Last modified:
2009-02-17
Description:
Displays the transaction details for a specific Advance or Expense Reference Number.
Prompting Query Fields:
- Advance or Expense reference number