Wirecard Documentation

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

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

Invoice Number

opt.

String

Text

Unique identifier of invoice or cancelation.

M/D

Invoice State

man.

String

Text

Values: Signed or Canceled.

M/D

Invoice Type

man.

String

Text

Values: Invoice or Cancelation.

M/D

Reference Invoice ID

opt.

String

Text

ID of invoice to which the cancelation was signed for.

M/D

Billing Period

opt.

yyyy-mm-dd

Date Interval

Period we are picking the transactions for.

M/D

Merchant Account Name

man.

String

Text

Name of the merchant account.

M/D

Merchant Account ID

man.

String

Text

ID of the merchant account.

M/D

Card Brand

man.

String

Text

Values: Visa, MasterCard, etc.

M/D

Acquirer

man.

String

Text

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

M/D

Card Type

man.

String

Text

Values: Debit, Credit and Commercial.

M/D

Region Type

man.

String

Text

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

M/D

Invoice Currency

man.

String

ISO

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

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

Text code, such as EUR, not numeric 978.

M/D

Settlement Amount

man.

Float

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

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

M/D

Transaction Count

man.

Number

Count of transactions of same type within same invoice.

Fee Type

man.

String

Text

Values: Turnover, Transaction, etc.

M/D

Fee Name

man.

String

Text

Values: Discount, Authorization. etc.

M/D

Fee State

man.

String

Text

Successful / Unsuccessful

M/D

Fee Amount

opt.

Float

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

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

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

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

Merchant Function ID

Text

String

Text

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

Merchant Job ID

Text

String

Text

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

Schedule and Execution

The ICF-Overview Report is scheduled on a regular basis on the 8^th 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.