Skip to main content

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

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.