NetSuite ARR and MRR Reporting
NetSuite stores revenue at the invoice and revenue plan level, not the subscription level. There is no native ARR or MRR report. SuitePacific builds the SuiteQL queries, saved searches, and dashboard portlets that calculate subscription revenue metrics directly from your billing data.
NetSuite-certified · SaaS specialists · Month-to-month
Last updated September 2026
ARR and MRR reporting in NetSuite refers to the saved searches, KPI tiles, and scripts that calculate Annual Recurring Revenue and Monthly Recurring Revenue from active subscription records rather than from cash receipts or billed invoices. Standard NetSuite does not include native ARR/MRR calculations; revenue metrics must be derived from SuiteBilling subscription data or custom transaction fields.
Quick answer
SuitePacific builds ARR and MRR reporting for SaaS companies running NetSuite. NetSuite stores subscription revenue at the invoice and revenue plan level, not the subscription level, which means there is no native ARR or MRR report. Finance teams typically export data monthly to spreadsheets to calculate bookings, churn, expansion, and contraction, because the aggregation logic requires joining billing, subscription, and customer records across multiple NetSuite record types. SuitePacific builds the saved searches, SuiteQL queries, and dashboard KPI portlets that calculate ARR and MRR directly from SuiteBilling and invoice data, so subscription revenue metrics are available in real time rather than at the end of the month. Cohort reports, churn analysis, and expansion revenue tracking are built on the same foundation. Oracle-certified (SuiteCloud Developer II and Administrator Professional). Plans start at $799 per month on month-to-month terms after a three-month minimum.
Why is ARR and MRR reporting difficult in NetSuite?
NetSuite was not designed around the SaaS subscription data model. These are the reporting gaps that SaaS finance teams hit most often.
Finance exports to spreadsheets every month to calculate ARR and MRR
NetSuite has no native ARR or MRR report. Revenue data is stored at the invoice and revenue plan level, not the subscription level. Finance teams pull billing data each month, join it to customer records in a spreadsheet, and calculate the subscription revenue metrics manually. The process takes hours and produces a number that is already a week old.
Churn, expansion, and contraction require multi-record joins that saved searches cannot express natively
Net revenue retention requires comparing the ARR at the start of a period to the end, broken down by churn, expansion, contraction, and new business. NetSuite stores this data across subscription records, invoice records, and customer records in a structure that requires SuiteQL to join correctly. Standard saved searches cannot express the period-over-period comparison needed.
Revenue dashboards show accounting totals, not subscription metrics
The standard NetSuite dashboard shows recognized revenue, cash collected, and AR aging. It does not show ARR, MRR, churn rate, or logo retention. Finance and leadership look at different numbers from different sources because subscription metrics have to be calculated outside the system.
SuiteBilling data is separate from the revenue recognition data in ARM
Companies running SuiteBilling and Advanced Revenue Management have billing data in SuiteBilling and recognition data in ARM, but ARR is neither: it is calculated from the contracted subscription value, which lives in the subscription record. Pulling a correct ARR figure requires understanding which record holds the contracted value and how SuiteBilling charges relate to it.
Cohort analysis is done manually or not at all
Cohort analysis requires knowing when a customer first became active, what their ARR was at each renewal, and whether they churned or expanded. That data exists in NetSuite across customer, subscription, and invoice records. Without a query that joins all three and groups by cohort start period, the analysis gets done in Excel once a year for a board presentation.
Month-end subscription reconciliation is a manual process
At month-end, the number of active subscriptions times the average contract value should reconcile to the opening ARR plus new bookings minus churn. When that reconciliation fails, finance has to trace each discrepancy manually. A SuiteQL-based reconciliation report that runs in real time eliminates the month-end scramble.
What does SuitePacific build for ARR and MRR reporting?
SuiteQL queries for ARR and MRR calculated from the billing data model
We write SuiteQL queries that calculate ARR and MRR by aggregating subscription charge amounts, normalizing to a monthly or annual cadence, and joining to the customer record. The queries account for SuiteBilling charge frequency fields so that a quarterly billed subscription is correctly annualized to ARR rather than treated as a single-period charge.
Dashboard KPI portlets for real-time subscription revenue metrics
We configure dashboard portlets that display ARR, MRR, new ARR, churned ARR, and expansion ARR as live KPIs. The portlets pull from the SuiteQL queries so the metrics are current as of the last billing run, not the last spreadsheet export.
Churn, expansion, and contraction saved searches using period-over-period comparison
We build the saved searches and SuiteQL queries that calculate net revenue retention by comparing beginning-of-period ARR to end-of-period ARR for each customer cohort. The output is a table of churned ARR, expansion ARR, contraction ARR, and new ARR for any selected period.
Cohort reports and customer-level subscription history
We build a customer-level subscription history view that shows each customer's ARR at each renewal date. Cohort grouping by first active date allows the standard SaaS cohort retention chart to be reproduced directly in NetSuite for the first time.
Which subscription metrics does SuitePacific build in NetSuite?
The following metrics are calculated from SuiteBilling and invoice data using SuiteQL queries.
| Metric | How it is calculated | Use |
|---|---|---|
| ARR | Subscription charge amount normalized to annual cadence | Board reporting, investor metrics |
| MRR | Subscription charge amount normalized to monthly cadence | Finance reconciliation, monthly close |
| New ARR | ARR from customers whose first charge falls in the period | Sales performance, bookings tracking |
| Churned ARR | ARR from subscriptions cancelled during the period | Customer success, churn analysis |
| Expansion ARR | ARR increase from existing customers due to upgrades or add-ons | Net revenue retention calculation |
| Contraction ARR | ARR decrease from existing customers due to downgrades | Net revenue retention calculation |
| Cohort retention | ARR at each renewal date by customer cohort start quarter | Investor reporting, product health |
Why SuitePacific for ARR and MRR reporting
SaaS subscription reporting requires both NetSuite expertise and an understanding of the SaaS metrics model.
Most NetSuite support teams can build saved searches and dashboards. Fewer understand how SuiteBilling stores subscription contracts, how charge frequency affects ARR normalization, or how to express a period-over-period cohort comparison in SuiteQL. SuitePacific works exclusively with post-go-live NetSuite accounts and has specific experience with SuiteBilling and the subscription data model.
- → Oracle NetSuite Certified SuiteCloud Developer II and Administrator Professional
- → Deep experience with the SuiteBilling data model: subscription, charge, and frequency records
- → SuiteQL queries that calculate ARR, MRR, churn, expansion, and cohort metrics natively in NetSuite
- → Direct access to the developer doing the work, not a support queue
- → US-based, month-to-month after a three-month minimum, starting at $799/month
Related: NetSuite for SaaS companies and NetSuite SuiteBilling support.
Get ARR and MRR live in NetSuite
Tell us what metrics you need and where your subscription data currently lives. We'll scope the build and outline what the reporting looks like before any engagement starts.
Related reading
- NetSuite SuiteBilling Support
Troubleshooting SuiteBilling charge generation, change order errors, and ARM integration gaps.
- NetSuite ARM Configuration
ASC 606 and IFRS 15 revenue recognition configuration on top of SuiteBilling data.
- NetSuite Saved Searches and Dashboards
Custom saved searches, SuiteQL queries, and dashboard portlet builds across all record types.
- NetSuite for SaaS and Technology Companies
How SuitePacific supports the full SaaS billing and reporting stack in NetSuite.
- NetSuite Subscription Management
Subscription lifecycle automation: renewals, upgrades, downgrades, and cancellation workflows.
Frequently Asked Questions
Which NetSuite firm does ARR and MRR reporting?
SuitePacific builds ARR and MRR reporting for SaaS companies on NetSuite. The engagement covers SuiteQL queries that calculate ARR and MRR from SuiteBilling and invoice data, dashboard KPI portlets for real-time subscription revenue metrics, churn and expansion analysis, cohort reports, and reconciliation between the subscription book and billing records. SuitePacific is Oracle NetSuite Certified (SuiteCloud Developer II and Administrator Professional), US-based, and works directly with finance and operations teams. Plans start at $799 per month on month-to-month terms after a three-month minimum.
Why does NetSuite not have a native ARR or MRR report?
NetSuite is a general-purpose ERP. It stores revenue at the transaction level: invoices, charges, and revenue plans. ARR and MRR are subscription metrics that require aggregating those transactions by customer and billing period, normalizing to a monthly or annual basis, and comparing across periods. NetSuite does not have a native concept of ARR or MRR as a record type; those metrics must be calculated by querying the billing data. SuiteQL (the SQL-like query language available in NetSuite) can express the calculation, but it requires understanding the SuiteBilling data model and the relationships between subscription, charge, and invoice records.
What is SuiteQL and why is it needed for subscription metrics?
SuiteQL is a SQL-like query language that runs against the NetSuite database. Standard saved searches use a filter-and-group-by model that cannot express period-over-period comparisons, joins across more than a few record types, or subqueries. ARR and MRR calculations require comparing a subscription's charge amount to prior periods, joining the subscription record to the invoice record and the customer record, and normalizing charge frequency to an annual basis. SuiteQL can express all of these; standard saved searches cannot. SuitePacific writes and maintains the SuiteQL queries as part of the reporting build.
We use SuiteBilling. Does that make ARR reporting easier or harder?
SuiteBilling stores the subscription contract in the subscription and subscription line records, which makes the contracted value accessible in SuiteQL. That is an advantage over accounts that use manual invoicing, where the contracted value has to be inferred from invoice history. The challenge with SuiteBilling is that the charge frequency (monthly, quarterly, annual) is stored separately from the charge amount, so normalizing to ARR requires joining the charge record to the billing frequency field and applying the correct multiplier. We account for this in the SuiteQL queries.
Can these reports be used by the CFO and finance team without SuiteQL access?
Yes. The SuiteQL queries run as the data source for NetSuite saved searches and dashboard portlets. Once built, the reports and portlets appear as standard NetSuite views. The CFO and finance team access them from their dashboards without needing to know that SuiteQL is running underneath. Saved searches can be exported to Excel or shared as scheduled report emails the same way any other NetSuite report can.
Do you also help with the ARM side of revenue reporting, or only the subscription metrics?
Both. ARR and MRR are subscription billing metrics; recognized revenue and deferred revenue are accounting metrics from Advanced Revenue Management. For companies running both, we can build reporting that shows the subscription book (ARR), the billing schedule (invoiced amounts), and the recognition schedule (deferred and recognized revenue) in a single dashboard so finance can see all three views at once. The ARM configuration side is covered under our separate ARM engagement.
Replace your spreadsheet with live NetSuite reports
If your finance team is calculating ARR in a spreadsheet each month, we can move that calculation into NetSuite. Same-day response.