Reconciliation File Retrieval

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

Method 1: Download reconciliation files through PayerMax's MMC platform;

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 [Appendix - Reconciliation Service - Reconciliation File Content]).

1. Downloading Reconciliation Files via MMC Platform

(1) Bill Download Request

On the MMC platform's [Bill Reports] - [Bill Download] page, merchants can download three types of bills:【Settlement Report】【Funds Detail Report】【Payin Transaction Reportl】【Payout Transaction Report】. You can download Reports for the past 2 years, and the maximum time range for a single download is 180 days.

Additionally, email delivery is supported. When submitting a download request, if an email is provided, the exported results will be sent as a compressed package to the specified email addresses (up to 5 emails separated by commas).

(2) Successful File Generation and Download

The generated bill files can be viewed on the list page. After clicking download, the compressed package can be downloaded locally.

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