UK Self-Employed Income, Expenses & Tax Planner 2026/27

Keep your self-employed finances organised without paying for complicated accounting software.

The UK Self-Employed Income, Expenses & Tax Planner 2026/27 is a ready-made Excel workbook for sole traders, freelancers, gig workers, delivery drivers, online sellers and anyone earning money from a side hustle.

Enter your payments and costs as you go. The workbook automatically updates your monthly summaries, annual profit and estimated Income Tax and Class 4 National Insurance position.

What the workbook includes

• Space for up to 500 income and expense transactions
• Automatic income, expense and cash-profit totals
• Customisable business expense categories
• Business-use percentage calculations for shared costs
• Receipt tracking and missing-receipt warnings
• A 500-row business mileage log
• Automatic 2026/27 mileage rates for cars, vans, motorcycles and bicycles
• Monthly summaries covering April 2026 to March 2027
• A visual dashboard showing income and expenses
• Estimated Income Tax for England, Wales, Northern Ireland or Scotland
• Estimated Class 4 National Insurance
• Actual-expenses and £1,000 trading-allowance options
• Space to enter other taxable income and tax already deducted
• A separate step-by-step PDF instruction guide

Easy to use

Blue cells show where to enter information. Calculations update automatically, and four example transactions demonstrate how everything works.

No subscription is required. Download the files once and keep them on your own computer.

Files supplied

1. UK Self-Employed Income, Expenses & Tax Planner 2026/27 - Excel workbook (.xlsx)
2. Step-by-step instruction guide (.pdf)

Important

This workbook is an organisational and estimation tool. It does not replace professional tax, accounting or legal advice. Tax rules and personal circumstances can change, and your final HMRC calculation may differ. Microsoft Excel or compatible spreadsheet software is required.