Settlement Report
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 |
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.
The settlement sum bill example is as follows：
| Bill Header | Header Description | Bill Sample | Enumeration |
| Created Time | Created Time | 2023/8/14 00:40:00 | |
| 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 | |
| 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 | |
| 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 No Exchange |
| 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. | ||
| Completion Time | Settlement Completion Time | 2023/8/14 01:40:00 | |
| Settlement Status | Settlement Status | Settled | Settling Settled |
| Net Deduct Amount | Deducted Amount | 0 | |
| Net Deduct Currency | Deducted Amount Currency | USD | |
| Remaining Payable Amount | Remaining Settleable Amount | 3.99 | |
| Payable Amount Currency | Remaining Settleable Amount Currency | USD | |
| Net Deduct ID | Deduction Number | FSTSC202308140220441450290 | |
| Merchant Name | Merchant Name(Extended field) | ||
| Merchant Number | Merchant Number(Extended field) |
| Bill Header | Header Description | Bill Sample | Enumeration |
| Settle ID | Settle ID | FSTSC202308140220441450264 | |
| Settlement Time | Settlement Time | 2023/8/14 08:00:00 | |
| Txn Created Time | Transaction Created Time | 2023/7/24 01:31:00 | |
| Txn Completed Time | Transaction Completed Time | 2023/7/24 02:35:00 | |
| Country | Country/Region | TW | |
| Transaction Type | Transaction Type | Pay | Pay Refund Apply Refund Failed Chargeback Unfrozen Chargeback Frozen CB Assist Apply CB Assist Cancel 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 Rate Time | 2023/8/14 02:40:00 | |
| Exchange Type | Exchange Type | On Settlement Time | On Settlement Time On Txn Complete Time On Confirm Time No Exchange |
| 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 | ||
| Trade Description | Order title or product information | Subject 40 Diamonds | |
| Reference | Customized data for merchant | This is reference | |
| 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. | ||
| Settlement Status | Settlement Status | Settled | Pending Settlement Settling Settled |
| Merchant Name | Merchant Name(Extended field) |