Skip to main content

Using Custom Segments in ExtendInsights Financial Reporting

ExtendInsights FRE | Filter financial reports using NetSuite custom segments

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.BALANCE

  • XAVI.BALANCECURRENCY

  • XAVI.TYPEBALANCE

  • XAVI.NETINCOME

  • XAVI.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

  1. From the ExtendInsights panel, select Custom Segment.

  2. Selecting a custom segment

  3. Selecting values

  4. Example of a filtered custom segment ("Filtered by: Budget Custom Segment")

  5. Completed report with formulas referencing the custom segment

Did this answer your question?