Podcast Summary: Metrics That Measure Up

Episode: Evolving from Excel for SaaS Financial and Metrics Reporting
Host: Ray Rike
Guest: Ali Rizvi, Founder and CEO, TrueRev
Date: May 24, 2023

Overview of Episode's Main Theme

This episode features a deep dive into the common pitfalls B2B SaaS companies encounter when using Excel for financial and metrics reporting, especially for revenue recognition, and when it makes sense to transition to purpose-built software. Host Ray Rike and guest Ali Rizvi explore real-world scenarios, ASC 606 compliance challenges, and top metrics for early-stage SaaS companies. The conversation covers practical advice for founders scaling from $0M to $5M ARR, the value of process rigor, metrics consistency, and the importance of preparation when engaging investors or auditors.

Key Discussion Points and Insights

1. Signs It’s Time to Move Beyond Excel for SaaS Revenue Recognition

[03:15 – 08:22]

• Ali’s firsthand auditor experience: Many SaaS companies, even those with substantial backing, run complex rev rec processes on Excel, opening themselves to errors and misstatements.
  • "Tens of thousands of rows in a spreadsheet, multiple worksheets, formulas everywhere, macros, Pivots, you name it, errors throughout... It literally took 10 minutes just to open the damn thing." – Ali Rizvi [01:50]
• Who, where, and how calculations are made is critical:
  • Excel manages revenue recognition by default, but as deal volume and complexity grow, spreadsheets can’t keep pace.
• Initial red flags: Including multiple revenue streams (SaaS + services), manual calculations, lack of resource expertise, and investor pressure for reliable numbers.

2. Why Simple “Divide by 12” Revenue Recognition Isn’t Enough

[05:01 – 06:42]

• Many founders incorrectly split ACV evenly across 12 months for MRR, not accounting for nuances like mixed contracts, bundled services, and non-standard deal schedules.
• Errors multiply as contracts involve professional services, one-off fees, or irregular start dates.
  • "These are small sort of issues which seem small at the time, but they end up leading to numbers that are not accurate." – Ali Rizvi [05:54]

3. The Real Catalyst for Accurate Rev Rec: External Stakeholders

[06:42 – 09:54]

• Tax filing requires accurate revenue reporting, but pressures most often spike when founders seek investment or credit and need reliable numbers for due diligence.
• Growing ARR brings new scrutiny—founders must understand and defend their GAAP and SaaS metrics.
  • "It starts really surfacing... once you cross into a certain amount of revenue and a growth where others are now looking to see the health of the business." – Ali Rizvi [07:40]
• Having accurate numbers isn’t just about hiring a SaaS accountant—manual systems break as deal complexity and volume increase.

4. ASC 606: Blessing or Curse for SaaS Founders?

[09:54 – 12:41]

• ASC 606 standardizes revenue recognition for contracts but introduces new rigor.
  • "At the earliest stage of a company, it really is... ignorance is bliss, to be honest. If I don't know about it... I'll just keep doing what I'm doing." – Ali Rizvi [10:45]
• Compliance becomes non-negotiable when banks, landlords, or institutional investors require GAAP-compliant financials.
  • "In that rental, landlord, rental agreement, there's probably a provision... that says, we'd like to be able to see your financials... using GAAP." – Ali Rizvi [11:36]

5. Most Important Metrics for Sub-$5M SaaS Companies

[12:41 – 15:19]

• Core SaaS metrics: MRR, ARR are essential—track annual contracts versus monthly.
• Vital financial health metrics: cash burn, runway, outdate, and sales/marketing spend efficiency.
  • "Being hyper focused on [cash], typically for companies at that early stage... there's other metrics that [are] really important... sales and marketing efficiency metrics." – Ali Rizvi [14:18]
• Early pipeline analytics ("lead funnel by stage") are also key, even if imperfect.

6. Challenges in SaaS Metric Calculation—Consistency and Source Data

[15:19 – 20:10]

• No universal approach: Companies differ on formulas for vital metrics like MRR, CAC, Gross Margins. Industry guidance has improved, but ambiguity persists.
• Example complexity: Deals starting mid-month—how to allocate MRR? Ex: $12,000 annual contract starting Jan 15—do you count $1,000 in January, $500, or prorate differently?
  • "Companies stumble along those things..." – Ali Rizvi [16:57]
• CAC definition varies wildly—what’s in the numerator (do you include conferences? sponsorships?).
  • "There's so much variability on how companies will calculate cost of customer acquisition. ...So just the consistency in that calculation is missing." – Ali Rizvi [18:10]
• Software can help, but process education and best practices remain crucial. TrueRev’s tools aim to support customization and help clients adopt sound methodologies.

7. Overrated and Underrated Metrics for Early-Stage SaaS

[20:10 – 22:48]

• Overrated: Gross margin (for very early-stage)—often too noisy and variable to be actionable. Customer Lifetime Value (LTV)/CAC ratio for startups with little retention data.
  • "Gross margins, I think for the earliest stage companies tend to be not as useful just because the variability is significant..." – Ali Rizvi [20:41]
  • "Customer lifetime value is completely meaningless, you know, if you're sort of less than 3 years old..." – Ali Rizvi [22:18]
• Underrated as companies mature: Committed ARR, renewal rates, and Net Promoter Score (NPS).

8. The Essential Metrics TrueRev Itself Tracks

[22:48 – 23:49]

• ARR and ARR retention are always top-of-mind.
• Renewals and NPS growing in importance as customer base grows.
• Marketing and sales spend efficiency closely watched.

9. Peer Inspiration, Tools, and Founding Advice

[23:49 – 26:15]

• Ray and Ali’s “who to follow”: HubSpot—remarkable retention focus and evolution from $5M to $1B ARR.
  • "For me personally, I love the story of HubSpot... it's a great playbook that I think a lot of founders can learn from." – Ali Rizvi [24:11]
• Favorite tool, not TrueRev: ChatGPT, as a huge accelerator for content and ideation even in SaaS ops.
  • "What would take me... a couple of hours to brainstorm... I was able to do it in about 25 seconds with ChatGPT." – Ali Rizvi [25:49]
• Advice to aspiring founders: Build relationships early, develop your community, don’t try to go solo.
  • "It takes a village. I would say. Build relationships, strengthen relationships, develop a community of people you trust. Don't wait. It's never too late to do that." – Ali Rizvi [26:19]
  • "...it takes 10 years to become an overnight success and nothing could be farther from the truth." – Ali Rizvi [27:11]

Notable Quotes and Memorable Moments

| Timestamp | Quote | Speaker |
|---------------|-----------|-------------| | 01:50 | "Tens of thousands of rows in a spreadsheet... errors throughout... It literally took 10 minutes just to open the damn thing." | Ali Rizvi | | 05:54 | "These are small sort of issues which seem small at the time, but they end up leading to numbers that are not accurate." | Ali Rizvi | | 07:40 | "It starts really surfacing... once you cross into a certain amount of revenue... others are now looking to see the health of the business." | Ali Rizvi | | 10:45 | "At the earliest stage of a company, it really is... ignorance is bliss, to be honest." | Ali Rizvi | | 11:36 | "In that rental... there's probably a provision... that says, we'd like to be able to see your financials... using GAAP." | Ali Rizvi | | 14:18 | "Being hyper focused on [cash]... sales and marketing efficiency metrics [are] really, really important." | Ali Rizvi | | 16:57 | "Companies stumble along those things..." | Ali Rizvi | | 18:10 | "There's so much variability on how companies will calculate cost of customer acquisition... consistency in that calculation is missing." | Ali Rizvi | | 20:41 | "Gross margins, I think for the earliest stage companies tend to be not as useful just because the variability is significant..." | Ali Rizvi | | 22:18 | "Customer lifetime value is completely meaningless, you know, if you're sort of less than 3 years old..." | Ali Rizvi | | 24:11 | "For me personally, I love the story of HubSpot... it's a great playbook that I think a lot of founders can learn from." | Ali Rizvi | | 25:49 | "What would take me... a couple of hours to brainstorm... I was able to do it in about 25 seconds with ChatGPT." | Ali Rizvi | | 26:19 | "It takes a village. I would say. Build relationships, strengthen relationships, develop a community of people you trust. Don't wait." | Ali Rizvi | | 27:11 | "...it takes 10 years to become an overnight success and nothing could be farther from the truth." | Ali Rizvi |

Timestamps for Important Segments

• [01:16] – Ali shares how auditor frustration with Excel led him to found TrueRev.
• [03:15] – When do founders need to ditch Excel for revenue recognition?
• [05:01] – The pitfalls of simple "divide by 12" MRR.
• [06:42] – Why getting revenue right matters most when investors enter the picture.
• [09:54] – Demystifying ASC 606 for SaaS founders.
• [12:41] – Top three metrics for <$5M SaaS companies.
• [15:19] – Trouble with SaaS metrics: definitions, timing, and calculation.
• [18:49] – Can software alone solve the metric problem?
• [20:10] – Overrated metrics for early-stage SaaS.
• [22:48] – What TrueRev as a company is watching each month.
• [23:49] – HubSpot as a model SaaS success story.
• [25:22] – Game-changing SaaS tool: ChatGPT.
• [26:15] – Ali’s advice for founders: community, resilience, and patience.

Conclusion: Actionable Takeaways

• Move off Excel for revenue recognition and core metrics tracking once deal complexity or volume crosses the “manual manageable” threshold, or when external scrutiny is likely.
• Don’t underestimate process: Consistent, defendable metric calculations matter more as you raise money or seek credit.
• Master the basics: MRR, ARR, cash burn, and marketing efficiency. Don’t obsess over gross margin or LTV/CAC at the very earliest stage.
• Stay flexible and informed: Use tools that accommodate your business’s nuances; layer in best practices as you scale.
• Build your network: Both for knowledge and support—it takes a village to thrive as a founder.

Recommended Resources from the Episode:

• Model SaaS Playbook: HubSpot’s focus on churn and user experience.
• Essential Tool for Founders: ChatGPT (for content, brainstorming, scaling ops).
• Advice for Aspiring Founders: Cultivate relationships early and don’t go it alone.

This summary aims to offer comprehensive insights and actionable points, preserving the candid and pragmatic tone of Ray Rike and Ali Rizvi’s discussion for founders and SaaS operators at any stage.