How to track flatshare rent and utilities in the UK
Updated 2026-11-101. Why you need a clear record
Sharing a house or flat with fellow students can be great for rent, but it also means juggling multiple payments - rent, council tax, electricity, gas, water, internet and the eventual return of the deposit. Without a single source of truth you risk: - Missed payments and late-fee penalties. - Disagreements over who owes what. - Failing to meet landlord legal duties, which can affect your deposit return. A simple spreadsheet can act as a central ledger, helping everyone see what has been paid, what is due and when the next bill arrives.
2. Legal basics every flatmate should know (England)
Even if you are not the landlord, you share responsibility for a safe, compliant home. The following duties apply to the property you occupy in England:
| Duty | What it means for you | Where to check |
|---|---|---|
| Gas safety | An annual gas safety check must be carried out by a qualified engineer and a copy of the certificate given to tenants. | check GOV.UK for the current rules |
| Electrical safety | An Electrical Installation Condition Report (EICR) is valid for five years; a copy must be provided at the start of the tenancy. | check GOV.UK for the current rules |
| Energy Performance Certificate (EPC) | Must be valid (10-year expiry) when the tenancy starts and the property must have at least an 'E' rating to be let. | check GOV.UK for the current rules |
| Deposit protection | The deposit (capped at five weeks' rent) must be placed in a government-approved scheme within 30 days and details given to tenants. | check GOV.UK for the current rules |
| Smoke & carbon-monoxide alarms | Working smoke alarm on every storey used as living accommodation and a carbon-monoxide alarm in rooms with a fixed combustion appliance (excluding gas cookers). | check GOV.UK for the current rules |
| How to Rent guide | Landlords must give the government "How to Rent" guide to tenants at the start of the tenancy. | check GOV.UK for the current rules |
| Right to Rent | Landlords must check that tenants have the right to rent in the UK. | check GOV.UK for the current rules |
| Tenancy type change (from 1 May 2026) | New assured shorthold tenancy agreements become assured (periodic) tenancies under the Renters' Rights Act. | check GOV.UK for the current rules |
Keeping records of these documents in your spreadsheet (e.g., upload dates, expiry dates) makes it easy to prove compliance if the landlord asks.
3. Setting up your spreadsheet - a step-by-step guide
- Create a master sheet - Label the first tab "Overview". Include columns for:
- Flatmate name
- Monthly rent share
- Council tax share
- Utility shares (electricity, gas, water, internet)
- Total owed each month
- Paid (Y/N) and date of payment
- Add a "Bills" sheet - List each bill as it arrives:
- Date received
- Supplier (e.g., British Gas, Thames Water)
- Total amount
- Due date
- Split method (equal or usage-based)
- Individual amounts per flatmate
- Log deposit details - In a "Deposit" tab record:
- Amount paid
- Protection scheme name and reference number
- Date of protection
- Expected return date at end of tenancy
- Any deductions agreed in writing
- Include a "Compliance" tab - Record dates for gas safety, EICR, EPC, smoke alarm tests and the provision of the "How to Rent" guide. This helps you spot upcoming renewals.
- Set up conditional formatting - Highlight any unpaid rows in red and paid rows in green. This visual cue reduces the chance of missed payments.
- Share the file - Store the spreadsheet in a cloud service (e.g., Google Drive) and give each flatmate view-only access, with one person (often the tenant named on the tenancy agreement) having edit rights.
Tip: While a spreadsheet alone is not compatible software for Making Tax Digital (MTD) for Income Tax, you can use it alongside a bridging software if you ever need to report self-employment income. check GOV.UK for the current rules.
4. Splitting the bills fairly
- Equal split - Simple and works when usage is similar. Divide the total by the number of occupants.
- Meter-read split - For gas and electricity, use individual meter readings (if sub-meters exist) to allocate costs proportionally.
- Room-size split - Larger rooms may attract a higher share of rent or council tax. Agree on a percentage before the tenancy starts and record it in the "Overview" sheet.
Document the chosen method in the spreadsheet so everyone can see the rationale.
5. Keeping track of council tax
Council tax is usually a household charge, not an individual one. In a student flat, the property may be exempt or discounted if all occupants are full-time students. Check your local council's website to confirm eligibility. If you do pay council tax, record the monthly share in the "Overview" sheet and note any discount applied.
6. End-of-tenancy checklist
When the tenancy ends, the spreadsheet becomes a handy audit tool: - Verify that the deposit protection scheme has released the funds. - Compare the final utility readings with the last entries. - Ensure all compliance documents are up to date (gas safety, EICR, EPC). check GOV.UK for the current rules. - Use the "Overview" totals to settle any remaining balances before moving out.
FAQ
Q1: Do I need to register for Self Assessment if I only split rent with flatmates? A: You only need to file a Self Assessment tax return if you have untaxed income, such as from self-employment or property rental above the personal allowance. The online filing deadline is 31 January after the end of the tax year (6 April - 5 April). check GOV.UK for the current rules.
Q2: What if the landlord does not provide a gas safety certificate? A: It is the landlord's legal duty to provide a copy at the start of the tenancy and after each annual check. You can request it in writing; if they fail to comply, you can contact your local authority. check GOV.UK for the current rules.
Q3: Can I use a simple spreadsheet for Making Tax Digital? A: A spreadsheet alone is not recognised as compatible software for MTD. It can be used alongside approved bridging software if you need to report qualifying income. check GOV.UK for the current rules.
Q4: How often should the smoke alarm be tested? A: Test the working smoke alarm at least once a month and replace the battery annually. check GOV.UK for the current rules.
Q5: Is the deposit protection scheme automatically chosen by the landlord? A: No - the landlord must select a government-approved scheme and provide you with the details within 30 days of receiving the deposit. check GOV.UK for the current rules.
7. Using a ready-made template
If you prefer not to build a spreadsheet from scratch, the Flatshare Rent & Utility Split Tracker template does all the heavy lifting. It comes pre-formatted with the sheets described above, includes built-in formulas for equal and usage-based splits, and even has a compliance checklist for England-only landlord duties. At £7 it can save you hours of set-up time and help keep your flatshare finances transparent and legal.