Settlement Files

This document provides an overview of the settlement file format used by iyzico for transaction settlements. It explains the structure and usage of the file, ensuring accurate financial reconciliation and reporting.

Why Use Settlement Files?

• Detailed Reporting: Provides comprehensive details of all transactions, including payments, refunds, and cancellations.

• Financial Reconciliation: Facilitates accurate reconciliation of financial records by providing detailed transaction and settlement information.

• Compliance: Ensures compliance with financial regulations by providing detailed transaction records.

Fields

Column Name	Description
transactionDate	The date of the transaction.
transactionStatus	The status of the transaction (e.g., PAYMENT, REFUND).
afterSettlement	Indicates if the transaction is after settlement.
paymentTxId	The unique identifier for the payment transaction.
conversationId	A unique identifier for the conversation or session.
paymentIP	The IP address from which the payment was made.
paymentGid	The global identifier for the payment.
price	The amount involved in the transaction.
paidPrice	The amount paid in the transaction.
installment	The number of installments for the payment.
binNumber	The bank identification number associated with the transaction.
cardFamily	The family or type of the card used.
cardAssoc	The association (e.g., VISA, MasterCard) of the card.
cardType	The type of card (e.g., CREDIT, DEBIT).
isThreeD	Indicates if the transaction used 3D Secure authentication.
buyerId	The unique identifier for the buyer.
buyerName	The name of the buyer.
buyerSurname	The surname of the buyer.
buyerEmail	The email address of the buyer.
buyerPhone	The phone number of the buyer.
paymentTxOwner	The owner of the payment transaction.
iyziCommissionRate	The commission rate applied by iyzico.
iyziCommissionFee	The commission fee applied by iyzico.
paidPriceTRY	The paid price in Turkish Lira.
settlementPriceTRY	The settlement price in Turkish Lira.
owner	The owner of the transaction.
merchantId	The unique identifier for the merchant.
merchantContactName	The contact name for the merchant.
posOrderId	The order ID associated with the POS transaction.
posName	The name of the POS (Point of Sale).
subMerchantName	The name of the sub-merchant.
subMerchantPrice	The price for the sub-merchant.
subMerchantPayout	The payout amount for the sub-merchant.
settlementReferenceCode	The reference code for the settlement.
settlementDate	The date of the settlement.
settlementAmount	The amount settled.
transaction	The type of transaction.
totalPayme	The total payment amount.
totalCano	The total cancellation amount.
totalRefund	The total refund amount.
totalRefundCano	The total refund cancellation amount.
totalRefundName	The total refund name.
AmountSettlementTotal	The total amount settled.
MerchantPayoutTotal	The total payout amount to the merchant.