Every week, councillors across the country open a familiar spreadsheet. Rows upon rows of resident complaints, half-filled columns, colour-coded statuses that nobody quite remembers the meaning of, and a creeping sense that something has slipped through the cracks. Again.
It is not a new problem. Council casework management has been stuck in the dark ages for years, and the residents who depend on it are paying the price.
The Spreadsheet Trap
Most ward councillors inherit their casework system from whoever held the seat before them. That system is almost always a shared spreadsheet — sometimes a Google Sheet, sometimes an Excel file buried in a shared drive, occasionally a Word document that gets emailed back and forth.
The result is predictable:
-
Cases get lost. A resident reports a broken streetlight. The email arrives on a Friday afternoon, gets buried under weekend correspondence, and never makes it into the tracker. Three weeks later the resident calls back, frustrated and unheard.
-
Duplicate work piles up. Two councillors in neighbouring wards both log the same pothole complaint without realising it. Both chase the highways team. Neither knows the other has already received an update.
-
There is no transparency. When a resident asks "what is happening with my case?" the honest answer is often "let me check" — followed by ten minutes of scrolling, searching inboxes, and hoping the answer is somewhere.
"I spent more time looking for information about cases than I did actually resolving them. That is not what residents elected me to do."
— A parish councillor in the South West
The Human Cost
Behind every lost spreadsheet row is a real person waiting for help. A family dealing with damp housing. A pensioner whose bin has not been collected for weeks. A parent worried about speeding traffic near their child's school.
When casework falls through the cracks, trust in local democracy erodes. Residents stop reporting issues because they believe nothing will happen. Councillors burn out because they feel like they are failing the people they serve. And the cycle continues.
The problem is not that councillors do not care. The problem is that the tools they are using were never designed for this work.
Common Failure Modes
After speaking with dozens of council teams, a clear pattern emerges. The same failure modes appear again and again:
-
No single source of truth. Cases live across emails, spreadsheets, WhatsApp messages, and handwritten notes. There is no central place to see everything at once.
-
No audit trail. When a case changes hands — because a councillor is on holiday, or the issue crosses ward boundaries — context is lost. The next person picks it up with no history.
-
No resident-facing visibility. The resident has no way to check progress without making another phone call or sending another email. This creates more work for everyone.
-
No reporting or accountability. At the end of a council term, there is no easy way to show what was accomplished. How many cases were resolved? What were the most common issues? Which wards needed the most attention?
What Modern Councils Are Doing Instead
A growing number of councils are moving to purpose-built digital casework platforms. These are not generic project management tools or repurposed CRM systems. They are tools designed specifically for the unique workflow of council casework.
The best platforms share a few key characteristics:
-
Centralised case tracking. Every case — whether it arrives by email, phone, social media, or in-person surgery — goes into one system. Nothing gets lost.
-
Resident transparency. Residents can track the progress of their case online, reducing follow-up calls and building trust. They know their issue has been logged, they can see it is being worked on, and they get notified when it is resolved.
-
Ward-level visibility. Councillors and their teams can see casework patterns across their ward. Which streets have the most issues? What categories come up most often? This data helps prioritise resources and make the case for investment.
-
Collaboration without confusion. When multiple councillors or officers are involved in a case, everyone sees the same timeline. Handovers are clean. Nothing falls between the gaps.
A Better Way Forward
The spreadsheet era of council casework is ending — not because of some top-down mandate, but because councillors themselves are demanding better tools. They want to spend their time helping residents, not wrestling with broken workflows.
Councillor Watch was built for exactly this moment. It gives council teams a modern, transparent casework platform that residents can trust and councillors can rely on. Cases are tracked from report to resolution. Residents can follow progress online. And councillors finally have the data they need to show the impact of their work.
If your team is still drowning in spreadsheets, it might be time to try something different. Learn more about how Councillor Watch can help your council.