Settlement summary report

2025-08-19 06:10

The settlement summary report includes information such as the total number of transactions and net settlement amount within a settlement period. The report is generated the day after settlements are processed between acquirers and banks, along with the settlement details report. You can obtain this report through the SFTP server or APO Dashboard.

Report details

The settlement summary 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 summary information is represented by the corresponding values of the parameters.

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

Parameter	Description
settlementBatchId	MANDATORY String (64) The unique ID that is assigned by the acquirer to identify a settlement period, which corresponds to the settlement batch number in the settlement summary parameter. If the acquirer does not assign settlementBatchId, APO will generate this ID.
customerId	MANDATORY String (64) The unique ID that is assigned by the acquirer to identify a merchant.
acquirer	MANDATORY String (64) The name of the acquirer that processes the transactions. The acquirer here specifically means the acquirer that provides acquiring and funds settlement services for the merchant.
summaryType	OPTIONAL String (16) The type of the settlement summary. Valid values are: `AUTHORIZATION`: indicates a summary of authorized payments within a settlement batch. `PAYMENT`: indicates a payment summary within a settlement batch. `CAPTURE`: indicates a capture summary within a settlement batch. `REFUND`: indicates a refund summary within a settlement batch. `CANCEL`: indicates a cancellation summary within a settlement batch. `DISPUTE`: indicates a dispute summary within a settlement batch. `VOID`: indicates a summary of void authorizations within a settlement batch. `TOTAL`: indicates a total settlement summary within a settlement batch. `REFUND_REVERSAL`: indicates a reversed refund summary within a settlement batch. A reversed refund occurs when the payment method is unable to correctly process the refund. The funds are returned to your account. `SETTLEMENT_FEE`: indicates the summary of 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_WITHHOLDING`: indicates the withholding of collateral funds. `RESERVE_WITHHOLDING`: indicates the withholding of reserve funds. `RESERVE_RELEASE`: indicates the release of reserve funds. `COLLATERAL_RELEASE`: indicates the release of collateral funds.
settlementTime	MANDATORY String (64) The date and time when the settlement file is generated, in the format of `YYYY-MM-DDTHH:MM:SS+hh:mm` as defined in ISO 8601.
count	MANDATORY Integer Indicates the total number of transaction records.
settlementAmountValue	MANDATORY String (16) The net settlement amount in major units of the corresponding currency (For example, USD for dollars, and JPY for yen).
settlementCurrency	MANDATORY String (3) The currency of settlementAmountValue, specified by a 3-letter currency code as defined in ISO 4217.
feeAmountValue	OPTIONAL String (16) The amount of the processing fee that is charged by the acquirer. The value of this parameter is in major units of the corresponding currency (For example, USD for dollars, and JPY for yen).
feeCurrency	MANDATORY String (3) The currency of feeAmountValue, specified by a 3-letter currency code as defined in ISO 4217.

Table 1. Parameters and descriptions in the settlement summary report

Note: Use the header parameters to parse the transaction details report. The parameter order in the report downloaded from the SFTP server and APO 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)

On the transaction day of May 6, 2025, the merchant with an ID of 21111100000xxxx had a payment transaction. After APO settled with you and you received the bank receipt, APO generated a settlement summary report in CSV. The details of the report are as follows:

copy
settlementBatchId,customerId,acquirer,summaryType,settlementTime,count,settlementAmountValue,settlementCurrency,feeAmountValue,feeCurrency
"202505051967155612 ","2111110000022047 ",ALIPAY,PAYMENT,2025-05-06T05:18:17+08:00,1,0.98,HKD,-0.02,HKD
"202505051967155612 ","2111110000022047 ",ALIPAY,TOTAL,2025-05-06T05:18:17+08:00,1,0.98,HKD,-0.02,HKD
<END>,,,,,,,,,

📎Settlement summary report- Sample 1.csv

In this example, the acquirer is Antom and the settlement currency (settlementCurrency) is HKD, and the values of the settlement amount (settlementAmountValue) under different settlement types (summaryType) are as follows:

PAYMENT: For the payment, the value of settlementAmountValue is 0.98, indicating that APO needs to pay the merchant 0.98 HKD.
TOTAL: For the total settlement amount, the value of settlementAmountValue is 0.98, indicating that after calculating the settlement amounts of payment and refund, APO needs to settle a net settlement amount of 0.98 HKD to the merchant.

Sample 2 (No transaction)

copy
settlementBatchId,customerId,acquirer,summaryType,settlementTime,count,settlementAmountValue,settlementCurrency,feeAmountValue,feeCurrency
<END>,,,,,,,,,

📎Settlement summary report-Sample 2.csv

Note: When there is no transaction, the SFTP server will not generate transaction details reports. If you need the empty report that has no transaction, you can contact APO technical support to configure it in the SFTP server.