ItemizedEndingBalanceReconciliationReport

Columns

Name

Type

References

Description

Balance_Transaction_Id

String

Unique identifier for the balance transaction.

Created_UTC

Datetime

Time at which the balance transaction was created. Dates in UTC.

Created

Datetime

Time at which the balance transaction was created. Dates in the requested timezone, or UTC if not provided.

Available_On_UTC

Datetime

The date the balance transactions net funds will become available in the Stripe balance. Dates in UTC.

Available_On

Datetime

The date the balance transactions net funds will become available in the Stripe balance. Dates in the requested timezone, or UTC if not provided.

Currency

String

Three-letter ISO code for the currency in which gross, fee and net are defined.

Gross

Decimal

Gross amount of the transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY).

Fee

Decimal

Fees paid for this transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY).

Net

Decimal

Net amount of the transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY).

Reporting_Category

String

Reporting Category is a new categorization of balance transactions, meant to improve on the current type field.

Source_Id

String

The Stripe object to which this transaction is related.

Description

String

An arbitrary string attached to the balance transaction. Often useful for displaying to users.

Customer_Facing_Amount

Decimal

For transactions associated with charges or refunds, the amount of the original charge or refund.

Customer_Facing_Currency

String

For transactions associated with charges or refunds, the three-letter ISO code for the currency for customer_facing_amount.

Automatic_Payout_Id

String

ID of the automatically created payout associated with this balance transaction (only set if your account is on an automatic payout schedule).

Automatic_Payout_Effective_At_UTC

Datetime

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_Effective_At

Datetime

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.

Customer_Id

String

The unique ID of the related customer, if any.

Customer_Email

String

Email address of the customer, if any, associated with this balance transaction.

Customer_Name

String

Name of the customer, if any, associated with this balance transaction.

Customer_Description

String

Description provided when creating the customer, often used to store the customer name.

Shipping_Address_Line1

String

First line of the shipping address associated with this charge, if any

Shipping_Address_Line2

String

Second line of the shipping address associated with this charge, if any

Shipping_Address_City

String

City of the shipping address associated with this charge, if any

Shipping_Address_State

String

State of the shipping address associated with this charge, if any

Shipping_Address_Postal_Code

String

Postal code of the shipping address associated with this charge, if any

Shipping_Address_Country

String

Country of the shipping address associated with this charge, if any

Charge_Id

String

Unique identifier for the original charge associated with this balance transaction. Available for charges, refunds and disputes.

Payment_Intent_Id

String

The unique ID of the related Payment Intent, if any.

Charge_Created_UTC

Datetime

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_Created

Datetime

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.

Invoice_Id

String

Unique ID for the invoice associated with this balance transaction. Available for charges, refunds, and disputes made in connection with a Stripe Billing invoice.

Subscription_Id

String

Unique ID for the subscription associated with this balance transaction. Available for charges, refunds, and disputes made in connection with a Stripe Billing subscription.

Payment_Method_Type

String

The type of payment method used in the related payment.

Card_Brand

String

Card brand, if applicable.

Card_Funding

String

Card funding type, if applicable.

Card_Country

String

Two-letter ISO code representing the country of the card.

Statement_Descriptor

String

The dynamic statement descriptor or suffix specified when the related charge was created.

Dispute_Reason

String

Reason given by cardholder for dispute.

Connected_Account_Id

String

For Stripe Connect activity related to a connected account, the unique ID for the account.

Connected_Account_Name

String

For Stripe Connect activity related to a connected account, the name of the account.

Connected_Account_Country

String

For Stripe Connect activity related to a connected account, the two-letter ISO code representing the country of the account.

Id

String

Reports.Id

Unique identifier for the reports run object.

ParametersIntervalEnd

Datetime

Ending timestamp of data to be included in the report run (exclusive).

ParametersColumns

String

The set of output columns requested for inclusion in the report run.

ParametersCurrency

String

Currency of objects to be included in the report run.

ParametersReportingCategory

String

Category of balance transactions to be included in the report run.

ParametersTimezone

String

Defaults to Etc/UTC. The output timezone for all timestamps in the report.

Last updated