Need Help?

PCard Reports

Procurement Card Transactions

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

Description

Displays a listing of PCard transactions (one transaction per line) according to the entered search criteria.

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

  1. Search criteria - choose one of the following from the drop-down menu:
    • Cardholder McGill ID
    • Departmental PCard Reconciler (Default FOAPAL)
    • (Default FOAPAL) for FST, Fund, Organization Code, or FFM/PI McGill ID
    • (Posted FOAPAL) for FST, Fund, Organization Code, or FFM/PI McGill ID
  2. Corresponding search value - enter a value to match the selection above*
  3. Transaction Status - choose one of the following from the drop-down menu
    • All
    • Unreconciled
    • Waiting for approval
    • Disputed
    • Approved
    • Auto-approved
  4. Starting purchase date - enter in the format dd/mm/yyyy or click on the Calendar icon
  5. Ending purchase date - enter in the format dd/mm/yyyy or click on the Calendar icon
  6. Excel Friendly - choose one of the following from the drop-down menu:
    • Yes
    • No

*NOTE: If searching by the combination default FOAPAL and entering a fund code, the report may return no results. This happens when the entered fund code does not fall within your Fund/Org Security. If this happens, refresh the report and instead of entering the fund code, enter the FFM/PI McGill ID.

 

 

Procurement Card Usage

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

Description

Displays a summary of purchases by Card Holder, with a further breakdown by Merchant (number of purchases and total amount spent), according to the entered search criteria.

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

  1. Search criteria - choose one of the following from the drop-down menu:
    • Cardholder McGill ID
    • FST, Fund, Organization Code, or FFM/PI McGill ID
  2. Corresponding search value - enter a value to match the selection above
  3. Start Date - enter in the format dd/mm/yyyy or click on the Calendar icon
  4. Purchase End Date - enter in the format dd/mm/yyyy or click on the Calendar icon

 

 

PCard Holder by ORG with Reconcilers

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

Description, Prompting Query Fields

Last modified:
2022-02-02

Description:
Displays a listing of PCard reconcilers queried by Org, with a further breakdown by Card Holder. The report also displays the default fund code and FST name associated to this default foapal.

Prompting Query Fields:
1. Org code (any level)

 
 

Need HELP?

  • You will only be able to run these reports once you have FIS access and Data Warehouse Access (DWH). (If you received DWH access today, you will only be able to run the reports tomorrow.)
  • The data warehouse is Fund/Org secure. You will only see data (transactions) for the funds to which you have query access.
  • For help running the reports, submit a ticket via the FIS Service Desk portal or by phone at 514-398-3463

 

 

Back to top