# Stripe: Balance Change From Activity Itemized 3 ## Description * Modeled after the [titular report](https://stripe.com/docs/reports/balance#schema-balance-change-from-activity-itemized-3) from Stripe, each record represents a balance transaction and additional details such as associated customer, charge, refund, card, and invoice information. This class of Balance reports is similar to a bank statement, helping you to reconcile your Stripe balance at the end of the month. The Balance report is most useful if you treat Stripe like a bank account for accounting purposes, reconciling the balance at the end of each month. If you have automatic payouts enabled and prefer to reconcile the transactions settled in each payout, see the Payout reconciliation report instead. The Balance Change from Activity reports provides a more detailed breakdown of your transactions by reporting category. This section includes all transactions except for payouts that affect your balance, including charges, refunds, disputes, other adjustments, and fees. ## Supported Data Sources * Stripe ## Columns | Type | Name | Description | | -------- | ----------------------------------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | STRING | balance\_transaction\_id | Unique identifier for the balance transaction. | | DATETIME | created | Time at which the balance transaction was created. Dates in the requested timezone, or UTC if not provided. | | DATETIME | available\_on | The date the balance transaction’s net funds will become available in the Stripe balance. Dates in the requested timezone, or UTC if not provided. | | STRING | currency | Three-letter ISO code for the currency in which gross, fee and net are defined. | | INTEGER | gross | Gross amount of the transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | | INTEGER | fee | Fees paid for this transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | | INTEGER | net | Net amount of the transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). | | STRING | reporting\_category | Reporting Category is a new categorization of balance transactions, meant to improve on the current type field. | | STRING | source\_id | The Stripe object to which this transaction is related. | | STRING | description | An arbitrary string attached to the balance transaction. Often useful for displaying to users. | | INTEGER | customer\_facing\_amount | For transactions associated with charges, refunds, or disputes, the amount of the original charge, refund, or dispute. If the customer was charged in a different currency than your account’s default, this field will reflect the amount as seen by the customer. | | STRING | customer\_facing\_currency | For transactions associated with charges, refunds, or disputes, the three-letter ISO currency code for customer\_facing\_amount. | | STRING | automatic\_payout\_id | ID of the automatically created payout associated with this balance transaction (only set if your account is on an automatic payout schedule). | | DATETIME | automatic\_payout\_effective\_at | The date we expect this automatic payout to arrive in your bank account, in the requested timezone, or UTC if not provided. This is also when the paid-out funds are deducted from your Stripe balance. | | STRING | customer\_id | The unique ID of the related customer, if any. | | STRING | customer\_email | Email address of the customer, if any, associated with this balance transaction. | | STRING | customer\_name | Name of the customer, if any, associated with this balance transaction. | | STRING | customer\_description | Description provided when creating the customer, often used to store the customer name. | | STRING | customer\_shipping\_address\_line\_1 | First line of the customer shipping address associated with this charge, if any | | STRING | customer\_shipping\_address\_line\_2 | Second line of the customer shipping address associated with this charge, if any | | STRING | customer\_shipping\_address\_city | City of the customer shipping address associated with this charge, if any | | STRING | customer\_shipping\_address\_state | State of the customer shipping address associated with this charge, if any | | STRING | customer\_shipping\_address\_postal\_code | Postal code of the customer shipping address associated with this charge, if any | | STRING | customer\_shipping\_address\_country | Country of the customer shipping address associated with this charge, if any | | STRING | customer\_address\_line\_1 | First line of the customer address associated with this charge, if any | | STRING | customer\_address\_line\_2 | Second line of the customer address associated with this charge, if any | | STRING | customer\_address\_city | City of the customer address associated with this charge, if any | | STRING | customer\_address\_state | State of the customer address associated with this charge, if any | | STRING | customer\_address\_postal\_code | Postal code of the customer address associated with this charge, if any | | STRING | customer\_address\_country | Country of the customer address associated with this charge, if any | | STRING | shipping\_address\_line\_1 | First line of the shipping address associated with this charge, if any | | STRING | shipping\_address\_line\_2 | Second line of the shipping address associated with this charge, if any | | STRING | shipping\_address\_city | City of the shipping address associated with this charge, if any | | STRING | shipping\_address\_state | State of the shipping address associated with this charge, if any | | STRING | shipping\_address\_postal\_code | Postal code of the shipping address associated with this charge, if any | | STRING | shipping\_address\_country | Country of the shipping address associated with this charge, if any | | STRING | card\_address\_line\_1 | First line of the card address associated with this charge, if any | | STRING | card\_address\_line\_2 | Second line of the card address associated with this charge, if any | | STRING | card\_address\_city | City of the card address associated with this charge, if any | | STRING | card\_address\_state | State of the card address associated with this charge, if any | | STRING | card\_address\_postal\_code | Postal code of the card address associated with this charge, if any | | STRING | card\_address\_country | Country of the card address associated with this charge, if any | | STRING | charge\_id | Unique identifier for the original charge associated with this balance transaction. Available for charges, refunds and disputes. | | STRING | payment\_intent\_id | The unique ID of the related Payment Intent, if any. | | DATETIME | charge\_created | Creation time of the original charge associated with this balance transaction. Available for charges, refunds and disputes. For charges that were separately authorized and captured, this is the authorization time. Dates in the requested timezone, or UTC if not provided. | | STRING | invoice\_id | Unique ID for the invoice associated with this balance transaction. Available for charges, refunds, and disputes made in connection with a Stripe Billing invoice. | | STRING | invoice\_number | Number for the invoice associated with this balance transaction. Available for charges, refunds, and disputes made in connection with a Stripe Billing invoice. | | STRING | subscription\_id | Unique ID for the subscription associated with this balance transaction. Available for charges, refunds, and disputes made in connection with a Stripe Billing subscription. | | STRING | payment\_method\_type | The type of payment method used in the related payment. | | STRING | card\_brand | Card brand, if applicable. | | STRING | card\_funding | Card funding type, if applicable. | | STRING | card\_country | Two-letter ISO code representing the country of the card. | | STRING | statement\_descriptor | The dynamic statement descriptor or suffix specified when the related charge was created. | | STRING | dispute\_reason | Reason given by cardholder for dispute. Read more about dispute reasons. | | STRING | connected\_account\_id | For Stripe Connect activity related to a connected account, the unique ID for the account. | | STRING | connected\_account\_country | For Stripe Connect activity related to a connected account, the two-letter ISO code representing the country of the account. | | STRING | connected\_account\_direct\_charge\_id | (Beta) For Stripe Connect activity related to a connected account, charge id of the direct charge that happened on connected account. | | STRING | source\_relation | The source where this data was pulled from. If you are making use of the `union_schemas` variable, this will be the source schema. If you are making use of the `union_databases` variable, this will be the source database. If you are not unioning together multiple sources, this will be an empty string. | --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://endash-guidance-docs.gitbook.io/cigro-data-templates/data-model-templates/stripe-balance-change-from-activity-itemized-3.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.