BalanceTransactions
Returns the balance transactions that contribute to your Stripe balance, including the amount, fees, net amount, and source of each transaction.
View-Specific Information
SELECT
The add-in uses the Stripe API to filter the results by the following columns and operators while the rest of the filter is executed client-side within the add-in.
| Column | Supported Operators |
| Id | = |
| Currency | = |
| SourceId | = |
| Type | = |
| Payout | = |
| AccountId | = |
| Created | >, >=, <, <=, = |
You can select from BalanceTransactions with the following queries:
SELECT * FROM BalanceTransactions
SELECT * FROM BalanceTransactions WHERE Id = 'txn_1K2M4c2eZvKYlo2C1C1A1bQq'
SELECT * FROM BalanceTransactions WHERE SourceId = 're_3SzcKHHWDgcyHde01N5j7eGS'
SELECT * FROM BalanceTransactions WHERE Created >= '2023-01-01' AND Created <= '2023-12-31'
You can also filter balance transactions by a specified payout:
SELECT * FROM BalanceTransactions WHERE Payout = '123'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The Id of the balance transaction. | |
| Amount | Integer | The gross amount of the transaction, in cents. | |
| AvailableOn | Datetime | The date the net funds of the transaction become available in the Stripe balance. | |
| Created | Datetime | The date and time at which the transaction was created. | |
| Currency | String | The currency of the transaction. | |
| Description | String | The transaction description. | |
| Fee | Integer | The fees, in cents, paid for this transaction. | |
| FeeDetailsAggregate | String | The fee details. | |
| Net | Integer | The net amount of the transaction, in cents. | |
| Source | String | The Stripe object this transaction is related to. | |
| Status | String | Indicates whether the net funds of the transaction are available in the Stripe balance. Either available or pending. | |
| Type | String | The type of the transaction.
The allowed values are tax_fund, adjustment, advance, advance_funding, anticipation_repayment, application_fee, application_fee_refund, charge, climate_order_purchase, climate_order_refund, connect_collection_transfer, contribution, inbound_transfer, inbound_transfer_reversal, issuing_authorization_hold, issuing_authorization_release, issuing_dispute, issuing_transaction, obligation_outbound, obligation_reversal_inbound, payment, payment_failure_refund, payment_network_reserve_hold, payment_network_reserve_release, payment_refund, payment_reversal, payment_unreconciled, payout, payout_cancel, payout_failure, payout_minimum_balance_hold, payout_minimum_balance_release, refund, refund_failure, reserve_transaction, reserved_funds, reserve_hold, reserve_release, stripe_fee, stripe_fx_fee, stripe_balance_payment_debit, stripe_balance_payment_debit_reversal, tax_fee, topup, topup_reversal, transfer, transfer_cancel, transfer_failure, transfer_refund, fee_credit_funding. | |
| ReportingCategory | String | The reporting category that helps you understand balance transactions from an accounting perspective. | |
| ExchangeRate | Decimal | The exchange rate used, if applicable, for this transaction. | |
| BalanceType | String | The type of balance. One of available, issuing, or other.
The allowed values are available, issuing, other. | |
| SourceId | String | The Id of the Stripe object this balance transaction is related to. |
Pseudocolumns
Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description | |
| Transfer | String | DEPRECATED. For automatic Stripe transfers only, returns only transactions that were transferred out on the specified transfer Id. | |
| Payout | String | For automatic Stripe payouts only, returns only transactions that were paid out on the specified payout Id. | |
| AccountId | String | The Id of the connected account for which to retrieve balance history. |