Reconciliation file content

Last updated: 2019-11-20

Reconciliation files consist of transaction file and settlement file. Settlement files from SFTP and Alipay global site also contain a summary file. Files obtained from SFTP and Alipay global site are slightly different in naming convention and contents.


Transaction file

Transaction files contain transaction record of the selected time period.

Depending on where you download the file, the file name might consist of different parts. See the following table for details.      

Partner IDDateFile TypeFile SuffixSample
WebsiteA unique ID assigned by AlipayYYYYMMDD, YYYYMM, or YYYYMMDD + a 6-digit random number/.csv, .txt, or .xls2088611221573217_20180621151516.xls
SFTPA unique ID assigned by AlipayYYYYMMDDA fixed value: "transaction".csv2088721149955614_fptrade_20180823.csv


A transaction file might contain the following fields:

No.Field nameDescriptionExample
1Partner_transaction_idA unique transaction ID specified by the partner. It is the same with 

out_trade_no in the payment request or out_return_no in refund request.

201808274RE10NR9227446 
2AmountTransaction amount in foreign currency18.54
3Rmb_amountTransaction amount in CNY128.00
4FeeService fee in foreign currency. 

Note: If the currency is JPY or KRW, the value is integer.

0.17
5Distribute_amountThe split foreign currency amount of a trade or refund.2.78
6Distribute_rmb_amountThe split CNY amount of a trade or refund19.20
7SettlementSettlement amount in foreign currency15.59
8Rmb_settlementSettlement amount in CNY107.60
9CurrencyCurrencyUSD
10RateForeign exchange rate6.90370000
11Payment_timePayment time.
Note: If you view the transaction information on Alipay global open platform, this field name is Payment Time.
Example of Payment_time: 2018/8/27 0:00
Example of Payment Time: 2019.07.10 09:49:45
12Settlement_timeSettlement time
Note: If you view the transaction information on Alipay global open platform, this field name is Settlement Time.
 
13Type

Transaction type. The value of this parameter can be:

P: Payment transaction

R: Refund transaction

P
14Status

Transaction status. The value of this parameter can be:

P: Transaction succeeds

L: Transaction liquidated

P
15RemarksRemarks

Spray Deodorants 250ml

16Original_partner_transaction_ID

The original partner transaction ID. It is the same with the out_trade_no

in the payment request.
YJBS48822883813257449472
17Transaction ID/Partner Transaction ID

A unique transaction ID specified by Alipay / A unique transaction ID specified by the partner, which is the same with out_trade_no in the payment request or out_return_no in refund request.

2019071022001376801000076621 out_trade_no_20190710_094753
18Gross AmountThe gross transaction amount$ 20.00/¥131.89
19Distribute AmountThe split foreign currency amount and RMB amount of a trade or refund$ 1.50/¥9.89
20Net AmountThe net transaction amount$ 19.40/¥127.93
21RefundA button to process a refundRefund


The contents of transaction files that you download from Alipay global site and SFTP, and files you view online on the site are different. See the following table for details:

No.Field nameSFTP

Global Site Online

Global Site Download
1Partner_transaction_id

Yes

/

Yes

2Amount

Yes

/

Yes

3Rmb_amount

Yes

/

Yes

4Fee

Yes

Yes

Yes

5Distribute_amount

Yes

/

Yes

6Distribute_rmb_amount

Yes

/

Yes

7Settlement

Yes

/

Yes

8Rmb_settlement

Yes

/

Yes

9Currency

Yes

Yes

Yes

10Rate

Yes

Yes

Yes

11Payment_time

Yes

Yes

Yes

12Settlement_time

Yes

Yes

Yes

13Type

Yes

Yes

Yes

14Status

Yes

Yes

Yes

15Remarks

Yes

Yes

Yes

16Original_partner_transaction_ID

Yes

/

Yes

17Transaction ID/Partner Transaction ID

/

Yes

/

18Gross Amount

/

Yes

/

19Distribute Amount

/

Yes

/

20Net Amount

/

Yes

/

21Refund

/

Yes

/

Settlement file

Settlement files contain the settlement record of the selected time period.

Note:

The settlement files you download from Alipay global site and SFTP are compressed into a .zip file. The .zip file contains the settlement summary file and the settlement file. The naming convention of the .zip file is <PID>-<date>.<file_suffix>, for example, 2088021******931-20180508.zip.


Settlement summary file

Only settlement files obtained through SFTP or from Alipay global site at Download Files contain a settlement summary file, namely settlebatch file. The name of a settlebatch file contains the following parts:

Partner IDFile TypeDateFile SuffixSample
A unique ID assigned by AlipayA fixed value: "settlebatch"YYYYMMDD or YYYYMM.csv2088021******931_settlebatch_20180531.csv

A settlebatch file might contain the following fields:

NO.Field NameDescription
1settle_batch_noAn internal serial number of the file in Alipay system
2settle_dateSettlement time
3AmountTransaction amount in foreign currency
4FeeService fee in foreign currency
5SettlementSettlement amount in foreign currency
6CurrencyCurrency

Settlement file

Settlement files contain the settlement details of the selected time period.

Depending on where you download the file from, the file name might consist of different parts. See the following table for details.

Partner IDFile TypeDateSystem Assigned IDFile SuffixSample
Alipay global siteA unique ID assigned by AlipayA fixed value: "settle"YYYYMMDD, YYYYMM, or YYYYMMDD + a 6-digit random numberA unique ID assigned to each settlement file by Alipay.csv, .txt, or .xls2088721631012256_settle_20171106_50002017080100032007000005107441.csv
SFTPA unique ID assigned by AlipayA fixed value: "settle"YYYYMMDDA unique ID assigned to each settlement file by Alipay.csv2088721631012256_settle_20171106_50002017080100032007000005107441.csv


A settlement file might contain the following fields:

No.Field nameDescriptionExample
1Partner_transaction_id

The unique transaction ID specified by the partner. It is equal to out_trade_no in the payment request or out_return_no in the refund request.

201808224RE10NR9119242 
2AmountTransaction amount in foreign currency14.43
3Rmb_amountTransaction amount in CNY99.00
4Fee

Service fee in foreign currency. 

Note: If the currency is JPY or KRW, the value is integer.

0.14
5Distribute_amountThe split foreign currency amount of a trade or refund2.16
6Distribute_rmb_amountThe split CNY amount of a trade or refund14.85
7SettlementSettlement amount in foreign currency12.13
8Rmb_settlementSettlement amount in CNY83.22
9CurrencyCurrencyUSD
10RateForeign exchange rate6.85960000
11Payment_timePayment time2018/8/23 0:00
12Settlement_timeSettlement time2018/8/24 12:36
13TypeTransaction type. The value of this parameter can be:

P: Payment transaction

R: Refund transaction

P
14Status

Transaction status. For both payment and refund transactions, the value is L, which means Transaction Liquidated.

15Stem_from

The channel through which the transaction occurs. The value of this parameter can be:

M: cross border

T: Tmall

M
16RemarksRemarks

Spray Deodorants 250ml

17Original_partner_transaction_ID

The original partner transaction ID. It is the same with the out_trade_no in the payment request. 

YJGWZY18210660928560987406


The contents of settlement files that you download from Alipay global site and SFTP are different. See the following table for details: 

No.Field nameSFTPGlobal Site Download
1Partner_transaction_id

Yes

Yes

2Amount

Yes

Yes

3Rmb_amount

Yes

Yes

4Fee

Yes

Yes

5Distribute_amount

Yes

/

6Distribute_rmb_amount

Yes

/

7Settlement

Yes

Yes

8Rmb_settlement

Yes

Yes

9Currency

Yes

Yes

10Rate

Yes

Yes

11Payment_time

Yes

Yes

12Settlement_time

Yes

Yes

13Type

Yes

Yes

14Status

Yes

Yes

15Stem_from

Yes

Yes

16Remarks

Yes

Yes

17Original_partner_transaction_ID

Yes

Yes


If you have any question, please contact us