Funding account activity daily report
Product version 3.91
Last edited January 2023
This report contains a detailed list of all funding account activity on all funding accounts on a specific day. The purpose of this report is to reconcile all funding account activity. It is generated daily and covers all transactions carried out on the previous day.
Latest version : 3.13.0
File repository path : Funding Account Activity/Daily
File name pattern : Funding_Account_Activity_daily
| REPORT CONTENT |
|---|
| startDate |
| The date when the transaction started. |
| transactionDate |
| The date when the balance movement was performed. |
| community |
| The name of the community to which a client belongs as set up in Nium. |
| client |
| The name of the client, as set up in Nium. |
| country |
| The country the client is based in. |
| transactionId |
| A unique transaction identifier. |
| adjustmentId |
| A unique identifier for each balance movement. |
NOTE
A transaction can have multiple balance movements
| transactionType |
| The type of activity carried out on a funding account. The following reported transaction types are available: |
| TRANSACTION TYPE | DESCRIPTION | TRANSACTION INFO FIELD |
|---|---|---|
| Transfer | Represents transfers to or from this funding account. | If the client initiates the transfer, this field contains NULL. If Nium initiates the transfer, this field contains comments entered by the Nium officer. |
| Fee reversal | Represents a reversal of a previous fee. | Contains the original transactionID of the transaction for which the fee is being reversed. |
| Bank deposit | Represents a deposit via a bank transfer. | It contains the name of the provider used to make the bank deposit. |
| Bank deposit reversal | Represents the reversal of a deposit to the funding account via a bank transfer. Possible reasons could be that the bank reverses the transaction, the client does not supply Nium with bank documents, etc. | Contains the original transactionID of the transaction for which the bank deposit is reversed. |
| Card return | Represents the withdrawal of funds to a bank card. | NULL |
| Bank return | Represents the withdrawal of funds to a bank account. | NULL |
| Bank return reversal | Represents the reversal of a fund transfer from the funding account to a bank account. Possible reasons could be incorrect bank details, canceled by the bank, canceled by Nium due to unapproved bank details, and more. | Contains the original transactionID of the transaction for which the bank return is being reversed. |
| Revenue share | Represents a revenue share deposit. | Contains comments entered by the Nium officer |
| Manual credit | Represents a positive manual adjustment on a card. | Contains comments entered by the Nium officer. |
| Manual debit | Represents a negative manual adjustment on a card. | Contains comments entered by the Nium officer. |
| Card created | Represents the creation of new cards (which could involve fund transfer). | NULL |
| Card deleted | Represents the deletion of cards (which could involve fund transfer). | NULL |
| Card deposit reversal | Represents the reversal of a deposit via a bank (credit/debit) card. | Contains the original transactionID of the transaction for which the card deposit is reversed. |
| Funding account created | Represents the creation of a new funding account. | NULL |
| Funding account deleted | Represents the deletion of a funding account. | NULL |
| Loss recovery | Represents negative card balance recovery. | NULL |
| transactionCurrency |
| The requested currency. For example, if the client requested 1000 GBP and the currency of the funding account is EUR, transactionCurrency is GBP. |
| transactionAmount |
| The requested amount represented in transactionCurrency. For example, if the client requested 1000 GBP, transactionAmount is 1000. |
| transactionAuthor |
| The author of the transaction (for example, username, API call). |
| sourceType |
| The source participant in the transaction. |
| sourceDetails |
| A friendly name of the source participant. |
| destinationType |
| The destination participant in the transaction. |
| destinationDetails |
| A friendly name of the destination participant. |
| participantType |
| The type of transaction participant (it can be a source or a destination participant). |
NOTE
For funding account reports, participantType is always Funding Account.
| PARTICIPANT TYPE | DESCRIPTION |
|---|---|
| Funding Account | An account maintained with Nium, used by a lien to issue and load virtual cards. |
| Virtual Card | A virtual card was issued through Nium. |
| Bank Card | The account holder’s bank card deposits funds to the funding account. |
| Bank Account | A bank account registered in Nium for bank transfers. |
| Manual Account |
|---|
| Manual accounts are tagged accounts used by Nium for manual adjustments. These include the following: |
| MANUAL ACCOUNT TYPE | DESCRIPTION |
|---|---|
| Revshare | This account is used to show revenue share credits/debits. |
| Forex_fee | This account is used to adjust forex credits/debits. |
| Misc_Clearing | Misc_Clearing This account is used to adjust one-off, occasional adjustments (supported by a note). |
| Testing | This account is used to adjust testing credits/debits. |
| Settlement_Loss | This account is used to collect losses on client settlement processing. |
| Settlement_Charge | This account collects fees associated with settlement charges (not collected by the system). |
| Dispute_Fee | This account is used to collect dispute fees on client requests. |
| Dispute_Won | This account is used to credit funds won related to disputes processed. |
| Card_Fee | This account is used to collect/refund card fee charges manually. |
| Transfer_Fee | This account is used to manually collect/refund fees generated on a transfer. |
| Bank_Charge | This account is used to collect/refund fees associated with a bank transfer. |
| Tracing_Charge | This account is used to collect/refund fees associated with a bank transfer trace. |
| Professional_Fee | This account collects fees associated to a bespoke task that had previously communicated a charge. |
| Setup_Fee | This account is used to collect/refund setup fees. |
| participantDetails |
| A friendly name of the participant. For example, bank account information (if the participant type is Bank Account), funding account name (if the participant is Funding Account), and so on. |
| participantSink |
| Possible values: SOURCE or DESTINATION. |
| originalCurrency |
| The original currency is as requested by the client. This is independent of the participant's currency. For example, if the client requested 1000 GBP and participantCurrency is EUR, the originalCurrency is 1000. |
| originalAmount |
| The amount requested by the client. This is independent of the participant's currency. For example, if the client requested 1000 GBP and participantCurrency is EUR, originalAmount is 1000. |
| participantCurrency |
| The currency of the participant (a funding account). For example, if the client requested 1000 GBP and the currency or the funding account is EUR, participantCurrency is EUR. |
| participantAmount |
| The requested amount is represent in the participant's currency (see participantCurrency). For example, if the client requested 1000 GBP, participantCurrency is EUR, and the current GBP to EUR exchange rate is 1.1, participantAmount is 1100. |
| exchangeRate |
| The exchange rate used between source currency and destination currency (if they are different). |
| nonForexFee |
| Non-Fore fees for the reported transaction, where applicable. |
| forexFee |
| Forex fees for the reported transaction, where applicable. |
| balanceBefore |
| The balance on the funding account before the transaction was processed. |
| balanceAdjustment |
| The adjustment amount on the funding account. |
| balanceAfter |
| The balance on the funding account after the transaction was processed. |
| status |
| Used to keep track of transactions. |
| STATUS | DESCRIPTION |
|---|---|
| Completed | The transaction has been completed successfully |
| Failed | The transaction has failed, and no fund movements have happened. |
| Initialised | The transaction is suspended, and funds have only been partially moved. |
| Initialised completed | The transaction was previously in a suspended state but has been resumed to completion successfully, and funds have also been fully moved. |
| Initialised failed | The transaction that was previously suspended has been resumed to a failed state. Therefore, initial fund movements have been reversed, and a new balance movement entry has been created. |
| forexFlag |
| Contains a Boolean flag indicating whether a transaction is Forex or not (possible values: Y/N). |
| direction |
| Contains a Boolean flag indicating whether a transaction is an advance or a reversal (possible values: A/R). |
| externalRef |
| A unique Nium reference of the funding account. |
| transactionInfo |
| Additional information is specific to each transaction type. |
Updated about 1 year ago