Landlord Expense Tracker Template: Categorise Costs for Tax

From Sort & Keep, the maker of the linked templates. Our current product prices update with your selected currency. Worked examples and third-party prices keep their stated currency and date.

The average UK landlord misses between £2,000 and £4,000 in legitimate tax deductions every year. Not because the expenses don't exist, but because they're logged in the wrong place, categorised incorrectly, or lost entirely between a shoebox of receipts and a half-built spreadsheet. A proper landlord expense tracker doesn't just record what you spent -- it maps every cost to the correct line on your self-assessment so HMRC gets the right number and you don't pay more than you owe.

We've filed property income returns for multiple rentals and watched the same mistakes repeat: repairs logged as improvements (losing the full deduction), mortgage interest claimed at the wrong rate, travel costs never recorded. The fix is a tracker that matches the SA105 property income form from day one, so when January rolls around, you're copying numbers instead of reconstructing a year's worth of spending from bank statements.

Here's how to set one up, what HMRC actually lets you deduct, and the trap that catches more landlords than any other.

What HMRC Lets Landlords Deduct

This is the full list of allowable expenses for residential property income under HMRC's property income manual. If your tracker doesn't have a category for each of these, you're almost certainly missing deductions.

Repairs and maintenance. Fixing things that are broken or worn out. Repainting after a tenant leaves. Replacing a broken boiler with a like-for-like equivalent. Fixing a leaking roof. Replastering damaged walls. This is the largest category for most landlords and the one most frequently miscategorised (more on that below).

Mortgage interest (basic rate tax credit only). Since Section 24 phased in fully from April 2020, you can no longer deduct mortgage interest from rental income directly. Instead, you get a 20% tax credit on the interest portion of your mortgage payments. If you're a basic rate taxpayer, the net effect is the same. If you're a higher rate taxpayer at 40%, you're only getting relief at 20%. Your tracker needs to record mortgage interest separately because it's handled differently on the SA105.

Letting agent fees. If you use a managing agent, their fees (typically 8-15% of rent collected) are fully deductible. Tenant-find fees are also deductible.

Insurance. Landlord building insurance, contents insurance, rent guarantee insurance, and liability insurance. All deductible. If you have a combined home and landlord policy, only the rental property portion qualifies.

Ground rent and service charges. If you own a leasehold property, both are deductible. Service charges can be substantial for flats -- often £1,500-£3,000 per year -- and are easy to forget when they're paid quarterly.

Council tax and water rates (during void periods). When the property is empty between tenants, you're responsible for both. Those costs are deductible against property income. Once a tenant moves in and takes over, they're no longer your expense to claim.

Accountancy and professional fees. Your accountant's fee for the property income section of your self-assessment. Legal fees for renewing tenancies or resolving disputes (not for buying or selling -- those are capital costs).

Travel to the property. Mileage to inspect, meet contractors, or deal with tenant issues. HMRC's rate is 45p per mile for the first 10,000 miles. Keep a log of each trip: date, destination, purpose, miles. Without a log, the deduction is indefensible in an enquiry.

Stationery, phone calls, and advertising. Tenant advertising (Rightmove, OpenRent listing fees), phone calls related to the property, and stationery. Small amounts that add up.

Replacement of domestic items relief. Since April 2016, landlords of furnished properties can claim the cost of replacing furnishings -- sofas, carpets, curtains, white goods, beds -- on a like-for-like basis. You can't claim initial furnishing, only replacements. If you upgrade (standard washer to a high-end one), you can only claim the like-for-like cost.

The Repairs vs Improvements Trap

This is HMRC's most common audit trigger for property income, and the distinction trips up landlords and accountants alike.

Repairs are fully deductible in the year you pay for them. An improvement is a capital expense -- you can't deduct it from rental income, and it only reduces your capital gains tax bill when you eventually sell the property.

The rule sounds simple: a repair restores something to its previous condition. An improvement makes it better than before. In practice, it's full of grey areas.

Clear repairs (fully deductible):

• Replacing a broken boiler with the same type of boiler -- £2,500-£3,500
• Fixing a leaking roof with new tiles of the same type -- £500-£5,000
• Replacing rotten window frames with equivalent frames -- £3,000-£8,000
• Repainting walls, replacing worn carpet with similar quality carpet
• Replumbing a bathroom using the same layout and fixtures

Clear improvements (capital only):

• Upgrading a standard boiler to a combi boiler -- £3,000-£4,500
• Adding a new extension or converting a loft
• Installing central heating where none existed before
• Adding double glazing where there were single-glazed windows
• Converting one large room into two rooms

The grey area that causes problems:

• Replacing a kitchen. If the old kitchen was functional and you install a similar-quality replacement, HMRC generally accepts this as a repair. Rip out a basic kitchen and install a premium one, and the basic replacement cost is a repair while the excess is an improvement. Document the original kitchen's condition and get a like-for-like quote alongside the upgrade quote.
• Replacing single-glazed wooden windows with double-glazed uPVC. HMRC says if the new windows are the nearest modern equivalent (because single-glazed frames are no longer standard), this can be treated as a repair. If you're adding double glazing as a deliberate upgrade, it's an improvement. The distinction comes down to documentation and intent.

How to protect yourself: Photograph the item before replacement. Get quotes for both like-for-like and upgrade options. Keep both in your records. If HMRC opens an enquiry, the allowable deduction is clear.

A single misclassified boiler replacement can cost you £700-£900 in overpaid tax (£3,500 expense at 20-25% effective rate). Across multiple properties and years, the cumulative effect is thousands of pounds.

Setting Up a Landlord Expense Tracker in Google Sheets

Here's a step-by-step setup that maps directly to the SA105 property income form. Every category corresponds to a line on the form, so at year-end you're reading numbers straight off your tracker.

Step 1: Create the Column Structure

Set up these columns across the top of your sheet:

Step 2: Set Up SA105-Aligned Categories

Create a data validation dropdown for the Category column using these values. Each maps to a specific section of the SA105:

1. Rent, rates, insurance, ground rent -- SA105 Box 25
2. Property repairs and maintenance -- SA105 Box 26
3. Loan interest and financial costs -- SA105 Box 27 (Section 24 tax credit)
4. Legal, management, and professional fees -- SA105 Box 28
5. Cost of services provided -- SA105 Box 29
6. Travel -- SA105 Box 29 (included in cost of services)
7. Replacement domestic items -- SA105 Box 29
8. Other allowable expenses -- SA105 Box 30
9. Capital improvement -- Not deductible on SA105 (track separately for CGT)

Step 3: Add a Summary Tab

Create a second tab that pulls totals using SUMIFS. For each property and each category, the formula is:

=SUMIFS(Expenses!E:E, Expenses!B:B, "Property Name", Expenses!C:C, "Category Name")

Build a summary table with properties as rows and SA105 boxes as columns. At year-end, each cell gives you the exact number for the corresponding box on the form.

Step 4: Add Cash Flow and Mortgage Interest Tabs

Add a monthly cash flow tab showing income minus expenses per property -- this isn't for HMRC, it's for you to spot trends. Add a separate mortgage interest tab tracking monthly payments and the 20% Section 24 tax credit calculation.

5 Landlord Expense Tracking Approaches Compared

1. Free Google Sheets Template (DIY)

Platform: Google Sheets
Price: Free
Best for: Landlords with 1-2 properties and decent spreadsheet skills

Pros:

• No cost beyond your time
• Fully customisable to your situation
• You own the data completely

Cons:

• Takes 4-8 hours to build properly with SA105 mapping
• Formula errors go unnoticed -- nobody audits your SUMIFS
• Falls apart at 3+ properties without significant restructuring
• No receipt storage or automation

Verdict: Fine for a single-property landlord who's disciplined about weekly entry. The risk is formula errors -- we've seen landlords overclaim by £800+ because a SUMIFS referenced the wrong column.

2. Landlord Software (Hammock, Landlord Studio, Landlord Vision)

Platform: Web and mobile apps
Price: £5-£20/month per property (Hammock free for basic; Landlord Studio from £8.25/month; Landlord Vision from £12/month)
Best for: Landlords with 3+ properties who want automation and SA105-ready reports

Pros:

• Bank feed integration -- transactions import automatically
• Receipt capture via mobile app
• SA105 report generation at year-end with repairs vs improvements built in
• Multi-property support by design

Cons:

• Monthly fees add up: £120-£240/year for 1-2 properties, more for larger portfolios
• Your data lives in their cloud; if the company folds, you're exporting CSVs
• Some features locked behind higher tiers (Landlord Vision's SA105 report requires premium)

Verdict: The best option for landlords with 3-10 properties who value time over monthly fees. Hammock's free tier is genuinely useful for 1-2 properties. Landlord Studio has the best mobile experience. Landlord Vision has the strongest SA105 integration but costs more.

3. Accounting Software (Xero, FreeAgent, QuickBooks)

Platform: Web and mobile apps
Price: £12-£36/month
Best for: Landlords who also run a business and want one system for everything

Pros:

• Strong bank feed integration and reconciliation
• Your accountant almost certainly uses one of these already
• Receipt capture, storage, and scales to any number of properties

Cons:

• No built-in SA105 mapping, repairs vs improvements workflow, or Section 24 calculation
• Requires your accountant to configure it for rental income
• Monthly fees regardless of how many properties you have
• Overkill if property income is your only income source

Verdict: If you already pay for Xero or FreeAgent for a business, adding property tracking is efficient. If property income is your only reason to get accounting software, the cost and setup complexity aren't justified.

4. Spreadsheet with Bank Statement Reconciliation (Annual Approach)

Platform: Excel or Google Sheets
Price: Free
Best for: Landlords who hate ongoing data entry and prefer a once-a-year marathon

Download 12 months of bank statements in January. Categorise everything in one sitting. File your self-assessment.

Pros:

• No ongoing maintenance throughout the year
• Forces a complete reconciliation against bank statements

Cons:

• January is already stressful; adding 200+ transactions to categorise makes it worse
• Memory fades -- a £350 charge from August becomes a guessing game
• Cash payments are lost entirely if you didn't note them during the year
• Repairs vs improvements decisions are harder 6-12 months after the fact

Verdict: About half the landlords we talk to use this approach, and it consistently produces the most errors and missed deductions. Travel, phone calls, small purchases -- you can't remember them eight months later. It works, but it costs you money.

5. Sort & Keep Rental Property Portfolio Tracker

Platform: Google Sheets (also works in Excel)
Price: £29.99 one-time
Best for: Landlords who want expense tracking alongside deal analysis, portfolio management, and tax preparation in one file

We built this because the expense tracking problem doesn't exist in isolation -- you need expenses in the context of each property's cash flow, ROI, and tax position.

Pros:

• Expense categories mapped to tax form line items (SA105 for UK, Schedule E for US)
• Per-property P&L with monthly columns and annual totals
• Maintenance log feeds directly into P&L -- no double entry
• Deal analyzer, portfolio dashboard, tenant tracker, and mortgage amortization included
• One-time £29.99; no recurring fees, all formulas visible and unlocked
• Works for 1-20 properties without performance issues

Cons:

• No bank feed integration -- every transaction is manual entry
• No receipt photo storage (use a Google Drive folder alongside it)
• Portfolio tool, not a pure expense tracker; the additional features add complexity if you only need expense logging

Verdict: If you want a standalone expense tracker and nothing else, Hammock's free tier or a DIY Google Sheet will do. If you want expense tracking connected to each property's cash flow, ROI, and tax position -- that's what we built. Get the Rental Property Portfolio Tracker on Sort & Keep | Also on Sort & Keep -- £29.99.

UK edition built for buy-to-let landlords. Council tax bands, EPC ratings, Gas Safety Certificate tracking, leasehold vs freehold analysis, and HMRC Self Assessment categories. US edition included with Schedule E, 1031 exchange planning, and 27.5-year depreciation schedules.

Quick Comparison

Choosing the Right Landlord Expense Tracker

Here's what we recommend based on portfolio size and budget:

For 1-2 properties, budget-conscious: Start with a free DIY Google Sheet using the SA105 structure above. Enter expenses weekly (5-10 minutes). Keep receipts in a Google Drive folder by property and year.

For 3+ properties, or if you value automation: Hammock or Landlord Studio for day-to-day expense capture with bank feeds and receipt photos. The monthly fee pays for itself in time saved.

For landlords who want expenses connected to portfolio performance: The Sort & Keep Rental Property Portfolio Tracker (Sort & Keep) gives you expense tracking, deal analysis, cash flow monitoring, and tax preparation in one spreadsheet for £29.99.

Whatever you choose, the non-negotiable is this: your categories must match the SA105 from day one. Recategorising 300 transactions in January because your tracker used "General Expenses" as a catch-all is how you miss deductions and overpay HMRC. Set the categories right, enter expenses as they happen, and tax season becomes a 30-minute job instead of a three-day ordeal.

Related Reads

• Best Rental Property Spreadsheets in 2026
• Buy-to-Let vs Flip: Spreadsheet Comparison
• How to Calculate Cap Rate in Google Sheets
• Property Portfolio Diversification Analysis

Get free spreadsheet templates and updates. New templates, feature updates, and practical guides delivered to your inbox. No spam, unsubscribe anytime.

Subscribe free → | Already have a template? Download the free budget tracker or free meal planner. No email required.