Connect report type
Retrieve financial reports for your connected accounts using the API.
Connect platforms can use most financial reports to view the activity in their platform account, or in one or more of their connected accounts. In the Dashboard, the report setting controls which account’s data the report displays. By default, the API returns report data for your platform account activity. To view data for your connected accounts, use the Connect-specific report types listed below.
The following tables define the required and optional parameters to run the report, as well as the schema of the CSV output.
| Report type | Required run parameters | Optional run parameters |
|---|---|---|
connected_account_balance_change_from_activity.itemized.1 Columns | interval_start interval_end | connected_account currency reporting_category decimal_separator columns |
connected_account_balance_change_from_activity.itemized.2 Columns | interval_start interval_end | connected_account connected_accounts currency reporting_category decimal_separator columns |
connected_account_balance_change_from_activity.itemized.3 Columns | interval_start interval_end | connected_account connected_accounts timezone currency reporting_category decimal_separator columns |
connected_account_balance_change_from_activity.summary.1 Columns | interval_start interval_end | currency connected_account connected_accounts timezone columns |
connected_account_payouts.itemized.1 Columns | interval_start interval_end | connected_account currency reporting_category decimal_separator columns |
connected_account_payouts.itemized.2 Columns | interval_start interval_end | connected_account connected_accounts currency reporting_category decimal_separator columns |
connected_account_payouts.itemized.3 Columns | interval_start interval_end | connected_account connected_accounts timezone currency reporting_category decimal_separator columns |
connected_account_payouts.summary.1 Columns | interval_start interval_end | currency connected_account connected_accounts timezone columns |
connected_account_balance.summary.1 Columns | interval_start interval_end | timezone currency connected_account connected_accounts columns |
connected_account_balance_change_from_activity.itemized.6 Columns | interval_start interval_end | connected_account connected_accounts currency reporting_category decimal_separator columns |
connected_account_balance_change_from_activity.itemized.7 Columns | interval_start interval_end | connected_account connected_accounts timezone currency reporting_category decimal_separator columns |
connected_account_balance_change_from_activity.summary.2 Columns | interval_start interval_end | currency connected_account connected_accounts timezone columns |
connected_account_balance.summary.2 Columns | interval_start interval_end | timezone currency connected_account connected_accounts columns |
connected_account_payouts.itemized.4 Columns | interval_start interval_end | connected_account connected_accounts currency reporting_category decimal_separator columns |
connected_account_payouts.itemized.5 Columns | interval_start interval_end | connected_account connected_accounts timezone currency reporting_category decimal_separator columns |
connected_account_payouts.summary.2 Columns | interval_start interval_end | currency connected_account connected_accounts timezone columns |
connected_account_ending_balance_reconciliation.itemized.1 Columns | interval_end | connected_account currency reporting_category decimal_separator columns |
connected_account_ending_balance_reconciliation.itemized.2 Columns | interval_end | connected_account connected_accounts currency reporting_category decimal_separator columns |
connected_account_ending_balance_reconciliation.itemized.3 Columns | interval_end | connected_account currency reporting_category timezone decimal_separator columns |
connected_account_ending_balance_reconciliation.summary.1 Columns | interval_end | connected_account connected_accounts currency timezone columns |
connected_account_payout_reconciliation.by_id.itemized.1 Columns | connected_account payout | reporting_category decimal_separator columns |
connected_account_payout_reconciliation.by_id.itemized.2 Columns | connected_account payout | reporting_category decimal_separator columns |
connected_account_payout_reconciliation.by_id.itemized.3 Columns | connected_account payout | reporting_category decimal_separator columns |
connected_account_payout_reconciliation.by_id.itemized.4 Columns | connected_account payout | timezone reporting_category decimal_separator columns |
connected_account_payout_reconciliation.by_id.summary.1 Columns | connected_account payout | columns |
connected_account_payout_reconciliation.itemized.1 Columns | interval_start interval_end | connected_account currency reporting_category decimal_separator columns |
connected_account_payout_reconciliation.itemized.2 Columns | interval_start interval_end | connected_account currency reporting_category decimal_separator columns |
connected_account_payout_reconciliation.itemized.3 Columns | interval_start interval_end | connected_account connected_accounts currency reporting_category decimal_separator columns |
connected_account_payout_reconciliation.itemized.4 Columns | interval_start interval_end | connected_account timezone currency reporting_category decimal_separator columns |
connected_account_payout_reconciliation.summary.1 Columns | interval_start interval_end | currency connected_account connected_accounts timezone columns |
connected_account_ending_balance_reconciliation.itemized.4 Columns | interval_end | connected_account connected_accounts currency reporting_category timezone decimal_separator columns |
connected_account_failed_payouts.itemized.1 Columns | interval_start interval_end | connected_account connected_accounts currency reporting_category decimal_separator columns |
connected_account_failed_payouts.itemized.2 Columns | interval_start interval_end | connected_account connected_accounts timezone currency reporting_category decimal_separator columns |
connected_account_failed_payouts.summary.1 Columns | interval_start interval_end | currency connected_account connected_accounts timezone columns |
connected_account_payout_reconciliation.itemized.5 Columns | interval_start interval_end | connected_account connected_accounts timezone currency reporting_category decimal_separator columns |
connected_account_payout_reconciliation.itemized.6 Columns | interval_start interval_end | connected_account connected_accounts currency reporting_category decimal_separator columns |
connected_account_payout_reconciliation.itemized.7 Columns | interval_start interval_end | connected_account connected_accounts timezone currency reporting_category decimal_separator columns |
connected_account_payout_reconciliation.summary.2 Columns | interval_start interval_end | currency connected_account connected_accounts timezone columns |
connected_account_stripe_fees.balance_transaction_created.itemized.1 Columns | interval_start interval_end | currency fee_category timezone connected_account columns |
connected_account_stripe_fees.balance_transaction_created.summary.1 Columns | interval_start interval_end | currency connected_account columns |
connected_account_stripe_fees.incurred_at.itemized.1 Columns | interval_start interval_end | currency fee_category timezone connected_account columns |
connected_account_stripe_fees.incurred_at.summary.1 Columns | interval_start interval_end | currency connected_account columns |
connect.negative_balance_refunds_disputes_overview.1 Columns | interval_end | |
connected_account_tax.transactions.itemized.2 Columns | interval_start interval_end | connected_account timezone decimal_separator columns |
connect_card_payments_fees.plan_level.1 Columns | interval_start interval_end | columns |
connect_card_payments_fees.transaction_level.1 Columns | interval_start interval_end | columns |
Connected account itemized balance change from activity
API report type: connected_account_balance_change_from_activity.itemized.1
| Column name | Default | Description |
|---|---|---|
| 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. | |
| 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). | |
| available_on_utc | The date the balance transaction’s net funds will become available in the Stripe balance. Dates in UTC. | |
| balance_transaction_id | Unique identifier for the balance transaction. | |
| card_brand | Card brand, if applicable. | |
| card_country | Two-letter ISO code representing the country of the card. | |
| card_funding | Card funding type, if applicable. | |
| charge_created_utc | 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 UTC. | |
| charge_id | Unique identifier for the original charge associated with this balance transaction. Available for charges, refunds and disputes. | |
| connected_account | Unique identifier for the Stripe account associated with this line. | |
| created_utc | Time at which the balance transaction was created. Dates in UTC. | |
| currency | Three-letter ISO code for the currency in which gross, fee and net are defined. | |
| customer_description | Description provided when creating the customer, often used to store the customer name. | |
| customer_email | Email address of the customer, if any, associated with this balance transaction. | |
| 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. | |
| customer_facing_currency | For transactions associated with charges, refunds, or disputes, the three-letter ISO currency code for customer_facing_amount. | |
| customer_id | The unique ID of the related customer, if any. | |
| customer_name | Name of the customer, if any, associated with this balance transaction. | |
| description | An arbitrary string attached to the balance transaction. Often useful for displaying to users. | |
| fee | Fees paid for this transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| gross | Gross amount of the transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| 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. | |
| is_link | Whether or not the payment was made using Link. | |
| net | Net amount of the transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| payment_intent_id | The unique ID of the related Payment Intent, if any. | |
| payment_method_type | The type of payment method used in the related payment. | |
| reporting_category | Reporting Category is a new categorization of balance transactions, meant to improve on the current type field. | |
| shipping_address_city | City of the shipping address associated with this charge, if any | |
| shipping_address_country | Country of the shipping address associated with this charge, if any | |
| shipping_address_line1 | First line of the shipping address associated with this charge, if any | |
| shipping_address_line2 | Second line of the shipping address associated with this charge, if any | |
| shipping_address_postal_code | Postal code of the shipping address associated with this charge, if any | |
| shipping_address_state | State of the shipping address associated with this charge, if any | |
| source_id | The Stripe object to which this transaction is related. | |
| statement_descriptor | The dynamic statement descriptor or suffix specified when the related charge was created. | |
| 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. | |
| trace_id | Trace ID is a unique identifier generated by bank for the Stripe payouts. Used by banks to locate specific transfers, sometimes referred to as a Reference number. | |
| trace_id_status | The status of the trace ID. Either pending, unsupported or supported. |
Connected account itemized balance change from activity
API report type: connected_account_balance_change_from_activity.itemized.2
| Column name | Default | Description |
|---|---|---|
| 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. | |
| 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). | |
| available_on_utc | The date the balance transaction’s net funds will become available in the Stripe balance. Dates in UTC. | |
| balance_transaction_id | Unique identifier for the balance transaction. | |
| card_address_city | City of the card address associated with this charge, if any | |
| card_address_country | Country of the card address associated with this charge, if any | |
| card_address_line1 | First line of the card address associated with this charge, if any | |
| card_address_line2 | Second line of the card address associated with this charge, if any | |
| card_address_postal_code | Postal code of the card address associated with this charge, if any | |
| card_address_state | State of the card address associated with this charge, if any | |
| card_brand | Card brand, if applicable. | |
| card_country | Two-letter ISO code representing the country of the card. | |
| card_funding | Card funding type, if applicable. | |
| charge_created_utc | 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 UTC. | |
| charge_id | Unique identifier for the original charge associated with this balance transaction. Available for charges, refunds and disputes. | |
| connected_account | Unique identifier for the Stripe account associated with this line. | |
| created_utc | Time at which the balance transaction was created. Dates in UTC. | |
| currency | Three-letter ISO code for the currency in which gross, fee and net are defined. | |
| customer_address_city | City of the customer address associated with this charge, if any | |
| customer_address_country | Country of the customer address associated with this charge, if any | |
| customer_address_line1 | First line of the customer address associated with this charge, if any | |
| customer_address_line2 | Second line of the customer address associated with this charge, if any | |
| customer_address_postal_code | Postal code of the customer address associated with this charge, if any | |
| customer_address_state | State of the customer address associated with this charge, if any | |
| customer_description | Description provided when creating the customer, often used to store the customer name. | |
| customer_email | Email address of the customer, if any, associated with this balance transaction. | |
| 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. | |
| customer_facing_currency | For transactions associated with charges, refunds, or disputes, the three-letter ISO currency code for customer_facing_amount. | |
| customer_id | The unique ID of the related customer, if any. | |
| customer_name | Name of the customer, if any, associated with this balance transaction. | |
| customer_shipping_address_city | City of the customer shipping address associated with this charge, if any | |
| customer_shipping_address_country | Country of the customer shipping address associated with this charge, if any | |
| customer_shipping_address_line1 | First line of the customer shipping address associated with this charge, if any | |
| customer_shipping_address_line2 | Second line of the customer shipping address associated with this charge, if any | |
| customer_shipping_address_postal_code | Postal code of the customer shipping address associated with this charge, if any | |
| customer_shipping_address_state | State of the customer shipping address associated with this charge, if any | |
| description | An arbitrary string attached to the balance transaction. Often useful for displaying to users. | |
| dispute_reason | Reason given by cardholder for dispute. Read more about dispute reasons. | |
| fee | Fees paid for this transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| gross | Gross amount of the transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| 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. | |
| 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. | |
| is_link | Whether or not the payment was made using Link. | |
| net | Net amount of the transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| payment_intent_id | The unique ID of the related Payment Intent, if any. | |
| payment_metadata[key] | Metadata associated with the related PaymentIntent, if any. If no PaymentIntent metadata exists, metadata from any related charge object will be returned. API requests including this column must specify a metadata key in brackets. This column can be specified multiple times to retrieve data from additional metadata keys. | |
| payment_method_type | The type of payment method used in the related payment. | |
| refund_metadata[key] | Metadata associated with the related refund object, if any. API requests including this column must specify a metadata key in brackets. This column can be specified multiple times to retrieve data from additional metadata keys. | |
| regulatory_tag | An identifier reflecting the classification of this transaction according to local regulations, if applicable. Accounts with automatic payouts enabled receive a separate payout for each regulatory tag. This column is only populated for Brazilian accounts. | |
| reporting_category | Reporting Category is a new categorization of balance transactions, meant to improve on the current type field. | |
| shipping_address_city | City of the shipping address associated with this charge, if any | |
| shipping_address_country | Country of the shipping address associated with this charge, if any | |
| shipping_address_line1 | First line of the shipping address associated with this charge, if any | |
| shipping_address_line2 | Second line of the shipping address associated with this charge, if any | |
| shipping_address_postal_code | Postal code of the shipping address associated with this charge, if any | |
| shipping_address_state | State of the shipping address associated with this charge, if any | |
| source_id | The Stripe object to which this transaction is related. | |
| statement_descriptor | The dynamic statement descriptor or suffix specified when the related charge was created. | |
| 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. | |
| trace_id | Trace ID is a unique identifier generated by bank for the Stripe payouts. Used by banks to locate specific transfers, sometimes referred to as a Reference number. | |
| trace_id_status | The status of the trace ID. Either pending, unsupported or supported. | |
| transfer_metadata[key] | Metadata associated with the related transfer object, if any. API requests including this column must specify a metadata key in brackets. This column can be specified multiple times to retrieve data from additional metadata keys. |
Connected account itemized balance change from activity
API report type: connected_account_balance_change_from_activity.itemized.3
| Column name | Default | Description |
|---|---|---|
| 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. | |
| automatic_payout_effective_at_utc | 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. | |
| 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). | |
| 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. | |
| available_on_utc | The date the balance transaction’s net funds will become available in the Stripe balance. Dates in UTC. | |
| balance_transaction_id | Unique identifier for the balance transaction. | |
| card_address_city | City of the card address associated with this charge, if any | |
| card_address_country | Country of the card address associated with this charge, if any | |
| card_address_line1 | First line of the card address associated with this charge, if any | |
| card_address_line2 | Second line of the card address associated with this charge, if any | |
| card_address_postal_code | Postal code of the card address associated with this charge, if any | |
| card_address_state | State of the card address associated with this charge, if any | |
| card_brand | Card brand, if applicable. | |
| card_country | Two-letter ISO code representing the country of the card. | |
| card_funding | Card funding type, if applicable. | |
| 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. | |
| charge_created_utc | 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 UTC. | |
| charge_id | Unique identifier for the original charge associated with this balance transaction. Available for charges, refunds and disputes. | |
| connected_account | Unique identifier for the Stripe account associated with this line. | |
| created | Time at which the balance transaction was created. Dates in the requested timezone, or UTC if not provided. | |
| created_utc | Time at which the balance transaction was created. Dates in UTC. | |
| currency | Three-letter ISO code for the currency in which gross, fee and net are defined. | |
| customer_address_city | City of the customer address associated with this charge, if any | |
| customer_address_country | Country of the customer address associated with this charge, if any | |
| customer_address_line1 | First line of the customer address associated with this charge, if any | |
| customer_address_line2 | Second line of the customer address associated with this charge, if any | |
| customer_address_postal_code | Postal code of the customer address associated with this charge, if any | |
| customer_address_state | State of the customer address associated with this charge, if any | |
| customer_description | Description provided when creating the customer, often used to store the customer name. | |
| customer_email | Email address of the customer, if any, associated with this balance transaction. | |
| 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. | |
| customer_facing_currency | For transactions associated with charges, refunds, or disputes, the three-letter ISO currency code for customer_facing_amount. | |
| customer_id | The unique ID of the related customer, if any. | |
| customer_name | Name of the customer, if any, associated with this balance transaction. | |
| customer_shipping_address_city | City of the customer shipping address associated with this charge, if any | |
| customer_shipping_address_country | Country of the customer shipping address associated with this charge, if any | |
| customer_shipping_address_line1 | First line of the customer shipping address associated with this charge, if any | |
| customer_shipping_address_line2 | Second line of the customer shipping address associated with this charge, if any | |
| customer_shipping_address_postal_code | Postal code of the customer shipping address associated with this charge, if any | |
| customer_shipping_address_state | State of the customer shipping address associated with this charge, if any | |
| description | An arbitrary string attached to the balance transaction. Often useful for displaying to users. | |
| dispute_reason | Reason given by cardholder for dispute. Read more about dispute reasons. | |
| fee | Fees paid for this transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| gross | Gross amount of the transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| 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. | |
| invoice_number | Number for the invoice associated with this balance transaction. Available for charges, refunds, and disputes made in connection with a Stripe Billing invoice. | |
| is_link | Whether or not the payment was made using Link. | |
| net | Net amount of the transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| payment_intent_id | The unique ID of the related Payment Intent, if any. | |
| payment_metadata[key] | Metadata associated with the related PaymentIntent, if any. If no PaymentIntent metadata exists, metadata from any related charge object will be returned. API requests including this column must specify a metadata key in brackets. This column can be specified multiple times to retrieve data from additional metadata keys. | |
| payment_method_type | The type of payment method used in the related payment. | |
| refund_metadata[key] | Metadata associated with the related refund object, if any. API requests including this column must specify a metadata key in brackets. This column can be specified multiple times to retrieve data from additional metadata keys. | |
| regulatory_tag | An identifier reflecting the classification of this transaction according to local regulations, if applicable. Accounts with automatic payouts enabled receive a separate payout for each regulatory tag. This column is only populated for Brazilian accounts. | |
| reporting_category | Reporting Category is a new categorization of balance transactions, meant to improve on the current type field. | |
| shipping_address_city | City of the shipping address associated with this charge, if any | |
| shipping_address_country | Country of the shipping address associated with this charge, if any | |
| shipping_address_line1 | First line of the shipping address associated with this charge, if any | |
| shipping_address_line2 | Second line of the shipping address associated with this charge, if any | |
| shipping_address_postal_code | Postal code of the shipping address associated with this charge, if any | |
| shipping_address_state | State of the shipping address associated with this charge, if any | |
| source_id | The Stripe object to which this transaction is related. | |
| statement_descriptor | The dynamic statement descriptor or suffix specified when the related charge was created. | |
| 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. | |
| trace_id | Trace ID is a unique identifier generated by bank for the Stripe payouts. Used by banks to locate specific transfers, sometimes referred to as a Reference number. | |
| trace_id_status | The status of the trace ID. Either pending, unsupported or supported. | |
| transfer_metadata[key] | Metadata associated with the related transfer object, if any. API requests including this column must specify a metadata key in brackets. This column can be specified multiple times to retrieve data from additional metadata keys. |
Connected account balance change from activity summary
API report type: connected_account_balance_change_from_activity.summary.1
| Column name | Default | Description |
|---|---|---|
| count | The number of transactions associated with the reporting_category. | |
| currency | Three-letter ISO code for the currency in which gross, fee and net are defined. | |
| fee | Sum of the fees paid for the transactions associated with the reporting_category. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| gross | Sum of the gross amounts of the transactions associated with the reporting_category. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| net | Sum of the net amounts for the transactions associated with the reporting_category. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| reporting_category | Reporting Category is a new categorization of balance transactions, meant to improve on the current type field. |
Connected account itemized payouts
API report type: connected_account_payouts.itemized.1
| Column name | Default | Description |
|---|---|---|
| balance_transaction_id | Unique identifier for the balance transaction. | |
| connected_account | Unique identifier for the Stripe account associated with this line. | |
| currency | Three-letter ISO code for the currency in which gross, fee and net are defined. | |
| description | An arbitrary string attached to the balance transaction. Often useful for displaying to users. | |
| effective_at_utc | For automatic payouts, this is the date we expect funds to arrive in your bank account. For manual payouts, this is the date the payout was initiated. In both cases, it’s the date the paid-out funds are deducted from your Stripe balance. All dates in UTC. | |
| fee | Fees paid for this transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| gross | Gross amount of the transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| net | Net amount of the transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| payout_description | An arbitrary string attached to the payout. Often useful for displaying to users. | |
| payout_destination_id | ID of the bank account or card the payout was sent to. | |
| payout_expected_arrival_date | Date the payout is scheduled to arrive in the bank. This factors in delays like weekends or bank holidays. Dates in UTC. | |
| payout_id | The Stripe object to which this transaction is related. | |
| payout_reversed_at | Typically this field will be empty. However, if the payout’s status is canceled or failed, this field will reflect the time at which it entered that status. | |
| payout_status | Current status of the payout ( paid, pending, in_transit, canceled or failed). A payout will be pending until it is submitted to the bank, at which point it becomes in_transit. It will then change to paid if the transaction goes through. If it does not go through successfully, its status will change to failed or canceled. | |
| payout_type | Can be bank_account or card. | |
| reporting_category | Reporting Category is a new categorization of balance transactions, meant to improve on the current type field. | |
| trace_id | Trace ID is a unique identifier generated by bank for the Stripe payouts. Used by banks to locate specific transfers, sometimes referred to as a Reference number. | |
| trace_id_status | The status of the trace ID. Either pending, unsupported or supported. |
Connected account itemized payouts
API report type: connected_account_payouts.itemized.2
| Column name | Default | Description |
|---|---|---|
| balance_transaction_id | Unique identifier for the balance transaction. | |
| connected_account | Unique identifier for the Stripe account associated with this line. | |
| currency | Three-letter ISO code for the currency in which gross, fee and net are defined. | |
| description | An arbitrary string attached to the balance transaction. Often useful for displaying to users. | |
| effective_at_utc | For automatic payouts, this is the date we expect funds to arrive in your bank account. For manual payouts, this is the date the payout was initiated. In both cases, it’s the date the paid-out funds are deducted from your Stripe balance. All dates in UTC. | |
| fee | Fees paid for this transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| gross | Gross amount of the transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| net | Net amount of the transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| payout_description | An arbitrary string attached to the payout. Often useful for displaying to users. | |
| payout_destination_id | ID of the bank account or card the payout was sent to. | |
| payout_expected_arrival_date | Date the payout is scheduled to arrive in the bank. This factors in delays like weekends or bank holidays. Dates in UTC. | |
| payout_id | The Stripe object to which this transaction is related. | |
| payout_reversed_at | Typically this field will be empty. However, if the payout’s status is canceled or failed, this field will reflect the time at which it entered that status. | |
| payout_status | Current status of the payout ( paid, pending, in_transit, canceled or failed). A payout will be pending until it is submitted to the bank, at which point it becomes in_transit. It will then change to paid if the transaction goes through. If it does not go through successfully, its status will change to failed or canceled. | |
| payout_type | Can be bank_account or card. | |
| regulatory_tag | An identifier reflecting the classification of this transaction according to local regulations, if applicable. Accounts with automatic payouts enabled receive a separate payout for each regulatory tag. This column is only populated for Brazilian accounts. | |
| reporting_category | Reporting Category is a new categorization of balance transactions, meant to improve on the current type field. | |
| trace_id | Trace ID is a unique identifier generated by bank for the Stripe payouts. Used by banks to locate specific transfers, sometimes referred to as a Reference number. | |
| trace_id_status | The status of the trace ID. Either pending, unsupported or supported. |
Connected account itemized payouts
API report type: connected_account_payouts.itemized.3
| Column name | Default | Description |
|---|---|---|
| balance_transaction_id | Unique identifier for the balance transaction. | |
| connected_account | Unique identifier for the Stripe account associated with this line. | |
| currency | Three-letter ISO code for the currency in which gross, fee and net are defined. | |
| description | An arbitrary string attached to the balance transaction. Often useful for displaying to users. | |
| effective_at | For automatic payouts, this is the date we expect funds to arrive in your bank account. For manual payouts, this is the date the payout was initiated. In both cases, it’s the date the paid-out funds are deducted from your Stripe balance. All dates in the requested timezone, or UTC if not provided. | |
| effective_at_utc | For automatic payouts, this is the date we expect funds to arrive in your bank account. For manual payouts, this is the date the payout was initiated. In both cases, it’s the date the paid-out funds are deducted from your Stripe balance. All dates in UTC. | |
| fee | Fees paid for this transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| gross | Gross amount of the transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| net | Net amount of the transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| payout_description | An arbitrary string attached to the payout. Often useful for displaying to users. | |
| payout_destination_id | ID of the bank account or card the payout was sent to. | |
| payout_expected_arrival_date | Date the payout is scheduled to arrive in the bank. This factors in delays like weekends or bank holidays. | |
| payout_id | The Stripe object to which this transaction is related. | |
| payout_reversed_at | Typically this field will be empty. However, if the payout’s status is canceled or failed, this field will reflect the time at which it entered that status. Times in the requested timezone, or UTC if not provided. | |
| payout_reversed_at_utc | Typically this field will be empty. However, if the payout’s status is canceled or failed, this field will reflect the time at which it entered that status. Times in UTC. | |
| payout_status | Current status of the payout ( paid, pending, in_transit, canceled or failed). A payout will be pending until it is submitted to the bank, at which point it becomes in_transit. It will then change to paid if the transaction goes through. If it does not go through successfully, its status will change to failed or canceled. | |
| payout_type | Can be bank_account or card. | |
| regulatory_tag | An identifier reflecting the classification of this transaction according to local regulations, if applicable. Accounts with automatic payouts enabled receive a separate payout for each regulatory tag. This column is only populated for Brazilian accounts. | |
| reporting_category | Reporting Category is a new categorization of balance transactions, meant to improve on the current type field. | |
| trace_id | Trace ID is a unique identifier generated by bank for the Stripe payouts. Used by banks to locate specific transfers, sometimes referred to as a Reference number. | |
| trace_id_status | The status of the trace ID. Either pending, unsupported or supported. |
Connected account payouts summary
API report type: connected_account_payouts.summary.1
| Column name | Default | Description |
|---|---|---|
| count | The number of transactions associated with the reporting_category. | |
| currency | Three-letter ISO code for the currency in which gross, fee and net are defined. | |
| fee | Sum of the fees paid for the transactions associated with the reporting_category. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| gross | Sum of the gross amounts of the transactions associated with the reporting_category. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| net | Sum of the net amounts for the transactions associated with the reporting_category. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| reporting_category | Reporting Category is a new categorization of balance transactions, meant to improve on the current type field. |
Connected account balance summary
API report type: connected_account_balance.summary.1
| Column name | Default | Description |
|---|---|---|
| category | One of starting_balance, ending_balance, activity or payouts. | |
| currency | Three-letter ISO code for the currency in which net_amount is defined. | |
| description | One of Starting balance (the related setting-MM-DD) - the balance at the start of the period, Activity - the net amount of all transactions that affected your balance except for payouts, Total payouts - the amount of payouts to your bank account, or Ending balance (the related setting-MM-DD) - the balance left over at the end of the period after subtracting payouts from the Starting balance and Activity. | |
| net_amount | Net amount for the transactions associated with category. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). |
Connected account Itemized balance change from activity
API report type: connected_account_balance_change_from_activity.itemized.6
| Column name | Default | Description |
|---|---|---|
| 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. | |
| 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). | |
| available_on_utc | The date the balance transaction’s net funds will become available in the Stripe balance. Dates in UTC. | |
| balance_transaction_id | Unique identifier for the balance transaction. | |
| balance_type | The type of balance this transaction belongs to (for example, payments, issuing, corporate_card). | |
| card_address_city | City of the card address associated with this charge, if any | |
| card_address_country | Country of the card address associated with this charge, if any | |
| card_address_line1 | First line of the card address associated with this charge, if any | |
| card_address_line2 | Second line of the card address associated with this charge, if any | |
| card_address_postal_code | Postal code of the card address associated with this charge, if any | |
| card_address_state | State of the card address associated with this charge, if any | |
| card_brand | Card brand, if applicable. | |
| card_country | Two-letter ISO code representing the country of the card. | |
| card_funding | Card funding type, if applicable. | |
| charge_created_utc | 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 UTC. | |
| charge_id | Unique identifier for the original charge associated with this balance transaction. Available for charges, refunds and disputes. | |
| connected_account | Unique identifier for the Stripe account associated with this line. | |
| created_utc | Time at which the balance transaction was created. Dates in UTC. | |
| currency | Three-letter ISO code for the currency in which gross, fee and net are defined. | |
| customer_address_city | City of the customer address associated with this charge, if any | |
| customer_address_country | Country of the customer address associated with this charge, if any | |
| customer_address_line1 | First line of the customer address associated with this charge, if any | |
| customer_address_line2 | Second line of the customer address associated with this charge, if any | |
| customer_address_postal_code | Postal code of the customer address associated with this charge, if any | |
| customer_address_state | State of the customer address associated with this charge, if any | |
| customer_description | Description provided when creating the customer, often used to store the customer name. | |
| customer_email | Email address of the customer, if any, associated with this balance transaction. | |
| 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. | |
| customer_facing_currency | For transactions associated with charges, refunds, or disputes, the three-letter ISO currency code for customer_facing_amount. | |
| customer_id | The unique ID of the related customer, if any. | |
| customer_name | Name of the customer, if any, associated with this balance transaction. | |
| customer_shipping_address_city | City of the customer shipping address associated with this charge, if any | |
| customer_shipping_address_country | Country of the customer shipping address associated with this charge, if any | |
| customer_shipping_address_line1 | First line of the customer shipping address associated with this charge, if any | |
| customer_shipping_address_line2 | Second line of the customer shipping address associated with this charge, if any | |
| customer_shipping_address_postal_code | Postal code of the customer shipping address associated with this charge, if any | |
| customer_shipping_address_state | State of the customer shipping address associated with this charge, if any | |
| description | An arbitrary string attached to the balance transaction. Often useful for displaying to users. | |
| dispute_reason | Reason given by cardholder for dispute. Read more about dispute reasons. | |
| fee | Fees paid for this transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| gross | Gross amount of the transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| 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. | |
| 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. | |
| is_link | Whether or not the payment was made using Link. | |
| net | Net amount of the transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| payment_intent_id | The unique ID of the related Payment Intent, if any. | |
| payment_metadata[key] | Metadata associated with the related PaymentIntent, if any. If no PaymentIntent metadata exists, metadata from any related charge object will be returned. API requests including this column must specify a metadata key in brackets. This column can be specified multiple times to retrieve data from additional metadata keys. | |
| payment_method_type | The type of payment method used in the related payment. | |
| refund_metadata[key] | Metadata associated with the related refund object, if any. API requests including this column must specify a metadata key in brackets. This column can be specified multiple times to retrieve data from additional metadata keys. | |
| regulatory_tag | An identifier reflecting the classification of this transaction according to local regulations, if applicable. Accounts with automatic payouts enabled receive a separate payout for each regulatory tag. This column is only populated for Brazilian accounts. | |
| reporting_category | Reporting Category is a new categorization of balance transactions, meant to improve on the current type field. | |
| shipping_address_city | City of the shipping address associated with this charge, if any | |
| shipping_address_country | Country of the shipping address associated with this charge, if any | |
| shipping_address_line1 | First line of the shipping address associated with this charge, if any | |
| shipping_address_line2 | Second line of the shipping address associated with this charge, if any | |
| shipping_address_postal_code | Postal code of the shipping address associated with this charge, if any | |
| shipping_address_state | State of the shipping address associated with this charge, if any | |
| source_id | The Stripe object to which this transaction is related. | |
| statement_descriptor | The dynamic statement descriptor or suffix specified when the related charge was created. | |
| 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. | |
| trace_id | Trace ID is a unique identifier generated by bank for the Stripe payouts. Used by banks to locate specific transfers, sometimes referred to as a Reference number. | |
| trace_id_status | The status of the trace ID. Either pending, unsupported or supported. | |
| transfer_metadata[key] | Metadata associated with the related transfer object, if any. API requests including this column must specify a metadata key in brackets. This column can be specified multiple times to retrieve data from additional metadata keys. |
Connected account Itemized balance change from activity
API report type: connected_account_balance_change_from_activity.itemized.7
| Column name | Default | Description |
|---|---|---|
| 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. | |
| automatic_payout_effective_at_utc | 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. | |
| 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). | |
| 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. | |
| available_on_utc | The date the balance transaction’s net funds will become available in the Stripe balance. Dates in UTC. | |
| balance_transaction_id | Unique identifier for the balance transaction. | |
| balance_type | The type of balance this transaction belongs to (for example, payments, issuing, corporate_card). | |
| card_address_city | City of the card address associated with this charge, if any | |
| card_address_country | Country of the card address associated with this charge, if any | |
| card_address_line1 | First line of the card address associated with this charge, if any | |
| card_address_line2 | Second line of the card address associated with this charge, if any | |
| card_address_postal_code | Postal code of the card address associated with this charge, if any | |
| card_address_state | State of the card address associated with this charge, if any | |
| card_brand | Card brand, if applicable. | |
| card_country | Two-letter ISO code representing the country of the card. | |
| card_funding | Card funding type, if applicable. | |
| card_network | Card network, if applicable. | |
| 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. | |
| charge_created_utc | 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 UTC. | |
| charge_id | Unique identifier for the original charge associated with this balance transaction. Available for charges, refunds and disputes. | |
| connected_account | Unique identifier for the Stripe account associated with this line. | |
| created | Time at which the balance transaction was created. Dates in the requested timezone, or UTC if not provided. | |
| created_utc | Time at which the balance transaction was created. Dates in UTC. | |
| currency | Three-letter ISO code for the currency in which gross, fee and net are defined. | |
| customer_address_city | City of the customer address associated with this charge, if any | |
| customer_address_country | Country of the customer address associated with this charge, if any | |
| customer_address_line1 | First line of the customer address associated with this charge, if any | |
| customer_address_line2 | Second line of the customer address associated with this charge, if any | |
| customer_address_postal_code | Postal code of the customer address associated with this charge, if any | |
| customer_address_state | State of the customer address associated with this charge, if any | |
| customer_description | Description provided when creating the customer, often used to store the customer name. | |
| customer_email | Email address of the customer, if any, associated with this balance transaction. | |
| 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. | |
| customer_facing_currency | For transactions associated with charges, refunds, or disputes, the three-letter ISO currency code for customer_facing_amount. | |
| customer_id | The unique ID of the related customer, if any. | |
| customer_name | Name of the customer, if any, associated with this balance transaction. | |
| customer_shipping_address_city | City of the customer shipping address associated with this charge, if any | |
| customer_shipping_address_country | Country of the customer shipping address associated with this charge, if any | |
| customer_shipping_address_line1 | First line of the customer shipping address associated with this charge, if any | |
| customer_shipping_address_line2 | Second line of the customer shipping address associated with this charge, if any | |
| customer_shipping_address_postal_code | Postal code of the customer shipping address associated with this charge, if any | |
| customer_shipping_address_state | State of the customer shipping address associated with this charge, if any | |
| description | An arbitrary string attached to the balance transaction. Often useful for displaying to users. | |
| dispute_reason | Reason given by cardholder for dispute. Read more about dispute reasons. | |
| exchange_rate | captures the foreign exchange rate applied to a balance transaction | |
| fee | Fees paid for this transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| gross | Gross amount of the transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| 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. | |
| invoice_number | Number for the invoice associated with this balance transaction. Available for charges, refunds, and disputes made in connection with a Stripe Billing invoice. | |
| is_link | Whether or not the payment was made using Link. | |
| net | Net amount of the transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| payment_intent_id | The unique ID of the related Payment Intent, if any. | |
| payment_metadata[key] | Metadata associated with the related PaymentIntent, if any. If no PaymentIntent metadata exists, metadata from any related charge object will be returned. API requests including this column must specify a metadata key in brackets. This column can be specified multiple times to retrieve data from additional metadata keys. | |
| payment_method_type | The type of payment method used in the related payment. | |
| product_ids | Product IDs associated with the related balance transaction. | |
| product_names | Product names associated with the related balance transaction. | |
| refund_metadata[key] | Metadata associated with the related refund object, if any. API requests including this column must specify a metadata key in brackets. This column can be specified multiple times to retrieve data from additional metadata keys. | |
| regulatory_tag | An identifier reflecting the classification of this transaction according to local regulations, if applicable. Accounts with automatic payouts enabled receive a separate payout for each regulatory tag. This column is only populated for Brazilian accounts. | |
| reporting_category | Reporting Category is a new categorization of balance transactions, meant to improve on the current type field. | |
| shipping_address_city | City of the shipping address associated with this charge, if any | |
| shipping_address_country | Country of the shipping address associated with this charge, if any | |
| shipping_address_line1 | First line of the shipping address associated with this charge, if any | |
| shipping_address_line2 | Second line of the shipping address associated with this charge, if any | |
| shipping_address_postal_code | Postal code of the shipping address associated with this charge, if any | |
| shipping_address_state | State of the shipping address associated with this charge, if any | |
| source_id | The Stripe object to which this transaction is related. | |
| statement_descriptor | The dynamic statement descriptor or suffix specified when the related charge was created. | |
| 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. | |
| trace_id | Trace ID is a unique identifier generated by bank for the Stripe payouts. Used by banks to locate specific transfers, sometimes referred to as a Reference number. | |
| trace_id_status | The status of the trace ID. Either pending, unsupported or supported. | |
| transfer_metadata[key] | Metadata associated with the related transfer object, if any. API requests including this column must specify a metadata key in brackets. This column can be specified multiple times to retrieve data from additional metadata keys. |
Connected account balance change from activity summary
API report type: connected_account_balance_change_from_activity.summary.2
| Column name | Default | Description |
|---|---|---|
| count | The number of transactions associated with the reporting_category. | |
| currency | Three-letter ISO code for the currency in which gross, fee and net are defined. | |
| fee | Sum of the fees paid for the transactions associated with the reporting_category. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| gross | Sum of the gross amounts of the transactions associated with the reporting_category. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| net | Sum of the net amounts for the transactions associated with the reporting_category. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| reporting_category | Reporting Category is a new categorization of balance transactions, meant to improve on the current type field. |
Connected account balance summary
API report type: connected_account_balance.summary.2
| Column name | Default | Description |
|---|---|---|
| category | One of starting_balance, ending_balance, activity or payouts. | |
| currency | Three-letter ISO code for the currency in which net_amount is defined. | |
| description | One of Starting balance (the related setting-MM-DD) - the balance at the start of the period, Activity - the net amount of all transactions that affected your balance except for payouts, Total payouts - the amount of payouts to your bank account, or Ending balance (the related setting-MM-DD) - the balance left over at the end of the period after subtracting payouts from the Starting balance and Activity. | |
| net_amount | Net amount for the transactions associated with category. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). |
Connected account itemized payouts
API report type: connected_account_payouts.itemized.4
| Column name | Default | Description |
|---|---|---|
| balance_transaction_id | Unique identifier for the balance transaction. | |
| connected_account | Unique identifier for the Stripe account associated with this line. | |
| currency | Three-letter ISO code for the currency in which gross, fee and net are defined. | |
| description | An arbitrary string attached to the balance transaction. Often useful for displaying to users. | |
| effective_at_utc | For automatic payouts, this is the date we expect funds to arrive in your bank account. For manual payouts, this is the date the payout was initiated. In both cases, it’s the date the paid-out funds are deducted from your Stripe balance. All dates in UTC. | |
| fee | Fees paid for this transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| gross | Gross amount of the transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| net | Net amount of the transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| payout_description | An arbitrary string attached to the payout. Often useful for displaying to users. | |
| payout_destination_id | ID of the bank account or card the payout was sent to. | |
| payout_expected_arrival_date | Date the payout is scheduled to arrive in the bank. This factors in delays like weekends or bank holidays. Dates in UTC. | |
| payout_id | The Stripe object to which this transaction is related. | |
| payout_reversed_at | Typically this field will be empty. However, if the payout’s status is canceled or failed, this field will reflect the time at which it entered that status. | |
| payout_status | Current status of the payout ( paid, pending, in_transit, canceled or failed). A payout will be pending until it is submitted to the bank, at which point it becomes in_transit. It will then change to paid if the transaction goes through. If it does not go through successfully, its status will change to failed or canceled. | |
| payout_type | Can be bank_account or card. | |
| regulatory_tag | An identifier reflecting the classification of this transaction according to local regulations, if applicable. Accounts with automatic payouts enabled receive a separate payout for each regulatory tag. This column is only populated for Brazilian accounts. | |
| reporting_category | Reporting Category is a new categorization of balance transactions, meant to improve on the current type field. | |
| trace_id | Trace ID is a unique identifier generated by bank for the Stripe payouts. Used by banks to locate specific transfers, sometimes referred to as a Reference number. | |
| trace_id_status | The status of the trace ID. Either pending, unsupported or supported. |
Connected account itemized payouts
API report type: connected_account_payouts.itemized.5
| Column name | Default | Description |
|---|---|---|
| balance_transaction_id | Unique identifier for the balance transaction. | |
| connected_account | Unique identifier for the Stripe account associated with this line. | |
| currency | Three-letter ISO code for the currency in which gross, fee and net are defined. | |
| description | An arbitrary string attached to the balance transaction. Often useful for displaying to users. | |
| effective_at | For automatic payouts, this is the date we expect funds to arrive in your bank account. For manual payouts, this is the date the payout was initiated. In both cases, it’s the date the paid-out funds are deducted from your Stripe balance. All dates in the requested timezone, or UTC if not provided. | |
| effective_at_utc | For automatic payouts, this is the date we expect funds to arrive in your bank account. For manual payouts, this is the date the payout was initiated. In both cases, it’s the date the paid-out funds are deducted from your Stripe balance. All dates in UTC. | |
| fee | Fees paid for this transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| gross | Gross amount of the transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| net | Net amount of the transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| payout_description | An arbitrary string attached to the payout. Often useful for displaying to users. | |
| payout_destination_id | ID of the bank account or card the payout was sent to. | |
| payout_expected_arrival_date | Date the payout is scheduled to arrive in the bank. This factors in delays like weekends or bank holidays. | |
| payout_id | The Stripe object to which this transaction is related. | |
| payout_reversed_at | Typically this field will be empty. However, if the payout’s status is canceled or failed, this field will reflect the time at which it entered that status. Times in the requested timezone, or UTC if not provided. | |
| payout_reversed_at_utc | Typically this field will be empty. However, if the payout’s status is canceled or failed, this field will reflect the time at which it entered that status. Times in UTC. | |
| payout_status | Current status of the payout ( paid, pending, in_transit, canceled or failed). A payout will be pending until it is submitted to the bank, at which point it becomes in_transit. It will then change to paid if the transaction goes through. If it does not go through successfully, its status will change to failed or canceled. | |
| payout_type | Can be bank_account or card. | |
| regulatory_tag | An identifier reflecting the classification of this transaction according to local regulations, if applicable. Accounts with automatic payouts enabled receive a separate payout for each regulatory tag. This column is only populated for Brazilian accounts. | |
| reporting_category | Reporting Category is a new categorization of balance transactions, meant to improve on the current type field. | |
| trace_id | Trace ID is a unique identifier generated by bank for the Stripe payouts. Used by banks to locate specific transfers, sometimes referred to as a Reference number. | |
| trace_id_status | The status of the trace ID. Either pending, unsupported or supported. |
Connected account payouts summary
API report type: connected_account_payouts.summary.2
| Column name | Default | Description |
|---|---|---|
| count | The number of transactions associated with the reporting_category. | |
| currency | Three-letter ISO code for the currency in which gross, fee and net are defined. | |
| fee | Sum of the fees paid for the transactions associated with the reporting_category. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| gross | Sum of the gross amounts of the transactions associated with the reporting_category. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| net | Sum of the net amounts for the transactions associated with the reporting_category. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| reporting_category | Reporting Category is a new categorization of balance transactions, meant to improve on the current type field. |
Connected account itemized ending balance reconciliation
API report type: connected_account_ending_balance_reconciliation.itemized.1
| Column name | Default | Description |
|---|---|---|
| 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. | |
| 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). | |
| available_on_utc | The date the balance transaction’s net funds will become available in the Stripe balance. Dates in UTC. | |
| balance_transaction_id | Unique identifier for the balance transaction. | |
| card_brand | Card brand, if applicable. | |
| card_country | Two-letter ISO code representing the country of the card. | |
| card_funding | Card funding type, if applicable. | |
| charge_created_utc | 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 UTC. | |
| charge_id | Unique identifier for the original charge associated with this balance transaction. Available for charges, refunds and disputes. | |
| connected_account | Unique identifier for the Stripe account associated with this line. | |
| created_utc | Time at which the balance transaction was created. Dates in UTC. | |
| currency | Three-letter ISO code for the currency in which gross, fee and net are defined. | |
| customer_description | Description provided when creating the customer, often used to store the customer name. | |
| customer_email | Email address of the customer, if any, associated with this balance transaction. | |
| 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. | |
| customer_facing_currency | For transactions associated with charges, refunds, or disputes, the three-letter ISO currency code for customer_facing_amount. | |
| customer_id | The unique ID of the related customer, if any. | |
| customer_name | Name of the customer, if any, associated with this balance transaction. | |
| description | An arbitrary string attached to the balance transaction. Often useful for displaying to users. | |
| fee | Fees paid for this transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| gross | Gross amount of the transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| 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. | |
| is_link | Whether or not the payment was made using Link. | |
| net | Net amount of the transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| payment_intent_id | The unique ID of the related Payment Intent, if any. | |
| payment_method_type | The type of payment method used in the related payment. | |
| reporting_category | Reporting Category is a new categorization of balance transactions, meant to improve on the current type field. | |
| shipping_address_city | City of the shipping address associated with this charge, if any | |
| shipping_address_country | Country of the shipping address associated with this charge, if any | |
| shipping_address_line1 | First line of the shipping address associated with this charge, if any | |
| shipping_address_line2 | Second line of the shipping address associated with this charge, if any | |
| shipping_address_postal_code | Postal code of the shipping address associated with this charge, if any | |
| shipping_address_state | State of the shipping address associated with this charge, if any | |
| source_id | The Stripe object to which this transaction is related. | |
| statement_descriptor | The dynamic statement descriptor or suffix specified when the related charge was created. | |
| 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. | |
| trace_id | Trace ID is a unique identifier generated by bank for the Stripe payouts. Used by banks to locate specific transfers, sometimes referred to as a Reference number. | |
| trace_id_status | The status of the trace ID. Either pending, unsupported or supported. |
Connected account itemized ending balance reconciliation
API report type: connected_account_ending_balance_reconciliation.itemized.2
| Column name | Default | Description |
|---|---|---|
| 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. | |
| 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). | |
| available_on_utc | The date the balance transaction’s net funds will become available in the Stripe balance. Dates in UTC. | |
| balance_transaction_id | Unique identifier for the balance transaction. | |
| balance_type | The type of balance this transaction belongs to (for example, payments, issuing, corporate_card). | |
| card_address_city | City of the card address associated with this charge, if any | |
| card_address_country | Country of the card address associated with this charge, if any | |
| card_address_line1 | First line of the card address associated with this charge, if any | |
| card_address_line2 | Second line of the card address associated with this charge, if any | |
| card_address_postal_code | Postal code of the card address associated with this charge, if any | |
| card_address_state | State of the card address associated with this charge, if any | |
| card_brand | Card brand, if applicable. | |
| card_country | Two-letter ISO code representing the country of the card. | |
| card_funding | Card funding type, if applicable. | |
| charge_created_utc | 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 UTC. | |
| charge_id | Unique identifier for the original charge associated with this balance transaction. Available for charges, refunds and disputes. | |
| connected_account | Unique identifier for the Stripe account associated with this line. | |
| created_utc | Time at which the balance transaction was created. Dates in UTC. | |
| currency | Three-letter ISO code for the currency in which gross, fee and net are defined. | |
| customer_address_city | City of the customer address associated with this charge, if any | |
| customer_address_country | Country of the customer address associated with this charge, if any | |
| customer_address_line1 | First line of the customer address associated with this charge, if any | |
| customer_address_line2 | Second line of the customer address associated with this charge, if any | |
| customer_address_postal_code | Postal code of the customer address associated with this charge, if any | |
| customer_address_state | State of the customer address associated with this charge, if any | |
| customer_description | Description provided when creating the customer, often used to store the customer name. | |
| customer_email | Email address of the customer, if any, associated with this balance transaction. | |
| 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. | |
| customer_facing_currency | For transactions associated with charges, refunds, or disputes, the three-letter ISO currency code for customer_facing_amount. | |
| customer_id | The unique ID of the related customer, if any. | |
| customer_name | Name of the customer, if any, associated with this balance transaction. | |
| customer_shipping_address_city | City of the customer shipping address associated with this charge, if any | |
| customer_shipping_address_country | Country of the customer shipping address associated with this charge, if any | |
| customer_shipping_address_line1 | First line of the customer shipping address associated with this charge, if any | |
| customer_shipping_address_line2 | Second line of the customer shipping address associated with this charge, if any | |
| customer_shipping_address_postal_code | Postal code of the customer shipping address associated with this charge, if any | |
| customer_shipping_address_state | State of the customer shipping address associated with this charge, if any | |
| description | An arbitrary string attached to the balance transaction. Often useful for displaying to users. | |
| dispute_reason | Reason given by cardholder for dispute. Read more about dispute reasons. | |
| fee | Fees paid for this transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| gross | Gross amount of the transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| 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. | |
| 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. | |
| is_link | Whether or not the payment was made using Link. | |
| net | Net amount of the transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| payment_intent_id | The unique ID of the related Payment Intent, if any. | |
| payment_metadata[key] | Metadata associated with the related PaymentIntent, if any. If no PaymentIntent metadata exists, metadata from any related charge object will be returned. API requests including this column must specify a metadata key in brackets. This column can be specified multiple times to retrieve data from additional metadata keys. | |
| payment_method_type | The type of payment method used in the related payment. | |
| refund_metadata[key] | Metadata associated with the related refund object, if any. API requests including this column must specify a metadata key in brackets. This column can be specified multiple times to retrieve data from additional metadata keys. | |
| regulatory_tag | An identifier reflecting the classification of this transaction according to local regulations, if applicable. Accounts with automatic payouts enabled receive a separate payout for each regulatory tag. This column is only populated for Brazilian accounts. | |
| reporting_category | Reporting Category is a new categorization of balance transactions, meant to improve on the current type field. | |
| shipping_address_city | City of the shipping address associated with this charge, if any | |
| shipping_address_country | Country of the shipping address associated with this charge, if any | |
| shipping_address_line1 | First line of the shipping address associated with this charge, if any | |
| shipping_address_line2 | Second line of the shipping address associated with this charge, if any | |
| shipping_address_postal_code | Postal code of the shipping address associated with this charge, if any | |
| shipping_address_state | State of the shipping address associated with this charge, if any | |
| source_id | The Stripe object to which this transaction is related. | |
| statement_descriptor | The dynamic statement descriptor or suffix specified when the related charge was created. | |
| 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. | |
| trace_id | Trace ID is a unique identifier generated by bank for the Stripe payouts. Used by banks to locate specific transfers, sometimes referred to as a Reference number. | |
| trace_id_status | The status of the trace ID. Either pending, unsupported or supported. | |
| transfer_metadata[key] | Metadata associated with the related transfer object, if any. API requests including this column must specify a metadata key in brackets. This column can be specified multiple times to retrieve data from additional metadata keys. |
Connected account itemized ending balance reconciliation
API report type: connected_account_ending_balance_reconciliation.itemized.3
| Column name | Default | Description |
|---|---|---|
| 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. | |
| automatic_payout_effective_at_utc | 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. | |
| 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). | |
| 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. | |
| available_on_utc | The date the balance transaction’s net funds will become available in the Stripe balance. Dates in UTC. | |
| balance_transaction_id | Unique identifier for the balance transaction. | |
| card_brand | Card brand, if applicable. | |
| card_country | Two-letter ISO code representing the country of the card. | |
| card_funding | Card funding type, if applicable. | |
| 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. | |
| charge_created_utc | 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 UTC. | |
| charge_id | Unique identifier for the original charge associated with this balance transaction. Available for charges, refunds and disputes. | |
| connected_account | Unique identifier for the Stripe account associated with this line. | |
| created | Time at which the balance transaction was created. Dates in the requested timezone, or UTC if not provided. | |
| created_utc | Time at which the balance transaction was created. Dates in UTC. | |
| currency | Three-letter ISO code for the currency in which gross, fee and net are defined. | |
| customer_description | Description provided when creating the customer, often used to store the customer name. | |
| customer_email | Email address of the customer, if any, associated with this balance transaction. | |
| 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. | |
| customer_facing_currency | For transactions associated with charges, refunds, or disputes, the three-letter ISO currency code for customer_facing_amount. | |
| customer_id | The unique ID of the related customer, if any. | |
| customer_name | Name of the customer, if any, associated with this balance transaction. | |
| description | An arbitrary string attached to the balance transaction. Often useful for displaying to users. | |
| fee | Fees paid for this transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| gross | Gross amount of the transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| 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. | |
| is_link | Whether or not the payment was made using Link. | |
| net | Net amount of the transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| payment_intent_id | The unique ID of the related Payment Intent, if any. | |
| payment_method_type | The type of payment method used in the related payment. | |
| reporting_category | Reporting Category is a new categorization of balance transactions, meant to improve on the current type field. | |
| shipping_address_city | City of the shipping address associated with this charge, if any | |
| shipping_address_country | Country of the shipping address associated with this charge, if any | |
| shipping_address_line1 | First line of the shipping address associated with this charge, if any | |
| shipping_address_line2 | Second line of the shipping address associated with this charge, if any | |
| shipping_address_postal_code | Postal code of the shipping address associated with this charge, if any | |
| shipping_address_state | State of the shipping address associated with this charge, if any | |
| source_id | The Stripe object to which this transaction is related. | |
| statement_descriptor | The dynamic statement descriptor or suffix specified when the related charge was created. | |
| 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. | |
| trace_id | Trace ID is a unique identifier generated by bank for the Stripe payouts. Used by banks to locate specific transfers, sometimes referred to as a Reference number. | |
| trace_id_status | The status of the trace ID. Either pending, unsupported or supported. |
Connected account ending balance reconciliation summary
API report type: connected_account_ending_balance_reconciliation.summary.1
| Column name | Default | Description |
|---|---|---|
| count | The number of transactions associated with the reporting_category. | |
| currency | Three-letter ISO code for the currency in which gross, fee and net are defined. | |
| fee | Sum of the fees paid for the transactions associated with the reporting_category. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| gross | Sum of the gross amounts of the transactions associated with the reporting_category. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| net | Sum of the net amounts for the transactions associated with the reporting_category. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| reporting_category | Reporting Category is a new categorization of balance transactions, meant to improve on the current type field. |
Connected account itemized single payout reconciliation
API report type: connected_account_payout_reconciliation.by_id.itemized.1
| Column name | Default | Description |
|---|---|---|
| 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. | |
| 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). | |
| available_on_utc | The date the balance transaction’s net funds will become available in the Stripe balance. Dates in UTC. | |
| balance_transaction_id | Unique identifier for the balance transaction. | |
| card_brand | Card brand, if applicable. | |
| card_country | Two-letter ISO code representing the country of the card. | |
| card_funding | Card funding type, if applicable. | |
| charge_created_utc | 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 UTC. | |
| charge_id | Unique identifier for the original charge associated with this balance transaction. Available for charges, refunds and disputes. | |
| connected_account | Unique identifier for the Stripe account associated with this line. | |
| created_utc | Time at which the balance transaction was created. Dates in UTC. | |
| currency | Three-letter ISO code for the currency in which gross, fee and net are defined. | |
| customer_description | Description provided when creating the customer, often used to store the customer name. | |
| customer_email | Email address of the customer, if any, associated with this balance transaction. | |
| 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. | |
| customer_facing_currency | For transactions associated with charges, refunds, or disputes, the three-letter ISO currency code for customer_facing_amount. | |
| customer_id | The unique ID of the related customer, if any. | |
| description | An arbitrary string attached to the balance transaction. Often useful for displaying to users. | |
| fee | Fees paid for this transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| gross | Gross amount of the transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| 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. | |
| is_link | Whether or not the payment was made using Link. | |
| net | Net amount of the transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| reporting_category | Reporting Category is a new categorization of balance transactions, meant to improve on the current type field. | |
| source_id | The Stripe object to which this transaction is related. | |
| source_transaction_id | The source transaction id in case of Separate Charges & Transfers and destination charges | |
| 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. | |
| trace_id | Trace ID is a unique identifier generated by bank for the Stripe payouts. Used by banks to locate specific transfers, sometimes referred to as a Reference number. | |
| trace_id_status | The status of the trace ID. Either pending, unsupported or supported. |
Connected account itemized single payout reconciliation
API report type: connected_account_payout_reconciliation.by_id.itemized.2
| Column name | Default | Description |
|---|---|---|
| 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. | |
| 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). | |
| available_on_utc | The date the balance transaction’s net funds will become available in the Stripe balance. Dates in UTC. | |
| balance_transaction_id | Unique identifier for the balance transaction. | |
| card_brand | Card brand, if applicable. | |
| card_country | Two-letter ISO code representing the country of the card. | |
| card_funding | Card funding type, if applicable. | |
| charge_created_utc | 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 UTC. | |
| charge_id | Unique identifier for the original charge associated with this balance transaction. Available for charges, refunds and disputes. | |
| connected_account | Unique identifier for the Stripe account associated with this line. | |
| created_utc | Time at which the balance transaction was created. Dates in UTC. | |
| currency | Three-letter ISO code for the currency in which gross, fee and net are defined. | |
| customer_description | Description provided when creating the customer, often used to store the customer name. | |
| customer_email | Email address of the customer, if any, associated with this balance transaction. | |
| 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. | |
| customer_facing_currency | For transactions associated with charges, refunds, or disputes, the three-letter ISO currency code for customer_facing_amount. | |
| customer_id | The unique ID of the related customer, if any. | |
| description | An arbitrary string attached to the balance transaction. Often useful for displaying to users. | |
| fee | Fees paid for this transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| gross | Gross amount of the transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| 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. | |
| is_link | Whether or not the payment was made using Link. | |
| net | Net amount of the transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| reporting_category | Reporting Category is a new categorization of balance transactions, meant to improve on the current type field. | |
| source_id | The Stripe object to which this transaction is related. | |
| source_transaction_id | The source transaction id in case of Separate Charges & Transfers and destination charges | |
| 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. | |
| trace_id | Trace ID is a unique identifier generated by bank for the Stripe payouts. Used by banks to locate specific transfers, sometimes referred to as a Reference number. | |
| trace_id_status | The status of the trace ID. Either pending, unsupported or supported. |
Connected account itemized single payout reconciliation
API report type: connected_account_payout_reconciliation.by_id.itemized.3
| Column name | Default | Description |
|---|---|---|
| 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. | |
| 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). | |
| available_on_utc | The date the balance transaction’s net funds will become available in the Stripe balance. Dates in UTC. | |
| balance_transaction_id | Unique identifier for the balance transaction. | |
| card_brand | Card brand, if applicable. | |
| card_country | Two-letter ISO code representing the country of the card. | |
| card_funding | Card funding type, if applicable. | |
| charge_created_utc | 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 UTC. | |
| charge_id | Unique identifier for the original charge associated with this balance transaction. Available for charges, refunds and disputes. | |
| connected_account | Unique identifier for the Stripe account associated with this line. | |
| created_utc | Time at which the balance transaction was created. Dates in UTC. | |
| currency | Three-letter ISO code for the currency in which gross, fee and net are defined. | |
| customer_description | Description provided when creating the customer, often used to store the customer name. | |
| customer_email | Email address of the customer, if any, associated with this balance transaction. | |
| 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. | |
| customer_facing_currency | For transactions associated with charges, refunds, or disputes, the three-letter ISO currency code for customer_facing_amount. | |
| customer_id | The unique ID of the related customer, if any. | |
| customer_name | Name of the customer, if any, associated with this balance transaction. | |
| description | An arbitrary string attached to the balance transaction. Often useful for displaying to users. | |
| dispute_reason | Reason given by cardholder for dispute. Read more about dispute reasons. | |
| fee | Fees paid for this transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| gross | Gross amount of the transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| 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. | |
| is_link | Whether or not the payment was made using Link. | |
| net | Net amount of the transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| payment_intent_id | The unique ID of the related Payment Intent, if any. | |
| payment_method_type | The type of payment method used in the related payment. | |
| regulatory_tag | An identifier reflecting the classification of this transaction according to local regulations, if applicable. Accounts with automatic payouts enabled receive a separate payout for each regulatory tag. This column is only populated for Brazilian accounts. | |
| reporting_category | Reporting Category is a new categorization of balance transactions, meant to improve on the current type field. | |
| shipping_address_city | City of the shipping address associated with this charge, if any | |
| shipping_address_country | Country of the shipping address associated with this charge, if any | |
| shipping_address_line1 | First line of the shipping address associated with this charge, if any | |
| shipping_address_line2 | Second line of the shipping address associated with this charge, if any | |
| shipping_address_postal_code | Postal code of the shipping address associated with this charge, if any | |
| shipping_address_state | State of the shipping address associated with this charge, if any | |
| source_id | The Stripe object to which this transaction is related. | |
| source_transaction_id | The source transaction id in case of Separate Charges & Transfers and destination charges | |
| statement_descriptor | The dynamic statement descriptor or suffix specified when the related charge was created. | |
| 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. | |
| trace_id | Trace ID is a unique identifier generated by bank for the Stripe payouts. Used by banks to locate specific transfers, sometimes referred to as a Reference number. | |
| trace_id_status | The status of the trace ID. Either pending, unsupported or supported. |
Connected account itemized single payout reconciliation
API report type: connected_account_payout_reconciliation.by_id.itemized.4
| Column name | Default | Description |
|---|---|---|
| acquirer_reference_number | The Acquirer Reference Number (ARN) for the refund, if available. Only populated for refund rows. | |
| 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. | |
| automatic_payout_effective_at_utc | 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. | |
| 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). | |
| 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. | |
| available_on_utc | The date the balance transaction’s net funds will become available in the Stripe balance. Dates in UTC. | |
| balance_transaction_id | Unique identifier for the balance transaction. | |
| card_brand | Card brand, if applicable. | |
| card_country | Two-letter ISO code representing the country of the card. | |
| card_funding | Card funding type, if applicable. | |
| 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. | |
| charge_created_utc | 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 UTC. | |
| charge_id | Unique identifier for the original charge associated with this balance transaction. Available for charges, refunds and disputes. | |
| connected_account | Unique identifier for the Stripe account associated with this line. | |
| created | Time at which the balance transaction was created. Dates in the requested timezone, or UTC if not provided. | |
| created_utc | Time at which the balance transaction was created. Dates in UTC. | |
| currency | Three-letter ISO code for the currency in which gross, fee and net are defined. | |
| customer_description | Description provided when creating the customer, often used to store the customer name. | |
| customer_email | Email address of the customer, if any, associated with this balance transaction. | |
| 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. | |
| customer_facing_currency | For transactions associated with charges, refunds, or disputes, the three-letter ISO currency code for customer_facing_amount. | |
| customer_id | The unique ID of the related customer, if any. | |
| customer_name | Name of the customer, if any, associated with this balance transaction. | |
| description | An arbitrary string attached to the balance transaction. Often useful for displaying to users. | |
| dispute_reason | Reason given by cardholder for dispute. Read more about dispute reasons. | |
| fee | Fees paid for this transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| gross | Gross amount of the transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| 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. | |
| is_link | Whether or not the payment was made using Link. | |
| net | Net amount of the transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| payment_intent_id | The unique ID of the related Payment Intent, if any. | |
| payment_metadata[key] | Metadata associated with the related PaymentIntent, if any. If no PaymentIntent metadata exists, metadata from any related charge object will be returned. API requests including this column must specify a metadata key in brackets. This column can be specified multiple times to retrieve data from additional metadata keys. | |
| payment_method_type | The type of payment method used in the related payment. | |
| refund_metadata[key] | Metadata associated with the related refund object, if any. API requests including this column must specify a metadata key in brackets. This column can be specified multiple times to retrieve data from additional metadata keys. | |
| regulatory_tag | An identifier reflecting the classification of this transaction according to local regulations, if applicable. Accounts with automatic payouts enabled receive a separate payout for each regulatory tag. This column is only populated for Brazilian accounts. | |
| reporting_category | Reporting Category is a new categorization of balance transactions, meant to improve on the current type field. | |
| shipping_address_city | City of the shipping address associated with this charge, if any | |
| shipping_address_country | Country of the shipping address associated with this charge, if any | |
| shipping_address_line1 | First line of the shipping address associated with this charge, if any | |
| shipping_address_line2 | Second line of the shipping address associated with this charge, if any | |
| shipping_address_postal_code | Postal code of the shipping address associated with this charge, if any | |
| shipping_address_state | State of the shipping address associated with this charge, if any | |
| source_id | The Stripe object to which this transaction is related. | |
| source_transaction_id | The source transaction id in case of Separate Charges & Transfers and destination charges | |
| statement_descriptor | The dynamic statement descriptor or suffix specified when the related charge was created. | |
| 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. | |
| trace_id | Trace ID is a unique identifier generated by bank for the Stripe payouts. Used by banks to locate specific transfers, sometimes referred to as a Reference number. | |
| trace_id_status | The status of the trace ID. Either pending, unsupported or supported. | |
| transfer_metadata[key] | Metadata associated with the related transfer object, if any. API requests including this column must specify a metadata key in brackets. This column can be specified multiple times to retrieve data from additional metadata keys. |
Connected account single payout reconciliation summary
API report type: connected_account_payout_reconciliation.by_id.summary.1
| Column name | Default | Description |
|---|---|---|
| count | The number of transactions associated with the reporting_category. | |
| currency | Three-letter ISO code for the currency in which gross, fee and net are defined. | |
| fee | Sum of the fees paid for the transactions associated with the reporting_category. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| gross | Sum of the gross amounts of the transactions associated with the reporting_category. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| net | Sum of the net amounts for the transactions associated with the reporting_category. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| reporting_category | Reporting Category is a new categorization of balance transactions, meant to improve on the current type field. |
Connected account itemized date-ranged payout reconciliation
API report type: connected_account_payout_reconciliation.itemized.1
| Column name | Default | Description |
|---|---|---|
| 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. | |
| 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). | |
| available_on_utc | The date the balance transaction’s net funds will become available in the Stripe balance. Dates in UTC. | |
| balance_transaction_id | Unique identifier for the balance transaction. | |
| card_brand | Card brand, if applicable. | |
| card_country | Two-letter ISO code representing the country of the card. | |
| card_funding | Card funding type, if applicable. | |
| charge_created_utc | 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 UTC. | |
| charge_id | Unique identifier for the original charge associated with this balance transaction. Available for charges, refunds and disputes. | |
| connected_account | Unique identifier for the Stripe account associated with this line. | |
| created_utc | Time at which the balance transaction was created. Dates in UTC. | |
| currency | Three-letter ISO code for the currency in which gross, fee and net are defined. | |
| customer_description | Description provided when creating the customer, often used to store the customer name. | |
| customer_email | Email address of the customer, if any, associated with this balance transaction. | |
| 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. | |
| customer_facing_currency | For transactions associated with charges, refunds, or disputes, the three-letter ISO currency code for customer_facing_amount. | |
| customer_id | The unique ID of the related customer, if any. | |
| description | An arbitrary string attached to the balance transaction. Often useful for displaying to users. | |
| fee | Fees paid for this transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| gross | Gross amount of the transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| 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. | |
| is_link | Whether or not the payment was made using Link. | |
| net | Net amount of the transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| reporting_category | Reporting Category is a new categorization of balance transactions, meant to improve on the current type field. | |
| source_id | The Stripe object to which this transaction is related. | |
| source_transaction_id | The source transaction id in case of Separate Charges & Transfers and destination charges | |
| 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. | |
| trace_id | Trace ID is a unique identifier generated by bank for the Stripe payouts. Used by banks to locate specific transfers, sometimes referred to as a Reference number. | |
| trace_id_status | The status of the trace ID. Either pending, unsupported or supported. |
Connected account itemized date-ranged payout reconciliation
API report type: connected_account_payout_reconciliation.itemized.2
| Column name | Default | Description |
|---|---|---|
| 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. | |
| 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). | |
| available_on_utc | The date the balance transaction’s net funds will become available in the Stripe balance. Dates in UTC. | |
| balance_transaction_id | Unique identifier for the balance transaction. | |
| card_brand | Card brand, if applicable. | |
| card_country | Two-letter ISO code representing the country of the card. | |
| card_funding | Card funding type, if applicable. | |
| charge_created_utc | 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 UTC. | |
| charge_id | Unique identifier for the original charge associated with this balance transaction. Available for charges, refunds and disputes. | |
| connected_account | Unique identifier for the Stripe account associated with this line. | |
| created_utc | Time at which the balance transaction was created. Dates in UTC. | |
| currency | Three-letter ISO code for the currency in which gross, fee and net are defined. | |
| customer_description | Description provided when creating the customer, often used to store the customer name. | |
| customer_email | Email address of the customer, if any, associated with this balance transaction. | |
| 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. | |
| customer_facing_currency | For transactions associated with charges, refunds, or disputes, the three-letter ISO currency code for customer_facing_amount. | |
| customer_id | The unique ID of the related customer, if any. | |
| description | An arbitrary string attached to the balance transaction. Often useful for displaying to users. | |
| fee | Fees paid for this transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| gross | Gross amount of the transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| 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. | |
| is_link | Whether or not the payment was made using Link. | |
| net | Net amount of the transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| reporting_category | Reporting Category is a new categorization of balance transactions, meant to improve on the current type field. | |
| source_id | The Stripe object to which this transaction is related. | |
| source_transaction_id | The source transaction id in case of Separate Charges & Transfers and destination charges | |
| 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. | |
| trace_id | Trace ID is a unique identifier generated by bank for the Stripe payouts. Used by banks to locate specific transfers, sometimes referred to as a Reference number. | |
| trace_id_status | The status of the trace ID. Either pending, unsupported or supported. |
Connected account itemized date-ranged payout reconciliation
API report type: connected_account_payout_reconciliation.itemized.3
| Column name | Default | Description |
|---|---|---|
| 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. | |
| 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). | |
| available_on_utc | The date the balance transaction’s net funds will become available in the Stripe balance. Dates in UTC. | |
| balance_transaction_id | Unique identifier for the balance transaction. | |
| card_address_city | City of the card address associated with this charge, if any | |
| card_address_country | Country of the card address associated with this charge, if any | |
| card_address_line1 | First line of the card address associated with this charge, if any | |
| card_address_line2 | Second line of the card address associated with this charge, if any | |
| card_address_postal_code | Postal code of the card address associated with this charge, if any | |
| card_address_state | State of the card address associated with this charge, if any | |
| card_brand | Card brand, if applicable. | |
| card_country | Two-letter ISO code representing the country of the card. | |
| card_funding | Card funding type, if applicable. | |
| charge_created_utc | 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 UTC. | |
| charge_id | Unique identifier for the original charge associated with this balance transaction. Available for charges, refunds and disputes. | |
| connected_account | Unique identifier for the Stripe account associated with this line. | |
| created_utc | Time at which the balance transaction was created. Dates in UTC. | |
| currency | Three-letter ISO code for the currency in which gross, fee and net are defined. | |
| customer_address_city | City of the customer address associated with this charge, if any | |
| customer_address_country | Country of the customer address associated with this charge, if any | |
| customer_address_line1 | First line of the customer address associated with this charge, if any | |
| customer_address_line2 | Second line of the customer address associated with this charge, if any | |
| customer_address_postal_code | Postal code of the customer address associated with this charge, if any | |
| customer_address_state | State of the customer address associated with this charge, if any | |
| customer_description | Description provided when creating the customer, often used to store the customer name. | |
| customer_email | Email address of the customer, if any, associated with this balance transaction. | |
| 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. | |
| customer_facing_currency | For transactions associated with charges, refunds, or disputes, the three-letter ISO currency code for customer_facing_amount. | |
| customer_id | The unique ID of the related customer, if any. | |
| customer_name | Name of the customer, if any, associated with this balance transaction. | |
| customer_shipping_address_city | City of the customer shipping address associated with this charge, if any | |
| customer_shipping_address_country | Country of the customer shipping address associated with this charge, if any | |
| customer_shipping_address_line1 | First line of the customer shipping address associated with this charge, if any | |
| customer_shipping_address_line2 | Second line of the customer shipping address associated with this charge, if any | |
| customer_shipping_address_postal_code | Postal code of the customer shipping address associated with this charge, if any | |
| customer_shipping_address_state | State of the customer shipping address associated with this charge, if any | |
| description | An arbitrary string attached to the balance transaction. Often useful for displaying to users. | |
| dispute_reason | Reason given by cardholder for dispute. Read more about dispute reasons. | |
| fee | Fees paid for this transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| gross | Gross amount of the transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| 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. | |
| 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. | |
| is_link | Whether or not the payment was made using Link. | |
| net | Net amount of the transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| payment_intent_id | The unique ID of the related Payment Intent, if any. | |
| payment_metadata[key] | Metadata associated with the related PaymentIntent, if any. If no PaymentIntent metadata exists, metadata from any related charge object will be returned. API requests including this column must specify a metadata key in brackets. This column can be specified multiple times to retrieve data from additional metadata keys. | |
| payment_method_type | The type of payment method used in the related payment. | |
| refund_metadata[key] | Metadata associated with the related refund object, if any. API requests including this column must specify a metadata key in brackets. This column can be specified multiple times to retrieve data from additional metadata keys. | |
| regulatory_tag | An identifier reflecting the classification of this transaction according to local regulations, if applicable. Accounts with automatic payouts enabled receive a separate payout for each regulatory tag. This column is only populated for Brazilian accounts. | |
| reporting_category | Reporting Category is a new categorization of balance transactions, meant to improve on the current type field. | |
| shipping_address_city | City of the shipping address associated with this charge, if any | |
| shipping_address_country | Country of the shipping address associated with this charge, if any | |
| shipping_address_line1 | First line of the shipping address associated with this charge, if any | |
| shipping_address_line2 | Second line of the shipping address associated with this charge, if any | |
| shipping_address_postal_code | Postal code of the shipping address associated with this charge, if any | |
| shipping_address_state | State of the shipping address associated with this charge, if any | |
| source_id | The Stripe object to which this transaction is related. | |
| source_transaction_id | The source transaction id in case of Separate Charges & Transfers and destination charges | |
| statement_descriptor | The dynamic statement descriptor or suffix specified when the related charge was created. | |
| 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. | |
| trace_id | Trace ID is a unique identifier generated by bank for the Stripe payouts. Used by banks to locate specific transfers, sometimes referred to as a Reference number. | |
| trace_id_status | The status of the trace ID. Either pending, unsupported or supported. | |
| transfer_metadata[key] | Metadata associated with the related transfer object, if any. API requests including this column must specify a metadata key in brackets. This column can be specified multiple times to retrieve data from additional metadata keys. |
Connected account itemized date-ranged payout reconciliation
API report type: connected_account_payout_reconciliation.itemized.4
| Column name | Default | Description |
|---|---|---|
| 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. | |
| automatic_payout_effective_at_utc | 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. | |
| 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). | |
| 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. | |
| available_on_utc | The date the balance transaction’s net funds will become available in the Stripe balance. Dates in UTC. | |
| balance_transaction_id | Unique identifier for the balance transaction. | |
| card_brand | Card brand, if applicable. | |
| card_country | Two-letter ISO code representing the country of the card. | |
| card_funding | Card funding type, if applicable. | |
| 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. | |
| charge_created_utc | 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 UTC. | |
| charge_id | Unique identifier for the original charge associated with this balance transaction. Available for charges, refunds and disputes. | |
| connected_account | Unique identifier for the Stripe account associated with this line. | |
| created | Time at which the balance transaction was created. Dates in the requested timezone, or UTC if not provided. | |
| created_utc | Time at which the balance transaction was created. Dates in UTC. | |
| currency | Three-letter ISO code for the currency in which gross, fee and net are defined. | |
| customer_description | Description provided when creating the customer, often used to store the customer name. | |
| customer_email | Email address of the customer, if any, associated with this balance transaction. | |
| 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. | |
| customer_facing_currency | For transactions associated with charges, refunds, or disputes, the three-letter ISO currency code for customer_facing_amount. | |
| customer_id | The unique ID of the related customer, if any. | |
| customer_name | Name of the customer, if any, associated with this balance transaction. | |
| description | An arbitrary string attached to the balance transaction. Often useful for displaying to users. | |
| fee | Fees paid for this transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| gross | Gross amount of the transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| 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. | |
| is_link | Whether or not the payment was made using Link. | |
| net | Net amount of the transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| payment_intent_id | The unique ID of the related Payment Intent, if any. | |
| payment_method_type | The type of payment method used in the related payment. | |
| reporting_category | Reporting Category is a new categorization of balance transactions, meant to improve on the current type field. | |
| shipping_address_city | City of the shipping address associated with this charge, if any | |
| shipping_address_country | Country of the shipping address associated with this charge, if any | |
| shipping_address_line1 | First line of the shipping address associated with this charge, if any | |
| shipping_address_line2 | Second line of the shipping address associated with this charge, if any | |
| shipping_address_postal_code | Postal code of the shipping address associated with this charge, if any | |
| shipping_address_state | State of the shipping address associated with this charge, if any | |
| source_id | The Stripe object to which this transaction is related. | |
| source_transaction_id | The source transaction id in case of Separate Charges & Transfers and destination charges | |
| statement_descriptor | The dynamic statement descriptor or suffix specified when the related charge was created. | |
| 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. | |
| trace_id | Trace ID is a unique identifier generated by bank for the Stripe payouts. Used by banks to locate specific transfers, sometimes referred to as a Reference number. | |
| trace_id_status | The status of the trace ID. Either pending, unsupported or supported. |
Connected account date-ranged payouts reconciliation summary
API report type: connected_account_payout_reconciliation.summary.1
| Column name | Default | Description |
|---|---|---|
| count | The number of transactions associated with the reporting_category. | |
| currency | Three-letter ISO code for the currency in which gross, fee and net are defined. | |
| fee | Sum of the fees paid for the transactions associated with the reporting_category. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| gross | Sum of the gross amounts of the transactions associated with the reporting_category. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| net | Sum of the net amounts for the transactions associated with the reporting_category. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| reporting_category | Reporting Category is a new categorization of balance transactions, meant to improve on the current type field. |
Connected account itemized ending balance reconciliation
API report type: connected_account_ending_balance_reconciliation.itemized.4
| Column name | Default | Description |
|---|---|---|
| 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. | |
| automatic_payout_effective_at_utc | 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. | |
| 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). | |
| 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. | |
| available_on_utc | The date the balance transaction’s net funds will become available in the Stripe balance. Dates in UTC. | |
| balance_transaction_id | Unique identifier for the balance transaction. | |
| balance_type | The type of balance this transaction belongs to (for example, payments, issuing, corporate_card). | |
| card_address_city | City of the card address associated with this charge, if any | |
| card_address_country | Country of the card address associated with this charge, if any | |
| card_address_line1 | First line of the card address associated with this charge, if any | |
| card_address_line2 | Second line of the card address associated with this charge, if any | |
| card_address_postal_code | Postal code of the card address associated with this charge, if any | |
| card_address_state | State of the card address associated with this charge, if any | |
| card_brand | Card brand, if applicable. | |
| card_country | Two-letter ISO code representing the country of the card. | |
| card_funding | Card funding type, if applicable. | |
| 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. | |
| charge_created_utc | 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 UTC. | |
| charge_id | Unique identifier for the original charge associated with this balance transaction. Available for charges, refunds and disputes. | |
| connected_account | Unique identifier for the Stripe account associated with this line. | |
| created | Time at which the balance transaction was created. Dates in the requested timezone, or UTC if not provided. | |
| created_utc | Time at which the balance transaction was created. Dates in UTC. | |
| currency | Three-letter ISO code for the currency in which gross, fee and net are defined. | |
| customer_address_city | City of the customer address associated with this charge, if any | |
| customer_address_country | Country of the customer address associated with this charge, if any | |
| customer_address_line1 | First line of the customer address associated with this charge, if any | |
| customer_address_line2 | Second line of the customer address associated with this charge, if any | |
| customer_address_postal_code | Postal code of the customer address associated with this charge, if any | |
| customer_address_state | State of the customer address associated with this charge, if any | |
| customer_description | Description provided when creating the customer, often used to store the customer name. | |
| customer_email | Email address of the customer, if any, associated with this balance transaction. | |
| 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. | |
| customer_facing_currency | For transactions associated with charges, refunds, or disputes, the three-letter ISO currency code for customer_facing_amount. | |
| customer_id | The unique ID of the related customer, if any. | |
| customer_name | Name of the customer, if any, associated with this balance transaction. | |
| customer_shipping_address_city | City of the customer shipping address associated with this charge, if any | |
| customer_shipping_address_country | Country of the customer shipping address associated with this charge, if any | |
| customer_shipping_address_line1 | First line of the customer shipping address associated with this charge, if any | |
| customer_shipping_address_line2 | Second line of the customer shipping address associated with this charge, if any | |
| customer_shipping_address_postal_code | Postal code of the customer shipping address associated with this charge, if any | |
| customer_shipping_address_state | State of the customer shipping address associated with this charge, if any | |
| description | An arbitrary string attached to the balance transaction. Often useful for displaying to users. | |
| dispute_reason | Reason given by cardholder for dispute. Read more about dispute reasons. | |
| fee | Fees paid for this transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| gross | Gross amount of the transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| 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. | |
| invoice_number | Number for the invoice associated with this balance transaction. Available for charges, refunds, and disputes made in connection with a Stripe Billing invoice. | |
| is_link | Whether or not the payment was made using Link. | |
| net | Net amount of the transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| payment_intent_id | The unique ID of the related Payment Intent, if any. | |
| payment_metadata[key] | Metadata associated with the related PaymentIntent, if any. If no PaymentIntent metadata exists, metadata from any related charge object will be returned. API requests including this column must specify a metadata key in brackets. This column can be specified multiple times to retrieve data from additional metadata keys. | |
| payment_method_type | The type of payment method used in the related payment. | |
| product_ids | Product IDs associated with the related balance transaction. | |
| product_names | Product names associated with the related balance transaction. | |
| refund_metadata[key] | Metadata associated with the related refund object, if any. API requests including this column must specify a metadata key in brackets. This column can be specified multiple times to retrieve data from additional metadata keys. | |
| regulatory_tag | An identifier reflecting the classification of this transaction according to local regulations, if applicable. Accounts with automatic payouts enabled receive a separate payout for each regulatory tag. This column is only populated for Brazilian accounts. | |
| reporting_category | Reporting Category is a new categorization of balance transactions, meant to improve on the current type field. | |
| shipping_address_city | City of the shipping address associated with this charge, if any | |
| shipping_address_country | Country of the shipping address associated with this charge, if any | |
| shipping_address_line1 | First line of the shipping address associated with this charge, if any | |
| shipping_address_line2 | Second line of the shipping address associated with this charge, if any | |
| shipping_address_postal_code | Postal code of the shipping address associated with this charge, if any | |
| shipping_address_state | State of the shipping address associated with this charge, if any | |
| source_id | The Stripe object to which this transaction is related. | |
| statement_descriptor | The dynamic statement descriptor or suffix specified when the related charge was created. | |
| 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. | |
| trace_id | Trace ID is a unique identifier generated by bank for the Stripe payouts. Used by banks to locate specific transfers, sometimes referred to as a Reference number. | |
| trace_id_status | The status of the trace ID. Either pending, unsupported or supported. | |
| transfer_metadata[key] | Metadata associated with the related transfer object, if any. API requests including this column must specify a metadata key in brackets. This column can be specified multiple times to retrieve data from additional metadata keys. |
Connected account itemized failed payouts
API report type: connected_account_failed_payouts.itemized.1
| Column name | Default | Description |
|---|---|---|
| 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. | |
| 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). | |
| available_on_utc | The date the balance transaction’s net funds will become available in the Stripe balance. Dates in UTC. | |
| balance_transaction_id | Unique identifier for the balance transaction. | |
| card_address_city | City of the card address associated with this charge, if any | |
| card_address_country | Country of the card address associated with this charge, if any | |
| card_address_line1 | First line of the card address associated with this charge, if any | |
| card_address_line2 | Second line of the card address associated with this charge, if any | |
| card_address_postal_code | Postal code of the card address associated with this charge, if any | |
| card_address_state | State of the card address associated with this charge, if any | |
| card_brand | Card brand, if applicable. | |
| card_country | Two-letter ISO code representing the country of the card. | |
| card_funding | Card funding type, if applicable. | |
| charge_created_utc | 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 UTC. | |
| charge_id | Unique identifier for the original charge associated with this balance transaction. Available for charges, refunds and disputes. | |
| connected_account | Unique identifier for the Stripe account associated with this line. | |
| created_utc | Time at which the balance transaction was created. Dates in UTC. | |
| currency | Three-letter ISO code for the currency in which gross, fee and net are defined. | |
| customer_address_city | City of the customer address associated with this charge, if any | |
| customer_address_country | Country of the customer address associated with this charge, if any | |
| customer_address_line1 | First line of the customer address associated with this charge, if any | |
| customer_address_line2 | Second line of the customer address associated with this charge, if any | |
| customer_address_postal_code | Postal code of the customer address associated with this charge, if any | |
| customer_address_state | State of the customer address associated with this charge, if any | |
| customer_description | Description provided when creating the customer, often used to store the customer name. | |
| customer_email | Email address of the customer, if any, associated with this balance transaction. | |
| 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. | |
| customer_facing_currency | For transactions associated with charges, refunds, or disputes, the three-letter ISO currency code for customer_facing_amount. | |
| customer_id | The unique ID of the related customer, if any. | |
| customer_name | Name of the customer, if any, associated with this balance transaction. | |
| customer_shipping_address_city | City of the customer shipping address associated with this charge, if any | |
| customer_shipping_address_country | Country of the customer shipping address associated with this charge, if any | |
| customer_shipping_address_line1 | First line of the customer shipping address associated with this charge, if any | |
| customer_shipping_address_line2 | Second line of the customer shipping address associated with this charge, if any | |
| customer_shipping_address_postal_code | Postal code of the customer shipping address associated with this charge, if any | |
| customer_shipping_address_state | State of the customer shipping address associated with this charge, if any | |
| description | An arbitrary string attached to the balance transaction. Often useful for displaying to users. | |
| dispute_reason | Reason given by cardholder for dispute. Read more about dispute reasons. | |
| fee | Fees paid for this transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| gross | Gross amount of the transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| 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. | |
| 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. | |
| is_link | Whether or not the payment was made using Link. | |
| net | Net amount of the transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| payment_intent_id | The unique ID of the related Payment Intent, if any. | |
| payment_metadata[key] | Metadata associated with the related PaymentIntent, if any. If no PaymentIntent metadata exists, metadata from any related charge object will be returned. API requests including this column must specify a metadata key in brackets. This column can be specified multiple times to retrieve data from additional metadata keys. | |
| payment_method_type | The type of payment method used in the related payment. | |
| refund_metadata[key] | Metadata associated with the related refund object, if any. API requests including this column must specify a metadata key in brackets. This column can be specified multiple times to retrieve data from additional metadata keys. | |
| regulatory_tag | An identifier reflecting the classification of this transaction according to local regulations, if applicable. Accounts with automatic payouts enabled receive a separate payout for each regulatory tag. This column is only populated for Brazilian accounts. | |
| reporting_category | Reporting Category is a new categorization of balance transactions, meant to improve on the current type field. | |
| retried_payout_id | The ID of the subsequent payout that retries the transactions from the failed payout. | |
| shipping_address_city | City of the shipping address associated with this charge, if any | |
| shipping_address_country | Country of the shipping address associated with this charge, if any | |
| shipping_address_line1 | First line of the shipping address associated with this charge, if any | |
| shipping_address_line2 | Second line of the shipping address associated with this charge, if any | |
| shipping_address_postal_code | Postal code of the shipping address associated with this charge, if any | |
| shipping_address_state | State of the shipping address associated with this charge, if any | |
| source_id | The Stripe object to which this transaction is related. | |
| source_transaction_id | The source transaction id in case of Separate Charges & Transfers and destination charges | |
| statement_descriptor | The dynamic statement descriptor or suffix specified when the related charge was created. | |
| 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. | |
| trace_id | Trace ID is a unique identifier generated by bank for the Stripe payouts. Used by banks to locate specific transfers, sometimes referred to as a Reference number. | |
| trace_id_status | The status of the trace ID. Either pending, unsupported or supported. | |
| transfer_metadata[key] | Metadata associated with the related transfer object, if any. API requests including this column must specify a metadata key in brackets. This column can be specified multiple times to retrieve data from additional metadata keys. |
Connected account itemized failed payouts
API report type: connected_account_failed_payouts.itemized.2
| Column name | Default | Description |
|---|---|---|
| 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. | |
| automatic_payout_effective_at_utc | 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. | |
| 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). | |
| 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. | |
| available_on_utc | The date the balance transaction’s net funds will become available in the Stripe balance. Dates in UTC. | |
| balance_transaction_id | Unique identifier for the balance transaction. | |
| card_address_city | City of the card address associated with this charge, if any | |
| card_address_country | Country of the card address associated with this charge, if any | |
| card_address_line1 | First line of the card address associated with this charge, if any | |
| card_address_line2 | Second line of the card address associated with this charge, if any | |
| card_address_postal_code | Postal code of the card address associated with this charge, if any | |
| card_address_state | State of the card address associated with this charge, if any | |
| card_brand | Card brand, if applicable. | |
| card_country | Two-letter ISO code representing the country of the card. | |
| card_funding | Card funding type, if applicable. | |
| card_network | Card network, if applicable. | |
| 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. | |
| charge_created_utc | 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 UTC. | |
| charge_id | Unique identifier for the original charge associated with this balance transaction. Available for charges, refunds and disputes. | |
| connected_account | Unique identifier for the Stripe account associated with this line. | |
| created | Time at which the balance transaction was created. Dates in the requested timezone, or UTC if not provided. | |
| created_utc | Time at which the balance transaction was created. Dates in UTC. | |
| currency | Three-letter ISO code for the currency in which gross, fee and net are defined. | |
| customer_address_city | City of the customer address associated with this charge, if any | |
| customer_address_country | Country of the customer address associated with this charge, if any | |
| customer_address_line1 | First line of the customer address associated with this charge, if any | |
| customer_address_line2 | Second line of the customer address associated with this charge, if any | |
| customer_address_postal_code | Postal code of the customer address associated with this charge, if any | |
| customer_address_state | State of the customer address associated with this charge, if any | |
| customer_description | Description provided when creating the customer, often used to store the customer name. | |
| customer_email | Email address of the customer, if any, associated with this balance transaction. | |
| 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. | |
| customer_facing_currency | For transactions associated with charges, refunds, or disputes, the three-letter ISO currency code for customer_facing_amount. | |
| customer_id | The unique ID of the related customer, if any. | |
| customer_name | Name of the customer, if any, associated with this balance transaction. | |
| customer_shipping_address_city | City of the customer shipping address associated with this charge, if any | |
| customer_shipping_address_country | Country of the customer shipping address associated with this charge, if any | |
| customer_shipping_address_line1 | First line of the customer shipping address associated with this charge, if any | |
| customer_shipping_address_line2 | Second line of the customer shipping address associated with this charge, if any | |
| customer_shipping_address_postal_code | Postal code of the customer shipping address associated with this charge, if any | |
| customer_shipping_address_state | State of the customer shipping address associated with this charge, if any | |
| description | An arbitrary string attached to the balance transaction. Often useful for displaying to users. | |
| dispute_reason | Reason given by cardholder for dispute. Read more about dispute reasons. | |
| fee | Fees paid for this transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| gross | Gross amount of the transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| 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. | |
| 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. | |
| is_link | Whether or not the payment was made using Link. | |
| net | Net amount of the transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| payment_intent_id | The unique ID of the related Payment Intent, if any. | |
| payment_metadata[key] | Metadata associated with the related PaymentIntent, if any. If no PaymentIntent metadata exists, metadata from any related charge object will be returned. API requests including this column must specify a metadata key in brackets. This column can be specified multiple times to retrieve data from additional metadata keys. | |
| payment_method_type | The type of payment method used in the related payment. | |
| refund_metadata[key] | Metadata associated with the related refund object, if any. API requests including this column must specify a metadata key in brackets. This column can be specified multiple times to retrieve data from additional metadata keys. | |
| regulatory_tag | An identifier reflecting the classification of this transaction according to local regulations, if applicable. Accounts with automatic payouts enabled receive a separate payout for each regulatory tag. This column is only populated for Brazilian accounts. | |
| reporting_category | Reporting Category is a new categorization of balance transactions, meant to improve on the current type field. | |
| retried_payout_id | The ID of the subsequent payout that retries the transactions from the failed payout. | |
| shipping_address_city | City of the shipping address associated with this charge, if any | |
| shipping_address_country | Country of the shipping address associated with this charge, if any | |
| shipping_address_line1 | First line of the shipping address associated with this charge, if any | |
| shipping_address_line2 | Second line of the shipping address associated with this charge, if any | |
| shipping_address_postal_code | Postal code of the shipping address associated with this charge, if any | |
| shipping_address_state | State of the shipping address associated with this charge, if any | |
| source_id | The Stripe object to which this transaction is related. | |
| source_transaction_id | The source transaction id in case of Separate Charges & Transfers and destination charges | |
| statement_descriptor | The dynamic statement descriptor or suffix specified when the related charge was created. | |
| 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. | |
| trace_id | Trace ID is a unique identifier generated by bank for the Stripe payouts. Used by banks to locate specific transfers, sometimes referred to as a Reference number. | |
| trace_id_status | The status of the trace ID. Either pending, unsupported or supported. | |
| transfer_metadata[key] | Metadata associated with the related transfer object, if any. API requests including this column must specify a metadata key in brackets. This column can be specified multiple times to retrieve data from additional metadata keys. |
Connected account failed payouts summary
API report type: connected_account_failed_payouts.summary.1
| Column name | Default | Description |
|---|---|---|
| count | The number of transactions associated with the reporting_category. | |
| currency | Three-letter ISO code for the currency in which gross, fee and net are defined. | |
| fee | Sum of the fees paid for the transactions associated with the reporting_category. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| gross | Sum of the gross amounts of the transactions associated with the reporting_category. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| net | Sum of the net amounts for the transactions associated with the reporting_category. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| reporting_category | Reporting Category is a new categorization of balance transactions, meant to improve on the current type field. |
Connected account itemized date-ranged payout reconciliation
API report type: connected_account_payout_reconciliation.itemized.5
| Column name | Default | Description |
|---|---|---|
| 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. | |
| automatic_payout_effective_at_utc | 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. | |
| 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). | |
| 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. | |
| available_on_utc | The date the balance transaction’s net funds will become available in the Stripe balance. Dates in UTC. | |
| balance_transaction_id | Unique identifier for the balance transaction. | |
| card_address_city | City of the card address associated with this charge, if any | |
| card_address_country | Country of the card address associated with this charge, if any | |
| card_address_line1 | First line of the card address associated with this charge, if any | |
| card_address_line2 | Second line of the card address associated with this charge, if any | |
| card_address_postal_code | Postal code of the card address associated with this charge, if any | |
| card_address_state | State of the card address associated with this charge, if any | |
| card_brand | Card brand, if applicable. | |
| card_country | Two-letter ISO code representing the country of the card. | |
| card_funding | Card funding type, if applicable. | |
| 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. | |
| charge_created_utc | 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 UTC. | |
| charge_id | Unique identifier for the original charge associated with this balance transaction. Available for charges, refunds and disputes. | |
| connected_account | Unique identifier for the Stripe account associated with this line. | |
| created | Time at which the balance transaction was created. Dates in the requested timezone, or UTC if not provided. | |
| created_utc | Time at which the balance transaction was created. Dates in UTC. | |
| currency | Three-letter ISO code for the currency in which gross, fee and net are defined. | |
| customer_address_city | City of the customer address associated with this charge, if any | |
| customer_address_country | Country of the customer address associated with this charge, if any | |
| customer_address_line1 | First line of the customer address associated with this charge, if any | |
| customer_address_line2 | Second line of the customer address associated with this charge, if any | |
| customer_address_postal_code | Postal code of the customer address associated with this charge, if any | |
| customer_address_state | State of the customer address associated with this charge, if any | |
| customer_description | Description provided when creating the customer, often used to store the customer name. | |
| customer_email | Email address of the customer, if any, associated with this balance transaction. | |
| 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. | |
| customer_facing_currency | For transactions associated with charges, refunds, or disputes, the three-letter ISO currency code for customer_facing_amount. | |
| customer_id | The unique ID of the related customer, if any. | |
| customer_name | Name of the customer, if any, associated with this balance transaction. | |
| customer_shipping_address_city | City of the customer shipping address associated with this charge, if any | |
| customer_shipping_address_country | Country of the customer shipping address associated with this charge, if any | |
| customer_shipping_address_line1 | First line of the customer shipping address associated with this charge, if any | |
| customer_shipping_address_line2 | Second line of the customer shipping address associated with this charge, if any | |
| customer_shipping_address_postal_code | Postal code of the customer shipping address associated with this charge, if any | |
| customer_shipping_address_state | State of the customer shipping address associated with this charge, if any | |
| description | An arbitrary string attached to the balance transaction. Often useful for displaying to users. | |
| dispute_reason | Reason given by cardholder for dispute. Read more about dispute reasons. | |
| fee | Fees paid for this transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| gross | Gross amount of the transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| 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. | |
| 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. | |
| is_link | Whether or not the payment was made using Link. | |
| net | Net amount of the transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| payment_intent_id | The unique ID of the related Payment Intent, if any. | |
| payment_metadata[key] | Metadata associated with the related PaymentIntent, if any. If no PaymentIntent metadata exists, metadata from any related charge object will be returned. API requests including this column must specify a metadata key in brackets. This column can be specified multiple times to retrieve data from additional metadata keys. | |
| payment_method_type | The type of payment method used in the related payment. | |
| refund_metadata[key] | Metadata associated with the related refund object, if any. API requests including this column must specify a metadata key in brackets. This column can be specified multiple times to retrieve data from additional metadata keys. | |
| regulatory_tag | An identifier reflecting the classification of this transaction according to local regulations, if applicable. Accounts with automatic payouts enabled receive a separate payout for each regulatory tag. This column is only populated for Brazilian accounts. | |
| reporting_category | Reporting Category is a new categorization of balance transactions, meant to improve on the current type field. | |
| shipping_address_city | City of the shipping address associated with this charge, if any | |
| shipping_address_country | Country of the shipping address associated with this charge, if any | |
| shipping_address_line1 | First line of the shipping address associated with this charge, if any | |
| shipping_address_line2 | Second line of the shipping address associated with this charge, if any | |
| shipping_address_postal_code | Postal code of the shipping address associated with this charge, if any | |
| shipping_address_state | State of the shipping address associated with this charge, if any | |
| source_id | The Stripe object to which this transaction is related. | |
| source_transaction_id | The source transaction id in case of Separate Charges & Transfers and destination charges | |
| statement_descriptor | The dynamic statement descriptor or suffix specified when the related charge was created. | |
| 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. | |
| trace_id | Trace ID is a unique identifier generated by bank for the Stripe payouts. Used by banks to locate specific transfers, sometimes referred to as a Reference number. | |
| trace_id_status | The status of the trace ID. Either pending, unsupported or supported. | |
| transfer_metadata[key] | Metadata associated with the related transfer object, if any. API requests including this column must specify a metadata key in brackets. This column can be specified multiple times to retrieve data from additional metadata keys. |
Connected account itemized date-ranged payout reconciliation
API report type: connected_account_payout_reconciliation.itemized.6
| Column name | Default | Description |
|---|---|---|
| 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. | |
| 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). | |
| available_on_utc | The date the balance transaction’s net funds will become available in the Stripe balance. Dates in UTC. | |
| balance_transaction_id | Unique identifier for the balance transaction. | |
| card_address_city | City of the card address associated with this charge, if any | |
| card_address_country | Country of the card address associated with this charge, if any | |
| card_address_line1 | First line of the card address associated with this charge, if any | |
| card_address_line2 | Second line of the card address associated with this charge, if any | |
| card_address_postal_code | Postal code of the card address associated with this charge, if any | |
| card_address_state | State of the card address associated with this charge, if any | |
| card_brand | Card brand, if applicable. | |
| card_country | Two-letter ISO code representing the country of the card. | |
| card_funding | Card funding type, if applicable. | |
| charge_created_utc | 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 UTC. | |
| charge_id | Unique identifier for the original charge associated with this balance transaction. Available for charges, refunds and disputes. | |
| connected_account | Unique identifier for the Stripe account associated with this line. | |
| created_utc | Time at which the balance transaction was created. Dates in UTC. | |
| currency | Three-letter ISO code for the currency in which gross, fee and net are defined. | |
| customer_address_city | City of the customer address associated with this charge, if any | |
| customer_address_country | Country of the customer address associated with this charge, if any | |
| customer_address_line1 | First line of the customer address associated with this charge, if any | |
| customer_address_line2 | Second line of the customer address associated with this charge, if any | |
| customer_address_postal_code | Postal code of the customer address associated with this charge, if any | |
| customer_address_state | State of the customer address associated with this charge, if any | |
| customer_description | Description provided when creating the customer, often used to store the customer name. | |
| customer_email | Email address of the customer, if any, associated with this balance transaction. | |
| 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. | |
| customer_facing_currency | For transactions associated with charges, refunds, or disputes, the three-letter ISO currency code for customer_facing_amount. | |
| customer_id | The unique ID of the related customer, if any. | |
| customer_name | Name of the customer, if any, associated with this balance transaction. | |
| customer_shipping_address_city | City of the customer shipping address associated with this charge, if any | |
| customer_shipping_address_country | Country of the customer shipping address associated with this charge, if any | |
| customer_shipping_address_line1 | First line of the customer shipping address associated with this charge, if any | |
| customer_shipping_address_line2 | Second line of the customer shipping address associated with this charge, if any | |
| customer_shipping_address_postal_code | Postal code of the customer shipping address associated with this charge, if any | |
| customer_shipping_address_state | State of the customer shipping address associated with this charge, if any | |
| description | An arbitrary string attached to the balance transaction. Often useful for displaying to users. | |
| dispute_reason | Reason given by cardholder for dispute. Read more about dispute reasons. | |
| fee | Fees paid for this transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| gross | Gross amount of the transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| 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. | |
| 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. | |
| is_link | Whether or not the payment was made using Link. | |
| net | Net amount of the transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| payment_intent_id | The unique ID of the related Payment Intent, if any. | |
| payment_metadata[key] | Metadata associated with the related PaymentIntent, if any. If no PaymentIntent metadata exists, metadata from any related charge object will be returned. API requests including this column must specify a metadata key in brackets. This column can be specified multiple times to retrieve data from additional metadata keys. | |
| payment_method_type | The type of payment method used in the related payment. | |
| payout_reference_token | A unique reference token that displays on the beneficiary’s bank statement. | |
| payout_statement_descriptor | Extra information that displays on the recipient’s bank statement. Most banks truncate this information and display it inconsistently. Some banks might not display it at all. | |
| refund_metadata[key] | Metadata associated with the related refund object, if any. API requests including this column must specify a metadata key in brackets. This column can be specified multiple times to retrieve data from additional metadata keys. | |
| regulatory_tag | An identifier reflecting the classification of this transaction according to local regulations, if applicable. Accounts with automatic payouts enabled receive a separate payout for each regulatory tag. This column is only populated for Brazilian accounts. | |
| reporting_category | Reporting Category is a new categorization of balance transactions, meant to improve on the current type field. | |
| shipping_address_city | City of the shipping address associated with this charge, if any | |
| shipping_address_country | Country of the shipping address associated with this charge, if any | |
| shipping_address_line1 | First line of the shipping address associated with this charge, if any | |
| shipping_address_line2 | Second line of the shipping address associated with this charge, if any | |
| shipping_address_postal_code | Postal code of the shipping address associated with this charge, if any | |
| shipping_address_state | State of the shipping address associated with this charge, if any | |
| source_id | The Stripe object to which this transaction is related. | |
| source_transaction_id | The source transaction id in case of Separate Charges & Transfers and destination charges | |
| statement_descriptor | The dynamic statement descriptor or suffix specified when the related charge was created. | |
| 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. | |
| trace_id | Trace ID is a unique identifier generated by bank for the Stripe payouts. Used by banks to locate specific transfers, sometimes referred to as a Reference number. | |
| trace_id_status | The status of the trace ID. Either pending, unsupported or supported. | |
| transfer_metadata[key] | Metadata associated with the related transfer object, if any. API requests including this column must specify a metadata key in brackets. This column can be specified multiple times to retrieve data from additional metadata keys. |
Connected account itemized date-ranged payout reconciliation
API report type: connected_account_payout_reconciliation.itemized.7
| Column name | Default | Description |
|---|---|---|
| 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. | |
| automatic_payout_effective_at_utc | 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. | |
| 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). | |
| 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. | |
| available_on_utc | The date the balance transaction’s net funds will become available in the Stripe balance. Dates in UTC. | |
| balance_transaction_id | Unique identifier for the balance transaction. | |
| card_address_city | City of the card address associated with this charge, if any | |
| card_address_country | Country of the card address associated with this charge, if any | |
| card_address_line1 | First line of the card address associated with this charge, if any | |
| card_address_line2 | Second line of the card address associated with this charge, if any | |
| card_address_postal_code | Postal code of the card address associated with this charge, if any | |
| card_address_state | State of the card address associated with this charge, if any | |
| card_brand | Card brand, if applicable. | |
| card_country | Two-letter ISO code representing the country of the card. | |
| card_funding | Card funding type, if applicable. | |
| card_network | Card network, if applicable. | |
| 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. | |
| charge_created_utc | 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 UTC. | |
| charge_id | Unique identifier for the original charge associated with this balance transaction. Available for charges, refunds and disputes. | |
| connected_account | Unique identifier for the Stripe account associated with this line. | |
| created | Time at which the balance transaction was created. Dates in the requested timezone, or UTC if not provided. | |
| created_utc | Time at which the balance transaction was created. Dates in UTC. | |
| currency | Three-letter ISO code for the currency in which gross, fee and net are defined. | |
| customer_address_city | City of the customer address associated with this charge, if any | |
| customer_address_country | Country of the customer address associated with this charge, if any | |
| customer_address_line1 | First line of the customer address associated with this charge, if any | |
| customer_address_line2 | Second line of the customer address associated with this charge, if any | |
| customer_address_postal_code | Postal code of the customer address associated with this charge, if any | |
| customer_address_state | State of the customer address associated with this charge, if any | |
| customer_description | Description provided when creating the customer, often used to store the customer name. | |
| customer_email | Email address of the customer, if any, associated with this balance transaction. | |
| 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. | |
| customer_facing_currency | For transactions associated with charges, refunds, or disputes, the three-letter ISO currency code for customer_facing_amount. | |
| customer_id | The unique ID of the related customer, if any. | |
| customer_name | Name of the customer, if any, associated with this balance transaction. | |
| customer_shipping_address_city | City of the customer shipping address associated with this charge, if any | |
| customer_shipping_address_country | Country of the customer shipping address associated with this charge, if any | |
| customer_shipping_address_line1 | First line of the customer shipping address associated with this charge, if any | |
| customer_shipping_address_line2 | Second line of the customer shipping address associated with this charge, if any | |
| customer_shipping_address_postal_code | Postal code of the customer shipping address associated with this charge, if any | |
| customer_shipping_address_state | State of the customer shipping address associated with this charge, if any | |
| description | An arbitrary string attached to the balance transaction. Often useful for displaying to users. | |
| dispute_reason | Reason given by cardholder for dispute. Read more about dispute reasons. | |
| fee | Fees paid for this transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| gross | Gross amount of the transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| 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. | |
| 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. | |
| is_link | Whether or not the payment was made using Link. | |
| net | Net amount of the transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| payment_intent_id | The unique ID of the related Payment Intent, if any. | |
| payment_metadata[key] | Metadata associated with the related PaymentIntent, if any. If no PaymentIntent metadata exists, metadata from any related charge object will be returned. API requests including this column must specify a metadata key in brackets. This column can be specified multiple times to retrieve data from additional metadata keys. | |
| payment_method_type | The type of payment method used in the related payment. | |
| payout_reference_token | A unique reference token that displays on the beneficiary’s bank statement. | |
| payout_statement_descriptor | Extra information that displays on the recipient’s bank statement. Most banks truncate this information and display it inconsistently. Some banks might not display it at all. | |
| product_ids | Product IDs associated with the related balance transaction. | |
| product_names | Product names associated with the related balance transaction. | |
| refund_metadata[key] | Metadata associated with the related refund object, if any. API requests including this column must specify a metadata key in brackets. This column can be specified multiple times to retrieve data from additional metadata keys. | |
| regulatory_tag | An identifier reflecting the classification of this transaction according to local regulations, if applicable. Accounts with automatic payouts enabled receive a separate payout for each regulatory tag. This column is only populated for Brazilian accounts. | |
| reporting_category | Reporting Category is a new categorization of balance transactions, meant to improve on the current type field. | |
| shipping_address_city | City of the shipping address associated with this charge, if any | |
| shipping_address_country | Country of the shipping address associated with this charge, if any | |
| shipping_address_line1 | First line of the shipping address associated with this charge, if any | |
| shipping_address_line2 | Second line of the shipping address associated with this charge, if any | |
| shipping_address_postal_code | Postal code of the shipping address associated with this charge, if any | |
| shipping_address_state | State of the shipping address associated with this charge, if any | |
| source_id | The Stripe object to which this transaction is related. | |
| source_payment_intent_id | The payment intent ID on the platform associated with the source transaction. | |
| source_transaction_id | The source transaction id in case of Separate Charges & Transfers and destination charges | |
| statement_descriptor | The dynamic statement descriptor or suffix specified when the related charge was created. | |
| 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. | |
| trace_id | Trace ID is a unique identifier generated by bank for the Stripe payouts. Used by banks to locate specific transfers, sometimes referred to as a Reference number. | |
| trace_id_status | The status of the trace ID. Either pending, unsupported or supported. | |
| transfer_metadata[key] | Metadata associated with the related transfer object, if any. API requests including this column must specify a metadata key in brackets. This column can be specified multiple times to retrieve data from additional metadata keys. |
Connected account date-ranged payouts reconciliation summary
API report type: connected_account_payout_reconciliation.summary.2
| Column name | Default | Description |
|---|---|---|
| count | The number of transactions associated with the reporting_category. | |
| currency | Three-letter ISO code for the currency in which gross, fee and net are defined. | |
| fee | Sum of the fees paid for the transactions associated with the reporting_category. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| gross | Sum of the gross amounts of the transactions associated with the reporting_category. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| net | Sum of the net amounts for the transactions associated with the reporting_category. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | |
| reporting_category | Reporting Category is a new categorization of balance transactions, meant to improve on the current type field. |
Connected accounts All fees itemized pivoted on balance_transaction_created
API report type: connected_account_stripe_fees.balance_transaction_created.itemized.1
| Column name | Default | Description |
|---|---|---|
| account | The ID of the merchant. | |
| activity_end_time | For a fee based on activity that spans a period of time, the activity’s end date in the requested time zone. | |
| activity_start_time | For a fee based on activity that spans a period of time, the activity’s start date in the requested time zone. | |
| amount | Amount of the fee, expressed in major units of the currency. | |
| balance_transaction_created | Time at which the fee transaction affected your Stripe balance, in the requested time zone. | |
| balance_transaction_description | Description of the balance transaction containing the fee. | |
| balance_transaction_id | ID of the balance transaction containing the fee. | |
| currency | Three-letter ISO code for the currency of amount and tax. | |
| fee_category | Classification of the fee. | |
| fee_transaction_created | Creation time of the fee transaction that deducts this fee from your Stripe v1, v2 or credit balances. | |
| fee_transaction_id | ID of the fee transaction that deducts this fee from your Stripe v1, v2 or credit balances. | |
| incurred_at | Time of the originating event that incurred the fee, in the requested time zone. | |
| incurred_by | ID of the object that incurred the fee, if any. The object type appears in the incurred_by_type field. | |
| incurred_by_type | The type of the incurred_by object. It matches the object field in the API (with values such as charge, refund, or invoice). | |
| pricing_tier | The pricing tier at which this fee was assessed. | |
| product_feature_description | The product or feature associated with the fee. | |
| tax | Tax on the fee, expressed in major units of the currency. |
Connected accounts All fees summary pivoted on balance transaction date
API report type: connected_account_stripe_fees.balance_transaction_created.summary.1
| Column name | Default | Description |
|---|---|---|
| amount | Total amount of the fees associated with the fee_category and the product or feature in product_feature_description. Expressed in major units of the currency (for example, dollars for USD or yen for JPY). | |
| currency | Three-letter ISO code for the currency of amount and tax. | |
| fee_category | Classification of the fees included in amount. | |
| product_feature_description | The product or feature associated with the fees included in amount. | |
| tax | Tax on the fees included in amount, expressed in major units of the currency. |
Connect accounts All fees itemized pivoted on incurred at date
API report type: connected_account_stripe_fees.incurred_at.itemized.1
| Column name | Default | Description |
|---|---|---|
| account | The ID of the merchant. | |
| activity_end_time | For a fee based on activity that spans a period of time, the activity’s end date in the requested time zone. | |
| activity_start_time | For a fee based on activity that spans a period of time, the activity’s start date in the requested time zone. | |
| amount | Amount of the fee, expressed in major units of the currency. | |
| balance_transaction_created | Time at which the fee transaction affected your Stripe balance, in the requested time zone. | |
| balance_transaction_description | Description of the balance transaction containing the fee. | |
| balance_transaction_id | ID of the balance transaction containing the fee. | |
| currency | Three-letter ISO code for the currency of amount and tax. | |
| fee_category | Classification of the fee. | |
| fee_transaction_created | Creation time of the fee transaction that deducts this fee from your Stripe v1, v2 or credit balances. | |
| fee_transaction_id | ID of the fee transaction that deducts this fee from your Stripe v1, v2 or credit balances. | |
| incurred_at | Time of the originating event that incurred the fee, in the requested time zone. | |
| incurred_by | ID of the object that incurred the fee, if any. The object type appears in the incurred_by_type field. | |
| incurred_by_type | The type of the incurred_by object. It matches the object field in the API (with values such as charge, refund, or invoice). | |
| pricing_tier | The pricing tier at which this fee was assessed. | |
| product_feature_description | The product or feature associated with the fee. | |
| tax | Tax on the fee, expressed in major units of the currency. |
Connected accounts All fees summary pivoted on incurred at date
API report type: connected_account_stripe_fees.incurred_at.summary.1
| Column name | Default | Description |
|---|---|---|
| amount | Total amount of the fees associated with the fee_category and the product or feature in product_feature_description. Expressed in major units of the currency (for example, dollars for USD or yen for JPY). | |
| currency | Three-letter ISO code for the currency of amount and tax. | |
| fee_category | Classification of the fees included in amount. | |
| product_feature_description | The product or feature associated with the fees included in amount. | |
| tax | Tax on the fees included in amount, expressed in major units of the currency. |
Connected accounts with negative balances disputes and refunds
API report type: connect.negative_balance_refunds_disputes_overview.1
| Column name | Default | Description |
|---|---|---|
| account_id | The ID of the connected account. | |
| balance | The balance of the connected account, including both available and pending funds. | |
| balance_24hr_net_change | The 24 hour net change in balance for the connected account. | |
| balance_excluding_pending_debits | The balance, excluding pending debits. | |
| business_name | The business name of the connected account. | |
| country | Two-letter ISO code representing the account’s country. | |
| currency | Three-letter ISO code for the currency in which the balance, refunded amount, and disputed amount are defined. | |
| dispute_pct_change | The percent change in disputes in the past 7 days compared to the preceding period. | |
| disputed_amount_7d | The total amount disputed in the past 7 days related to the connected account. | |
| disputed_amount_7d_prev | The total amount disputed in the past 7 days prior to the most recent 7 days related to the connected account. | |
| has_24hr_negative_balance_change | Whether the account has had their balance go negative in the past 24 hours. | |
| has_high_disputes | Whether the account has been tagged as having high disputes. | |
| has_high_refunds | Whether the account has been tagged as having high refunds. | |
| pending_debits | The sum of debits that are currently pending or in transit on the connected account. | |
| refund_pct_change | The percent change in refunds in the past 7 days compared to the preceding period. | |
| refunded_amount_7d | The total amount refunded in the past 7 days related to the connected account. | |
| refunded_amount_7d_prev | The total amount refunded in the past 7 days prior to the most recent 7 days related to the connected account. |
Connected account itemized tax transactions
API report type: connected_account_tax.transactions.itemized.2
| Column name | Default | Description |
|---|---|---|
| connected_account | Unique ID for the Connected account associated with this line. | |
| country_code | Two-letter ISO code representing the situs country. | |
| credit_note_metadata[key] | Metadata associated with a Credit Note object | |
| currency | Transaction currency presented to the buyer. | |
| customer_tax_id | List of tax ID type-value pairs for the customer. | |
| destination_resolved_address_country | Two-letter ISO code representing the customer country. | |
| destination_resolved_address_state | Two-letter ISO code representing the customer country subdivision. | |
| filing_currency | Filing currency for applicable registration jurisdiction. | |
| filing_exchange_rate | Filing exchange rate used. | |
| filing_non_taxable_amount | Non-taxable amount in filing currency. | |
| filing_tax_amount | Tax amount in filing currency. | |
| filing_taxable_amount | Taxable amount in filing currency. | |
| filing_total | Taxable amount plus tax or non-taxable amount in filing currency. | |
| id | Unique ID for the tax transaction. A transaction is identified by reference to an invoice, checkout session, credit note, subscription, or order. | |
| invoice_metadata[key] | Metadata associated with an Invoice object | |
| jurisdiction_level | Jurisdiction level imposing the tax. | |
| jurisdiction_name | Imposing tax jurisdiction name. | |
| line_item_id | Unique ID for the line item associated with the tax transaction. Multiple sales taxes rates may be applied to a single line item, so you may see several rows with the same line item ID. | |
| non_taxable_amount | Non-taxable amount in the transaction currency. | |
| origin_resolved_address_country | Two-letter ISO code representing the merchant country. | |
| origin_resolved_address_state | Two-letter ISO code representing the merchant country subdivision. | |
| quantity | Units sold as per the invoice. | |
| quantity_decimal | Units sold as per the invoice expressed in decimal. | |
| refund_metadata[key] | Metadata associated with a Refund object | |
| state_code | Two-letter ISO code representing the situs country subdivision. | |
| subtotal | Taxable or non-taxable amount. | |
| tax_amount | Tax amount in the transaction currency. | |
| tax_code | Unique ID for the product tax code assigned to the line item. | |
| tax_date | Date used to determine the tax rules and rates. It’s usually the same date as the transaction date, but can vary for refunds. When a credit note is issued, the transaction_date is when the credit note was issued. The tax_date is when tax was calculated on the original transaction. | |
| tax_name | Local name of the applicable tax. | |
| tax_rate | Tax rate applied to the line item. | |
| tax_transaction_metadata[key] | Metadata associated with a Tax Transaction object | |
| taxability | Indicates whether a line item is taxable or non_taxable. | |
| taxability_reason | Reason for tax collection or non-collection. | |
| taxable_amount | Taxable amount in the transaction currency. | |
| total | Taxable amount plus tax or the non-taxable amount. | |
| transaction_date | Date when the transaction is committed in the requested timezone. | |
| type | How a transaction is processed by Stripe. Possible values are: invoice, checkout, payment_link, payment_intent, order, refund, credit_note. |
Connect Card Payments Plan Level Report
API report type: connect_card_payments_fees.plan_level.1
| Column name | Default | Description |
|---|---|---|
| billing_amount | Total amount billed to the connected account. | |
| billing_currency | Currency of the ‘billing_amount’. | |
| connected_account_id | ID of the connected account. (For example, ‘acct_1234’) | |
| connected_account_name | Human-readable name of the connected account | |
| count | The number of times ‘fixed_rate’ was incurred. | |
| fee_amount | Total fee amount incurred, equal to ‘variable_rate’ * ‘variable_volume_amount’ + ‘fixed_rate’ * ‘count’ | |
| fee_currency | Currency of ‘fee_amount’, ‘variable_volume_amount’, and ‘fixed_rate’. | |
| fee_incurred_month | Start of the calendar month during which the fee was incurred. Measured in seconds since the Unix epoch | |
| fixed_rate | Fixed fee amount applicable for the fee plan. | |
| network_cost_category | Category of network costs. ‘interchange’, ‘card_scheme’, ‘discount’, or ‘non_transactional_card_scheme’ | |
| plan_name | Name of network cost plan. (For example, ‘Volume Fee - POS Mastercard Debit/Prepaid’) | |
| platform_id | ID of the platform account. (For example, ‘acct_1234’) | |
| variable_rate | Variable rate applicable for the fee plan. | |
| variable_volume_amount | The total amount on which the ‘variable_rate’ was applied. |
Connect Card Payments Transaction Level Report
API report type: connect_card_payments_fees.transaction_level.1
| Column name | Default | Description |
|---|---|---|
| automatic_payout_id | ID of the automatic payout with which contained the balance_transaction | |
| balance_transaction_created | Time at which the balance transaction was created. Measured in seconds since the Unix epoch | |
| balance_transaction_id | ID of the balance transaction that performed the change in the connected account’s balance (For example, ‘bt_1234’) | |
| billing_amount | Total amount of fees billed to the connected account. | |
| billing_currency | Currency of the ‘billing_amount’ and ‘platform_application_fee’ columns. | |
| bin | BIN number of the card that this fee was incurred for. | |
| captured_amount | Amount captured by the charge. Non-zero only on rows with ‘fee_category’=‘platform_fee’ | |
| captured_currency | Currency of the ‘captured_amount’ | |
| card_brand | Brand of the card that this fee was incurred for. (For example, ‘Visa’ or ‘MasterCard’) | |
| card_country | The ISO country code for the country that the card was issued in. (For example, ‘US’) | |
| card_funding | The funding type of the card that this fee was incurred for. (For example, ‘debit’, ‘credit’, or ‘prepaid’) | |
| card_present | Boolean indicating if the card was physically present at purchase. | |
| card_scheme_fee | Scheme fee amount incurred. | |
| charge_id | ID of the charge that this fee is associated with (For example, ‘ch_1234’ or ‘py_1234’) | |
| connected_account_id | ID of the connected account. (For example, ‘acct_1234’) | |
| connected_account_name | Human-readable name of the connected account | |
| dispute_id | ID of the dispute that this fee is associated with | |
| fee_category | ‘network_cost’ or ‘platform_fee’. | |
| fee_currency | Currency of the ‘card_scheme_fee’, ‘interchange_or_discount_fee’, and ‘non_transactional_card_scheme_fee’. | |
| fee_incurred | Time at which the fee was incurred. Measured in seconds since the Unix epoch | |
| interchange_or_discount_fee | Interchange or discount fee amount incurred. | |
| invoice_created | Time at which the invoice was created. Measured in seconds since the Unix epoch. Null for net-settled rows. | |
| invoice_id | Invoice number of the multiparty invoice that settled this fee (gross settlement only). Null for net-settled rows. | |
| issuing_bank | The bank that issued the card that this fee was incurred for. | |
| non_transactional_card_scheme_fee | Non transactional scheme fee amount incurred. | |
| platform_application_fee | Platform application fee incurred, currency specified by ‘billing_currency’. | |
| platform_id | ID of the platform account. (For example, ‘acct_1234’) | |
| platform_transfer_id | ID of the transfer or payment object that credited or debited the network costs from the platform account’s balance. (For example, ‘tr_1234’ or ‘py_1234’) | |
| refund_id | ID of the refund that this fee is associated with | |
| source_transaction_id | ID of the original charge that this fee is associated with. For Direct charges, this is the same as ‘charge_id’. For Destination charges, it is the underlying charge settling on the platform account. (For example, ‘ch_1234’) | |
| transfer_created | Time at which the transfer was created. Measured in seconds since the Unix epoch | |
| transfer_id | ID of the transfer or payment object that credited or debited the network costs from the connected account’s balance. (For example, ‘tr_1234’ or ‘py_1234’) |