# Bericht zum Auszahlungsabgleich

Gleichen Sie jede Auszahlung mit dem durch sie abgerechneten Transaktionsbatch ab.

Sie können den [Auszahlungsabgleich auch über die API durchführen](https://docs.stripe.com/payouts/reconciliation.md).

Mit dem Bericht zum [Auszahlungsabgleich](https://dashboard.stripe.com/reports/reconciliation) können Sie auf Ihrem Bankkonto eingegangene Auszahlungen mit den Batches aus Zahlungen und sonstigen zugehörigen Transaktionen abgleichen.

Der Bericht zum Auszahlungsabgleich ist nur für Nutzerinnen und Nutzer verfügbar, die [**automatische Auszahlungen** aktiviert haben](https://dashboard.stripe.com/settings/settlement), oder für eine Plattform mit manuellen Auszahlungen, deren verbundene Konten automatische Auszahlungen aktiviert haben. Er ist für Nutzerinnen und Nutzer optimiert, die es vorziehen, die in jeder Auszahlung enthaltenen [Transaktionen](https://support.stripe.com/questions/find-what-transactions-were-included-in-or-impacted-a-payout-amount) als Zahlungsabwicklungsstapel abzugleichen. Wenn Sie manuelle Auszahlungen verwenden (und keine Plattform sind, deren verbundene Konten automatische Auszahlungen aktiviert haben) oder es vorziehen, Ihr Stripe-Guthaben wie ein Bankkonto nachzuverfolgen und abzugleichen, sehen Sie sich stattdessen den Bericht [Saldo](https://docs.stripe.com/reports/balance.md) an. Um Ihnen bei der Entscheidung zu helfen, welcher Bericht für Sie der richtige ist, lesen Sie den [Leitfaden zur Auswahl von Berichten](https://docs.stripe.com/reports/select-a-report.md#reconciliation).

> Sie steuern den Zeitpunkt und die Höhe der manuellen Auszahlungen, sodass Stripe nicht erkennen kann, welche Transaktionen in jeder Auszahlung enthalten sind. Sie sind dafür verantwortlich, die von Ihnen erstellten Auszahlungen mit Ihrem Transaktionsverlauf abzugleichen.

So finden Sie die in einer Auszahlung enthaltenen Transaktionen:

1. Öffnen Sie den [Bericht zum Auszahlungsabgleich](https://dashboard.stripe.com/reports/reconciliation).
2. Verwenden Sie die [Steuerelemente](https://docs.stripe.com/reports/options.md), um einen Datumsbereich auszuwählen, der das voraussichtliche Eingangsdatum der Auszahlung enthält. Wenn Sie sich bezüglich des Datums nicht sicher sind, erweitern Sie den Bereich. Weitere Informationen finden Sie unter [Auszahlungsablauf und Verfügbarkeit von Berichten](https://docs.stripe.com/reports/payout-reconciliation.md#payout-timing-and-report-availability).
3. Suchen Sie die Auszahlung im Bereich **Auszahlungsabgleich**.
4. Laden Sie die **aufgeschlüsselte** CSV-Datei herunter, um alle in der Auszahlung enthaltenen Zahlungen, Rückerstattungen, Streitfälle, Gebühren und sonstigen Saldo-Transaktionen zu überprüfen.

Der Abschnitt **Saldenübersicht** zeigt den Anfangs- und den Abschlusssaldo Ihres Stripe-Kontos für den ausgewählten Datumsbereich sowie eine allgemeine Zusammenfassung Ihrer Aktivitäten in diesem Zeitraum.

Der Abschnitt **Auszahlungsabgleich** bietet eine Aufschlüsselung der automatischen Auszahlungen in dem ausgewählten Datumsbereich. Die in jeder Auszahlung enthaltenen [Transaktionen](https://support.stripe.com/questions/find-what-transactions-were-included-in-or-impacted-a-payout-amount) werden nach [Berichtskategorie](https://docs.stripe.com/reports/reporting-categories.md) gruppiert, wie etwa Abbuchungen, Rückerstattungen und Gebühren.

Der Abschnitt **Fehlgeschlagene Auszahlungen** enthält eine Aufschlüsselung der fehlgeschlagenen automatischen Auszahlungen, falls vorhanden. Dieser Bereich ist nur sichtbar, wenn im ausgewählten Zeitraum fehlgeschlagene automatische Auszahlungen auftreten.

Der Abschnitt **Abschlusssaldenabgleich** zeigt eine ähnliche Aufschlüsselung von Transaktionen, die zum Zeitpunkt des Enddatums des Berichts nicht abgerechnet worden waren.

## Berichtsdaten herunterladen

Klicken Sie in der oberen rechten Ecke eines Berichtsabschnitts auf **Download**. Die Abschnitte **Auszahlungsabgleich** und **Abgleichung des Endguthabens** bieten diese Berichtsformate:

- **Zusammenfassung**: Lädt die im Dashboard angezeigten Gesamtbeträge herunter.
- **Aufgeschlüsselt**: Lädt jede Transaktion herunter, die in diesen Gesamtbeträgen enthalten ist. Bei CSV-Exporten können Sie [benutzerdefinierte Metadaten](https://docs.stripe.com/reports/metadata.md) einbeziehen, um Stripe-Transaktionen mit Datensätzen in Ihrem Buchhaltungssystem abzugleichen.

Der CSV-Export ist für alle Konten verfügbar. Wenn das Download-Dialogfeld für Ihr Konto eine Dateiformatauswahl enthält, können Sie **PDF** auswählen, **Zusammenfassung** oder **Aufgeschlüsselt** wählen und auf **Download** klicken. Aufgeschlüsselte Exporte im PDF-Format umfassen bis zu 5.000 Zeilen. Wenn im Dialogfeld nicht **PDF** angezeigt wird, verwenden Sie einen CSV-Export.

Um aufgeschlüsselte CSV-Daten für eine Transaktionskategorie herunterzuladen, bewegen Sie den Mauszeiger über die Kategorie und klicken Sie auf **Download**.

## Aufschlüsselung der Aktivitäten

Im Dashboard können Sie Daten wie zusammenfassende Gesamtbeträge und Einzelheiten zu einzelnen Transaktionen einsehen. Klicken Sie auf die Beträge in den Abschnitten **Payout reconciliation** und **Ending balance reconciliation**, um die zugrunde liegenden Transaktionen zu überprüfen. Diese Funktion steht nur zur Verfügung, wenn eine Connect-Plattform Berichte für ihr eigenes Plattformkonto aufruft; sie ist nicht verfügbar für Berichte, deren Geltungsbereich auf verbundene Konten beschränkt ist. Erfahren Sie mehr über die [Aufschlüsselung der Aktivitäten](https://docs.stripe.com/reports/activity-breakdown.md).

## Auszahlungsablauf und Verfügbarkeit von Berichten

Der Bericht gruppiert eine Auszahlung nach dem voraussichtlichen Eingangsdatum, das auf der [Auszahlungsseite](https://dashboard.stripe.com/payouts) angezeigt wird, nicht nach dem Datum, an dem Ihre Bank die Einzahlung verbucht. Verwenden Sie das voraussichtliche Eingangsdatum, wenn Sie den Datumsbereich des Berichts auswählen. Der Auszahlungsplan bestimmt, wann Stripe Gelder an Ihre Bank überweist, und Wochenenden, Feiertage sowie die Verarbeitungszeiten der Bank können Auswirkungen darauf haben, wann die Gelder eingehen. Erfahren Sie mehr über [Auszahlungspläne und -ablauf](https://docs.stripe.com/payouts.md#payout-schedule).

Berichtsdaten folgen einem separaten Verarbeitungszeitplan, sodass eine Auszahlung möglicherweise eingeht, bevor die entsprechenden Abgleichsdaten bereit sind. Weitere Informationen zu Verarbeitungszeiten und Ausnahmen finden Sie unter [Verfügbarkeit von Berichtsdaten](https://docs.stripe.com/reports/options.md#data-availability).

Sie können Berichte für einen Teiltag über die [Reporting API](https://docs.stripe.com/reports/api.md) anfordern, Berichte im Stripe-Dashboard decken jedoch immer einen vollständigen Tag ab.

Bei API-Integrationen sendet Stripe `reporting.report_type.updated`-Webhook-Ereignisse, sobald neue Berichtsdaten verfügbar sind. Erfahren Sie mehr über [Integrationsmuster für die Reporting API](https://docs.stripe.com/reports/v1-api.md#integration-pattern).

## Geplante Berichte

Informationen zum Einrichten eines Abonnementplans für Berichte und zum Erhalten von Benachrichtigungen über neue Daten finden Sie unter [geplante Berichte](https://docs.stripe.com/reports/options.md#scheduled-reports).

## Verfügbare Spalten

Sie können die Spalten anpassen, die in den Berichten beim Herunterladen im Dashboard oder über die [Reporting API](https://docs.stripe.com/reports/api.md) angezeigt werden. Die für die einzelnen Berichtsarten verfügbaren Spalten werden nachfolgend beschrieben.

### Balance Summary

API report type: 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](https://stripe.com/docs/currencies) in which `net_amount` is defined. |
| 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, `Total 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). |

### Payouts reconciliation summary

API report type: 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](https://stripe.com/docs/currencies) 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](https://stripe.com/docs/reporting/reporting-categories) is a new categorization of balance transactions, meant to improve on the current `type` field. |

### Itemized payout reconciliation

API report type: payout_reconciliation.itemized.7

| Column name | Default | Description |
| --- | --- | --- |
| automatic_payout_effective_at | ✓ | The date we expect this [automatic payout](https://stripe.com/docs/payouts#payout-schedule) to arrive in your bank account, in the requested time zone, 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](https://stripe.com/docs/payouts#payout-schedule) 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](https://stripe.com/docs/payouts#payout-schedule)). |
| available_on | ✓ | The date the balance transaction's net funds will become available in the Stripe balance. Dates in the requested time zone, 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](https://stripe.com/docs/api#card_object-brand), if applicable. |
| card_country |  | Two-letter ISO code representing the country of the card. |
| card_funding |  | Card [funding type](https://stripe.com/docs/api#account_card_object-funding), 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 time zone, 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_country |  | For Stripe Connect activity related to a connected account, the two-letter ISO code representing the country of the account. |
| connected_account_direct_charge_id |  | For Stripe Connect activity related to a connected account, charge id of the direct charge that happened on connected account. |
| 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. |
| created | ✓ | Time at which the balance transaction was created. Dates in the requested time zone, 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](https://stripe.com/docs/currencies) 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](https://stripe.com/docs/currencies) 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. |
| destination_payment_id |  | Destination payment id in the case of Separate Charges & Transfers and destination charges |
| dispute_reason |  | Reason given by cardholder for dispute. Read more about [dispute reasons](https://stripe.com/docs/disputes/categories). |
| fee | ✓ | Fees paid for this transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). |
| fee_net_of_withheld_tax |  | The Stripe processing fee after removing withheld tax. Calculated as fee minus withheld_tax — represents Stripe's actual processing charge excluding any tax withheld. |
| 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. |
| is_managed_payments |  | Whether this transaction was processed through Stripe Managed Payments. True when the charge was handled via Stripe Managed Payments, regardless of whether any tax was withheld. |
| net | ✓ | Net amount of the transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). |
| order_id |  | Unique ID for the order associated with this balance transaction. |
| 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](https://stripe.com/docs/reporting/reporting-categories) 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](https://stripe.com/docs/payouts/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. |
| withheld_tax |  | Sales tax, VAT or GST withheld. This amount is already included within the fee column. |

### Failed payouts summary

API report type: 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](https://stripe.com/docs/currencies) 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](https://stripe.com/docs/reporting/reporting-categories) is a new categorization of balance transactions, meant to improve on the current `type` field. |

### Itemized failed payouts

API report type: failed_payouts.itemized.2

| Column name | Default | Description |
| --- | --- | --- |
| automatic_payout_effective_at | ✓ | The date we expect this [automatic payout](https://stripe.com/docs/payouts#payout-schedule) to arrive in your bank account, in the requested time zone, 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](https://stripe.com/docs/payouts#payout-schedule) 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](https://stripe.com/docs/payouts#payout-schedule)). |
| available_on | ✓ | The date the balance transaction's net funds will become available in the Stripe balance. Dates in the requested time zone, 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](https://stripe.com/docs/api#card_object-brand), if applicable. |
| card_country |  | Two-letter ISO code representing the country of the card. |
| card_funding |  | Card [funding type](https://stripe.com/docs/api#account_card_object-funding), 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 time zone, 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_country |  | For Stripe Connect activity related to a connected account, the two-letter ISO code representing the country of the account. |
| connected_account_direct_charge_id |  | For Stripe Connect activity related to a connected account, charge id of the direct charge that happened on connected account. |
| 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. |
| created | ✓ | Time at which the balance transaction was created. Dates in the requested time zone, 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](https://stripe.com/docs/currencies) 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](https://stripe.com/docs/currencies) 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. |
| destination_payment_id |  | Destination payment id in the case of Separate Charges & Transfers and destination charges |
| dispute_reason |  | Reason given by cardholder for dispute. Read more about [dispute reasons](https://stripe.com/docs/disputes/categories). |
| 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). |
| order_id |  | Unique ID for the order associated with this balance transaction. |
| 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](https://stripe.com/docs/reporting/reporting-categories) 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. |
| 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](https://stripe.com/docs/payouts/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. |

### Ending balance reconciliation summary

API report type: 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](https://stripe.com/docs/currencies) 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](https://stripe.com/docs/reporting/reporting-categories) is a new categorization of balance transactions, meant to improve on the current `type` field. |

### Itemized ending balance reconciliation

API report type: ending_balance_reconciliation.itemized.4

| Column name | Default | Description |
| --- | --- | --- |
| automatic_payout_effective_at | ✓ | The date we expect this [automatic payout](https://stripe.com/docs/payouts#payout-schedule) 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](https://stripe.com/docs/payouts#payout-schedule) 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](https://stripe.com/docs/payouts#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](https://stripe.com/docs/api#card_object-brand), if applicable. |
| card_country |  | Two-letter ISO code representing the country of the card. |
| card_funding |  | Card [funding type](https://stripe.com/docs/api#account_card_object-funding), 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_country |  | For Stripe Connect activity related to a connected account, the two-letter ISO code representing the country of the account. |
| connected_account_direct_charge_id |  | For Stripe Connect activity related to a connected account, charge id of the direct charge that happened on connected account. |
| 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. |
| 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](https://stripe.com/docs/currencies) 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](https://stripe.com/docs/currencies) 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](https://stripe.com/docs/disputes/categories). |
| fee | ✓ | Fees paid for this transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY). |
| fee_net_of_withheld_tax |  | The Stripe processing fee after removing withheld tax. Calculated as fee minus withheld_tax — represents Stripe's actual processing charge excluding any tax withheld. |
| 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](https://stripe.com/docs/reporting/reporting-categories) 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](https://stripe.com/docs/payouts/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. |
| withheld_tax |  | Sales tax, VAT or GST withheld. This amount is already included within the fee column. |

### Zusätzliche Spalten

Die detaillierten Berichte, die Sie vom Dashboard herunterladen können, enthalten die folgenden zusätzlichen Spalten:

### Zusätzliche Spalten für detaillierte Berichte

- **Produkt-IDs**: Die eindeutigen Kennungen der mit der Transaktion verbundenen Produkte.
- **Produktnamen**: Die Namen der mit der Transaktion verbundenen Produkte.
- **Land**: Das mit der Transaktion verbundene Land. Bei Kartenzahlungen ist dies das Ausstellungsland der Karte oder das Land der Rechnungsadresse. Bei lokalen Zahlungsmethoden wird dies aus der Art der Zahlungsmethode abgeleitet. Bei Zahlungsmethoden für mehrere Regionen wie SEPA oder PayPal wird standardmäßig das Land Ihres Kontos verwendet.

## See also

- [FAQ zu Auszahlungsplänen](https://support.stripe.com/questions/payout-schedules-faq)
- [FAQ zu Auszahlungen](https://support.stripe.com/questions/payouts-faq)