Skip to main content
Used when funds have settled to your FBO account but not yet posted to your end-user accounts.
Applicalbe to Balance Type = Deposit Only
This file lists transactions where funds have settled to your FBO account but not yet posted to individual end-user accounts. Transactions remain in this file for N days until posted. Inaccurate data may risk proper account funding and disrupt program operations.
For all optional fields where you do not plan to pass through data, please include the header and a null value.

IDs & Details

FieldDescriptionRequiredData Type
transaction_idThe unique ID for the transaction.Requiredstring
balance_idUnique ID of the balance.Optionalstring
settlement_group_idIf this transaction is net settled, a unique ID to group all transactions in the net settlement.Optionalstring

Transaction Information

FieldDescriptionRequiredData Type
amountTransaction amountRequirednumber
currency decimals
currencyThe currency code for the transaction. 3 letter code, e.g. USDRequiredISO4217
amount_in_usdTransaction amount in USD. Only required if currency is not USD.Required if the program can have non-USD balancesnumber decimal(M,2)
typeTransaction type.Requiredenum
transfer_typeType of transfer rail.Requiredenum
reconciliation_noteDetails to explain why the transaction is unsettled.Requiredstring
settlement_dateThe settlement date of this transaction.Requireddate
YYYY-MM-DD
transfer_idThe unique ID for the related transfer object, if applicable (e.g. the ACH ID or Internal Transfer ID generated by Lead)Optionalstring
statement_descriptionThe description on the customers statement for this transaction.Optionalstring

Other

FieldDescriptionRequiredData Type
generated_atThe day this file is generated. This should always be the date the file is sent to Lead Bank.Requireddatetime
ISO8601
effective_atThe timestamp of when the related object(s) were polled to collect the information for this record.Requireddatetime
ISO8601