17-4. Custom Reports within the Servicing Bank
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. |