Stripe Reporting: Match Sales, Fees and Payouts
Published October 30, 2026 · Written by Aanart

Stripe reporting answers several different questions: what changed in your Stripe balance, which transactions settled in a payout, and how recurring subscriptions are performing. Choose the report by the question. A bank deposit, a customer charge and recognised revenue can all have different dates and amounts.
Use SourcetoMCP’s Stripe connector to review balance activity, refunds, disputes, Stripe fees and payouts with an AI assistant. This guide shows how to reconcile a period summary and when to switch to Stripe’s own payout or accounting reports.
Choose the Stripe report that matches your question
| Question | Report or view | Basis |
|---|---|---|
| What moved through my Stripe balance this month? | Balance | Transactions and balance movements across a date range |
| Which transactions were included in an automatic bank payout? | Payout reconciliation | Transactions grouped into the settlement batch |
| How much were my fees? | Fees | Stripe’s fee breakdown for the period |
| How much recurring revenue do my subscriptions represent? | Billing analytics | Subscription metrics using your Billing settings |
| When should revenue appear in my accounts? | Revenue Recognition reports or accounting records | Revenue attributed to the periods in which it is earned |
Stripe’s report selection guide explains when to use Balance and Payout reconciliation. To get a transaction history that works like a Stripe account statement, choose Balance in the Dashboard reports, set the dates and currency, and download the summary or itemised data. Use the filters that correspond to the account and period you intend to reconcile.
Check gross, fees and net without double-counting a payout
Start with the transaction-level change in the Stripe balance. Charges add funds. Refunds and dispute activity can reduce funds, and fees reduce what remains. Other adjustments can add or subtract funds. Keep the signs from the exported or connected data and identify whether fees are already included in a net column before doing arithmetic.
This hypothetical USD example has a $1,000 opening balance and no other adjustments. It uses a positive fee amount shown as a deduction.
| Movement | USD | What it explains |
|---|---|---|
| Gross sales | +$12,000 | Charges in the period |
| Refunds | −$600 | Funds returned to customers |
| Disputes | −$200 | Net dispute activity in the period |
| Fees | −$360 | Fees deducted in the summary |
| Net operating activity | +$10,840 | Sales after these refunds, disputes and fees |
| Bank payout | −$10,000 | Transfer out of the Stripe balance |
| Closing balance | $1,840 | $1,000 + $10,840 − $10,000 |
If the payout arrives at the bank on the first day of the following month, it can still reduce the Stripe balance in the earlier period. Compare payout ID, settlement currency, amount and relevant dates. Keep a timing difference open until the bank records the matching deposit. These simplified figures explain movement in the balance. Cost of goods and operating expenses are outside this calculation.
Reconcile an automatic payout separately
Use Stripe’s Payout reconciliation report to select a payout and inspect its transactions. Set a range that includes the estimated arrival date and compare the itemised total with the bank deposit. For a mismatch, start with the account and currency, then inspect payout status, adjustments and whether you picked the intended batch.
Stripe provides this transaction-to-payout report for automatic payouts. Use the Balance report for a manual payout workflow and match the transfers to the bank. Stripe can’t identify a transaction batch for an instant payout, so keep the underlying reconciliation separate from that transfer. When supported for an automatic payout, the connector’s balance transactions list can use a payout ID filter to review the batch.
Check what the connected revenue summary includes
SourcetoMCP’s Stripe revenue summary reads balance transactions and returns gross sales, signed refunds and disputes, fees, other adjustments and net after fees. It returns payouts and transfers separately. Use the currency and time zone returned with the summary. Compare complete equivalent date ranges and leave different currencies in separate rows until you have a documented conversion policy.
The summary defaults to 2,000 balance transactions and can request up to 5,000. A capped response starts with the newest records, so earlier days may be incomplete. Split a busy period into shorter, non-overlapping date ranges, keep the same time zone, and confirm each response is complete before combining the figures. The connected summary explains balance activity. Use native report exports or accounting records for a formal close and for recognised revenue.
Ask AI to explain a Stripe reporting difference
Confirm [Stripe account], live or test mode, currency and time zone. Summarise [dates] from balance transactions. Show gross sales, signed refunds and disputes, fees, other adjustments and net, with payouts and transfers separate. Show record counts and truncation warnings. If the range is incomplete, break it into non-overlapping dates. For [automatic payout ID], compare the batch with my supplied bank line. Separate timing differences, unmapped items and unexplained amounts. Do not infer the contents of a manual or instant payout. Make no changes.
Record which amounts you matched and which need a closer look. To explain a subscription change, use the monthly recurring revenue guide. To connect the account first, follow Stripe for Claude or Stripe for ChatGPT.
Platform guidance and SourcetoMCP capabilities checked on 14 November 2026. Worked figures are hypothetical examples.