Settlement Bill

• For acquiring services, since the fund statement file does not include individual transaction fund details for acquiring transactions, merchants can reconcile by combining the settlement statement with the acquiring transaction daily bill details to meet the reconciliation needs for acquiring business funds.

1. Settlement Statement Generation:

(1) The settlement cycle consists of two parts;
(2) T+N, where N represents the settlement interval;
(3) Daily, weekly, monthly, and bi-weekly represent the settlement time range;

Settlement Cycle	Settlement Date Description
T+N Days	Transactions on T day, (T+N calendar days) can be settled
T+N Weeks	Transactions in T week, can be settled on Monday of T+N week
T+N Bi-weekly	Transactions in T week, together with transactions of the following week, are settled on the Monday of T+1 week + N weeks later
T+N Months	Transactions in T month, can be settled on the 1st of T+N month

Whether it's weekly or bi-weekly, settlement is always performed on the following Monday. For monthly, it is divided into the beginning/end of the month (the first or last day of the calendar month).

2. Settlement Statement Description

(1) When there are refund orders in the settlement statement, the order creation time refers to the creation time of the refund transaction, and the order completion time refers to the completion time of the refund transaction, which are independent of the original transaction;
(2) The merchant order number for refund orders in the settlement statement is the order number of the refund transaction, not the original transaction's merchant order number. It corresponds to the refund order number (refund id) of the original transaction.

3. Settlement Statement Reconciliation

1. The settlement summary statement summarizes the total transaction amount, total fees (including handling fees, taxes, withholding taxes, etc.) and settlement amount by product, transaction currency, settlement currency, and exchange type;
2. When merchants reconcile the detailed data of settlement statements for different settlement cycles, they need to go to the backend to download transaction data for different settlement cycles by country and payment method dimension, and perform reconciliation;
3. The summary logic of the settlement summary statement is as follows:

• Net Amount (Sum) = Txn Amount (Sum) + Txn Fee (Sum) + Txn Tax (Sum) + Merchant Txn Tax (Sum)
• Net Amount (Sum): Total settlement amount (transaction currency)
• Txn Amount (Sum): Total transaction amount (transaction currency)
• Txn Fee (Sum): Total transaction fees (transaction currency)
• Txn Tax (Sum): Total transaction taxes (transaction currency)
• Merchant Txn Tax (Sum): Total merchant withholding taxes (transaction currency)

Settlement Day Exchange: Settlement Amount (Sum) = Net Amount (Sum) * Exchange Rate (On Settlement Time)

Transaction Time Exchange: Settlement Amount (Sum) = ∑ ( Txn Net Amount * Txn Exchange Rate )

Additional Notes: For each settlement cycle, regardless of whether the settlement amount is positive or negative, a settlement statement will be issued. However, negative settlement statements will not deduct from the merchant's balance; instead, they will be netted against subsequent positive settlement statements before settlement payment is allowed. The exchange rate and exchange rate time for negative settlement statements are left empty.

4. Settlement Bill Details

The settlement statement report is provided as a compressed file. After extraction, it contains the following two types of Excel files (settlement summary / settlement details):

Merchant ID_settlement_sum.xlsx
Merchant ID_settlement_detail.xlsx

Settlement Statement Example:

Bill Header	Header Description	Bill Example	Enumeration
Created Time	Settlement Statement Creation Time	2025-01-01 08:00:30
Settle ID	Settlement Confirmation Number	FSTSC202308140220441450264
Txn Amount	Transaction Amount	4.99
Txn Currency	Transaction Currency	USD
Txn Fee	Transaction Fee	-1.99
Txn Fee Currency	Transaction Fee Currency	USD
Txn Tax	Transaction Tax	-0.1
Txn Tax Currency	Transaction Tax Currency	USD
Merchant Txn Tax	Merchant Withholding Tax	-0.5
Merchant Txn Tax Currency	Merchant Withholding Tax Currency	USD
Net Amount(confirm)	Settlement Amount	2.4
Net Currency	Settlement Currency	USD
Exchange Type	Exchange Timing	No Exchange	On Settlement Time: Settlement Day Exchange On Txn Complete Time: Transaction Day Exchange On Confirm Time: Exchange at Currency Confirmation Time No Exchange: No exchange required
Settlement Amount	Settlement Amount	2.4
Settlement Currency	Settlement Currency	USD
Security Deposit	Rolling Security Deposit
Security Deposit Currency	Rolling Security Deposit Currency
Fields to be added	When new business arises in the future, new fields will be added at the end of the bill for explanation and identification
Completion Time	Settlement Completion Time (Extended Field)	2025-01-01 10:00:30
Settlement Status	Settlement Status (Extended Field)	Settled	Settling: In Settlement Settled: Settled
Net Deduct Amount	Deduction Amount (Extended Field)	0
Net Deduct Currency	Deduction Amount Currency (Extended Field)	USD
Remaining Payable Amount	Remaining Payable Amount (Extended Field)	2.4
Payable Amount Currency	Remaining Payable Amount Currency (Extended Field)	USD
Merchant Name	Merchant Name (Extended Field)
Merchant ID	Merchant ID (Extended Field)
Funding Status	Funding Status (Extended Field)
Funds Account	Fund Account Number (Extended Field)

Settlement Detail Bill Example:

Bill Header	Header Description	Bill Example	Enumeration
Settle ID	Settlement Statement Number	FSTSC202308140220441450264
Settlement Time	Settlement Time	2025-01-07 10:00:10
Txn Created Time	Transaction Creation Time	2025-01-01 15:00:00
Txn Completed Time	Transaction Completion Time	2025-01-01 15:30:00
Country	Country/Region	TW
Transaction Type	Transaction Type	Pay	Pay: Acquiring Payment Pay Failed/Closed: Acquiring Failed/Closed Refund Apply: Refund Initiated Refund Failed: Refund Failed Chargeback Unfrozen: Chargeback Unfrozen Chargeback Frozen: Chargeback Frozen CB Assist Apply: Defense Frozen CB Assist Cancel: Defense Unfrozen Adjustment Increase: Adjustment Increase Adjustment Decrease: Adjustment Decrease Charge Deposit: Deposit Collection Return Deposit: Deposit Return Auth: Authorization Capture: Capture
Merchant ID	Merchant ID	P000001
Merchant Txn ID	Merchant Order ID	sdfhsdofnsaldja
Trade Order ID	Platform Order ID	T202307240008117223154
Txn Amount	Transaction Amount	4.99
Txn Currency	Transaction Currency	USD
Txn Fee	Transaction Fee	-1.99
Txn Fee Currency	Transaction Fee Currency	USD
Txn Tax	Transaction Tax	-0.1
Txn Tax Currency	Transaction Tax Currency	USD
Merchant Txn Tax	Merchant Withholding Tax	-0.5
Merchant Txn Tax Currency	Merchant Withholding Tax Currency	USD
Net Amount	Settlement Amount	2.4
Net Currency	Settlement Currency	USD
Exchange Rate	Exchange Rate
Exchange Time	Exchange Rate Time
Exchange Type	Exchange Timing	No Exchange	On Settlement Time: Settlement Day Exchange On Txn Complete Time: Transaction Day Exchange On Confirm Time: Exchange at Currency Confirmation Time No Exchange: No exchange required
Payment Method Type	Payment Method Type	BAR_CODE
Payment Method	Payment Method	711/Convenience Store/HiLife/OK MART
Target Org/Card Org	Target Organization/Card Network	FAMILYMART
OriginalMerchant Txn ID	Original Merchant Business Order ID
Trade Description	Order Title or Product Information	Subject 40 Diamonds
Reference	Merchant Custom Additional Data	This is reference
Fields to be added	When new business arises in the future, new fields will be added at the end of the bill for explanation and identification
Settlement Status	Settlement Status (Extended Field)	Settled	Settling: In Settlement Settled: Settled
Merchant Name	Merchant Name (Extended Field)
Issuer Country	Issuer Country (Extended Field)
Fee Name	Fee Name (Extended Field)