Fee Item Detail Report

The Fee Item Detail Report can be used to search and display Fee Items across the portfolio based on various characteristics or criteria. This report may be used to find Fee Items within pricing templates, merchant pricing profiles, hierarchy profiles, or expense rate groups. The report provides detailed information for each fee item that matches the report criteria. The report criteria is similar to the Fee Item Summary Report, but the report contains more information about each fee item.

To run the report:

1. Select Reports, and then under Pricing Reports, select Fee Item Detail.

   

   The Fee Item Detail Report page opens.

   

2. Enter your report criteria.

   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.

   • Fee Item Location

     From the drop-down list, you can select one of these fee item locations to report on:

     • Merchant Profile
     • Pricing Template
     • ERG
     • Hierarchy Profile
     • Merchant & Hierarchy Profile
   • Bank ID
   • Group ID
   • Association ID
   • Merchant ID
   • Fee Item Name
   • 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.

   • GL Item Code
   • From Start Date
   • To Start Date
   • From Stop Date
   • To Stop Date
   • User Data Code
   • Combine Code
   • Amount N/G/B

     Indicates how percentage rate fees are calculated for activity associated with the fee item. The available options are:

     • Net: Sales minus credits.
     • Gross: Sales only.
     • Both: Sales plus credits.

     Note: This field is only available for fee items with a Fee Category of Discount or Interchange.

     Fees as defined by major card brands.

     Base discount fee based on sales activity or card type.

   • Count N/G/B

     Indicates how per item rate fees are calculated for activity associated with the fee item. The available options are:

     • Net: Sales minus credits.
     • Gross: Sales only.
     • Both: Sales plus credits.

     Note: This field is only available for fee items with a Fee Category of Discount or Interchange.

     Fees as defined by major card brands.

     Base discount fee based on sales activity or card type.

   • Fee DDA Override
   • Billing Method

     Options available for the billing method are:

     • Debit
     • Remit

   • Name Address Usage Code

     Indicates which name and address record is used for a particular fee. The available options are:

     • Discount
     • RCL List
     • CRB List
     • Card Mailer
     • IRS 1099K
     • Imprinter
     • Membership
     • POS Terminal
     • Miscellaneous
     • Unique Message
     • Adjustment
     • Chargeback
     • BET 1
     • BET 2
     • BET 3
   • Stmt Fee Descript

     The Statement Fee Description.

   • Cost Plus
   • From Percent Rate (%)
   • To Percent Rate (%)
   • From Per Item Rate ($)
   • To Per Item Rate ($)
   • Sales Tax Indicator

     Options available for the sales tax indicator are:

     • Tax
     • Immune
     • Exempt
     • NA
   • Sales Tax GL Item Code

     This field is only available if you are configured to utilize Sales Tax. It can be used to group or associate similar items for GL or other reporting purposes.

   • Sales Tax User Data Code

     This field is only available if you are configured to utilize Sales Tax. It can be used to label groups of fee items for certain merchants with a client-defined value for reporting, searching, and possible re-pricing at a later time.

   • Tier Type

     You can select Volume to calculate tier rates based on the overall volume (applies at month-end), select the required Volume Tier Method, and then select the Volume Tier Based On value.

   • Include In Monthly Min

     In your report criteria, select this to report on profiles/fee items that have the Include In Monthly Min indicator selected.

   • Daily Fee Indicator

     In your report criteria, select this to report on fee items that have the Daily Fee Indicator selected, which indicates fee items billed daily rather than assessed at month-end.

   • Display Detail on Stmt

     In your report criteria, select this to report on fee items that have the Display Detail on Stmt indicator selected, which details the activity in those fee items on the merchant’s statement.

   • Display Rates on Stmt

     In your report criteria, select this to report on fee items that have the Display Rates on Stmt indicator selected, which displays the rates for those fee items on the merchant’s statement.

   • Comb Fee on Rate Change

     In your report criteria, select this to report on fee items that have the Combine Fee on Rate Change option selected.

     Combine Fee on Rate Change is used if a rate changes mid-month. Normally when a rate change occurs, two line items will display on the statement, one for each set of activity that applied to each rate. The Combine Fee on Rate Change option allows the user to combine both line items into one item on the merchant’s statement. The merchant will see one line item, with a total of the calculated fees from the month, regardless of what rate was applied throughout the month.

   • Pass Thru Rate Method

     In your report criteria, select the fee item pass through rate method to report on:

     • Interchange
     • Expense
     • Card Brand Fees
   • Apply 100% Exp Rate Method

     In your report criteria, select the type of fee item expense rate method to report on:

     • Interchange

       When this option is selected for a fee item, 100% of the Interchange fee amount is applied as expense to the agent.

       This option is only available for fee items with a Fee Category of Interchange or 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).

       Fees as defined by major card brands.

     • Card Brand Fees

       When this option is selected for a fee item, 100% of the card brand fee amount is applied as expense to the agent.

       This option is only available for fee items with a Fee Category of Card Brand Fees.

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

   • From Qualification Per Item
   • To Qualification Per Item
   • From Qualification Percent
   • To Qualification Percent
   • From Exp Per Item
   • To Exp Per Item
3. Select the Offline Export Format you require, and enter the Offline Report Name (or accept the default) to help you identify the report later in the Offline Repository.
4. Select the Include Criteria On Report check box if required.
5. Select Generate.

   The Offline Repository page opens.

   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.

   

6. Once your report has run and its Status appears as Available (select Refresh as required), select its Report Name to open or save it.