Introduce MRR in the dashboard view

🔍 Problem Statement

Pelcro currently does not display a Monthly Recurring Revenue (MRR) metric in the Overview dashboard.

Subscription businesses need quick visibility into their recurring revenue performance without relying on external tools or detailed reports.

💡 User Story

As a business operator using Pelcro,

I want to see Monthly Recurring Revenue (MRR) in the Overview dashboard,

so that I can quickly understand the health and growth of my recurring subscription business.

🎯 Definition of Done (DoD)

A feature is done when:

✔ An MRR summary card is added to the Overview dashboard.

✔ The card displays the current normalized monthly recurring revenue.

✔ Billing intervals are normalized into monthly values:

1. Monthly plans → full monthly amount

2. Quarterly plans → amount ÷ 3

3. Annual plans → amount ÷ 12

4. Daily plans → daily amount × 30

✔ Only recurring subscription revenue is included in MRR calculations.

✔ One-time charges, taxes, and non-recurring purchases are excluded.

✔ Discounts applied to subscriptions are reflected in the MRR value.

✔ Invalid subscription states are excluded from MRR calculations, including:

1. Canceled

2. Expired

3. Incomplete

4. Unpaid subscriptions outside the grace period

✔ Currency formatting follows the merchant’s reporting currency settings.

✔ Empty states are handled correctly and display:

1. “$0 MRR”

✔ A tooltip/help text explains the MRR definition.

Suggested tooltip:

“Monthly Recurring Revenue (MRR) represents the normalized monthly value of active recurring subscriptions.”