NetSuite Reporting: Why Two Reports Give Two Totals, and Which Tool to Trust
Say the CFO's deck shows October revenue of $412,600 and the income statement shows $385,450. Both came out of NetSuite, and each is right about what it counted. NetSuite reporting runs on four tools that count differently: financial and standard reports, saved searches, SuiteAnalytics workbooks, and the dashboards built from them. Knowing which rules each one follows settles most arguments about the number.
One month of revenue, two NetSuite totals
A transaction saved search against the income statement for the same month, reconciled line by line.
| Saved search: invoice amounts dated in October (Filtered on transaction date, all subsidiaries.) | $412,600 |
|---|---|
| Invoices dated October but posted to November (Financial reports follow the posting period, not the date.) | −$18,400 |
| Cash sales the invoice-only search left out | +$9,750 |
| Credit memos issued in October (They reduce revenue on the statement but weren't in the search.) | −$6,200 |
| A subsidiary outside the report's selection (The report ran for one subsidiary; the search covered all of them.) | −$12,300 |
| Income statement revenue, October | $385,450 |
Two more to rule out: a transaction search without a Main Line filter returns header and line rows, which double counts, and summing Amount (Foreign Currency) mixes currencies where Amount is in base currency.
Settle these before you build a NetSuite report
Does the number have to tie to the general ledger?
Use a financial report: the income statement, balance sheet or cash flow statement, laid out in the Financial Report Builder. They follow posting periods and the accounting rules your auditors expect. A search won't, unless you rebuild those rules by hand.
Is it a list someone works through?
Overdue invoices, unshipped orders, unapproved bills. That's a saved search, which can also drive alerts and reminders. Our saved search guide has the build steps.
Will someone want to pivot, chart or regroup it on screen?
That's a SuiteAnalytics workbook: a dataset joined across record types, with pivot tables and charts on top. Workbooks read the analytics data source, so field names and some records don't line up one for one with saved searches.
Should people see it the moment they log in?
Put it on a NetSuite dashboard. Portlets, KPI scorecards and trend graphs are built from the searches and reports you already have, so fix the source first and the dashboard follows.
Does it need to arrive in inboxes on a schedule?
Reports and saved searches can both be scheduled to email from NetSuite. Big attachments run into the 25MB limit on email sent from NetSuite, so very wide reports may need splitting.
Does it need figures NetSuite doesn't hold?
Pipeline from the CRM, headcount from payroll, spend from ad platforms. None of NetSuite's in-app tools can join those, so the report has to be built outside NetSuite with its numbers brought in.
NetSuite numbers beside the rest of the business
There are two supported ways to get NetSuite data into a warehouse or BI tool. SuiteAnalytics Connect gives ODBC, JDBC and ADO.NET drivers against the NetSuite2.com data source, and it's a separately licensed add-on. The other is pulling with SuiteQL through NetSuite's REST query service, covered on our NetSuite API page.
Either way, the pull is the easy half. The board deck only matches the books if the posting period, subsidiary, credit memo and currency rules from the reconciliation above travel with the data. n-frames builds that feed: NetSuite figures landed next to CRM, payroll and spend data on a schedule, with revenue that ties to the income statement, plus a short daily figure posted to a Slack channel if the team wants one.
NetSuite reports, dashboards and SuiteAnalytics
What is SuiteAnalytics in NetSuite?
It's the umbrella name for NetSuite's analytics tools. Day to day it usually means SuiteAnalytics Workbook, where you build a dataset across record types and look at it as tables, pivots and charts. SuiteAnalytics Connect is the separate, licensed piece that lets outside tools query NetSuite data directly.
Does NetSuite have dashboards?
Yes. Every role has a home dashboard of portlets: KPI scorecards, trend graphs, reminders and saved search lists. It shows data the account already has in searches and reports, so a dashboard is only as right as the search or report behind it.
What is the difference between a NetSuite report and a saved search?
Reports, and financial reports in particular, follow accounting rules: posting periods, subsidiary consolidation, the chart of accounts. A saved search returns the records that match your filters, by whatever date or field you pick. That's why the two can disagree, as in the example above. Our saved search page goes into searches in depth.
Can NetSuite reports feed a BI tool automatically?
Yes, with setup. SuiteAnalytics Connect lets a BI tool query NetSuite on its own schedule, if your account licenses it. Without Connect, a scheduled SuiteQL pull through the REST API can land the data in a warehouse. n-frames builds either, and adds the period and subsidiary logic so totals match NetSuite's own reports.
How do I build a custom report in NetSuite?
Open a standard report and choose Customize to change its columns, filters and sorting in the report builder, then save it under a new name. For financial statements, edit rows and sections in the Financial Report Builder instead. If you need joins across record types or pivots, start a SuiteAnalytics workbook.
Why doesn't my NetSuite report match my saved search?
Usually one of five things: the report uses posting period while the search uses date, the search left out a transaction type such as cash sales or credit memos, the two cover different subsidiaries, the search has no Main Line filter, or the search sums foreign-currency amounts.