Reports

Reports configure the output worksheets in your generated Excel model. While the working worksheets contain raw calculations and formulas, report worksheets are formatted presentations designed for sharing with stakeholders, printing, and inclusion in board packages or investor materials.

Reports transform the model's analytical data into polished, readable financial statements.

Report Formats

Each financial statement can be generated in up to three levels of detail. The format controls which accounts are included and how much granularity the reader sees.

Long Format

The Long format includes every account in the hierarchy for the given statement. It mirrors the full chart of accounts, showing all parent accounts, detail accounts, and subtotals. This is the most comprehensive view.

Best for: Internal finance teams, auditors, and analysts who need to trace every line item. Long format is a working document, not a presentation.

Medium Format

The Medium format includes accounts that have been flagged for medium report inclusion in the Accounts section. This typically covers major categories and key subtotals while omitting granular detail lines.

Best for: Management reporting, monthly financial reviews, and operational dashboards. It balances detail with readability.

Short Format

The Short format includes only accounts flagged for short report inclusion. This is the most condensed view, typically showing only top-level categories and final totals.

Best for: Board presentations, investor summaries, and executive briefings where brevity is essential. A short format Income Statement might show only Revenue, Total Expenses, EBITDA, and Net Income.

Controlling Which Accounts Appear

The Medium and Short formats do not automatically decide which accounts to include. Instead, each account in the Accounts section has report inclusion flags:

• Include in Medium Report — check this for accounts that should appear in the Medium format.
• Include in Short Report — check this for accounts that should appear in the Short format.

The Long format always includes all accounts regardless of these flags.

This design gives you complete control over report content. You decide which line items matter for each audience.

Settings

Include Outputs

Master toggle that enables or disables report generation. When off, no report worksheets are created.

Outputs Data Source

Determines which analysis data feeds the reports:

• Analysis — uses the Full Analysis consolidation (all accounts, all units combined).
• Quick Analysis — uses the condensed Quick Analysis consolidation.
• Quick Analysis per Unit — uses per-unit condensed analysis, generating separate reports for each unit.

Choose the data source that matches the level of detail you want in your reports.

Default Values Divider

Controls how numeric values are scaled in the report:

| Divider | Effect | Example | |---------|--------|---------| | Units | Raw values, no scaling | 1,500,000 | | Thousands | Divided by 1,000 | 1,500 | | Millions | Divided by 1,000,000 | 1.5 |

The divider is displayed in the report header so readers know the scale. Choose the divider that makes your numbers easiest to read. For most mid-market companies, thousands works well. For large enterprises, millions is standard.

Values Decimal Places

The number of decimal places for financial values in the report (0, 1, or 2). For reports in millions, one or two decimal places are common. For reports in units, zero decimals is typical.

Metric Decimal Places

The number of decimal places for calculated metrics and ratios (margins, growth rates, returns). These are often shown with one or two decimals regardless of the values divider.

Per-Statement Toggles

Individual toggles to include or exclude each financial statement in the report output:

• Include Income Statement
• Include Balance Sheet
• Include Cash Flow Statement
• Include Valuation Summary

Smart Outputs

The Smart Outputs feature automatically determines the most appropriate report format based on the number of accounts in each statement. If a statement has relatively few accounts, the Long format is used since it is already concise. For statements with many accounts, the Medium or Short format provides a more digestible view. Smart Outputs saves time by removing the need to manually select formats for each statement.

Practical Tips

• Start with Long format during model development to verify all accounts and calculations.
• Configure Medium and Short flags in the Accounts section before generating final reports.
• Match the divider to your audience. Investors typically expect millions; operational managers may prefer thousands.
• Use zero decimal places for whole-number clarity when values are already divided by thousands or millions.