Reports
Payout reconciliation

Payout reconciliation report

Reconcile each payout with the batch of transactions it settles.

The Payout reconciliation report helps you match the payouts you receive in your bank account with the batches of payments and other transactions that they relate to.

The payout reconciliation report is only available for users with automatic payouts enabled, and is optimized for users who prefer to reconcile the transactions included in each payout as a settlement batch. If you use manual payouts or prefer to track and reconcile your Stripe balance like a bank account, see the Balance report instead. Not sure? Check out our guide to choosing the right report.

To get started, use the controls at the top of the screen to select a date range.

The Balance summary section shows your starting and ending Stripe balance for the selected date range, along with a high level summary of your activity during the period.

The Payout reconciliation section provides a breakdown of the automatic payouts that were received in your bank account during the selected date range. The transactions included in those settlement batches are grouped by reporting category.

The Ending balance reconciliation section provides a similar breakdown of the transactions that hadn’t been settled as of the report’s end date.

Downloading data

You can download the data displayed in each section of the report as a CSV file by clicking the Download button in the upper right corner of that section. The Payout reconciliation and Ending balance reconciliation sections allow you to download multiple types of reports:

  • Summary: This downloads data in CSV format exactly as you see it in the dashboard.
  • Itemized: This downloads the full list of individual transactions that are summarized in the dashboard.

In addition, you can quickly download itemized data for a single category of transactions by hovering over that category and clicking the Download button that appears.

Available columns

You can customize the columns that appear in the reports when downloading them in the dashboard or via the Reporting API. The available columns in each type of report are described below.

Balance summary

API report type: balance.summary.1

Column name Default Description
category

One of starting_balance, ending_balance, activity or payouts.

description

One of Starting balance (YYYY-MM-DD) - the balance at the start of the period, Activity - the net amount of all transactions that affected your balance except for payouts, Less payouts - the amount of payouts to your bank account, or Ending balance (YYYY-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).

currency

Three-letter ISO code for the currency in which net_amount is defined.

Payouts reconciliation summary

API report type: payout_reconciliation.summary.1

Column name Default Description
reporting_category

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

currency

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

count

The number of transactions associated with the reporting_category.

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).

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).

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).

Itemized payout reconciliation

API report type: payout_reconciliation.itemized.4

Column name Default Description
balance_transaction_id

Unique identifier for the balance transaction.

created_utc

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

created

Time at which the balance transaction was created. 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.

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.

currency

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

gross

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

fee

Fees paid for this 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).

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.

description

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

customer_facing_amount

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

customer_facing_currency

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

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).

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_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.

customer_id

The unique ID of the related customer, if any.

customer_email

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

customer_name

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

customer_description

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

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_city

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

shipping_address_state

State 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_country

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

charge_id

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

payment_intent_id

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

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_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.

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.

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.

payment_method_type

The type of payment method used in the related payment.

card_brand

Card brand, if applicable.

card_funding

Card funding type, if applicable.

card_country

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

statement_descriptor

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

connected_account_id

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

connected_account_name

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

connected_account_country

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

Ending balance reconciliation summary

API report type: ending_balance_reconciliation.summary.1

Column name Default Description
reporting_category

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

currency

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

count

The number of transactions associated with the reporting_category.

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).

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).

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).

Itemized ending balance reconciliation

API report type: ending_balance_reconciliation.itemized.3

Column name Default Description
balance_transaction_id

Unique identifier for the balance transaction.

created_utc

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

created

Time at which the balance transaction was created. 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.

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.

currency

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

gross

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

fee

Fees paid for this 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).

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.

description

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

customer_facing_amount

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

customer_facing_currency

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

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).

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_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.

customer_id

The unique ID of the related customer, if any.

customer_email

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

customer_name

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

customer_description

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

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_city

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

shipping_address_state

State 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_country

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

charge_id

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

payment_intent_id

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

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_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.

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.

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.

payment_method_type

The type of payment method used in the related payment.

card_brand

Card brand, if applicable.

card_funding

Card funding type, if applicable.

card_country

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

statement_descriptor

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

connected_account_id

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

connected_account_name

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

connected_account_country

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

Was this page helpful?
Questions? Contact us.
Developer tutorials on YouTube.