The Local Council Report / Revenue Outturn / Real spend trend · markdown view

Real spend trend

% per year (real-terms CAGR) · constructed · council-year

Whether this council's spending has been growing or shrinking over the past eight years, after stripping out inflation — its direction of travel, not its size. It matters because a council can look normal today while quietly growing much faster than its peers. Faster-than-peers growth in a service, like children's care, flags mounting pressure or slipping cost control; steady or falling real spending suggests discipline — or cuts.

councils
305
median
1.74
q1
0.65
q3
3.08
min
-7.23
max
18.26

Distribution

-4.9510.66

Highest 10

CouncilClassValueIn its class
Runnymededistrict18.261st highest of 161
Surrey Heathdistrict13.082nd highest of 161
South Derbyshiredistrict11.753rd highest of 161
Colchesterdistrict10.724th highest of 161
Mid Suffolkdistrict9.45th highest of 161
East Lindseydistrict9.186th highest of 161
Thanetdistrict8.947th highest of 161
Dartforddistrict8.278th highest of 161
Horshamdistrict7.899th highest of 161
Westminsterlondon7.621st highest of 33

Lowest 10

CouncilClassValueIn its class
Nuneaton & Bedworthdistrict-7.23161st highest of 161
Gloucesterdistrict-6.87160th highest of 161
Brentwooddistrict-6.76159th highest of 161
Eastleighdistrict-4.97158th highest of 161
Rushmoordistrict-4.52157th highest of 161
Tandridgedistrict-4.18156th highest of 161
Eastbournedistrict-3.96155th highest of 161
Folkestone & Hythedistrict-3.91154th highest of 161
Mansfielddistrict-3.82153rd highest of 161
Erewashdistrict-3.54152nd highest of 161

Definition

namereal-spend-trend
dataset01-revenue-outturn
kindconstructed
typepercentage
unit% per year (real-terms CAGR)
graincouncil-year
rolefeature
sourceFormula: CAGR of `RS_totsx_net_exp` (or any service line) from 2017-18 to 2024-25, GDP-deflated. Inputs: this dataset's CSV (8 years) + ONS GDP deflator (external)
periodFY 2017-18 to 2024-25, annual (year_ending 201803-202503)
missingness"Rows with status other than "submitted" (i.e. "total" aggregates and "not submitted") must be filtered out; a non-submitted council-year is a genuine gap, not zero. 2024-25 covers 410/411 councils. Councils abolished/created in 2017-25 reorganisations appear only for the years they existed. Undefined for councils created or abolished by 2017-25 reorganisations, whose series do not span the window; the GDP deflator must be sourced externally."
score_noteCost discipline over time is a genuine efficiency read that raw levels miss; reorganisations break some series.
calculated../calculated/real-spend-trend.csv
calculated_rows392
calculated_periods2017-18 to 2024-25 (one CAGR per council, period stamped 2024-25)
calculated_date2026-08-13
peer_groupdistricts (n=161), unitaries (n=54), metropolitan boroughs (n=36), London boroughs (n=33), counties (n=21) — context variable, excluded from leaderboard scoring

Real-terms compound annual growth of total (or service-line) spend over the eight-year series — cost discipline over time. Comparing service-line trends to peers spots outlier growth, e.g. children's social care. Reorganisations break series continuity, so match on ONS_code per year and exclude councils without a full series.