Skip to content

Finance and payments

Connect Stripe to DataxLand

The Stripe connector reads customers, subscriptions, invoices, charges, refunds, balance transactions and payouts of your Stripe account. For a software company selling subscriptions, Si maps this data to the technology industry's standard model to give MRR, new, expansion, churned and net new MRR, logo churn rate, invoiced amount and collection rate - one definition across dashboards, Si's answers and MCP. Stripe fees in balance transactions give the real payment fees.

Free plan with no time limit · No card required · Sample workspace ready in minutes

What you can do with Stripe

  • Track MRR and net new MRR by month without building a spreadsheet from Stripe exports.
  • See how many customers churn and how much MRR is lost each month, with an alert on unusual rises.
  • Compare invoiced with collected amounts to spot failed payments.
  • Combine with HubSpot or Salesforce to tie won deals to new MRR.

What data you get

Each stream lands as its own table in the workspace warehouse, as is; personal-data columns are hashed on load.

Stream (table)Contents
customersCustomers (personal columns such as email and name hashed on load).
subscriptionsSubscriptions, plan, status, start and cancel dates.
invoicesInvoices, billing period, amounts due and paid.
chargesCharges and payment status.
refundsRefunds.
balance_transactionsBalance transactions, including the Stripe fee of each.
payoutsPayouts to your bank.

Connection details

Sign-in methodConnection details (API key, account), encrypted at rest
Sync modesFull (reloaded each run) · Incremental (new or changed rows only)
Fields to fill inAccount ID, Secret Key
DeveloperAirbyte (certified), run inside DataxLand
LicenseELv2

Passwords and keys are encrypted at rest. Personal-data columns are hashed on load.

Metrics computed from this source

Real definitions from the analytics packs; dashboards and Si share them.

MetricDefinitionUnit
Average MRRAverage monthly recurring revenue in the period = total MRR across month-end snapshots divided by the number of snapshot dates.= tech_mrr_snapshot_total / tech_snapshot_countCurrency
New MRRTotal MRR from subscriptions that start paying in the period (events of type new), by effective date.Currency
Expansion MRRTotal MRR increase from existing customers (more seats, plan upgrades) in the period.Currency
Churned MRRTotal MRR lost from customers cancelling their subscriptions in the period, as a positive number.Currency
Net new MRRNew MRR plus expansion, minus contraction and churn, in the period.= New MRR + Expansion MRR - Contraction MRR - Churned MRRCurrency
Logo churn rateChurned accounts in the period divided by average paying accounts in the period.= Churned accounts / Average paying accountsRatio (%)
Invoiced amountTotal amount of subscription invoices issued in the period (by issue date).Currency
Invoice collection rateAmount collected divided by amount invoiced, for invoices issued in the period.= tech_invoice_paid_amount / Invoiced amountRatio (%)
Payment feesMarketplace transaction fees and payment gateway fees, allocated to lines by line revenue.Currency

Connect Stripe in 3 steps

  1. 1

    Create a restricted key

    In Stripe Dashboard → Developers → API keys, create a read-only restricted key; copy the Account ID from account settings.

  2. 2

    Add the source

    In the workspace choose Add source, find Stripe in the connector library, paste the key in Secret Key, enter Account ID and a start date, click Test connection.

  3. 3

    Choose streams and review

    Pick subscriptions, invoices, charges and balance transactions (loaded incrementally); Si proposes a subscription mapping, you approve and build.

Limits and caveats

  • MRR follows the technology pack definition from subscriptions and their movements; it can differ from Stripe Billing reports when discounts or trials are treated differently.
  • Use a read-only restricted key, not the full secret key; the key is encrypted at rest.
  • This is an Airbyte connector (ELv2 license) run inside DataxLand; accounts with years of data can take a while on the first load.

Frequently asked questions

Does DataxLand create transactions in Stripe?

No. With a read-only key, DataxLand only reads data.

I sell one-off, without subscriptions.

Charges and refunds still serve revenue and payment fees; MRR metrics need subscriptions.

Is card data read?

Stripe does not return full card numbers through the API; customer personal columns are hashed on load.

Dashboard templates that use this source

Ask Si about your Stripe data →Stripe + Intercom →Stripe + HubSpot →All data sources →

Connect Stripe and get verified dashboards

Free plan with no time limit · No card required · Sample workspace ready in minutes