What this article covers: How to use the Period Selector in any BrizoConsol report to compare actuals against last year, forecast, or budget — and how the built-in comparison reports use this to open with the right view pre-selected.

Every report in BrizoConsol has a Period Selector at the top of the page. Changing it reshapes the entire report — switching between a 12-month view, a rolling window, a year-on-year comparison, or an actuals vs forecast layout — without leaving the report or opening a different one.

BrizoConsol's built-in comparison reports (such as Profit & Loss Variance and Profit & Loss Forecast Variance) are standard reports that simply open with a comparison period pre-selected for you. You can change the period selector on any of them at any time.

The quickest way to run a comparison is to open one of BrizoConsol's built-in comparison reports — they open with the right period already selected. For more flexibility, every report has a Period Selector at the top of the page that lets you switch to any comparison or multi-period layout in one click.

1. Built-In Comparison Reports

BrizoConsol includes two dedicated comparison reports under Reports → All Reports → Performance. These are standard reports that open with a comparison period selector pre-selected — saving you the step of changing it manually:

Report Default Period Use for
Actual vs Last Year Year-on-year performance reviews, management and board reporting
Actual vs Forecast Monthly budget reviews, identifying where performance is ahead of or behind plan
💡 Tip: You can change the period selector on either built-in report at any time. For example, open Profit & Loss Variance and switch to Actual vs Budget to instantly compare actuals against budget instead of last year — no new report needed.
★ Tip: Click the star icon on a report in All Reports to add it to your favourites in the left navigation.

2. All Period Selector Options

Open any report and click the Period Selector at the top of the page. The following options are available:

Fiscal & Budget Year

Period Type Columns Generated
One column per month across the full fiscal year
Fiscal year monthly columns plus a full-year total column
One column per month across the full budget year
Two columns, H1 (January–June) and H2 (July–December)
Year-to-date for the current fiscal year and the one before
Budget year monthly columns plus a full-year total column

Rolling Periods

Period Type Columns Generated
One column per month for the last 3 months
One column per month for the last 6 months
One column per month for the last 9 months
One column per month for the last 12 months
One column per quarter for the last 4 quarters

Single Period Views

Period Type Columns Generated
A single column for the selected month
The selected quarter with a monthly breakdown
The selected period as a year-to-date total column
One YTD column per year for the last 3 years
Four columns: Debit, Credit, Debit YTD, and Credit YTD
One column at the end of the selected fiscal year
One column at the end of the fiscal year before
One column at the end of the fiscal year two years back

Comparison Views

These options generate variance columns automatically — no manual calculation needed.

Period Type Columns Generated
Current period actual, prior year actual, YTD actual, prior year YTD — plus the variance, and a % of Revenue column, for both
Current period actual, forecast, YTD actual, YTD forecast — plus the variance, and a % of Revenue column, for both
Current period actual, budget, YTD actual, YTD budget — plus the variance, and a % of Revenue column, for both

Custom Range

Period Type Columns Generated
Columns for a manually defined start and end period — use for ad-hoc date ranges not covered by the options above

3. Reading a Comparison View

When Actual vs Last Year, Actual vs Forecast, or Actual vs Budget is selected, the report generates the following columns for both the current period and YTD:

Column What it shows
The real financial result for the current period
The comparison figure for the same period
Actual minus the comparison figure. A positive variance is good on revenue and profit, and an overspend on a cost
Each line as a share of revenue — the margin beside the amounts

These columns appear for both the current period and YTD, giving you a complete picture of how performance tracks at a point in time and cumulatively across the year.

4. Common Workflows

📋 Monthly management pack
Open Profit & Loss Forecast Variance → period selector is already set to Actual vs Forecast → export to PDF. Done in under a minute with current-month actuals and YTD variance automatically calculated.
🏗 Board reporting — year-on-year
Open Profit & Loss Variance → period selector defaults to Actual vs Last Year → review current period and YTD variance columns → export or schedule delivery.
📈 12-month trend view
Open any P&L or custom report → change the period selector to Last 12 Months → see each of the past 12 months as a column to spot seasonal patterns or sustained trends.
🕑 Multi-year review
Open any report → change the period selector to Last 3 Years → view three YTD columns side by side for a long-run performance overview.

5. Exporting & Scheduling Comparison Reports

Once you have the view you need, use the export icons in the report header to download it as Excel (.xlsx) or PDF.

To deliver the same report automatically each month, use the Schedule feature. See Scheduling Dashboards, Reports, and Insight Packages for setup steps.

💡 Tip: For report display preferences — decimal places, negative number formatting, showing account codes — click the gear icon at the top-right of any report. See Report Settings.

Related Articles

Viewing Reports Built-in Reports in BrizoConsol Customizing Reports Report Settings Scheduling Dashboards, Reports & Insight Packages Accounting Standards