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 TYPEDESCRIPTIONTRANSACTION INFO FIELD
TransferRepresents 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 reversalRepresents a reversal of a previous fee.Contains the original transactionID of the transaction for which the fee is being reversed.
Bank depositRepresents a deposit via a bank transfer.It contains the name of the provider used to make the bank deposit.
Bank deposit reversalRepresents 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 returnRepresents the withdrawal of funds to a bank card.NULL
Bank returnRepresents the withdrawal of funds to a bank account.NULL
Bank return reversalRepresents 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 shareRepresents a revenue share deposit.Contains comments entered by the Nium officer
Manual creditRepresents a positive manual adjustment on a card.Contains comments entered by the Nium officer.
Manual debitRepresents a negative manual adjustment on a card.Contains comments entered by the Nium officer.
Card createdRepresents the creation of new cards (which could involve fund transfer).NULL
Card deletedRepresents the deletion of cards (which could involve fund transfer).NULL
Card deposit reversalRepresents 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 createdRepresents the creation of a new funding account.NULL
Funding account deletedRepresents the deletion of a funding account.NULL
Loss recoveryRepresents 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 TYPEDESCRIPTION
Funding AccountAn account maintained with Nium, used by a lien to issue and load virtual cards.
Virtual CardA virtual card was issued through Nium.
Bank CardThe account holder’s bank card deposits funds to the funding account.
Bank AccountA 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 TYPEDESCRIPTION
RevshareThis account is used to show revenue share credits/debits.
Forex_feeThis account is used to adjust forex credits/debits.
Misc_ClearingMisc_Clearing This account is used to adjust one-off, occasional adjustments (supported by a note).
TestingThis account is used to adjust testing credits/debits.
Settlement_LossThis account is used to collect losses on client settlement processing.
Settlement_ChargeThis account collects fees associated with settlement charges (not collected by the system).
Dispute_FeeThis account is used to collect dispute fees on client requests.
Dispute_WonThis account is used to credit funds won related to disputes processed.
Card_FeeThis account is used to collect/refund card fee charges manually.
Transfer_FeeThis account is used to manually collect/refund fees generated on a transfer.
Bank_ChargeThis account is used to collect/refund fees associated with a bank transfer.
Tracing_ChargeThis account is used to collect/refund fees associated with a bank transfer trace.
Professional_FeeThis account collects fees associated to a bespoke task that had previously communicated a charge.
Setup_FeeThis 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.
STATUSDESCRIPTION
CompletedThe transaction has been completed successfully
FailedThe transaction has failed, and no fund movements have happened.
InitialisedThe transaction is suspended, and funds have only been partially moved.
Initialised completedThe transaction was previously in a suspended state but has been resumed to completion successfully, and funds have also been fully moved.
Initialised failedThe 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.