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 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
|
| 2 | Amount | Transaction amount in foreign currency
|
| 3 | Rmb_amount | Transaction amount in CNY
|
| 4 | Fee | Service fee in foreign currency Note: If the currency is JPY or KRW, the value is integer.
|
| 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.
|
| 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.
|
| 7 | Settlement | Settlement amount in foreign currency
|
| 8 | Rmb_settlement | Settlement amount in CNY
|
| 9 | Currency | Currency
|
| 10 | Rate | Foreign exchange rate
|
| 11 | Payment_time | Payment time.
|
| 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:
|
| 14 | Status | Transaction status. The value of this parameter can be:
|
| 15 | Remarks | Remarks
|
| 16 | Original_partner_transaction_ID | The original partner transaction ID. It is the same with the
|
| 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
|
| 18 | Gross Amount | The gross transaction amount
|
| 19 | Distribute Amount | The distributed amount of a payment or refund in foreign currency and CNY currency
|
| 20 | Net Amount | The net transaction amount
|
| 21 | Refund | A button to process a 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
|
| 2 | Amount | Transaction amount in foreign currency
|
| 3 | Rmb_amount | Transaction amount in CNY
|
| 4 | Fee | Service fee in foreign currency. Note: If the currency is JPY or KRW, the value is integer.
|
| 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.
|
| 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.
|
| 7 | Settlement | Settlement amount in foreign currency
|
| 8 | Rmb_settlement | Settlement amount in CNY
|
| 9 | Currency | Currency
|
| 10 | Rate | Foreign exchange rate
|
| 11 | Payment_time | Payment time
|
| 12 | Settlement_time | Settlement time
|
| 13 | Type | Transaction type. The value of this parameter can be:
|
| 14 | Status | Transaction status. For both payment and refund transactions, the value is L, which means Transaction Liquidated.
|
| 15 | Stem_from | The channel through which the transaction occurs. The value of this parameter can be:
|
| 16 | Remarks | Remarks
|
| 17 | Original_partner_transaction_ID | The original partner transaction ID. It is the same with the
|
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 |