Each acquirer provides different methods to obtain settlement reports, and the report formats and fields may vary. APO consolidates the bills of acquirers and generates standardized reconciliation reports for your reconciliation process. You can reconcile using two methods: Reports and APO Dashboard. If you need to reconcile using the acquirer's original reports, you must store the information of acquirerTransactionId for subsequent reconciliation. For details, refer to Order number management. 

Reports

This section explains how to obtain reconciliation reports and how to use the reports for reconciliation.

Supported acquirers

APO currently supports standard reports from four acquirers: Antom, Adyen, 2C2P, and Checkout.com. Standard reports from other acquirers are being integrated gradually. If you have report requirements for other acquirers, you can contact APO technical support.

Obtain reports

You can obtain reconciliation reports in the following two ways:

• Download from the 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. If you need customized configurations, please contact APO technical support.
  
• Download from APO Dashboard: The reconciliation reports downloaded from APO Dashboard cannot be customized according to your requirements. The reports from the APO Dashboard are subject to changes as reporting capabilities are continuously updated.

Note: Adyen and Checkout.com require report configuration to be enabled on their respective platforms.

SFTP

You can download reconciliation reports from a specific directory in the SFTP server. APO encodes all the reports in UTF-8 and uploads them to the SFTP server. Reports downloaded from the SFTP server include .csv and .xlsx formats.

Note: APO does not support downloading the transaction details report through the SFTP server, and the transaction details report is only available on APO Dashboard.

Server login

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

1. Contact APO technical support (AlipayGlobalTechService@service.alipay.com) to obtain SFTP login credentials and submit the public IP address to access the SFTP server.
2. Log into 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 APO Dashboard.
• In the case of no transaction, you can contact APO technical support (AlipayGlobalTechService@service.alipay.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 follows the structure of: report directory + report name. For example, the download path for a settlement details report:

/v1/settlements/102*************234/20221024/settlementItems_USD_202*************234_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 APO for merchants.
• transactionDate: the date of the transaction.
• settlementDate: the day when APO settles with merchants.

Report name

The default report names and formats for different reports are as follows. You can also contact APO technical support (AlipayGlobalTechService@service.alipay.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.

APO Dashboard

To obtain real-time reconciliation reports or reconciliation reports for specific batches through the APO Dashboard, complete the following steps:

1. Log into the APO Dashboard and locate Transaction module.
2. Download different types of reports:

• Transaction details report
• Settlement details report
• Settlement summary report

Reconcile using reports

You can use the following three financial reports to perform different reconciliation tasks:

Table 3. Reports and tasks

APO Dashboard transaction queries

In addition to downloading reconciliation reports through APO Dashboard, you can also use the following functions in the Transaction module of the portal to assist you with reconciliation:

• Search for real-time transaction