SuiteQL Query Examples
Explore common SuiteQL use cases for pulling data from NetSuite using ExtendInsights
6 articles
Balance Sheet by Account (As of a Specific Period)This SuiteQL query creates a consolidated NetSuite balance sheet as of a selected period, grouping assets, liabilities, and equity while using BUILTIN.CONSOLIDATE for accurate multi-subsidiary reporting and Excel-based financial analysis.
Monthly Profit and Loss by Account (Fixed Monthly Columns)This SuiteQL query returns a pre-pivoted monthly profit and loss by account, with each month shown as a separate column and totals consolidated using NetSuite’s BUILTIN.CONSOLIDATE for accurate multi-subsidiary financial…
Monthly Profit and Loss by Account (Pivot Table Friendly)This SuiteQL query returns monthly profit and loss data with months shown as rows instead of columns, making it ideal for Excel pivot tables and dashboards while using NetSuite’s BUILTIN.CONSOLIDATE…
Year-to-Date P<his SuiteQL query returns consolidated year-to-date profit and loss totals by grouping accounts into standard finncial statement sections and uses BUILTIN.CONSOLIDATE to ensure results reflect consolidated financials across subsidiaries.
Expense by Account with Vendor Detail (Includes Account Totals)This SuiteQL query returns expense totals by account and vendor, showing account summary rows with totals followed by vendor detail rows, making it easy to build Excel pivot tables and…
SuiteQL for Top 10 Sales Reps“This SuiteQL query shows how to calculate net invoice revenue by sales representative in NetSuite. It demonstrates how to use mainline = ‘T’, subtract tax lines (taxline = ‘T’), and…