IC Fee Report

Since December 2015, the IRF (EU regulation) requires to provide reporting to all merchants with regard to the amounts invoiced to them per Aggregates. All charges must be listed in such reporting, including fees.

Description

This ICF-Overview Report contains signed invoices as well as cancelations, with their transactions, aggregated per each transaction type and total amount of fees. Data is collected every month for a previous month period in a .csv file per each merchant and delivered to all merchants via the WEP document center or an SFTP server.

An ICF-Overview Report will only be generated, if there had been transactions or signed invoices during the preceding month.
Only credit card transactions are displayed in the report, no alternative payments.

Report Content

The IC-Overview Report is a .csv file, containing neither Floating ranges nor Price points for those ranges.

The regularly scheduled overview report file’s name format is: Interchange_CustomerID_MerchantShortName-MerchantAccountShortName_StartDate_EndDate_ReportPeriod.csv (ReportPeriod is "monthly").

The detailed report file’s name format is: InterchangeDetailed_CustomerID_MerchantShortName-MerchantAccountShortName_StartDate_EndDate_ReportPeriod_v1.csv (ReportPeriod is "Individual").

Some fields appear in the monthly report (Appearance = M), some in the detailed report (Appearance = D) and some in both (Appearance = M/D). If you need the fields from the detailed report (Start and End Dates are provided explicitly), please contact Merchant Support.

Field Name Cardinality (EPA) Data Type (EPA) Format Size Description Appearance

Invoice Number

opt.

String

Text

36

Unique identifier of invoice or cancelation.

M/D

Invoice State

man.

String

Text

10

Values: Signed or Canceled.

M/D

Invoice Type

man.

String

Text

15

Values: Invoice or Cancelation.

M/D

Reference Invoice ID

opt.

String

Text

36

ID of invoice to which the cancelation was signed for.

M/D

Billing Period

opt.

yyyy-mm-dd

Date Interval

25

Period we are picking the transactions for.

M/D

Merchant Account Name

man.

String

Text

40

Name of the merchant account.

M/D

Merchant Account ID

man.

String

Text

20

ID of the merchant account.

M/D

Card Brand

man.

String

Text

20

Values: Visa, MasterCard, etc.

M/D

Acquirer

man.

String

Text

10

3-letters code, eg: WDB is for Wirecard Bank.

M/D

Card Type

man.

String

Text

10

Values: Debit, Credit and Commercial.

M/D

Region Type

man.

String

Text

10

Values: Domestic, Intra-Region or Inter-Region.

M/D

Invoice Currency

man.

String

ISO

3

Text code, such as EUR, not numeric 978 (value is equal to either Settlement or Transaction Currency, depending on merchant settings).

M/D

Transaction Currency

man.

String

ISO

3

Text code, such as EUR, not numeric 978.

M/D

Transaction Amount

man.

Float

Number

Float

Including minor units. Can be negative, eg. for refunds (this is an amount of money calculated in Transaction Currency).

M/D

Settlement Currency

man.

String

ISO

3

Text code, such as EUR, not numeric 978.

M/D

Settlement Amount

man.

Float

Number

Number

Including Minor units. Can be negative, eg. for refunds (this is an amount of money calculated in Settlement Currency)

M/D

Transaction Type

man.

String

Text

40

Values: Capture, Authorization, Refund, BookPreAuth, Chargeback etc.

M/D

Transaction Count

man.

Number

Number

Number

Count of transactions of same type within same invoice.

M

Fee Type

man.

String

Text

20

Values: Turnover, Transaction, etc.

M/D

Fee Name

man.

String

Text

40

Values: Discount, Authorization. etc.

M/D

Fee State

man.

String

Text

20

Successful / Unsuccessful

M/D

Fee Amount

opt.

Float

Number

Number

This fee varies from merchant discount rate pricing, if there is any. This value in report includes minor units. Can be negative, eg. for refunds.

M/D

Interchange Fee

opt.

Float

Number

Number

Fee paid between issuing and acquiring banks for the acceptance of card based transactions. This value in report includes minor units. Can be negative, eg. for refunds.

M/D

Scheme Fee

opt.

Float

Number

Number

Deduction from MasterCard or VISA after transaction settlement. This value in report includes minor units. Can be negative, eg. for refunds.

M/D

transaction-id

man.

uuid

Text

50

A unique identifier assigned for every transaction. This information is returned in the response only.

D

Merchant Function ID

Text

String

Text

50

This ID is reserved for merchant system data and can be used for tracking purposes.

D

Merchant Job ID

Text

String

Text

50

This ID is reserved for merchant system data and can be used for tracking purposes.

D

Schedule and Execution

The ICF-Overview Report is scheduled on a regular basis on the 8th day of each month at 8 pm. The reports are generated for those merchants who requested it and had any billed credit card transactions during the preceding month. Each generated report is delivered to each merchant as .csv file via

  • the WEP

  • an SFTP Server

Please contact Merchant Support for details.