UK Home Office Tax Deduction Calculator 2026-27 | Sole Trader Work From Home Expenses | Excel Spreadsheet
Work out exactly how much you can claim for working from home — in minutes.This Excel spreadsheet calculates your home office tax deduction using both HMRC-approved methods and tells you which one gives you the higher allowance. Built specifically for UK sole traders and freelancers for the 2026/27 tax year.WHAT'S INCLUDED✔ Flat Rate (Simplified) Method — enter your hours worked from home each month, and the correct HMRC rate (£10, £18 or £26) is applied automatically ✔ Actual Cost (Proportional) Method — enter your annual household bills and the tool calculates the allowable proportion based on your rooms and working hours ✔ Results Summary — shows both totals side by side and recommends the higher deduction ✔ SA103S and SA103F guidance — tells you exactly which box to enter your figure on your Self Assessment return ✔ Demo version included — filled with example data so you can see it in action before entering your own figuresTHE TWO HMRC METHODS EXPLAINEDMethod 1 — Flat Rate: HMRC allows a fixed amount per month depending on how many hours you work from home. This calculator auto-selects the correct rate for each month based on your hours.Method 2 — Actual Cost: Claim a proportion of your real household running costs — rent or mortgage interest, council tax, gas, electricity, water, broadband, and home insurance — based on the share of rooms and time used for business.The Results sheet picks the higher of the two for you.WHO THIS IS FOR→ UK sole traders and freelancers who work from home full or part time → Anyone completing a Self Assessment (SA103S short or SA103F full return) → People who want to make sure they're claiming the maximum allowable home office expenseSHEETS INCLUDED📋 Instructions — explains both methods and how to use the calculator ⏱ Flat Rate Method — enter your monthly hours; rate and deduction calculate automatically 🏠 Actual Cost Method — enter your household bills and room/time proportions 📊 Results — side-by-side comparison with the recommended deduction highlightedFILE DETAILSFormat: Microsoft Excel (.xlsx) Works with: Excel 2016 and later (Windows and Mac) Google Sheets and LibreOffice are not officially supported Instant download — no subscription, no login requiredDISCLAIMERThis spreadsheet is a record-keeping and estimation tool only. It does not constitute financial, legal, or tax advice. Always verify your figures with a qualified accountant or check HMRC guidance at gov.uk.Questions? Message me through Etsy and I'll get back to you.
Get it → uksoletradertools.gumroad.com