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: [Transaction Status explained]
    • 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
 
 

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, contact the Finance Help Desk: 514-398-3463 | fishelp.acct [at] mcgill.ca (Email)