Relationship Profitability Expense Rate Group Search

To search for a Relationship Profitability Expense Rate Group (RP ERG):

1. From the Actions menu, under Relationship Profitability, select Rel Prof ERG Search.

   

   The page refreshes to display the Relationship Profitability Expense Rate Group Search Criteria.

   

2. Enter the search criteria, select an Offline Export Format, and then select Search.

   Criteria Notes

   • Where a list icon or lookup icon is provided, click it to open a box where you can search for and select the criterion you want to search or report on.
   • In the Group ID and Association ID fields, you can specify a range of values by using a dash (-) between the low and high end values, and search on multiple values by using a comma (,) between each value.
   • These special characters cannot be used: : ` ^ = " < > [ ] |
   • Do not enter spaces before or after text entires.

   • Rel Prof ERG ID
   • Bank ID
   • Agent ID
   • View

     From the drop-down list, select the hierarchy level you want to search on:

     • All
     • Client Hierarchy
     • Bank Hierarchy
     • Group Hierarchy
     • Association Hierarchy
   • From Start Date
   • To Start Date
   • From Stop Date
   • To Stop Date
   • Fee Category

     These fee categories are available for selection:

     • Authorization Other

       Fees associated with the authorization of a transaction not captured under the Authorization Transaction category.

     • Authorization Transactions

       Fees associated with the authorization of a transaction.

     • Card Brand Fees

       Acquirer type fees established by the major card brands, such as MC, NABU, VS TIF, and DS Data Usage.

     • Data Capture Other

       Other capture related fees. For example, Level 3.

     • Data Capture Transactions

       Fees associated with closing out terminal, sending batches, or settling online transactions (not funded).

     • Debit Network

       Fees for the network association or issuing bank. The surcharge for calling into the network for processing, PIN based debit only (online debit).

     • Discount

       Base discount fee based on sales activity or card type.

     • EBT

       Fees associated with Electronic Benefits Transfer.

     • Exceptions

       Fees for exception-type of activity, such as chargebacks, adjustments, and retrievals.

     • Interchange

       Fees as defined by major card brands.

     • Individual Plan

       Fees based on card type and/or transaction type, such as sales, cash and credit (returns).

     • MISC Fixed Fees

       Miscellaneous fixed fees, typically for non-transactional time-frame related services, such as training, residency, profile builds, and terminal downloads.

     • MISC Per Item Fees

       Miscellaneous per item fees, typically for front-end products and services, such as call center help, training, residency, profile builds, and terminal downloads.

   • From / To Buy Rate (%)

     The percentage of the dollar volume from the activity associated with the fee item to be applied as expense to the agent.

   • From / To Buy Rate Per Item ($)

     The per item expense rate for the agent. If this is a positive value, the amount is charged to the agent. If this is a negative value, the amount is paid to the agent.

   • Fee Item Name
   • GL Item Code
   • User Data Code
   • RP ERG Type

     The Relationship Profitability Expense Rate Group (RP ERG) type. The available options are:

     • Partner Rate Group: When selected, the page refreshes to include these report criteria fields:
       • Share Based on Merchant Net Income: Select this check box to report on fee items with the Share Based on Merchant Net Income option selected.

         When this option is selected for a fee item, the system will apply the Agent Share % value against the net income collected from the merchants.

       • Residual Payment % of Sales: Enter the From and To values to report on fee items within a range of Residual Payment % of Sales values.

         The percentage of the dollar volume from activity associated with the fee item to be applied as a residual payment to the agent.

       • Residual Payment $ Per Tran: Enter the From and To values to report on fee items within a range of Residual Payment $ Per Tran values.

         The per transaction rate from the activity associated with the fee item to be applied as a residual payment to the agent.

       • Agent Share %: Enter the From and To values to report on fee items within a range of Agent Share % values.

         The percentage of the eligible net income allocated to the agent. Eligible net income is the income from merchant fees minus the expense specified for the agent.

     • ISO Rate Group
   • Agent Flat Fee/Payment

     When this option is selected for a fee item, it indicates that the Buy Rate Per Item ($) expense amount for the fee item is charged (if it is a positive value) or paid (if it is a negative value) to the agent.

     This option is only available for fee items with a Fee Category of MISC Fixed Fees.

     Miscellaneous fixed fees, typically for non-transactional time-frame related services, such as training, residency, profile builds, and terminal downloads.

   • Share Based on Merchant Net Income

     When this option is selected for a fee item, the system will apply the Agent Share % value against the net income collected from the merchants.

   • Residual Payment % of Sales (From / To)

     The percentage of the dollar volume from activity associated with the fee item to be applied as a residual payment to the agent.

   • Residual Payment $ Per Tran (From / To)

     The per transaction rate from the activity associated with the fee item to be applied as a residual payment to the agent.

   • Agent Share % (From / To)

     The percentage of the eligible net income allocated to the agent. Eligible net income is the income from merchant fees minus the expense specified for the agent.

   If you select an Offline Export Format of None, the page refreshes to list the Results Summary, and the Search Criteria panel collapses.

   

   Tip: If you want to enter new search criteria, you can expand the Search Criteria panel by selecting the plus icon.

   -or-

   If you select an Offline Export Format of PDF or Excel, the Offline Repository page opens and the search runs as an Offline Report, which you can retrieve when it becomes available.

   Report results and search results can be generated while you continue to work. These results will be located in the Offline Repository. Once the report is finished running, the Report Name will become a link which the user can select in order to access the report output and an email notification is sent to the user.

   • Each user will have their own Offline Repository.
   • Users may generate up to 40 offline reports per day.
   • The offline reports will be assigned one of the following statuses:
     • Pending: The user has launched the report and it is waiting to run.
     • In Progress: The system is currently running the report.
     • Available: The system has finished running the report and it is available to view.
     • Deleted: The user has deleted the report.
   • The Expires By column is the date the report expires, after which the report is no longer accessible by the user.
     • Reports are set to expire after 4 calendar days.
     • Reports are available up through end of day on the Expiration Date.

   To access the Offline Repository,

   1. Select Offline Repository.

      

      The screen displays a list of available reports.

   2. Select a Report Name to open or save that report.

      -or-

      Select the delete icon for a report you want to delete.

      -or-

      Select Refresh to update the status of the offline report listing.