Next Making Tax Digital quarterly update deadline: Start filing now
← All free templates
Self Assessment 2025/26FreeYear-end return, not MTD

Self Assessment spreadsheet for 2025/26 (SA103 and SA105)

aligned.tax has two free Excel templates for the 2025/26 tax year (6 April 2025 to 5 April 2026), one for sole traders and one for UK landlords. They organise your income and expenses so the totals line up with the boxes on HMRC's SA103 and SA105 pages, ready to copy into your traditional Self Assessment return.

  • Box numbers from the 2025/26 forms. Checked against the 2026 editions of SA103S, SA103F and SA105 on GOV.UK.
  • Disallowable and private use kept separate. Enter what you paid and the private part; the workbook keeps them apart.
  • A year-end summary per form. Each total sits next to its HMRC box number and box name.

Excel (.xlsx). No macros, no email required. The templates help you prepare figures. They do not file your return.

Keeping records for 2026/27 instead? Use the sole trader bookkeeping spreadsheet for 2026/27 or the landlord bookkeeping spreadsheet, or estimate next year's bill with the 2026-27 Self Assessment tax calculator.

aligned-tax-sa103-sole-trader-2025-26.xlsx
IncomeExpensesSA103S summary
BoxBox nameAmount
9Your turnover£38,400
12Car, van and travel expenses£2,140
18Phone, fax, stationery and other office costs£610
20Total allowable expenses£4,980
21Net profit£33,420

Example figures

These templates are free bookkeeping aids to help you prepare figures for your 2025/26 Self Assessment return. They are not the official HMRC forms, they do not submit anything to HMRC, and they are not tax, legal or financial advice. Check every figure against the GOV.UK notes for 2025/26, or ask a qualified accountant. aligned.tax accepts no liability for errors or omissions, and responsibility for your return rests with you.

What is a Self Assessment spreadsheet? It is a workbook where you record a year's income and expenses, then add them up by HMRC category so you know what to put in each box of your tax return. HMRC publishes the official forms and notes on GOV.UK: SA103S and SA103F for self-employment, and SA105 for UK property. The free aligned.tax templates follow the 2025/26 versions of those pages. If you file online, you answer the same questions on screen and do not post a separate SA103 or SA105, but the box logic is the same.

Last checked against GOV.UK: 9 November 2026

What is the Self Assessment deadline for the 2025/26 tax year?

Paper return (passed)31 October 202611:59pm
Online return, if paying through your tax code30 December 202611:59pm
Online return31 January 202711:59pm
Pay the tax you owe31 January 202711:59pm

Source: GOV.UK, Self Assessment tax returns: deadlines.

Who these templates are for

  • Sole traders and self-employed people filing a traditional 2025/26 return with SA103S or SA103F
  • Landlords with UK rental income filing SA105, including former holiday lets
  • Anyone keeping records in Excel who wants totals that match the HMRC boxes
  • People whose accountant asks for a tidy year-end summary

When to use something else

  • Making Tax Digital quarterly updates. Use the MTD templates instead
  • Looking for the official HMRC PDF. Get it from GOV.UK
  • Limited companies, partnerships, payroll or double-entry bookkeeping
  • Foreign property only. That goes on SA106

What is an SA103 form, and do I need SA103S or SA103F for 2025/26?

SA103 is the self-employment supplement to the main SA100 tax return. HMRC's 2025/26 notes say use the short version (SA103S) if your turnover was less than £90,000 (or would have been for a full year) and your affairs are simple. Use the full version (SA103F) if turnover was £90,000 or more, your accounting period ended before 31 March 2026 or was not 12 months long, you changed accounting basis, you need to adjust Class 4 profits, or you were in HMRC's Managing Serious Defaulters programme. Read the SA103S notes and SA103F notes on GOV.UK.

How does a sole trader spreadsheet map to SA103 income and expense boxes?

You log each receipt and payment against one of the categories below. The workbook totals them and shows the box on each version of the page. Entertainment and depreciation are always treated as disallowable, and any private-use part you enter is kept separate.

Category in the templateSA103F boxSA103S box
Turnover159
Other business income1610
Cost of goods bought for resale or goods used1711
Construction industry payments to subcontractors1819 (no separate box)
Wages, salaries and other staff costs1913
Car, van and travel expenses2012
Rent, rates, power and insurance costs2114
Repairs and maintenance2215
Phone, fax, stationery and other office costs2318
Advertising and business entertainment2419 (advertising only)
Interest, bank and card charges25 and 2617
Irrecoverable debts written off2719
Accountancy, legal and other professional fees2816
Depreciation29Not allowable
Other business expenses3019
Disallowable and private parts32 to 46Taken off before boxes 11 to 19

The summary sheets also cover capital allowances, balancing charges, goods for your own use, losses brought forward and CIS deductions, using figures you work out from the notes. Boxes that need HMRC's working sheets, such as basis period adjustments and transition profit, are flagged for you to complete from the SA103F notes.

What is an SA105 form, and when do landlords use it?

SA105 is the UK property supplement. Use it for rent and other income from UK land or property, furnished rooms in your own home, lease premiums and reverse premiums. Income from property outside the UK goes on the Foreign pages (SA106) instead. See the SA105 form and notes on GOV.UK.

Changed for 2025/26: HMRC's UK property notes say the furnished holiday lettings regime was abolished from April 2025, and the 2025/26 SA105 says boxes 5 to 19 are no longer in use. Report former holiday lets with the rest of your UK property business in boxes 20 to 45. The landlord template has no separate FHL section for that reason.

How does a landlord spreadsheet map to SA105 rental income and expenses?

List your properties once, then log income and expenses against them. Joint owners enter only their share. The workbook builds the SA105 totals, follows the working sheet in the notes for boxes 38 and 41, and shows each property's figures on a separate sheet.

What you recordSA105 box
Rent and other income from property20
Property income allowance20.1
Tax taken off (non-resident landlords)21
Lease premiums (with the working sheet)22
Reverse premiums and inducements23
Rent, rates, insurance and ground rents24
Property repairs and maintenance25
Non-residential property finance costs26
Legal, management and other professional fees27
Costs of services provided, including wages28
Other allowable property expenses29
Private use adjustment30
Capital allowances31 to 35
Replacing domestic items36
Rent a Room exempt amount37
Adjusted profit or loss38 to 43
Residential property finance costs44 and 45

Residential mortgage interest is not deducted as an expense. It goes in box 44 and HMRC works out a reduction in your tax. Non-residential finance costs go in box 26.

When do I use SA106 instead of SA105?

Use the Foreign pages (SA106) for rental income from property outside the UK and other foreign income. SA105 is for UK property only. There is no aligned.tax SA106 template yet, so use the SA106 form and notes on GOV.UK. The property income allowance of up to £1,000 covers UK and foreign property income together.

Can I use a spreadsheet to prepare my Self Assessment figures?

Yes. HMRC does not ask you to send your records with a traditional return, so you can keep them in a spreadsheet and copy the totals across. The aligned.tax templates add up your income and expenses by HMRC category and show the box each total belongs in. They do not submit anything to HMRC. You still enter the figures in HMRC's online service or other software yourself.

  • Each workbook has a start sheet, an entry area for income and expenses, an allowances and adjustments sheet, and a year-end summary by HMRC box.
  • Dates use dd/mm/yyyy and amounts are in pounds. Entries outside 6 April 2025 to 5 April 2026 trigger a warning, not a block, because some accounting periods differ from the tax year.
  • Nothing is sent anywhere. The files stay on your computer.
After this return

Is traditional Self Assessment for 2025/26 the same as Making Tax Digital quarterly updates?

No. For 2025/26 most sole traders and landlords file a traditional year-end return: the SA100 plus supplements such as SA103 and SA105, once, by 31 January 2027. Making Tax Digital for Income Tax is a separate process with quarterly updates through software.

Your 2025/26 figures matter for what comes next. GOV.UK says if your qualifying income was over £30,000 for 2025/26, you will need to use Making Tax Digital for Income Tax from 6 April 2027. Check if you are eligible on GOV.UK.

See the free MTD spreadsheet templates

What should I do after this return if I expect to join MTD next year?

  1. 1 Keep recording income and expenses in a spreadsheet through 2026/27
  2. 2 Check your start date with the start-date checker and key dates
  3. 3 Read MTD for sole traders or MTD for landlords

Download the free 2025/26 templates

Two workbooks, free, with no email required.

Sole trader, SA103

Tax year 2025/26

  • Income and expense entry with HMRC categories
  • SA103S and SA103F summaries with box numbers
  • Trading income allowance, capital allowances and optional balance sheet
Download sole trader template

Landlord, SA105

Tax year 2025/26

  • Up to 20 properties, with joint lets and private use
  • SA105 summary with the boxes 38 and 41 working sheet
  • Lease premium working sheet and by-property totals
Download landlord template

File format: .xlsx (Microsoft Excel, Google Sheets, LibreOffice). Preparation aids only. They do not file your return.

Frequently asked questions

GOV.UK says HMRC must receive a paper return by 11:59pm on 31 October 2026 (that date has now passed) and an online return by 11:59pm on 31 January 2027. Any tax you owe must also be paid by 31 January 2027. If you want HMRC to collect what you owe through your tax code, submit online by 30 December 2026. Check the GOV.UK deadlines page.

Yes. HMRC does not ask you to send your records with a traditional return, so you can keep them in a spreadsheet and copy the totals across. The aligned.tax templates add up your income and expenses by HMRC category and show the box each total belongs in. They do not submit anything to HMRC. You still enter the figures in HMRC's online service or other software yourself.

No. These templates help you prepare figures only. They are not the official HMRC form, and nothing in them is sent to HMRC. aligned.tax files Making Tax Digital quarterly updates today; these year-end templates are a separate free download.

HMRC's notes say total self-employment and miscellaneous receipts of up to £1,000 are exempt and do not need reporting, unless they come from a connected party. Above that, you can claim the £1,000 allowance or deduct your actual expenses, not both. The sole trader template lets you enter the allowance and leaves expenses out if you do. See tax-free allowances on GOV.UK.

The UK property notes say all property income up to £1,000, including foreign property income, is exempt. Above that, you can claim the allowance in box 20.1 or deduct your actual expenses and allowances, not both. You cannot use it against Rent a Room income or income from a connected party.

HMRC's 2025/26 UK property notes say the furnished holiday lettings regime was abolished from April 2025. On the 2025/26 SA105, boxes 5 to 19 (the old FHL section) are no longer in use. Income and costs from former holiday lets now go in boxes 20 to 45 with the rest of your UK property business. The landlord template follows that layout.

Yes. There are no macros, so the workbooks open in Excel, Excel Online, Google Sheets and LibreOffice Calc. Drop-down lists and formulas carry across.