SuiteQL Query Examples
Explore common SuiteQL use cases for pulling data from NetSuite using ExtendInsights
4 articles
Balance Sheet by Account (As of a Specific Period)This query produces a consolidated balance sheet as of a specific accounting period. It returns assets, liabilities, and equity accounts with their final consolidated balances, making it easy to build…
Monthly Profit and Loss by Account (Fixed Monthly Columns)This query creates a monthly profit and loss layout where each month is its own column, making it easy for users to compare month-over-month performance and build Excel dashboards.
Monthly Profit and Loss by Account (Pivot Table Friendly)This query produces a full year of monthly financial activity for each account, with one column per month and a total column, making it easy to build pivot tables and…
Year-to-Date P<his query produces a year-to-date, consolidated profit and loss view by account, grouping each account into standard financial statement sections for easy analysis in Excel.