Stripe: Balance Transactions

Description

• Each record represents a change to your account balance, enriched with data about the transaction.

Supported Data Sources

• Stripe

Columns

Type	Name	Description
STRING	balance_transaction_id	Unique identifier for the transaction.
DATETIME	balance_transaction_created_at	When the transaction took place
DATETIME	balance_transaction_available_on	The date the transaction’s net funds will become available in the Stripe balance.
STRING	balance_transaction_currency	Three-letter ISO currency code, in lowercase.
INTEGER	balance_transaction_amount	Gross amount of the transaction, in cents.
INTEGER	balance_transaction_fee	Fees (in cents) paid for this transaction.
INTEGER	balance_transaction_net	Net amount of the transaction, in cents. Gross amount minus fees, refunds, and disputes
STRING	balance_transaction_source_id	The Stripe object to which this transaction is related.
STRING	balance_transaction_description	An arbitrary string attached to the object. Often useful for displaying to users.
STRING	balance_transaction_type	The type of transaction. Possible values are adjustment, advance, advance_funding, application_fee, application_fee_refund, charge, connect_collection_transfer, issuing_authorization_hold, issuing_authorization_release, issuing_dispute, issuing_transaction, payment, payment_failure_refund, payment_refund, payout, payout_cancel, payout_failure, refund, refund_failure, reserve_transaction, reserved_funds, stripe_fee, stripe_fx_fee, tax_fee, topup, topup_reversal, transfer, transfer_cancel, transfer_failure, or transfer_refund.
STRING	balance_transaction_reporting_category	Groupings of transactions types based on how they show in Stripe's reporting
INTEGER	customer_facing_amount	The transaction amount that the customer sees.
STRING	customer_facing_currency	Three-letter ISO currency code that the customer sees.
DATETIME	effective_at	calendar day after available_at
STRING	automatic_payout_id	(Applies only to accounts on automatic payouts.) The unique ID for the associated payout.
STRING	payout_id	ID for the payout associated with this balance transaction
DATETIME	payout_created_at	Time at which the payout record was created.
STRING	payout_currency	Three-letter ISO currency code of the payout, in lowercase.
BOOLEAN	payout_is_automatic	True if the payout was created by an automated payout schedule, and false if it was requested manually.
DATETIME	payout_arrival_date_at	Date the payout is expected to arrive in the bank. This factors in delays like weekends or bank holidays.
DATETIME	automatic_payout_effective_at	The date we expect this automatic payout to arrive in your bank account, in UTC. This is also when the paid-out funds are deducted from your Stripe balance.
STRING	payout_type	Whether the payout was to a bank_account or card.
STRING	payout_status	Current status of the payout. Can be paid, pending, in_transit, canceled or failed.
STRING	payout_description	An arbitrary string attached to the payout. Often useful for displaying to users.
STRING	destination_bank_account_id	ID of the bank account the payout was sent to.
STRING	destination_card_id	ID of the card the payout was sent to.
STRING	customer_id	The customer associated with the balance transaction (based on charge or refund details)
STRING	receipt_email	The email the receipt was emailed to for this transaction.
STRING	customer_email	The customer’s email address.
STRING	customer_name	Customer name.
STRING	customer_description	The description field associated with the customer
STRING	customer_shipping_address_line_1	Attribute of the customer's shipping address.
STRING	customer_shipping_address_line_2	Attribute of the customer's shipping address.
STRING	customer_shipping_address_city	Attribute of the customer's shipping address.
STRING	customer_shipping_address_state	Attribute of the customer's shipping address.
STRING	customer_shipping_address_postal_code	Attribute of the customer's shipping address.
STRING	customer_shipping_address_country	Attribute of the customer's shipping address.
STRING	customer_address_line_1	Address line 1 (e.g., street, PO Box, or company name).
STRING	customer_address_line_2	Address line 2 (e.g., apartment, suite, unit, or building).
STRING	customer_address_city	City, district, suburb, town, or village.
STRING	customer_address_state	State, county, province, or region.
STRING	customer_address_postal_code	ZIP or postal code.
STRING	customer_address_country	Two-letter country code (ISO 3166-1 alpha-2).
STRING	charge_shipping_address_line_1	Address line 1 (e.g., street, PO Box, or company name) belonging to the charge.
STRING	charge_shipping_address_line_2	Address line 2 (e.g., apartment, suite, unit, or building) belonging to the charge.
STRING	charge_shipping_address_city	City, district, suburb, town, or village belonging to the charge.
STRING	charge_shipping_address_state	State, county, province, or region belonging to the charge.
STRING	charge_shipping_address_postal_code	ZIP or postal code belonging to the charge.
STRING	charge_shipping_address_country	Two-letter country code (ISO 3166-1 alpha-2) belonging to the charge.
STRING	card_address_line_1	Address line 1 (e.g., street, PO Box, or company name).
STRING	card_address_line_2	Address line 2 (e.g., apartment, suite, unit, or building).
STRING	card_address_city	City, district, suburb, town, or village.
STRING	card_address_state	State, county, province, or region.
STRING	card_address_postal_code	ZIP or postal code.
STRING	card_address_country	Two-letter country code (ISO 3166-1 alpha-2).
STRING	charge_id	The id of the charge associated with the balance transaction
DATETIME	charge_created_at	Timestamp of the charge object associated with the balance transaction
STRING	payment_intent_id	The id of the payment intent associated with the balance transaction
STRING	invoice_id	The ID of the invoice this record is a part of.
STRING	invoice_number	The number of the invoice associated with this record.
STRING	subscription_id	The ID of the subscription is associated with this record.
STRING	payment_method_type	The id of the payment method type associated with the balance transaction
STRING	payment_method_brand	Card brand used for the payment method. Can be American Express, Diners Club, Discover, JCB, MasterCard, UnionPay, Visa, or Unknown.
STRING	payment_method_funding	Card funding type for the payment method. Can be credit, debit, prepaid, or unknown.
STRING	card_brand	The brand of the card associated with the balance transaction
STRING	card_funding	Card funding type. Can be credit, debit, prepaid, or unknown.
STRING	card_country	The country the card was issued in.
STRING	charge_statement_descriptor	Extra information about a source. This will appear on your customer’s statement every time you charge the source.
STRING	dispute_id	Unique identifier for the object.
STRING	dispute_reason	Reason given by cardholder for dispute. Possible values are bank_cannot_process, check_returned, credit_not_processed, customer_initiated, debit_not_authorized, duplicate, fraudulent, general, incorrect_account_details, insufficient_funds, product_not_received, product_unacceptable, subscription_canceled, or unrecognized.
STRING	refund_id	ID of the refund associated with this record.
STRING	refund_reason	Reason for the refund, either user-provided (duplicate, fraudulent, or requested_by_customer) or generated by Stripe internally (expired_uncaptured_charge).
STRING	transfer_id	ID of the transfer associated with this record.
STRING	connected_account_id	The ID of the account connected to the transaction.
STRING	connected_account_country	The country of the account connected to the transaction.
STRING	connected_account_direct_charge_id	(Beta) For Stripe Connect activity related to a connected account, charge id of the direct charge that happened on connected account.
STRING	source_relation	The source where this data was pulled from. If you are making use of the union_schemas variable, this will be the source schema. If you are making use of the union_databases variable, this will be the source database. If you are not unioning together multiple sources, this will be an empty string.