Reconciliation & Reports

The NUSDpay admin console provides a statement export feature. Merchants can export transaction details by project and date range for financial verification and reconciliation.

Export Method

In the admin console, go to the Report page, click the Export button, select filter conditions, and download the Excel file.

Filter Conditions

Condition	Description
Project	Select a specific project, or export aggregated data for all projects
Date Range	Select start and end dates (default: last 30 days)

Statement Field Description

The exported Excel statement contains the following fields:

Field	Description
No.	Record number
Transaction Created At	Time when the transaction was initiated
Transaction Posted At	Time when the transaction was posted
Transaction Type	Gateway Payin / Gateway Payout / Settlement / Transfer / Add Balance / Deduct Balance
Exchange Rate	The actual exchange rate of this transaction
Credit Amount	Credit amount of this transaction (incoming direction)
Debit Amount	Debit amount of this transaction (outgoing direction)
Transaction Currency	USD
Fee	Fee amount of this transaction
Fee Currency	The denomination currency of the fee
Fee Type	App (paid by merchant) / User (paid by end user)
Account Balance	NUSD account balance after this transaction is completed
Transaction ID	Unique transaction identifier, usable for cross-system reconciliation matching
Project	Name of the project this transaction belongs to

Transaction Type Description

The transaction types in the statement correspond to the following business operations:

Transaction Type	Corresponding Business	Amount Direction
Gateway Payin	Payin - end user pays the merchant	Credit (+)
Gateway Payout	Payout - merchant pays the end user	Debit (-)
Settlement	Settlement - NUSD settled to USD fiat	Debit (-)
Transfer	Transfer - NUSD transferred between projects	Credit/Debit
Add Balance	Manual adjustment (increase)	Credit (+)
Deduct Balance	Manual adjustment (decrease)	Debit (-)

Reconciliation Process

Export the NUSDpay statement

On the Report page of the admin console, select the project and date range, and export the Excel statement.

Export the merchant system statement

Export the transaction records for the same time period from the merchant’s own business system.

Match transactions by Transaction ID

Use Transaction ID (transaction_id) as the join key to verify amount, status, and time for each transaction.

Verify aggregated data

Compare the total credits, total debits, total fees, and balance changes on both sides to confirm consistency.

Handle discrepancies

If discrepancies are found, check the following common causes:

Inconsistent transaction status (e.g., Payout in transit, not yet completed)
Exchange rate precision differences
Different fee calculation methods (App-paid vs User-paid)
Date boundary shifts due to timezone differences

Reconciliation Formulas

Payin Reconciliation

Merchant Credit (NUSD) = End User Transfer Amount × Exchange Rate × (1 - Payin Fee Rate)

Verification point: “Credit Amount” + “Fee” in the statement should equal the end user’s on-chain transfer amount × exchange rate.

Payout Reconciliation

App-paid mode:

End User Received = Payment Amount × Exchange Rate
Merchant Deducted = Payment Amount + Fee

User-paid mode:

End User Received = Payment Amount × (1 - Payout Fee Rate) × Exchange Rate
Merchant Deducted = Payment Amount

Balance Verification

Closing Balance = Opening Balance + Σ Credit Amount - Σ Debit Amount

Each transaction in the statement records the “Account Balance” after the transaction, allowing balance changes to be traced transaction by transaction.

Permission Description

Role	Export Scope
Super Admin	Can export statements for all projects or a specified project
Project Admin	Can export statements for the current project or all authorized projects
Finance / Operator (Payout)	Can export statements for the current project

Super Admin and Finance roles can see the “Fee Type” field in the statement; this field is not displayed for other roles.

Overview

Analytics

Transactions

Funds