Skip to content
Create account
or
Sign in
The Stripe Docs logo
/
Ask AI
Create account
Sign in
Get started
Payments
Revenue
Platforms and marketplaces
Money management
Developer resources
Overview
Billing
OverviewAbout the Billing APIs
Subscriptions
Invoicing
Usage-based billing
Quotes
Customer management
Billing with other products
Revenue recovery
Automations
Test your integration
Tax
Overview
Use Stripe tax
Manage compliance
Reporting
Overview
Select a report
Configure reports
Reports API
Reports for multiple accounts
Revenue recognition
Data
OverviewSchema
Custom reports
Data Pipeline
Data management
    Overview
    Business and product data use cases
      Transactional data
      Disputes and fraud data
      All fees data
      Billing data
      Tax data
      Connected account data
      Card issuing data
    Import external data
HomeRevenueData managementBusiness and product data use cases

Query connected account data

Use Sigma and Data Pipeline to retrieve connected account information.

Account properties

Connected accounts can be configured with properties that determine how the account will behave. Account types can be mapped to their corresponding properties.
This content applies to connected accounts that your platform controls. This includes Custom and Express accounts, and Standard accounts with platform controls enabled.

Connect platforms can report on their connected accounts using Sigma or Data Pipeline. You can write queries that run across your entire platform in much the same way as your own Stripe account.

Additional groups of Connect-specific tables within the schema are located in the Connect sections of the schema. If you don’t operate a Connect platform, these tables are not displayed.

Connected account information

The connected_accounts table provides a list of Account objects with information about connected accounts. This table is used for account-level information across all accounts on your platform, such as business name, country, or the user’s email address.

The following example uses the connected_accounts table to retrieve a list of five accounts for individuals located in the US that have payouts disabled because Stripe does not have the required verification information to verify their account.

select id, email, legal_entity_address_city as city, legal_entity_address_line1 as line1, legal_entity_address_postal_code as zip, legal_entity_address_state as state, legal_entity_dob_day as dob_day, legal_entity_dob_month as dob_month, legal_entity_dob_year as dob_year,

All the required fields for individual accounts in the US are retrieved as columns. This allows you to see what information has been provided, and what is needed, for each account. This can be seen in the example report below (some columns have been omitted for brevity).

idemailcity…id_provideddocument_id
acct_GvO8RED…jenny.rosen@example.comSan Francisco…truefile_bLh2EX1…
acct_dnhbL5I…sophia.garcia@example.com…falsefile_t2nrCGt…
acct_0QJuhDd…natalie.davis@example.comSeattle…truefile_H4b1YP5…
acct_dGjq3Yb…ella.thompson@example.comAustin…falsefile_Klinhtm…
acct_Vgr8NDZ…james.smith@example.com…falsefile_vTgHYUb…

Accounts with requirements

The connected_accounts table also contains information about the requirements and future_requirements for connected accounts. Use the table to retrieve lists of accounts that have requirements currently due and will be disabled soon. Use the future_requirements columns to handle verification updates.

The following example uses the connected_accounts table to retrieve a list of accounts that have upcoming verification updates.

select id, business_name, requirements_currently_due, future_requirements_currently_due from connected_accounts where future_requirements_currently_due != ''

The requirements_past_due, requirements_currently_due, requirements_eventually_due, future_requirements_past_due, future_requirements_currently_due, and future_requirements_eventually_due are comma-separated lists of requirements on the account.

idbusiness_namerequirements_currently_duefuture_requirements_currently_due
acct_1swVCTsDr7T8QCxVRocketRidesbusiness_profile.url
acct_1sKBYRwsYq6OpPp1Kavholmindividual.email,settings.payments.statement_descriptor
acct_1T61cdGxgdsuTB6pFurEverexternal_accountsettings.payments.statement_descriptor
acct_1WVGj0OwBP02upnHPashabusiness_profile.urlcompany.tax_id

Transactional data for connected accounts

Connect query templates

Sigma and Data Pipeline include a variety of query templates for Connect platforms. Use these to get started with reporting on your connected accounts.

Transactional and subscription data for connected accounts is contained within the connected_account_ tables. The available data for connected accounts is organized and structured in the same way as data for your own account.

For instance, the balance_transactions table, located in the Payments section, contains balance transaction data for your Stripe account. The connected_account_balance_transactions table, located in the Connect - Payments section, contains balance transaction data for your connected accounts. Each Connect-specific table has an additional account column containing the identifier of a connected account. This can be used when joining tables to build advanced queries.

The following example is based upon the default query that’s loaded into the editor. Instead of retrieving the ten most recent balance transactions on your account, it does so across all of your platform’s connected accounts.

select date_format(created, '%m-%d-%Y') as day, account, -- Added to include corresponding account identifier id, amount, currency, source_id, type from connected_account_balance_transactions -- Changed to use Connect-specific table order by day desc limit 5
dayaccountidamountcurrencysource_idtype
7/6/2025acct_uSASxd5…txn_CUmpIFm…-1,000usdre_7zgNnIF…refund
7/6/2025acct_bmMxRRS…txn_w13PuTR…1,000usdch_SsCGuTr…charge
7/6/2025acct_QiSL4cl…txn_6eXixp2…1,000usdch_bQXtJvp…charge
7/6/2025acct_OH0JMfU…txn_aavq7sE…1,000eurch_8IOl37J…charge
7/6/2025acct_Bpf5Kve…txn_7cvkeK7…-1,000usdre_VeEdtVk…refund

Refer to our transactions and subscriptions documentation to learn more about querying transactional and subscription data. You can then supplement or adapt your queries with Connect-specific information to report on connected accounts.

Query charges on connected accounts

Use Sigma or Data Pipeline to report on the flow of funds to your connected accounts. How you do this depends on your platform’s approach to creating charges.

Direct charges

If your platform creates direct charges on a connected account, they appear on the connected account, not on your platform. This is analogous to a connected account making a charge request itself. Platforms can use the Connect-specific tables (for example, connected_account_charges or connected_account_balance_transactions) to report on direct charges.

Access the direct charges query template to retrieve itemized information about application fees earned through direct charges, and reports on the connected account, transfer, and payment that is created.

Destination charges

If your platform creates destination charges on behalf of connected accounts, charge information is available within your own account’s data. A separate transfer of the funds to the connected account is automatically created, which creates a payment on that account. For example, the destination charges query template reports on transfers related to destination charges made by your platform. One way to analyze the flow of funds from a destination charge to a connected account is by joining the transfer_id column of the charges table to the id column of the transfers table. This example includes the original charge identifier and amount, the amount transferred to the connected account, and the connected account’s identifiers and resulting payment.

select date_format(date_trunc('day', charges.created), '%y-%m-%d') as day, charges.id, charges.amount as charge_amount, transfers.amount as transferred_amount, transfers.destination_id from charges inner join transfers on transfers.id=charges.transfer_id order by day desc limit 5
dayidcharge_amounttransferred_amountdestination_id
7/6/2025ch_acct_7K328A6…1,0001,000acct_3GSqRTu…
7/6/2025ch_acct_73NSRdi…800800acct_XABfrjO…
7/6/2025ch_acct_KZWo3zA…1,000800acct_1kMWKmv…
7/6/2025ch_acct_Ro5EgVS…1,100950acct_pswyabp…
7/6/2025ch_acct_luFBkMO…1,1001,100acct_PTh0Lmy…

Payment and transfer information for Connected accounts is also available within Connect-specific tables (for example, connected_account_charges).

Separate charges and transfers

Report on separate charges and transfers using a similar approach to destination charges. All charges are created on your platform’s account, with funds separately transferred to connected accounts using transfer groups. A payment is created on the connected account that references the transfer and transfer group.

Both the charges and transfers table include a transfer_group column. Payment, transfer, and transfer group information is available within the Connect-specific connected_account_charges table.

Was this page helpful?
YesNo
Need help? Contact Support.
Join our early access program.
Check out our changelog.
Questions? Contact Sales.
LLM? Read llms.txt.
Powered by Markdoc