Settlement details report

2026-02-28 05:26

The settlement detail report contains transaction settlement details for all transactions within a settlement period. The report is generated when the batch settlement is processed. You can obtain this report through the SFTP server or Antom Dashboard.

Report details

The settlement details report consists of three parts: header information, transaction details, and the end-of-file <END> that appears in the last line of the report. The header information is represented by parameter names, and the settlement details are represented by the corresponding values of the parameters.

The following table shows the parameters in the settlement details report and parameter descriptions:

Parameter	Description
settlementBatchId	MANDATORY String (64) The unique ID assigned by Antom to identify a settlement period, which is the same as the settlement batch number in the settlement summary file.
customerId	MANDATORY String (64) The unique ID that is assigned by Antom to identify a merchant.
PSP	MANDATORY String (64) Payment service provider. The name of the acquirer that processes the transactions, specifically referring to the acquirer that provides acquiring and funds settlement services for the merchant.
ARN	OPTIONAL String (256) Acquirer reference number. The card acquirer generates a unique identifier for each card transaction. When the payment method is card payment, this field may have a value.
referenceMerchantId	OPTIONAL String (64) The value of this parameter needs to be the same as that of the referenceMerchantId parameter in the original payment or pre-authorization request. This field is refer to referenceMerchantId that specify in the pay (One-time Payments) API.
referenceStoreId	OPTIONAL String (64) The value of this parameter needs to be the same as that of the referenceStoreId parameter in the original payment or pre-authorization request.
transactionId	MANDATORY String (64) The unique ID that is assigned by Antom to identify a transaction. The value of this parameter follows these rules: When transactionType is `PAYMENT`, `AUTHORIZATION`, `CANCEL`, `CAPTURE`, `REFUND`, `DISPUTE`, `DISPUTE_REVERSAL`, `REFUND_REVERSAL`, `PAYMENT_REVERSAL`, `RAPID_DISPUTE_RESOLUTION` or `CDRN`, the value of this parameter is identical to paymentId.
transactionRequestId	OPTIONAL String (64) The unique ID that is assigned by the merchant to identify a transaction request. The value of this parameter is identical to the value of paymentRequestId for a payment, or the value of refundRequestId for a refund. This field is refer to the request ID that specify in the pay (One-time Payments), capture (One-time Payments) and refund API. When transactionType is `PAYMENT`, `AUTHORIZATION`, `CAPTURE`, `REFUND`, `CANCEL`, `REFUND_REVERSAL` or `PAYMENT_REVERSAL`, the value of this parameter is not empty. When transactionType is `DISPUTE`, `DISPUTE_REVERSAL`, `RAPID_DISPUTE_RESOLUTION` or `CDRN`, the value of this parameter is empty.
referenceTransactionId	OPTIONAL String (64) The unique ID assigned by the merchant that directly provides services or goods to users to identify a transaction. This parameter’s value matches referenceOrderId for transactions such as `PAYMENT`, `AUTHORIZATION`, `CAPTURE`, `REFUND`, `DISPUTE`, `DISPUTE REVERSAL`, `REFUND REVERSAL`, `PAYMENT REVERSAL`, `RAPID_DISPUTE_RESOLUTION` or `CDRN`. This field is refer to referenceOrderId that specify in the pay (One-time Payments) API.
paymentMethodType	OPTIONAL String (32) The payment method for processing the payment. See Payment methods to check the valid values. The value of this parameter is identical to that of paymentMethodType in the original payment or pre-authorization request.
wallet	OPTIONAL String (64) The name of digital wallets, such as GCash.
transactionType	MANDATORY String (64) Transaction type. Possible values are: `PAYMENT`: indicates a payment process. `REFUND`: indicates a refund process. `CANCEL`: indicates a cancellation process. `AUTHORIZATION`: indicates a pre-authorization process. `CAPTURE`: indicates a capture process after a pre-authorization process. `DISPUTE`: indicates a dispute process. `ADJUSTMENT_FEE`: indicates adjustment fees. For card payments, adjustments may be made due to changes, errors, or other reasons, including but not limited to fees or additional charges imposed or stipulated by payment system operators. `PAYMENT_REVERSAL`: indicates a payment reversal, which usually occurs with payment methods that do not support refunds to the original route. The funds will be returned to your account. `REFUND_REVERSAL`: indicates a reversed refund, which usually occurs with payment methods that do not support refunds to the original route. The funds will be returned to your account `SETTLEMENT_FEE`: indicates the settlement fee charged by the acquirer. The fee details are represented by the settlementAmountValue and settlementCurrency parameters. `DISPUTE_REVERSAL`: indicates a reversal of a successfully defended dispute. `COLLATERAL_WITHHELD`: indicates the withheld collateral funds, meaning that if Antom requires a collateral deposit from you, the collateral amount will be deducted from the settlement batch amount. `RESERVE`: indicates the withheld of reserve funds, meaning that if you need to retain part of the funds to prepare for potential refunds, and you increase the reserve threshold in Antom Dashboard, Antom will deduct the corresponding reserve amount from the settlement batch. `RESERVE_RELEASED`: indicates the release of reserve funds, meaning that when you lower the reserve threshold in Antom Dashboard, Antom will release the excess reserve funds to the settlement batch and settle them to you. `COLLATERAL_RELEASED`: indicates the release of collateral funds, meaning that if Antom no longer needs to withhold additional collateral, the excess collateral amount will be released to the settlement batch and settled to you accordingly. `RAPID_DISPUTE_RESOLUTION`: indicates a dispute process with rapid dispute resolution (RDR). `CDRN`: indicates a cardholder dispute resolution networkprocess (CARDHOLDER_DISPUTE_RESOLUTION_NETWORK).
transactionCreationTime	MANDATORY String (64) The creation time for current data, in the format of `YYYY-MM-DDTHH:MM:SS+hh:mm` as defined in ISO 8601. For example, `PAYMENT` stands for the creation time of a payment or `REFUND` stands for the creation time of a refund.
transactionUpdateTime	MANDATORY String (64) The time when the transaction status is updated, in the format of `YYYY-MM-DDTHH:MM:SS+hh:mm` as defined in ISO 8601. For example, when transactionType is `PAYMENT` and the status is updated from `PROCESSING` to `SUCCESS`.
transactionCompletionTime	MANDATORY String (64) The time when the corresponding transaction reaches a final status of success, in the format of `YYYY-MM-DDTHH:MM:SS+hh:mm` as defined in ISO 8601.
settlementInitiatedDate	MANDATORY String (64) The time when a settlement report is generated, on the day the batch settlement is processed, in the format of `YYYY-MM-DDTHH:MM:SS+hh:mm` as defined in ISO 8601.
productCode	OPTIONAL String The type of payment product that is contracted between Antom and the merchant. Valid values are: `AGREEMENT_PAYMENT`: indicates Tokenized Payment. `CASHIER_PAYMENT`: indicates One-time Payments. The value of this parameter is identical to that of productCode in the original payment or pre-authorization request.
transactionAmountValue	OPTIONAL String (16) The transaction amount, displayed in the unit of the transactionCurrency. (For example, if the currency is `USD` and the amount is $1.00, set the value of this parameter to `1.00`. Or, if the currency is `JPY` and the amount is ¥1, set the value of this parameter to `1`.)
transactionCurrency	OPTIONAL String (3) The currency of transactionAmountValue, specified by a 3-letter currency code as defined in ISO 4217.
settlementAmountValue	MANDATORY String (16) Net settlement amount after deduction of fees for orders converted to settlement currency, displayed in the unit of the settlementCurrency. (For example, if the currency is `USD` and the amount is $1.00, set the value of this parameter to `1.00`. Or, if the currency is `JPY` and the amount is ¥1, set the value of this parameter to `1`.)
settlementCurrency	MANDATORY String (3) The currency of settlementAmountValue, specified by a 3-letter currency code as defined in ISO 4217.
quoteCurrencyPair	OPTIONAL String (16) The quote currency pair. Antom uses the standard quote currency pair provided by the foreign exchange partner. The two currencies are separated by a slash and use 3-letter ISO 4217 currency codes, such as `EUR`/`USD`. This parameter is empty when the settlement currency is the same as the transaction currency.
quotePrice	OPTIONAL Decimal (20) The quoted exchange rate. For example, if quoteCurrencyPair is `EUR`/`USD`, this parameter stands for the exchange rate quotation for EUR to USD. This parameter is empty when the settlement currency is the same as the transaction currency.
paymentMethodFeeAmountValue	OPTIONAL String (16) The amount of the payment method processing fee that is charged by Antom, displayed in the unit of the paymentMethodFeeCurrency. (For example, if the currency is `USD` and the amount is $1.00, set the value of this parameter to `1.00`. Or, if the currency is `JPY` and the amount is ¥1, set the value of this parameter to `1`.)
paymentMethodFeeCurrency	OPTIONAL String (3) The currency of paymentMethodfeeAmountValue, specified by a 3-letter currency code as defined in ISO 4217.
taxFeeAmountValue	OPTIONAL String (16) The tax fee amount, displayed in the unit of the taxFeeCurrency. (For example, if the currency is `USD` and the amount is $1.00, set the value of this parameter to `1.00`. Or, if the currency is `JPY` and the amount is ¥1, set the value of this parameter to `1`.)
taxFeeCurrency	OPTIONAL String (3) The currency of taxFeeAmountValue, specified by a 3-letter currency code as defined in ISO 4217.
processingFeeAmountValue	OPTIONAL String (16) The amount of the processing fee charged for the payment processing services provided by Antom for each transaction. This parameter’s value is displayed in the unit of the processingFeeCurrency. (For example, if the currency is `USD` and the amount is $1.00, set the value of this parameter to `1.00`. Or, if the currency is `JPY` and the amount is ¥1, set the value of this parameter to `1`.)
processingFeeCurrency	OPTIONAL String (3) The currency of processingFeeAmountValue, specified by a 3-letter currency code as defined in ISO 4217.
disputeHandlingFee	OPTIONAL String (16) The amount of the fee charged by Antom to the merchant for handling a dispute. This parameter’s value is displayed in the unit of the disputeHandlingFeeCurrency. (For example, if the currency is `USD` and the amount is $1.00, set the value of this parameter to `1.00`. Or, if the currency is `JPY` and the amount is ¥1, set the value of this parameter to `1`.) This parameter has a value when transactionType is `DISPUTE`, and Antom charges or refunds the fee to you.
disputeHandlingFeeCurrency	OPTIONAL String (3) The currency of disputeHandlingFee, specified by a 3-letter currency code as defined in ISO 4217.
interchangeFeeAmountValue	OPTIONAL String (16) The fee charged by the issuing bank, displayed in the unit of the interchangeFeeCurrency. (For example, if the currency is `USD` and the amount is $1.00, set the value of this parameter to `1.00`. Or, if the currency is `JPY` and the amount is ¥1, set the value of this parameter to `1`.) This parameter has a value when paymentMethodType is `CARD`, the Interchange++ pricing model is used, and the issuing bank charges or refunds the fee to you.
interchangeFeeCurrency	OPTIONAL String (3) The currency of interchangeFeeAmountValue, specified by a 3-letter currency code as defined in ISO 4217.
schemeFeeAmountValue	OPTIONAL String (16) The fee charged by the card scheme, displayed in the unit of the schemeFeeCurrency. (For example, if the currency is `USD` and the amount is $1.00, set the value of this parameter to `1.00`. Or, if the currency is `JPY` and the amount is ¥1, set the value of this parameter to `1`.) This parameter has a value when paymentMethodType is `CARD`, the Interchange++ pricing model is used, and the card scheme charges or refunds the fee to you.
schemeFeeCurrency	OPTIONAL String (3) The currency of schemeFeeAmountValue, specified by a 3-letter currency code as defined in ISO 4217.
acquirerMarkupAmountValue	OPTIONAL String (16) The fee charged by Antom, displayed in the unit of the acquirerMarkupCurrency. (For example, if the currency is `USD` and the amount is $1.00, set the value of this parameter to `1.00`. Or, if the currency is `JPY` and the amount is ¥1, set the value of this parameter to `1`.) This parameter has a value when paymentMethodType is `CARD`, the Interchange++ pricing model is used, and Antom charges or refunds the fee to you.
acquirerMarkupCurrency	OPTIONAL String (3) The currency of acquirerMarkupAmountValue, specified by a 3-letter currency code as defined in ISO 4217.
refundFeeAmountValue	OPTIONAL String (16) The commission fee charged by Antom for a refund, displayed in the unit of the refundFeeCurrency. (For example, if the currency is `USD` and the amount is $1.00, set the value of this parameter to `1.00`. Or, if the currency is `JPY` and the amount is ¥1, set the value of this parameter to `1`.) This parameter has a value when transactionType is `REFUND`, and Antom charges the fee to you.
refundFeeCurrency	OPTIONAL String (3) The currency of refundFeeAmountValue, specified by a 3-letter currency code as defined in ISO 4217.
financingFeeAmountValue	OPTIONAL String (16) The fee amount for the installment payment charged by Antom to you, displayed in the unit of the financingFeeCurrency. (For example, if the currency is `USD` and the amount is $1.00, set the value of this parameter to `1.00`. Or, if the currency is `JPY` and the amount is ¥1, set the value of this parameter to `1`.) This parameter has a value when paymentMethodType is `CARD`, the parameter installmentsNum has a value, and Antom charges or refunds the fee to you.
financingFeeCurrency	OPTIONAL String (3) The currency of financingFeeAmountValue, specified by a 3-letter currency code as defined in ISO 4217.
rdrFeeAmountValue	OPTIONAL String (16) The fee amount for rapid dispute resolution (RDR) transactions charged by Antom to you. This parameter’s value is displayed in the unit of the rdrFeeCurrency. (For example, if the currency is `USD` and the amount is $1.00, set the value of this parameter to `1.00`. Or, if the currency is `JPY` and the amount is ¥1, set the value of this parameter to `1`.) This parameter has a value when you activates the RDR service through Antom, transactionType is `RAPID_DISPUTE_RESOLUTION`, and Antom charges or refunds the fee to you.
rdrFeeCurrency	OPTIONAL String (3) The currency of rdrFeeAmountValue, specified by a 3-letter currency code as defined in ISO 4217.
anticipationFeeAmountValue	OPTIONAL String (16) The fee amount for the settlement period acceleration charged by Antom to merchants. This parameter’s value is displayed in the unit of the anticipationFeeCurrency. (For example, if the currency is `USD` and the amount is $1.00, set the value of this parameter to `1.00`. Or, if the currency is `JPY` and the amount is ¥1, set the value of this parameter to `1`.) This parameter has a value when the buyer uses Brazilian local cards for installment payments, or when the days of delay for customer fund settlement are less than T+26, and Antom charges or refunds the fee to you.
anticipationFeeCurrency	OPTIONAL String (3) The currency of anticipationFeeAmountValue, specified by a 3-letter currency code as defined in ISO 4217.
riskDecisionServiceFeeAmountValue	OPTIONAL String (16) Risk control decision-making fee, displayed in the unit of the riskDecisionServiceFeeCurrency. (For example, if the currency is `USD` and the amount is $1.00, set the value of this parameter to `1.00`. Or, if the currency is `JPY` and the amount is ¥1, set the value of this parameter to `1`.) This fee will be charged when the merchant does not sign up for the risk control compensation capability, while will not be charged to merchants who sign up for the risk control compensation capability. This fee is only charged when transactionType is `AUTHORIZATION` and is not refundable.
riskDecisionServiceFeeCurrency	OPTIONAL String (3) The currency of riskDecisionServiceFeeAmountValue, specified by a 3-letter currency code as defined in ISO 4217.
riskManagementFeeAmountValue	OPTIONAL String (16) Risk control management fee, displayed in the unit of the riskManagementFeeCurrency. (For example, if the currency is `USD` and the amount is $1.00, set the value of this parameter to `1.00`. Or, if the currency is `JPY` and the amount is ¥1, set the value of this parameter to `1`.) The fee will be charged when the merchant signes up for the risk control compensation capability, while will not be charged to merchants who do not sign up for the risk control compensation capability. This fee is only charged when transactionType is `CAPTURE` and is not refundable.
riskManagementFeeCurrency	OPTIONAL String (3) The currency of riskManagementFeeAmountValue, specified by a 3-letter currency code as defined in ISO 4217.
fundingSource	OPTIONAL String (20) The funding type of the payment method. This parameter is returned when the value of paymentMethodType is `CARD`, `GRABPAY_MY`, or `GRABPAY_SG`. When the value of paymentMethodType is `CARD`, valid values are: `CREDIT`: indicates a credit card payment. `DEBIT`: indicates a debit card payment. `PREPAID`: indicates a prepaid card payment. `CHARGE`: indicates a charge card payment. `DEFERRED_DEBIT`: indicates a deferred debit card payment. When the value of paymentMethodType is `GRABPAY_MY` or `GRABPAY_SG`, valid values are: `WALLETS`: indicates a regular wallet payment using the wallet balance. `BNPL`: indicates a buy-now-pay-later payment.
region	OPTIONAL String (16) The region where the transaction occurred. Valid values are: `DOMESTIC`: domestic transactions, where the issuing country, acquiring country, and merchant registration country are the same. `INTRAREGIONAL`: intraregional transactions, where the issuing country, acquiring country, and merchant registration country are different, but belong to the same region. `INTERREGIONAL`: interregional transactions, where the issuing country, acquiring country, and merchant registration country are different, and do not belong to the same region.
installmentsNum	OPTIONAL String (8) Indicates the number of installment payments.
issuingCountry	OPTIONAL String (2) The issuing country or region of the card. The parameter is a 2-letter country or region code that follows the ISO 3166 Country Codes standard. This parameter is specified when paymentMethodType is `CARD`.
cardBrand	OPTIONAL String (256) The brand of the card. This parameter is specified when paymentMethodType is `CARD`.
cardCategory	OPTIONAL String (256) Card categories. The valid values are: `CONSUMER`: personal cards. `COMMERCIAL`: bussiness cards.
cdrnFeeAmountValue	OPTIONAL String (16) The fee amount for cardholder dispute resolution network (CDRN) transactions charged by Antom to you. The value of this parameter is displayed in the unit of the cdrnFeeCurrency. (For example, if the currency is `USD` and the amount is $1.00, set the value of this parameter to `1.00`. Or, if the currency is `JPY` and the amount is ¥1, set the value of this parameter to `1`.) This parameter has a value when transactionType is `CDRN`, you activates the CDRN service through Antom, and Antom charges or refunds the fee to you.
cdrnFeeCurrency	OPTIONAL String (3) The currency of cdrnFeeAmountValue, specified by a 3-letter currency code as defined in ISO 4217.
originalTransactionRequestId	OPTIONAL String (64) An identifier for the original transaction. When transactionType is `PAYMENT`, `AUTHORIZATION`, `SETTLEMENT_FEE`, `ADJUSTMENT_FEE`, `COLLATERAL_WITHHELD`, `RESERVE`, `RESERVE_RELEASED` or `COLLATERAL_RELEASED` the value of this parameter is empty. When transactionType is `CANCEL`, `CAPTURE`, `REFUND`, `DISPUTE`, `DISPUTE_REVERSAL`, `RAPID_DISPUTE_RESOLUTION`, `PAYMENT_REVERSAL` or `REFUND_REVERSAL`, the value of this parameter is identical to that of paymentRequestId of original payment or authorization request.
iofFeeAmountValue	OPTIONAL String (16) The IOF (Imposto sobre Operações Financeiras) fee is a Brazilian federal tax mandated specific financial operations including foreign exchange, credit card international settlements, and cross-border investments. The value of this parameter is displayed in the unit of the iofFeeCurrency. (For example, if the currency is `USD` and the amount is $1.00, set the value of this parameter to `1.00`. Or, if the currency is `JPY` and the amount is ¥1, set the value of this parameter to `1`.) This parameter has a value when the Brazilian federal government levies this tax.
iofFeeCurrency	OPTIONAL String (3) The currency of iofFeeAmountValue, specified by a 3-letter currency code as defined in ISO 4217.
withholdingTaxAmountValue	OPTIONAL String (16) This field indicates the amount of tax withheld at source in accordance with the relevant local tax regulations. It represents the portion of the transaction that is retained by the payer and remitted to the appropriate tax authority as withholding tax. The value is typically calculated based on the applicable tax rate and may vary depending on the nature of the transaction and the classification of the parties involved. The value of this parameter is displayed in the unit of the withholdingTaxFeeCurrency. (For example, if the currency is `USD` and the amount is $1.00, set the value of this parameter to `1.00`. Or, if the currency is `JPY` and the amount is ¥1, set the value of this parameter to `1`.) This parameter has a value when the Philippine federal government levies this tax.
withholdingTaxFeeCurrency	OPTIONAL String (3) The currency of withholdingTaxAmountValue, specified by a 3-letter currency code as defined in ISO 4217.
fxFeeAmountValue	OPTIONAL String (16) The amount of the processing fee that is charged for the FX (foreign exchange) conversion services Antom provided for each transaction. The value of this parameter is displayed in the unit of the fxFeeAmountCurrency. (For example, if the currency is `USD` and the amount is $1.00, set the value of this parameter to `1.00`. Or, if the currency is `JPY` and the amount is ¥1, set the value of this parameter to `1`.) This parameter has a value when Antom charges or refunds the fee to you.
fxFeeAmountCurrency	OPTIONAL String (3) The currency of fxFeeAmountValue, specified by a 3-letter currency code as defined in ISO 4217.
convertedTransactionAmountValue	OPTIONAL String (16) Amount after conversion of transaction amount to settlement currency, excluding fees. The amount value is displayed in the unit of the convertedCurrency. (For example, if the currency is `USD` and the amount is $1.00, set the value of this parameter to `1.00`. Or, if the currency is `JPY` and the amount is ¥1, set the value of this parameter to `1`.)
convertedCurrency	OPTIONAL String (3) The currency of convertedTransactionAmountValue, specified by a 3-letter currency code as defined in ISO 4217.
metadata	OPTIONAL String (2048) This field is refer to metadata that specify in the pay (One-time Payments) and refund API.
orderDescription	MANDATORY String (256) The description of the order. The value of this parameter is identical to that of orderDescription of the original payment or pre-authorization.
isCardOnFile	OPTIONAL String (1) This parameter is used to specify whether the transaction is a Card-on-File (COF) transaction. The valid values are: `Y`: indicates that the transaction is a Card-on-File (COF) transaction. `N`: indicates that the transaction is not a Card-on-File (COF) transaction.
isNetworkToken	OPTIONAL String (1) This parameter is used to specify whether the transaction is a Network Token (NT) transaction. The valid values are: `T`: indicates that the transaction is a Network Token (NT) transaction. `F`: indicates that the transaction is not a Network Token (NT) transaction.

Table 1. Parameters and descriptions in the settlement details report

Note: Use the header parameters to parse the transaction details report. The parameter order in the report downloaded from the SFTP server and Antom Dashboard may not match the parameter order displayed in Table 1.

Report samples

The following samples show settlement details reports in different scenarios.

Sample 1 (Standard report)

From November 24, 2024 to December 9, 2024, the merchant with an ID of 21881201642xxxxx had 17 transactions, including authorization, refund, request for capture, payment, cancellation, dispute, refund failure, settlement fee, chargeback defense, final payment, released collateral, withheld collateral, reserve, released reserve, and RDR dispute. After Antom settled with you and you received the bank receipt, Antom generated a settlement details report in CSV. The details of the report are as follows:

copy
settlementBatchId,customerId,PSP,ARN,referenceMerchantId,referenceStoreId,transactionId,transactionRequestId,referenceTransactionId,paymentMethodType,wallet,transactionType,transactionCreationTime,transactionUpdateTime,transactionCompletionTime,settlementInitiatedDate,productCode,transactionAmountValue,transactionCurrency,settlementAmountValue,settlementCurrency,quoteCurrencyPair,quotePrice,paymentMethodFeeAmountValue,paymentMethodFeeCurrency,taxFeeAmountValue,taxFeeCurrency,processingFeeAmountValue,processingFeeCurrency,disputeHandlingFee,disputeHandlingFeeCurrency,interchangeFeeAmountValue,interchangeFeeCurrency,schemeFeeAmountValue,schemeFeeCurrency,acquirerMarkupAmountValue,acquirerMarkupCurrency,refundFeeAmountValue,refundFeeCurrency,financingFeeAmountValue,financingFeeCurrency,rdrFeeAmountValue,rdrFeeCurrency,anticipationFeeAmountValue,anticipationFeeCurrency,riskDecisionServiceFeeAmountValue,riskDecisionServiceFeeCurrency,riskManagementFeeAmountValue,riskManagementFeeCurrency,fundingSource,region,installmentsNum,issuingCountry,cardBrand,cardCategory,cdrnFeeAmountValue,cdrnFeeCurrency,originalTransactionRequestId,iofFeeAmountValue,iofFeeCurrency,withholdingTaxAmountValue,withholdingTaxFeeCurrency,fxFeeAmountValue,fxFeeAmountCurrency,convertedTransactionAmountValue,convertedCurrency,metadata,orderDescription,isCardOnFile,isNetworkToken
"2024121619607xxxxx ","21881201642xxxxx ",Antom_SG,,,"  ","202411281940109000001887902628xxxxx  ","REQUEST_c900xxx  ","ORDER_065665446534XXXX   ",CARD,,,AUTHORIZATION,2024-11-28T20:11:41+08:00,2024-12-17T03:43:47+08:00,2024-12-17T03:43:47+08:00,CASHIER_PAYMENT,0,USD,-0.23346,USD,USD/USD,1,,,,,,,,,,,-0.23346,USD,,,,,,,,,,,,,,,DEBIT,,,GB,VISA,¡¤,,,,,,,,,,,,,
"2024121619607xxxxx ","21881201642xxxxx ",Antom_SG,,,"  ","202411301940108001001884902629xxxxx  ","202412010454000004_a5106d88-57f8-4b65-8191-1edff90xxxxx  ","2024120104540xxxxx   ",PAYU,,,PAYMENT,2024-12-01T04:54:58+08:00,2024-12-17T05:16:17+08:00,2024-12-17T05:16:17+08:00,CASHIER_PAYMENT,477.05,PLN,113.12,USD,USD/PLN,4.15002917,-1.72,USD,,,-0.11,USD,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
"2024121619607xxxxx ","21881201642xxxxx ",Antom_SG,,,"  ","202411301940108001001884902629xxxxx  ","9375xx   ",,PAYU,,,REFUND,2024-12-01T11:22:48+08:00,2024-12-17T05:16:17+08:00,2024-12-17T05:16:17+08:00,CASHIER_PAYMENT,-2.53,PLN,-0.93,USD,USD/PLN,4.15002917,0,USD,,,0,USD,,,,,,,,,,-0.32,USD,,,,,,,,,,,,,,,,,,"202412010454000004_a5106d88-57f8-4b65-8191-1edff90xxxxx    ",,,,,,,,,,
"2024121619607xxxxx ","21881201642xxxxx ",Antom_SG,,,"  ","202412091940109000001881402652xxxxx  ","2024120919252855801xxxxx ","2024120919252855801xxxxx ",CARD,,,CAPTURE,2024-12-09T19:27:09+08:00,2024-12-17T05:16:17+08:00,2024-12-17T05:16:17+08:00,CASHIER_PAYMENT,5.19,USD,4.86,USD,,,-0.18,USD,,,-0.15,USD,,,,,,,,,,,,,,,,,,,,,DEBIT,Interregional,,TW,VISA,,,,"2024120919252855801xxxxx  ",,,,,,,,,,
"2024121619607xxxxx ","21881201642xxxxx ",Antom_SG,,,"  ","202412021140108001001812002218xxxxx  ","1550900xxx   ","1550900xxx   ",ALIPAY_CN,AlipayCN,,PAYMENT,2024-12-02T15:37:31+08:00,2024-12-17T05:16:17+08:00,2024-12-17T05:16:17+08:00,CASHIER_PAYMENT,231.04,CNY,31.13,USD,USD/CNY,7.3115074,-0.47,USD,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
"2024121619607xxxxx ","21881201642xxxxx ",Antom_SG,,,"  ","202412021140108001001812002218xxxxx  ","202412021140108070001812002584xxxxx  ",,ALIPAY_CN,AlipayCN,,CANCEL,2024-12-02T16:57:04+08:00,2024-12-17T05:16:17+08:00,2024-12-17T05:16:17+08:00,CASHIER_PAYMENT,-231.04,CNY,-31.13,USD,USD/CNY,7.3115074,0.47,USD,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"1550900xxx   ",,,,,,,,,,
"2024121619607xxxxx ","21881201642xxxxx ",Antom_SG,,,"  ","202410131940109000001881202517xxxxx  ",,"8888202410140704493779xxxxx ",CARD,,,DISPUTE,2024-12-09T20:02:01+08:00,2024-12-17T05:16:17+08:00,2024-12-17T05:16:17+08:00,CASHIER_PAYMENT,-310.79,USD,-325.79,USD,,,,,,,,,-15,USD,,,,,,,,,,,,,,,,,,,CREDIT,Interregional,,TW,MASTERCARD,,,,"8888202410140704493779xxxxx    ",,,,,,,,,,
"2024121619607xxxxx ","21881201642xxxxx ",Antom_SG,,,"  ","202411291940108001001886902622xxxxx  ","1702880xxx   ","1432698624-8-17028xxxxx  ",MAYA,,,REFUND,2024-11-29T21:50:52+08:00,2024-12-17T05:16:17+08:00,2024-12-17T05:16:17+08:00,CASHIER_PAYMENT,-16994.1,PHP,-283.94,USD,USD/PHP,58.87302841,4.72,USD,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"1702878xxx ",,,,,,,,,,
"2024121619607xxxxx ","21881201642xxxxx ",Antom_SG,,,"  ","202411291940108013001886902405xxxxx  ","1702880xxx   ",,MAYA,,,REFUND_REVERSAL,2024-11-29T21:50:52+08:00,2024-12-17T05:16:17+08:00,2024-12-17T05:16:17+08:00,CASHIER_PAYMENT,16994.1,PHP,289.63,USD,USD/PHP,58.67423819,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"1702878xxx    ",,,,,,,,,,
"2024121619607xxxxx ","21881201642xxxxx ",Antom_SG,,,"  ",,,,,,,SETTLEMENT_FEE,2024-12-13T03:11:49+08:00,2024-12-17T05:16:17+08:00,2024-12-17T05:16:17+08:00,,,,0,USD,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
"2024121619607xxxxx ","21881201642xxxxx ",Antom_SG,,,"  ","202407091940108001001889202331xxxxx  ",,"1015202407094101892700060xxxxx  ",CARD,,,DISPUTE_REVERSAL,2024-12-09T16:00:33+08:00,2024-12-17T05:16:17+08:00,2024-12-17T05:16:17+08:00,CASHIER_PAYMENT,353680,KRW,240.05,USD,USD/KRW,1435.616775,-6.31,USD,,,,,,,,,,,,,,,,,,,,,,,,,CREDIT,Intraregional,,KR,KOOKMIN,,,,"1015202407094101892700060xxxxx ",,,,,,,,,,
"2024121619607xxxxx ","21881201642xxxxx ",Antom_SG,,,"  ","202411221940108001001883302608xxxxx  ",,"20241122100904741355820xxxxx    ",,,,PAYMENT_REVERSAL,2024-11-22T23:39:33+08:00,2024-12-17T05:16:17+08:00,2024-12-17T05:16:17+08:00,CASHIER_PAYMENT,249000,IDR,15.39,USD,USD/IDR,16174.41541,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"XYSEA_WEB_20241122100904741355820xxxxx  ",,,,,,,,,,
"2024121619607xxxxx ","21881201642xxxxx ",Antom_SG,,,"  ","202412041900000000000001200976xxxxx  ",,,,,,COLLATERAL_RELEASED,2024-12-05T03:43:19+08:00,2024-12-17T05:16:17+08:00,2024-12-17T05:16:17+08:00,,,,378.71,USD,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
"2024121619607xxxxx ","21881201642xxxxx ",Antom_SG,,,"  ","202412041900000000000001200976xxxxx  ",,,,,,COLLATERAL_WITHHELD,2024-12-05T03:43:19+08:00,2024-12-17T05:16:17+08:00,2024-12-17T05:16:17+08:00,,,,-451.87,USD,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
"2024121619607xxxxx ","21881201642xxxxx ",Antom_SG,,,"  ","202412011900000000000001200733xxxxx  "," "," ",,,,RESERVE_RELEASED,2024-12-01T03:37:48+08:00,2024-12-17T05:16:17+08:00,2024-12-17T05:16:17+08:00,,,,11.3,USD,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"    ",,,,,,,,,,
"2024121619607xxxxx ","21881201642xxxxx ",Antom_SG,,,"  ","202411291900000000000001200851xxxxx  "," "," ",,,,RESERVE,2024-11-30T03:37:48+08:00,2024-12-17T05:16:17+08:00,2024-12-17T05:16:17+08:00,,,,-3.7,USD,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"    ",,,,,,,,,,
"2024121619607xxxxx ","21881201642xxxxx ",Antom_SG,,,"  ","202411281940109000001887902628xxxxx  ","REQUEST_c900xxx  ","ORDER_065665446534XXXX   ",CARD,,,AUTHORIZATION,2024-11-28T20:11:41+08:00,2024-12-17T03:43:47+08:00,2024-12-17T03:43:47+08:00,CASHIER_PAYMENT,0,USD,-0.01,USD,USD/USD,1,,,,,,,,,,,,,,,,,,,,,,,,,,,DEBIT,,,GB,VISA,CONSUMER,,,,,,,,,,,,,
"2024121619607xxxxx ","21881201642xxxxx ",Antom_SG,,,"  ","202412091940109000001881402652xxxxx  ","2024120919252855801xxxxx ","2024120919252855801xxxxx ",CARD,,,CAPTURE,2024-12-09T19:27:09+08:00,2024-12-17T05:16:17+08:00,2024-12-17T05:16:17+08:00,CASHIER_PAYMENT,5.19,USD,4.85,USD,,,-0.18,USD,,,-0.15,USD,,,,,,,,,,,,,,,,,,,,,DEBIT,Interregional,,TW,VISA,CONSUMER,,,"2024120919252855801xxxxx  ",,,,,,,,,,
"2024121619607xxxxx ","21881201642xxxxx ",Antom_SG,,,"  ","202406101940108001001884902283xxxxx  ","202406101940108001001884902283xxxxx  ","TL01824061102033xxxxx    ",CARD,,,RAPID_DISPUTE_RESOLUTION,2024-12-09T16:50:13+08:00,2024-12-17T05:16:17+08:00,2024-12-17T05:16:17+08:00,CASHIER_PAYMENT,-875.88,USD,-875.88,USD,USD/USD,1,,,,,,,0,USD,,,,,,,,,,,,,,,,,,,DEBIT,,,US,VISA,,,,"TL01824061102033xxxxx   ",,,,,,,,,,
<END>

📎Settlement details report-Sample 1.csv

Sample 2 (No transaction)

copy
settlementBatchId,customerId,PSP,ARN,referenceMerchantId,referenceStoreId,transactionId,transactionRequestId,referenceTransactionId,paymentMethodType,wallet,transactionType,transactionCreationTime,transactionUpdateTime,transactionCompletionTime,settlementInitiatedDate,productCode,transactionAmountValue,transactionCurrency,settlementAmountValue,settlementCurrency,quoteCurrencyPair,quotePrice,paymentMethodFeeAmountValue,paymentMethodFeeCurrency,taxFeeAmountValue,taxFeeCurrency,processingFeeAmountValue,processingFeeCurrency,disputeHandlingFee,disputeHandlingFeeCurrency,interchangeFeeAmountValue,interchangeFeeCurrency,schemeFeeAmountValue,schemeFeeCurrency,acquirerMarkupAmountValue,acquirerMarkupCurrency,refundFeeAmountValue,refundFeeCurrency,financingFeeAmountValue,financingFeeCurrency,rdrFeeAmountValue,rdrFeeCurrency,anticipationFeeAmountValue,anticipationFeeCurrency,riskDecisionServiceFeeAmountValue,riskDecisionServiceFeeCurrency,riskManagementFeeAmountValue,riskManagementFeeCurrency,fundingSource,region,installmentsNum,issuingCountry,cardBrand,cardCategory,cdrnFeeAmountValue,cdrnFeeCurrency,originalTransactionRequestId,iofFeeAmountValue,iofFeeCurrency,withholdingTaxAmountValue,withholdingTaxFeeCurrency,fxFeeAmountValue,fxFeeAmountCurrency,convertedTransactionAmountValue,convertedCurrency,metadata,orderDescription,isCardOnFile,isNetworkToken
<END>

📎Settlement details report-Sample 2.csv

Note: When there is no transaction, the SFTP server and Antom Dashboard will not generate reports. If you need the empty report that has no transaction, you can contact Antom Merchant Service technical support (TechnicalService@antom.com) to configure it in the SFTP server.