Methodology

How the figures are read

Social care spend per resident by age

Calculations use MHCLG’s 2026/27 RA budget, Part 1, sheet RA_LA_Data_2026-27, and ONS Population estimates for the UK, England, Wales, Scotland and Northern Ireland: mid-2025, MYE2 Persons, published 1 October 2026. The population estimate is for mid-2025; the budget is for 2026/27. Each numerator in thousands of pounds is multiplied by 1,000 and divided by the relevant resident count, with the result displayed to the nearest pound. Adult social care uses line 360 and residents aged 18 and over; working-age support uses lines 332, 334, 336, 340 and 344 and residents aged 18 to 64; older people’s support uses lines 333, 335, 337, 341 and 345 and residents aged 65 and over; children’s social care uses line 330 and residents under 18. Line 360 less the ten age lines is shown as an amount and percentage, with no per resident ratio. The age ratios have different denominators and do not add up to the adult ratio.

Eligibility uses RA classes SC, UA, MD and LB, an available return and the same ONS code. Districts use their county’s figures. Missing returns remain unavailable. Barnsley and Sheffield have different boundary codes in the two editions, so the site does not join them. The City of London and the Isles of Scilly carry a small population note. No England ratio, ranking, average, or claim about need, efficiency or value is calculated.

ONS mid-2025 workbook, MYE2 Persons. Both editions and the lines used appear alongside the calculations.

Council budgets

The budget pages use MHCLG's 2026/27 RA budget return. Service amounts are observed net current expenditure, net of sales, fees, charges and transfers, excluding NHS-funded spending. Printed integers in thousands of pounds are converted to pounds for display. No other year's figures fill missing returns.

MHCLG service headings and their sub-lines are retained. Zero service headings are omitted and negative totals are labelled net income. Education is not reduced by the Dedicated Schools Grant. Special schools and alternative provision is not a total for SEND spending.

The funding view is a calculation: reverse the signs of the financing lines, group reserves and other items, and add the council tax requirement to reach revenue expenditure. Positive magnitudes carry an add or deduct label. The original signed lines are also shown. The non-ringfenced reserve total is other earmarked plus unallocated reserves; MHCLG cautions that usable revenue reserves cannot be identified in this release.

Service and financing totals are reconciled against the printed RA totals. Council tax requirement is checked against Table 10's own Band D including average parish precepts multiplied by its tax base. Reviewed source discrepancies remain unchanged, and MHCLG note 4 is quoted beside affected figures. Band D bill components are separate observations from Table 10; no resident's bill is apportioned across services.

Source: Ministry of Housing, Communities and Local Government, Local authority revenue expenditure and financing England: 2026 to 2027 budget individual local authority data, RA_LA_Data_2026-27, published 11 June 2026.

The game adds guesses to the observed tables. Spending shares divide each positive service total by the sum of positive service totals. Net income headings remain visible outside the guess. The bill round uses only the printed Band D components divided by the printed area average; published rounding differences are preserved.

Game scoring uses the unrounded shares: 100 minus half the sum of absolute pence differences, rounded and bounded from 0 to 100. Funding is ordered by magnitude, with add/deduct labels retained, and scored by correctly ordered unequal pairs. Reserve direction and size are each worth 50 points; size bands are answer choices, not estimates. Skips have no score. Scores and the council slug can be shared, but guesses, bands and postcodes are not included. Shared scores are not verified.

Council tax by band

Each council's figures for bands A to H are Table 9 of the MHCLG release for 2026/27, read as published. No band is worked out from another. The figure is the area charge for a home with two adults: it includes the county council where there is one, the police and crime commissioner, the fire authority where it sets a precept, and the average parish precept for the council's area. A home in a parish with its own precept pays a different amount, which is why every band figure carries that caveat.

MHCLG's note on the band table: The ratios of other bands to Band D are: A 6/9; B 7/9; C 8/9; E 11/9; F 13/9; G 15/9; H 18/9.

Changes and budgeting equivalents

The change on 2025/26 is this year's published figure less last year's published figure for the same council, from the two band tables, and as a percentage of last year's figure, rounded to one decimal place on summary cards and two decimal places in the increase explorer. It is labelled as calculated wherever it appears. Where a council's ONS code differs between the two tables, as Barnsley's and Sheffield's do between the 2024 to 2025 and 2025 to 2026 tables, no change is shown for that pair of years: ONS issues a new code when an area's boundary changes, so the two figures may not be for the same area.

The monthly figure is the yearly charge divided by ten, because ten monthly instalments is the usual way council tax is paid. The local bill tool also offers a separately labelled twelve-payment equivalent. Neither is an actual instalment schedule.

Local bills and precepts

The local precept tool reads adopted council schedules. Each band total must reconcile exactly to its published components in integer pence. County, police, fire, mayoral, parish and special-expense components can be represented separately or as a published bundle. A component included in a bundle cannot be counted again. Postcode geography suggests a locality; it does not establish a property's exact charge.

Scotland and Wales

Scottish band cells are read from the Scottish Government's published workbooks and rounded to their displayed penny precision. Water and sewerage are excluded. The Welsh extract reads Table 1 Band D averages and components, rounded to whole pounds as displayed. No missing band is inferred. The Sources page links to the original publications.

Future-cost scenarios

Model version 1.0 compounds the starting charge by the chosen annual percentage for each year, then rounds that year's amount to pennies. Cumulative cost sums those rounded annual amounts. Extra cost compares that sum with paying the unchanged baseline for the same number of years. The component tool compounds and rounds each component separately before summing. These are editable illustrations, not official forecasts or predictions of legal limits.

What is not shown

MHCLG's tables include an adult social care element for councils with social care duties. The technical notes do not define it, and it is not the whole adult social care precept, so the site does not print it.

Comparisons

The national page orders councils by area Band D within each class of council, because MHCLG publishes every council for the same complete year. Band and region pages list councils alphabetically. No page says why a council's figure is higher or lower than another's.