Reconciliation file content

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"

.txt

2088000000000000_transaction_20191216.txt


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


A Website transaction file might contain the following fields:

No.Field nameDescription
1

Time

Payment time.

Example of Payment_time: 2019-08-27 0:00:00

2

Settlement_time

Settlement time.

Example of Payment_time: 2019-08-28 0:00:00

3

Transaction_ID

A unique transaction ID specified by Alipay.

Example: 2019071022001376801000076621

3Partner_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

5

Gross_amount

Transaction amount in foreign currency

Example: 18.54

6Rmb_Gross_amount

Transaction amount in CNY

Example: 128.00

7

Distribute_amount

The distributed amount of a payment or refund in foreign currency

Example: 2.78

8Rmb_Distribute_amount

The distributed amount of a payment or refund in CNY currency

Example: 19.20

9Settlement

Settlement amount in foreign currency

Example: 15.59

10Rmb_settlement

Settlement amount in CNY

Example: 107.60

11FeeService fee in foreign currency

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

Example: 0.17

12Rmb_fee

Service fee in CNY

Example: 1.01

13M_Discount_amount

Merchant discount amount in foreign currency

Example: 0.07

14

M_Discount_RMB_amount

Merchant discount amount in CNY

Example: 0.01

15Currency

Currency

Example: USD

16

Rate

Foreign exchange rate

Example: 6.90370000

17

Goods_title

Good title. It is the same with Subject in the payment request.

Example: Spray Deodorants 250ml

18

Product

Payment product

Example: AD

19

Type

Transaction type. The value of this parameter can be:

P: Payment transaction

R: Refund transaction

Example: P

20

Status

Transaction or refund status. The value of this parameter can be:

P: Payment

S: Refund success

Example: P

21

Liquidation

Transaction type. The value of this parameter can be:

Y: Liquidated transaction

N: Unliquidated transaction

Example: N

22

Remarks

Remarks

Example: Full Refunded


An SFTP 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

2

Transaction_id

A unique transaction ID specified by Alipay.

Example: 2019071022001376801000076621

3

Amount

Transaction amount in foreign currency

Example: 18.54

3Rmb_amount

Transaction amount in CNY

Example: 128.00

5

FeeService fee in foreign currency

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

Example: 0.17

6Distribute_amount

The distributed amount of a payment or refund in foreign currency

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

Example: 2.78

7

Distribute_rmb_amount

The distributed amount of a payment or refund in CNY currency

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

Example: 19.20

8Settlement

Settlement amount in foreign currency

Example: 15.59

9Rmb_settlement

Settlement amount in CNY

Example: 107.60

10Currency

Currency

Example: USD

11Rate

Foreign exchange rate

Example: 6.90370000

12Payment_time

Payment time.

Example of Payment_time: 2018/8/27 0:00

Example of Payment Time: 2019.07.10 09:49:45

13Settlement_time

Settlement time.

Example of Payment_time: 2019-08-28 0:00:00

14

Type

Transaction type. The value of this parameter can be:

P: Payment transaction

R: Refund transaction

Example: P

15Status

Transaction status. The value of this parameter can be:

P: Transaction succeeds

L: Transaction liquidated

Example: P

16

Remarks

Remarks. It is the same with Subject in the payment request.

Example: Spray Deodorants 250ml


#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 .txt file. The .txt file contains the settlement summary file and the settlement file. The naming convention of the .txt file is <PID>_settlement_<date>.<file_suffix>, for example, 2088000000000000_settlement_20191216.txt.


#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 .xls2088611221573217_20180621151516.xls
SFTPA unique ID assigned by AlipayA fixed value: "settle"YYYYMMDDA unique ID assigned to each settlement file by Alipay

.txt

2088000000000000_settlement_20191216.txt


A settlement 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

2

Transaction_id

A unique transaction ID specified by Alipay.

Example: 2019071022001376801000076621

3

Amount

Transaction amount in foreign currency

Example: 18.54

3Rmb_amount

Transaction amount in CNY

Example: 128.00

5

FeeService fee in foreign currency

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

Example: 0.17

6Distribute_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

7

Distribute_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

8Settlement

Settlement amount in foreign currency

Example: 15.59

9Rmb_settlement

Settlement amount in CNY

Example: 107.60

10Currency

Currency

Example: USD

11Rate

Foreign exchange rate

Example: 6.90370000

12Payment_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

13Settlement_timeSettlement time
Note: If you view the transaction information on Alipay global open platform, this field name is Settlement Time.

14

Type

Transaction type. The value of this parameter can be:

P: Payment transaction

R: Refund transaction

Example: P

15Status

Transaction status. The value of this parameter can be:

P: Transaction succeeds

L: Transaction liquidated

Example: P

16

Remarks

Remarks

Example: Spray Deodorants 250ml


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


A Website settlement file might contain the following fields:

No.Field nameDescription
1

Time

Payment time.

Example of Payment_time: 2019-08-27 0:00:00

2

Settlement_time

Settlement time.

Example of Payment_time: 2019-08-28 0:00:00

3

Transaction_ID

A unique transaction ID specified by Alipay.

Example: 2019071022001376801000076621

3Partner_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

5

Gross_amount

Transaction amount in foreign currency

Example: 18.54

6Rmb_Gross_amount

Transaction amount in CNY

Example: 128.00

7

Distribute_amount

The distributed amount of a payment or refund in foreign currency

Example: 2.78

8Rmb_Distribute_amount

The distributed amount of a payment or refund in CNY currency

Example: 19.20

9Settlement

Settlement amount in foreign currency

Example: 15.59

10Rmb_settlement

Settlement amount in CNY

Example: 107.60

11FeeService fee in foreign currency

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

Example: 0.17

12Rmb_fee

Service fee in CNY

Example: 1.01

13M_Discount_amount

Merchant discount amount in foreign currency

Example: 0.07

14

M_Discount_RMB_amount

Merchant discount amount in CNY

Example: 0.01

15Currency

Currency

Example: USD

16

Rate

Foreign exchange rate

Example: 6.90370000

17

Goods_title

Good title. It is the same with Subject in the payment request.

Example: Spray Deodorants 250ml

18

Product

Payment product

Example: AD

19

Type

Transaction type. The value of this parameter can be:

P: Payment transaction

R: Refund transaction

Example: P

20

Status

Transaction or refund status. The value of this parameter can be:

P: Payment

S: Refund success

Example: P

21

Liquidation

Transaction type. The value of this parameter can be:

Y: Liquidated transaction

N: Unliquidated transaction

Example: N

22

Remarks

Remarks

Example: Full Refunded


An SFTP settlement 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

2

Transaction_id

A unique transaction ID specified by Alipay.

Example: 2019071022001376801000076621

3

Amount

Transaction amount in foreign currency

Example: 18.54

3Rmb_amount

Transaction amount in CNY

Example: 128.00

5

FeeService fee in foreign currency

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

Example: 0.17

6Distribute_amount

The distributed amount of a payment or refund in foreign currency

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

Example: 2.78

7

Distribute_rmb_amount

The distributed amount of a payment or refund in CNY currency

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

Example: 19.20

8Settlement

Settlement amount in foreign currency

Example: 15.59

9Rmb_settlement

Settlement amount in CNY

Example: 107.60

10Currency

Currency

Example: USD

11Rate

Foreign exchange rate

Example: 6.90370000

12Payment_time

Payment time.

Example of Payment_time: 2018/8/27 0:00

Example of Payment Time: 2019.07.10 09:49:45

13Settlement_time

Settlement time.

Example of Payment_time: 2019-08-28 0:00:00

14

Type

Transaction type. The value of this parameter can be:

P: Payment transaction

R: Refund transaction

Example: P

15Status

Transaction status. The value of this parameter can be:

P: Transaction succeeds

L: Transaction liquidated

Example: P

16

Remarks

Remarks. It is the same with Subject in the payment request.

Example: Spray Deodorants 250ml