You can obtain reconciliation reports in the following two ways:

• Download from SFTP server: The reconciliation reports downloaded from the SFTP server can be customized according to your requirements. The configured content in the SFTP server cannot be automatically updated when the reconciliation report capability is updated unless otherwise requested.
• Download from Alipay Global Merchant Portal: The reconciliation reports downloaded from the portal cannot be customized according to your requirements. The reconciliation reports in the portal will change when the reconciliation report capability is updated.

SFTP

You can download reconciliation reports from a specific directory in the SFTP server. Alipay encodes all the reports in UTF-8 and uploads them to the SFTP server.

Server login

Complete the following steps first before you obtain reconciliation reports from the SFTP server:

1. Contact Alipay Merchant Service technical support (overseas_support@service.alibaba.com) to obtain SFTP login credentials and submit the public IP address to access the SFTP server.
2. Log in to the SFTP server using the following information:

• Port: 22
• Hostname: isftp.alipay.com (If the loading speed of this link is slow, try sftp.alipay.com.)
• Username and password

Notes:

• SFTP accounts that are not used for 90 days will be disabled.
• Reconciliation reports older than 7 days on the SFTP server might be deleted. If the reconciliation reports are deleted, you can download them from Alipay Global Merchant Portal.
• In the case of no transaction, you can contact Alipay Merchant Service technical support (overseas_support@service.alibaba.com) to configure whether to generate reconciliation reports.

For the specific download path of the report, see the following report download path section.

Report download path

The download path for all reconciliation reports is report directory + report name. For example, the download path for a settlement details report: /v1/settlements/102218800000000****/20221024/settlementItems_USD_20221024193034****_000.csv.

Report directory

The formats and examples of the download directories for different report types are as follows:

Table 1. Download directories for different reports

The concepts in the report directory format are explained as follows:

• merchantIdByAcquirer: the identity assigned by Alipay for merchants
• transactionDate: the date of the transaction
• settlementDate: the day when Alipay settles with merchants

Report name

The default report names and formats for different reports are as follows. You can also contact Alipay Merchant Service technical support (overseas_support@service.alibaba.com) to customize the report name.

Table 2. Default report names for different reports

The concepts in the report name format are explained as follows:

• transactionDate: the date of the transaction.
• settlementCurrency: the settlement currency specified in the contract. The currency is the same as the settlement currency in the settlement report.
• settlementBatchId: the settlement batch ID that corresponds to the settlement batch ID in the reports.

Alipay Global Merchant Portal

You can obtain reconciliation reports through Alipay Global Merchant Portal, where you can download online real-time reports or directly download reports for the time period you need.

To download reconciliation reports through the portal, you need to first log in to the portal and find Billing. For specific operations of logging in to the portal, see Billing center.

For how to download different report types, see the following:

• Download Transaction Details Report
• Download Settlement Report