Understanding how funds flow in and out of your account is an important part of processing payments. Use the Dashboard to view information about the different types of account activity, which can be exported into a CSV-formatted report for use in spreadsheet apps.
Monthly summary report
This report includes all your account activity—grouped by month—up to the most recent full day. Account activity includes charges, refunds, fees, and disputes, divided into the sections below. It can be downloaded from your account’s Data settings.
All amounts are expressed in the currency of the bank account that payouts are sent to. If you make use of separate bank accounts to receive payouts in different currencies, the report will include separate information for each payout currency.
Monthly activity summary
The first section of the monthly summary report provides a breakdown of your account balance, excluding payouts and payout failures:
- Dispute Reversals
- Other Adjustments
- Net Activity
If you’re using any of the following, you’ll also see separate lines for:
Declined, failed, or uncaptured charges are not included as they do not impact your Stripe balance.
This section details any transfer of funds out of your Stripe balance that have been created. If you’re using automatic payouts, they are grouped into months based on the date we expect the transfers to post to your account. If you’re using manual payouts, they are grouped together based on the date requested.
If there were any failed transfers, this information is also included, along with the date that Stripe was notified of the failure.
The starting and ending balance in your Stripe account each month. This includes both the available and pending balance.
|Start of Month Balance||623.29||2.52|
|Less Net Transfers||-631.97||-7.62|
|End of Month Balance||2.61||623.29|
This section of the report is included for users who have automatic payouts enabled. If you’re using manual payouts, this section is not included.
Use this information to reconcile deposits to your bank account with your account’s activity from each month. If you’re operating multiple Stripe accounts and receive payouts into the same bank account, you must reconcile each account separately.
Payout reconciliation is subdivided into several parts.
- Net Activity: from the monthly activity summary
- Failed transfers (if any): from the transfers section
- Less Activity Transferred in Month: the amount of this month’s activity transferred in this month
- Less Activity Transferred in Later Months: the amount of this month’s activity transferred after the end of the month. This is typically nonzero because activity from the end of the month will be transferred at the beginning of the following month.
- Untransferred Activity: The difference between the above two sections. This is typically nonzero for the current month because funds haven’t yet been paid out from the most recent days’ activity.
|Less Activity Transferred in Month||-8.68||-5.1|
|Less Activity Transferred in Later Months||-623.29||-2.52|
If there have been other issues that led to payout delays, an additional line is included that totals the cumulative untransferred funds. This can be used to determine how much has is yet to be transferred.
Account activity reports
Use the Balance area of the Dashboard to review any of your account’s balance history, such as payments, refunds, adjustments, and disputes. Every transaction contributing to your account’s balance and transfers is listed here, making accounting over specific periods of times straightforward. The balance report includes many different pieces of information about each transaction, such as:
- Type and ID of transaction (transfer, charge, adjustment, etc.)
- Net amount
- Date created
- Date available
- Transfer ID
- Transfer date
In addition, any metadata that has been provided is also included in the balance report. Each key has its own column provided with a separate column.
Use the following areas of the Dashboard to report on specific account activity in more detail:
The balance history and account activity can be filtered to display results within a specified criteria. Use the Filter option, located at the top-left of the results, to view and apply the available filter options. Account activity with filtered results can also be exported to a CSV file, reducing the amount of data you need to work with.
Reconciling individual payouts
If you’re receiving automated payouts from Stripe, you can view the details of each individual payout in the Dashboard to determine which balance transactions it contains. This information can also be retrieved using balance_history and providing the payout ID as a value for
Further reporting options
Stripe Sigma makes all of your business data available as an interactive SQL environment in the Dashboard. You can write queries that leverage its extensive schema, allowing you to create fully customized reports using information about your transactions.
Information about payments, refunds, fees, and transfers can be exported to a QuickBooks-compatible IIF file, available in the Dashboard’s Data settings. Refer to our QuickBooks documentation for a complete overview.
There are also many third-party accounting integrations that can connect to your Stripe account and synchronize your account activity for automatic reconciliation. These types of services automatically detect any new activity and update any information they have.