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
Open the ExtendInsights Financial Reporting task pane in Excel.
Select Quick Start.
Go to Report.
Select CFO Flash Report.
Choose a fiscal year.
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?
đ Visit the Help Center: https://www.cloudextend.io/support/
đŹ Use the in-app chat
âď¸ Email cloudextend-support@celigo.com




