Free templateExcel, 4 sheetsHousing providers and managing agents

Rent and service charge schedule template

Free Excel rent and service charge schedule for supported housing, splitting eligible and ineligible charges, with a reconciliation and IHM time record.

Get the free template

Quick answer

A free Excel schedule that turns annual costs into a weekly charge per resident, split into eligible, ineligible and depends-on-evidence lines for Housing Benefit. It includes a year-end reconciliation sheet and an intensive housing management time record.

What is inside

  • Example lines for core rent, eligible service charges and common ineligible charges
  • Automatic weekly charge per resident and totals by type
  • A reconciliation sheet comparing what you charged with what you spent
  • An intensive housing management time record that shows the split from support

What it looks like

Formulas, drop-down lists and print settings are already set up. It opens in Excel, Google Sheets and LibreOffice.

XLSXrent-and-service-charge-schedule.xlsx
ABCDEF
1ChargeTypeHow it is calculatedAnnual costWeekly per residentEvidence held
2
3
4
5
6
7
How to useScheduleReconciliationIHM time record

How to use it

  1. 1

    Enter the scheme details

    Add the scheme, landlord, charging period and number of bed spaces.

  2. 2

    Enter annual costs

    Replace the example lines with your own costs and say how each one is calculated.

  3. 3

    Set the type of each line

    Choose Eligible, Ineligible or Depends. Keep support, counselling and personal care out of the rent.

  4. 4

    Record intensive housing management time

    Use the time record for staff whose time is split between housing management and support.

  5. 5

    Reconcile at year end

    Compare what you charged with what you spent, and explain any big difference.

Read the guide

The template follows our guide. It explains what each section is for and what a council will ask to see.

Rent, service charges and Housing Benefit

Questions people ask

Which service charges does Housing Benefit cover in supported housing?

Charges connected with providing adequate accommodation, such as cleaning and lighting communal areas, furniture and intensive housing management. Support, water charges and most personal fuel and meals are ineligible.

Why does the schedule have a Depends type?

Some lines, such as intensive housing management, are only eligible if your evidence shows they are housing management and not support. Marking them separately shows the council you know the difference.

Does the spreadsheet work in Google Sheets?

Yes. Upload it to Google Drive and open it with Google Sheets. The formulas and drop-down lists carry over.

Support Audit

Want your plans and records checked?

A template is a start. Support Audit samples real files against what councils and the planned licensing conditions look for, and tells you what to fix first.

More free templates

All templates

Popular

What is exempt accommodation?Licensing and the national standardsRent and service chargesGrey areasAudit readiness check
Enter open↑ ↓ moveEsc close