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
Payout Reconciliation
App-paid mode:Balance Verification
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.
Next Steps
Pricing & Fee Rates
Learn about the fee models and calculation methods for each step.
Transaction Status Reference
Learn the meaning of each transaction status.