Reconciliation file content

2021-02-26 07:36

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 ID	Date	File Type	File Suffix	Sample
Website	A unique ID assigned by Alipay	YYYYMMDD, YYYYMM, or YYYYMMDD + a 6-digit random number	/	.csv, .txt, or .xls	2088611221573217_20180621151516.xls
SFTP	A unique ID assigned by Alipay	YYYYMMDD	A fixed value: "transaction"	.csv	2088721149955614_fptrade_20180823.csv

A transaction file might contain the following fields:

No.	Field name	Description
1	Partner_transaction_id	A 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	Amount	Transaction amount in foreign currency `Example: 18.54`
3	Rmb_amount	Transaction amount in CNY `Example: 128.00`
4	Fee	Service fee in foreign currency Note: If the currency is JPY or KRW, the value is integer. `Example: 0.17`
5	Distribute_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`
6	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`
7	Settlement	Settlement amount in foreign currency `Example: 15.59`
8	Rmb_settlement	Settlement amount in CNY `Example: 107.60`
9	Currency	Currency `Example: USD`
10	Rate	Foreign exchange rate `Example: 6.90370000`
11	Payment_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`
12	Settlement_time	Settlement time Note: If you view the transaction information on Alipay global open platform, this field name is Settlement Time.
13	Type	Transaction type. The value of this parameter can be: `P`: Payment transaction `R`: Refund transaction `Example: P`
14	Status	Transaction status. The value of this parameter can be: `P`: Transaction succeeds `L`: Transaction liquidated `Example: P`
15	Remarks	Remarks `Example: Spray Deodorants 250ml`
16	Original_partner_transaction_ID	The original partner transaction ID. It is the same with the `out_trade_no` in the payment request. `Example: YJBS48822883813257449472`
17	Transaction 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`
18	Gross Amount	The gross transaction amount `Example: $ 20.00/￥131.89`
19	Distribute Amount	The distributed amount of a payment or refund in foreign currency and CNY currency `Example: $ 1.50/￥9.89`
20	Net Amount	The net transaction amount `Example: $ 19.40/￥127.93`
21	Refund	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 name	SFTP	Global Site Online	Global Site Download
1	Partner_transaction_id	Yes	/	Yes
2	Amount	Yes	/	Yes
3	Rmb_amount	Yes	/	Yes
4	Fee	Yes	Yes	Yes
5	Distribute_amount	Conditional	/	Conditional
6	Distribute_rmb_amount	Conditional	/	Conditional
7	Settlement	Yes	/	Yes
8	Rmb_settlement	Yes	/	Yes
9	Currency	Yes	Yes	Yes
10	Rate	Yes	Yes	Yes
11	Payment_time	Yes	Yes	Yes
12	Settlement_time	Yes	Yes	Yes
13	Type	Yes	Yes	Yes
14	Status	Yes	Yes	Yes
15	Remarks	Yes	Yes	Yes
16	Original_partner_transaction_ID	Yes	/	Yes
17	Transaction ID/Partner Transaction ID	/	Yes	/
18	Gross Amount	/	Yes	/
19	Distribute Amount	/	Yes	/
20	Net Amount	/	Yes	/
21	Refund	/	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 ID	File Type	Date	File Suffix	Sample
A unique ID assigned by Alipay	A fixed value: "settlebatch"	YYYYMMDD or YYYYMM	.csv	2088021******931_settlebatch_20180531.csv

A settlebatch file might contain the following fields:

NO.	Field Name	Description
1	settle_batch_no	An internal serial number of the file in Alipay system
2	settle_date	Settlement time
3	Amount	Transaction amount in foreign currency
4	Fee	Service fee in foreign currency
5	Settlement	Settlement amount in foreign currency
6	Currency	Currency

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 ID	File Type	Date	System Assigned ID	File Suffix	Sample
Alipay global site	A unique ID assigned by Alipay	A fixed value: "settle"	YYYYMMDD, YYYYMM, or YYYYMMDD + a 6-digit random number	A unique ID assigned to each settlement file by Alipay	.csv, .txt, or .xls	2088721631012256_settle_20171106_50002017080100032007000005107441.csv
SFTP	A unique ID assigned by Alipay	A fixed value: "settle"	YYYYMMDD	A unique ID assigned to each settlement file by Alipay	.csv	2088721631012256_settle_20171106_50002017080100032007000005107441.csv

A settlement file might contain the following fields:

No.	Field name	Description
1	Partner_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`
2	Amount	Transaction amount in foreign currency `Example: 14.43`
3	Rmb_amount	Transaction amount in CNY `Example: 99.00`
4	Fee	Service fee in foreign currency. Note: If the currency is JPY or KRW, the value is integer. `Example: 0.14`
5	Distribute_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`
6	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: 14.85`
7	Settlement	Settlement amount in foreign currency `Example: 12.13`
8	Rmb_settlement	Settlement amount in CNY `Example: 83.22`
9	Currency	Currency `Example: USD`
10	Rate	Foreign exchange rate `Example: 6.85960000`
11	Payment_time	Payment time `Example: 2018/8/23 0:00`
12	Settlement_time	Settlement time `Example: 2018/8/24 12:36`
13	Type	Transaction type. The value of this parameter can be: `P`: Payment transaction `R`: Refund transaction `Example: P`
14	Status	Transaction status. For both payment and refund transactions, the value is L, which means Transaction Liquidated. `Example: L`
15	Stem_from	The channel through which the transaction occurs. The value of this parameter can be: `M`: cross border `T`: Tmall `Example: M`
16	Remarks	Remarks `Example: Spray Deodorants 250ml`
17	Original_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 name	SFTP	Global Site Download
1	Partner_transaction_id	Yes	Yes
2	Amount	Yes	Yes
3	Rmb_amount	Yes	Yes
4	Fee	Yes	Yes
5	Distribute_amount	Conditional	Conditional
6	Distribute_rmb_amount	Conditional	Conditional
7	Settlement	Yes	Yes
8	Rmb_settlement	Yes	Yes
9	Currency	Yes	Yes
10	Rate	Yes	Yes
11	Payment_time	Yes	Yes
12	Settlement_time	Yes	Yes
13	Type	Yes	Yes
14	Status	Yes	Yes
15	Stem_from	Yes	Yes
16	Remarks	Yes	Yes
17	Original_partner_transaction_ID	Yes	Yes