bookkeeping spreadsheet for UK sole traders 2026/27: ledger, SA103S boxes, 55p mileage and the tax to set aside

Bookkeeping spreadsheet for UK self-employed sole traders: log income, costs and business miles, see your SA103S boxes, profit, Income Tax + Class 4 to set aside and the…

bookkeeping spreadsheet for UK sole traders 2026/27: ledger, SA103S boxes, 55p mileage and the tax to set aside
Example of the result this page gives you

Example (made-up mobile hairdresser, 2026/27): £38,400.00 turnover and 8,200 business miles. The tax to set aside is £4,197.44, but 31 January 2028 needs £6,296.16 once HMRC's first payment on account is added; a sheet still at last year's 45p claims £820.00 less for those miles, so you overpay £213.20 in tax.

Try it freeFull version · $39 per year →

How it works
  1. Put your own numbers into the free version below — no sign-up.
  2. Your result shows up right here, as you type.
  3. Want to keep it, print it or do it again next time? That is what the full version adds — see "What you get".

What you get: saved ledger for both tax years, bank CSV import sorted into the SA103S boxes, a 4-sheet Excel file, a printable year summary and a calendar of your HMRC dates.

Renewal and cancellation: the 1-year subscription renews automatically every 12 months at $39 until you cancel. Cancel any time before the renewal date in your Whop account (Profile → Orders → Cancel membership); you keep access until the end of the year you paid for and are not charged again.

Published 2026-11-18 · ReadyStack

Try it freeFull version →

Example (made-up mobile hairdresser, 2026/27): £38,400.00 turnover and 8,200 business miles. The tax to set aside is £4,197.44, but 31 January 2028 needs £6,296.16 once HMRC's first payment on account is added; a sheet still at last year's 45p claims £820.00 less for those miles, so you overpay £213.20 in tax. Type your own year below: the boxes, the bill and the January cash appear as you type, at this year's HMRC rates, with nothing to install and no bank login.

Your year (example: made-up mobile hairdresser)

Allowable expenses, SA103S boxes 11-19 (£)

England, Wales and Northern Ireland Income Tax bands. Scotland has its own bands.

Cash to have ready by 31 January 2028£6,296.16

Tax to set aside£4,197.44
Profit taxed£28,714.00
Mileage claim£4,510.00

Pro keeps this book: saved ledger for both tax years, bank CSV import sorted into the SA103S boxes, a 4-sheet Excel file, a printable year summary and a calendar of your HMRC dates. Pro yearly · $39 per year or $5.99 per month

Your SA103S boxes and the bill

    Ledger: one line per sale, cost or trip

    Type rows as they happen, pick the SA103S box, then put the totals into the boxes above. Fuel, insurance and servicing for a vehicle you claim the mileage rate for are kept but not claimed. The running totals follow the Making Tax Digital quarters (from 6 April).

    DateWhatBox£ or miles

    Pro: keep the book, import the bank, take the files

    • Your ledger and boxes saved in this browser, one book per tax year (2025/26 and 2026/27)
    • Bank CSV import (Date, Description, Amount or Paid in / Paid out) sorted into the SA103S boxes; lines already in the book are skipped
    • Excel file: Ledger, SA103S boxes (SUMIF formulas), Quarterly to date, Tax set-aside
    • Printable year summary for you or your accountant
    • .ics calendar: 31 January and 31 July payments, the 4 MTD update dates if your turnover is over £20,000, and a monthly book-closing day

    Get Pro · $39 per year $5.99 per month

    Have a key?

    Where the numbers come from (read 18 November 2026 on GOV.UK)

    Record-keeping and arithmetic only, not tax advice. Your numbers stay in this browser.

    This tool is 1 of 333 paid tools in English. All 333 with one key: Freelancer & Small Business Pass — $9.99/month · $79/year · Deadline reminders by email (free)

    Email me this result
    A copy of what you see above, in your inbox — the tool stays free, nothing here is locked.

    More tools for the same work

    bookkeeping spreadsheet for UK sole traders 2026/27: ledger, SA103S boxes, 55p mileage and the tax to set asideSelf Assessment 2025-26 Calculator + Monthly 2026-27 Tax Tracker (UK)Your 31 January 2027 bill in one figure, every amount next to its HMRC boxFree versionbookkeeping spreadsheet for UK sole traders 2026/27: ledger, SA103S boxes, 55p mileage and the tax to set asidesmall business plannerTrips and receipts to Schedule C 2026 lines, each trip at its own IRS rateFree versionbookkeeping spreadsheet for UK sole traders 2026/27: ledger, SA103S boxes, 55p mileage and the tax to set asideday rate calculatorday rate calculator: your rate after 2027 tax on your real billable daysFree versionbookkeeping spreadsheet for UK sole traders 2026/27: ledger, SA103S boxes, 55p mileage and the tax to set asideEtsy bookkeeping spreadsheet 2027Etsy bookkeeping spreadsheet: every Etsy fee by country, true profit, Schedule CFree version
    People like you also use
    Everything for Traders and investors → · ReadyStack Pass — every tool in one subscription · All tools →

    Questions and answers

    What does this page do?

    Bookkeeping spreadsheet for UK self-employed sole traders: log income, costs and business miles, see your SA103S boxes, profit, Income Tax + Class 4 to set aside and the cash due on 31 January, at 2026/27 rates incl.

    Is it free?

    Yes. The free version on this page works without an account. The full version ($39 per year) adds: saved ledger for both tax years, bank CSV import sorted into the SA103S boxes, a 4-sheet Excel file, a printable year summary and a calendar of your HMRC dates.

    How do I use it?

    1. Put your own numbers into the free version below — no sign-up. 2. Your result shows up right here, as you type. 3. Want to keep it, print it or do it again next time? That is what the full version adds — see "What you get".

    Ask about this tool

    One question, answered by the person who built it. Your email only if you want the answer sent.

    Privacy: your e-mail is used only to send you the answer. A question appears on this page only after it is answered, without your e-mail.

    For a team or company: for an invoice with your company details, a quote or several licences, write to support@getreadystack.com.

    Who is behind this page

    ReadyStack is a small team. We build each tool for one job people keep asking about, from the rules and sources named on the page, and we run it on the worked example you see here before it goes live.

    How we check our pages: each rule names its source and the day we read it.

    Something looks wrong, or you are stuck? Write to support@getreadystack.com or use the contact form. It goes to our own inbox, not to a bot.

    About ReadyStack

    Your next step

    More in Freelancers & 1099 See all →