Skip to main content

Management Report : Column Guide

Learn what the key columns in the Management Report refer to for a better understanding of your financial data.

Written by Cristina Gruita

The management report displays the selected period's actuals vs budgets, year-to-date values, budget comparisons, and full-year projections against ledger codes.

This guide explains the key columns within your management report and what they mean, helping you interpret financial performance with confidence.

Columns Overview

The Management Report contains four main sections:

  • Period Values.

  • Year to Date Values.

  • Budget Comparison.

  • Full Year Projection.

Each section contains columns that help you compare actual financial activity with budgeted values and projected year end positions.

As at Period Values

Column

What it shows

Actual

The amount spent or received during the selected period.

Current Budget

Budget allocated for the selected period.

Commitments (Optional)

Outstanding approved commitments for the selected period.

Variance (Β£)

Difference between Budget and Actuals (including Commitments if selected):

Income:

  • Positive = Surplus income against Budget.

  • Negative= Income shortfall against Budget.

Expenditure:

  • Positive= Underspent against Budget.

  • Negative= Overspent against Budget.

% of Budget Spent

Percentage of YTD Budget used or received (including Commitments if selected).

Year-to-Date (YTD) Values

Column

What it shows

Actual (YTD)

Total spent or received so far, in the current financial year.

Current Budget (YTD)

Budget allocated up to this point in the current year.

Commitments (Optional)

Outstanding approved commitments year to date.

Variance

Difference between YTD Budget and Actuals (including Commitments if selected):

Income:

  • Positive = Surplus income against Budget.

  • Negative= Income shortfall against Budget.

Expenditure:

  • Positive= Underspent against Budget.

  • Negative= Overspent against Budget.

% of Budget Spent

Percentage of YTD Budget used or received (including Commitments if selected).

Budget Comparison

This section compares the original budget against the latest updated budget across the full financial year( Periods 1-12).

Column

What it shows

Original Budget

Initial Budget imported into Finance.
As a best practice, this budget should be locked in Finance so that future Budget imports populate the Current Budget Column.

Current Budget

Latest imported budget.

Variance (Β£)

Difference between Original and Current Budget.

Full-Year Projection

This section provides a forecast of your expected financial position at year end.

Column

What it shows

Current Budget

Total full-year Budget.

Total Actuals + Commitments to Date

Spent or income so far ( including commitments if selected).

Additional Known Commitments

Expected income or expenditure that is not yet present in the system, this will be a manually entered value.

Remaining Profiled Budget

Allocated profiled Budget for the remainder of the year.

Projected Budget Outturn

Expected final year-end position:

Actuals +Commitments + Adjustments + Remaining Budgets.

Variance (Β£)

Difference between Current Budget and Projected Outturn.

Variance (%)

Variance as a percent of budget.

Notes

Free-text comments to add explanations, risks or context.

Did this answer your question?