Alipay, China's leading third-party online payment solutionAlipay, China's leading third-party online payment solutionDOCS

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