Settlement reconciliation

For the payin reconciliation service, since the fund bill file does not contain the details of a single fund of the payin transaction, the merchant can reconcile the settlement document with the payin transaction data to meet the needs of fund reconciliation in the payin transaction business.

1、Settlement generation： The computation cycle consists of two parts;T+N where N represents the interval at which the calculation ends;By day, by week, by month, by two weeks, representing the time range of settlement;

Billing Cycle	Statement of Settlement Date
T+N Day	T-day transaction, (T+N natural day) can be calculated
T+N Week	T week transactions can be settled on Mondays of T+N weeks
T+N Biweek	T week transactions together with the following 1 week transactions will be settled on the next N week Monday of T+1 week
T+N Month	Transactions in month T can be settled on the 1st of month T+N

Whether it is a week or two weeks, the settlement is made on the following Monday, and the month is divided into the beginning of the month/end of the month (the first or last day of the natural month)

2、Settlement description：
● When there is a refund order in the settlement document, 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 has nothing to do with the original transaction
● The order number of the merchant is the order number of the refund transaction, not the merchant order number of the original transaction, which corresponds to the refund order number (refund id) of the original transaction

3.Settlement check：
● The settlement summary document is classified and summarized by the dimensions of region&payment method
● When merchants check the detailed data of settlement documents of different settlement periods, they need to download the transaction data of different settlement periods according to the dimension of country&payment method on the MMC platform, and perform the reconciliation.
● The summary logic of the settlement summary document is as follows:
Net Amount (Sum)=Txn Amount(Sum) + Txn Fee(Sum) + Txn Tax(Sum)
Txn Amount(Sum):Transaction Amount Summary(Transaction Currency)
Txn Fee(Sum):Transaction fee summary(Transaction Currency)
Txn Tax(Sum):Transaction tax summary(Transaction Currency)
Merchant Txn Tax (Sum)：Merchant's Tax on Transactions (Transaction Currency)
Net Amount(remain):Remaining pre-settled amount(transaction currency)
Net Amount(confirm)=Settlement Amount,Corresponding transaction currency and settlement
Settlement Amount=Application Amount+Remain Settlement Amount；
Settlement Amount:Settlement Amount (Settlement Currency)

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

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

Additional Instructions: At each settlement period, a settlement statement will be issued for both positive and negative settlement amounts. However, negative settlement statements will not deduct from the merchant's balance. Instead, they will be reconciled against subsequent positive settlement statements, and only after this reconciliation will the settlement payment be allowed. Additionally, the exchange rate and the rate date for negative settlement statements will be left blank.

4、Settlement export：
Settlement export path：MMC-Settlement Order（batch），MMC to be settlement details page download (single);
● Settlement-Settlement Order ：To export the settlement and its details in bulk, select the settlement statement and click on "Export Details."
● The settlement report is provided in the form of a compressed file. After decompression, it contains the following two types of excel.

Merchant ID_settlement_sum

Merchant ID_settlement_detail

The settlement sum bill example is as follows：

Bill Header	Header Description	Bill Sample	Enumeration
Created Time	Created Time	2023/8/14 0:40:00.0
Settle ID	Settle ID	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
Transaction Tax	Transaction Tax	-0.1
Txn Tax Currency	Transaction Tax Currency	USD
Merchant Txn Tax	Merchant Transaction Tax	-0.5
Merchant Txn Tax Currency	Merchant Transaction Tax Currency	USD
Security Deposit	Security Deposit
Security Deposit Currency	Security Deposit Currency
Net Amount(confirm)	Net Amount(confirm)	2.4
Net Currency	Net Currency	USD
Exchange Type	Exchange Type	On Settlement Time	On Settlement Time On Txn Complete Time On Confirm Time
Settlement Amount	Settlement Amount	2.4
Settlement Currency	Settlement Currency	USD
Fields to be added	When new business arises in the future, we will add new fields to the end of the billing statements to provide clarification and identification.

The settlement detail bill example is as follows：

Bill Header	Header Description	Bill Sample	Enumeration
Settle ID	Settle ID	FSTSC202308140220441450264
Settlement Time	Settlement Time	2023/8/14 0:00:00.0
Txn Created Time	Transaction Created Time	2023/7/24 0:31:00.0
Txn Completed Time	Transaction Completed Time	2023/7/24 0:35:00.0
Country	Country	TW
Transaction Type	Transaction Type	Pay	Pay Refund Apply Refund Failed Chargeback Unfrozen Chargeback Frozen Adjustment Increase Adjustment Decrease
Merchant ID	Merchant ID	P000001
Merchant Txn ID	Merchant Txn ID	sdfhsdofnsaldja
Trade Order ID	PayerMax Transaction 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 Transaction Tax	-0.5
Merchant Txn Tax Currency	Merchant Transaction Tax Currency	USD
Net Amount	Net Amount	2.4
Net Currency	Net Currency	USD
Exchange Rate	Exchange Rate	1
Exchange Time	Exchange Time	2023/8/14 0:40:00.0
Exchange Type	Exchange Type	On Settlement Time	On Settlement Time On Txn Complete Time On Confirm Time
Payment Method Type	Payment Method Type	BAR_CODE
Payment Method	Payment Method	711/全家/HiLife/OK MART
Traget Org/Card Org	Traget Org/Card Org	FAMILYMART
OriginalMerachant Txn ID	Original Merachant Transaction ID
Fields to be added	When new business arises in the future, we will add new fields to the end of the billing statements to provide clarification and identification.