Select a report
Find the right report to fit your financial workflow.
Stripe has a variety of different reports that provide information about your transactions. Start with the task you’re looking to perform and use the table below to identify the best report.
Task | Suggested report |
---|---|
| Balance |
| Payout reconciliation |
Reconciling your cash
The Balance and Payout reconciliation reports both provide downloadable transaction history including custom metadata, and you can use either to reconcile your cash. The reports group transactions in different ways to facilitate different types of reconciliation.
The Balance report
The Balance report resembles a bank statement and is optimized for users who treat their Stripe account similar to a bank account in their accounting system. The Balance report helps you to record all activity that occurred in Stripe during a date range. Payouts are recorded as simple transfers between your Stripe account and your bank account, which don’t correspond to any specific payments. Like a bank account, the balance is reconciled at the end of the period to confirm that all transactions have been accounted for.
The Payout reconciliation report
The Payout reconciliation report is optimized for users on automatic payout plans who model their Stripe balance as a temporary clearing account in their accounting system. This report helps you to reconcile each payout against the transactions included in that batch after it settles.
Reconciling between the reports
Most reconciliation workflows don’t require using both reports, but it can be helpful to understand how they fit together.
The following table shows an account on a two day rolling schedule with 5 days of activity. The account was opened on the 1st of the month and accepted 10 USD in charges from its customers on its first day. Those funds became available on the 3rd, and the account received its first payout to its bank account because of the 2 day payout schedule.
DAY | TRANSACTIONS | PAYOUTS | BALANCE AT EOD |
---|---|---|---|
1st | 10 USD | 10 USD | |
2nd | 20 USD | 30 USD | |
3rd | 30 USD | 10 USD | 50 USD |
4th | 50 USD | 20 USD | 80 USD |
5th | 70 USD | 30 USD | 120 USD |
Given the above account activity and a date range of 3rd–5th, the Balance summary would include the following data.
BALANCE SUMMARY | |
---|---|
Starting balance | 30 USD |
Balance change from activity | 150 USD |
Total payouts | -60 USD |
Ending balance | 120 USD |
The Balance change from activity section of the Balance report includes all transactions that occurred from the 3rd through the 5th. The total of these transactions matches the Balance change from activity line item in the balance summary of 150 USD.
The Payout reconciliation report includes transactions from the 1st through the 3rd because these transactions were paid out within the selected date range of 3rd–5th. The sum of these transactions matches the Total Payouts line item of the balance summary of -60 USD.
The Ending balance reconciliation section at the bottom of the Payout reconciliation report includes transactions from the 4th and 5th because these transactions weren’t paid out within the selected date range of 3rd–5th. The sum of these transactions matches the Ending balance line item in the balance summary of 120 USD.
Including transactions in a given date range
When you run a report, you select the reporting period using the controls in the dashboard, or by specifying start and end dates via the API. Each report uses a different type of date to determine which transactions fall within the reporting period.
Report | Relevant Date | Report Column |
---|---|---|
Balance | Date of change in Stripe balance | Balance transaction created (*) |
Payout reconciliation | Date automatic payout is available | automatic_ |
(*) except automatic payout transactions, which impact your Stripe balance based on the available_
date