StripeYync

Track Stripe net revenue in Airtable (not just gross)

If your Airtable revenue comes from a generic Stripe sync, it is almost certainly overstated. Here is why gross-vs-net matters, and how to get accurate net revenue and settlement reconciliation into Airtable automatically. Want a ready-made base? Grab the free dashboard template.

Gross vs net: why your revenue numbers are overstated

A $49 charge does not put $49 in your account. Stripe takes roughly 2.9% + 30¢, so you actually receive about $47.28. Sync the gross amount and your revenue is inflated on every single transaction — small per charge, but it compounds across hundreds of payments and quietly breaks forecasting.

Net on a balance transaction shows what Stripe added after that transaction's fee. Refunds, disputes, reserves, and payout timing still affect the deposit that ultimately reaches your bank.

Worth keeping separate: MRR is normalized recurring subscription revenue, not cash collected. Stripe balance transactions tell you what settled, including one-off charges, refunds, and fees — a settlement ledger, not an MRR figure. Both are useful, and conflating them is how revenue reporting goes wrong in the first place.

What you need to reconcile Stripe in Airtable

  • Balance transactions — the source of truth, with gross, fee, and net per event
  • Refunds and disputes — so revenue nets down correctly
  • Payout entries and available dates — to review settlement timing before confirming exact membership in Stripe
  • Reporting category and currency — for grouping and multi-currency totals

Manual formulas vs automated sync

You can export a CSV and rebuild fee math with Airtable formulas every month — but it is stale the moment you import it, and re-imports create duplicates. See Stripe to Airtable without CSV exports for why that breaks down.

StripeYync automates the whole thing: it reads balance transactions on a schedule and writes gross, fee, and net as separate fields, so your Airtable revenue dashboard is always current. It is the Stripe Airtable integration built specifically for this. For deposit-level matching, see how to reconcile Stripe payouts in Airtable.

Stripe revenue in Airtable FAQ

Why is my Stripe revenue in Airtable too high?
Because most integrations sync the gross charge amount — before Stripe deducts its processing fee. Net revenue (gross minus fees) is what actually lands in your account, and it is usually 2.9% + 30¢ lower per charge. Note that neither figure is MRR: MRR is normalized recurring subscription revenue, while balance transactions record cash that actually settled.
How do I reconcile Stripe payouts in Airtable?
Sync Stripe balance transactions — including payouts and the available date — so each payout can be matched against the charges and fees that make it up. StripeYync writes all of these automatically.
Can Airtable calculate Stripe fees automatically?
Airtable will not pull fees on its own. StripeYync reads the fee from each Stripe balance transaction and writes gross, fee, and net as separate fields, so no formulas are required.

Ready to see your real revenue?

Start free trial