Best Practices for Using Finsyte Functions
Finsyte functions (=FSN) are designed to pull NetSuite data directly into Excel with optimized caching, drill down support and fast refresh behavior. To get these benefits, use each function as intended - as a standalone data-retrieval function, not as part of an Excel formula chain.
Using =FSN inside other Excel functions (such as SUM, IF, VLOOKUP, etc.) costs performance and functionality. A standalone =FSN function keeps:
- Faster Report Performance
- Drill Down Capabilities
- Caching of Results
Recommended Approach
Let Finsyte retrieve the data directly in dedicated cells, then reference those cells using normal Excel formulas as needed.
A1: =FSN.GLAccountCreditBalance("Headquarters (Consolidated)", "FY 2025", 12, "YTD", 1010)
B1: =FSN.GLAccountDebitBalance("Headquarters (Consolidated)", "FY 2025", 12, "YTD", 1010)
C1: =SUM(A1:B1)
For more on keeping reports fast, see Keeping Finsyte Workbooks Fast.