The Spreadsheet of Power: Why Your Council's Contract Register Deserves Scrutiny

The contract register is not a transparency ornament. It is a map of power. Every entry records a decision about whose labour, whose energy and whose future the council is buying. For a resident trying to test whether a council means what it says about the climate emergency, outsourcing or local jobs, the register is more honest than the press release. It is also less read. That is the opportunity.

A register is a decision log

Councils in the UK are expected to publish contract registers and procurement pipelines. The exact format varies, but the useful documents are consistent: a contracts register listing live and recent contracts, a forward plan of procurements, award notices, and spending data over £500. National portals such as Contracts Finder and Find a Tender carry some of the same information. The council's own register is where the local detail sits: the directorate, the supplier, the value, the start and end dates, the route to market and sometimes the social value commitment.

Read it as a decision log, not a list of stationery orders. A contract for energy supply is a decision about fossil fuels. A contract for waste is a decision about incineration and recycling. A contract for IT is a decision about surveillance, data and labour. A contract for a green scheme is a decision about whether the council's climate plan has a budget line or only a photograph.

What to open first

Start with the register and the pipeline. Download them as spreadsheets, not PDFs, if you can. Then add the council's spending over £500 dataset and its award notices. If the council publishes a climate action plan, keep it open in another window. You are looking for the gap between the plan and the purchase order.

Do not begin with a conclusion. Begin with a sort. Sort by supplier to see who keeps appearing. Sort by value to see where the money goes. Sort by end date to see what is about to be renewed. Sort by procurement route to see how many contracts are direct awards or extensions rather than open competition. Each sort is a question.

The searches that expose a story

Use the search function with the plain words that describe public priorities. Search for oil, gas, fossil, fuel, energy, aviation and advertising. Search for retrofit, insulation, heat pump, EV charging, tree, biodiversity, net zero and carbon. Search for consultancy, agency, communications and public relations. Search for waste, incinerator, landfill and recycling. Search for IT, cloud, surveillance and biometric. Search for the names of council subsidiaries and wholly owned companies.

Then search for absence. If the council has declared a climate emergency and published a retrofit plan, is there a contract for retrofit? If there is a grant-funded green scheme, who is delivering it and what does the contract require? If a flagship scheme was announced and the only entry is a feasibility study, that is not necessarily a scandal, but it is a question about delivery. If the scheme has disappeared from the pipeline entirely, ask why.

Red flags that survive contact with a spreadsheet

A single red flag proves little. A cluster is a story. Look for contracts that have been extended repeatedly without competition. Look for values that sit just below a threshold, or a series of small contracts to the same supplier that add up to a large one. Look for direct awards justified by urgency where the urgency has lasted for years. Look for variations that increase value after the award. Look for social value promises that appear in the tender but not in the contract. Look for suppliers with offshore parents or complex subcontracting chains. Look for councillor interests that are declared late or not at all.

Climate red flags deserve their own column. A council can have a net zero target and a pension fund invested in fossil fuels; it can also have a procurement strategy that rewards the same companies. Check whether the contract includes a carbon reduction plan, whether it is binding, and who monitors it. Check whether the council asked for a climate impact assessment before awarding. If the answer is no, ask who decided that it was not necessary.

From spreadsheet to full-council question

A spreadsheet becomes politics when it is read aloud with a name attached. Take one contract. Ask the relevant cabinet member for the delegated decision record, the officer's report and the contract itself, redacted only where the law requires. Use the Freedom of Information Act 2000 or the Environmental Information Regulations 2004 where the register is thin. Ask the monitoring officer about any undeclared interest. Ask the audit committee to review procurement compliance, not just the accounts.

At full council, keep the question narrow: 'Can the council publish the contract award report for [supplier] for [service], including the procurement route, the social value commitments and the climate impact assessment?' A narrow question is harder to answer with a speech. Ask it in public. Ask for the answer in writing. Then ask the follow-up at the next meeting.

The political point

Procurement is where a council's values meet its legal obligations. A motion in favour of a green future costs nothing; a contract for a high-carbon service costs money and locks in behaviour for years. The register is the place where residents can see which one the council actually chose. It is not a niche document for policy nerds. It is the receipt for the future being purchased in your name.

Open it. Sort it. Ask the question. The spreadsheet is not the whole story, but it is usually the first page.