Perform reconciliation
This section guides you through the general process of performing reconciliation and helps you understand how the amounts in each financial report are calculated.
Before you begin
Before you use the Alipay+ reports to perform reconciliation, make sure that the following data are prepared:
- Organize the successful transactions (Failed or canceled transactions are not included.) according to the transaction times (the value of the originalCreditTime parameter) from Alipay+. The daily cutoff time is Alipay+'s daily cutoff time, 00:00 UTC+8.
- Determine the total count of transactions and fees for every T day.
- Determine every T day's transaction amount and the to-be-settled amount for the ACQP.
- Determine the fees of every transaction and summarize all the fees according to Alipay+'s fee calculation rules.
Process overview
It is recommended to perform the reconciliation in the following steps:
- Reconcile settlements
- Compare the settlement amount in the Settlement Report against the amount recorded on the ACQP side.
- If the data on the two sides is consistent, there are no discrepancies in the settlement amount of the settlement cycle. The reconciliation ends.
- If discrepancies exist, compare the settlement amount in each clearing cycle against the amounts recorded on the ACQP side. Find the clearing cycle that causes the discrepancies.
- Reconcile the transactions and fees of the clearing cycle that cause the discrepancies.
- Compare the net settlement amount and the total transaction counts in the Transaction Detail Report against the data recorded on the ACQP side.
- If discrepancies exist in the transaction data, compare the information of every transaction in the Transaction Detail Report against the data recorded on the ACQP side. Find the transaction that causes the discrepancies.
- If the data on the two sides is consistent, reconcile the fee data of the clearing cycle.
- Compare the net fee settlement amount and the total fee counts in the Fee Report against the data recorded on the ACQP side.
- If discrepancies exist in the fee data, compare the information of every fee item in the Fee Report against the data recorded on the ACQP side. Find the fee item that causes the discrepancies.
- If the data on the two sides is consistent, calculate the settlement amount of this clearing cycle.
Note: If the transaction status in the Alipay+ system is inconsistent with that in the ACQP system, the scope of the successful transactions on the two sides may be inconsistent. The successful transactions in the clearing reports and the Settlement Report provided by Alipay+ prevail. ACQP deals with the discrepancies according to the Alipay+ reports. If any doubt exists, send an email to connect_support@service.alipay.com.
For details about each step, see the following sections.
Reconcile settlements
Follow the process that is illustrated in the figure below to reconcile the settlement amount of a settlement cycle.
Figure 1. Reconcile settlements
- Download the Settlement Report from the Alipay+ SFTP server.
- Compare the value of the netSettlementAmountValue parameter in the summary section of the Settlement Report against the data recorded on the ACQP side.
- If the data on the two sides is consistent, there are no discrepancies in the settlement amount of the settlement cycle. The reconciliation ends.
- If discrepancies exist, compare the values of the netSettlementAmountValue parameter in each clearing cycle against the amounts recorded on the ACQP side. Find the clearing cycle that causes the discrepancies. For how to calculate the total settlement amount in the Settlement Report, see Calculating the amounts - Settlement amount.
- Reconcile the transactions and fees of the clearing cycle. See Reconcile transactions and fees for details.
Reconcile transactions and fees
If discrepancies exist in the settlements, you can use the clearing reports to reconcile transactions and fees to find the cause of the discrepancies.
Follow the process illustrated in the figure below to reconcile transactions and fees.
Figure 2. Reconcile transactions and fees
- Download the clearing reports from the Alipay+ SFTP server.
- Compare the value of the netSettlementAmountValue parameter and the value of the totalCount parameter of the Transaction Detail Report against the data recorded on the ACQP side.
- If discrepancies exist in the transaction data, compare the information of every transaction in the Transaction Detail Report against the data recorded on the ACQP side. Find the transaction that causes the discrepancies. For how to calculate the total transaction settlement amount in the Transaction Detail Report, see Calculating the amounts - Transaction settlement amount.
- If the data on the two sides is consistent, compare the value of the netFeeSettlementAmountValue parameter and the value of the totalCount parameter in the Fee Report against the data recorded on the ACQP side.
- If discrepancies exist in the fee data, compare the information of every fee item in the Fee Report against the data recorded on the ACQP side. Find the fee item that causes the discrepancies. For how to calculate the total fee settlement amount in the Transaction Detail Report, see Calculating the amounts - Fee settlement amount.
- If the data on the two sides is consistent, calculate the settlement amount of this clearing cycle.
If you have any questions during the reconciliation process, contact connect_support@service.alipay.com for help.
Calculate the amounts
The following section explains how to calculate the transaction amount and fee amount according to each report, and how to determine the settlement amount according to the transaction amount and the fee amount.
Notes:
- In the reports, the values of all the amount parameters, such as the value of the netSettlementAmount parameter, are provided in the smallest unit of the corresponding currency. For example, if the settlement currency is EUR, and the value of netSettlementAmount is
1000
, the actual settlement amount is 10 EUR. - Important parameters are highlighted in the screenshots of the sample reports.
Transaction settlement amount
The total settlement amount for transactions is the sum of the settlement amount of all the OCTs:
netSettlementAmountValue = sum (settlementAmountValue)
The data in the following report is used:
📎transactionItems_A1234567890_EUR_202204190000200000_20210001_000.csv
Figure 3. Sample Transaction Detail Report
According to the sample Transaction Detail Report, the following information is provided:
- The settlement currency is EUR (settlementCurrency =
EUR
). - The OCT funds are to be debited from the ACQP. (When transactionType =
OCT
, fundDirection =DEBIT
). - There are two OCTs in total and every OCT has a settlement amount of 10 EUR (two transactions with transactionType =
OCT
, settlementAmountValue =1000
). - The total settlement amount for transactions is 20 EUR (netSettlementAmountValue =
2000
)
Based on the information above, the total settlement amount is 20 * 2 = 20 EUR.
netSettlementAmountValue = sum (settlementAmountValue) = 10 EUR + 10 EUR = 20 EUR
Fee settlement amount
The total fee settlement amount is the sum of all the fees to be paid to Alipay+, namely:
netFeeAmountValue = sum (feeSettleAmountValue)
The following sample Fee Report is in the same set of reports as the previous report for Transaction settlement amount and has the following data:
📎feeItems_A1234567890_EUR_202204190000200000_20210001_000.csv
Figure 4. Sample Fee Report
According to the sample Fee Report, the following information is provided:
- The fee settlement currency is EUR (feeSettlementCurrency =
EUR
). - For OCTs, the service fees are to be debited from the ACQP. (When transactionType =
OCT
, feeDirection =DEBIT
. - There are two fee items and every fee item has a settlement amount of 0.1 EUR (Two fee items with feeType =
SERVICE_FEE
, and feeSettlementAmountValue =10
). - The total fee settlement amount is 0.2 EUR (netFeeSettlementAmountValue =
20
).
Based on the information above, the total fee settlement amount is 0.1 * 2 = 0.2 EUR.
netFeeAmountValue = sum (feeSettleAmountValue) = 0.1 EUR + 0.1 EUR = 0.2 EUR
Settlement amount
The settlement amount of a settlement cycle is calculated in two scenarios:
- Only one clearing cycle exists in the settlement cycle.
- Multiple clearing cycles exist in the settlement cycle.
See the following sections for details:
Settlement cycle with 1 clearing cycle
If a settlement cycle contains only one clearing cycle, the total settlement amount is the settlement amount of the clearing cycle. That is the total settlement amount in the Transaction Detail Report and the total fee settlement amount in the Fee Report, namely:
The settlement report's netSettlementAmountValue of a clearing cycle = netSettlementAmountValue in the Transaction Detail Report + netFeeSettlementAmountValue in the Fee Report
The following sample Settlement Report is in the same set of reports as the previous report for Transaction settlement amount and Fee settlement amount and has the following data:
📎settlement_A1234567890_EUR_202204200000200000_20210001_000.csv
Figure 5. Sample Settlement Report with 1 clearing cycle
According to the sample Settlement Report, the following information is provided:
- The settlement currency is EUR (settlementCurrency =
EUR
). - The total settlement amount of the clearing cycle is 20.20 EUR (netSettlementAmountValue =
2020
).
Based on the information above, the total settlement amount is:
The settlement report's netSettlementAmountValue of a clearing cycle = netSettlementAmountValue in the Transaction Detail Report + netFeeSettlementAmountValue in the Fee Report = 20 EUR + 0.2 EUR = 20.2 EUR
Settlement cycle with multiple clearing cycles
If a settlement cycle contains multiple clearing cycles, the total settlement amount of the settlement cycle is the sum of the total settlement amounts in the clearing cycles to be debited from the ACQP, namely:
netSettlementAmountValue in the summary section = sum (netSettlementAmountValue) in the detail section
The data in the following report is used:
Figure 6. Sample Settlement Report with multiple clearing cycles
According to the sample Settlement Report, the following information is provided:
- There are four clearing cycles in the settlement cycle (there are four rows under the clearingBatchId parameter).
- The settlement currency is EUR (settlementCurrency =
EUR
). - There are two clearing cycles that have no funds settled (netSettlementAmountValue =
0
). - Only two of the clearing cycles have settlement amounts that are not 0:
- The clearing cycle with clearingBatchId =
202201091107564683
has a settlement amount of 3.3 EUR to be debited from the ACQP (netSettlementAmountValue =330
, fundDirection =DEBIT
). - The clearing cycle with clearingBatchId =
202201111107957472
has a settlement amount of 5 EUR to be debited from the ACQP (netSettlementAmountValue =500
, fundDirection =DEBIT
).
- The total settlement amount of the settlement cycle is 8.3 EUR (netSettlementAmountValue =
830
).
Based on the information above, the following is concluded:
The total settlement amount of the settlement cycle is calculated by adding all the settlement amounts of every clearing cycle in the settlement cycle:
netSettlementAmountValue in the summary section = sum (netSettlementAmountValue) in the detail section =2 * 0 EUR + 5 EUR + 3.3 EUR = 8.3 EUR