NetSuite Excel Functions
Purpose-built Excel functions put live NetSuite balances in any cell, so every number in your report is a formula you can read, reuse and refresh.
Screen recording with on-screen captions. A Statement of Profit & Loss built from Finsyte functions shows an FSN.GLAccountBalance formula in the formula bar. Caption: View Function Arguments. Excel’s Function Arguments dialog lists each argument of FSN.GLAccountBalance, such as Subsidiary, Fiscal Year, Period Number, Period Range and Account Number, with a description of each. Caption: Use Function IntelliSense. Typing the formula in a cell shows the function’s argument list as you type. Caption: View All Finsyte Functions. The Finsyte Functions menu on the ribbon lists the GL Account, Inventory, Budget, Periods and Utility functions.
Your NetSuite general ledger, one cell at a time
Type =FSN. into any cell, or pick a function from the Finsyte Functions menu, and the cell returns a live value from NetSuite. Each function takes its inputs from other cells, so one formula filled across a grid builds a whole report.
- GLAccountBalance and its debit and credit versions, for any account, period range and segment
- Budget, inventory, statistical, period and list functions alongside the GL
- Saved Searches, SuiteQL queries and SuiteAnalytics datasets as dynamic arrays
- Period ranges from a single period to inception to date, including a trailing twelve months
- Excel’s Function Arguments dialog and autocomplete describe every argument as you type
- Right-click a balance to drill down, switch its sign or refresh it on its own
Saved Searches, SuiteQL and datasets in a cell
Three functions return whole result sets as dynamic arrays that spill into the cells below, ready for formulas, tables or Power Query.
- Only in Finsyte
Saved Searches as their own functions
In the docs: Saved Search FiltersSavedSearchruns a NetSuite Saved Search in a cell. Register one and it becomes a function of its own, such as=FSN.SavedSearch.APAging, with an argument for each filter you add on any field of the search’s record type. Point an argument at a cell and the search runs for that date, location or customer. More on Saved Searches in Excel. - Only in Finsyte
SuiteQL in a cell
The
In the docs: QueryQueryfunction runs a SuiteQL query from a cell and returns the rows as a dynamic array, joins and filters included. Any SuiteAnalytics dataset
The
In the docs: DatasetDatasetfunction loads a SuiteAnalytics dataset by name or ID as a dynamic array, with no query to write.
From a blank cell to a live NetSuite number in four steps
Choose a function
Type
=FSN.in a cell, or open Finsyte Functions on the ribbon for the full list.Point it at your inputs
Give it the subsidiary, fiscal year, period number, period range and account, typed in or referenced from other cells.
Fill it across the report
Lock the references the way any Excel model does, then copy the formula across periods and down accounts.
Refresh when the books change
Refresh Data updates every function in the sheet or workbook, and right-click › Refresh Selection updates just the cells you pick.
A function for every number in a finance report
Finsyte functions behave like any other Excel function. They take arguments, return a value, and recalculate when their inputs change, so the skills your team already has carry straight over.
GL balances by any slice
GLAccountBalance returns an account’s balance for a subsidiary, fiscal year, period number and period range. Optional arguments narrow it by book, item, class, department, location, entity, transaction type, posted status, currency and your custom segments. GLAccountDebitBalance and GLAccountCreditBalance split the same balance, and GLAccountNetIncome and GLAccountRetainedEarnings total the income and expense accounts for an income statement or an equity line.
Period ranges that match how you report
- PTD: a single period
- QTD: the quarter to date
- YTD: the fiscal year to date, and the balance to date for balance sheet accounts
- RTD: the fiscal year to date, always starting at the first period of the year
- ITD: everything since inception
- TTD: a trailing window, twelve periods by default
The period range definitions show each one with examples.
Budgets, inventory and statistics
BudgetAccountBalance and BudgetAccountNetIncome return NetSuite budget amounts with nearly the same arguments as GLAccountBalance plus a budget category, so a budget column can sit beside an actual column. GLItemQuantity and GLItemUnit return item quantities, and StatAccountAmount returns statistical accounts such as labor hours or headcount.
Periods and lists
DateToPeriod, GetPeriodName and PeriodToDate convert between dates and accounting periods. The Range functions return accounts, departments, classes, locations, subsidiaries, items or entities as a dynamic array, a quick way to lay out a report’s rows or columns.
One function per cell
Keep each Finsyte function in a cell of its own and build your calculations around it. That keeps the report easy to audit, and it is what the right-click options need: Drill Down, Switch Sign, Go To Budget, Refresh Selection and Static Snapshot Selection all work on a cell that holds a Finsyte function alone.
Templates and AI use the same functions
The report templates are built from these functions, and so are the reports Claude builds with the Finsyte skill. Every number they produce can be traced back to NetSuite and refreshed.
NetSuite Excel functions: FAQ
- QHow do I pull NetSuite data into an Excel cell?
- Type =FSN.GLAccountBalance into a cell, or choose it from the Finsyte Functions menu, and give it the subsidiary, fiscal year, period number, period range and account. The cell returns the live balance from NetSuite and updates when you refresh.
- QWhich NetSuite data can the functions return?
- GL account balances, debits and credits, net income and retained earnings, budget amounts, item quantities, statistical accounts, accounting periods, lists of accounts and segments, Saved Search results, SuiteQL query results and SuiteAnalytics datasets.
- QCan I turn a Saved Search into an Excel function?
- Yes. Register the search in Finsyte Preferences and it becomes a function such as =FSN.SavedSearch.APAging, with an argument for each filter you add. Point an argument at a cell and the search runs for that date, location or customer.
- QCan I run SuiteQL from Excel?
- Yes. The Query function runs a SuiteQL query from a cell and returns the results as a dynamic array, ready for formulas, tables or Power Query.
- QCan I pull a SuiteAnalytics dataset into Excel?
- Yes. The Dataset function loads a SuiteAnalytics dataset by name or ID and returns it as a dynamic array.
- QCan a function filter by department, class or location?
- Yes. GLAccountBalance takes optional class, department, location, item, entity, transaction type, book, currency and custom segment arguments, so one cell can return a balance for any combination of them.
- QWhich period ranges are available?
- PTD for one period, QTD for the quarter to date, YTD and RTD for the fiscal year to date, ITD for everything since inception, and TTD for a trailing window that defaults to twelve periods.
- QDo I need SuiteAnalytics Connect or an ODBC driver?
- No. Finsyte connects through NetSuite’s REST API with each user’s own NetSuite access, and no extra NetSuite modules are required.
Try it with your own NetSuite data
30-day free trial with every Finsyte feature included. No credit card required.