Home / Founders
For SaaS and startup founders on Stripe

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.

Try it on sample data → No signup, no Stripe login, nothing to install.

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

How it works for a founder

  1. 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.
  2. 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, ARR and Churned MRR. Your admin reviews and edits them.
  3. 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.
  4. 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.
  5. 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.

MetricName in QuirizThe assumption behind it
MRR todayMRR, ARRStripe Billing's rules: active and past-due subscriptions, after forever coupons, before tax. ARR is MRR times twelve. Home currency only.
MRR over timeMRR by monthMRR at each month-end. It is a snapshot, so it is never added across months.
The MRR bridgeNew MRR, Expansion MRR, Contraction MRR, Churned MRR, Reactivation MRRThe monthly change in MRR, split by cause. Contraction and churn are shown negative.
SubscriptionsActive subscriptionsSubscriptions Stripe counts in MRR today.
Payments healthPayment success rate, Failed paymentsSuccessful charges over all charge attempts.
Cash from salesGross volume, Net volume, Processing feesMatches the Stripe Balance report. Net volume is after refunds, disputes and fees.
BooksCash balance, Net income, Operating expensesFrom QuickBooks. Cash balance is the newest month-end.
Product funnelPostHog signups, PostHog 7 day activation rate, PostHog week 4 retention, PostHog paid conversion rateBy 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:

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.

AskWhat comes back
MRR by month this yearOne row per month-end, ending at today's MRR.
New, expansion, contraction and churned MRR by monthThe 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 monthA rate per month, so a card-failure problem shows up before it shows up as churn.

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.

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.

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.

Connect, or upload an export

Ask the sample data → Then connect Stripe, or try your own export and check the MRR against the one you reported.

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

Questions

How do I calculate MRR from Stripe?
Add up every active subscription normalized to one month, after recurring discounts. Annual plans count as one twelfth of the price each month. Quiriz reads Stripe's subscriptions into an MRR dataset built on Stripe Billing rules (active and past-due subscriptions, after forever coupons, before tax) and stores them as 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?
Customer churn is customers lost divided by customers at the start of the period. Revenue churn is MRR lost divided by starting MRR. They can disagree: lose 300 of 5,000 customers (6.0%) who each paid $12 against a $30 average and revenue churn is 2.4%. Quiriz has 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?
LTV is monthly gross margin per customer times customer lifetime (one divided by monthly churn). CAC is acquisition spend divided by new customers. Stripe supplies the customers and revenue, Google Ads and Meta Ads supply spend, and QuickBooks can supply the costs outside ads. Quiriz does not ship LTV:CAC as a built-in metric. Your admin defines it once from those metrics in Company Context, and you check the first quarter by hand. See LTV to CAC ratio and customer acquisition cost.
Can Quiriz calculate burn multiple?
Yes, as a metric your admin defines. Burn multiple is net burn divided by net new ARR. Net burn comes from QuickBooks (cash balance), and net new ARR comes from Stripe (new, expansion, contraction and churned MRR times twelve). It is not a built-in metric, so define it once in Company Context and check the first quarter against your own spreadsheet. See burn multiple.
How is net revenue retention worked out?
Starting MRR plus expansion, minus contraction, minus churn, divided by starting MRR, for the customers you had at the start. Quiriz has 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.
Why does ChatGPT give me a different churn number each time?
A general chat assistant given a Stripe export has to pick a churn rule each time you ask, and it can pick a different one. Quiriz routes the question to a stored definition instead, so the same question returns the same number in the sheet, the deck and Slack. An admin can approve a company's key questions, and their answers are cached. If you want Claude on Stripe directly, read Stripe MCP and why MRR and churn need a definition first.
Does Quiriz forecast revenue or runway?
No. Quiriz reports what happened and what the data holds today. It does not project MRR, and a runway figure is arithmetic on today's cash and burn, not a forecast. Anything you would present as a forecast is your own assumption.
Does my co-founder or finance lead need a license?
No. Team members use the admin's keys in the add-ins and the admin's Slack binding, so there is no per-seat fee for people who only ask questions. Plus allows 5 add-in keys, Pro 10 and Max unlimited.