Account Ledger Balance Report

Overview

This report lists every financial account in your organization with its Available Cash balance as of a date you choose. It is a snapshot, not an activity window: each row carries the latest balance recorded on or before the as-of date. Accounts with a zero balance are included.

Use it for month-end balance evidence, reconciliation against your own records, and audit support.

ReportType enum: ACCOUNT_LEDGER_BALANCE

Data availability

Data for this report is available as follows:

• Earliest available: 18 months from today
• Latest available: Yesterday, as of 5pm PT

Each day's balances are cut off at 5pm Pacific Time. Choosing a date returns the balances as of that cutoff.

Requesting through the API

Generate the report with the InitiateReport mutation, passing the variables below. This is a snapshot report, so only between.end is read; between.start is ignored. Set both to the same value, and pass the 5pm Pacific cutoff instant of the day you want. The as-of date is derived from that instant in Eastern time, so an instant earlier in the day can land on the previous date. For example, to request the balances as of August 31, 2026:

{
  "input": {
    "reportType": "ACCOUNT_LEDGER_BALANCE",
    "parameters": {
      "between": {
        "start": "2026-09-01T00:00:00Z",
        "end": "2026-09-01T00:00:00Z"
      }
    }
  }
}

2026-09-01T00:00:00Z is 5pm PDT on August 31. Passing 2026-08-31T00:00:00Z instead would return the August 30 snapshot.

Report fields

Field Name	Data Type	Description
report_as_of_date	Date	Calendar date the balance snapshot is taken at. Each day's data cuts off at 5pm PT. Same value on every row.
card_product_id	String	Unique identifier of the card product
card_product_name	String	Name of the card product
financial_account_id	String	Unique identifier of the financial account
financial_account_name	String	Name of the financial account as set by the subscriber. Empty when unnamed.
financial_account_external_id	String	The subscriber's own identifier for the account (externalId). Empty when not set.
account_holder_id	String	Public identifier of the account holder. Empty for accounts created without one.
account_category	String	FINANCIAL_ACCOUNT, EXTERNAL_FINANCIAL_BANK_ACCOUNT, or NON_VERIFIED_EXTERNAL_US_FINANCIAL_BANK_ACCOUNT, matching the AllFinancialAccount union
account_status	String	Account status, e.g. ACTIVE, SUSPENDED, CLOSED, UNACTIVATED, PENDING_CLOSE, RISK_REVIEW. These are the report's labels; PENDING_CLOSE and RISK_REVIEW correspond to PENDING_CLOSURE and UNDER_REVIEW in the FinancialAccountStatus API enum.
ledger_name	String	Ledger the balance is drawn from. Currently always AVAILABLE_CASH.
balance_amount	Decimal	Balance as of the cutoff in major currency units. Zero balances are included.
balance_amount_currency_code	String	ISO 4217 currency code (e.g., USD)
normal_balance	String	DEBIT or CREDIT: the direction that increases the ledger. CREDIT for AVAILABLE_CASH.
balance_platform_date	Date	Platform date of the balance entry used for the row. Never after report_as_of_date.