Skip to main content
Vortex IQ Nerve Centre tracks 60 KPI pulses for NetSuite stores. Each metric has its own page: definition, calculation, why it matters, and what to do when it moves. NetSuite is the system of record. For mid-market and lower-enterprise commerce businesses, Oracle NetSuite is the financial spine: revenue is booked in its General Ledger, Invoices age in its AR module, inventory is valued at landed cost in its item records, and Sales Orders flow through Pending Approval, Pending Fulfilment, Pending Billing, and finally to GL revenue. Every other system, including Shopify, BigCommerce, Adobe Commerce, Stripe, PayPal, and Google Ads, is upstream of NetSuite or downstream of it. The number that survives audit, that the bank lender pulls, and that the board reviews on Monday morning lives here. The persona running this dashboard is the Finance Controller or VP Finance, often paired with a NetSuite Admin who builds saved searches and SuiteAnalytics workbooks. They open NetSuite at 9am every Monday for cash-flow telemetry: how much GL revenue did we book, how much cash did we collect, how much is stuck in Pending Billing, what did the AR aging buckets look like over the weekend. NetSuite has the data; what NetSuite does not have is a single screen that surfaces the three killer findings every Controller actually wants to see. The first killer finding is the revenue gap reconciliation. Commerce platforms (Shopify, BigCommerce, Adobe Commerce) report gross order totals that always exceed NetSuite GL booked revenue, often by 8 to 15% in any 30-day window. The gap is structural (Pending Billing lag, Credit Memos, cancellations, unmapped marketplace orders), not error, but it is rarely diagnosed line by line. Vortex IQ Nerve Centre runs the full reconciliation every 15 minutes and breaks the gap into reason buckets, exposing exactly which orders, customers, and SOs make up the missing dollars. Most mid-market Controllers see this view for the first time and identify 50Kto50K to 500K of trapped working capital that nobody had previously surfaced. The second killer finding is inventory carrying cost waste, particularly the cross-channel “dead stock with active ad spend” pattern. NetSuite shows inventory aging and dead stock value; Google Ads shows campaign spend by SKU. Cross-tabulating reveals SKUs that have not sold in 180 days but are still receiving thousands of dollars per month in paid traffic. That is pure waste, often hundreds of thousands of dollars annually, and no NetSuite-only or ads-only dashboard surfaces it. Vortex IQ Nerve Centre is the cross-connector layer that makes the finding visible. The third killer finding is margin erosion by SKU, the per-product trend that aggregate gross margin percentage always hides. A 2 percentage point drop in headline gross margin almost always traces to a small set of SKUs with 20 to 35 percentage point drops, either because of a freight cost spike, an FX shift on imported components, or aggressive discounting that pushed price below cost. NetSuite tracks the data; surfacing the per-SKU drift requires a comparison saved search that most Admins do not maintain. The Margin Erosion Alerts card runs that comparison continuously. Beyond the three killer findings, NetSuite data shape is unique on the Nerve Centre because it is multi-subsidiary, multi-currency, and multi-tax-jurisdiction. OneWorld accounts route 60 cards through a subsidiary roll-up logic, an FX translation layer that respects transaction-date and period-average rates, and an intercompany elimination convention. Single-subsidiary accounts collapse the same logic to a single bar. Cards that only render on OneWorld (Revenue by Subsidiary, Currency Exposure, Intercompany Balance, Subsidiary Performance roll-ups) gate cleanly behind the multi_subsidiary feature flag. The integration is built on NetSuite SuiteTalk REST, RESTlet, and SuiteQL, with token-based authentication or OAuth2 depending on workspace setup. Refresh cadence is 15 minutes for transactional data and real-time for status flags (credit holds, OOS alerts). Vortex IQ Nerve Centre keeps NetSuite as the source of truth for everything financial; commerce platforms remain the source of truth for everything customer-facing.
CardClassTierCategoryChart
Days Sales Outstanding (DSO)🦸 HeroheroReceivables & Cashgauge
Dead Stock Value🦸 HeroheroInventory & Itemskpi
Gross Margin Percentage🦸 HeroheroMargin & Cost Intelligencegauge
Inventory Aging🦸 HeroheroInventory & Itemsbar
Margin Erosion Alerts🦸 HeroheroMargin & Cost Intelligencealert_table
Open Sales Order Value🦸 HeroheroExecutive Command Centrekpi
Revenue Booked into GL🦸 HeroheroExecutive Command Centrekpi
Revenue Gap vs Commerce🦸 HeroheroExecutive Command Centrekpi
SOs Blocked on Inventory or Credit🦸 HeroheroExecutive Command Centrealert_table
Total Inventory Value🦸 HeroheroInventory & Itemskpi
Commerce Orders Without NetSuite SO🔗 Cross-Channel-Cross-Channel: Revenue Reconciliationalert_table
Dead Stock with Active Ad Spend🔗 Cross-ChannelheroCross-Channel: Revenue Reconciliationalert_table
Inventory Sync Drift🔗 Cross-Channel-Cross-Channel: Revenue Reconciliationalert_table
OOS with Open SO Demand🔗 Cross-ChannelheroCross-Channel: Revenue Reconciliationalert_table
Revenue Gap, Detailed Breakdown🔗 Cross-ChannelheroCross-Channel: Revenue Reconciliationtable
A/R Aging DetailNon-Hero-Receivables & Cashbar
Active CustomersNon-Hero-Customers & B2Bkpi
Average Landed Cost per UnitNon-Hero-Inventory & Itemskpi
Average Sales Order ValueNon-Hero-Revenue & Sales Performancekpi
B2B Payment Terms MixNon-Hero-Customers & B2Bpie
Cash Application RateNon-Hero-Receivables & Cashgauge
Cash Applied TodayNon-Hero-Executive Command Centrekpi
Cash CollectedNon-Hero-Revenue & Sales Performancekpi
Consolidated Revenue TrendNon-Hero-Multi-Subsidiary Dashboardarea
Credit Hold SpikeNon-Hero-Alerts & Anomaliesalert_table
Credit Memo ValueNon-Hero-Order Operationskpi
Customer Churn SignalsNon-Hero-Customers & B2Balert_table
Customer Credit UtilisationNon-Hero-Customers & B2Bgauge
Dead Stock Threshold BreachNon-Hero-Alerts & Anomaliesalert_table
DSO Increase AlertNon-Hero-Alerts & Anomaliesalert_table
FX Currency ExposureNon-Hero-Multi-Subsidiary & Multi-Currencybar
High-Value Overdue InvoicesNon-Hero-Alerts & Anomaliesalert_table
Intercompany BalanceNon-Hero-Multi-Subsidiary & Multi-Currencykpi
Inventory Carrying CostNon-Hero-Inventory & Itemskpi
Inventory Turnover RatioNon-Hero-Inventory & Itemsgauge
Invoice Aging SummaryNon-Hero-Executive Command Centrebar
Invoiced RevenueNon-Hero-Revenue & Sales Performancekpi
Landed Cost Variance vs StandardNon-Hero-Margin & Cost Intelligencebar
Low Stock AlertsNon-Hero-Inventory & Itemsalert_table
Margin by SKUNon-Hero-Margin & Cost Intelligencebar_horizontal
Margin CompressionNon-Hero-Alerts & Anomaliesalert_table
Open Sales OrdersNon-Hero-Order Operationskpi
Orders on Credit HoldNon-Hero-Receivables & Cashalert_table
Overdue Invoice ValueNon-Hero-Receivables & Cashkpi
Return AuthorisationsNon-Hero-Order Operationskpi
Revenue Booked Over TimeNon-Hero-Revenue & Sales Performancearea
Revenue by ClassNon-Hero-Revenue & Sales Performancebar
Revenue by CurrencyNon-Hero-Revenue & Sales Performancebar
Revenue by SubsidiaryNon-Hero-Revenue & Sales Performancebar
Revenue Gap SpikeNon-Hero-Alerts & Anomaliesalert_table
SO State BreakdownNon-Hero-Order Operationspie
SO to Invoice Lead TimeNon-Hero-Order Operationsgauge
Subsidiary Health Roll-upNon-Hero-Multi-Subsidiary Dashboardtable
Subsidiary PerformanceNon-Hero-Multi-Subsidiary & Multi-Currencytable
Top B2B Accounts by RevenueNon-Hero-Customers & B2Bbar_horizontal
Top Customers by RevenueNon-Hero-Revenue & Sales Performancebar_horizontal
Top Findings Across SubsidiariesNon-Hero-Multi-Subsidiary Dashboardalert_table
Top SKUs by Inventory ValueNon-Hero-Inventory & Itemsbar_horizontal
Total COGSNon-Hero-Margin & Cost Intelligencekpi
Unpaid Invoice CountNon-Hero-Receivables & Cashkpi

​
Cross-connector reconciliation: how NetSuite fits into the Vortex IQ stack

NetSuite is the system of record for revenue, AR, inventory, and customer hierarchy at mid-market and lower-enterprise commerce merchants. It rarely operates alone: the typical Vortex IQ NetSuite tenant runs alongside one or more commerce platforms (Shopify Plus, BigCommerce, Adobe Commerce), at least one payment connector (Stripe, PayPal), and often ad platforms (Google Ads, Amazon Ads, Meta). The cross-connector value of NetSuite is the same fact: every other connector tracks ONE LENS on the customer; NetSuite is the only system that records the GL-level truth that all the other lenses must reconcile against. The reconciliation patterns in priority order: (1) commerce orders to NetSuite SOs via Commerce Orders Without NetSuite SO, this is the largest revenue-leakage detector for merchants migrating onto integrated stacks; expect 2 to 5% of commerce revenue to be missing in NS books on first connection; (2) commerce inventory to NetSuite item.on_hand via Inventory Sync Drift, the operational-risk twin of the revenue gap; (3) NetSuite credit memos to gateway refund value via Credit Memo Value plus the corresponding stripe.stripe_refund_value or paypal.pp_refund_value cards, the GL-versus-bank reconciliation; (4) NetSuite dead stock to ad-platform spend via Dead Stock with Active Ad Spend, the kill shot for ad-spend recovery, joining sales velocity from NS to spend from Google Ads, Amazon Ads, and Meta Ads.

​
Refresh cadence

NetSuite data lands in Vortex IQ via SuiteAnalytics Connect (live SuiteQL queries, refreshed at the merchant’s tenant cadence; typically 5 minutes for SuiteAnalytics Premium accounts, 30 to 60 minutes for Standard). The SuiteTalk REST API is used for transactional create/update operations (SO retry, inventory force-resync). Most KPI cards reflect data within 15 minutes of NetSuite postings; cross-connector reconciliation cards (Section 9) are gated on the slowest sibling connector’s refresh cadence.

​
FAQ-style notes

When does NetSuite data refresh? SuiteAnalytics replication runs at the merchant’s configured cadence; cards typically reflect transactions within 15 minutes for Premium, 30 to 60 minutes for Standard. Real-time RT cards (Open Sales Orders, Customer Credit Utilisation) re-query on dashboard load. Can I reconcile against the bank statement? Yes, indirectly. Cross-reference Cash Applied Today and Cash Collected against gateway-side cash from Stripe, PayPal, and ACH feeds. The bank-side reconciliation runs through NS’s Bank Reconciliation module; Vortex IQ surfaces the upstream cash-application metrics that drive the bank match. How do Credit Memos affect refund cards? Credit memos posted in NS reduce net revenue and reduce AR; their cash counterpart (Customer Refund) is a separate event that may post days or weeks later. Refund-impact cards default to the memo posting date (GL-side); cash-out cards use the refund posting date. Reconciliation between the two reveals the dwell-time of credit applied to next invoice. Why is my OneWorld card showing a placeholder? Several Section 8 and Section 11 cards are gated only_when: multi_subsidiary. Single-subsidiary tenants see a placeholder; OneWorld upgrade is required for full population. My SuiteAnalytics is on Standard cadence (30 to 60 minutes). Will my dashboards lag? Yes, by the configured replication interval. For tighter dashboards, consider upgrading to Premium (5-minute cadence). Real-time cards can be re-queried via Ask Viq for an immediate live read regardless of replication cadence.