Skip to content

Structure a SaaS MRR and Unit Economics CSV Schema

Standardize monthly recurring revenue waterfalls (New, Expansion, Contraction, Churn), logo/dollar retention matrices, CAC payback, and burn-multiple sheets.

Copy the prompt and paste it into the AI assistant you already use.

SaaS metrics workbooks standardize operational KPI modeling and do not constitute GAAP revenue-recognition advice or audited financial statements.

Avoiding diligence red flags in SaaS metric sheets

  1. 01

    Never include one-time onboarding fees inside MRR

    Isolate implementation, setup, and professional services revenue in non-recurring rows so investors trust your pure recurring ARR multiple.

  2. 02

    Normalize annual and quarterly contracts cleanly to 30-day months

    Convert multi-year or annual contracts consistently across exact contract start and end dates rather than booking cash spikes as MRR.

  3. 03

    Report Gross Retention alongside Net Dollar Retention

    Cap Gross Revenue Retention strictly at 100% per cohort so strong expansion from whales never hides leaky logo churn underneath.

  4. 04

    Adjust CAC payback by SaaS gross margin

    Divide prior-quarter sales and marketing spend by gross-margin-weighted net new MRR rather than raw top-line bookings.

How it works in practice

Founder billing export notes for Series A prep

Need clean CSV/XLSX schema from Stripe + Salesforce invoices. Have annual ($12k–$60k) and monthly ($600/mo) plans plus $2,500 one-time onboarding fees. Investors asked for 18-month MRR bridge, GRR vs NRR, and gross-margin CAC payback (78% SaaS GM, 1-quarter S&M lag).

Structured Workbook & CSV schema specification

1. `Raw_Contracts_CSV`: `customer_id, start_date, end_date, mrr_normalized, non_recurring_setup_fee, segment` (excludes $2.5k setup from MRR). 2. `MRR_Bridge`: Beginning MRR + New + Expansion + Reactivation - Contraction - Churn = Ending MRR (ARR = Ending MRR * 12). 3. `Retention_Cohorts`: GRR (capped <=100%, Excl. Expansion) vs. NRR (Incl. Expansion) across 18 monthly start cohorts. 4. `Unit_Economics`: `S&M_(t-1) / (Net_New_MRR_t * 78% GM)` = Months to CAC Payback.

Gives investors clean, standard SaaS formulas that survive diligence scrutiny without manual restatements.

Common questions

What is the difference between booked ARR and recognized GAAP revenue?

Contracted ARR measures annualized recurring run-rate of active subscriptions, whereas GAAP revenue recognizes earned days strictly across service delivery.

Should resurrected churned customers count as 'New MRR' or 'Reactivation'?

Track Reactivation MRR on its own bridge row so returning accounts don't artificially inflate first-time New Logo CAC efficiency.

Why lag Sales & Marketing spend when computing B2B CAC payback?

If your enterprise sales cycle averages 60 to 90 days, today's closed New ARR was generated by last quarter's marketing and SDR spend.

Learn more

Related guides and background articles for this task