Skip to main content

Open and Understand Budget Monitoring Snapshots

Learn how to open a Budget Monitoring Snapshot, understand the key columns, and export the data.

Written by Cristina Gruita
Updated over 2 months ago

Snapshots show your budgets, actuals, commitments, and projections by account coding combination. You can filter, export, and customise the view.


Open a Snapshot

  1. In Access Education Budgets, click the Academy/School menu.

  2. Under Budget Monitoring, click Manage Snapshots.

  3. Click the Snapshot Name in the grid to open it.

Each row represents one combination of account coding (Ref 1, Ref 2, Ref 3, Ref 4). Budget coding is matched to actuals coding.

  • You can filter the grid using the search box.

  • You can export the grid to Excel using Export to Excel.


Snapshot Data Columns (Overview)

Below is an overview of the main columns and how they are calculated:

  • Total for the current budget year – Original Budget

    • Budgeted total of lines in the Original Budget scenario for that account coding combination.

  • Total for the current budget year – Current Budget

    • Budgeted total of lines in the Current Budget scenario for that account coding combination.

  • Budget Variance – Original Budget

    • Variance between Original and Current Budget.

    • Calculation: Current Budget – Original Budget.

  • Total actuals for the year to date – Actual To Date

    • Total actuals to date for that coding combination, from Access Education Finance or Excel import.

  • Total commitments for the year to date – Commitments

    • Total commitments to date for that coding combination, from Access Education Finance or Excel import.

  • Actual Inc Commitments

    • Total of actuals and commitments to date.

    • Calculation: Actual To Date + Commitments.

  • % of Budget Spent

    • Percentage of the Current Budget already used by actuals and commitments.

    • Calculation: Actual Inc Commitments ÷ Current Budget.

  • Projection to End of Year

    • Budgeted total for the remaining periods after the month actuals have been imported for, based on the Current Budget profile.

  • Adjustment

    • Total adjustment value entered in the Adjustments column for that row.

  • Expected Outturn

    • Expected total at year end based on actuals, commitments, projections, and adjustments.

    • Calculation: Actual Inc Commitments + Projection to End of Year + Adjustments.

  • Actual Variance

    • Variance between Current Budget and Expected Outturn.

    • Calculation: Current Budget – Expected Outturn.

  • Budget Adjustment

    • Total of budget adjustments entered in the Budget Adjustment column (saved back to the Current Scenario).

  • New Budget

    • Current Budget after applying Budget Adjustments.

    • Calculation: Current Budget + Budget Adjustment.

  • New Variance

    • Variance between the New Budget and Expected Outturn.

    • Calculation: New Budget – Expected Outturn.

Did this answer your question?