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, and payout entries — into Airtable with gross, fee, and net on each record, plus type, status, reporting category, and available date. That puts the whole settlement ledger in one table, refreshed automatically: no CSV export, no re-imports, no duplicate rows.
One honest limitation: the payout ID is not one of the synced fields today, so a deposit does not group itself. Available date can narrow the likely transactions, and the gross/fee/net columns help check the arithmetic — but exact payout membership still has to be confirmed in Stripe or from a payout reconciliation export.
It pairs with the broader net revenue 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, status, and available date — in one place. StripeYync syncs all of them into Airtable automatically, so the ledger behind a deposit is already there instead of sitting in a CSV export. Payout IDs are not written to Airtable yet, so tying a specific deposit to its exact transaction set still means filtering by available date.
- 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.