Fee Report

The Fee report provides a detailed breakdown of all Worldpay and Passthrough (Interchange) fees associated with transactions. The report can be scheduled based upon either activity (post) or settlement (funds transfer) day. Worldpay produces this report either daily or for the previous calendar month.

Filename Syntax

The syntax of the report filename is:

Financial_Summary_FeeReportByActivityDate${ReportCategoryId}${currency}_${organizationI d}_${targetDay}

or

Financial_Summary_FeeReportBySettlementDate${rptCategoryId}${currency}_${organizationId}_${targetDay}

where

• rptCategoryId is the ID of the Reporting Group to which the report applies. If the report is not filtered by Reporting Group, this value is replaced by a 0.

• currency is the settlement currency. If the report includes all currencies, this value is replaced by a 0.

• organizationId is the ID of the parent merchant organization

• targetDay is the date to which the data applies

Report Structure

The table below provides information about the fields included in the report. The report fields are in the order presented in the table.

Field Name	Data Type	Max Size	Description
Reporting Group	Alphanumeric	50	The Reporting Group to which the transaction belongs.
Reporting Group Type	Alphanumeric	50	The type of Reporting Group: Transactional, if this Reporting group is at a transaction level (the ones submitted with the transactions) or Rollup, if this contains child Reporting Group.
Payment Type	Alphanumeric	50	The method of payment (Visa, MasterCard, etc.) for this transaction.
Settlement Currency	Alphanumeric	5	The currency used for the settlement, designated by a three-character abbreviation of the country.
Fee Category Type	Alphanumeric	20	Defines the Fee type as either Worldpay Fee or Passthrough Fee.
Fee Category	Alphanumeric	20	The primary category.
Fee Sub-Category	Alphanumeric	20	The secondary category.
Description	Alphanumeric	350	A text description of the fee.
Txn Count	Numeric	19	The total number of transactions to which the fee applies.
Fee per Txn	Signed Decimal (13,4)	21	The flat rate amount assigned to each transaction.
Txn Amount	Signed Decimal (15,3)	20	The total dollar amount to which this fee applies.
Txn % Fee	Signed Decimal (15,3)	12	The percent rate assigned to the total amount of transactions.
Total Fees	Signed Decimal (15,3)	20	Total fee charge based on the flat rate and percent rate
Presenter	Alphanumeric	15	The name of the Presenter. This field is empty for Payment Facilitators using aggregate accounting.
Merchant Name	Alphanumeric	50	The name of the merchant. This field is empty for Payment Facilitators using aggregate accounting.
Merchant ID	Alphanumeric	50	The value of the merchantId element/attribute submitted in the cnpAPI transaction. This field a value of Unknown for Payment Facilitators using aggregate accounting.
Billing Profile Id	Numeric	19	The unique identifier of the merchant’s Billing Profile within our system.