Getting Started

Product Catalog

Customers

Subscriptions

Invoices, Credit Notes and Quotes

Taxes

Payments

Site Configuration

Data Privacy & Security

Data Operations

Reports and Analytics

Integrations

Sample Reports 

RevenueStory's Report Builder capability allows you to create reports on your own. We have curated a few essential reports that you can create using Report Builder.

Sales by Country 

This Summary report displays the total revenue earned each month across different countries.

We are now going to see how to build this report.

  1. Click RevenueStory > Report Builder.

  2. Select Create a Summary Report.

  3. Choose the primary Data Source as Invoices.

  4. Select Paid on field (group them as Year and Month) from Invoices under Column grouping and Country from the Customers data source under Row grouping.

  5. Select the Amount Paid field from Invoices to aggregate the report and apply sum function on it.

  6. Click Build Report.

  7. Next, let us add the Invoice Status (Paid) and Invoice paid on filter.

  8. This is how the report will look like.

Revenue by Customer 

As a business owner, you'd want to see the revenue generated for each customer. We are now going to see how to build this report.

  1. Click RevenueStory > Report Builder.

  2. Select Create a Summary Report.

  3. Select the primary Data Source as Invoices.

  4. Select Company from the Customers data source under Row grouping.

  5. Select the Amount Paid field from Invoices to aggregate the report and apply sum function on it.

  6. Click Build Report. This is how the report will look like.

Total Cancelations plan wise each month 

This report will allow you to see the total number of cancelations month wise from each plan.

  1. Click RevenueStory > Report Builder.

  2. Select Create a Summary Report.

  3. Select the primary data source as Subscriptions.

  4. Select Canceled on field from Subscriptions (grouped them as Year and month) under Column grouping and Current plan from the Subscriptions data source under Row grouping.

  5. Select the Subscription ID from Subscriptions data source to aggregate the report and apply *Count * function on it.

  6. Click Build Report. This is how the report will look like.

Due Invoices by Customer 

The Due Invoices report allows you to view the invoices that are in Due State by customer. Let us now see how to create this report.

  1. Click RevenueStory > Report Builder.

  2. Select Create a Detailed Report.

  3. Select Next Billing on, Subscription status, Subscription ID from the Subscriptions data source, Amount Due, Due Date, Invoice ID, Status from Invoices data source, Email from the Customers data source.

  4. Select Build Report. Next, add the Invoice Status (Payment Due), Invoices Due Date, Subscription Status (Active) as filters.

  5. This is how the final report will look.

MRR (Monthly Recurring Revenue) by country (month on month trend) 

This report displays the MRR trend across countries. To create this report:

  1. Click RevenueStory > Report Builder.

  2. Select Create a Summary Report.

  3. Select "Monthly Subscription History" as your base datasource.

  4. In Row grouping, add Country from Customers datasource.

  5. In Column grouping, add MRR Changed Date from Monthly Subscription History and group by Month and Year.

  6. In Summarization (aggregation/measure), add MRR (Monthly) from Monthly Subscription History and aggregate using the Sum function.

  7. Click Build Report

Contraction MRR or expansion MRR by customer 

This report displays the contraction or expansion MRR trend on a yearly basis. To create this report:

  1. Click RevenueStory > Report Builder.

  2. Select Create a Summary Report.

  3. Select "Yearly Subscription History" as your base datasource.

  4. In Row grouping, Country and Customers from the Customers datasource.

  5. In Column grouping, add MRR Changed Date from Yearly Subscription History and group by Year. ( this is the historical date associated with MRR)

  6. In Summarization (aggregation/measure) add MRR (Yearly) from Yearly Subscription History and aggregate using the Sum function.

  7. Click Build Report
    We are now going to filter the report to display the Expansion MRR or Contraction MRR. Select MRR Impact Status from Yearly Subscription History. Apply the filter.

Was this article helpful?
Loading…