NetSuite Analytics and Reporting for Ecommerce KPIs

Disclosure: This article may contain affiliate links. We may earn a referral fee at no cost to you.

Every ecommerce CFO I work with has the same complaint about QuickBooks: they can't see what's happening in their business without exporting data to Excel. Revenue by channel? Export and pivot. Margin by SKU? Export, VLOOKUP the COGS, build a pivot table. Inventory turns? Forget about it — QuickBooks doesn't track the data you need. You end up spending more time building reports than actually analyzing them.

NetSuite's analytics and reporting capabilities are a generation ahead of QuickBooks, but they're also significantly more complex. There are saved searches, financial report builder, dashboards, KPI portlets, SuiteAnalytics Workbook, and the Analytics Warehouse (NSAW) — each serving a different purpose. Understanding which tool to use for which reporting need is the difference between a data-driven operation and an expensive system that generates the same Excel exports you had before.

This guide covers the specific analytics and reporting configurations that ecommerce CFOs need, with practical examples of the dashboards and metrics that actually drive decisions.

Key Takeaways

• Saved searches are the foundation of all NetSuite reporting. Master saved searches and you can answer any question about your business. Ignore them and you'll be frustrated with NetSuite's reporting forever.
• Financial reports use a dedicated report builder separate from saved searches — these are your P&L, balance sheet, and cash flow statement templates with drill-down, comparative periods, and custom columns.
• Dashboards and KPI portlets give real-time visibility without running reports. Configure your dashboard on day one — it's the first screen you see when you log in.
• SuiteAnalytics Workbook is NetSuite's answer to self-service BI — pivot tables, charts, and visualizations built directly on your live data without exporting.
• Analytics Warehouse (NSAW) is a separate data warehouse for complex analytics, historical trends, and large dataset analysis. It's an add-on that costs extra but eliminates the need for a separate BI tool for most mid-market brands.
• Integration with external BI tools (Looker, Tableau, Power BI) is possible via ODBC/JDBC connectors or the Analytics Warehouse API, but most ecommerce brands under $50M don't need an external BI tool if they configure NetSuite's native analytics properly.

How Do Saved Searches Work, and Why Are They So Important?

Saved searches are the Swiss Army knife of NetSuite. They query any record type — transactions, customers, items, cases — with flexible criteria, results columns, formulas, and summary calculations. If you can think of a question about your data, a saved search can answer it.

Here are the saved searches every ecommerce brand should build during implementation:

Revenue by Channel (Daily/Weekly/Monthly):

• Record type: Transaction (Sales Order or Invoice)
• Criteria: Date range, Main Line = Yes, Status = Billed/Fulfilled
• Results: Date (grouped by week or month), Class (your channel dimension), Sum of Amount
• This replaces the "export all orders to Excel and pivot by channel" workflow

Gross Margin by SKU:

• Record type: Transaction
• Criteria: Date range, Main Line = No (line level)
• Results: Item Name, Sum of Amount (Revenue), Sum of Cost (COGS), Formula: (Amount - Cost) / Amount (Margin %)
• Sort by: Margin % ascending to see your worst-performing SKUs first

Inventory Turns by Category:

• Record type: Item
• Results: Item Category, Average Inventory Value (custom formula using snapshot data), Annual COGS (from transaction summary)
• Formula: Annual COGS / Average Inventory Value = Turns
• This is the metric that tells you how efficiently you're deploying your largest asset

Customer Cohort Analysis:

• Record type: Customer with transaction summary
• Criteria: Customer created date (by month/quarter)
• Results: Creation month, Count of customers, Sum of lifetime revenue, Average orders per customer
• Shows whether your newer customer cohorts are performing better or worse than older ones

Open Purchase Orders by Vendor:

• Record type: Transaction (Purchase Order)
• Criteria: Status = Pending Receipt
• Results: Vendor, PO Number, Expected Receipt Date, Item, Quantity, Amount
• Sorted by Expected Receipt Date — so your purchasing team sees what's coming next

Pro tip: Name your saved searches with a consistent prefix format: "ECOM - Revenue by Channel," "ECOM - Margin by SKU," "FIN - AP Aging," "OPS - Open POs." This makes them findable when you have 200+ saved searches (and you will). Also, set appropriate access permissions — your marketing team doesn't need to see the AP aging search.

What Financial Reports Should an Ecommerce CFO Configure?

NetSuite's Financial Report Builder is a separate tool from saved searches, designed specifically for financial statements. It uses standard accounting report formats with rows (accounts), columns (periods, comparatives), and formatting options.

Income Statement (P&L): Configure your primary P&L with these columns:

• Column 1: Current month actual
• Column 2: Current month budget
• Column 3: Variance (actual vs. budget, $ and %)
• Column 4: Prior year same month
• Column 5: Year-to-date actual
• Column 6: Year-to-date budget
• Column 7: YTD variance

Add a class filter so you can run the P&L for the total business or filter by channel (DTC, Amazon, Wholesale). This is the report you'll review every month at close.

Contribution Margin Report (Custom): This isn't a standard financial report — you'll build it as a customized P&L:

• Row 1: Gross Revenue (by channel)
• Row 2: Returns & Discounts
• Row 3: Net Revenue
• Row 4: Product COGS
• Row 5: Gross Margin
• Row 6: Channel-specific fees (marketplace fees, payment processing)
• Row 7: Shipping & Fulfillment costs
• Row 8: Variable marketing costs (allocated by channel)
• Row 9: Contribution Margin (the key metric)

This report answers the question every ecommerce CFO asks: "After all variable costs, how much does each channel actually contribute to covering fixed costs and generating profit?"

Cash Flow Statement: Configure the indirect method cash flow statement with:

• Operating activities (net income + non-cash adjustments + working capital changes)
• Investing activities (capex, mainly)
• Financing activities (debt, equity)

Balance Sheet: Standard balance sheet with comparative columns (current month vs. prior month vs. prior year). Add a subtotal for "Net Working Capital" (current assets minus current liabilities) — this is the metric your board and investors watch closely.

Board Reporting Package: Create a report group that includes: P&L, Balance Sheet, Cash Flow, and a KPI summary dashboard. Schedule this to generate automatically on Day 5 of your close process. Export to PDF. Send to your board. Total time: 10 minutes. Compare that to the 4-6 hours you currently spend reformatting QuickBooks exports in Excel.

How Do You Build an Effective Ecommerce Dashboard in NetSuite?

Your NetSuite dashboard is the first screen you see when you log in. Configure it properly and you'll start every day with a clear picture of your business. Leave it as the default and you'll see generic portlets that don't tell you anything useful.

Here's the dashboard layout I recommend for an ecommerce CFO:

Row 1: Key Metrics Portlets (4 across)

• Today's Revenue (real-time from sales orders)
• MTD Revenue vs. Budget (with green/red indicator)
• Cash Balance (from bank account records)
• Open Orders Awaiting Fulfillment (count)

Row 2: Charts (2 across)

• Revenue by Channel (bar chart, trailing 12 months) — from a saved search
• Gross Margin Trend (line chart, trailing 12 months) — from a saved search

Row 3: Operational Alerts

• Items Below Reorder Point (count and list) — from a saved search
• Overdue Purchase Orders (list) — from a saved search
• Support Cases Open > 48 Hours (list) — from a saved search

Row 4: Financial Close Status

• Period Close Checklist (built-in portlet showing task completion)
• Accounts Receivable Aging Summary (built-in portlet)

Custom KPI portlets can display any saved search result as a single number with trend indicators. Set up portlets for:

• Average Order Value (AOV) — trailing 30 days
• Customer Acquisition Cost (CAC) — if you're tracking this in NetSuite
• Return Rate — trailing 30 days
• Inventory Days on Hand — current

Role-based dashboards: NetSuite allows different dashboards per role. Your CFO dashboard should focus on financial metrics. Your VP of Operations should see fulfillment metrics, inventory levels, and shipping performance. Your marketing team should see revenue by channel, conversion rates, and campaign performance. Configure dashboards per role during implementation — don't make everyone use the same view.

What Is SuiteAnalytics Workbook, and When Should You Use It?

SuiteAnalytics Workbook is NetSuite's built-in business intelligence tool. Think of it as a more powerful, more visual layer on top of saved searches. It provides pivot tables, charts, and dashboards that you can build without any coding.

When to use Workbook instead of saved searches:

• When you need to pivot data by multiple dimensions simultaneously (channel × product category × month)
• When you need interactive visualizations (drill-down charts, dynamic filters)
• When you want to share analytics with stakeholders who don't know how to run saved searches
• When you need to combine data from multiple record types in a single view

Example: Channel × Category Revenue Matrix

In a saved search, you'd see a flat list: Shopify-Supplements $450K, Shopify-Skincare $280K, Amazon-Supplements $320K, etc. In Workbook, you'd see a pivot table with channels as columns and categories as rows, plus a heat map visualization showing where your revenue concentration is highest.

Example: Customer Lifetime Value Distribution

Workbook can create a histogram showing how your customers distribute across CLV brackets. You might discover that 60% of your customers have a CLV under $50 (one-time buyers), 25% are between $50-$200 (moderate repeat), and 15% are above $200 (loyal high-value). This distribution informs your retention strategy far more effectively than a single "average CLV" number.

Practical setup: During implementation, build 5-10 Workbook analyses covering your core metrics: revenue by channel/category/time, margin analysis, inventory performance, customer segmentation, and order fulfillment metrics. Save these to a Workbook dashboard that's accessible to your leadership team. Update the underlying data automatically — Workbook queries live data, so there's nothing to refresh.

Limitation to be aware of: Workbook operates on transactional data, which means complex calculations over very large datasets (millions of transactions) can be slow. If you need historical trend analysis over 3+ years of high-volume transaction data, the Analytics Warehouse (NSAW) is a better choice.

How Does the Analytics Warehouse (NSAW) Compare to External BI Tools?

The NetSuite Analytics Warehouse (NSAW) is a separate analytical database that pre-processes your NetSuite data for fast, complex queries. It's essentially a data warehouse built into the NetSuite ecosystem.

What NSAW gives you that SuiteAnalytics Workbook doesn't:

• Pre-calculated metrics and dimensions for faster queries
• Historical data retention beyond your transactional system
• Connections to external BI tools (Tableau, Power BI, Looker) via ODBC/JDBC
• Complex cross-module analytics (combining financial, inventory, CRM, and project data)
• Support for very large datasets without impacting your production NetSuite performance

Cost: NSAW is an add-on module. Pricing varies significantly based on your contract, but expect $6,000–$15,000/year for mid-market licenses. This is a substantial cost that needs clear ROI justification.

When NSAW is worth it:

• You need to connect NetSuite data to an existing BI tool (Tableau, Looker) that your company already uses
• Your transaction volume exceeds 100K transactions/year and Workbook queries are slow
• You need year-over-year trend analysis at a granular level (daily revenue by SKU by channel over 3 years)
• You're combining NetSuite data with data from other sources (marketing platforms, web analytics) in a unified analytics layer

When NSAW is overkill:

• You're under $20M in revenue with moderate transaction volume
• Your analytics needs are met by saved searches and Workbook
• You don't have a dedicated analyst or data team to build and maintain BI reports
• Your board is happy with the financial reporting package from NetSuite's standard report builder

Alternative approach: For many ecommerce brands under $30M, skip NSAW and use a lightweight BI tool like Google Looker Studio (free) or Metabase (open source) connected to your Supabase or data warehouse. Replicate the key NetSuite data you need via nightly export, and build your dashboards there. This is a fraction of the cost and gives you more flexibility.

What Are the Most Important Ecommerce KPIs to Track?

Here's my definitive list of KPIs for ecommerce brands, organized by audience, with the NetSuite source for each:

CFO / Finance (Monthly review):

KPI	Definition	NetSuite Source
Net Revenue	Gross revenue minus returns, discounts	Financial Report (P&L)
Gross Margin %	(Revenue - COGS) / Revenue	Financial Report (P&L)
Contribution Margin by Channel	Revenue minus all variable costs, by class	Custom P&L with class filter
Cash Conversion Cycle	DIO + DSO - DPO	Saved searches for each component
Working Capital Ratio	Current Assets / Current Liabilities	Balance Sheet
EBITDA	Earnings before interest, taxes, depreciation, amortization	Financial Report (custom)

VP Operations (Weekly review):

KPI	Definition	NetSuite Source
Order Fulfillment Rate	Orders shipped on time / Total orders	Saved search on fulfillments
Inventory Turns	COGS / Average Inventory Value	Saved search on items
Days Inventory Outstanding	Average Inventory / (COGS / 365)	Saved search formula
Return Rate	Returns / Gross orders	Saved search on RMAs
Perfect Order Rate	Orders shipped complete, on time, undamaged	Saved search combining multiple criteria

CMO / Marketing (Weekly review):

KPI	Definition	NetSuite Source
Revenue by Channel	Sales by class (DTC, Amazon, Wholesale)	Saved search
Average Order Value	Revenue / Number of orders	Saved search
Customer Acquisition Cost	Marketing spend / New customers	Custom record + saved search
Customer Lifetime Value	Total margin per customer	Saved search on customer transactions
Repeat Purchase Rate	Customers with 2+ orders / Total customers	Saved search

Pro tip: Don't track 50 KPIs. Pick 10-12 that align with your strategic priorities and review them religiously. I've seen brands build elaborate KPI dashboards with 40+ metrics that nobody looks at. Better to have 10 metrics that drive action than 40 metrics that drive nothing.

FAQ

Can I schedule reports to email automatically in NetSuite? Yes. Both saved searches and financial reports can be scheduled to run and email results on a defined cadence (daily, weekly, monthly). You can set recipients, output format (CSV, PDF, Excel), and delivery time. This is extremely useful for the weekly revenue report, monthly board package, and daily inventory alerts. Set this up during implementation — automated delivery ensures metrics are seen even when people forget to log in.

How do I connect NetSuite to Google Sheets for ad-hoc analysis? There are several approaches: (1) Use the SuiteAnalytics Connect ODBC driver with a Google Sheets add-on that supports ODBC. (2) Export saved search results to CSV and import into Google Sheets manually. (3) Use a connector like Coefficient or Supermetrics that pulls NetSuite data into Google Sheets automatically. Option 3 is the most user-friendly for non-technical team members.

What's the learning curve for NetSuite reporting? Expect 2-4 weeks for a finance team member to become proficient with saved searches, and another 2-4 weeks to master the financial report builder. Workbook has a steeper learning curve — budget 4-6 weeks. I strongly recommend investing in NetSuite reporting training (Oracle University or a consultant-led workshop) during the first month post go-live. The investment in training pays for itself quickly — a team that can build their own reports doesn't need to call a consultant every time they need a new metric.

Should I use NetSuite reporting or export everything to Excel? The whole point of NetSuite is to stop living in Excel. Build your core reports in NetSuite's native tools. Use Excel only for one-off ad-hoc analysis or when you need functionality that NetSuite doesn't offer (like regression analysis or complex statistical modeling). Every report you build natively in NetSuite benefits from real-time data, drill-down capability, and shared access — none of which exist in a spreadsheet emailed between team members.

How do I report on Amazon and Shopify channel performance in NetSuite? Set up classes (a NetSuite dimension) for each sales channel: Shopify-DTC, Amazon-FBA, Amazon-FBM, Wholesale, etc. Your integration tool (Celigo, etc.) tags each order with the appropriate class during sync. All financial reports and saved searches can then be filtered or grouped by class. This gives you true channel P&L down to contribution margin — something that's nearly impossible to achieve in QuickBooks or with separate channel-specific reporting tools.

---

Not sure if NetSuite is the right fit? Take our free ERP readiness assessment to find out.