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.
