Data Exports

Estimated reading: 2 minutes

You can perform several exports of your account in CSV, EXCEL, or JSON formats from your Portail Marchand. To do this, configure your search using the filters available on the desired export page, click “Search” then “Export”. Within seconds, you will receive the file by email and can download it at any time from your Portail Marchand Account Exports

1. Card Transaction Export

This export allows you to obtain the details of card transactions you have processed over a given period.
This export simplifies the reading of your card transactions by aggregating authorization and debit operations, and presents additional data specific to card transactions.

The export contains the following data:

Designation	Meaning
`transaction_creation_date`	creation date
`transaction_id`	transaction ID
`transaction_amount`	amount
`transaction_currency`	currency
`transaction_payout_amount`	settlement currency value
`transaction_payout_currency`	settlement currency
`transaction_commision_amount`	transaction fees
`transaction_commision_currency`	fee currency
`transaction_fee_amount`	fixed fees per transaction
`transaction_3ds`	3DS (0=no, 1=yes)
`transaction_description`	merchant-defined description
`transaction_source`	EC E-commerce, DP Deposit, MO Mail order
`transaction_bank_code`	bank authorization response
`transaction_status`	transaction status
`transaction_authorization_status`	authorization status
`transaction_authorization_code`	authorization code
`transaction_capture_status`	capture status
`transaction_capture_date`	capture date
`transaction_capture_amount`	capture amount
`merchant_transaction_id`	merchant transaction ID
`point_of_sale_id`	point of sale ID
`point_of_sale_name`	point of sale name
`merchant_id`	merchant ID
`merchant_name`	merchant name
`dispute_amount`	dispute amount
`dispute_currency`	dispute currency
`dispute_date`	dispute date
`refund_amount`	refund amount
`refund_currency`	refund currency
`refund_date`	refund date
`card_id`	payment card ID
`card_first6`	first 6 digits of card
`card_last4`	last 4 digits of card
`card_cardholder_name`	cardholder name
`card_cardholder_email`	cardholder email
`card_type`	card type (credit/debit/prepaid)
`card_product`	card product name (Infinite, Gold…)
`card_product_type`	consumer or corporate card
`card_commercial_brand`	card network (VISA/Mastercard/CB)
`card_region`	card origin continent
`card_country`	card origin country
`card_establishment_name`	name of card-issuing institution
`customer_id`	customer ID
`end_user_ip`	user IP
`end_user_language`	user language
`browser_user_agent`	user browser
`receipt_email`	user reception email
`clearing_number`	clearing number
`merchant_category_code`	merchant activity

Access:

Recette Portail Marchand – Transactions

Production Portail Marchand – Transactions

2. Card Refund Export

This export allows you to obtain the details of card refunds you have processed over a given period.

Access:

Recette Portail Marchand – Card Refunds

Production Portail Marchand – Card Refunds

3. Card Transaction Disputes Export

This export allows you to obtain the details of card transaction disputes/chargebacks you have received over a given period.

Access:

Recette Portail Marchand – Card Disputes

Production Portail Marchand – Card Disputes

4. Subscriptions Export (Cards and SDD)

This export allows you to obtain the details of card and SDD subscriptions you have processed over a given period.

Access:

Recette Portail Marchand – Subscriptions

Production Portail Marchand – Subscriptions