Table Tool

Create your own tables

Choose the data and area of interest you want to explore and then use filters to create your table.
Once you've created your table, you can download the data it contains for your own offline analysis.

  1. Step 1 Choose a publication

    Publication
    LA and school expenditure
  2. Step 2 View a featured table or create your own

    Subject
    LA maintained schools, revenue reserves, (National, Regional, LA levels) (£million)
  3. Step 3 Choose locations

    National
    • England
  4. Step 4 Choose time period

    Time period
    2015-16 to 2020-21
  5. Step 5 Choose your filters

    Indicators
    • Average revenue balance per school
    • Number of schools with a negative revenue balance
    • Number of schools with a surplus revenue balance
    • Percentage of schools with a negative revenue balance (deficit)
    • Percentage of schools with a surplus revenue balance
    • Revenue balance as a percentage of total income
    • Total revenue balance of schools with a deficit (£ million)
    • Total revenue balance of schools with a surplus (£ million)
    Phase of education
    • All LA maintained schools
    • Nursery
    • PRU
    • Primary
    • Secondary
    • Special
  6. Step 6 (current) Explore data

    Re-order table headers

    Drag and drop the options below to re-order the table headers. Hold the Ctrl key and click to select multiple items to drag and drop. For keyboard users, select and deselect a draggable item with space and use the arrow keys to move a selected item.

    To move an item with your keyboard, select or deselect the item with Space and use the Up and Down arrow keys to move the selected item. To move multiple items, you can press Ctrl and Enter to add an item to your selected items. If you are using a screen reader disable scan mode.

    Row groups
    Row group 1
    Nursery
    Primary
    PRU
    Secondary
    Special
    All LA maintained schools
    Row group 2
    Number of schools with a surplus revenue balance
    Percentage of schools with a surplus revenue balance
    Number of schools with a negative revenue balance
    Percentage of schools with a negative revenue balance (deficit)
    Total revenue balance of schools with a surplus (£ million)
    Total revenue balance of schools with a deficit (£ million)
    Average revenue balance per school
    Revenue balance as a percentage of total income
    Column groups
    Column group 1
    2015-16
    2016-17
    2017-18
    2018-19
    2019-20
    2020-21
    This is the latest data
    'LA maintained schools, revenue reserves, (National, Regional, LA levels) (£million)' for All LA maintained schools, Nursery, PRU, Primary, Secondary and 1 other filter in England between 2015-16 and 2020-21
    2015-162016-172017-182018-192019-202020-21
    NurseryNumber of schools with a surplus revenue balance351328314321304287
    Percentage of schools with a surplus revenue balance87.381.679.781.779.275.1
    Number of schools with a negative revenue balance517380698094
    Percentage of schools with a negative revenue balance (deficit)12.718.220.317.620.824.6
    Total revenue balance of schools with a surplus (£ million)37.033.033.636.536.338.5
    Total revenue balance of schools with a deficit (£ million)-2.6-3.8-4.9-6.7-8.8-12.2
    Average revenue balance per school85,37372,67273,03275,72871,62168,738
    Revenue balance as a percentage of total income12.110.410.210.49.69.6
    PrimaryNumber of schools with a surplus revenue balance13,28712,46111,49510,7299,8839,929
    Percentage of schools with a surplus revenue balance94.792.290.891.389.192.9
    Number of schools with a negative revenue balance6279541,0199271,145711
    Percentage of schools with a negative revenue balance (deficit)4.57.18.17.910.36.7
    Total revenue balance of schools with a surplus (£ million)1,545.31,349.41,302.91,291.61,223.11,596.4
    Total revenue balance of schools with a deficit (£ million)-23.2-42.1-50.9-52.2-74.1-63.6
    Average revenue balance per school108,52996,75398,924105,488103,539143,432
    Revenue balance as a percentage of total income8.47.47.47.77.29.6
    PRUNumber of schools with a surplus revenue balance229196176172153150
    Percentage of schools with a surplus revenue balance80.975.172.478.273.677.7
    Number of schools with a negative revenue balance334747354333
    Percentage of schools with a negative revenue balance (deficit)11.718.019.315.920.717.1
    Total revenue balance of schools with a surplus (£ million)43.139.436.534.031.339.6
    Total revenue balance of schools with a deficit (£ million)-2.6-5.8-9.7-6.2-8.3-6.2
    Average revenue balance per school142,843128,738110,218126,282110,737173,298
    Revenue balance as a percentage of total income9.58.06.77.16.08.9
    SecondaryNumber of schools with a surplus revenue balance1,008830705645601629
    Percentage of schools with a surplus revenue balance80.871.768.070.472.880.8
    Number of schools with a negative revenue balance222304313260221147
    Percentage of schools with a negative revenue balance (deficit)17.826.330.228.426.818.9
    Total revenue balance of schools with a surplus (£ million)394.8309.7260.9253.1275.2378.9
    Total revenue balance of schools with a deficit (£ million)-82.5-126.4-151.4-147.9-150.2-127.9
    Average revenue balance per school250,419158,420105,593114,935151,343322,615
    Revenue balance as a percentage of total income4.62.91.92.02.54.9
    SpecialNumber of schools with a surplus revenue balance746683646592552536
    Percentage of schools with a surplus revenue balance91.488.289.587.186.087.0
    Number of schools with a negative revenue balance678373858674
    Percentage of schools with a negative revenue balance (deficit)8.210.710.112.513.412.0
    Total revenue balance of schools with a surplus (£ million)186.6162.2160.1159.8156.9215.0
    Total revenue balance of schools with a deficit (£ million)-8.9-13.5-16.5-20.3-25.0-27.5
    Average revenue balance per school217,756192,106199,025205,056205,390304,433
    Revenue balance as a percentage of total income8.97.57.47.36.79.2
    All LA maintained schoolsNumber of schools with a surplus revenue balance15,62114,49813,33612,45911,49311,531
    Percentage of schools with a surplus revenue balance93.190.088.689.387.391.1
    Number of schools with a negative revenue balance1,0001,4611,5321,3761,5751,059
    Percentage of schools with a negative revenue balance (deficit)6.09.110.29.912.08.4
    Total revenue balance of schools with a surplus (£ million)2,206.71,893.71,794.01,775.01,722.92,268.4
    Total revenue balance of schools with a deficit (£ million)-119.9-191.7-233.3-233.3-266.4-237.4
    Average revenue balance per school124,415105,683103,690110,448110,692160,486
    Revenue balance as a percentage of total income7.56.46.26.46.18.5

    Footnotes

    1. There are a small number of local authorities with no LA maintained secondary schools, all are academies.
    2. Includes schools making a part year return as they converted to academies part way through the financial year

    Save table

    Download Table

    Select file format: