Rapport de rapprochement des virements

Effectuez le rapprochement entre chaque virement et chaque lot de transactions correspondant.

Le rapport de rapprochement des virements vous aide à faire correspondre les virements reçus sur votre compte bancaire avec les paiements et autres transactions par lots auxquels ils se rapportent.

Le rapport de rapprochement des virements est réservé aux utilisateurs pour lesquels les virements automatiques sont activés. Il est optimisé pour les utilisateurs qui préfèrent rapprocher les transactions comprises dans chaque virement sous la forme d’un règlement par lots. Si vous recourez aux virements manuels ou si vous préférez suivre et rapprocher votre solde Stripe à la manière d’un compte bancaire, consultez plutôt le rapport de solde. Pour vous aider à choisir le rapport qui vous convient, consultez le guide de sélection des rapports.

Pour commencer, sélectionnez une plage de dates à l’aide des commandes situées en haut de l’écran.

La section Récapitulatif du solde affiche votre solde Stripe aux dates de début et de fin de la plage sélectionnée, ainsi qu’une vue d’ensemble de votre activité au cours de cette période.

La section Rapprochement des virements décrit en détail les virements automatiques reçus sur votre compte bancaire au cours de la plage de dates sélectionnée. Les transactions comprises dans ces règlements par lots sont regroupées par catégorie de reporting.

La section Rapprochement du solde de clôture détaille de façon similaire les transactions qui n’ont pas encore été réglées à la date de fin du rapport.

Téléchargement des données

Vous pouvez télécharger un fichier CSV des données affichées dans chaque section du rapport, en cliquant sur le bouton Télécharger situé dans le coin supérieur droit de la section. Les sections Rapprochement des virements et Rapprochement du solde de clôture vous permettent de télécharger plusieurs types de rapports :

Récapitulatif : cette option télécharge les données au format CSV tel que vous les voyez dans le tableau de bord.
Détaillé : cette option télécharge la liste complète répertoriant chacune des transactions consolidées dans le tableau de bord. Vous pouvez inclure des métadonnées personnalisées associées à ces transactions pour accélérer le processus de rapprochement.

En outre, vous pouvez télécharger rapidement le détail des données pour une catégorie de transaction. Pour ce faire, survolez la catégorie correspondante avec votre souris et cliquez sur le bouton Télécharger qui s’affiche.

Colonnes disponibles

Vous pouvez personnaliser les colonnes apparaissant dans les rapports que vous téléchargez depuis le Dashboard ou via l’API Reporting. Découvrez ci-dessous les colonnes disponibles dans chaque type de rapport.

Balance summary
Payouts reconciliation summary
Itemized payout reconciliation
Ending balance reconciliation summary
Itemized ending balance reconciliation

Balance summary

Type de rapport d'API : balance.summary.1

Nom de colonne	Par défaut	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 (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

Type de rapport d'API : payout_reconciliation.summary.1

Nom de colonne	Par défaut	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.

Itemized payout reconciliation

Type de rapport d'API : payout_reconciliation.itemized.5

Nom de colonne	Par défaut	Description
automatic_payout_effective_at		The date we expect this automatic payout 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 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 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, 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 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		(Beta) 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 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.
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.
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 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		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

Type de rapport d'API : ending_balance_reconciliation.summary.1

Nom de colonne	Par défaut	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.

Itemized ending balance reconciliation

Type de rapport d'API : ending_balance_reconciliation.itemized.4

Nom de colonne	Par défaut	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_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		(Beta) 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 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.
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.