Data set from LA and school expenditure

School revenue reserves - unrounded data

Not the latest data
Published
Last updated
This file contains unrounded data on revenue reserves of local authority maintained schools. It includes local authority, regional and national data.  It was collected via the Consistent Financial reporting data collection.

Data set details

Theme
Finance and funding
Publication
LA and school expenditure
Release type
Number of rows
6,006
Geographic levels
Local authority, National, Regional
Indicators
  • Average revenue balance per school
  • Average surplus per school for schools over the threshold
  • Committed revenue balances (B01)
  • Community-focused school revenue balances (B06)
  • Devolved formula capital balance (B03)
  • Number of schools making a Consistent Financial Reporting (CFR) return
  • Number of schools with a negative revenue balance
  • Number of schools with a surplus over the threshold
  • Number of schools with a surplus revenue balance
  • Opening capital balance (OB03)
  • Opening community-focused revenue balance (OB02)
  • Opening pupil-focused revenue balance (OB01)
  • Other capital balances (B05)
  • Outstanding balance of capital loans to schol (B07)
  • Percentage of schools with a negative revenue balance (deficit)
  • Percentage of schools with a surplus over the threshold
  • Percentage of schools with a surplus revenue balance
  • Revenue balance as a percentage of total income
  • Total income
  • Total revenue balance
  • Total revenue balance of schools with a deficit
  • Total revenue balance of schools with a surplus
  • Total surplus of schools over the threshold
  • Uncommitted revenue balances (B02)
Filters
  • Phase of school
Time period
2015-16 to 2021-22

Data set preview

Table showing first 5 rows, from underlying data
time_periodtime_identifiergeographic_levelcountry_namecountry_coderegion_nameregion_codela_nameold_la_codenew_la_codeschool_phasenumber_schoolsnumber_schools_with_surplusnumber_schools_with_deficitPC_schools_with_surplusPC_schools_with_deficittotal_revenue_balanceaverage_revenue_balancerevenue_balance_as_pc_total_incometotal_revenue_reserve_schools_surplustotal_revenue_reserve_schools_deficitnumber_schools_with_surplus_over_thresholdpc_schools_with_surplus_over_thresholdschool_surplus_over_thresholdschool_over_threshold_av_per_schoolcommitted_revenue_balances(B01)uncommitted_revenue_balances(B02)devolved_formula_capital_balance(B03)other_capital_balances(B05)community_focussed_school_revenue_balance(B06)outstanding_balance_of_capital_loans_to_school(B07)opening_pupil_focussed_revenue_balance(OB01)opening_community_focussed_revenue_balance(OB02)opening_capital_balance(OB03)total_income
201516Financial yearNationalEnglandE92000001All LA maintained schools1677415621100093.1620868204601244157.62206684277-119863817807451.71677025271207707103515374810153500961371934584757025936316616x20106997443575507218998804127563969208
201516Financial yearNationalEnglandE92000001Nursery4023515187.312.7343198208537312.236960434-264061524770.43386725413711414249672155686603634014246374501488x2831372858796063788419282046263
201516Financial yearNationalEnglandE92000001Primary140261328762794.74.515221152751085298.41545283952-23168676668450.31128208808168792756132971739602944993835782408581226379361x14199387642505649013130509618081669834
201516Financial yearNationalEnglandE92000001PRU2832293380.911.7404244751428439.643053798-262932314061.1365446752610331573763424637885345406614630948956x36846139484153752350422157576
201516Financial yearNationalEnglandE92000001Secondary1247100822280.817.83122720452504194.6394770490-8249844557356.832776145757201016351252014561570019312529181926583143825x3521558833267534341117306792774695

Variables in this data set

Table showing all 25 variables
Variable nameVariable description
average_revenue_balanceAverage revenue balance per school
committed_revenue_balances(B01)Committed revenue balances (B01)
community_focussed_school_revenue_balance(B06)Community-focused school revenue balances (B06)
devolved_formula_capital_balance(B03)Devolved formula capital balance (B03)
number_schoolsNumber of schools making a Consistent Financial Reporting (CFR) return
number_schools_with_deficitNumber of schools with a negative revenue balance
number_schools_with_surplusNumber of schools with a surplus revenue balance
number_schools_with_surplus_over_thresholdNumber of schools with a surplus over the threshold
opening_capital_balance(OB03)Opening capital balance (OB03)
opening_community_focussed_revenue_balance(OB02)Opening community-focused revenue balance (OB02)
opening_pupil_focussed_revenue_balance(OB01)Opening pupil-focused revenue balance (OB01)
other_capital_balances(B05)Other capital balances (B05)
outstanding_balance_of_capital_loans_to_school(B07)Outstanding balance of capital loans to schol (B07)
PC_schools_with_deficitPercentage of schools with a negative revenue balance (deficit)
PC_schools_with_surplusPercentage of schools with a surplus revenue balance
pc_schools_with_surplus_over_thresholdPercentage of schools with a surplus over the threshold
revenue_balance_as_pc_total_incomeRevenue balance as a percentage of total income
school_over_threshold_av_per_schoolAverage surplus per school for schools over the threshold
school_phasePhase of school
school_surplus_over_thresholdTotal surplus of schools over the threshold
total_incomeTotal income
total_revenue_balanceTotal revenue balance
total_revenue_reserve_schools_deficitTotal revenue balance of schools with a deficit
total_revenue_reserve_schools_surplusTotal revenue balance of schools with a surplus
uncommitted_revenue_balances(B02)Uncommitted revenue balances (B02)

Footnotes

  1. There are a small number of local authorities with no LA maintained secondary schools, all are academies. Thurrock returned no data from primary schools in 2021-22. There are also authorities returning no nursery schools, pupil referral units or special schools. Full details are in the methodology document. These local authorities will be uncoloured in the maps above.
  2. Includes schools making a part year return as they converted to academies part way through the financial year

Using this data

  • Download the underlying data as a compressed ZIP file

  • View or create your own tables

    View tables that we have built for you, or create your own tables from open data using our table tool

Download this data using code

Access this data using common programming languages using the URL below.

Example code

Python
import pandas as pd

pd.read_csv("https://explore-education-statistics.service.gov.uk/data-catalogue/data-set/ca3c494e-f12d-43e8-8752-3e15fca3438c/csv")
R
read.csv("https://explore-education-statistics.service.gov.uk/data-catalogue/data-set/ca3c494e-f12d-43e8-8752-3e15fca3438c/csv")

Contact us

If you have a specific enquiry about School revenue reserves - unrounded data statistics and data:

Workforce and Finance Statistics Team

Email: finance.statistics@education.gov.uk
Contact name: Workforce and Finance Statistics Team