Report this item to Etsy

UK Sole Trader Self Assessment Spreadsheet 2026/27 | Excel & Google Sheets Tax Estimator

NowPrice:$16.40

Original Price: $20.50

Loading

20% off

•

Sale ends on December 20

Includes Etsy Purchase Protection

You can only make an offer when buying a single item

Highlights

Keep a clear 2026/27 record as a UK sole trader — and see a plain-English estimate of Income Tax and National Insurance as you go.

This is a working Excel workbook (also designed to import into Google Sheets) for the tax year 6 April 2026 to 5 April 2027. Log invoices, expenses and business mileage. The dashboard estimates Income Tax for England, Wales and Northern Ireland or for Scotland, Class 4 National Insurance, and any voluntary Class 2 if your profits are below the threshold. A suggested monthly set-aside helps you plan. Payments on account are flagged when the usual £1,000 rule may apply — you still need to check your HMRC account.

What you get
• A SAMPLE workbook with fictional figures (so you can see how every sheet behaves)
• A BLANK workbook for your own 2026/27 records
• Instructions, Dashboard, Settings, Income, Expenses, Mileage, Tax estimate, Rates and dropdown lists
• Working formulas, drop-down menus, date and number checks, and locked formula cells (Excel protection has no password)
• Official 2026/27 figures taken from GOV.UK and listed with source links, including the Personal Allowance of £12,570, Income Tax bands, Class 4 rates (6% and 2%), the Class 2 weekly rate of £3.65, the £1,000 trading allowance, and the simplified mileage rates from 6 April 2026 (55p / 25p for cars and vans, 24p for motorcycles)

How to use it
1. Open the BLANK file and complete the Settings sheet (your name, tax region, and whether you will deduct expenses or use the trading allowance).
2. Enter income, expenses and business mileage in the cream cells. Choose a category from the drop-down lists.
3. Read the Dashboard. The Tax estimate sheet shows every step of the calculation so you can see how a figure was reached.
4. Before you file, check current rules and dates on GOV.UK. 2025/26 Self Assessment deadlines are printed as published; 2026/27 filing dates follow the usual cycle and should be confirmed on GOV.UK when HMRC updates that page.

Google Sheets: use File → Import → Upload. Core formulas use SUM, SUMIFS, IF, MIN, MAX, ROUND and SEARCH. Excel sheet protection often does not transfer — re-protect the Rates and Tax estimate sheets in Sheets if you want to. After importing, change one income figure and confirm the Dashboard updates.

What this is not
It is not a Self Assessment filing tool, not a substitute for commercial accounting software if you need one, and not tax advice. It does not calculate dividend tax, capital gains, student loans, the High Income Child Benefit Charge or most reliefs. If your affairs are complex, speak to a qualified accountant.

Disclaimer: This is a record-keeping and planning tool. Figures are estimates based on the amounts you enter and on HMRC rates published on GOV.UK as at 17 November 2026. It is not official HMRC or GOV.UK software, not tax, legal or financial advice, and not a substitute for a qualified accountant or for filing your Self Assessment return with HMRC. You are responsible for checking that rates, thresholds, dates and your own figures are current and correct. April Sixth is a trading name, not a government body.

Sources (checked 17 November 2026): https://www.gov.uk/income-tax-rates · https://www.gov.uk/scottish-income-tax · https://www.gov.uk/self-employed-national-insurance-rates · https://www.gov.uk/simpler-income-tax-simplified-expenses/vehicles · https://www.gov.uk/self-assessment-tax-returns/deadlines · https://www.gov.uk/understand-self-assessment-bill/payments-on-account · https://www.gov.uk/guidance/tax-free-allowances-on-property-and-trading-income

AI-assistance disclosure: This listing text and the spreadsheet were produced with assistance from AI tools, then reviewed, edited and tested by a person. Official rates and dates were checked against GOV.UK (17 November 2026) and the formulas were recalculated independently. This is not official HMRC software and is not tax advice.

File format: Microsoft Excel .xlsx (two files — SAMPLE and BLANK). Instant digital download. No physical item will be sent.

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