Fundamental Principles and Implementation of a Payment System Reconciliation Center

In payment systems, fund reconciliation is performed in the reconciliation center by matching system‑recorded transaction flows with bank‑provided clearing flows to ensure the consistency of expected and actual fund movements for each bank account.

1. Clearing Reconciliation System

The payment company's financial services rely on bank funds; all internal account balances correspond one‑to‑one with bank deposits. To guarantee correct conversion between real and virtual funds, the company must promptly reconcile all business‑related fund movements with the bank.

1.1 Funds Inflow Reconciliation

Bank‑initiated fund transfers are notified to the payment company in real time. At night, the bank aggregates these transfers and credits the company's bank account, providing a clearing file. The company imports this file and matches it against its business data.

(1) Bank recharge records exceed system records – temporary pending entries are created. (2) Bank recharge records are fewer than system records – potential loss, also handled with temporary pending entries.

1.2 Funds Outflow Reconciliation

When users request withdrawals, the company sends batch withdrawal requests to the bank. The bank processes them and returns success or failure files. Successful withdrawals are matched; failed withdrawals are directly refunded to the user without passing through the reconciliation center.

2. What Is Reconciliation

2.1 Definition of Fund Reconciliation

In accounting, reconciliation ensures that ledger entries are correct (accuracy), supported by evidence (authenticity), and consistent across records (consistency). In payment institutions, it means matching system‑saved transaction flows with bank‑provided clearing flows to guarantee that each bank account’s expected and actual balances are identical.

2.2 Role of the Reconciliation Center

The center mainly handles clearing reconciliation, receiving data from both the accounting system and the clearing system, and matching them.

3. Reconciliation Content and Data Sources

Step 1: Verify entry flows against clearing flows to ensure each order’s bank result matches the system result. Step 2: Compare the reconciliation summary sheet with the bank statement to confirm that all business‑level bank results align with actual cleared funds.

3.1 Reconciliation Business Process

The process includes importing clearing files, matching flows, classifying, summarizing, handling pending entries, and final ledger posting.

3.2 Reconciliation Center Main Functions

Key functions include importing clearing data, performing one‑to‑one, many‑to‑many, and one‑to‑many matching based on channel, order number, amount, and business code, and marking statuses such as "reconciliation successful", "amount mismatch", or "bank excess".

4. Reconciliation Center Function Module Analysis

4.1 Acquiring Reconciliation Data

Clearing files are imported manually or automatically; different business types have distinct parsing logic.

4.2 Clearing Flow Reconciliation

Images illustrate the flow (see below).

4.3 Reconciliation Logic

(1) One‑to‑One Reconciliation

Each entry flow matches a single bank flow. Supported business codes include various recharge and withdrawal types (e.g., 500401 – successful withdrawal, 400301 – personal online banking recharge).

(2) Many‑to‑Many Reconciliation

When multiple entry flows share the same order, channel, and amount, they are matched with multiple bank flows on a first‑come‑first‑served basis. Example codes: 410401 – charge‑back, 410402 – corporate charge‑back.

(3) One‑to‑Many Reconciliation

Multiple entry flows are matched against a single bank flow, commonly for overseas settlement (e.g., 520101 – overseas purchase deduction, 400319 – foreign exchange replenishment).

4.4 Reconciliation Functions

(1) Internal Flow Offsetting

For withdrawals, the system creates both a debit and a corresponding credit flow; these are offset internally without involving the bank.

(2) Reconciliation Summary Confirmation

After matching, users confirm results; successful matches move to historical tables, while mismatches require manual adjustment.

(3) Flow Classification and Pending Entry Aggregation

Pending ("bank excess") flows can be classified and aggregated for pending posting, using predefined business codes (e.g., 700101 – other payable).

(4) Clearing/Entry/Historical Flow Management

Provides query, modify, delete, and import capabilities for clearing flows; entry flows are read‑only to prevent tampering.

4.5 Bank Balance Entry

Allows manual entry of actual bank balances, which are later verified against imported balances before becoming effective.

4.6 Internal Account Posting

Handles non‑bank pending items such as clearing fees and interest, ensuring double‑entry bookkeeping rules are met.

4.7 Pending Income Posting and Confirmation

Registers pending income from banks, then confirms and clears it, following strict validation (one debit, one credit, positive amount, correct account types).

4.8 Pending Expense Posting and Confirmation

Similar to pending income but for expenses, with validation that the debit side is an internal account and the credit side is a bank account.

5. Unexpected Data Recovery Logic

5.1 Types of Unexpected Data

(1) Duplicate payments – same internal order paid multiple times. (2) Payment failure with amount mismatch – buyer’s paid amount differs from transaction amount. (3) Payment success with amount mismatch – order marked successful but amount differs due to network or bank issues.

5.2 Reconciliation and Exception Recovery Logic

(1) Use merchant‑successful orders as the source of truth.

If the merchant shows a successful order while the backend is initial or failed, update the backend to success.

(2) Avoid duplicate recovery.

Recover T‑day orders on T+1 day only once; do not re‑download after recovery.

(3) Time‑zone differences.

Bank cut‑off times vary, causing mismatches between merchant and backend data; the system accounts for these differences during reconciliation.

Overall, the reconciliation center ensures that every fund movement recorded by the payment system aligns with the bank’s clearing records, providing mechanisms for matching, pending handling, manual adjustments, and exception recovery.