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

Try it freeFull version · $39 per year →

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.

How it works
  1. Enter your details in the free version below.
  2. See your result right away on this page.
  3. Need more? The full version adds what is listed under "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.

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.

    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. Enter your details in the free version below. 2. See your result right away on this page. 3. Need more? The full version adds what is listed under "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 [email protected].

    Your next step

    More in Freelancers & 1099 See all →