1. SaaSGrid Help Center
  2. Data Sources
  3. Files (Excel or Sheets Template)

Using Files

How to determine what to input into the SaaSGrid template.

SaaSGrid utilizes a best-in-class methodology for SaaS KPIs, while also providing the flexibility to support a wide range of analyses and business models. This documentation covers in detail how each metric is calculated so start-ups can have full confidence in their numbers.

SaaSGrid is designed to support subscription or usage/transaction based software revenue, and currently does not support future projections. Because SaaSGrid is focused on SaaS KPIs, the relevant revenue values may diverge from GAAP revenue. When filling out revenue in the SaaSGrid template, use the following guidelines:

For subscription models, input Monthly Recurring Revenue (MRR) as of the end of each month. Some examples:

  • A customer pays $1200 for a 1 year contract, starting in January: Input $100 for each month starting in January.
  • A customer pays $1200 for a 1 year contract, starting in January, but in July pays an additional $600 to update their contract for the rest of the year: Input $100 per month for January - June, and $200 per month starting in July.
  • A customer pays $10 per user per month. In January, they have 2 users; halfway through February, they add 2 additional users: Input $20 for January and $40 for February, even if the amount the customer is charged for the month of February is <$40. In other words, ignore pro-ration and use the end of month’s MRR.

For usage or transaction based models, input the net revenue accrued in the month. Some examples:

  • A customer pays $1 per API call, and uses 500 API calls in January: Input $500 for January.
  • A customer pays $1 per API call and uses 500 API calls in January, but their contract dictates they have a $750/month minimum: Input $750 for January.
  • A customer pays 1% of their sales each month. In January, their sales are $50,000: Input $500 for January.

The inputted revenue figure, regardless of whether it is MRR or net revenue, will be referred to as “revenue” in the below KPI definitions. “New revenue” will refer to the inputted revenue figure for customers who have never produced revenue in a previous period. Similarly, “new customers” are customers with inputted revenue in a given month and no revenue in any previous month.