Report this item to Etsy

UK Sole Trader Tax Calculator 2026/27, Self Assessment Spreadsheet, Monthly Tax Set Aside

Price:$6.89

Loading
Includes Etsy Purchase Protection

You can only make an offer when buying a single item

Highlights

  • Designed by DigishopBySteve
  • Digital download
  • Digital file type(s): 1 PDF, 2 other files

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

You may also like

Shoppers with similar taste loved these

Show more
Show more
Listed on Oct 22, 2026