Why Your Client's June Stripe Payout Doesn't Match Their Sales Report
Mid-year is when this question shows up most: a client looks at their bank deposit from Stripe and can't tie it to what they think they sold that week. The deposit is smaller, arrives on a different day, and doesn't match any single day's sales. Nothing is wrong — but explaining why takes the same three-way logic used at tax time, just applied mid-year instead of in April.
Payouts are a batch, not a sale
A Stripe payout bundles multiple days of activity, minus fees, minus refunds issued in that window, on Stripe's own settlement schedule (often a rolling 2-day delay, sometimes longer for new accounts). A $4,200 payout landing on a Tuesday might represent sales from the previous Thursday through Saturday, net of $180 in fees and a $75 refund. None of that is visible from the bank feed alone.
This is exactly why a payout total should never be the input for a reconciliation — it's already netted down, and it mixes multiple days together. The gross sales figure has to come from the processor's own transaction-level export, not the number that hits the bank.
The mid-year version of the same three numbers
The same structure used for the annual 1099-K reconciliation applies here, just monthly instead of annually:
- Processor gross — the sum of actual charges for the period, before fees and payouts
- Client's books — what's recorded as revenue for that same period
- The gap between them — and whether it's explained by timing (a charge posted one day, deposited the next) or something actually missing from the books
Catching a $400 gap in June, while the transaction detail is still fresh and easy to trace, is a five-minute conversation. Catching the accumulated version of that same gap in January — after twelve months of small drifts stacked on top of each other — is a much longer one.
What to actually check
- Pull the processor's itemized or balance transaction report for the period in question, not the payout summary
- Sum gross charges (before fees) for the window
- Compare to what's booked as revenue for that same window
- If they don't match, look for: refunds processed but not recorded, a second processor account, or a payout that straddles a month-end boundary
This is a natural monthly habit, not just a once-a-year exercise — running it every month, instead of only reconstructing the whole year in January, is what actually keeps a client's books from drifting.