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 Select a data set or featured table

    Data set
    CFR School Revenue Balances (National, Regional, LA Levels))
  3. Step 3 Choose locations

    National
    • England
  4. Step 4 Choose time period

    Time period
    2014-15 to 2019-20
  5. Step 5 Choose your filters

    Indicators
    • Average revenue balance
    • Committed revenue balance (B01)
    • Community focussed extended school revenue balance (B06)
    • Revenue balance as percentage of total income
    • Total Income
    Phase
    • Total
    • Nursery
    • Primary
    • Pupil referral unit
    • Secondary
    Revenue state
    • Total
    • Deficit
    • Surplus
  6. Step 6 (current) Explore data

    This data is not from the latest release
    View latest data: Financial year 2022-23
    'CFR School Revenue Balances (National, Regional, LA Levels))' for Deficit, Nursery, Primary, Pupil referral unit, Secondary and 2 other filters in England between 2014-15 and 2019-20
    TotalDeficitSurplus
    Number of schoolsPercentage of schoolsTotal revenue balanceCommitted revenue balance (B01)Uncommitted revenue balance (B02)Community focussed extended school revenue balance (B06)Average revenue balanceTotal IncomeRevenue balance as percentage of total incomeNumber of schools over surplus thresholdPercentage of schools over surplus thresholdTotal value of surplus over surplus thresholdAverage value of surplus over surplus thresholdNumber of schoolsPercentage of schoolsTotal revenue balanceCommitted revenue balance (B01)Uncommitted revenue balance (B02)Community focussed extended school revenue balance (B06)Average revenue balanceTotal IncomeRevenue balance as percentage of total incomeNumber of schools over surplus thresholdPercentage of schools over surplus thresholdTotal value of surplus over surplus thresholdAverage value of surplus over surplus thresholdNumber of schoolsPercentage of schoolsTotal revenue balanceCommitted revenue balance (B01)Uncommitted revenue balance (B02)Community focussed extended school revenue balance (B06)Average revenue balanceTotal IncomeRevenue balance as percentage of total incomeNumber of schools over surplus thresholdPercentage of schools over surplus thresholdTotal value of surplus over surplus thresholdAverage value of surplus over surplus threshold
    Total2014-1517,692100.0%£2,119.230m£1,083,319,617£998,606,138£37,304,429£0.120m£28,112.675m7.5%::::9485.4%-£103.040m-£69,387,246-£33,487,895-£164,449-£0.109m£1,788.937m-5.8%::::16,53393.4%£2,222.270m£1,152,692,436£1,032,111,309£37,466,029£0.134m£26,323.739m8.4%8,07345.6%£729.278m£90,335
    2015-1616,768100.0%£2,086.816m£1,035,149,493£1,015,350,096£36,316,616£0.124m£27,630.163m7.6%::::1,0016.0%-£119.868m-£64,714,687-£53,346,549-£1,806,835-£0.120m£2,116.186m-5.7%::::15,62193.2%£2,206.684m£1,099,864,180£1,068,708,106£38,111,991£0.141m£25,513.977m8.6%8,00347.7%£737.537m£92,158
    2016-1716,106100.0%£1,702.079m£826,368,882£839,437,329£36,272,737£0.106m£26,503.107m6.4%::::1,4619.1%-£191.665m-£104,009,520-£88,562,062£907,034-£0.131m£3,049.676m-6.3%::::14,49990.0%£1,893.743m£930,298,969£927,999,392£35,445,137£0.131m£23,453.431m8.1%6,50640.4%£607.751m£93,414
    2017-1815,050100.0%£1,560.740m£784,293,144£739,649,004£36,797,406£0.104m£24,948.985m6.3%::::1,53210.2%-£233.248m-£70,448,056-£162,480,819-£318,697-£0.152m£3,178.122m-7.3%::::13,33688.6%£1,793.987m£854,663,099£902,403,781£36,920,245£0.135m£21,770.863m8.2%6,16441.0%£580.475m£94,172
    2018-1913,936100.0%£1,541.747m£827,377,263£681,289,678£33,080,292£0.111m£23,880.424m6.5%::::1,3769.9%-£233.259m-£2,505,348-£232,515,588£1,761,531-£0.170m£2,820.868m-8.3%::::12,45989.4%£1,775.007m£829,882,611£913,803,824£31,320,202£0.142m£21,059.557m8.4%5,98042.9%£578.639m£96,762
    2019-2013,158100.0%£1,456.486m£734,948,142£686,600,486£34,937,241£0.111m£22,980.858m6.3%::::1,57512.0%-£266.361m£2,126,835-£270,955,325£2,467,336-£0.169m£2,998.259m-8.9%::::11,49387.3%£1,722.847m£732,821,290£957,580,720£32,445,013£0.150m£19,982.600m8.6%5,54142.1%£600.601m£108,392
    Nursery2014-15407100.0%£34.525m£17,544,134£10,973,162£6,007,778£0.085m£279.441m12.4%::::4310.6%-£1.930m-£273,150-£905,208-£752,088-£0.045m£25.432m-7.6%::::36389.2%£36.456m£17,817,283£11,878,371£6,759,866£0.100m£254.009m14.4%23858.5%£19.221m£80,762
    2015-16402100.0%£34.320m£14,249,672£15,568,660£4,501,488£0.085m£283.438m12.1%::::5112.7%-£2.641m-£694,691£389,119-£2,335,043-£0.052m£32.111m-8.2%::::35187.3%£36.960m£14,944,363£15,179,541£6,836,531£0.105m£251.327m14.7%24761.4%£19.891m£80,530
    2016-17402100.0%£29.214m£10,446,407£12,958,215£5,809,563£0.073m£281.098m10.4%::::7318.2%-£3.828m-£1,622,774-£1,932,898-£272,002-£0.052m£46.142m-8.3%::::32881.6%£33.042m£12,069,180£14,891,113£6,081,565£0.101m£234.956m14.1%21353.0%£17.483m£82,081
    2017-18394100.0%£28.774m£10,029,019£15,494,397£3,250,997£0.073m£281.641m10.2%::::8020.3%-£4.864m-£1,946,209-£3,281,984£364,330-£0.061m£56.328m-8.6%::::31479.7%£33.638m£11,975,229£18,776,381£2,886,667£0.107m£225.314m14.9%21855.3%£17.987m£82,508
    2018-19390100.0%£29.761m£12,586,876£15,401,022£1,773,082£0.076m£286.775m10.4%::::6917.7%-£6.723m£0-£7,207,479£484,979-£0.097m£48.916m-13.7%::::32182.3%£36.483m£12,586,876£22,608,501£1,288,103£0.114m£237.859m15.3%21454.9%£20.379m£95,230
    2019-20385100.0%£27.485m£12,960,696£15,870,832-£1,346,441£0.071m£256.213m10.7%::::8121.0%-£8.823m£3,875-£9,051,898£224,598-£0.109m£53.474m-16.5%::::30479.0%£36.309m£12,956,822£24,922,730-£1,571,039£0.119m£202.739m17.9%21856.6%£22.241m£102,024
    Primary2014-1514,733100.0%£1,497.612m£748,819,522£722,834,716£25,957,693£0.102m£18,123.680m8.3%::::6164.2%-£21.851m-£25,507,499£2,831,925£824,570-£0.035m£663.731m-3.3%::::13,97994.9%£1,519.463m£774,312,594£720,022,403£25,127,937£0.109m£17,459.949m8.7%6,58944.7%£436.911m£66,309
    2015-1614,019100.0%£1,522.115m£756,132,971£739,602,944£26,379,361£0.109m£18,154.291m8.4%::::6274.5%-£23.169m-£12,943,562-£10,675,416£450,302-£0.037m£782.263m-3.0%::::13,28794.8%£1,545.284m£769,076,533£750,278,359£25,929,059£0.116m£17,372.028m8.9%6,61947.2%£460.067m£69,507
    2016-1713,511100.0%£1,307.230m£634,778,189£647,300,139£25,151,804£0.097m£17,646.843m7.4%::::9547.1%-£42.131m-£24,763,345-£17,479,864£112,074-£0.044m£1,217.249m-3.5%::::12,46192.2%£1,349.361m£659,542,848£664,780,003£25,038,415£0.108m£16,429.594m8.2%5,39239.9%£387.877m£71,936
    2017-1812,656100.0%£1,251.986m£605,472,686£618,616,724£27,896,925£0.099m£16,725.332m7.5%::::1,0198.1%-£50.872m-£11,638,211-£37,705,411-£1,528,605-£0.050m£1,312.140m-3.9%::::11,49590.8%£1,302.859m£617,110,897£656,517,994£29,229,672£0.113m£15,413.191m8.5%5,14840.7%£383.350m£74,466
    2018-1911,726100.0%£1,238.961m£604,674,648£606,183,041£28,102,889£0.106m£16,109.850m7.7%::::9277.9%-£52.146m£22,821-£53,929,705£1,760,843-£0.056m£1,172.714m-4.4%::::10,72491.5%£1,291.107m£604,651,827£660,112,746£26,342,047£0.120m£14,937.136m8.6%5,01342.8%£384.180m£76,637
    2019-2011,097100.0%£1,149.098m£528,575,958£587,760,277£32,761,475£0.104m£15,509.235m7.4%::::1,14410.3%-£74.034m£1,162,945-£77,666,271£2,469,715-£0.065m£1,480.473m-5.0%::::9,88389.1%£1,223.131m£527,412,996£665,319,251£30,399,074£0.124m£14,028.762m8.7%4,60841.5%£380.269m£82,524
    Secondary2014-151,400100.0%£369.255m£210,921,316£154,726,839£3,607,215£0.264m£7,325.728m5.0%::::21015.0%-£68.526m-£36,587,774-£31,646,228-£291,756-£0.326m£942.048m-7.3%::::1,15782.6%£437.781m£247,509,090£186,373,066£3,898,971£0.378m£6,383.680m6.9%65046.4%£186.380m£286,739
    2015-161,247100.0%£312.272m£163,512,520£145,615,700£3,143,825£0.250m£6,783.557m4.6%::::22217.8%-£82.498m-£43,516,635-£38,891,379-£90,431-£0.372m£1,077.714m-7.7%::::1,00880.8%£394.770m£207,029,155£184,518,540£3,222,796£0.392m£5,705.843m6.9%57145.8%£169.798m£297,369
    2016-171,157100.0%£183.292m£98,608,786£81,109,109£3,574,537£0.158m£6,208.913m3.0%::::30426.3%-£126.425m-£64,000,344-£63,019,709£594,878-£0.416m£1,507.389m-8.4%::::83071.7%£309.718m£162,528,381£144,128,818£3,060,408£0.373m£4,701.524m6.6%43137.3%£129.626m£300,757
    2017-181,037100.0%£109.500m£84,779,129£21,534,981£3,185,389£0.106m£5,630.537m1.9%::::31330.2%-£151.357m-£51,633,620-£100,682,801£959,220-£0.484m£1,548.615m-9.8%::::70568.0%£260.857m£136,334,648£122,295,882£2,226,170£0.370m£4,081.923m6.4%35434.1%£108.410m£306,242
    2018-19920100.0%£105.806m£127,399,531-£23,182,977£1,589,185£0.115m£5,199.893m2.0%::::26028.3%-£147.849m-£2,952,715-£144,598,770-£297,029-£0.569m£1,304.049m-11.3%::::65070.7%£253.654m£130,352,247£121,415,793£1,886,214£0.390m£3,895.844m6.5%32835.7%£105.471m£321,557
    2019-20826100.0%£125.009m£117,138,272£5,456,020£2,414,947£0.151m£4,973.825m2.5%::::22126.8%-£150.218m£843,076-£150,887,840-£173,162-£0.680m£1,158.574m-13.0%::::60172.8%£275.227m£116,295,196£156,343,860£2,588,109£0.458m£3,815.251m7.2%32839.7%£128.121m£390,614
    Special2014-15843100.0%£179.112m£89,310,531£88,126,794£1,674,372£0.212m£1,972.962m9.1%::::556.5%-£8.494m-£6,140,987-£2,407,590£54,825-£0.154m£124.654m-6.8%::::77992.4%£187.605m£95,451,518£90,534,384£1,619,547£0.241m£1,848.308m10.2%44652.9%£68.864m£154,404
    2015-16816100.0%£177.689m£85,520,950£89,924,908£2,242,987£0.218m£1,998.240m8.9%::::678.2%-£8.927m-£5,589,420-£3,501,361£164,023-£0.133m£172.222m-5.2%::::74691.4%£186.616m£91,110,370£93,426,269£2,078,964£0.250m£1,826.018m10.2%42652.2%£68.087m£159,829
    2016-17774100.0%£148.690m£68,170,077£78,896,952£1,622,876£0.192m£1,960.646m7.6%::::8310.7%-£13.506m-£9,137,093-£4,832,865£463,854-£0.163m£204.923m-6.6%::::68388.2%£162.196m£77,307,170£83,729,817£1,159,021£0.237m£1,755.723m9.2%35445.7%£54.355m£153,546
    2017-18722100.0%£143.696m£69,506,619£72,158,551£2,031,047£0.199m£1,930.882m7.4%::::7310.1%-£16.447m-£4,511,877-£11,805,582-£129,311-£0.225m£180.372m-9.1%::::64689.5%£160.143m£74,018,496£83,964,132£2,160,358£0.248m£1,750.510m9.1%33546.4%£52.460m£156,597
    2018-19680100.0%£139.438m£70,039,736£67,823,359£1,574,845£0.205m£1,907.041m7.3%::::8512.5%-£20.316m£441,107-£20,569,840-£187,261-£0.239m£227.496m-8.9%::::59287.1%£159.754m£69,598,629£88,393,199£1,762,106£0.270m£1,679.545m9.5%32748.1%£52.983m£162,029
    2019-20642100.0%£131.861m£64,847,448£65,911,157£1,101,964£0.205m£1,897.969m6.9%::::8613.4%-£25.013m£45,001-£25,013,236-£44,535-£0.291m£227.426m-11.0%::::55286.0%£156.873m£64,802,446£91,056,599£1,014,292£0.284m£1,670.543m9.4%30347.2%£54.748m£180,687
    Pupil referral unit2014-15309100.0%£38.726m£16,724,115£21,944,627£57,371£0.125m£410.865m9.4%::::247.8%-£2.239m-£877,836-£1,360,794£0-£0.093m£33.072m-6.8%::::25582.5%£40.965m£17,601,951£23,303,085£59,707£0.161m£377.793m10.8%15048.5%£17.901m£119,341
    2015-16284100.0%£40.420m£15,733,380£24,637,885£48,956£0.142m£410.638m9.8%::::3412.0%-£2.634m-£1,970,379-£667,513£4,314-£0.077m£51.877m-5.1%::::22980.6%£43.054m£17,703,759£25,305,397£44,642£0.188m£358.761m12.0%14049.3%£19.694m£140,673
    2016-17262100.0%£33.652m£14,365,425£19,172,914£113,957£0.128m£405.607m8.3%::::4717.9%-£5.774m-£4,485,965-£1,296,726£8,230-£0.123m£73.973m-7.8%::::19775.2%£39.427m£18,851,389£20,469,640£105,727£0.200m£331.634m11.9%11644.3%£18.410m£158,708
    2017-18241100.0%£26.783m£14,505,691£11,844,351£433,048£0.111m£380.592m7.0%::::4719.5%-£9.708m-£718,139-£9,005,041£15,669-£0.207m£80.667m-12.0%::::17673.0%£36.491m£15,223,829£20,849,392£417,379£0.207m£299.925m12.2%10945.2%£18.269m£167,607
    2018-19220100.0%£27.782m£12,676,471£15,065,233£40,291£0.126m£376.865m7.4%::::3515.9%-£6.226m-£16,561-£6,209,793£0-£0.178m£67.692m-9.2%::::17278.2%£34.008m£12,693,032£21,273,585£41,732£0.198m£309.172m11.0%9844.5%£15.626m£159,444
    2019-20208100.0%£23.033m£11,425,768£11,602,201£5,296£0.111m£343.617m6.7%::::4320.7%-£8.273m£71,938-£8,336,080-£9,281-£0.192m£78.311m-10.6%::::15373.6%£31.307m£11,353,830£19,938,281£14,576£0.205m£265.306m11.8%8440.4%£15.222m£181,210

    Footnotes

    1. There are a small number of local authorities with no LA maintained secondary schools, are all academies.

    Save table

    Download Table

    Select file format:

    Related information

    Our statistical practice is regulated by the Office for Statistics Regulation (OSR)