Skip to main content

Overview: Generate the Cash Flow Statement

ExtendInsights FRE | Generate a report of cash flow activities

A cash flow statement built with the indirect method that pulls live data from NetSuite through XAVI formulas. It starts with net income and adjusts for changes in working capital to show how cash moved during the period you choose. Figures update each time the report refreshes, so nothing needs to be typed in by hand.


Generate the Report

  1. Open the ExtendInsights Financial Reporting task pane in Excel.

  2. Select Quick Start.

  3. Select Reports.

  4. Go to the Cash Flow Statement section.

  5. Add a From period and To period.

  6. Select Generate.


How To Use It

All of the report's formulas look at the filter block at the top of the sheet. Change a filter and the whole statement recalculates.

  • From Period / To Period: The date range the report covers (for example, Jan 2026 – Mar 2026). The title updates automatically.

  • Subsidiary: The entity or consolidation level to report on.

  • Department, Location, Class, Custom Segments: Optional. Leave them blank to include everything, or pick a value to narrow the report.

  • Acct Book: The accounting book to report from (usually the primary book).

  • Cash Flow Sync: Keeps the report in sync with XAVI's cash flow settings.

Use the XAVI task pane's filter selector to fill in these cells.


What the Report Includes

  1. Net Income: NetSuite's net income for the selected period.

  2. Adjustments to Net Income: Changes in Accounts Receivable, Inventory, and Accounts Payable during the period.

  3. Total Operating Activities: Net income plus the adjustments.

  4. Net Change in Cash: The total change in cash for the period.

  5. Cash at Beginning / End of Period: Bank and undeposited funds balances. Ending cash is beginning cash plus the net change.

The report finds accounts by account type, not by account number, so it works with any chart of accounts. Totals and subtotals are standard Excel formulas.


Known Limitations

The pre-built Cash Flow Statement:

  • Does not yet support custom fiscal calendars.

  • Does not support drill-down on all line items.

  • May show an incorrect Cash at End of Period amount when you apply a Class, Department, or Location filter.

If you use one of these filters, check the ending cash amount against your expected results before relying on the report.


Notes

Pre-built reports are examples, not permanent templates for day-to-day reporting.

📖 Review Working with Pre-Built Reports for guidance about fiscal period compatibility and customization.


Related Articles


Need Help?

Did this answer your question?