Overview
ExtendInsights Financial Reporting includes a Quick Start section in the task pane that lets you generate prebuilt reports without creating XAVI formulas from scratch. Select a report type, set the available parameters, and XAVI generates an example report directly in Excel.
Prebuilt reports are designed to showcase what is possible with XAVI formulas and give you a starting point for building your own financial reports. They are not intended to serve as permanent templates for day-to-day reporting.
Because we continue to refine and expand these examples, the formulas and layouts used in prebuilt reports may change in future releases.
For reports you use regularly, use the prebuilt reports as a guide and build your own version tailored to your subsidiaries, departments, fiscal calendar, and reporting requirements. This gives you greater control over the report and helps keep it stable as the prebuilt examples evolve.
Fiscal Period Compatibility
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.
CFO Flash Report
The CFO Flash Report is a high-level Profit and Loss summary. It uses XAVI.TYPEBALANCE to calculate totals by account type, such as Income, Cost of Goods Sold, and Expense. Because it groups accounts by type, it does not rely on a specific account numbering scheme.
Generate the CFO Flash Report
Open the Financial Reporting task pane and select Quick Start.
Go to Profit & Loss Report.
Choose a fiscal year.
Select CFO Flash Report.
Select Generate.
See in Action
For example, the Total Revenue formula may look like this:
=XAVI.TYPEBALANCE("Income",C$5,C$5,$Q$3,$R$3,$S$3,$T$3,$U$3)
In this example, C5 contains the period. Cells Q3 through U3 contain the Subsidiary, Department, Location, Class, and Accounting Book filters.
Referencing filter cells lets you change a filter value in one place and have the formulas that use it recalculate.
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.
Full Income Statement
Use Full Income Statement for a detailed Profit and Loss report that includes accounts with activity during the selected year.
Generate the Full Income Statement
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 includes:
Revenue accounts, typically in the 4xxx range
Cost of Goods Sold accounts, typically in the 5xxx range
Operating Expense accounts, typically in the 6xxx range
Other Income and Expense accounts, typically in the 7xxx and 8xxx ranges
Calculated rows such as Gross Profit, Operating Income, and Net Income
The report uses XAVI formulas to retrieve data from NetSuite. Financial Reporting caches data for one hour. To retrieve newly posted transactions sooner, select
Refresh All in the task pane.
Balance Sheet Report
The Balance Sheet report shows assets, liabilities, and equity as of a selected period.
Generate the Balance Sheet Report
Open the XAVI task pane and click Quick Start.
Select More Reports, then go to the Balance Sheet Report section.
Add Period.
Click Generate.
Cash Flow Statement
The Cash Flow Statement report presents operating, investing, and financing activities.
Generate the Cash Flow Statement Report
Open the XAVI task pane and click Quick Start.
Select More Reports, then go to the Cash Flow Statement section
Add Period.
Click Generate.
Known Limitation
The template doesn't yet support custom fiscal calendars or drill down on all line items. When a Class, Department, or Location filter is applied, the Cash at End of Period amount may be incorrect.
Budget Report
The Budget Report retrieves NetSuite budget data for a selected year. Use it as a starting point for building a formula-driven Budget vs. Actual report.
Generate the Budget Report
Open the XAVI task pane and click Quick Start
Select 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.
See Also
📖 XAVI Formula Reference — Complete guide to all available formulas
📖 Using Wildcards for Summary Reports — Build full P&Ls with just a handful of formulas
📖 Filtering by Subsidiary, Department, Class & Location — Slice your data any way you need
📖 Drill-Down: Exploring Transactions Behind a Balance — Click into any number to see what's behind it
Need Help?
🔍 Visit the Help Center: https://www.cloudextend.io/support/
💬 Use the in-app chat
✉️ Email cloudextend-support@celigo.com