Skip to main content

Best Practices for Using Finsyte Functions

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. These benefits rely on the function being used 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.) introduces several issues that degrade performance and reduce functionality.

These functionality reductions include:

  • Slower Report Performance
  • Loss of Drill Down Capabilities
  • No 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)