Stripe: Ending Balance Reconciliation Itemized 4

Description

• Modeled after the titular report from Stripe, each record represents an automatic payout and additional details such as associated customer, shipping, card, subscription information. This report belongs to the class of Payout Reconciliation reports. The Payout reconciliation report helps you match the payouts you receive in your bank account with the batches of payments and other transactions that they relate to. The payout reconciliation report is only available for users with automatic payouts enabled, and is optimized for users who prefer to reconcile the transactions included in each payout as a settlement batch. If you use manual payouts or prefer to track and reconcile your Stripe balance like a bank account, see the Balance report instead. To help you decide which report is right for you, see the guide for selecting reports. This Ending Balance Reconciliation section provides a similar breakdown of the transactions that hadn’t been settled as of the report’s end date.

Supported Data Sources

• Stripe

Columns

Type	Name	Description
STRING	automatic_payout_id	ID of the automatically created payout associated with this balance transaction (only set if your account is on an automatic payout schedule).
DATETIME	automatic_payout_effective_at	The date we expect this automatic payout to arrive in your bank account, in the requested timezone, or UTC if not provided. This is also when the paid-out funds are deducted from your Stripe balance.
STRING	balance_transaction_id	Unique identifier for the balance transaction.
DATETIME	created	Time at which the balance transaction was created. Dates in the requested timezone, or UTC if not provided.
DATETIME	available_on	The date the balance transaction’s net funds will become available in the Stripe balance. Dates in the requested timezone, or UTC if not provided.
STRING	currency	Three-letter ISO code for the currency in which gross, fee and net are defined.
INTEGER	gross	Gross amount of the transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY).
INTEGER	fee	Fees paid for this transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY).
INTEGER	net	Net amount of the transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY).
STRING	reporting_category	Reporting Category is a new categorization of balance transactions, meant to improve on the current type field.
STRING	source_id	The Stripe object to which this transaction is related.
STRING	description	An arbitrary string attached to the balance transaction. Often useful for displaying to users.
INTEGER	customer_facing_amount	For transactions associated with charges, refunds, or disputes, the amount of the original charge, refund, or dispute. If the customer was charged in a different currency than your account’s default, this field will reflect the amount as seen by the customer.
STRING	customer_facing_currency	For transactions associated with charges, refunds, or disputes, the three-letter ISO currency code for customer_facing_amount.
STRING	customer_id	The unique ID of the related customer, if any.
STRING	customer_email	Email address of the customer, if any, associated with this balance transaction.
STRING	customer_name	Name of the customer, if any, associated with this balance transaction.
STRING	customer_description	Description provided when creating the customer, often used to store the customer name.
STRING	customer_shipping_address_line_1	First line of the customer shipping address associated with this charge, if any
STRING	customer_shipping_address_line_2	Second line of the customer shipping address associated with this charge, if any
STRING	customer_shipping_address_city	City of the customer shipping address associated with this charge, if any
STRING	customer_shipping_address_state	State of the customer shipping address associated with this charge, if any
STRING	customer_shipping_address_postal_code	Postal code of the customer shipping address associated with this charge, if any
STRING	customer_shipping_address_country	Country of the customer shipping address associated with this charge, if any
STRING	customer_address_line_1	First line of the customer address associated with this charge, if any
STRING	customer_address_line_2	Second line of the customer address associated with this charge, if any
STRING	customer_address_city	City of the customer address associated with this charge, if any
STRING	customer_address_state	State of the customer address associated with this charge, if any
STRING	customer_address_postal_code	Postal code of the customer address associated with this charge, if any
STRING	customer_address_country	Country of the customer address associated with this charge, if any
STRING	shipping_address_line_1	First line of the shipping address associated with this charge, if any
STRING	shipping_address_line_2	Second line of the shipping address associated with this charge, if any
STRING	shipping_address_city	City of the shipping address associated with this charge, if any
STRING	shipping_address_state	State of the shipping address associated with this charge, if any
STRING	shipping_address_postal_code	Postal code of the shipping address associated with this charge, if any
STRING	shipping_address_country	Country of the shipping address associated with this charge, if any
STRING	card_address_line_1	First line of the card address associated with this charge, if any
STRING	card_address_line_2	Second line of the card address associated with this charge, if any
STRING	card_address_city	City of the card address associated with this charge, if any
STRING	card_address_state	State of the card address associated with this charge, if any
STRING	card_address_postal_code	Postal code of the card address associated with this charge, if any
STRING	card_address_country	Country of the card address associated with this charge, if any
STRING	charge_id	Unique identifier for the original charge associated with this balance transaction. Available for charges, refunds and disputes.
STRING	payment_intent_id	The unique ID of the related Payment Intent, if any.
DATETIME	charge_created	Creation time of the original charge associated with this balance transaction. Available for charges, refunds and disputes. For charges that were separately authorized and captured, this is the authorization time. Dates in the requested timezone, or UTC if not provided.
STRING	invoice_id	Unique ID for the invoice associated with this balance transaction. Available for charges, refunds, and disputes made in connection with a Stripe Billing invoice.
STRING	invoice_number	Unique Number for the invoice associated with this balance transaction. Available for charges, refunds, and disputes made in connection with a Stripe Billing invoice.
STRING	subscription_id	Unique ID for the subscription associated with this balance transaction. Available for charges, refunds, and disputes made in connection with a Stripe Billing subscription.
STRING	payment_method_type	The type of payment method used in the related payment.
STRING	card_brand	Card brand, if applicable.
STRING	card_funding	Card funding type, if applicable.
STRING	card_country	Two-letter ISO code representing the country of the card.
STRING	statement_descriptor	The dynamic statement descriptor or suffix specified when the related charge was created.
STRING	dispute_reason	Reason given by cardholder for dispute. Read more about dispute reasons.
STRING	connected_account_id	For Stripe Connect activity related to a connected account, the unique ID for the account.
STRING	connected_account_country	For Stripe Connect activity related to a connected account, the two-letter ISO code representing the country of the account.
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.