Revenue by Item (Power BI Report)

The Revenue by Item report gives a clear picture of your organization's subscription item sales. It showcases key metrics for each item or item category. For example, the monthly recurring revenue, monthly recurring cost and net monthly recurring profit.

Use the report

The Revenue by Item report provides a clear overview of the monthly recurring revenue (MRR) generated by individual items and item categories. It helps users understand which products contribute most to recurring income and how profitable these products are.

Sales managers can use the Revenue by Item report to monitor how recurring revenue performs at product and item-category level. By comparing MRR and net recurring profit across items, they can identify products that generate stable, high-margin revenue versus items that drive volume but low profitability. This information helps sales managers steer the sales focus toward more profitable subscription offerings, adjust incentive models, and prioritize items when defining sales targets or campaigns.

Salespeople can use the report to understand which subscription items generate the most recurring revenue. By reviewing item-level MRR and profitability, they can focus their conversations on high-value products, confidently recommend premium or higher-margin items, and identify opportunities to expand existing subscriptions.

Key performance indicators

• Mon. Recurring Revenue
• Mon. Recurring Cost
• Mon. Net Profit Amount
• Mon. Net Profit Percentage

Click on the link for a KPI to learn more about what it means, how it is calculated, and what data was used in the calculations.

Data used in the report

The report uses data form the following tables in Business Central:

• Subscription Contract Analysis Entries
• Item

Related information

Track your business KPIs with Power BI metrics
Setting up the Subscription Billing Power BI app
Subscription Billing controlling
Subscription Billing overview