Advances and Expense 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.

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.

 

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

  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

 

Advances & Expense Reimbursements by Fund WEB Report

File Advances & Expense Reimbursements by Fund CRYSTAL Report

Description, Prompting Query Fields, Help Documentation

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.

Report Help:
Advances and Reimbursements by Fund [.pdf]

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

Advances & Expense Reimbursements by Responsible ID WEB Report

File Advances & Expense Reimbursements by Responsible ID CRYSTAL Report

Description, Prompting Query Fields, Help Documentation

Last modified:
2009-08-19

Description:
Displays all Accountable Advances and Expense Reimbursements belonging to a Responsible McGill ID.

Report Help:
Advances and Reimbursements by Responsible ID [.pdf]

Prompting Query Fields:
- Responsible McGill ID

Advances & Expense Reimbursements by Org Code WEB Report

File Advances & Expense Reimbursements by Org Code CRYSTAL Report

Description, Prompting Query Fields, Help Documentation

Last modified:
2009-02-17

Description:
Displays all Accountable Advances and Expense Reimbursements charged to Department ORG within the Fiscal Year.

Report Help:
Advances and Reimbursements by Organization [.pdf]

Prompting Query Fields:
- Fiscal year
- Dept. ORG code

Advances Expenses by Reference Number Search WEB Report

File Advances Expenses by Reference Number Search CRYSTAL Report

Description, Prompting Query Fields, Help Documentation

Last modified:
2009-02-17

Description:
Displays the transaction details for a specific Advance or Expense Reference Number.

Report Help:
Advances and Expenses by Reference Number Search [.pdf]

Prompting Query Fields:
- Advance or Expense reference number