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.
📚 For report-specific details and generation steps, open the relevant guide in the Pre-Built Reports collection.
Fiscal Period Compatibility
Pre-built reports are designed to demonstrate what you can build with XAVI formulas. They may not work correctly with every fiscal calendar.
Reports are more likely to work when your accounting periods align with calendar months. If your company uses a 4-4-5 or 4-5-4 calendar, or has an adjustment period, a pre-built report may not run correctly.
For reports you rely on regularly, use the pre-built report as a reference and create a version suited to your fiscal calendar and reporting needs.
Refreshing Report Data
Financial Reporting caches data for one hour. If NetSuite transactions were recently posted and you need to retrieve them sooner, select Refresh All in the task pane.
Refresh performance depends on the amount of data requested and the NetSuite API resources available when the formulas are refreshed.
➡️ Good to know: Are There Limits When Using XAVI Formulas in a Workbook?
Customizing Pre-Built Reports
After generating a report, you can edit its Excel worksheet. For example, you can:
Add or remove rows and columns.
Apply your own formatting.
Add formulas for metrics such as margins or variances.
Adjust filters to analyze data by department, location, or class.
The report uses XAVI formulas to retrieve data from NetSuite. Changes to the worksheet may affect how the report works. Keep a copy of the generated report before making substantial changes, and check the formulas in any rows or columns you edit.
Pre-built report formulas and layouts may change in future releases. For reports used regularly, build and maintain a version tailored to your organization’s reporting requirements.
Available Reports
CFO Flash Report
View a high-level Profit and Loss summary grouped by account type.
➡️ Full Guide: Generate the CFO Flash Report
Full Income Statement
View a detailed Profit and Loss report with accounts that had activity during the selected year.
➡️ Full Guide: Generate the Full Income Statement
Balance Sheet Report
The Balance Sheet report shows assets, liabilities, and equity as of a selected period.
➡️ Full Guide: Generate the Balance Sheet
Cash Flow Statement
View operating, investing, and financing activities.
➡️ Full Guide: Generate the Cash Flow Statement
Comparative Reports
➡️ Full Guides:
Generate the Comparative Income Statement to compare profit and loss
Generate the Comparative Balance Sheet to compare assets, liabilities, and equity
Sample Comparative Balance Sheet
AR/AP Aging
The A/R Aging and A/P Aging templates show open receivables by customer and open payables by vendor.
➡️ Full Guide: Generate the AR/AP aging report
Budget Report
Retrieve NetSuite budget data for a selected year.
➡️ Full Guide: Generate the Budget Report
Budget vs Actual
Compare budgeted and actual amounts from NetSuite side by side.
➡️ Full Guide: Generate the Budget vs Actual Report
Trial Balance
Lists every GL account with its balance in Debit and Credit columns,
➡️ Full Guide: Generate the Trial Balance Report
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










