Skip to content
Log in Sign up

Weekly MRR report

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

Use this template How automations work
Runs weekly Scheduled Delivered 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 data.

Weekly MRR report Runs weekly · Sent to Slack, Email
Sample output
MRR components, last 6 weeks USD
W14 W15 W16 W17 W18 W19
New Expansion Churn

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 sources Finance
The prompt

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.
Data sources

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?
How often should I review MRR?
Keep going

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.

Get started in under 30 minutes

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

Start free Book a demo