Reconciliation File Retrieval

For various statements, PayerMax provides two ways to obtain statements:

Method 1: Download reconciliation files through PayerMax's MMC platform, you can also set up timed statements to automatically send out statement emails when the cycle is due.

Method 2: Retrieve reconciliation files via SFTP access.

Note:

To ensure the accuracy of billing data, we have enhanced the inspection and automated reconciliation capabilities for customer billing statements. However, this enhancement will result in a delay of the latest production time for customer billing statements. The new schedule will move the deadline from 12:00 PM to 2:00 PM within the UTC+8 time zone (UTC+8 time zone 2:00 PM = UTC+0 time zone 6:00 AM ).
Instructions for automatic bill parsing: PayerMax has more and more business types, and it is inevitable to add fields to the bill to distinguish different types of business. Therefore, we provide a bill header setting function. To ensure that after the merchant develops automatic bill reconciliation, the additional fields in the bill do not affect the merchant's daily reconciliation. The newly added fields need to be modified by the merchant through the MMC bill setting function according to their needs (Please refer to the rows of each new field in the statement under Reconciliation File Description).

1. Downloading Reconciliation Files via MMC Platform

1.1 Manually Download Statements

(a) Statement Download Request

Through the billing service on the Merchant Platform (MMC), customers can manually download statements, including: Settlement Statements, Fund Detail Statements, Payin Transaction Statements, and Payout Transaction Statements. Statements from the past two years are available for download.

(b) File Generated Successfully and Downloaded

After submitting a download request, PayerMax will process it. Merchants can then view the request on the list page and directly download the file to their local device.

1.2 Set Up Scheduled Statement Push to Specified Recipient Email

Through the billing module on the Merchant Platform (MMC), select the statement type you wish to have sent on a scheduled basis, specify the schedule cycle (daily or monthly), and choose email as the notification method to receive the statements.

2. Retrieving Reconciliation Files via SFTP Access

To retrieve reconciliation files via SFTP, please follow the application and retrieval process below:

After SFTP is enabled, the file path, compressed package, and file type of the corresponding bill are as follows:

SFTP File Path:

/upload/#{[year]}/
（Example: /upload/2023/）

Compressed Package File Name:

{[member_id]}#{[start_date]}#{[end_date]}.zip
（Example: 203242353454634545_20230301_20230301.zip）

Note:

member_id is the unique identifier for the merchant entity - platform entity.

File Type:

Report Type	Report Name	Description
Fund Detail Reconciliation Report	P010123456789_bill_20230301_20230301_0.csv P01010114310163 daily_fund_20241221202 41221_0.csv	For all merchants
Deposit Transaction Reconciliation Report	P010123456789_payin_20230301_20230301_0.csv	Required for merchants with acquiring business
Payment Transaction Reconciliation Report	P010123456789_payout_20230301_20230301_0.csv	Required for merchants with payment business
Settlement Detail Reconciliation Report	P010123456789_settlement_sum_20230301_20230301_0.csv P010123456789_settlement_detail_20230301_20230301_0.csv	Required for merchants with acquiring business and needing to reconcile according to settlement bills