How to reconcile Stripe payouts in Airtable
You get a payout for $2,247 and Stripe shows 60 transactions behind it — fees taken out, a refund somewhere, maybe a chargeback. Matching that deposit back to real revenue is where most founders lose an afternoon. Here is how to make it automatic in Airtable.
Why one payout never equals your revenue
A Stripe payout is the net cash deposited to your bank after Stripe nets out processing fees, refunds, and disputes across every transaction in that batch. Your dashboard's gross revenue is the total charged before any of that. The two are supposed to differ — reconciliation is the process of proving why.
Do it in a spreadsheet and you are exporting CSVs, running pivot tables, and matching rows by hand every month. See why CSV reconciliation breaks down.
What goes into a Stripe payout
- Charges — the gross amounts customers paid in the batch
- Fees — Stripe's per-transaction processing cut, deducted before deposit
- Refunds — money returned that nets down the payout
- Chargebacks and disputes — reversals that reduce the deposit further
- Available date — when the batch actually lands in your bank
Reconcile it automatically in Airtable
StripeYync syncs every balance transaction — charges, fees, refunds, payouts — into Airtable with gross, fee, and net on each record and the payout it belongs to. Group by payout and the deposit reconciles itself; no CSV export, no manual matching, no duplicate rows.
It pairs with the broader net revenue and MRR guide and the Stripe Airtable integration overview.
Stripe payout reconciliation FAQ
- Why doesn't my Stripe payout match my revenue?
- A payout is the net amount deposited to your bank after Stripe nets out fees, refunds, and chargebacks across many transactions. Your gross revenue is the total charged before those deductions, so the two never match. Reconciling means breaking a payout back into the charges and fees that make it up.
- How do I reconcile a Stripe payout made up of many transactions?
- A single payout can bundle dozens of charges plus fees, refunds, and the odd chargeback. To reconcile it you need every balance transaction — gross, fee, net, type, and the payout it belongs to — in one place. StripeYync syncs all of them into Airtable automatically, so each payout maps to its underlying transactions without manual matching.
- How do I handle Stripe fees, refunds, and chargebacks when reconciling?
- Treat each as its own balance transaction so it nets against gross revenue correctly. StripeYync writes fees, refunds, and disputes as separate records with their type, gross, and net amounts, so your Airtable totals reflect what actually hit your bank.