提现对账报告
提现对账报告可帮助您将银行账户中收到的提现与和其相关的付款批次及其他交易进行匹配。
提现对账报告仅可由启用了自动提现的用户使用,并为喜欢将每笔提现包含的交易作为结算批次进行核对的用户进行了优化。如果您使用手动提现,或者喜欢像银行账户那样跟踪并核对您的 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.summary.1
列名 | 默认 | 描述 |
---|---|---|
category | One of | |
description | One of | |
net_amount | Net amount for the transactions associated with | |
currency | Three-letter ISO code for the currency in which |
Payouts reconciliation summary
API 报告类型:payout_reconciliation.summary.1
列名 | 默认 | 描述 |
---|---|---|
reporting_category | Reporting Category is a new categorization of balance transactions, meant to improve on the current | |
currency | Three-letter ISO code for the currency in which | |
count | The number of transactions associated with the | |
gross | Sum of the gross amounts of the transactions associated with the | |
fee | Sum of the fees paid for the transactions associated with the | |
net | Sum of the net amounts for the transactions associated with the |
Itemized payout reconciliation
API 报告类型:payout_reconciliation.itemized.5
列名 | 默认 | 描述 |
---|---|---|
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 | 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. | |
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 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. | |
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. | |
currency | Three-letter ISO code for the currency in which | |
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 | |
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, 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 | |
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. | |
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. | |
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. | |
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_city | City 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 | |
customer_shipping_address_postal_code | Postal code 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_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_city | City 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_address_postal_code | Postal code of the customer address associated with this charge, if any | |
customer_address_country | Country of the customer 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_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 | |
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_city | City 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_address_postal_code | Postal code of the card address associated with this charge, if any | |
card_address_country | Country of the card 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 time zone, 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. | |
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. | |
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. | |
order_id | Unique ID for the order associated with this balance transaction. | |
payment_method_type | The type of payment method used in the related payment. | |
is_link | Whether or not the payment was made using Link. | |
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. | |
dispute_reason | Reason given by cardholder for dispute. Read more about dispute reasons. | |
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. | |
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. | |
destination_payment_id | Destination payment id in the case of Separate Charges & Transfers and destination charges | |
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. | |
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. | |
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_balance_reconciliation.summary.1
列名 | 默认 | 描述 |
---|---|---|
reporting_category | Reporting Category is a new categorization of balance transactions, meant to improve on the current | |
currency | Three-letter ISO code for the currency in which | |
count | The number of transactions associated with the | |
gross | Sum of the gross amounts of the transactions associated with the | |
fee | Sum of the fees paid for the transactions associated with the | |
net | Sum of the net amounts for the transactions associated with the |
Itemized ending balance reconciliation
API 报告类型:ending_balance_reconciliation.itemized.4
列名 | 默认 | 描述 |
---|---|---|
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 | 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. | |
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 | 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 | |
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, 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 | |
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. | |
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. | |
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. | |
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_city | City 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 | |
customer_shipping_address_postal_code | Postal code 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_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_city | City 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_address_postal_code | Postal code of the customer address associated with this charge, if any | |
customer_address_country | Country of the customer 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_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 | |
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_city | City 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_address_postal_code | Postal code of the card address associated with this charge, if any | |
card_address_country | Country of the card 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. | |
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. | |
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. | |
is_link | Whether or not the payment was made using Link. | |
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. | |
dispute_reason | Reason given by cardholder for dispute. Read more about dispute reasons. | |
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. | |
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. | |
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. | |
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. | |
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. |