Snapshots show your budgets, actuals, commitments, and projections by account coding combination. You can filter, export, and customise the view.
Open a Snapshot
In Access Education Budgets, click the Academy/School menu.
Under Budget Monitoring, click Manage Snapshots.
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.
