trending_up Reporting

OBI Dashboard: PCard Efficacy (PCE)

The OBI PCard Efficacy (PCE) Dashboard provides reports and visualizations about how organizations and employees use the Purchasing Card (PCard) and how quickly PCard transactions are processed. The dashboard provides high level reporting on:

  • Counts of all transactions vs. those that were withdrawn or returned before prior to approval, displayed by organization or employee
  • Average processing times for verifications and approvals, including how these averages trend over time
  • PCard transactions by a range of dates and dollar amounts
  • PCard spending grouped by card holder, verifier, and approver
  • PCard transactions by expenditure type and merchant category code description

PCard transactions of all statuses are included in the statistics, unless where noted.  The verifier listed is the verifier at the time of the PCard transaction


Common Drills for PCard Transaction Details

Drilling on counts or dollar amounts displays the  PCard Detail Drill, which provides details about the credit card transaction, including credit card roles, credit card transaction ID number, personal expense indicator, merchant, processing dates, amounts and business purpose.

Drilling on the Transaction ID Number, found on the PCard Detail Drill and some of the reports, displays the PCard Transaction Detail Drill, which provides data similar to the PCard Detail Drill plus approval history.

 

Launch OBI PCard Efficacy Dashboard

Select this link... ...for reports about
PCard Withdrawn by Org Shows data on PCard transactions that were withdrawn prior to final approval. Displays graphical and tabular views of withdrawn vs. not withdrawn PCard transactions by organization.
PCard Returned by Org Shows data on PCard transactions that were returned prior to final approval. Displays graphical and tabular views of returned vs. not returned PCard transactions by organization.
PCard Verifier Stats Shows data on PCard transactions that were returned or withdrawn prior to final approval. Displays graphical and tabular views of transactions by verifier.
PCard Processing Stats Shows PCard transaction counts and displays the average processing times for verifications and approvals. Graphically displays how these averages trend over time.
PCard Transactions in Range Shows PCard transactions and amounts within the specified dollar range amounts.
PCard Detail by Employee Shows spending of PCard transactions data by cardholder, verifier, and approver.
PCard Detail by Expenditure Type Shows PCard Transactions data grouped by expenditure type and merchant MCC description.

 

Shows data on PCard transactions that were withdrawn prior to final approval. Displays graphical and tabular views of withdrawn vs. not withdrawn PCard transactions by organization.

Launch OBI PCard Withdrawn By Org

  • How many PCard transactions within my organization have been withdrawn by the verifier?
  • By organization, what percentage of total PCard transactions have been withdrawn?

For best results, be sure to follow the Selection Criteria instructions near the top of the screen. Refer to Using Selection Criteria for OBI Reports for more guidance.

Displays graphical and tabular views of withdrawn vs. not withdrawn PCard transactions by organization. The report includes transactions that have been withdrawn prior to being approved.

Drilling on the transaction counts will display details about each transaction. Subsequently drilling on the SU Credit Card Transaction ID Number displays the credit card transaction detail, including aging data and approval history.

Only the first transaction withdrawal is counted, so any subsequent withdrawals prior to approval are not included in the count.

For a list of fields available to include in report customizations, refer to Data Fields Available in PCE Dashboard.

Shows data on PCard transactions that were returned prior to final approval. Displays graphical and tabular views of returned vs. not returned PCard Transactions by organization.

Launch OBI PCard Returned by Org

  • By organization, how many PCard transactions have been returned by an approver?
  • By organization, what percentage of total PCard transactions have been returned?

For best results, be sure to follow the Selection Criteria instructions near the top of the screen. Refer to Using Selection Criteria for OBI Reports for more guidance.

 

Displays graphical and tabular views of returned vs. not returned PCard Transactions by organization. The report includes transactions that have been returned prior to being approved.

Drilling on the transaction counts will display details about each transaction. Subsequently drilling on the SU Credit Card Transaction ID Number displays the credit card transaction detail, including aging data and approval history.

Only the first transaction return is counted, so any subsequent returns prior to approval are not included in the count.

For a list of fields available to include in report customizations, refer to Data Fields Available in PCE Dashboard.

Shows data on PCard transactions that were returned to the verifier or withdrawn prior to final approval. Displays graphical and tabular views of returned and withdrawn transactions by verifier .

Launch OBI PCard Verifier Stats

 

  • By verifier, what is the number and percentage of PCard transactions that have been returned to the verifier by an approver?
  • By verifier, what is the number and percentage of PCard transactions that have been withdrawn by the verifier?
  • In my organization, who could benefit from more training?
  • Who is the verifier's supervisor for these transactions?

For best results, be sure to follow the Selection Criteria instructions near the top of the screen. Refer to Using Selection Criteria for OBI Reports for more guidance.

By transaction role,  displays the number of returned, withdrawn and total PCard transactions by verifier. 

  • Displays tabular and graphic views. The bar charts display up to 25 bars.
  • Toggle the view between  Verifier Full Name or Verifier Supervisor Full Name to update the table and diagram accordingly.

 

Only the first transaction return is counted, so any subsequent returns prior to approval are not included in the count.

Only the first transaction withdrawal is counted, so any subsequent withdrawals prior to approval are not included in the count.


Drilling on the transaction counts will display details about each transaction. Subsequently drilling on the SU Credit Card Transaction ID Number displays the credit card transaction detail, including aging data and approval history.

For a list of fields available to include in report customizations, refer to Data Fields Available in PCE Dashboard.

 Shows PCard transaction counts and displays the average processing times for verifications and approvals. Graphically displays how these averages trend over time.

Launch OBI PCard Processing Statistics

Transactions that are pending approval or were force cleared are not included in these metrics. Data about force cleared transactions can be found on the OBI Dashboard: Force Clear Metrics

  • How long has it taken by organization to fully process (submit and approve) a PCard transaction?  
  • How long on average are the verifiers in my organization taking to submit a PCard transaction for approval?  How long are the approvers taking to approve a PCard transaction?  
  • What are the trends for processing time within my organization?
  • What is the average time, by cardholder, to process and approve a PCard transaction?

 

For best results, be sure to follow the Selection Criteria instructions near the top of the screen. Refer to Using Selection Criteria for OBI Reports for more guidance.

 

Aging of Transactions

Aging of Transactions displays by organization or transaction role the PCard transaction count, average number of days to submit, and average number of days to approve.  Drilling on the transaction counts will display details about each transaction. Subsequently drilling on the SU Credit Card Transaction ID Number displays the credit card transaction detail, including aging data and approval history.

The following view by options are available:

Note: When Approver Full Name is listed as "Unknown" it is an indication that an end route approval was included.

For department credit cards where the department name is the cardholder, the credit card custodian is displayed as the cardholder.


Average Processing Times

Average Processing Times displays the average processing times (verifications or approvals) by month during the time range specified in the selection criteria.

Average processing approval time is calculated based on the elapsed time between the Original Submit Date and the Latest Approval Date for fully approved transactions. 

Average processing verification time is calculated based on the elapsed time between the SU Credit Card Posted Date and Original Submit Date for fully approved transactions.

 


PCard Dates Defined

Expense Incurred Date The date the credit card transaction occurred
SU Credit Card Posted Date The date that the transaction was posted into the AP Oracle module from the bank file
SU Credit Card Original Submit Date The date the verifier first submits the verified transaction for approval
Latest Approval Date The date that the final approval occurred for a fully approved transaction

Processing Times

OBI PCE Aging Diagram

 

 

 

 

 

 

 

 

For a list of fields available to include in report customizations, refer to Data Fields Available in PCE Dashboard.

Shows PCard transactions and their associated amounts within the dollar amounts specified in the prompts. 

Launch OBI PCard Transactions in Range

  • How can I focus on and analyze those transactions based on specific transaction amount ranges?

For best results, be sure to follow the Selection Criteria instructions near the top of the screen. Refer to Using Selection Criteria for OBI Reports for more guidance.

 

PCard Transactions in Range displays PCard transactions that fall within the range of the selected amounts.  This report allows you to narrow your search on transactions and perform more efficient analysis of certain transaction amounts.

Note: When Approver Full Name is listed as "Unknown" it is an indication that an end route approval was included or that the transaction is not yet approved.


PCard Transaction Detail Drills

Drilling on the SU Credit Card Transaction ID Number displays the credit card transaction detail, including aging data and approval history.

For a list of fields available to include in report customizations, refer to Data Fields Available in PCE Dashboard.

Displays PCard spending data and returns of PCard transactions by cardholder, verifier, and approver. 

Launch OBI PCard Detail by Employee

  • How is the workload of PCard processing distributed throughout my organization?
  • Which cardholder has the highest dollar amount of PCard transactions over a period of time?
  • Where should I focus on training when it comes to minimizing PCard returns and reducing resubmissions?

 

For best results, be sure to follow the Selection Criteria instructions near the top of the screen. Refer to Using Selection Criteria for OBI Reports for more guidance.

Toggle the view between All PCard Transactions By Amount And Count or Returned PCard Transactions By Amount And Count for the following reports.


View by All PCard Transactions by Amount and Count

For each employee and their transaction role (cardholder/custodian, verifier, and approver) displays total transaction amount and count, including percentage of totals.

  • The same data from the Verifier and Approver perspective is displayed in the other report sections.
  • Toggle the view between  By Amount or By Transaction Count to update the bar charts accordingly. The bar charts display up to 25 bars.
  • Drilling on the amounts will display the PCard Detail Drill report which will provide the detail on each of the transactions.

Note: When Approver Full Name is listed as "Unknown" it is an indication that an end route approval was included or that the transaction is not yet approved.


View by Returned PCard Transactions by Amount and Count

For each transaction role (cardholder, verifier, and approver) displays returned PCard transactions by amount and counts, including percentage of totals.

  • The same data from the Cardholder and Approver perspective is displayed in the other report sections.
  • Toggle the view between  By Amount or By Transaction Count to update the bar charts accordingly. The bar charts display up to 25 bars.
  • Drilling on the amounts will display the PCard Detail Drill report which will provide the detail on each of the transactions.

Note: When Approver Full Name is listed as "Unknown" it is an indication that an end route approval was included or that the transaction is not yet approved.

For a list of fields available to include in report customizations, refer to Data Fields Available in PCE Dashboard.

Shows PCard Transactions data grouped by expenditure type and merchant category code  (MCC) description.

Launch OBI PCard Detail by Expenditure Type

  • For my organization, what is the PCard activity by merchant category code (MCC) description?
  • How much are we spending by expenditure type and what is our distribution of spending across expenditure types?  

For best results, be sure to follow the Selection Criteria instructions near the top of the screen. Refer to Using Selection Criteria for OBI Reports for more guidance.

 

By organization, displays a summary by amount, count and percentages by the expenditure type or the merchant category code (MCC) code.

  • Toggle the view between  By Amount or By Transaction Count to update the pie chart accordingly.
  • The pie chart displays the top 10 of the table results.
  • Drilling on the amounts will display the PCard Detail Drill report which will provide the detail on each transaction for that expenditure type or MCC description

 

For a list of fields available to include in report customizations, refer to Data Fields Available in PCE Dashboard.

Last Updated: Feb 20, 2024