We’re making some updates to credit card reports and dashboards to make them easier to find and use. We’re also replacing some older reports with new ones. Here are more details.
Updating credit card reports
We’re updating a number of credit card reports to make them easier to find and use.
- You’ll notice the new naming convention of “CR PRO” or “CR ROL” at the beginning of every procurement-related or role-related custom report.
- We’ve created some new reports that show aging and reconciliation of transactions.
- The existing procurement card transactions report was split into “My” and “Find” versions so that administrators can review unverified transactions even if they are not a Procurement Card Data Entry Specialist.
- We’ve consolidated the many maintenance reports into one report for each card type with expanded prompts.
We’ll start updating credit card reports beginning this afternoon (Friday, April 9) through the end of the day Monday, April 12. These reports might not be available for use during this time period. All changes will be completed by the end of the day Monday, April 12.
Here are the reports affected by this update:
Procurement Card Reports
| Report Name | Report Description |
| CR PRO My Procurement Card Transactions Not Verified | Find procurement card transactions that have not been verified on an approved verification where you are the procurement card’s cardholder or procurement card data entry specialist. |
| CR PRO Find Procurement Card Transactions Not Verified | Find procurement card transactions that have not been verified on an approved verification. |
| CR PRO Procurement Card Reconciliation Report (Verified) | Returns procurement card transactions and associated transaction and verification fields. Only includes procurement card transaction that are included on an approved verification. Required prompts include procurement card and billing date. The report is similar to the legacy Reconciliation Report from PaymentNet. |
| CR PRO Procurement Card Reconciliation Report (Not Verified) | Returns procurement card transactions and associated transaction and verification fields. Only includes procurement card transaction that are not included on an approved verification. Required prompts include procurement card and billing date. The report is similar to the legacy Reconciliation Report from PaymentNet. |
| CR PRO Procurement Card Transaction Details | Returns verification distribution line details for procurement card transactions. |
| CR PRO Aging Procurement Card Transactions | Returns a count of procurement card transactions and the summed transaction amount for each procurement card for the aging bins of 0-30 days, 31-60 days, 61-90 days, and 91+ days. |
| CR ROL Procurement Card Roles | Returns cardholder and procurement card data entry specialist for procurement cards. |
Expense Card Reports
| Report Name | Report Description |
| CR PRO My Expense Card Transactions Not Expensed | Find expense card transactions that have not been expensed on an approved expense report where you are the expense card’s custodian or the transaction’s assigned worker. |
| CR PRO Find Expense Card Transactions Not Expensed | Find expense card transactions that have not been expensed on an approved expense report. |
| CR PRO Expense Card Reconciliation Report | Returns expense card transactions and associated transaction and expense report fields. Required prompts include expense card and billing date. The report is similar to the legacy Reconciliation Report from PaymentNet. |
| CR PRO Expense Card Transaction Details | Returns expense report distribution line details for expense card transactions. |
| CR PRO Aging Expense Card Transactions | Returns a count of expense card transactions and the summed transaction amount for each expense card for the aging bins of 0-30 days, 31-60 days, 61-90 days, and 91+ days. |
| CR ROL Expense Card Roles | Returns custodians for expense cards. |
Card Programs Management
| Report Name | |
| CR PRO Type 31 Credit Card Transactions | |
| CR PRO Credit Card Payable Ledger Reconciliation Report | |
| CR PRO Procurement Card Maintenance Report | |
| CR PRO Expense Card Maintenance Report |
Dashboard updates
The dashboard PRO Card Programs is being updated to include 3 new tabs: Procurement Card Reports, Expense Card Reports, and Card Programs Management. This dashboard may be new to many of you.
New reports
The following reports are being replaced:
| Old Report (will be removed) | Replacement Report(s) |
| CR PRO Procurement Cardholders | CR ROL Procurement Card Roles |
| CR PRO Procurement Card Transactions not Verified | CR PRO My Procurement Card Transactions Not Verified and CR PRO Find Procurement Card Transactions Not Verified |
| CR ROL Roster for Procurement Card Data Entry Specialists | CR ROL Procurement Card Roles |
| CR PRO Active Purchasing Cards with Terminated Employee | CR PRO Procurement Card Maintenance Report |
| CR PRO Active Purchasing Cards without Transactions and without Cardholder | CR PRO Procurement Card Maintenance Report |
| CR PRO Purchasing Cards with Transactions and without Cardholder | CR PRO Procurement Card Maintenance Report |
| CR PRO Central Travel Accounts without Transactions and without an Organization | CR PRO Expense Card Maintenance Report |
| CR PRO Central Travel Accounts with Transactions and without an Organization | CR PRO Expense Card Maintenance Report |