Skip to main content
AFARS

AFARS

Change Number: 2024-0712
Effective Date: 07/12/2024

17-2. Reports for Monitoring and Oversight

17-2. Reports for Monitoring and Oversight

Reports listed in the Tables 17-2 through 17-11 are provided by the servicing bank for A/OPCs, BOs, and CHs to utilize to assist in managing the GPC program. These reports should be used for program oversight, assessments, and PMRs. Reports are not limited to those listed below.

Table 17-2: Recommended Reports for Monitoring and Oversight

Report Purpose
Insights on Demand
Findings and Determinations View all case findings and determinations
Exceptions by Type View all data mining cases by type
U.S. Bank Access Online – Program Management
Account List View all card and managing accounts in your program.
Account Spend Analysis View the number of transactions and dollars spent in a specified time period. Check for inactive accounts.
Past Due View managing accounts that are currently past due.
Order File History Check to see if orders were created before making a purchase.
U.S. Bank Access Online – Financial Management
Transaction Detail View CHs’ data in the Comments tab (including Contingency Operations and 889 Custom Fields tab). View sales tax charged on transactions.
Transaction Summary View whether CHs uploaded their purchase file into U.S. Bank.
Full Transaction and Order Detail View specific descriptions of what was purchased. Select Transaction Line Item Detail only and Excel.
Managing Account Approval Status View the certification status of managing accounts and date on which they were certified. This report is helpful for identifying managing accounts that need certification after the end of the billing cycle.
U.S. Bank Access Online – Supplier Management
Merchant Spend Analysis Track CH spending patterns from various merchants
Top Merchant Spend Analysis View top merchants from whom CHs are purchasing. You can customize the number shown (e.g., top 10, 25, 50).
U.S. Bank Access Online – Administration
System User List Check user profiles to confirm whether they are active or inactive. View the Functional Entitlement Group for users in your program.
U.S. Bank Access Online – Flex Data Reporting
Flex Data Report Create a custom report showing selected data.
U.S. Bank Access Online – Custom Reports
Certification and Payment Report View the exact dates on which accounts were certified and payments were made. This report is helpful for identifying managing accounts that need certification after the end of the billing cycle. This report also includes interest charged to delinquent accounts. Allows users to view accounts over multiple billing cycles.
Payment and Prompt Payment Act Interest Penalty Transactions View all payments, including interest charged to delinquent accounts. Allows you to view only one billing cycle at a time.
All Convenience Check Transactions Monitor convenience check activity.
PIEE Electronic Data Access (EDA)
JAM Detailed GPC Appointment Status Report View appointment status of CHs, BOs, and A/OPCs
JAM GPC Training Report View training completion dates