Monthly Revenue Report
Finance · monthly
Detected metrics from this report. Match each to a governed metric in the library, or create one.
Formula & definition
Custom formula found in the upload
SUM([Gross Bookings]) - SUM([Refunds])
Calculated field · used in "Revenue Summary"
Extracted definition
Total revenue booked in the period, net of refunds.
Governed metric · Revenue
SUM(recognized_subscription_revenue + services_revenue) − refunds − credits
Revenue is the total recognized income earned from customer subscriptions, expansion, and professional services within a reporting period, net of refunds and credits. It follows finance's recognition policy and excludes bookings not yet delivered.
Formula & definition
Custom formula found in the upload
[Total Revenue] - SUM([Discounts]) - SUM([Credits])
Calculated field · used in "Revenue Summary"
Extracted definition
Revenue after discounts and credits are applied.
Governed metric · Net Revenue
Revenue − discounts − partner_revenue_share
Net Revenue subtracts discounts, refunds, and partner revenue-share from gross recognized revenue to reflect the income Northwind actually keeps.
Formula & definition
Custom formula found in the upload
SUM([Subscription Amount]) / [Contract Months]
Calculated field · used in "Recurring"
Extracted definition
Monthly recurring revenue normalized from active subscriptions.
Governed metric · Monthly Recurring Revenue
SUM(active_subscription_amount normalized to 1 month)
MRR is the predictable subscription revenue normalized to a monthly amount. Annual contracts are divided by 12; it excludes one-time services and usage overages.
Formula & definition
Governed metric · Annual Recurring Revenue
MRR × 12
MRR expressed on an annualized basis (MRR × 12).