Exporting Fee Data

You can export data on transaction fees (Worldpay, RNPLLC, and Passthrough) from the Reconciliation Dashboard. The data is listed by transaction or group of transactions and exported to a comma separated value (csv)-format file. Transaction-level data is available for export for the previous 24 months only. If the option to export is available, a CSV export icon () appears as active (not grayed-out) next to values in the Total Fees column of the following data panels:

Note that you can export the same type of data from the Fee Report main page by clicking the CSV Export icon at the top the report.

To export Fee data from the Reconciliation Dashboard:

  1. From the iQ Bar, click the Financial icon and select Reconciliation Dashboard from the list of available reports, or from the Financial Navigation bar.

  2. Select the desired view, either by Settlement Date or Activity Date.

  3. Specify the desired Date, Reporting Group, and Currency and click View to refresh the page.

  4. Click the CSV export icon () next to a Fee value in the Total Fees column. If the CSV export icon is grayed-out, adjust your date range for a start date no earlier than 24 months prior to today.

    Depending on your browser, the File Download dialog box appears.

  5. Choose an option as follows:

    • Open - opens the report in your default spreadsheet application (e.g., Microsoft Excel).

    • Save - saves the CSV file to your computer.

    • Cancel

The data listed in the table below are included in the file.

See Notes on Microsoft Excel for information on the presentation of certain data fields in exported files.

 

Fee Data Export File Field Descriptions

Field

Description

Reporting Group

The Reporting Group to which the transaction applies.

Reporting Group Type

The type of Reporting Group:

  • Transactional - if this reporting group is submitted with the transaction.

  • Rollup - if this is an aggregated Reporting Group.

Payment Type

The method of payment for this transaction or group of transactions (Visa, Mastercard, American Express, Discover, PayPal, Bill Me Later, Direct Debit).

Settlement Currency

The currency used for the settlement, designated by a three-character abbreviation of the country.

Fee Category Type

The type of fee, Worldpay, RNPLLC, or passthrough (Interchange).

Fee Category

The fee category for this fee or group of fees. Worldpay Fees are designated by one of the following product categories:

Payments Acceptance (includes Authorizations, Deposits/Refunds, Funds Transfers, Chargebacks/ Returns, Other Fees)

  • Revenue Solutions (Recovery, Account Updating, Recycling)

  • Risk Solutions (Fraud Prevention, Fraud Chargeback Prevention Service-FCPS, Vault, eProtect)

  • Customer Insight

  • Dynamic Payout (seen only by Payment Facilitators enabled for sub-merchant funding.)


Passthrough fee categories are as follows:

  • Assessments

  • Authorizations

  • Chargebacks/Returns

  • Credit Interchange

  • Debit Interchange

  • Pre-paid Interchange

  • Refund Interchange

  • Other Fees

Fee Sub-Category

The secondary fee category for Worldpay Fees, for example, Authorizations, Chargebacks/Returns, etc. See more sub-categories under the primary Fee Category description for Worldpay Fees above.

Description

The description of the fee assessed.

Txn Count

The number of transactions associated with this fee.

Fee Per Txn

The total flat rate portion of the fee assessed for this type of transaction or group of transactions.

Txn Amount

The total amount of the transaction(s) that the percentage portion of the fee was levied against.

Txn % Fee

The percentage rate portion of the fee assessed for this type of transaction, if included.

Total Fees

The total fee amount charged for this transaction or group of transactions.

Presenter

The presenter who submitted the transaction.

Note: If your organization self-presents, this field displays your organization name.

Merchant Name

The name of the parent organization (or Reporting Group) to which the transaction applies.

Merchant ID

The value of the merchantId element/attribute submitted in the cnpAPI transaction.

 

Important: Services in the United States are provided by RealNet Payments LLC, a licensed money transmitter in the jurisdictions listed here.
RealNet Payments LLC, 11000 W Lake Park Drive, Milwaukee, WI 53224 (800)729.8787
Privacy statement found here.