metrics

Razorpay Business Metrics

Calculate key SaaS metrics from your Razorpay subscription and payment data. Includes both database queries (fast, for dashboards) and API-based approaches (accurate, for reconciliation).

MRR (Monthly Recurring Revenue)

Database Approach (Fast)

// lib/metrics/mrr.ts
import { db } from "@/lib/db";

interface MRRResult {
  mrr: number;          // in paise
  mrrDisplay: string;   // formatted in rupees
  activeCount: number;
  breakdown: { planKey: string; count: number; mrr: number }[];
}

export async function calculateMRR(): Promise<MRRResult> {
  // Query active subscriptions with plan details
  const subscriptions = await db.subscription.findMany({
    where: { status: "active" },
    select: {
      planKey: true,
      amount: true,       // amount in paise
      period: true,        // "monthly" | "yearly"
    },
  });

  let totalMRR = 0;
  const planMap = new Map<string, { count: number; mrr: number }>();

  for (const sub of subscriptions) {
    // Convert yearly to monthly contribution
    const monthlyAmount = sub.period === "yearly"
      ? Math.round(sub.amount / 12)
      : sub.amount;

    totalMRR += monthlyAmount;

    const existing = planMap.get(sub.planKey) || { count: 0, mrr: 0 };
    planMap.set(sub.planKey, {
      count: existing.count + 1,
      mrr: existing.mrr + monthlyAmount,
    });
  }

  const breakdown = Array.from(planMap.entries()).map(([planKey, data]) => ({
    planKey,
    ...data,
  }));

  return {
    mrr: totalMRR,
    mrrDisplay: `₹${(totalMRR / 100).toLocaleString("en-IN")}`,
    activeCount: subscriptions.length,
    breakdown,
  };
}

Razorpay API Approach (Accurate)

// lib/metrics/mrr-api.ts
import { razorpay } from "@/lib/razorpay";

export async function calculateMRRFromAPI(): Promise<number> {
  let totalMRR = 0;
  let skip = 0;
  const count = 100; // max per request

  // Fetch all plans first to know their periods
  const plansRes = await razorpay.plans.all({ count: 100 });
  const planPeriods = new Map<string, string>();
  for (const plan of plansRes.items) {
    planPeriods.set(plan.id, plan.period); // "monthly" | "yearly" | "weekly" | "daily"
  }

  // Paginate through all active subscriptions
  while (true) {
    const res = await razorpay.subscriptions.all({ count, skip });
    const active = res.items.filter((s: any) => s.status === "active");

    for (const sub of active) {
      const plan = await razorpay.plans.fetch(sub.plan_id);
      const amount = plan.item.amount * (sub.quantity || 1);

      // Normalize to monthly
      const period = planPeriods.get(sub.plan_id) || plan.period;
      if (period === "yearly") {
        totalMRR += Math.round(amount / 12);
      } else if (period === "weekly") {
        totalMRR += Math.round(amount * 4.33);
      } else if (period === "daily") {
        totalMRR += Math.round(amount * 30);
      } else {
        totalMRR += amount; // monthly
      }
    }

    if (res.items.length < count) break;
    skip += count;
  }

  return totalMRR; // in paise
}