How to build a subscription revenue dashboard
Build a subscription revenue dashboard from a billing export, reconcile monthly recurring revenue, and identify the customers behind growth and churn.
Free app. Runs on your Mac with the Claude or Codex plan you already have.
What a subscription revenue dashboard is
A subscription revenue dashboard shows how much recurring revenue you have at each monthly close and what changed since the last one. Its base measure is monthly recurring revenue, or MRR, the monthly value of active paid subscriptions. The dashboard links the opening balance to the closing balance through movements you can trace to customers. That lets a founder see whether acquisition, changes within existing accounts, or returning customers drove the month, even when several of those movements offset one another.
An MRR dashboard begins with a billing export that covers the reporting window. A monthly snapshot answers how much recurring revenue was active on one date. A history of subscription starts, ends, and price changes lets you explain why that amount moved. The dashboard and its supporting tables are a draft for qualified finance review. Compare their definitions with your company’s reporting definitions before using them in a board pack, investor update, or operating plan.
What it does for the business
- Find the right retention workUse the loss categories to decide who needs to follow up. Cancellations may call for exit conversations, while downgrades may warrant a review of what customers use and why they move to a lower plan.
- Plan with the actual sources of growthCompare revenue from new accounts, expansions, and returning customers before assigning work for the next month. A team with a strong base of expanding accounts can investigate which changes those customers made and what helped them make the change.
- Prepare for renewal exposureA revenue concentration view shows where individual accounts have a material effect on the closing balance. Pair it with the renewal calendar and give the account team time to confirm adoption, decision makers, and open issues.
- Explain the month consistentlyA reconciled bridge gives finance, sales, and customer success a shared explanation for the change. Each team can review the same customer movements when it prepares updates or proposes a response.
Subscription revenue dashboard, step by step
Set the reporting window and read the export
The history you can explain depends on the history your export contains.
What to do
- Pick the reporting currency views, first month, and as-of date. Use the end of a complete month for regular comparisons and mark any explicitly requested partial month in the title and notes.
- Find the stable customer and subscription identifiers, price, interval, quantity, and effective start and end dates. Check how the export records trial endings, cancellations, and successive price periods for a subscription.
- Confirm the date format and whether prices are in minor units such as cents. Inspect a few rows against their column definitions, especially if the file includes mixed intervals or periods that overlap for the same subscription.
- Preserve the original file and document its coverage. Identify active-only exports and exports that have a single current price per subscription, since each loses a different part of the history.
Why
An export filtered to today’s active subscribers can make prior losses disappear. A price overwritten in place can make expansion and contraction invisible. Catching these limits before calculation lets you choose a defensible period and keeps a tidy-looking dashboard from implying complete coverage.
Calculate recurring revenue and reconcile movements
Every movement has to explain a change in the recurring balance.
What to do
- Convert each eligible recurring price to a monthly value using its billing interval and quantity. Exclude one-time charges, tax, and usage from the defined recurring base, and begin counting eligible trial subscriptions when the trial ends.
- Aggregate eligible subscription values by customer at each monthly close before assigning movements. Check whether a customer who dropped one subscription kept another paid subscription, since that can be a contraction instead of a cancellation.
- Classify increases as new customer revenue, expansion, or reactivation of a former customer. Classify losses as contraction, also called downgrade, or churn when the customer leaves the paid recurring base.
- Reconcile the MRR bridge in each month and currency by adding the signed movements to opening MRR and comparing with closing MRR. Calculate annual recurring revenue as twelve times MRR, and keep rounding to the display layer.
Why
Annual invoices can produce a large cash receipt in a single month even when the subscription value is steady. Monthly normalization makes those contracts comparable with monthly contracts. A bridge tie-out catches missing movements or duplicated amounts before they influence the business narrative.
Find the movements that deserve attention
A useful finding connects a change in the balance to the customers behind it.
What to do
- Compare opening and closing MRR over the window, then compare recent complete periods with the complete periods before them. Identify months where the direction changed and look up the movements behind those months.
- Trace the largest losses and gains to customer records. Check whether the change came from one large contract, several similar plan changes, or a broader mix before deciding what question to investigate.
- Measure net revenue retention on a starting customer cohort, a fixed group of customers with recurring revenue at the beginning of the comparison. Review gross revenue retention, which excludes expansion gains, and logo churn, which counts lost customer accounts.
- Check the share of closing MRR held by the largest customers within each currency. Give each finding a month, a source-backed figure, and one action someone can take, with explanations of cause labeled as judgments.
Why
New sales can lift total MRR while the starting customer base shrinks. Cohort measures make that pattern visible, and gross retention shows whether expansion is offsetting losses. Customer-level evidence also helps you decide whether to review a shared plan or speak with a specific account team.
Review the figures against the calculation outputs
A reader should be able to trace each displayed figure to one calculation output.
What to do
- Have a reviewer trace each amount, rate, and period in the draft to its supporting table. Include the headline, chart, and any figure repeated in the accompanying summary.
- Check the sign and category of each cited movement, along with the currency, period, and customer. Compare the headline with the confirmed bridge to ensure it describes the same reporting window.
- Inspect exclusions for material gaps. If the missing rows or omitted history affect an interpretation, label the affected metric and name the export or field that would resolve the gap.
Why
The calculation can be correct while the write-up quotes the wrong row or assigns a loss to the wrong category. Checking the draft against the calculation files catches errors introduced during interpretation. Reviewing exclusions also shows which decisions need more evidence.
Deliver the dashboard for finance review
Show the balance, the bridge, and the limits together.
What to do
- Open with the most important supported finding, including the period it describes. Show closing MRR over time and put the movement bridge beside it so readers can see how each closing balance was reached.
- Show each currency in its own monthly table. Include recurring revenue, the movement categories, churn, retention, and the definitions for your reporting basis.
- Hand off the draft with its source version, cutoff, exclusions, and unresolved issues. Ask the finance reviewer to check the assumptions and confirm which metrics are appropriate for the intended audience.
Why
A chart gives readers the direction quickly. The supporting table answers what moved, and the definitions explain how to compare that month with the next one. Keeping exclusions close to the results gives the reviewer enough context to decide what the dashboard can support.
Common mistakes
- Treating invoice value as MRRNormalize recurring prices to their monthly equivalent so annual billing cycles do not dominate the operating trend.
- Combining currencies at face valueKeep balances and movements in their original currency unless a documented conversion basis supports a separate combined view.
- Calling every canceled subscription a lost customerCheck the customer’s remaining paid subscriptions before classifying the movement.
- Including new sales in cohort retentionFreeze the starting cohort and measure changes in recurring revenue for that group.
- Reporting a complete churn trend from active recordsShow churn as unavailable when the export omits the records needed to observe cancellations.
What a good result looks like
- Every table names its currency, period, and as-of date.
- Each monthly bridge reconciles and retains the signs of the movements.
- The churn and retention measures explain which customers enter each denominator.
- Material findings point to specific months and identifiable customer movements.
- The handoff flags excluded rows, gaps in price history, and any incomplete periods.
And then what? Using the result
- Ask the finance reviewer to check the definitions and reconcile the draft to the reporting sources before circulating the figures.
- Give customer success the affected accounts for the largest downgrade or cancellation category and agree on which conversations to have first.
- Use the month’s growth mix to brief sales on the sources of recurring revenue worth investigating for the next planning cycle.
- Add concentrated accounts to the renewal review and ask each owner to confirm the upcoming decision date and any adoption concerns.
When to run it
- During the monthly closeUse the complete month to explain recurring changes while finance prepares the separate accounting and cash figures. Save the cutoff and definitions so the next close can use the same basis.
- Before reviewing retentionBring the cohort figures and loss movements to the review. Check which accounts stopped paying and which stayed on a smaller plan before deciding what to investigate.
- When billing reports disagreeUse a defined export, month, and currency to locate where the numbers diverge. Check tax, usage, and billing interval before attributing the difference to a customer movement.
Questions people ask
What should a subscription revenue dashboard include?
Include closing MRR over time, a monthly bridge of gains and losses, churn and retention, and the definitions and coverage behind those measures. Show individual currency views and cite the customer movements that explain the highest-priority findings.
How do you calculate MRR for annual subscriptions?
Divide the eligible annual recurring charge by twelve to get its monthly equivalent. Apply the quantity and any relevant price period using a consistent basis, and exclude one-off fees and tax from the recurring charge.
What is the difference between MRR and cash receipts?
MRR expresses recurring subscription value on a monthly basis, while cash receipts reflect when customers actually pay. An annual prepayment can arrive all at once even though the monthly subscription value stays steady.
Can you measure churn from an active subscriptions export?
An active-only export generally lacks the canceled records needed to measure churn. Use the file for supported current values and request an all-subscriptions export with cancellation or end dates for a historical view.
How do you handle multiple currencies in an MRR dashboard?
Build a separate bridge and closing balance for each currency. If you prepare an additional converted view using supplied rates, document the rate basis and retain the original figures.
Can one subscription row show upgrades and downgrades?
A current-price row alone cannot show earlier prices that were overwritten. Use effective-dated price history to see when paid value rose or fell, and state the gap when the history is unavailable.
More jobs in Finance
Build a subscription revenue dashboard, on your own Mac.Free app. Runs on your Mac with the Claude or Codex plan you already have. Your files stay on your computer.
Download for Mac