Introduction
This report contains a breakdown of the sum of funds deposited and information about how these funds have been used.
This report aims to provide a high-level view of the flow of funds in Nium for a given period. The report is generated monthly.
This report is a spreadsheet with multiple sheets. It contains the main balance sheets (one per currency) and their associated detailed sheets. Each entry in the main balance sheet represents the transaction’s category and type, and includes a summary of the opening and closing balances for the given account.
The associated sheets contain information related to all balances within the account.
File repository path: Reconciliation
File name pattern: BalanceSheet_client
Report frequency: Monthly
Balance Sheet Report
| MAIN BALANCE SHEET REPORT CONTENT |
|---|
| CASH IN |
| CASH OUT |
| Field | Description |
|---|---|
| Bank transfer | Represents the amount of funds deposited into the balance from client bank accounts. |
| Internal transfer | Represents the funds deposited from another Balance (in the same or different currency). |
| Manual Adjustment | Represents the amount of manual adjustment credits. Note: See Manual Adjustments for a more detailed description of manual adjustments. |
| Purchase | Represents the amount of merchant purchases performed through virtual cards. |
| Purchase Refund | Represents the amount of purchase refunds processed on the cards. |
| Transaction fee | Represents fees associated with all transactions performed. |
| Forex fee | Represents Forex fees associated with all transactions performed. |
| Revenue Share | Represents DR or CR revenue share |
| Dispute Won | Represents the amount of disputes won. |
| MAIN BALANCE SHEET REPORT CONTENT |
|---|
| BALANCE |
| Field | Description |
|---|---|
| Opening Balance | Represents the total balance of a Balance account (for one specific currency) at the start of the period covered by the report. |
| Closing Balance | Represents the total balance of a Balance (for one specific currency) at the end of the period covered by the report. |
Associated detailed sheets
The following associated detailed sheets are available:
| Content |
|---|
| Balances |
This sheet contains all the details of the balances of the accounts.
Balances Report
| Field | Description |
|---|---|
| Balance Name | Balance name. |
| Balance Reference | Unique balance reference identifier. |
| Currency | Currency of the balance. |
| Opening Actual Balance | Represents the balance of a Balance at the start of the period covered by the report. |
| Closing Actual Balance | Represents the balance of a Balance at the end of the period covered by the report. |