FAQ: Financial Reporting Engine Common Questions

XAVI stands for the principles behind modern finance: Extend data, Analyze performance, Create Value, and deliver Intelligence.

XAVI is the mascot of CloudExtend Financial Reporting — and the inspiration behind every formula you'll find in the product.

When you type =XAVI.INCOME() or =XAVI.BALANCE() in Excel, you're putting XAVI to work: pulling live data directly from NetSuite and dropping it right where you need it.

The XAVI. prefix also serves a practical purpose. It gives every Financial Reporting formula its own distinct namespace inside Excel — so you always know exactly what's powering your numbers, and there's never any confusion with native Excel functions or other add-ins.

Data is cached for 1 hour. To get the latest data immediately after posting new transactions, click Refresh All in the task pane. To refresh only specific cells, use Refresh Selected.

We had a customer with 38 store locations and 1 corporate location. They wanted to create a consolidated P&L Statement for all locations "except" the Corporate Location.

Because The XAVI.BALANCE formula does not have an exclude option, the solution was to use 2 formulas, ie XAVI.BALANCE("4100", "Jan 2025", "Jan 2025") - XAVI.BALANCE("4100", "Jan 2025", "Jan 2025",,,"Corporate Location").

This creative solution subtracts the Corporate Location amounts from the total. This is yet another advantage of using real Excel formulas.

No. XAVI requires an active internet connection to communicate with NetSuite. Formulas will not resolve without a connection.

XAVI shows true GL (General Ledger) values. NetSuite sometimes flips signs for presentation purposes in its reports (for example, showing expenses as positive numbers). The totals always match — only individual line signs may appear different. If this causes confusion in your reports, adjust the sign in Excel using a simple multiplication by -1.

XAVI.NETINCOME always computes a period range. When you supply only one period, XAVI treats it as a single-period range (from = to), returning only that month's P&L — not year-to-date.

To match Balance Sheet Net Income, always supply both fromPeriod and toPeriod:
​=XAVI.NETINCOME("Jan 2025", "Feb 2025")

Yes. =XAVI.BUDGET("6*", "Jan 2025", "Dec 2025") returns the sum of all 6xxx expense budgets for the year.

To report on ALL subsidiaries use the Top Level Consolidated subsidiary in your NetSuite account (or leave your subsidiary blank and it will default to your top level).

Choosing a parent subsidiary will always consolidate the children of the parent as well.

To see multiple subsidiaries in the same report just copy your formula from one column to another and reference your deisred subsidiary.

No — a single formula uses one pattern. But you can use different formulas in different rows:

Row 1: =XAVI.BALANCE("4*", ...) → Total Revenue Row 2: =XAVI.BALANCE("4010", ...) → Product Revenue Row 3: =XAVI.BALANCE("4020", ...) → Service Revenue

This is a common pattern for reports that show a summary total with a supporting breakdown below it.

Not automatically. Location is passed as a parameter to the formula and needs to be set manually. When a new location is added in NetSuite, it will dynamically appear as an available option in the location parameter — but it won't show up as a column in the report itself until the user updates the cell to include that location.

Not currently supported.

Yes. You can layer filters — for example, filtering by Subsidiary, then Class, then Department.

Not natively, but you can replicate "is not" logic using formulas as a workaround.

On first use, pre-built reports (CFO Flash Report, Income Statement) fetch and process data live from NetSuite, which can take 2–3 minutes. After the initial load, data may be cached, reducing load time. A performance improvement is planned for an upcoming release. Custom XAVI formulas are not affected in the same way.