Overview

Financial Reporting includes a Quick Start section in the task pane that lets you generate complete, ready-to-use reports without writing a single formula. Just pick a report type, set your parameters, and XAVI builds the whole thing for you.

Pre-built reports are meant just to give you a quick example of what is possible using ExtendInsights Financial Reporting.

Caveat

The pre-built reports are meant to show samples of what can be built with XAVI formulas. They are not meant for your day to day reporting. For companies that do not have periods that align with months, ie periods do not cross months, the reports should run. If your company has 4-4-5, 4-5-4 calendars or has an adjustment period the pre-built reports may not run correctly.

Learn more about periods here.

CFO Flash Report

The CFO Flash Report is a high-level P&L summary perfect for board presentations, monthly flash reporting, and quick variance checks. It's the fastest way to get an executive overview of your financials.

How to generate it

Open the XAVI task pane and click Quick Start
Go to Profit & Loss Report
Choose Year
Select CFO Flash Report
Click Generate

XAVI builds the report instantly using the XAVI.TYPEBALANCE formula.
1. For example, Total Revenue is defined as
  =XAVI.TYPEBALANCE("Income",C$5,C$5,$Q$3,$R$3,$S$3,$T$3,$U$3)
  where C5 is the period, Q3 is Subsidiary, R3 is Department, S3 is Location, T3 is Class, and U3 is Accounting Book.
2. Building a formula with parameters enables a user to change the parameter (Subsidiary for example) in one place and have it flow to all the formulas at once.

See in Action

What's included

Revenue
Cost of Goods Sold
Gross Profit
Operating Expenses
Net Income

The CFO Flash Report uses XAVI.TYPEBALANCE with account types (such as "Income", "COGS", "Expense") to aggregate balances by financial category. This means it works independently of your specific account numbering scheme.

Build Income Statement

For a detailed P&L that includes all accounts — not just high-level totals — use Build Income Statement.

How to generate it

Open the XAVI task pane and click Quick Start
Go to Profit & Loss Report
Choose Year
Select Full Income Statement
Click Generate

See in Action

What's included

The report only includes accounts that have activity in the year selected otherwise, the income statement will add clutter with unnecessary lines.

All revenue accounts (4xxx)
Cost of Goods Sold (5xxx)
Operating Expenses (6xxx)
Other Income/Expense (7xxx, 8xxx)
Calculated rows: Gross Profit, Operating Income, Net Income

The resulting report is fully formula-driven — every number is live from NetSuite and can be refreshed at any time.

Build Budget Report

The Budget Report brings in your NetSuite Budget for a specific year. With this information at hand, you can easily build formula-driven Budget vs Actuals reports.

How to generate it

Open the XAVI task pane and click Quick Start
More Reports then go to the Budget Report section
Add Budget year
Click Generate

See in Action

Customizing Pre-Built Reports

Pre-built reports are generated as standard Excel worksheets filled with XAVI formulas. Once generated, you can:

Add or remove rows and columns
Apply your own formatting
Insert additional formulas to calculate custom metrics (margins, variances, etc.)
Adjust filters to slice by department, location, or class

The underlying formulas continue to pull live data regardless of any formatting or structural changes you make.