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.
| Box | Box name | Amount |
|---|---|---|
| 9 | Your turnover | £38,400 |
| 12 | Car, van and travel expenses | £2,140 |
| 18 | Phone, fax, stationery and other office costs | £610 |
| 20 | Total allowable expenses | £4,980 |
| 21 | Net 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?
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 template | SA103F box | SA103S box |
|---|---|---|
| Turnover | 15 | 9 |
| Other business income | 16 | 10 |
| Cost of goods bought for resale or goods used | 17 | 11 |
| Construction industry payments to subcontractors | 18 | 19 (no separate box) |
| Wages, salaries and other staff costs | 19 | 13 |
| Car, van and travel expenses | 20 | 12 |
| Rent, rates, power and insurance costs | 21 | 14 |
| Repairs and maintenance | 22 | 15 |
| Phone, fax, stationery and other office costs | 23 | 18 |
| Advertising and business entertainment | 24 | 19 (advertising only) |
| Interest, bank and card charges | 25 and 26 | 17 |
| Irrecoverable debts written off | 27 | 19 |
| Accountancy, legal and other professional fees | 28 | 16 |
| Depreciation | 29 | Not allowable |
| Other business expenses | 30 | 19 |
| Disallowable and private parts | 32 to 46 | Taken 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.
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 record | SA105 box |
|---|---|
| Rent and other income from property | 20 |
| Property income allowance | 20.1 |
| Tax taken off (non-resident landlords) | 21 |
| Lease premiums (with the working sheet) | 22 |
| Reverse premiums and inducements | 23 |
| Rent, rates, insurance and ground rents | 24 |
| Property repairs and maintenance | 25 |
| Non-residential property finance costs | 26 |
| Legal, management and other professional fees | 27 |
| Costs of services provided, including wages | 28 |
| Other allowable property expenses | 29 |
| Private use adjustment | 30 |
| Capital allowances | 31 to 35 |
| Replacing domestic items | 36 |
| Rent a Room exempt amount | 37 |
| Adjusted profit or loss | 38 to 43 |
| Residential property finance costs | 44 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.
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 templatesWhat should I do after this return if I expect to join MTD next year?
- 1 Keep recording income and expenses in a spreadsheet through 2026/27
- 2 Check your start date with the start-date checker and key dates
- 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
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
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.