提现对账报告
将每笔提现与它结算的交易批次进行核对。
提现对账报告可帮助您将银行账户中收到的提现与和其相关的付款批次及其他交易进行匹配。
提现对账报告仅可由启用了自动提现的用户使用,并为喜欢将每笔提现包含的交易作为结算批次进行核对的用户进行了优化。如果您使用手动提现,或者喜欢像银行账户那样跟踪并核对您的 Stripe 余额,请改为参考余额报告。为帮助您确定哪个报告适合您,请查看报告选择指南。
要开始使用,请用屏幕顶部的控件选择日期范围。
余额摘要部分显示了您在所选日期范围内的 Stripe 起始和结束余额,以及您在此期间的高级活动摘要。
提现对账部分提供选定日期范围内您的银行账户收到的自动提现的明细。这些结算批次内包含的交易按照报告类别进行分类。
期末余额对账部分提供了截至报告结束日期之前尚未结算的交易的类似明细。
下载数据
您可以以 CSV 格式下载报告各部分显示的数据,方式是点击那个部分右上角的下载按钮。提现对账和期末余额对账部分允许您下载多种类型的报告:
- 摘要:这将以 CSV 格式下载数据,与您在管理平台中看到的完全相同。
- 分项:这将下载管理平台中汇总的个别交易的完整列表。您可以包含与这些交易关联的自定义元数据,以加快对账过程。
此外,您可以通过将鼠标悬停在某个交易类别上并点击出现的下载按钮,快速下载该类别的分项数据。
可用列
在管理平台中或通过 Reporting API下载报告时,您可以自定义报告中出现的列。下面是对各类型报告中可用列的描述。
- Balance summary
- Payouts reconciliation summary
- Itemized payout reconciliation
- Ending balance reconciliation summary
- Itemized ending balance reconciliation
Balance summary
API 报告类型:balance.
列名 | 默认 | 描述 |
---|---|---|
category | One of | |
currency | Three-letter ISO code for the currency in which | |
description | One of | |
net_amount | Net amount for the transactions associated with |
Payouts reconciliation summary
API 报告类型:payout_
列名 | 默认 | 描述 |
---|---|---|
count | The number of transactions associated with the | |
currency | Three-letter ISO code for the currency in which | |
fee | Sum of the fees paid for the transactions associated with the | |
gross | Sum of the gross amounts of the transactions associated with the | |
net | Sum of the net amounts for the transactions associated with the | |
reporting_category | Reporting Category is a new categorization of balance transactions, meant to improve on the current |
Itemized payout reconciliation
API 报告类型:payout_
列名 | 默认 | 描述 |
---|---|---|
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 | |
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_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 | |
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
API 报告类型:ending_
列名 | 默认 | 描述 |
---|---|---|
count | The number of transactions associated with the | |
currency | Three-letter ISO code for the currency in which | |
fee | Sum of the fees paid for the transactions associated with the | |
gross | Sum of the gross amounts of the transactions associated with the | |
net | Sum of the net amounts for the transactions associated with the | |
reporting_category | Reporting Category is a new categorization of balance transactions, meant to improve on the current |
Itemized ending balance reconciliation
API 报告类型:ending_
列名 | 默认 | 描述 |
---|---|---|
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 | |
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_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 | |
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. |