Skip to main content

Overview: Generate the CFO Flash Report

ExtendInsights FRE | Generate a high-level Profit and Loss summary

The CFO Flash Report provides 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 depend on a specific account numbering scheme.


Generate the Report

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

  2. Select Quick Start.

  3. Go to Report.

  4. Select CFO Flash Report.

  5. Choose a fiscal year.

  6. Select Generate.


What the Report Includes

The report includes summary rows for:

  • Revenue

  • Cost of Goods Sold

  • Gross Profit

  • Operating Expenses

  • Net Income


How the Report Uses Filters

The formulas can reference worksheet cells containing a period and filter values. For example, a 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 formulas that use it recalculate.


Notes

Pre-built reports are examples to help you build your own reports. Their formulas and layouts may change in future releases.

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


Related Articles


Need Help?

Did this answer your question?