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 |
|---|---|
| customers | Customers (personal columns such as email and name hashed on load). |
| subscriptions | Subscriptions, plan, status, start and cancel dates. |
| invoices | Invoices, billing period, amounts due and paid. |
| charges | Charges and payment status. |
| refunds | Refunds. |
| balance_transactions | Balance transactions, including the Stripe fee of each. |
| payouts | Payouts to your bank. |
Connection details
| Sign-in method | Connection details (API key, account), encrypted at rest |
|---|---|
| Sync modes | Full (reloaded each run) · Incremental (new or changed rows only) |
| Fields to fill in | Account ID, Secret Key |
| Developer | Airbyte (certified), run inside DataxLand |
| License | ELv2 |
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.
| Metric | Definition | Unit |
|---|---|---|
| Average MRR | Average 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_count | Currency |
| New MRR | Total MRR from subscriptions that start paying in the period (events of type new), by effective date. | Currency |
| Expansion MRR | Total MRR increase from existing customers (more seats, plan upgrades) in the period. | Currency |
| Churned MRR | Total MRR lost from customers cancelling their subscriptions in the period, as a positive number. | Currency |
| Net new MRR | New MRR plus expansion, minus contraction and churn, in the period.= New MRR + Expansion MRR - Contraction MRR - Churned MRR | Currency |
| Logo churn rate | Churned accounts in the period divided by average paying accounts in the period.= Churned accounts / Average paying accounts | Ratio (%) |
| Invoiced amount | Total amount of subscription invoices issued in the period (by issue date). | Currency |
| Invoice collection rate | Amount collected divided by amount invoiced, for invoices issued in the period.= tech_invoice_paid_amount / Invoiced amount | Ratio (%) |
| Payment fees | Marketplace transaction fees and payment gateway fees, allocated to lines by line revenue. | Currency |
Connect Stripe in 3 steps
- 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
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
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
Connect Stripe and get verified dashboards
Free plan with no time limit · No card required · Sample workspace ready in minutes