Reconciliation file content

Last updated: 2019-12-31

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 nameDescription
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.

Example: 201808274RE10NR9227446

2Amount

Transaction amount in foreign currency

Example: 18.54

3Rmb_amount

Transaction amount in CNY

Example: 128.00

4FeeService fee in foreign currency

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

Example: 0.17

5Distribute_amount

The distributed amount of a payment or refund in foreign currency

Note: This field exists in the file if the amount split feature is signed. Contact technical support for details.

Example: 2.78

6Distribute_rmb_amount

The distributed amount of a payment or refund in CNY currency

Note: This field exists in the file if the amount split feature is signed. Contact technical support for details.

Example: 19.20

7Settlement

Settlement amount in foreign currency

Example: 15.59

8Rmb_settlement

Settlement amount in CNY

Example: 107.60

9Currency

Currency

Example: USD

10Rate

Foreign exchange rate

Example: 6.90370000

11Payment_time

Payment 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

Example: P

14Status

Transaction status. The value of this parameter can be:

P: Transaction succeeds

L: Transaction liquidated

Example: P

15Remarks

Remarks

Example: 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.

Example: 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.

Example: 2019071022001376801000076621 out_trade_no_20190710_094753

18Gross Amount

The gross transaction amount

Example: $ 20.00/¥131.89

19Distribute Amount

The distributed amount of a payment or refund in foreign currency and CNY currency

Example: $ 1.50/¥9.89

20Net Amount

The net transaction amount

Example: $ 19.40/¥127.93

21Refund

A button to process a refund

Example: Refund


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

Conditional

/

Conditional

6Distribute_rmb_amount

Conditional

/

Conditional

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 nameDescription
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.

Example: 201808224RE10NR9119242

2Amount

Transaction amount in foreign currency

Example: 14.43

3Rmb_amount

Transaction amount in CNY

Example: 99.00

4Fee

Service fee in foreign currency. 

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

Example: 0.14

5Distribute_amount

The distributed amount of a payment or refund in foreign currency

Note: This field exists in the file if the amount split feature is signed. Contact technical support for details.

Example: 2.16

6Distribute_rmb_amount

The distributed amount of a payment or refund in CNY currency

Note: This field exists in the file if the amount split feature is signed. Contact technical support for details.

Example: 14.85

7Settlement

Settlement amount in foreign currency

Example: 12.13

8Rmb_settlement

Settlement amount in CNY

Example: 83.22

9Currency

Currency

Example: USD

10Rate

Foreign exchange rate

Example: 6.85960000

11Payment_time

Payment time

Example: 2018/8/23 0:00

12Settlement_time

Settlement time

Example: 2018/8/24 12:36

13TypeTransaction type. The value of this parameter can be:

P: Payment transaction

R: Refund transaction

Example: P

14Status

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

Example: L

15Stem_from

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

M: cross border

T: Tmall

Example: M

16Remarks

Remarks

Example: 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. 

Example: 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

Conditional

Conditional

6Distribute_rmb_amount

Conditional

Conditional

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