How to Track Revenue Growth Rate in a Dashboard

Revenue growth rate is the most fundamental indicator of business health — every other metric is context for understanding whether and why revenue is growing.

Revenue Growth Rate Formulas

Month-over-Month (MoM) Growth:

MoM Growth = ((This Month Revenue - Last Month Revenue) ÷ Last Month Revenue) × 100

Year-over-Year (YoY) Growth:

YoY Growth = ((This Month Revenue - Same Month Last Year) ÷ Same Month Last Year) × 100

Compound Annual Growth Rate (CAGR) — for multi-year trends:

CAGR = (Ending Revenue ÷ Starting Revenue)^(1/n) - 1

Where n = number of years.

Why You Need Both MoM and YoY

MoM growth tells you the immediate trend but is noisy due to seasonality. In an Indian retail business, December might show +20% MoM (Diwali effect fading, Christmas boost) while February shows -15% MoM — but both could represent excellent YoY growth.

YoY growth removes seasonality by comparing the same period last year, giving a cleaner signal of underlying business growth. A business growing 25% YoY every month for 12 months is clearly on a strong trajectory.

Use MoM for: Operations, identifying immediate problems, tracking the impact of recent changes.
Use YoY for: Strategy, investor reporting, long-term trend evaluation.

Building a Revenue Growth Dashboard

Core Revenue Growth Metrics

For immediate visibility:

• Current month revenue vs last month (MoM change %)
• Current month revenue vs same month last year (YoY change %)
• MTD revenue vs MTD last year (running YoY for the current month)

For trend analysis:

• 12-month revenue trend chart (bar chart with YoY comparison)
• Rolling 3-month growth rate (smoothed)
• Revenue run rate (current month annualised)

Revenue Growth Decomposition

Total revenue growth is the sum of:

• Existing customer growth: Are existing customers buying more?

• New customer contribution: Revenue from customers who didn't exist in the prior period

• Lost customer impact: Revenue decline from churned customers

  Total Growth = Existing Customer Growth + New Customer Growth - Churned Customer Loss

Practical example:

• Last year's customers (those still active): grew 8%
• New customers acquired this year: contributed 15% of today's revenue
• Churned customers: lost 5% of last year's revenue base
• Net result: +18% total revenue growth

This decomposition shows whether growth is coming from acquiring new customers, growing existing ones, or both — and whether churn is a meaningful offset.

Revenue Growth by Segment

Break down growth rate by:

• Product category (which products are growing fastest)
• Customer segment (which customer types are growing)
• Geography (which regions are growing)
• Channel (which distribution channels are growing)

The overall growth rate is the average — segment analysis reveals where to focus for acceleration.

Revenue Growth Analytics from Tally

Tally's sales ledger contains the data needed for revenue growth analysis. With a BI tool connected to Tally:

• Monthly revenue automatically calculated from invoice data
• YoY and MoM calculations performed automatically
• Drill-down to product-level and customer-level growth contributors
• Forecast integration for projected growth

See how to build financial dashboards for the comprehensive financial dashboard setup guide.