Free for your first official MTD submission: Register Now!Excellent113 reviews onTrustpilot
SA105 UK Property Income Format

Income and Expense Tracker for Landlords

Track rental income and allowable expenses month-by-month in the exact format HMRC requires for your Self Assessment. This tracker follows the SA105 structure with automatic calculations, finance cost separation, and full tax year coverage.

  • SA105 Category Structure
  • Monthly Breakdown (April-March)
  • Finance Costs Separated
  • Automatic Totals Calculated
What's Included
Income & Expenses
MTD Ready
All Property Income Categories
All Allowable Expense Categories
Residential Finance Costs Section
Monthly & Annual Totals

SA105-Formatted Tracker with All HMRC Categories

Everything you need to track UK property income and expenses for Self Assessment filing under SA105 (UK Property) form requirements.

  • Property Income section (rental income, lease premiums, reverse premiums, other income)
  • Property Expenses section (all HMRC-allowable categories)
  • Monthly tracking columns (April through March tax year)
  • Automatic category totals across 12 months
  • Residential property finance costs (separate for 20% tax credit)
  • Finance costs brought forward section
  • Rent, rates, insurance, and ground rents tracking
  • Repairs and maintenance expense capture
  • Legal, management, and professional fees logging
  • Service costs, including wages documentation
  • Travel expenses and utilities tracking
PREVIEW ONLY

Income and Expense Tracker for Landlords

SA105 UK Property Structure · Single Sheet · April to March

A single sheet tracker built around the SA105 UK property structure. Twelve monthly columns run from April to March with a total column at the end, so a full tax year of rental income and expenses sits on one page. Every total calculates itself as you type.

Monthly columns: Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Total

Section 1: SUMMARY AT A GLANCE

Sits at the top of the sheet and updates automatically as you fill in the months below, so you can see where the year stands without scrolling.

Total property income: £[Amount]

Total property expenses (excluding finance costs): £[Amount]

Property profit: £[Amount]

Residential property finance costs: £[Amount]

Residential finance costs brought forward: £[Amount]

(All five figures calculate themselves from the months below)

Section 2: PROPERTY INCOME

Four income lines following the SA105 categories.

Income lines (Apr to Mar, per month):

Rental income: £[Amount]

Premiums for the grant of a lease: £[Amount]

Reverse premiums and inducements: £[Amount]

Other income from the property: £[Amount]

Total property income: £[Amount]

(Each line totals across the twelve months, and each month totals down the column, so the figures reconcile in both directions)

Section 3: PROPERTY EXPENSES

Allowable property expenses, with finance costs kept out and handled in Section 4.

Expense rows (Apr to Mar, per month):

Rent, rates, insurance and ground rents: £[Amount]

Property repairs and maintenance: £[Amount]

Legal, management and other professional fees: £[Amount]

Costs of services provided, including wages: £[Amount]

Travel: £[Amount]

Utilities: £[Amount]

Other allowable property expenses: £[Amount]

Total property expenses: £[Amount]

(Every category totals across the year and every month totals down the column)

Section 4: RESIDENTIAL PROPERTY FINANCE COSTS

Kept in a separate section rather than mixed into expenses.

Finance cost rows (Apr to Mar, per month):

Mortgage interest and other finance costs: £[Amount]

Finance costs brought forward from earlier years: £[Amount]

Total residential finance costs: £[Amount]

Reminder: relief on residential finance costs is given as a 20 per cent tax reducer rather than a deduction from profit, which is the point landlords most often get wrong.

Fully editable. Built in Excel with formulas already in place.

Enter your figures month by month and every total, including the summary at the top, updates itself.

Why Every Landlord Needs Income & Expense Tracker Templates

Without proper monthly tracking, landlords overpay tax, miss legitimate deductions, and waste hours reconstructing records at Self Assessment deadlines.

When you don't track expenses monthly, you forget to claim management fees, ground rents, and travel costs. These missing deductions mean you pay tax on profit that should have been reduced, costing hundreds or thousands, depending on your tax bracket.
You must provide a written tenancy agreement containing specific prescribed information before the tenancy starts.
Residential mortgage interest gets a 20% tax credit, not a full deduction. Without proper tracking that separates finance costs, landlords accidentally claim them as expenses. HMRC will recalculate your tax and you'll owe the difference plus interest on late payment. In cases of repeated errors or carelessness, penalties may also apply.
Without monthly records, you'll spend 8-12 hours in January going through bank statements and receipts trying to reconstruct the tax year. You miss expenses you can't find, stress about deadlines, and often pay accountants extra to sort the mess.
SA105 requires specific expense categories, not generic lumps. When your return doesn't match HMRC's structure, electronic submission gets rejected or flagged for review. This creates filing delays and potential enquiries into your property income.
Utilities are fully allowable but easily overlooked when lumped with other costs. For a typical rental property, that's £300-£800 annually in legitimate deductions you're not claiming without dedicated tracking.

Get Your Income & Expense Tracker Today

1

Download and Customise

Download the foreign property income & expenses tracker formatted for the 2025/26 tax year (6th April 2025 to 5th April 2026). All income and expense categories match exactly what HMRC requires on the SA106 form, so your totals transfer directly to Self Assessment for overseas property reporting.
2

Track Monthly as Income and Expenses Occur

Each month, enter rental income received from your foreign properties and expenses paid in the appropriate HMRC categories. The tracker automatically calculates totals for each category across all 12 months, giving you running visibility of your foreign property profit.
3

Separate Finance Costs Correctly

Enter foreign residential mortgage interest in the dedicated "Residential property finance costs" section, not in expenses. The tracker includes a reminder about the 20% tax credit, so you don't accidentally claim it as a full deduction on SA106.
4

Transfer Totals to SA106 at Filing Time

When Self Assessment opens in January, simply copy the annual totals from each category into the corresponding SA106 boxes. No calculations needed; the tracker has done the work throughout the year, ensuring accurate foreign property income reporting.

Understanding SA105 Requirements for Landlords

From your first rental payment to filing Self Assessment, here's how proper tracking keeps you compliant and maximises deductions throughout the tax year.

1
April

Tax Year Starts (6th April)

Set up your tracker for the new tax year. HMRC requires April-March accounting for property income, not calendar years. Starting with the correct structure prevents period confusion and filing errors.

2
Monthly

Track Income and Expenses

Record rental income in required categories and enter expenses in specific HMRC categories like repairs, management fees, and utilities. Keep mortgage interest separate in finance costs for the 20% tax credit. Monthly tracking ensures nothing gets forgotten at year-end.

3
Quarterly

Submit Income & Expense Updates

Make quarterly submissions to HMRC through your summary record of rental income and expenses. Stay ahead of tax obligations and avoid surprises at year-end. Regular submissions keep HMRC informed and demonstrate active compliance.

4
Annually

Make Final Declaration

Transfer annual totals directly into SA105 boxes. Each tracker category matches an SA105 line exactly. No calculations needed, no scrambling through receipts, just copy pre-calculated figures and submit your final declaration.

Stop Overpaying Tax Due to Poor Record-Keeping

Download the complete SA105-formatted income and expense tracker with all HMRC categories, automatic calculations, and proper finance cost separation for the 2025/26 tax year.

Agreement Preview

Frequently Asked Questions

Support

FAQ Section

5 answers · curated
Can I use this tracker for multiple properties?

Yes. You can consolidate all UK property income and expenses into one tracker since HMRC doesn't require a property-by-property breakdown on SA105. However, if you want individual property performance tracking for your own analysis, use separate trackers for each property and create a summary sheet for filing. 

What's the difference between repairs and improvements for tax purposes?

Repairs are allowable expenses you can claim immediately, such as fixing broken items, redecorating, and replacing like-for-like. Improvements add value or change the property's character (extensions, conversions, major upgrades) and cannot be claimed on SA105 as expenses. When unsure, seek professional advice. 

Should I track expenses when paid or when invoiced?

Use cash basis (when paid) unless you've elected for accruals accounting with HMRC. Most landlords track income when received and expenses when paid, regardless of invoice dates. Enter transactions in the month money actually moves, not when bills arrive. 

Can I claim utilities if the tenant normally pays them?

Only claim utilities you actually pay. If tenants pay electricity, gas, and water directly to suppliers, you cannot claim these on SA105. If you pay utilities and include them in rent (common for HMOs), they're fully allowable expenses. 

Do I need to keep receipts if I'm tracking everything in this spreadsheet?

Absolutely yes. The tracker summarises transactions, but HMRC can request receipts, invoices, and bank statements to verify any SA105 claims. Keep all supporting documentation for at least 5 years after the 31st January filing deadline.