Daily account activity

3min

The purpose of this section is to explain the Daily Account Activity report. This report lets you see all the money movement for a single given master account.
This report can be used to reconcile between what you requested from COS and what COS actually processed.
Glossary
Term
Description
CRB
Cross River Bank
Partner
CRB’s immediate customer, i.e. you
The table below shows the different columns included in the report together with descriptions and explanations of the information they represent.
Column
Description
Id
This is internal to CRB and can be disregarded.
TransactionId
Unique identification number for the related core transaction.
TraceNumber
A unique number assigned to the transaction by COS.
Status
Transaction status.
TransactionType
Core transaction type, which can be either Debit or Credit.
ActivityType
Indicates whether the activity is internal (between two sub accounts under the same master account) or external (between two master accounts).
Source
Activity type, which includes:
Transaction: Activity from transactions will first soft post, remaining as status pending for the day, and later hard post during the nightly settlement process. Once hard posted a sequence number and running balance are assigned.
MemoPosts: Activity from memo posts are a temporary debit or credit on the account. Commonly they will be removed and then posted as a transaction.
MasterAccountNumber
Master account affected by the transaction.
SubAccountNumber
Sub ledger account affected by the transaction.
TransactionCode
Indicates transaction types as follows:
Incoming ACH
Outgoing ACH
Account Transfer
Fee
Fee Refund
Deposit
Withdrawal
Interest
Misc Credit
Misc Debit
Incoming Wire
Outgoing Wire
Check
Cash
Reversal
Adjustment
Sale
Card Auth
Payment
Refund
ATM Transaction
Zelle Debit
Zelle Credit
RTP Debit
RTP Credit
Description
Transaction description.
Rail
Rail type (i.e. ACH, Wires, etc.)
RailId
Rail ID, which is a combination of the transaction code and the payment ID.
Amount
Transaction amount.
Balance
Balance resulting from the transaction.
SequenceNumber
Sequence number of the payment in the batch. The sequence number is inserted once the transaction has been posted.
ProductId
Product identifier for the account involved in the transaction.
PartnerId
Unique identification number for the partner resource.
ExecutedAt
Date and time the transaction was executed.
PostingDate
Transaction posting date.
PostedAt
Date and time the transaction was posted, specifically at end of day settlement.
CreatedAt
Date and time the transaction was created.
LastModifiedAt
Date and time of the last change to the resource record.
Flags
An additional identifier added to certain transaction scenarios.
Daily Account Balance By Partner Report
The purpose of this section is to explain the Daily Account Balance By Partner report. This report lets you see the daily account balances for all the master accounts of a single given partner.
This report can be used to reconcile between what you requested from COS and what COS actually processed.
Column
Description
Account Number
Account Number.
Account_Title
Title of the account.
Account_Type
Account type.
Date_Account_Opened
Date on which the account was opened.
Available_Balance
Total available balance of the account.
Current_Balance
Total current balance of the account.
﻿

Term	Description
CRB	Cross River Bank
Partner	CRB’s immediate customer, i.e. you

Column	Description
Id	This is internal to CRB and can be disregarded.
TransactionId	Unique identification number for the related core transaction.
TraceNumber	A unique number assigned to the transaction by COS.
Status	Transaction status.
TransactionType	Core transaction type, which can be either Debit or Credit.
ActivityType	Indicates whether the activity is internal (between two sub accounts under the same master account) or external (between two master accounts).
Source	Activity type, which includes: Transaction: Activity from transactions will first soft post, remaining as status pending for the day, and later hard post during the nightly settlement process. Once hard posted a sequence number and running balance are assigned. MemoPosts: Activity from memo posts are a temporary debit or credit on the account. Commonly they will be removed and then posted as a transaction.
MasterAccountNumber	Master account affected by the transaction.
SubAccountNumber	Sub ledger account affected by the transaction.
TransactionCode	Indicates transaction types as follows: Incoming ACH Outgoing ACH Account Transfer Fee Fee Refund Deposit Withdrawal Interest Misc Credit Misc Debit Incoming Wire Outgoing Wire Check Cash Reversal Adjustment Sale Card Auth Payment Refund ATM Transaction Zelle Debit Zelle Credit RTP Debit RTP Credit
Description	Transaction description.
Rail	Rail type (i.e. ACH, Wires, etc.)
RailId	Rail ID, which is a combination of the transaction code and the payment ID.
Amount	Transaction amount.
Balance	Balance resulting from the transaction.
SequenceNumber	Sequence number of the payment in the batch. The sequence number is inserted once the transaction has been posted.
ProductId	Product identifier for the account involved in the transaction.
PartnerId	Unique identification number for the partner resource.
ExecutedAt	Date and time the transaction was executed.
PostingDate	Transaction posting date.
PostedAt	Date and time the transaction was posted, specifically at end of day settlement.
CreatedAt	Date and time the transaction was created.
LastModifiedAt	Date and time of the last change to the resource record.
Flags	An additional identifier added to certain transaction scenarios.

Column	Description
Account Number	Account Number.
Account_Title	Title of the account.
Account_Type	Account type.
Date_Account_Opened	Date on which the account was opened.
Available_Balance	Total available balance of the account.
Current_Balance	Total current balance of the account.

Overdrawn account

Daily ACH payments