UK Sole Trader Tax Calculator 2026/27, Self Assessment Spreadsheet, Monthly Tax Set Aside
Price:$6.89
Here's what's eligible:
- Your order doesn't match the item description or photos
- Your item arrived damaged
- Your item arrived after the estimated arrival window
- Your item didn't arrive or was lost in the mail
You can only make an offer when buying a single item
Highlights
Sole trader tax calculator for the current tax year: a UK Self Assessment Spreadsheet for 2026/27 (6 April 2026 – 5 April 2027).
Which tax year do I need? Filing your 2025/26 return, due 31 January 2027? You need the separate 2025/26 version: https://www.etsy.com/listing/4601641726/uk-self-assessment-spreadsheet-202526
Log your income and expenses as the year goes and watch a running estimate of your tax, National Insurance, student loan and payments on account build up – with a monthly and weekly figure to put aside, so the bill due on 31 January 2028 is no surprise. At the end of the year, the box totals for your return are already worked out.
★ WHAT'S INCLUDED
• 2 spreadsheets: a BLANK copy (ready to fill in) + a filled-in EXAMPLE copy with sample data, so you can see exactly how every tab works before you start
• Quick Start Guide (PDF)
• 11 tabs, in order: Start Here · 1 Setup · 2 Income · 3 Expenses · 4 Mileage (optional) · 5 Home (optional) · Dashboard · Your Tax Return · Tax Estimate · Quarterly · Rates (with gov.uk sources)
★ HOW IT WORKS
• Start Here opens with a 7-step checklist. Each step has a "Go ›" link that jumps you to the right tab.
• Yellow cells are for typing. Grey italic rows are examples (not counted). Everything else calculates itself.
• 1 Setup takes about 2 minutes: the basics up front, and an Advanced block you can skip unless it applies (PAYE, payments on account already paid, Making Tax Digital check).
• Add income and expenses as you go. Mileage and working-from-home are optional.
• The Dashboard shows four big numbers, a status line ("✓ All good" or a warning if rows aren't counted), your next HMRC payment and how much to put aside each month – plus charts.
★ WHAT IT DOES
• Income tax estimate for England, Wales & NI, plus all 6 Scottish bands
• Class 4 NI (6% / 2%) and optional voluntary Class 2
• Student loans Plans 1, 2, 4 & 5 (two plans handled) and Postgraduate loan
• Salary + self-employed: add your P60 PAYE income and tax
• Payments on account: £1,000 and 80% rules, 31 Jan & 31 Jul amounts
• Monthly & weekly "set aside" figure and next-payment countdown
• Trading allowance (£1,000) vs actual expenses comparison – choose the allowance and the expense boxes show 0, so you leave them blank; boxes 28 and 31 show your profit after the allowance
• Flat-rate mileage (55p for the first 10,000 business miles, all cars/vans combined, 25p after, 24p motorcycle) and use-of-home flat rates
• Your Tax Return tab fills SA103S / SA103F box numbers automatically from your expense categories
• Data checks: rows outside the tax year, uncategorised, negative or invalid entries are flagged and left out of every total
• Making Tax Digital check (£50k / £30k / £20k thresholds) – keeps your digital records; this is not MTD software and can’t send updates to HMRC
★ WHAT'S NOT COVERED
• Savings interest and dividend income
• Capital allowances (equipment bought, vehicles on actual costs)
• Losses carried forward/back or set against other income (the loss is shown for box 32 / full form 65 only)
• CIS (Construction Industry Scheme) deductions
• The full form's balance sheet (SA103F boxes 83–99) – it's optional; if you don't keep one, skip to box 100
• Also not modelled: pension contributions, Gift Aid, Marriage Allowance, High Income Child Benefit Charge, property income, partnerships, VAT returns
If any of these apply to you, this spreadsheet is a record-keeping aid only – please speak to an accountant.
★ WORKS IN
Made for Excel. Not designed for Apple Numbers.
★ GOOD TO KNOW
• Box numbers come from HMRC's latest published SA103 forms (2025–26 editions). I'll re-check them when HMRC publishes the 2026–27 forms (usually April 2027).
• Rates checked on gov.uk on 14 October 2026.
• Questions? Send me a message through Etsy Messages (open your order › Message seller). I usually reply within 24 hours.
★ DISCLAIMER
Estimates only – not tax advice. Not affiliated with or endorsed by HMRC. You are responsible for your own tax return; always check your figures against your HMRC calculation and speak to an accountant if you're unsure.
★ LICENCE
For your own personal or single-business use. Please don't resell, share or redistribute the files, in whole or in part.
★ REFUNDS
This is an instant digital download, so I can't accept returns or exchanges. If anything doesn't work or you have a question, message me through Etsy Messages – I'm happy to help put it right. This doesn't affect your statutory rights.
Instant Download
Your files will be available to download once payment is confirmed. Here's how.
Instant download items don’t accept returns, exchanges or cancellations. Please contact the seller about any problems with your order.
Etsy Purchase Protection
Shop confidently on Etsy knowing if something goes wrong with an order, we've got your back for all eligible purchases —
see program terms
More from this shop
Visit shop-
Digital download
Sole Trader Bookkeeping Spreadsheet UK 2026/27, Self Employed Income and Expense Tracker, Invoice Log, Profit and Loss
$6.89
-
Digital download
UK Delivery Driver Tax Tracker 2026/27: Courier Mileage Log and Self Employed Earnings Spreadsheet
$6.89
-
Digital download
Self Assessment Tax Return Spreadsheet 2025/26 UK, HMRC SA103 Box Totals, Sole Trader Tax Calculator, Self Employed Excel
$6.89
-
Digital download
UK Sole Trader Tax Bundle 2026/27: Self Assessment, Bookkeeping and Delivery Driver Mileage Spreadsheets
$13.80
Be the first to leave a review
-
Digital download
Tax Prep Checklist Google Sheets, Tax Return, Tax Preparation Spreadsheet, Tax Season Tax Planner, Accounting Tax Planning Excel Spreadsheet
Sale Price $3.29
Original Price $6.59
-
Digital download
2024 Federal Income Tax Calculator: Excel & Google Sheets Template
$9.39
-
Digital download
2024 Federal Income Tax Calculator: Excel & Google Sheets
$9.39
-
Digital download
Income Tax Estimator - Easy to Use interactive Federal Tax Calculator Excel Template
$2.99
-
Digital download
2025 Federal & State Income Tax Calculator | Income Tax Template | Excel Tax Spreadsheet Google Sheets |Small Business Tax Calc Personal Tax
$10.39
-
Digital download
Income Tax Brackets Calculator – Editable U.S. Federal Tax Estimator (No Standard Deduction)
$7.99
-
Digital download
Tax Tracker Spreadsheet | Income Tax Deductions Template | Estimated Taxes Planner | Business Tax Organizer | Self Employed Tax Tracker
Sale Price $6.34
Original Price $12.68
-
Digital download
Tax Deduction Tracker Spreadsheet Template. Small Business Tax Deductions List. Tax Organizer Planner. Tax Prep Excel & Google Sheets.
Sale Price $3.75
Original Price $7.49
-
Digital download
Tax Deduction Tracker Spreadsheet Editable Tax Deductions List Tax Organizer Planner Small Business Tax Preparation Tax Prep Excel Google
$9.22
-
Digital download
Tax Deduction Tracker Excel Spreadsheet, Editable Tax Deductions List, Tax Organizer Planner, Small Business Tax Preparation Google Sheets
Sale Price $3.67
Original Price $7.35
-
Digital download
Tax Preparer Template, Editable Excel Forms, Tax Organizer, Client Tracker, Tax Filing Checklist, Self-Employed Tax Template
$9.95
-
Digital download
Tax Calculator: 2025, 2024, 2023 Income Tax, Form 1040 (Excel & PDF)
$3.99
Shoppers with similar taste loved these
-
Digital download
Tax Prep Season Flyer, Accountant Flyer, Credit Repair Flyer, Taxes Flyer, Tax Preparation Services Flyer, Tax Prep, Tax Season Flyer, Flyer
$3.95
-
Digital download
10 Valentines Tax Prep Bundle, February Tax Flyer, DIY Valentines flyer, Red Tax Preparer E-Flyer Template, Prep flyers, Tax Flyer
Sale Price $13.00
Original Price $20.00
-
Digital download
Tax Prep Quotes Bundle Template, 50 Tax Preparation Accounting Quotes, Tax Prep Digital Flyers Quotes Bundle,Tax Social Media Slogans,GG4
Sale Price $5.60
Original Price $8.00
-
Digital download
6 Tax Prep Services Flyers, Tax prep, Tax Season Flyers, Canva templates, Tax Flyers, Credit Repairs, Tax templates, Taxes 2023
Sale Price $11.05
Original Price $17.00
-
Digital download
Credit Repair Flyer, DIY Flyer Template Design, Editable Flyer, Consultation Services Flyers, Canva Credit Repair Flyer Template
$3.06
-
Digital download
2 Tax Valentine Flyer, Tax Prep Bundle, Tax Prep Instagram,Tax Prep Flyer Bundle, Tax Flyer Template, Prep Flyers Bundle, Tax Prep Templates
Sale Price $6.49
Original Price $9.99
-
Digital download
Bookkeeper Social Media Posts for Bookkeeping Instagram promo IG Financial Services Insta Post Bundle Editable Canva Templates Minimal
$20.73
-
Digital download
Minimalist Bookkeeping Service and Pricing Guide | Bookkeeper Guide | Finance Service Guide | Accountant | Finance Coach | Tax Prep
$12.00
-
Digital download
Accounting Client Intake Form Template: Bookkeeper Onboarding (Canva Template)
$8.00
-
Digital download
Bookkeeper Onboarding Canva Template Accounting Intake Form New Client Roadmap Client Management Template Welcome Guide Client Packet EHBK01
$8.79
-
Digital download
Neutral Boho Business Card Canva Template, DIY Printable QR Code Business Branding - Honey
$6.99
-
Digital download
Minimalist Bookkeeping Social Media Stories | Bookkeeper Canva Template | Finance Highlight Icons | Accountant Finance Coach | Tax Prep
$10.00