Chapter 17 – METRICS AND REPORTING

a. A/OPCs have a number of reporting tools that enable them to manage their purchase program effectively through the bank’s EAS. Most electronic reports are updated within two to three days after a transaction. However, some reports are only updated at the end of the billing cycle. A/OPCs will have access through the EAS to monitor account holder transactions at any time. By searching by account holder name or account number, A/OPCs can track account holder transactions (e.g., transactions, payments, disputes), as well as view account holder monthly statements. A/OPCs may also contact the bank’s customer service at any time to request information on a specific account.

b. Program metrics will be implemented in each contracting office to provide the SCO, A/OPCs, and key Army officials with an assessment of the risk environment and feedback as to whether card programs are satisfying overall strategic goals. All A/OPCs will utilize the reports identified in Table 17-1 and 17-2 to review performance metrics and any systemic deficiencies requiring corrective action(s).

c. A/OPCs should maximize utilization of reports available on the GPC Business IT systems web sites such as the IOD and AXOL. The reports can assist with conducting periodic and annual surveillance inspections along with overall GPC Program management. Many reports are available through the servicing bank’s EAS, IOD, and PIEE system to assist A/OPCs in the management and oversight of the GPC program. In addition to reviewing these reports, A/OPCs at all levels should perform and maintain certain metrics to assess the performance of their program. These metrics include, but are not limited to, the following:

Table 17-1: GPC Metrics

#	GPC Metric Description	GPC Metric
1	Monthly Delinquency Percentage - zero tolerance - any percentage of receivables over 180 days past due.	< 0.75% - of its total receivables over 60 days past due.
2	Span of Control - Level 4 A/OPC to Accounts (re-evaluated biennially)	1:250 accounts
3	Span of Control - Billing Official to Cardholder Accounts	1:7 accounts
4	Span of Control – Maximum number of cards per CH	3
5	Annual Assessment Checklist – Level 4 A/OPC	100% Annually
6	PMR - Level 3 A/OPC reviews all Level 4 A/OPCs	100% Every 3 Years
7	PMR - Level 2 A/OPC reviews all Level 3 A/OPCs	100% Every 3 Years
8	Convenience Check Reviews	Annually
9	Training	Prior to Issuance of GPC or prior to assuming duties
10	CH review of Account Statement Monthly	3 business days from cycle end date (19th )
11	BO Certification of Billing Statements Monthly	5 business days from cycle end date (19th )
12	Level 4 review of all BO and CH credit limits	Annually
13	Level 4 review of the ongoing need for all GPCs	Annually
14	Retention of BO financial records	6 years
15	Separation of Duties	BO, CH, RM, APO, A/OPC must be separate individuals
16	Dispute Transaction with the Servicing Bank	CH has 90 days from the date the transaction posted to the account
17	IOD Data Mining	Table 11-1, 11-2, 11-3
18	Upload transaction supporting documentation in the bank’s EAS	100% each transaction
20	Independent Receipt and Acceptance	100% each transaction
21	Rebates – percentage per spend volume on micro purchases	1.8%
22	Suspend purchasing under accounts with open data mining cases or incomplete monthly reviews	NLT 55 days after the billing cycle end date (19th)
23	A/OPCs may suspend BO Accounts with open DM cases	30 days after billing cycle end date (19th)

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

U.S. Bank Access Online features a full range of reports that enable users to analyze vital program data to support program management and vendor relationships. All Access Online reports are parameter-driven and have different parameters based on the data elements available for each report. Users can run reports by performing three basic steps:

1) Select the report. Begin by accessing the custom reports function and then navigating to and selecting the custom report you want to run.

2) Specify parameters. Set parameters for the report, such as date range.

3) Run the report. After specifying any report-specific parameters, select to run the report or save and then run the report.

Table 17-3: Summary of Standard Report Categories

Report Category	Category Description
Program management	The reports in this category enable you to monitor compliance with your organization’s program policies. You can also use these reports for general program management activities.
Financial management	These reports contain detailed transaction information, including transaction data and allocation.
Supplier management	You can use the reports in this category to manage your supplier relationships, support negotiations and manage spending by category.
Tax and compliance management	You can use the reports in this category to estimate sales/use tax, track spending for 1099/1057 vendors, and perform other regulatory reporting (e.g., with minority-owned suppliers).
Administration	You can use the reports in this category to manage the functionality you use in Access Online.
User Activity Audit reports	These reports capture activity that users take in Access Online.
Scheduled reports	These reports are standard reports that Program Administrators can set up to run on specific dates in the future.
Flex Data reports	These are basic ad hoc reports that Program Administrators create based on pre-created report templates.
Custom reports	These are complex, highly customized ad hoc reports we worked with clients to create to meet specific program management needs.

Table 17-4: Program Management Reports

Report	Report Description
Account History	This report provides information on the history of changes to accounts so that you can easily manage and track updates.
Account List	You can use this report to give you a comprehensive list of all the accounts in your program. With a single, complete list you can quickly and easily review and make decisions about your program accounts.
Account Spend Analysis	This report helps you audit CH accounts to ensure program compliance.
Account Status Change	This report lets you quickly identify an account with changes within a given period. This information lets you track correct changes and spot trends that may need addressing (e.g., a high number of lost/stolen cards).
Account Suspension	This report lets you quickly identify suspended accounts and review program policy adherence rates. You can leverage this information to manage policy guidelines.
Declined Transaction Authorizations	This report provides details of declined transaction authorizations along with related account and merchant information to help you monitor program compliance, card usage, and merchant program parameters.
Order File History	This report provides a history of your order file loading and matching to help you monitor and manage the order management function in the system.
Past Due	This report lets you quickly identify problem accounts and review program policy adherence rates. You can leverage this information to manage policy guidelines.

Table 17-5: Financial Management Reports

Report	Report Description
Full Transaction and Order Detail	This report provides full expenditure detail, including Level III data, for complete analysis of orders and transactions.
Managing Account Approval Status	This report provides a history of managing account and cardholder account statement approvals and certifications. You can use this report to track the status and progress of account approvals as they align with your internal operating procedures. In this way, you can ensure compliance with established procedures and actively manage and improve the efficiency of your program.
Order Detail	This report provides detailed order data, including line-item detail.
Transaction Detail	This report provides detailed transaction data, including merchant detail, transaction allocation information, and transaction comment data.
Transaction Summary	This report provides a summary of the transactions. It also includes information if an electronic attachment is present and/or the ability to view the attachment.

Table 17-6: Supplier Management Reports

Report	Report Description
Merchant Spend Analysis	This report gives you an overall view of total supplier base activity or total commodity type. You can use this information to support service-level and pricing requests with your suppliers.
Merchant Spend Analysis by Line Item	This report provides summary and detail information for analyzing merchant spend activity by purchasing line item to help support purchasing strategy and vendor negotiations.
Top Merchant Spend Analysis	This report lets you compare vendors based on purchase activity. When you combine this information with information on supplier service, you can put together a comprehensive profile of your key vendors.

Table 17-7: Administration Reports

Report	Report Description
System User List Detail	This report gives you detailed information about users in a single organization. You can use this report to manage the cardholders and other users who work in Access Online.
System User List	This report gives you information about user IDs and associated user profiles. The report includes a list of user hierarchy access and user functional entitlements. You can use this report to manage the cardholders and other users who work in Access Online.

Table 17-8: User Activity Audit reports

Report	Report Description
Transaction Management	You can use this report to review a detailed history of activity and changes for transaction-related actions such as transaction approval, rejection, reallocation, and extraction.
Order Management	You can use this report to track users’ actions within Order Management, including maintaining orders, matching multiple orders to transactions, and managing order receipt.
User Profiles	You can use this report to review a detailed history of activity and changes for user profile-related actions such as changing login information, contact information, updating processing hierarchy position, or adding/removing an account.
PIEE Task QUEUE	Detailed History of PIEE appointment task activity including creation and maintenance of User Profiles, Point of Contacts, Cardholder Accounts, and Managing Accounts.

In addition to the ability to access and run standard reports, the servicing bank has created custom reports available to the Army. Users can run these custom reports in three basic steps:

4) Select the report. Begin by accessing the custom reports function and then navigating to and selecting the custom report you want to run.

5) Specify parameters. Set parameters for the report, such as date range.

6) Run the report. After specifying any report-specific parameters, select to run the report or save and then run the report.

Table 17-9: Summary of Custom Reports

Account information reports	Transaction activity reports
Account Approval Status	All Convenience Check Transactions
Account List	Cash Activity Only
Accounts with High Credit Limits	Declined Transactions
Accounts with Underutilized Credit Limits	Frequent Credits by Merchant
Active Accounts with Multiple Lost/Stolen Cards	Frequent Credit Transactions
Billing/Approval Official Conflict of Interest	High Cardholder Spending by Merchant
Certification and Payment Report	Large Dollar Transactions
MCC/MAT Codes Assigned to CH Accounts	Mismatched Authorizations
	Over Limit Convenience Check Transactions
	Payment and Prompt Payment Act Interest Penalty Transactions
	Potential Split Requirement Review
	Retail Transaction
	Suspect Merchants
	Transactions at Blocked MCCs
	Transactions Without Authorization
	Transactions without Terminal IDs
	Transaction Detail
	Travel Industry Transactions
	Unusual Spending Activity

Table 17-10: Custom Reports of Account Information

Report	Report Description
Account Approval Status	This report provides a list of accounts with the approval status for each account. You can use this report to track the approval workflow for your program.
Account List	This report provides a list of accounts by one or more processing hierarchy positions or one or more reporting hierarchy positions.
Accounts with High Credit Limits	This report provides a list of accounts that have maximum credit limits over a specified amount. You can use the report to mitigate risk and review credit limits. The report presents all credit limits for analysis.
Accounts with underutilized Credit Limits	You can use this report to assist in your review of cardholder spend against the cardholder’s maximum credit limit. In this way, you can identify cardholder accounts that may need credit limit adjustments.
Active Accounts with Multiple Lost and Stolen Cards	This report lists accounts that have multiple lost and/or stolen cards. You can use the report to identify accounts that may be misusing their cards so that you can improve program management.
Billing/Approval Official Conflict of Interest	This report lists cardholder accounts that the Approving/Billing Official (A/BO) has approved in Access Online. You can use this report to identify potential lack of separation of duties between BOs and cardholders.
Certification and Payment Report	This report provides information on certification status and payment, including cycle close date, amount certified, last payment date and last payment amount. You can use this report to make sure your approvals, certifications, and payments are on track.
MCC/MAT Codes Assigned to CH Accounts	This report lists merchant category codes (MCCs)/merchant activity type (MAT) codes assigned to cardholder accounts. You can use this report to gain an overall picture of which merchants are available for cardholder purchases.

Table 17-11: Custom Reports of Transaction Activity

Report	Report Description
All Convenience Check Transactions	This report lists all convenience check transactions within your organization to help you identify trends inconvenience check transactions and possible misuse of convenience checks.
Cash Activity Only	This report provides a list of accounts that have only cash transactions, including transaction and merchant information. You can use this report to monitor program compliance.
Declined Transactions	This report lists transactions that a merchant declined at point of sale. You can use this report to monitor declined transactions, audit program compliance, and identify training needs.
Frequent Credits by Merchant	This report lists merchants who have a high number of credits as part of their overall number of transactions versus debits over a specified time period (e.g., 30 percent of all transactions between December 1 and December 31 were credits). You can use this report to identify potential card misuse at specific merchants and thereby improve program management.
Frequent Credit Transactions	This report lists accounts with a high percentage of credits relative to purchases (e.g., 30 percent credits and 70% debits). You can use this report to identify potential card misuse.
High Cardholder Spending by Merchant	This report lists cardholder accounts with a high level of spending with a specific merchant. You can use this report to identify potential card misuse, including cardholder collusion with a merchant.
Large Dollar Transactions	This report lists transactions that are over a specified purchase limit, which can help you identify possible misuse.
Mismatched Authorizations	This report lists transactions for which the authorization amount approved does not match the final transaction amount. You can use this report to help identify card misuse and improve program management.
Over Limit Convenience Check Transactions	This report lists convenience check transactions that are greater than a specified amount. You can use this report to help identify transactions that may require an independent review to mitigate risk.
Payment and Prompt Payment Act Interest Penalty Transactions	This report lists all Payment and Prompt Payment Act interest penalty transactions. You can use this report to identify timely certification and payment processing for your organization
Potential Split Requirement Review	This report lists CHs associated to the same managing account who have multiple transactions with the same vendor that total a specified amount or more over a specified number of days (e.g., Jane Doe has transactions totaling $2,000 with Quick Office Supply between January 10 and January 11). You can use this report to identify possible instances of CHs splitting a transaction among multiple dates to get around spending limits (e.g., get around a SPL of $1,500).
Retail Transaction	This report provides a list of retail transactions, including account information, merchant information, and transaction information. You can use this report to monitor policy and program compliance.
Suspect Merchants	This report provides a list of transactions with suspect merchants, including account information, merchant information, and transaction information. You can use this report to monitor policy and program compliance.
Transactions at Blocked MCCs	This report lists transactions at blocked merchant category codes (MCCs). You can use this report to track and manage vendor relationships and identify potential card misuse.
Transactions Without Authorization	The report shows transactions the cardholder did not obtain an authorization for. By tracking transactions without authorization, you can identify potential card misuse and improve program management.
Transactions without Terminal IDs	This report shows transactions for which no terminal ID was obtained. You can use this report to help identify potential card misuse and to improve program management.
Transaction Detail	This report provides detailed transaction information, including account, merchant, transaction, and allocation information. You can use this report for overall program management.
Travel Industry Transactions	This report identifies transactions (over a specified amount) from merchants in the travel industry. You can use this report to help identify potential card misuse.
Unusual Spending Activity	This report lists transactions a cardholder made on a weekend or transactions that appear to be split transactions. You can use this report to identify potential card misuse and thereby improve program management.

A/OPCs should save copies of all electronic reports that they generate, particularly statistical or summary reports. Due to the volume of information available, the bank will furnish information for a limited period (generally, 18 months or less) before archiving the data. Reports containing sensitive information (e.g., account numbers, account holder information, etc.) should be maintained in a secure location.

Ad Hoc reports provide the ability for the Army and A/OPCs to access all data elements of the BO, CH and transaction records at any time by allowing the Army A/OPCs, servicing bank, or GSA to create reports in html, Excel, text (ASCII) formats, and/or others as defined by the Army at the task order level. The servicing bank provides the capability for the Army to utilize the ad-hoc reporting functionality of the EAS Systems for any additional future reporting needs that are not listed.