Skip to content
Log inStart free

A free weekly MRR report template. AI breaks down new MRR, expansion, contraction, and churn from Stripe every Monday.

Use this templateHow automations work
Runs weeklyScheduledDelivered to Slack, Email

Weekly MRR report

Active
Trigger
Runs weekly
Instructions
Generate a weekly MRR report covering the past 7 days.
Delivery
Slack · Email

Example output

A realistic sample of what this automation delivers. Your version draws on your own data.

Weekly MRR reportRuns weekly · Sent to Slack, Email
Sample output
MRR components, last 6 weeksUSD
W14W15W16W17W18W19
NewExpansionChurn

Net new MRR this week: +$24,700 (+12% WoW, trailing 4-week avg +$22,100).

Components

  • New: +$19,800 (best week of the quarter)
  • Expansion: +$10,100
  • Contraction: -$1,500
  • Churn: -$3,700

Top contributors

  • New: NorthwindCo ($620), RegionalBank ($580), PlanetMedia ($340).
  • Expansion: Acme (+$340, 8 seats), ContentCo (+$280, plan upgrade).
  • Churn: RegionalCo ($380, downgrade after pricing change), three SMB cancellations.

Plan mix. 64% of new MRR landed on Growth (target), 22% Pro, 14% Starter.

Segment. Mid-market drove 71% of new MRR — best week for that segment ever.

Trend. Net new has now grown 6 weeks in a row. Trailing 12-week chart attached above.

Generated by Basedash AI from your connected data sourcesFinance

Copy, paste, customize.

Drop this into a Basedash automation. AI fills in the numbers from every source you've connected.

Instructions
Generate a weekly MRR report covering the past 7 days.

Report:

**Net new MRR.** This week, last week, trailing 4-week average.

**Components.**

- New MRR (new logo)
- Expansion MRR (upgrades, seat additions)
- Contraction MRR (downgrades, seat reductions)
- Churn MRR (cancellations)

**Top accounts.** Three largest contributors to each component (new / expansion / churn).

**Plan mix.** Distribution of net new MRR by plan tier.

**Segment.** SMB vs. mid-market vs. enterprise.

**Trend.** Net new MRR for each of the last 12 weeks.

Always name accounts. Numbers first.

Powered by these sources.

Basedash automations read across every connected source in a single run. These are the ones this template tends to use most.

Frequently asked questions

What's the formula for net new MRR?

Net new MRR = new MRR + expansion MRR − contraction MRR − churn MRR. Watching the components separately is more useful than the headline number — a flat net can hide a large churn problem masked by strong new logo.

How often should I review MRR?

Weekly for operating teams; daily for very high-velocity SMB businesses; monthly for the board. Weekly is the right cadence to catch a churn or pricing problem with time to react.

Related templates

Finance · Runs daily

Daily revenue snapshot

A one-paragraph morning revenue snapshot — yesterday's new MRR, expansions, churn, and notable events.

Finance · Runs monthly

Monthly burn and runway

Monthly burn (gross and net), cash balance, runway in months, and a forward forecast — automated.

Finance · Runs weekly

Weekly revenue breakdown

Revenue split by product, segment, geography, and channel — with the biggest movers each week.

Finance · Runs daily

Failed payments alert

Real-time alert when a paying customer's card fails, with ARR, reason, and the recommended next step.

We can help you migrate your data and dashboards from any other tool.

Start freeBook a demo