Data analytics to improve council tax collection rates

Digital dashboard to translate operational data into business intelligence


From 2020, Newcastle City Council’s services will be almost entirely dependent on funding from council tax and business rates.

A programme of continuous service improvement has enabled Newcastle Council to increase its Council Tax collection rate from around 93% to around 97% of council tax owed, outperforming most similar authorities.

Although the percentage of uncollected tax and rates are small, they provide an opportunity to secure a valuable source of additional revenue. These revenues, however, are the most difficult to collect.

Data management and controls are well-established disciplines within the Council Tax team, however the ability to make further improvements was constrained by the fragmented and disparate nature of the available data.

The need for this operational data was also impacting forward planning, resource allocation, problem analysis, and service improvement. ​

Solving the problem

Urban Foresight ran a focused sprint that involved key members of the Council Tax team. This activity identified the:

  • required service improvement goals, challenges and opportunities;
  • key performance indicators (KPIs) required to measure performance and delivery;
  • data required for operational insight/improvement and service innovation;
  • availability and quality of the data required;
  • consistency of data standards and definitions.

Urban Foresight then used this to design an accessible digital dashboard tool for translating operational data into business intelligence.

Increasing the target collection rate for council tax to 98% would generate additional revenues of £1.3 million per year.

The final stage of the programme involved the development of a structured transformation plan. This formalised data management responsibilities, processes, and provided guidance on how to enhance the team’s analytical and reporting capabilities.

Guidance was also provided on how to integrate the dashboard with the service’s other digital tools, including new document, call management, online forms and automation systems. ​

Key outcomes

The operational management dashboard represents a key component of the continuous improvement team’s toolset for supporting new ways of working.

Increasing the target collection rate for council tax to 98% would generate additional revenues of £1.3 million each year.

The Council identified that the approach developed with Urban Foresight could also be applied to improve the collection of Business Rates.

This initial work will also provide the foundation skills and knowledge for combining council tax databases with external data sets to secure further improvements in collection rates and operational efficiencies.


Image credit: Campaign Creators