17-3. Standard Reports in the Servicing Bank’s EAS

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.
Report Report Description
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.