Stripe connector: datasets and metric definitionsBeta
Bring in payments, refunds, fees and payouts that match the Stripe Balance report, plus subscriptions and MRR by month. Updates daily.
When you connect Stripe, Quiriz imports the datasets below and adds the metric definitions to Company Context, the one place your company’s definitions live. Every answer that uses one of these metrics uses the same definition, in the app, in Slack and in the Excel, Sheets, PowerPoint, Slides, Word and Docs add-ins. An admin can edit any of them.
DatasetsMetric definitionsWorks withQuestionsFAQ
Datasets
| Dataset | What it holds |
|---|---|
| [Stripe] Payments | One row per charge in its own currency, dated in the Stripe account time zone, failed attempts included (is_failed). Money that reached the balance is in [Stripe] Balance transactions. is_home_currency marks the account currency; never add currencies together. is_refunded = 1 for any refund, partial included.21 columnscreated_date, month, charge_id, payment_intent_id, balance_transaction_id, status, currency, is_home_currency, amount, amount_captured, amount_refunded, payment_method_type, card_brand, failure_code, customer_id, customer_name, invoice_id, is_succeeded, is_failed, is_refunded, is_disputed |
| [Stripe] Balance transactions | One row per balance transaction, like Stripe's Balance report, dated in the account time zone: gross, fee and net signed as Stripe signs them (refunds, disputes, fees and payouts negative). Net volume = net where is_sales_activity = 1. is_home_currency marks the account currency; never add currencies together.22 columnscreated_date, month, available_date, txn_id, type, reporting_category, currency, is_home_currency, gross, fee, net, source_id, charge_id, customer_id, customer_name, description, is_charge, is_refund, is_dispute, is_fee, is_payout, is_sales_activity |
| [Stripe] Subscriptions | One row per current subscription (active, past due, trialing, unpaid, paused) with its MRR by Stripe Billing's rules; is_counted = 1 for the ones Stripe counts. Canceled history is in [Stripe] MRR by month.20 columnssubscription_id, customer_id, customer_name, status, product_id, product_name, price_id, interval, interval_count, quantity, currency, is_home_currency, mrr, start_date, trial_end, current_period_end, cancel_at, is_counted, is_trialing, is_canceling |
| [Stripe] Invoices | One row per invoice in its own currency, dated in the account time zone. days_past_due counts from the due date for open invoices only. is_home_currency marks the account currency; never add currencies together.20 columnscreated_date, month, invoice_id, number, status, currency, is_home_currency, subtotal, discount, tax, total, amount_paid, amount_remaining, due_date, days_past_due, subscription_id, customer_id, customer_name, is_open, is_paid |
| [Stripe] MRR by month | One row per subscription per month-end by Stripe Billing's MRR rules (active and past due count; trials, metered items and tax do not; forever coupons subtracted, once and repeating coupons not). Past months from invoices, the current month from live subscriptions (is_latest = 1). A plan switch shows as one churn and one new. Group by month_end; never add month-ends together. Subscriptions in other currencies are not converted (is_home_currency). Tax-inclusive prices count the tax inside the price. After a mid-period upgrade, the upgrade month-end shows the old price until the next renewal.18 columnsmonth_end, month, subscription_id, customer_id, customer_name, product_id, product_name, interval, currency, is_home_currency, mrr, mrr_change, is_new, is_expansion, is_contraction, is_churn, is_reactivation, is_latest |
| [Stripe] Subscription snapshots | A dated copy of the Subscriptions dataset each day (daily for 90 days, then Mondays for 24 months). Compare two snapshot_date values; never add dates together.21 columnssnapshot_date, subscription_id, customer_id, customer_name, status, product_id, product_name, price_id, interval, interval_count, quantity, currency, is_home_currency, mrr, start_date, trial_end, current_period_end, cancel_at, is_counted, is_trialing, is_canceling |
| [Stripe] Customers | One row per customer named by a payment, subscription or invoice: name and country only, no email, phone or address. first_payment_date is the first successful charge in the imported payments.7 columnscustomer_id, customer_name, customer_country, created_date, first_payment_date, is_subscriber, is_delinquent |
Metric definitions
Each metric is a total over the period you ask about. A metric built from other metrics, such as a rate, divides the totals for the whole period; it does not average daily rates. Dated by is the date column that decides which period a row belongs to.
[Stripe] Payments
| Metric | How it is calculated | Dated by | Notes |
|---|---|---|---|
| Payments | Count of distinct charge_id | created_date | Charge attempts, successful or not, by charge date. |
| Successful payments | Count of distinct charge_id, where is_succeeded = 1 | created_date | Charges that succeeded, by charge date. |
| Failed payments | Count of distinct charge_id, where is_failed = 1 | created_date | Charges that failed (declined cards and the like), by charge date. |
| Payment success rate | Successful payments ÷ Payments | created_date | Successful payments divided by all charge attempts, as a decimal (0.95 = 95%). |
[Stripe] Balance transactions
| Metric | How it is calculated | Dated by | Notes |
|---|---|---|---|
| Gross volume | Sum of gross, where is_charge = 1 AND is_home_currency = 1 | created_date | Successful charges before refunds, disputes and fees, by balance transaction date. |
| Refunded amount | Sum of gross, where is_refund = 1 AND is_home_currency = 1 | created_date | Refunds, shown negative as in Stripe; a failed refund returns money and shows positive. |
| Dispute losses | Sum of gross, where is_dispute = 1 AND is_home_currency = 1 | created_date | Disputed amounts withdrawn, shown negative as in Stripe; a won dispute returns money and shows positive. |
| Processing fees | Sum of fee, where is_home_currency = 1 | created_date | The Stripe fee on every balance transaction (charges, refunds, disputes, instant payouts), shown positive. |
| Other Stripe fees | Sum of gross, where is_fee = 1 AND is_home_currency = 1 | created_date | Fees Stripe bills as their own transactions (Billing, Radar, Tax, Connect), shown negative as in Stripe. |
| Net volume | Sum of net, where is_sales_activity = 1 AND is_home_currency = 1 | created_date | Gross volume less refunds, disputes and all Stripe fees: the Dashboard's net volume from sales. |
| Payouts | Sum of gross, where is_payout = 1 AND is_home_currency = 1 | created_date | Money sent to the bank account, shown negative as in Stripe; a failed or canceled payout shows positive. |
[Stripe] Subscriptions
| Metric | How it is calculated | Dated by | Notes |
|---|---|---|---|
| Active subscriptions | Count of distinct subscription_id, where is_counted = 1 | Today’s snapshot | Subscriptions Stripe counts in MRR today (active and past due). |
[Stripe] MRR by month
| Metric | How it is calculated | Dated by | Notes |
|---|---|---|---|
| MRR | Sum of mrr, where is_latest = 1 AND is_home_currency = 1 | Today’s snapshot | Monthly recurring revenue today, by Stripe Billing's rules (active and past-due subscriptions, after forever coupons, before tax). For MRR over time use MRR by month. |
| MRR by month | Sum of mrr, where is_home_currency = 1 | month_end | Monthly recurring revenue at each month-end. Group by month_end; never add month-ends together. |
| ARR | mrr × 12 | Today’s snapshot | Annual recurring revenue today: current MRR times twelve. |
| New MRR | Sum of mrr_change, where is_new = 1 AND is_home_currency = 1 | month_end | MRR from subscriptions paying for the first time, by month-end. |
| Expansion MRR | Sum of mrr_change, where is_expansion = 1 AND is_home_currency = 1 | month_end | MRR added by upgrades and added seats, by month-end. |
| Contraction MRR | Sum of mrr_change, where is_contraction = 1 AND is_home_currency = 1 | month_end | MRR lost to downgrades, shown negative, by month-end. |
| Churned MRR | Sum of mrr_change, where is_churn = 1 AND is_home_currency = 1 | month_end | MRR lost to cancellations and unpaid subscriptions, shown negative, by month-end. |
| Reactivation MRR | Sum of mrr_change, where is_reactivation = 1 AND is_home_currency = 1 | month_end | MRR from subscriptions that came back after churning, by month-end. |
Works with other connectors
- Stripe + Google Analytics: Payments against traffic. Stripe revenue next to GA4 sessions and key events. Read the guide.
- PostHog + Stripe: Signups to revenue. PostHog signups and activation next to what Stripe collected. Read the guide.
- QuickBooks + Stripe: Burn multiple. Net burn from the books against net new ARR from billing. Read the guide.
Questions to ask
- What was our net volume by month this year?
- How much did we pay in Stripe fees last quarter?
- How has MRR changed month by month this year?
- Which customers churned last month, and how much MRR did we lose?
- Which products bring in the most MRR?
- How many payments failed this month, and why?
- Which customers have overdue invoices?
Related guides
- Connect Stripe to Quiriz
- Stripe AI: Ask Your Payments Data Questions in Plain English
- Stripe MCP: Connect Claude to Stripe, and Why MRR and Churn Need a Definition First
- Stripe Reporting: MRR, Refunds and Fees in Plain English
- How to Calculate MRR From Stripe: Annual Plans, Discounts and Pauses Without SQL
- Churn Rate Formula: Customer Churn vs Revenue Churn, With Examples and Why the Numbers Differ
Ask Stripe in plain words
Try the questions on sample data with no signup, then connect Stripe read-only and ask your own.
Try Quiriz free →Frequently asked questions
Does Quiriz change anything in Stripe?
How often does the Stripe data refresh?
Can I change how a metric is calculated?
Can I combine Stripe with other sources?
All connectors: Quiriz connectors. Definitions on this page are generated from the product’s own connector code.