← Back to articles

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

QuestionReport or viewBasis
What moved through my Stripe balance this month?BalanceTransactions and balance movements across a date range
Which transactions were included in an automatic bank payout?Payout reconciliationTransactions grouped into the settlement batch
How much were my fees?FeesStripe’s fee breakdown for the period
How much recurring revenue do my subscriptions represent?Billing analyticsSubscription metrics using your Billing settings
When should revenue appear in my accounts?Revenue Recognition reports or accounting recordsRevenue 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.

MovementUSDWhat it explains
Gross sales+$12,000Charges in the period
Refunds−$600Funds returned to customers
Disputes−$200Net dispute activity in the period
Fees−$360Fees deducted in the summary
Net operating activity+$10,840Sales after these refunds, disputes and fees
Bank payout−$10,000Transfer 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.