Can an open source revenues and benefits system work in local government?

We are a collaborative partnership, funded by DLUHC, testing how we can implement and migrate to an open system for managing business rates, assessing how usable it is for staff, and figuring out the best way to govern an open source community to maintain and develop the software.

The partnership is led by Teignbridge Council, and includes Sedgemoor, East Devon, Leeds, Basildon and Brentwood councils.

Latest news from the project:

  • Weeknotes for 9-13 May

    Weeknotes for 9-13 May

    This is the weeknote for the Open Revs & Bens project that covers the week 9-13 May. What we did: We continue to progress the import of data into the Sedgemoor system: this week we imported information related to accounts. User research completed interviews with council and business clients and we were able to provide an overview of what we’ve learnt so far. We are in the process of extracting templates to ease the process of spinning up a new instance of  the Sedgemoor system in Azure, complemented with documentation Significant progress was made on the governance workstream, identifying how…

    Keeping reading…


  • Weeknotes for 2-6 May

    Weeknotes for 2-6 May

    This is the weeknote for the Open Revs & Bens project that covers the week 2-6 May. What we did: We were able to migrate the minimum data set necessary from Leeds’s Capita system into the Sedgemoor system Shared with the project stakeholders the second draft of the open source governance document that we are working on. User research had two business interviews and one internal one around business rates What we learned: We found that during migration some dates were not migrated due to its format so we had to change it to Year-Month-Day. There’re some database constraints in…

    Keeping reading…


  • Weeknotes for 25-29 April

    Weeknotes for 25-29 April

    This is the weeknote for the Open Revs & Bens project that covers the week 25-29 April. What we did: Leeds data model is now finished We progressed the data model, we are expecting to finish it next week. We debugged the SOCCS Gazetteer API The business user research plan is finished, we have planned interviews 2 with businesses and 2 councils. Interviewed people from the Drupal project to understand how they are planning their Governance. What we learned: The SOCCS Gazetteer API needs further development to intake large files We have a better understanding on what we need to…

    Keeping reading…


  • Weeknotes for 11 – 22 April

    Weeknotes for 11 – 22 April

    This is the weeknote for the Open Revs & Bens project that covers the weeks 11-22 April, a double helping as Friday 15 April was a bank holiday. Over the past few weeks we’ve been working on: Importing the DTF gazetteer data into the Sedgemoor system Generating a readable model of the Capita database that is used for Business Tax  Mapped the Accounts and Property database tables from Capita to Sedgemoor  Started building the data flow routines to import data from the Property table from Civica into Sedgemoor  Provided recommendations around the Open Source licence to be used by the…

    Keeping reading…


  • Weeknote for  4-8 April 2022

    Weeknote for  4-8 April 2022

    This is the weeknote for the Open Revs & Bens project that covers the week 4-8 April. What we’ve done We are approaching the final stage of the data mapping, we only have two remaining tables from Leeds before we can do the first attempt of pumping data into the Sedgemoor system. A document providing the minimum data to be migrated is now available to the project partners – we are hoping to be able to publish this more widely in due course We ran a kick off session for the open source governance work. We identified the various areas…

    Keeping reading…


  • How the discovery phase is informing the alpha

    How the discovery phase is informing the alpha

    Revenue and Benefits systems are one of the key digital systems for all local authorities, processing payments to and from local businesses, council tax payers and hundreds of low income households on a weekly basis. They hold key customer data and, as such, are a linchpin in delivering councils’ digital transformation strategies and should link seamlessly into other key council systems. You would expect that transformation of these systems would be at the forefront of every council’s mind. And they are, but because there are limited options (3 main suppliers in the market), there is a level of dissatisfaction with…

    Keeping reading…


Project partners: