Service Charges in Social Housing
Estimates, actuals, apportionment and challenge — how service charge management stops being rebuilt in spreadsheets every year.
Why service charges have become a governance problem
Service charges pay for the communal side of social housing — repairs, cleaning, heating, grounds maintenance. They are also, for many housing associations, the last significant financial process still run on spreadsheets.
That matters more than it used to. Service charge regulation has tightened, residents are readier to challenge what they are billed, and the Housing Ombudsman treats an unclear statement as a service failure rather than an accounting quirk. A process that was merely inefficient five years ago is now a governance risk.
What goes wrong with spreadsheets
Disconnected spreadsheets fail in a predictable pattern. They are slow to produce, easy to break, and almost impossible to audit after the fact. Because they sit outside the asset, repairs and finance systems, the figures in them drift from the figures everywhere else.
The financial consequence is usually under-recovery: costs that were incurred but never apportioned, or apportioned to the wrong scheme. The operational consequence is a wave of queries at statement time, handled by people who cannot easily show how a number was reached.
Catching errors during the year, not after it
The change that makes the most difference is not a better spreadsheet. It is moving from an annual reconciliation to continuous visibility — tracking expenditure against schemes throughout the year so anomalies surface while there is still time to correct them.
For our client, a prominent housing association, that shift produced roughly £10.2m of costs corrected before year-end, across over 26,000 transactions between September 2023 and April 2024. The reporting dashboard was viewed more than 38,000 times by over 450 colleagues — which is the more telling number, because it shows the data reached the people making day-to-day decisions rather than sitting with the finance team.
"For the first time, we have centralised reporting on cost corrections, allowing us to identify root causes and target teams to correct behaviours related to how we raise purchase orders and pay invoices."
— Our client, a prominent housing association
Where the integration has to reach
Service charge software that stands alone recreates the original problem in a nicer interface. The apportionment is only as good as the data feeding it, so the system has to connect to:
- Asset management, for the scheme and property structure charges are apportioned against
- Repairs, so communal works land against the right scheme as they happen
- Finance, so purchase orders and invoices carry their scheme coding from the outset rather than being retro-fitted
Get those three right and the year-end reconciliation stops being a project.
Getting the apportionment right
Accurately calculating service charges means weighing several factors at once — lease type (shared ownership, affordable rent, leasehold), property and unit size, rateable value, bedroom count, and location. Rules built on these factors, applied automatically and consistently, are what keep charges fair and hold up when a resident asks how theirs was worked out — rather than each scheme being apportioned by hand, differently, depending on who did it.
What residents actually see
The visible output of all this is a statement a resident can understand and, if they want to, challenge on its merits. Clear breakdowns reduce disputes not because residents are placated but because the numbers hold up — and when a query does come in, the officer answering it can show how the figure was built.
That is the difference between defending a charge and explaining one.
- £10.2mof costs corrected before year-end (our client, a prominent housing association)
- 26,000transactions corrected in eight months (Sept 2023 – April 2024)
- 38,000dashboard views by 450 colleagues
For the first time, we have centralised reporting on cost corrections, allowing us to identify root causes and target teams to correct behaviours.
What this means for your team
- Errors are caught during the year, while there is still time to correct them
- A resident query is answered from the record rather than from a spreadsheet
- Apportionment traces back to the work that caused the cost
- Year-end reconciliation stops being a project
Get the full guide
Tell us who you are and the guide opens straight away, all 13 pages, to read online or download as a PDF.
Download the guide
What housing providers say
Named people at named organisations, in their own published words.
“We realised that we had a gap around the golden thread of data, in terms of the availability and accessibility of the data we held in seventeen different systems… That meant colleagues could immediately see all non-compliant properties.”
Jake Le Page Head of Building Safety Regulations Notting Hill Genesis
“Neo brought strong Dynamics 365 expertise, worked collaboratively with our internal teams and applied Microsoft best practice within a live operational environment… We would be pleased to recommend them as a Microsoft Dynamics 365 partner within the housing sector.”
Wayne Human Head of IT Change Sage Homes
“The successful deployment of this solution has significantly increased transparency and improved the operational efficiency of our contact centre, allowing us to deliver greater value to our customers.”
Philip Wragg Infrastructure Programme Manager
“The Neo Technology model allows us to scale our development capacity, accelerating our transformation programmes while future-proofing our business, while achieving substantial industry cost savings.”
Group CIO Notting Hill Genesis
Related proof
See how this works in practice
Thirty minutes, walked through by the people who deliver it. Bring your questions.