Skip to main content

Pre-Built Reports

ExtendInsights FRE | Generate sample reports with Quick Start

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.


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 Income Statement

View a detailed Profit and Loss report with accounts that had activity during the selected year.


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.


Comparative Reports

➡️ Full Guides:

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.


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.


Trial Balance

Lists every GL account with its balance in Debit and Credit columns,


See Also


Need Help?

Did this answer your question?