Monthly Revenue Run Rate Calculator

Inputs

Choose a method, then enter CRM and revenue signals.

All amounts are monthly unless noted.

Currency *

Used only for display and exports.

Method *

Pick proration for paced revenue, or MRR for subscription models.

Conservative haircut (0–50%)

Reduces estimates to offset volatility and slippage.

Year

Month

Days in month auto-calculates at submit time.

Days elapsed in month

Used only for daily proration method.

Daily proration inputs

Run rate = (revenue so far ÷ days elapsed) × days in month

Revenue collected so far

Exclude one-time items unless you opt in below.

Include one-time revenue?

One-time items can inflate pace-based run rate.

One-time revenue amount

Used only if you include one-time revenue.

Subscription MRR inputs

Run rate = net MRR + (optional) one-time revenue

Active MRR

Recurring revenue from active customers.

Expected new MRR (this month)

Closed-won or very high confidence adds.

Expected churn MRR (this month)

Include downgrades and cancellations.

Expected expansion MRR (this month)

Upsells, seat adds, and price uplifts.

Weighted pipeline (annual value)

Optional: converted to monthly estimate.

Pipeline influence (0–100%)

How much pipeline may land this month.

Include one-time revenue?

Adds a one-time line item to the monthly view.

One-time revenue amount

Services, setup fees, or non-recurring charges.

Note

Pipeline is optional. Keep influence conservative. Avoid double-counting deals already included in new MRR.

Example data table

Use this as a quick reference for typical CRM inputs.

Scenario	Active MRR	New MRR	Expansion MRR	Churn MRR	Weighted Pipeline (Annual)	Influence
Steady month	48,500	4,200	1,100	1,600	120,000	15%
Pipeline push	48,500	2,500	900	1,200	260,000	20%
Churn risk	48,500	3,000	700	3,500	90,000	10%

Numbers above are sample amounts. Replace them with your data.

Formula used

1) Daily proration run rate

Monthly Run Rate = (Revenue So Far ÷ Days Elapsed) × Days In Month

Use this when revenue is paced daily and collections reflect delivery.

2) Subscription MRR run rate

Net MRR = Active MRR + New MRR + Expansion MRR + Pipeline MRR Add − Churn MRR

Pipeline MRR Add = (Weighted Pipeline × Influence%) ÷ 12

Use this for subscription models. Keep pipeline influence conservative.

3) Conservative haircut

Conservative Value = Estimate × (1 − Haircut%)

How to use this calculator

Pick a method that matches your revenue model.
Select the correct month and enter days elapsed if needed.
Enter CRM signals: active MRR, expected adds, churn, and expansions.
Optionally add weighted pipeline and a conservative influence percent.
Use the haircut to reduce over-optimistic forecasts.
Click calculate to view results above the form.
Export CSV or PDF to share in pipeline reviews.

FAQs

1) What is monthly revenue run rate?

It is an estimate of what your month would deliver if current pace continues. It converts partial-month revenue signals into a full-month projection.

2) When should I use daily proration?

Use it when revenue is collected steadily during the month and early results represent delivery pace. Avoid it for lumpy invoices or end-of-month billing.

3) When should I use the subscription MRR method?

Use it when revenue is primarily recurring. It combines active recurring revenue with expected adds, expansions, and churn to estimate a realistic monthly run rate.

4) Why include a conservative haircut?

Forecasts often miss due to slippage, payment delays, and churn surprises. A haircut builds a safety buffer so targets and staffing decisions rely on tighter assumptions.

5) How do I treat pipeline in the run rate?

Pipeline is optional. If included, keep influence low and avoid double counting deals already in “expected new MRR.” Treat it as a light sensitivity input.

6) Should one-time revenue be included?

Include it only when you need a blended monthly view. For recurring performance reporting, exclude one-time revenue to prevent overstating recurring momentum.

7) How can I improve accuracy?

Update inputs weekly, segment churn risk by account health, and track forecast error. Use the conservative estimate for planning, and keep a notes log per adjustment.