Custom Segments are fully supported in ExtendInsights Financial Reporting, allowing you to build reports that are filtered by your organisation's custom dimensions, such as Business Unit, Region, Department, Project Code, or any other custom segment configured in NetSuite.
Use custom segments to create more targeted Income Statements and custom financial reports without modifying your chart of accounts.
Supported Reports and Formulas
Custom Segments are currently supported in the following features.
Supported XAVI Formulas
XAVI.BALANCEXAVI.BALANCECURRENCYXAVI.TYPEBALANCEXAVI.NETINCOMEXAVI.RETAINEDEARNINGS
Supported Report Templates
Sample Report
CFO Flash Report
Full Income Statement
Currently Not Supported
The following report types do not currently support custom segments:
Budget Reports
Balance Sheets
Using a Custom Segment in a Formula
After selecting a custom segment, reference the segment cell as the final argument in your XAVI formula.
Example
=XAVI.BALANCE("4220","Jan 2024","Jan 2024","Celigo Inc.","Sales","","",$W$4)In this example:
Account 4220 is returned.
The report is filtered for January 2024.
The formula applies the custom segment selected in cell W4.
This allows multiple formulas to reuse the same segment filter simply by referencing the same cell.
Working with Filtered Custom Segments
Some custom segments depend on another selection before their values become available.
For example, a Project segment may first require a Subsidiary, or one custom segment may be filtered by another custom segment.
When this occurs, the panel displays a Filtered by label.
Example
Select the required parent value first to unlock the available segment values.
Templated vs Free-form Reports
Custom segments behave slightly differently depending on the report type.
Templated Reports
For built-in templates such as:
Income Statement
CFO Flash Report
the custom segment filter is automatically placed in the fixed filter cells (typically W2/W3) immediately after the standard report filters.
This keeps all template formulas synchronised and ensures every calculation uses the same segment selection.
Free-form Reports
In a free-form workbook, you have complete flexibility.
You can place custom segment filters in any worksheet or cell and reference those cells in your XAVI formulas to build fully customised financial reports.
Editing an Existing Custom Segment
You can modify a custom segment at any time.
Simply click the worksheet cell containing the custom segment value to reopen the Custom Segment panel.
From there, you can:
Change the selected values
Add or remove filters
Select a different custom segment
All formulas referencing that cell update automatically after the selection changes.
Example Interface
From the ExtendInsights panel, select Custom Segment.
Selecting a custom segment
Selecting values
Example of a filtered custom segment ("Filtered by: Budget Custom Segment")
Completed report with formulas referencing the custom segment




