One MRR, one churn rate and one LTV:CAC in the investor update, the board deck and Slack
Stripe's dashboard says one MRR, your spreadsheet says another, and the deck says a third. Quiriz connects Stripe, QuickBooks and PostHog read-only, stores each definition once, and uses it everywhere you report: Excel, Sheets, Word, Docs, PowerPoint, Slides and Slack. The Sunday investor update becomes a refresh.
Your numbers rarely drift because Stripe is wrong. They drift because "churn" means customers to one person and revenue to another, annual plans are spread differently in each file, and whichever tab is open decides this week's answer. Quiriz writes the definition down once, applies it every time, and builds the board pack from the same figures. When a number changes, you can say why.
What you get
- One definition of MRR, churn and LTV:CAC. Stripe's MRR is stored by Stripe Billing's rules. The churn rate, retention and LTV:CAC rules are written once by an admin in Company Context. The Excel cell, the board deck, the Word update and the Slack thread all use them, and a daily refresh never overwrites a definition you edited.
- The investor update is a refresh, not a rebuild. The MRR bridge is a formula you recalculate. The board deck is built once and refreshed with Refresh all next quarter.
- Read-only. The Stripe and QuickBooks connectors read your data and never write to it. They cannot create a charge, a refund or an entry. Data refreshes once a day.
- Your co-founders check the numbers at no extra cost. Team members use the admin's keys in the add-ins and the admin's Slack binding. There is no per-seat fee for people who only ask questions.
- It says what it cannot answer. No forecasts, and nothing billed outside Stripe. See what it will not do.
How it works for a founder
- Connect. Connect Stripe and QuickBooks, then PostHog, Google Ads, Meta Ads or HubSpot if you use them. Or upload a Stripe or books export. Connectors are included on Plus, Pro and Max.
- Quiriz sets up the datasets and definitions. Stripe arrives with payments, balance transactions, subscriptions, invoices, MRR by month, subscription snapshots and customers, plus metrics such as
MRR,ARRandChurned MRR. Your admin reviews and edits them. - Write down what only you can decide. Customer churn or revenue churn, whether reactivations count, which spend counts in CAC. Define each once in Company Context.
- Ask where you already work. A formula in Excel or Sheets, live figures in Word or Docs, a deck in PowerPoint or Slides, or a question in Slack.
- Keep it current. Data refreshes daily. Recalculate the sheet, refresh the update, or press Refresh all in the deck.
The subscription metrics come pre-defined
These are the names Quiriz stores when Stripe, QuickBooks or PostHog connects. Each is a stored definition with its assumption written down, because the assumption is where these numbers go wrong. The full list is on the Stripe, QuickBooks and PostHog pages.
| Metric | Name in Quiriz | The assumption behind it |
|---|---|---|
| MRR today | MRR, ARR | Stripe Billing's rules: active and past-due subscriptions, after forever coupons, before tax. ARR is MRR times twelve. Home currency only. |
| MRR over time | MRR by month | MRR at each month-end. It is a snapshot, so it is never added across months. |
| The MRR bridge | New MRR, Expansion MRR, Contraction MRR, Churned MRR, Reactivation MRR | The monthly change in MRR, split by cause. Contraction and churn are shown negative. |
| Subscriptions | Active subscriptions | Subscriptions Stripe counts in MRR today. |
| Payments health | Payment success rate, Failed payments | Successful charges over all charge attempts. |
| Cash from sales | Gross volume, Net volume, Processing fees | Matches the Stripe Balance report. Net volume is after refunds, disputes and fees. |
| Books | Cash balance, Net income, Operating expenses | From QuickBooks. Cash balance is the newest month-end. |
| Product funnel | PostHog signups, PostHog 7 day activation rate, PostHog week 4 retention, PostHog paid conversion rate | By signup week. Only cohorts old enough are counted, and signups read 0 until you choose the signup event in the PostHog connector. |
Churn rate, net revenue retention, LTV:CAC and burn multiple are not on this list on purpose. They depend on rules only you can choose, so they are definitions you write once. The next sections show how.
Write the definition once
Two founders can read the same Stripe data and get different churn. Say which one you mean, once, and every report follows it:
- Customer churn: customers lost in the period divided by customers at the start. Revenue churn:
Churned MRRdivided by starting MRR. - Annual plans: spread over twelve months, as Stripe Billing's MRR does.
- Reactivations: whether a returning customer cancels the churn or counts as new.
- CAC: paid spend only, or all sales and marketing cost, divided by new paying customers.
Why it matters. Illustrative: 5,000 customers and $150,000 of starting MRR. Lose 300 customers who paid $12 each and customer churn is 300 / 5,000 = 6.0%, while revenue churn is 3,600 / 150,000 = 2.4%. Both are right. A board that hears only "6% churn" worries about the wrong thing. Written down once, the question gets the same answer every time. The full example is here.
The Sunday investor update
The same questions, every week or month. With Stripe connected, each is a formula you recalculate instead of an export you rebuild.
| Ask | What comes back |
|---|---|
| MRR by month this year | One row per month-end, ending at today's MRR. |
| New, expansion, contraction and churned MRR by month | The bridge: one row per month, so you see where the movement came from. |
| Which customers churned last month, and how much MRR did we lose? | One row per customer, with the MRR lost. |
| Payment success rate by month | A rate per month, so a card-failure problem shows up before it shows up as churn. |
- Excel:
=QUIRIZ.ASK("new, expansion, contraction and churned MRR by month this year", "table")spills one row per month. It answers against the refreshed data each time the sheet recalculates. - Google Sheets:
=QUIRIZ("MRR by month this year", "table"). The Google spelling has no dot. - Slack: bind a channel and ask "what was our MRR at the end of last month, and what churned?" in a thread, with the chart. Slack is included from the Plus plan.
The bridge, worked through. Illustrative: starting MRR $40,000, then $3,000 new, $1,000 expansion, $500 contraction and $1,500 churned. Net new MRR is 3,000 + 1,000 - 500 - 1,500 = $2,000, so ending MRR is $42,000. Net revenue retention is (40,000 + 1,000 - 500 - 1,500) / 40,000 = 97.5%, and gross retention is (40,000 - 500 - 1,500) / 40,000 = 95%. New customers are left out of both. See the net revenue retention formula.
Burn multiple and LTV:CAC, across your sources
With more than one source connected, Quiriz can answer across them. A metric that spans sources is one your admin defines, once, in Company Context, from metrics on different datasets. An admin can also map a Dimension, one column per dataset that means the same thing, to break a metric down. These are not built in, so check the first quarter against your own spreadsheet.
- Burn multiple. "What was our burn multiple last quarter?" Net burn comes from QuickBooks and net new ARR from Stripe. Illustrative: cash falls from $1,200,000 to $960,000 with no funding, so net burn is $240,000. Net new ARR is $180,000 new plus $30,000 expansion minus $60,000 churned and contracted, or $150,000. Burn multiple is 240,000 / 150,000 = 1.6. See burn multiple.
- LTV:CAC. Customer lifetime and margin come from Stripe and the books, and spend comes from Google Ads and Meta Ads, with other costs from QuickBooks if your CAC includes them. Illustrative: $100 MRR per customer at an 80% margin is $80 a month. At 4% monthly churn the lifetime is 25 months, so LTV is $2,000. With $30,000 of spend and 60 new customers, CAC is $500 and LTV:CAC is 4:1, with a payback of 6.25 months. See LTV to CAC ratio.
- Pipeline beside subscriptions. "How does HubSpot closed-won ARR compare with new MRR in Stripe each month?" Connectors: HubSpot (or Salesforce, Beta) and Stripe. The join is by month, and ARR is twelve times MRR, so the question states its unit.
- Product funnel beside revenue. PostHog gives signups, 7 day activation and week 4 retention by signup week, and Stripe gives MRR by month. They answer side by side at the same grain, by month, which is the honest level. See PostHog signups to Stripe revenue.
Ad spend is in the ad account's currency with no conversion, and Stripe MRR counts your home currency only.
The board pack and the update
The second clock is the quarterly board pack. It starts from the same data, so it stays in step with the weekly numbers.
- The update, in Word or Google Docs. In Word, put MRR, net new MRR and cash into your sentences as live Figures and lock them so nobody types over a number. In Docs, type "MRR by month" where the table should go. Next month, refresh the document instead of rewriting it.
- The board deck, in PowerPoint or Google Slides. Make a deck (Beta) plans the slides first, so you edit titles and questions before it builds, and the charts are editable. Next quarter, Refresh all updates every figure and chart instead of rebuilding the slides.
Install: Excel, Word, PowerPoint, Sheets, Docs, Slides.
Make a deck: the quarterly board pack
PowerPoint or Slides. Tick your Stripe and QuickBooks datasets.
"Board update for this quarter against last. MRR and ARR, the MRR bridge by month with new, expansion, contraction and churned MRR, net revenue retention, payment success rate, and cash balance, net income and operating expenses by month."
You get a plan of slide titles and questions to edit first, then the deck with editable charts. Save it once, and press Refresh all before the next board meeting.
What it will not do
Things a founder asks for that the data cannot answer, said here rather than discovered in the product.
- A forecast. Quiriz reports what happened and today's balances. It does not project MRR, churn or runway.
- Revenue billed outside Stripe. Stripe-only MRR ignores invoices you bill in another system or collect by bank transfer. QuickBooks revenue is the books, and it will not match MRR, because they measure different things.
- Coupons and plan changes without a stated rule. Stripe's MRR applies forever coupons. Anything else, such as a one-off discount, needs your rule. Say it in Company Context rather than letting each report guess.
- A person-level path from first visit to paying. PostHog does not carry Stripe customer IDs unless you send them, so Quiriz cannot say which person from which channel paid. It answers each side at the same grain, by month.
- Burn multiple and LTV:CAC out of the box. They are your admin's own metrics. Check the first quarter by hand.
Connect, or upload an export
- Stripe: payments, balance transactions, subscriptions, invoices, MRR by month, subscription snapshots and customers. Read-only, refreshed daily.
- QuickBooks Online: profit and loss and balance sheet by month, the ledger, open invoices and open bills. Read-only, refreshed daily.
- PostHog: traffic, signups, activation, retention and feature usage by day, channel and page.
- Ads and CRM: Google Ads, Meta Ads, HubSpot and Salesforce (Beta). See all of them on the connectors page.
- Anything else: upload an export from your billing tool or any other system, as Excel, CSV, PDF or an image with a table, by upload, email or Slack. Quiriz can also sync a OneDrive or Google Drive file or folder on a schedule. See your own data.
Pricing
Free is $0 for 5 files. Connectors, Slack and scheduled reports start on Plus at $12 a month ($120 a year); Pro is $30 and Max is $60 a month. You pay for the workspace and the person who builds it, not per seat asking questions. Your co-founders and your finance lead can check a number without another license. See pricing →
Your files stay yours, and we do not train on your data. Privacy policy →
Related reading
- How to calculate MRR from Stripe: annual plans, discounts and pauses
- Churn rate formula: customer churn against revenue churn
- Net revenue retention formula: NRR, GRR and net revenue churn
- LTV to CAC ratio: from your Stripe data, and what 3:1 means
- Customer acquisition cost: the four things people leave out
- Burn multiple: where net burn and net new ARR come from
- Stripe MCP: why MRR and churn need a definition first
- Stripe AI: asking your payments data questions
- Stripe reporting
- From PostHog signups to Stripe revenue: what you can and cannot connect
- All guides →
Questions
How do I calculate MRR from Stripe?
MRR and MRR by month. Ask =QUIRIZ.ASK("MRR by month this year", "table") in Excel, or =QUIRIZ("MRR by month this year", "table") in Sheets. The worked example is here.What is the churn rate formula, and which churn should I quote?
Churned MRR and Contraction MRR built in. The rate itself, and which customers count, is a definition your admin writes once in Company Context, so every report quotes the same one. See the churn rate formula.How do I calculate LTV to CAC from Stripe and my ad accounts?
Can Quiriz calculate burn multiple?
How is net revenue retention worked out?
Expansion MRR, Contraction MRR and Churned MRR from Stripe, so the bridge is there. Write the rule once in Company Context (which period, whether reactivations count) and every report uses it. See net revenue retention.