Summary Reserved Accounts

Date Range: None — reflects current balances as of run time

Description

A comprehensive snapshot of each sub-merchant's current financial position: reserve balance, unsettled activity, and any Real-Time Payment (RTP) exposure. Only merchants with non-zero balances in any category appear on this report.

Columns

Column

Type

Description

COMP_NUM

text(10)

Merchant number of the sub-merchant.

SETTLEMENT

currency

Current reserve balance from settled transactions (Deposit Source 1).

RETURN

currency

Reserve balance allocated to cover returns (Deposit Source 2).

CREDITS_DEPOSIT

currency

Reserve balance from credit deposits (Deposit Source 3).

WIRE_RESERVE

currency

Reserve balance held via wire (Deposit Source 4).

SETTLEMENT_TO_PARENT

currency

Reserve amount settled to the parent merchant (Deposit Source 5).

CG_DEPOSIT

currency

Reserve balance from CG deposits (Deposit Source 6).

WIRE

currency

Wire balance (Deposit Source 7).

FULLAMOUNT

currency

Total reserve balance across all sources.

SentUnsettledCredits

currency

Credits sent to the banking network that have not yet settled.

UnSettledReturnsAmounts

currency

Dollar value of returns received that have not yet been settled against reserves.

SentUnsettledDebits

currency

Debits sent to the banking network that have not yet settled.

SentUnsettledCreditsExtended

currency

Extended calculation of unsettled credits including all non-standard transaction codes.

ReturnedUnsettledAmount

currency

Returns received today (bank processing date) not yet reflected in settled reserves.

RTPPayments

currency

Real-Time Payments funded but not yet settled.

RTPAvailableBalance

currency

Available reserve balance after subtracting unsettled credits, unsettled returns, and RTP exposure. Calculated as FULLAMOUNT − SentUnsettledCreditsExtended − ReturnedUnsettledAmount − RTPPayments.