NetSuite reporting & business intelligence

NetSuite tells you what you sold. Not what you made.

Your margin is decided by Amazon's referral and FBA fees, your freight, your returns and your ad spend — and none of that data lives in NetSuite. MerchantsBI joins NetSuite to every channel you sell on, so you can see true margin by channel, customer and SKU without exporting anything to Excel.

Book a demoSee what you'd get →Live in days. Read-only. Nothing changes inside NetSuite.

Start here

Four systems, four answers. Which one goes in the board pack?

None of them is wrong. NetSuite, Amazon, Shopify and Stripe are each counting something different, and nobody has written down which one the business runs on. So the number your board sees is whichever one your analyst happened to pull.

Net sales, last monthSame month, same company. Illustrative figures.
NetSuite412,880Invoiced. This month's credit memos haven't posted yet.
Amazon Seller Central268,140Settlement, already net of referral and FBA fees.
Shopify151,905Orders placed, including the ones not yet shipped.
Stripe143,220Captured, across two of your three channels.
The number397,415One definition of net sales, applied to all four the same way every month — so this figure means the same thing in June as it did in May.

What you'd actually ask

Six questions NetSuite alone can't answer.

Not because it's a bad ERP. Because the data that answers them lives in four other systems, and joining marketplace, storefront and payment data to your GL has never been anybody's job.

Which sales channel actually made money last month, after fees and freight?

TodayExport NetSuite, export the Amazon settlement report, export the 3PL invoice, and hope the SKUs line up. Two days, and you still hedge when the CEO asks.

Which customers cost more to serve than they pay us?

TodayNobody has ever calculated it, because returns, shipping and discounts sit in three systems that don't share a customer ID.

What is my real landed margin on this SKU?

TodayStandard cost in NetSuite, freight on a spreadsheet, marketplace fees in a settlement PDF. The margin you quote a buyer is an estimate.

Which SKUs run out of stock before the next PO lands?

TodayYou find out from a stockout, or from someone who checks inventory manually on Fridays.

Did the promotion pay for itself?

TodayAd spend is in Meta, orders are in Shopify, revenue is in NetSuite, returns arrive six weeks later. Usually nobody goes back and checks.

Why was last quarter down?

TodayThree teams build three explanations from three exports, and the meeting becomes an argument about whose number is right.

Where teams tell us they get stuck

What NetSuite reporting was built for, and what it wasn't.

NetSuite ships several ways to report on your data, and for a lot of companies they are genuinely enough. Here is what each one is good at, and what we hear from merchants who have outgrown it.

Standard reports

Built for financial statements

Pre-built and fast, and the right tool for a trial balance, a P&L or an aging report. Anyone can run one on day one without training.

What we hear: "It's perfect right up until someone asks for margin by channel."

Saved searches

The operational workhorse

Flexible, scriptable and the backbone of day-to-day NetSuite reporting. In the right hands there is very little you can't find with one.

What we hear: "Ours have multiplied, the big ones are slow, and really only one person understands them."

SuiteAnalytics Workbook

Better pivots, friendlier builder

A genuine step up for ad-hoc analysis, with easier joins and pivoting than saved searches, and no extra licence on most accounts.

What we hear: "Great for a quick pivot. Then someone needs to see it who doesn't have a login."

NetSuite Analytics Warehouse

Oracle's own analytics product

Purpose-built for NetSuite data, with pre-built content and history that the transactional system doesn't keep. If most of your reporting data lives inside NetSuite, it is a serious option and worth pricing properly.

The question we'd ask: is the data you need actually in NetSuite? If your margin is decided by marketplace fees, freight and ad spend, test that first — with us, with NSAW, with anything you're considering.

We're not going to tell you NetSuite is the problem. It's a strong ERP doing exactly what an ERP is supposed to do. The only question worth asking is whether the answer you need is in there — and for merchants selling across channels, usually half of it isn't.

What changes

The same month, run differently.

Nothing about how your team uses NetSuite changes. What changes is everything that currently happens in Excel afterwards.

Moment
How it goes now
How it goes after
First Monday
Someone spends the morning rebuilding the same deck from the same exports.
It's already in the inbox, refreshed, before anyone sits down.
Month-end close
A week reconciling channels by hand before anyone can report on the close.
Channels are already reconciled. Reporting starts the day you close.
The board meeting
Finance and sales bring different revenue figures and spend ten minutes on why.
One number, one definition, and a drill-down if anyone wants to check it.
A new report request
It joins a three-week queue behind whoever owns saved searches.
You ask it and get an answer while the meeting is still running.
Stock runs low
You learn about it from a report, after the SKU has already gone out.
You're told before it happens, on the dashboard you already have open.
Someone needs access
Buy them a NetSuite seat, then build them a role.
Send them the dashboard. They see only what their job needs.
A big report runs
It gets scheduled for overnight so it stays out of everyone's way.
It runs on your own copy of the data. Nobody in NetSuite feels it.

AI analyst

Type the question the way you'd say it out loud.

No report to build first, no column names to learn, and no ticket for whoever owns your saved searches. Ask a follow-up and it keeps its place in the conversation.

What were my top ten products by net sales last month?

Break that down by channel.

Now just the ones where Amazon margin fell against last quarter.

And an answer you can put in front of your board.

The reason most finance teams won't trust AI with a number is that it might make one up. This one structurally can't.

It never writes the number

The AI decides what to ask your data — it doesn't author the figure. Every value comes straight out of the query result, so a misreported number isn't something we guard against. It isn't possible.

It can't invent a metric

Ask for something that doesn't exist in your data and you get a clarifying question, never a confident answer built on a field it made up.

You can open it up

Drill into any row, widen the top ten to a top fifty, or trace a figure back to the NetSuite transaction behind it. Nobody has to take it on faith.

Before you ask

NetSuite reporting questions we hear on every first call.

We only run NetSuite. Is this still worth it?

Often more than people expect — though it's worth being honest about when it isn't.

Start by checking the premise. NetSuite is usually the ERP rather than the whole picture, and most teams who tell us they're NetSuite-only find four or five other sources once they actually count: the CRM, the payment processor, the ad accounts, the 3PL portal, and the spreadsheet someone in FP&A maintains by hand. If any of those decide a number your board sees, you're already running a multi-system business.

If you genuinely are NetSuite-only, some of the value shifts to distribution. Dashboards go to anyone you choose without consuming an ERP seat, so the people who currently receive a PDF get a live view instead. And if you sell wholesale, your line sheets and catalogs come out of the same governed numbers as the report you send your CFO.

But the change most single-system teams actually feel is in how they interact with their own data. Right now, asking a question means someone builds something first — a search, a report, a workbook — and that construction cost is the real reason most questions never get asked at all. People settle for the report that already exists.

With MerchantsBI the question is the interface. You type it the way you'd say it out loud, you get an answer, and then you ask the next one. Break that down by region. Now only the lines under thirty percent margin. Show me the same thing this time last year. Each follow-up keeps its place in the conversation, so you're thinking out loud with your data instead of commissioning a build and waiting. The ten questions you'd never have bothered filing a request for are the ones that change decisions.

And the speed doesn't cost you defensibility. Every figure traces back to the transaction behind it, and the AI never authors a number — it only returns what the query returned. An answer you got in ten seconds is one you can still put in front of your board.

Where we'd be straight with you: if all you need is a cleaner P&L or trial balance, the native financial reports handle that and you don't need us. We earn our place the moment somebody starts asking the second and third question.

Why is my NetSuite saved search so slow?

Almost always because it's being asked to do analytical work inside a system designed for transactions. Wide result sets, deep joins and long formulas are heavy, and they're competing with everyone entering orders. Tightening criteria and trimming columns helps, and your admin or partner can usually get real gains that way. If you're past the point where tuning helps, the alternative is to stop running the analysis in your ERP at all — on a replicated copy, the same question has nothing to compete with.

What is the best BI tool for NetSuite?

It depends entirely on where your data lives. If everything you report on sits inside NetSuite, Oracle's own tools are the obvious first place to look and often the right answer. If you sell across Amazon, Shopify, Walmart or a payment processor, look for something that treats NetSuite as one source among several and reconciles them to a single definition first — otherwise you're buying a nicer chart on top of the same disagreement.

Is NetSuite Analytics Warehouse worth it?

For a lot of NetSuite-centric companies it's a strong fit, and we'd genuinely encourage you to price it. The way we'd frame the decision is to write down the five questions you most need answered, then check where the data to answer them actually lives. If it's all inside NetSuite, Oracle's own product has a real advantage. If half of it is sitting in marketplace settlements, freight invoices and ad platforms, that's the constraint to test before you compare anything else.

Can I report on NetSuite and Shopify or Amazon data together?

It needs the channel data brought alongside your GL first. The hard part isn't moving it, it's reconciling it: a marketplace settlement, a storefront order and a GL invoice are each counting a different moment in the same sale. Agreeing one definition and applying it the same way every month is the actual work, and it's what MerchantsBI does before you see a number.

Do you need a NetSuite license to view reports?

Licensing is between you and Oracle, so check your own agreement. What we can tell you is how it works on our side: MerchantsBI dashboards are shared with anyone you choose without consuming an ERP seat, with row-level permissions so each person sees only the data their job needs.

Will connecting a BI tool slow NetSuite down?

It shouldn't, if it's built correctly. Our connection is read-only and reads only what has changed rather than re-scanning tables, and every report, dashboard and question after that runs against your own copy of the data. The analytical work simply isn't happening in your production account any more.

How long does a NetSuite BI implementation take?

Days rather than quarters. It takes about an hour from whoever administers NetSuite to open the connection, and a few hours from someone in finance in the first week to confirm the mapping and sign off that the numbers tie to your last closed month. Nobody sees a dashboard until they do.

How do I fix a NetSuite saved search timeout on a large dataset?

There's a ceiling on how long a search can run in the browser, and past a certain data volume you'll keep hitting it. The common workarounds are narrowing the date range and stitching the exports back together, or pulling the query out of the browser entirely — your NetSuite partner can help with both. The durable fix is to stop asking the production system to do the analysis: once the data is replicated, the same question runs against your own copy with nothing competing for resources.

How do I get consolidated reporting across multiple NetSuite subsidiaries?

Statutory consolidation is well handled natively. The version teams tell us they still finish by hand is management reporting — comparing entities that sell through different channels, or looking at the group and one brand side by side. MerchantsBI reconciles entities into one model, so the consolidated view and the by-entity view come from the same definitions, and you can switch between them without signing out.

How do I export NetSuite data to Excel automatically?

Most teams schedule a saved search and email the CSV, which works until the result set gets big or someone needs it combined with another system. The alternative is to stop exporting: replicate the data once, define the report against it, and have the finished view delivered on a schedule to whoever needs it — in your own branding, without anyone rebuilding a workbook.

What happens to the saved searches we already rely on?

They keep working. Nothing inside NetSuite changes, and nothing is written back. Teams usually keep a handful for day-to-day operational lookups and quietly stop opening the rest once the same answer exists somewhere faster.

Bring the report that costs you the most time.

Twenty minutes. We'll take the one you rebuild every month, show you what it looks like when NetSuite and your channels agree, and tell you honestly if this is worth your time.

Book a demo

No NetSuite access needed for the call. A screenshot is enough.