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

   • Publication: LA and school expenditure

2. Step 2

   • Data set: CFR School Revenue Balances (National, Regional, LA Levels))

3. Step 3

   • Local authority:
     • Barking and Dagenham
     • Barnet
     • Barnsley
     • Bath and North East Somerset
     • Bedford Borough
   • National:
     • England
   • Regional:
     • East Midlands
     • East of England
     • Inner London
     • North East
     • North West

4. Step 4

   • Time period: 2019-20

5. Step 5

   • Indicators:
     • Average revenue balance
     • Total revenue balance
     • Number of schools
   • Phase:
     • Total
   • Revenue state:
     • Total
     • Deficit
     • Surplus

6. Step 6 Explore data

   This data is not from the latest release

   View latest data: Financial year 2022-23

   Some rows and columns are not shown in this table as the data does not exist in the underlying file.

   'CFR School Revenue Balances (National, Regional, LA Levels))' for Deficit and Surplus in Barking and Dagenham, Barnet, Barnsley, Bath and North East Somerset, Bedford Borough and 156 other locations for 2019-20

   		Total			Deficit			Surplus
   		Number of schools	Total revenue balance	Average revenue balance	Number of schools	Total revenue balance	Average revenue balance	Number of schools	Total revenue balance	Average revenue balance
   England		13,158	£1,456.486m	£0.111m	1,575	-£266.361m	-£0.169m	11,493	£1,722.847m	£0.150m
   Outer London	Barking and Dagenham	45	£12.289m	£0.273m	6	-£1.232m	-£0.205m	39	£13.521m	£0.347m
   	Barnet	89	£9.344m	£0.105m	17	-£1.898m	-£0.112m	72	£11.242m	£0.156m
   Yorkshire and the Humber	Barnsley	42	£2.392m	£0.057m	2	-£0.312m	-£0.156m	40	£2.704m	£0.068m
   South West	Bath and North East Somerset	18	£0.622m	£0.035m	2	-£0.403m	-£0.202m	16	£1.025m	£0.064m
   East of England	Bedford Borough	37	£4.347m	£0.117m	1	-£0.024m	-£0.024m	36	£4.371m	£0.121m
   Outer London	Bexley	20	£4.193m	£0.210m	2	-£0.167m	-£0.084m	18	£4.360m	£0.242m
   West Midlands	Birmingham	252	£76.691m	£0.304m	41	-£8.845m	-£0.216m	211	£85.536m	£0.405m
   North West	Blackburn with Darwen	56	£6.228m	£0.111m	9	-£0.552m	-£0.061m	47	£6.780m	£0.144m
   	Blackpool	17	£2.392m	£0.141m	no data	no data	no data	17	£2.392m	£0.141m
   	Bolton	87	£6.661m	£0.077m	12	-£0.263m	-£0.022m	75	£6.924m	£0.092m
   South West	Bournemouth Christchurch and Poole	17	£2.787m	£0.164m	1	-£0.024m	-£0.024m	16	£2.811m	£0.176m
   South East	Bracknell Forest	30	£1.100m	£0.037m	7	-£1.103m	-£0.158m	22	£2.203m	£0.100m
   Yorkshire and the Humber	Bradford	108	£9.504m	£0.088m	6	-£4.445m	-£0.741m	99	£13.949m	£0.141m
   Outer London	Brent	59	£13.923m	£0.236m	9	-£0.787m	-£0.087m	50	£14.710m	£0.294m
   South East	Brighton and Hove	64	£4.347m	£0.068m	10	-£0.301m	-£0.030m	54	£4.648m	£0.086m
   South West	Bristol City of	71	£9.266m	£0.131m	12	-£1.556m	-£0.130m	59	£10.822m	£0.183m
   Outer London	Bromley	8	£1.695m	£0.212m	no data	no data	no data	7	£1.695m	£0.242m
   South East	Buckinghamshire	170	£12.570m	£0.074m	36	-£2.715m	-£0.075m	134	£15.285m	£0.114m
   North West	Bury	65	£5.346m	£0.082m	9	-£0.754m	-£0.084m	55	£6.099m	£0.111m
   Yorkshire and the Humber	Calderdale	62	£6.819m	£0.110m	3	-£0.367m	-£0.122m	59	£7.186m	£0.122m
   East of England	Cambridgeshire	138	£13.414m	£0.097m	8	-£0.193m	-£0.024m	130	£13.607m	£0.105m
   Inner London	Camden	57	£12.244m	£0.215m	6	-£0.488m	-£0.081m	48	£12.732m	£0.265m
   East of England	Central Bedfordshire	73	£5.683m	£0.078m	10	-£0.523m	-£0.052m	63	£6.205m	£0.099m
   North West	Cheshire East	72	£5.117m	£0.071m	6	-£0.357m	-£0.059m	64	£5.474m	£0.086m
   	Cheshire West and Chester	130	£9.093m	£0.070m	28	-£1.268m	-£0.045m	102	£10.361m	£0.102m
   Inner London	City of London	1	£0.314m	£0.314m	no data	no data	no data	1	£0.314m	£0.314m
   South West	Cornwall	63	£4.650m	£0.074m	5	-£1.336m	-£0.267m	58	£5.986m	£0.103m
   West Midlands	Coventry	71	£17.061m	£0.240m	no data	no data	no data	62	£17.061m	£0.275m
   Outer London	Croydon	49	£2.020m	£0.041m	9	-£3.686m	-£0.410m	40	£5.705m	£0.143m
   North West	Cumbria	265	£2.247m	£0.008m	62	-£7.546m	-£0.122m	199	£9.793m	£0.049m
   North East	Darlington	6	£1.051m	£0.175m	no data	no data	no data	6	£1.051m	£0.175m
   East Midlands	Derby	51	£6.187m	£0.121m	9	-£0.554m	-£0.062m	42	£6.741m	£0.160m
   	Derbyshire	313	£25.294m	£0.081m	31	-£2.623m	-£0.085m	282	£27.917m	£0.099m
   South West	Devon	155	£15.975m	£0.103m	19	-£1.148m	-£0.060m	133	£17.123m	£0.129m
   Yorkshire and the Humber	Doncaster	52	£3.766m	£0.072m	13	-£0.484m	-£0.037m	39	£4.250m	£0.109m
   South West	Dorset	87	£0.542m	£0.006m	33	-£4.822m	-£0.146m	54	£5.364m	£0.099m
   West Midlands	Dudley	70	£11.025m	£0.158m	7	-£0.235m	-£0.034m	63	£11.260m	£0.179m
   North East	Durham	227	£16.284m	£0.072m	24	-£8.571m	-£0.357m	202	£24.855m	£0.123m
   Outer London	Ealing	76	£17.220m	£0.227m	6	-£0.727m	-£0.121m	70	£17.946m	£0.256m
   Yorkshire and the Humber	East Riding of Yorkshire	121	£9.417m	£0.078m	13	-£1.873m	-£0.144m	108	£11.290m	£0.105m
   South East	East Sussex	125	£16.980m	£0.136m	4	-£0.112m	-£0.028m	121	£17.092m	£0.141m
   Outer London	Enfield	55	-£3.044m	-£0.055m	16	-£7.645m	-£0.478m	38	£4.601m	£0.121m
   East of England	Essex	262	£35.044m	£0.134m	13	-£0.565m	-£0.043m	249	£35.609m	£0.143m
   North East	Gateshead	71	£5.477m	£0.077m	12	-£1.172m	-£0.098m	59	£6.649m	£0.113m
   South West	Gloucestershire	204	£14.400m	£0.071m	34	-£2.531m	-£0.074m	170	£16.931m	£0.100m
   Outer London	Greenwich	61	£9.718m	£0.159m	10	-£2.224m	-£0.222m	51	£11.942m	£0.234m
   Inner London	Hackney	49	£13.167m	£0.269m	11	-£1.973m	-£0.179m	38	£15.140m	£0.398m
   North West	Halton	52	£4.645m	£0.089m	3	-£0.128m	-£0.043m	49	£4.773m	£0.097m
   Inner London	Hammersmith and Fulham	33	£9.546m	£0.289m	no data	no data	no data	33	£9.546m	£0.289m
   South East	Hampshire	471	£38.148m	£0.081m	48	-£14.155m	-£0.295m	422	£52.304m	£0.124m
   Inner London	Haringey	65	£7.425m	£0.114m	12	-£1.351m	-£0.113m	53	£8.776m	£0.166m
   Outer London	Harrow	34	£12.740m	£0.375m	1	-£0.277m	-£0.277m	33	£13.017m	£0.394m
   North East	Hartlepool	23	-£0.262m	-£0.011m	5	-£2.430m	-£0.486m	17	£2.168m	£0.128m
   Outer London	Havering	42	£2.251m	£0.054m	19	-£1.417m	-£0.075m	23	£3.668m	£0.159m
   West Midlands	Herefordshire	65	£9.424m	£0.145m	1	-£0.001m	-£0.001m	63	£9.425m	£0.150m
   East of England	Hertfordshire	394	£66.431m	£0.169m	18	-£1.757m	-£0.098m	376	£68.188m	£0.181m
   Outer London	Hillingdon	54	£10.019m	£0.186m	5	-£3.633m	-£0.727m	49	£13.652m	£0.279m
   	Hounslow	54	£10.318m	£0.191m	7	-£0.651m	-£0.093m	47	£10.969m	£0.233m
   South East	Isle of Wight	42	-£0.272m	-£0.006m	13	-£4.072m	-£0.313m	29	£3.799m	£0.131m
   Inner London	Islington	52	£9.638m	£0.185m	4	-£0.245m	-£0.061m	48	£9.883m	£0.206m
   	Kensington and Chelsea	31	£4.539m	£0.146m	3	-£0.498m	-£0.166m	28	£5.036m	£0.180m
   South East	Kent	336	£35.343m	£0.105m	13	-£2.957m	-£0.227m	311	£38.301m	£0.123m
   Outer London	Kingston upon Thames	32	£4.365m	£0.136m	1	-£1.600m	-£1.600m	31	£5.965m	£0.192m
   Yorkshire and the Humber	Kingston-upon-Hull	8	£2.058m	£0.257m	no data	no data	no data	7	£2.058m	£0.294m
   	Kirklees	132	£11.129m	£0.084m	16	-£1.684m	-£0.105m	115	£12.813m	£0.111m
   North West	Knowsley	44	£1.737m	£0.039m	9	-£0.864m	-£0.096m	35	£2.600m	£0.074m
   Inner London	Lambeth	70	£9.822m	£0.140m	21	-£5.736m	-£0.273m	49	£15.558m	£0.318m
   North West	Lancashire	584	£42.521m	£0.073m	45	-£16.406m	-£0.365m	539	£58.927m	£0.109m
   Yorkshire and the Humber	Leeds	191	£23.739m	£0.124m	21	-£5.526m	-£0.263m	170	£29.266m	£0.172m
   East Midlands	Leicester	70	£14.971m	£0.214m	10	-£2.344m	-£0.234m	60	£17.314m	£0.289m
   	Leicestershire	91	£7.123m	£0.078m	15	-£1.034m	-£0.069m	76	£8.157m	£0.107m
   Inner London	Lewisham	77	£19.455m	£0.253m	11	-£3.816m	-£0.347m	66	£23.271m	£0.353m
   East Midlands	Lincolnshire	195	£21.689m	£0.111m	15	-£0.599m	-£0.040m	180	£22.287m	£0.124m
   North West	Liverpool	142	£4.585m	£0.032m	32	-£12.564m	-£0.393m	110	£17.149m	£0.156m
   East of England	Luton	52	£14.815m	£0.285m	4	-£0.520m	-£0.130m	46	£15.335m	£0.333m
   North West	Manchester	114	£16.236m	£0.142m	4	-£1.419m	-£0.355m	110	£17.656m	£0.161m
   South East	Medway	30	£2.248m	£0.075m	3	-£0.311m	-£0.104m	27	£2.560m	£0.095m
   Outer London	Merton	47	£8.368m	£0.178m	8	-£0.495m	-£0.062m	39	£8.862m	£0.227m
   North East	Middlesbrough	13	£3.241m	£0.249m	no data	no data	no data	13	£3.241m	£0.249m
   South East	Milton Keynes	77	£10.062m	£0.131m	4	-£0.176m	-£0.044m	73	£10.238m	£0.140m
   North East	Newcastle upon Tyne	61	£10.004m	£0.164m	4	-£0.420m	-£0.105m	57	£10.424m	£0.183m
   Inner London	Newham	54	£26.761m	£0.496m	2	-£0.187m	-£0.094m	52	£26.949m	£0.518m
   East of England	Norfolk	177	£13.981m	£0.079m	10	-£0.366m	-£0.037m	167	£14.348m	£0.086m
   Yorkshire and the Humber	North East Lincolnshire	10	£1.097m	£0.110m	1	-£0.021m	-£0.021m	9	£1.118m	£0.124m
   	North Lincolnshire	47	£3.039m	£0.065m	9	-£1.063m	-£0.118m	38	£4.103m	£0.108m
   South West	North Somerset	19	£0.896m	£0.047m	1	-£0.567m	-£0.567m	17	£1.463m	£0.086m
   North East	North Tyneside	74	£0.138m	£0.002m	10	-£9.524m	-£0.952m	64	£9.661m	£0.151m
   Yorkshire and the Humber	North Yorkshire	247	£10.761m	£0.044m	38	-£7.274m	-£0.191m	209	£18.035m	£0.086m
   East Midlands	Northamptonshire	123	£12.705m	£0.103m	8	-£0.239m	-£0.030m	115	£12.944m	£0.113m
   North East	Northumberland	125	£2.935m	£0.023m	37	-£3.764m	-£0.102m	88	£6.699m	£0.076m
   East Midlands	Nottingham	33	£6.611m	£0.200m	1	-£0.086m	-£0.086m	32	£6.697m	£0.209m
   	Nottinghamshire	197	£15.195m	£0.077m	19	-£0.699m	-£0.037m	177	£15.893m	£0.090m
   North West	Oldham	68	£5.450m	£0.080m	9	-£0.313m	-£0.035m	57	£5.762m	£0.101m
   South East	Oxfordshire	150	£7.973m	£0.053m	19	-£2.166m	-£0.114m	122	£10.140m	£0.083m
   East of England	Peterborough	35	£3.223m	£0.092m	no data	no data	no data	35	£3.223m	£0.092m
   South West	Plymouth	25	£1.811m	£0.072m	3	-£0.180m	-£0.060m	22	£1.991m	£0.090m
   South East	Portsmouth	24	£3.999m	£0.167m	3	-£0.243m	-£0.081m	21	£4.242m	£0.202m
   	Reading	35	£2.892m	£0.083m	6	-£0.818m	-£0.136m	29	£3.710m	£0.128m
   Outer London	Redbridge	62	£15.680m	£0.253m	3	-£0.334m	-£0.111m	59	£16.014m	£0.271m
   North East	Redcar and Cleveland	18	£2.928m	£0.163m	3	-£0.135m	-£0.045m	15	£3.062m	£0.204m
   Outer London	Richmond upon Thames	42	£8.064m	£0.192m	4	-£0.138m	-£0.035m	38	£8.202m	£0.216m
   North West	Rochdale	76	£12.266m	£0.161m	1	-£0.002m	-£0.002m	75	£12.268m	£0.164m
   Yorkshire and the Humber	Rotherham	41	£1.590m	£0.039m	11	-£1.386m	-£0.126m	30	£2.976m	£0.099m
   East Midlands	Rutland	3	£0.548m	£0.183m	no data	no data	no data	3	£0.548m	£0.183m
   North West	Salford	79	£7.501m	£0.095m	4	-£2.958m	-£0.739m	75	£10.458m	£0.139m
   West Midlands	Sandwell	85	£22.539m	£0.265m	4	-£0.345m	-£0.086m	81	£22.884m	£0.283m
   North West	Sefton	85	£10.226m	£0.120m	8	-£2.350m	-£0.294m	77	£12.576m	£0.163m
   Yorkshire and the Humber	Sheffield	91	£11.572m	£0.127m	13	-£1.780m	-£0.137m	78	£13.352m	£0.171m
   West Midlands	Shropshire	91	£3.542m	£0.039m	8	-£0.718m	-£0.090m	82	£4.260m	£0.052m
   South East	Slough	17	£6.004m	£0.353m	3	-£0.322m	-£0.107m	14	£6.326m	£0.452m
   West Midlands	Solihull	56	£11.330m	£0.202m	1	-£0.303m	-£0.303m	52	£11.633m	£0.224m
   South West	Somerset	161	£14.284m	£0.089m	11	-£1.334m	-£0.121m	150	£15.618m	£0.104m
   	South Gloucestershire	87	£5.107m	£0.059m	19	-£1.346m	-£0.071m	68	£6.453m	£0.095m
   North East	South Tyneside	54	-£0.762m	-£0.014m	17	-£4.594m	-£0.270m	35	£3.832m	£0.109m
   South East	Southampton	46	£0.856m	£0.019m	14	-£5.046m	-£0.360m	32	£5.902m	£0.184m
   East of England	Southend-on-Sea	12	£3.497m	£0.291m	no data	no data	no data	12	£3.497m	£0.291m
   Inner London	Southwark	76	£10.595m	£0.139m	24	-£3.701m	-£0.154m	52	£14.296m	£0.275m
   North West	St Helens	60	£7.107m	£0.118m	4	-£0.075m	-£0.019m	56	£7.183m	£0.128m
   West Midlands	Staffordshire	162	£18.478m	£0.114m	23	-£2.365m	-£0.103m	139	£20.843m	£0.150m
   North West	Stockport	98	£8.642m	£0.088m	11	-£1.408m	-£0.128m	87	£10.049m	£0.116m
   North East	Stockton-on-Tees	29	£2.953m	£0.102m	1	-£0.119m	-£0.119m	25	£3.072m	£0.123m
   West Midlands	Stoke-on-Trent	26	£3.428m	£0.132m	3	-£1.059m	-£0.353m	23	£4.486m	£0.195m
   East of England	Suffolk	123	£12.913m	£0.105m	5	-£0.813m	-£0.163m	111	£13.726m	£0.124m
   North East	Sunderland	65	£7.910m	£0.122m	4	-£0.327m	-£0.082m	55	£8.237m	£0.150m
   South East	Surrey	220	£38.817m	£0.176m	5	-£0.415m	-£0.083m	214	£39.232m	£0.183m
   Outer London	Sutton	28	£2.983m	£0.107m	5	-£1.218m	-£0.244m	23	£4.201m	£0.183m
   South West	Swindon	31	£4.783m	£0.154m	2	-£0.042m	-£0.021m	29	£4.825m	£0.166m
   North West	Tameside	63	£6.946m	£0.110m	4	-£1.207m	-£0.302m	59	£8.153m	£0.138m
   West Midlands	Telford and Wrekin	55	£3.907m	£0.071m	6	-£0.500m	-£0.083m	49	£4.407m	£0.090m
   East of England	Thurrock	5	£0.648m	£0.130m	1	-£0.197m	-£0.197m	4	£0.845m	£0.211m
   South West	Torbay	9	£0.004m	£0.000m	2	-£0.722m	-£0.361m	7	£0.726m	£0.104m
   Inner London	Tower Hamlets	84	£24.035m	£0.286m	7	-£1.618m	-£0.231m	77	£25.652m	£0.333m
   North West	Trafford	66	£8.229m	£0.125m	5	-£0.630m	-£0.126m	61	£8.860m	£0.145m
   Yorkshire and the Humber	Wakefield	59	£6.199m	£0.105m	6	-£0.211m	-£0.035m	53	£6.410m	£0.121m
   West Midlands	Walsall	87	£10.578m	£0.122m	4	-£2.233m	-£0.558m	83	£12.811m	£0.154m
   Outer London	Waltham Forest	42	£7.331m	£0.175m	6	-£2.192m	-£0.365m	36	£9.523m	£0.265m
   Inner London	Wandsworth	60	£9.997m	£0.167m	8	-£1.065m	-£0.133m	52	£11.062m	£0.213m
   North West	Warrington	63	£6.090m	£0.097m	6	-£0.121m	-£0.020m	57	£6.211m	£0.109m
   West Midlands	Warwickshire	146	£18.507m	£0.127m	25	-£2.089m	-£0.084m	121	£20.596m	£0.170m
   South East	West Berkshire	64	£4.664m	£0.073m	8	-£0.172m	-£0.022m	56	£4.836m	£0.086m
   	West Sussex	214	£15.224m	£0.071m	24	-£2.616m	-£0.109m	190	£17.840m	£0.094m
   Inner London	Westminster	40	£1.658m	£0.041m	17	-£1.833m	-£0.108m	22	£3.491m	£0.159m
   North West	Wigan	100	£16.830m	£0.168m	4	-£0.103m	-£0.026m	96	£16.932m	£0.176m
   South West	Wiltshire	135	£6.674m	£0.049m	21	-£3.541m	-£0.169m	114	£10.216m	£0.090m
   South East	Windsor and Maidenhead	38	£1.552m	£0.041m	9	-£1.096m	-£0.122m	29	£2.648m	£0.091m
   North West	Wirral	96	£7.923m	£0.083m	21	-£2.628m	-£0.125m	75	£10.551m	£0.141m
   South East	Wokingham	47	£3.835m	£0.082m	3	-£0.600m	-£0.200m	43	£4.434m	£0.103m
   West Midlands	Wolverhampton	53	£6.376m	£0.120m	3	-£1.763m	-£0.588m	49	£8.139m	£0.166m
   	Worcestershire	134	£1.430m	£0.011m	41	-£9.189m	-£0.224m	90	£10.620m	£0.118m
   Yorkshire and the Humber	York	32	£2.041m	£0.064m	8	-£0.404m	-£0.051m	24	£2.445m	£0.102m
   East Midlands		1,076	£110.322m	£0.103m	108	-£8.177m	-£0.076m	967	£118.499m	£0.123m
   East of England		1,308	£173.997m	£0.133m	70	-£4.957m	-£0.071m	1,229	£178.954m	£0.146m
   Inner London		749	£159.195m	£0.213m	126	-£22.511m	-£0.179m	619	£181.706m	£0.294m
   North East		766	£51.896m	£0.068m	117	-£31.055m	-£0.265m	636	£82.950m	£0.130m
   North West		2,482	£204.020m	£0.082m	296	-£53.915m	-£0.182m	2,177	£257.934m	£0.118m
   Outer London		899	£149.475m	£0.166m	134	-£30.321m	-£0.226m	763	£179.796m	£0.236m
   South East		2,200	£206.343m	£0.094m	232	-£39.396m	-£0.170m	1,943	£245.739m	£0.126m
   South West		1,082	£81.799m	£0.076m	165	-£19.554m	-£0.119m	913	£101.353m	£0.111m
   West Midlands		1,353	£214.316m	£0.158m	167	-£29.645m	-£0.178m	1,168	£243.961m	£0.209m
   Yorkshire and the Humber		1,243	£105.122m	£0.085m	160	-£26.831m	-£0.168m	1,078	£131.953m	£0.122m

   Footnotes

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

   Save table

   Related information

   • Release type:
   • Publication: LA and school expenditure, Financial year 2022-23

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