Laporan rekonsiliasi payout
Laporan Rekonsiliasi payout membantu Anda mencocokkan payout yang diterima di rekening bank dengan kelompok pembayaran dan transaksi lain yang terkait dengannya.
Laporan rekonsiliasi payout hanya tersedia untuk pengguna yang mengaktifkan payout otomatis, dan dioptimalkan bagi pengguna yang lebih suka merekonsiliasi transaksi yang disertakan dalam setiap payout sebagai batch penyelesaian. Jika Anda menggunakan payout manual atau lebih suka melacak serta merekonsiliasi saldo Stripe seperti rekening bank, lihat laporan Saldo sebagai gantinya. Untuk membantu memutuskan laporan mana yang tepat untuk Anda, lihat panduan untuk memilih laporan.
Untuk mulai, gunakan kontrol di bagian atas layar untuk memilih rentang tanggal.
Bagian Ringkasan saldo menunjukkan saldo Stripe awal dan akhir Anda untuk rentang tanggal yang dipilih, bersama ringkasan umum aktivitas Anda selama periode tersebut.
Bagian Rekonsiliasi payout memberikan perincian payout otomatis yang diterima di rekening bank Anda selama rentang tanggal yang dipilih. Transaksi yang termasuk dalam kelompok penyelesaian tersebut dikelompokkan menurut kategori pelaporan.
Bagian Rekonsiliasi saldo akhir memberikan perincian serupa atas transaksi yang belum diselesaikan pada tanggal akhir laporan.
Mengunduh data
Anda dapat mengunduh data yang ditampilkan di setiap bagian laporan sebagai file CSV dengan mengeklik tombol Unduh di sudut kanan atas bagian tersebut. Bagian Rekonsiliasi payout dan Rekonsiliasi saldo akhir memungkinkan Anda mengunduh beberapa tipe laporan:
- Ringkasan: Ini akan mengunduh data dalam format CSV sama persis dengan yang Anda lihat di Dashboard.
- Diperinci: Ini akan mengunduh daftar lengkap masing-masing transaksi yang dirangkum di dashboard. Anda dapat menyertakan metadata khusus yang terkait dengan transaksi tersebut untuk mempercepat proses rekonsiliasi.
Selain itu, Anda dapat mengunduh dengan cepat data per item untuk satu kategori transaksi dengan menempatkan kursor di atas kategori tersebut dan mengeklik tombol Unduh yang muncul.
Kolom yang tersedia
Anda dapat menyesuaikan kolom yang muncul di laporan saat mengunduhnya di dashboard atau melalui Reporting API. Kolom yang tersedia di setiap tipe laporan dijelaskan di bawah ini.
- Balance summary
- Payouts reconciliation summary
- Itemized payout reconciliation
- Ending balance reconciliation summary
- Itemized ending balance reconciliation
Balance summary
Tipe laporan API: balance.summary.1
Nama kolom | Default | Keterangan |
---|---|---|
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
Tipe laporan API: payout_reconciliation.summary.1
Nama kolom | Default | Keterangan |
---|---|---|
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
Tipe laporan API: payout_reconciliation.itemized.5
Nama kolom | Default | Keterangan |
---|---|---|
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
Tipe laporan API: ending_balance_reconciliation.summary.1
Nama kolom | Default | Keterangan |
---|---|---|
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
Tipe laporan API: ending_balance_reconciliation.itemized.4
Nama kolom | Default | Keterangan |
---|---|---|
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. |