Give a report's columns a fixed start date or fixed period, such as a financial year, so they stay on that period instead of moving with the current month. Use Option 1 to fix the columns of an existing report, or Option 2 to create a new report with a fixed period.
Option 1: Fix the columns of an existing report
- Open the report on the Reports tab and click Edit > Edit columns.
- On the column you want to fix, switch Dynamic to Fixed.
- Choose the Time element and the Fixed Start Date. The Fixed End Date is optional. If the Time element is Quarter or Year, ScaleXP shows one column for each financial quarter or year your dates touch, cut to the months you chose. The months covered appear under the column name (for example Sep-Oct 2026), and a cut year isn't labeled Full Year.
- Click Save & Exit.

Note: Dynamic, the default, moves the column relative to the current month.
Option 2: Create a new report with a fixed period
- Go to Reports and click + New > New report.
- Under Starting with a template, choose P&L, Balance Sheet or Cashflow.
- Open the Fixed Period tab and choose the Start month. The End month is optional.
- Choose which columns to show, name the report and click Save.

How to view a report as at a specific date
To see a Balance Sheet or P&L as at (or as of) a specific month end, set the Data as of month next to the report title to that month. The report's columns then end in that month.
For a column that always shows the same date, whatever month you view, set it to Fixed as in Option 1 and choose a Fixed End Date in that month.